Excel Magic Trick 510: Amortization Table That Changes When Year Input Is Changed
Loading...
Loading...
3,181
Loading...
Link to this comment:
Share to:
Uploader Comments (ExcelIsFun)
see all
All Comments (8)
-
cool
thank you
-
so each time i make an extra payment that month my number of years i have taken the loan out for reduces (because of the extra payments) and also my interest i would have paid over the 30 years also reduces.
How can i set up a formula so that i can track each time i make an extra payment, i want to be able to see exactly how much my total interest would be and exactly when my loan will finish.
-
Hi
Exellent tutorial.
How can i have a formula within this table to calculate additional payments
e.g
I have borrowed 100,000 over 30 years interest 5.9%
I occasionally make extra payments every month (not fixed payment, basically make a payment of however much i can afford that month).
-
Thank you
Loading...
- 12:01
Excel Magic Trick 509: VLOOKUP with Dynamic Table using Table Nomenclatureby ExcelIsFun7,554 views
- 9:17
Excel Magic Trick 515: Amortization Table Pay Off Early & Trouble Shoot Formula Creationby ExcelIsFun5,722 views
- 5:45
Excel Magic Trick 511: Extract First, Middle, Last Names From Bad Data With Extra Charactersby ExcelIsFun3,043 views
- 14:06
Excel Magic Trick 407: Amortization Table W Variable Rateby ExcelIsFun7,667 views
- 8:28
Excel 2007-2010 Amortization Tables (Loan Amounts You Pay Each Month).movby ejmagidson2,934 views
- 10:58
Excel Magic Trick 549: Dynamic Data Validation List Drop-Down OFFSET or Table Feature?by ExcelIsFun23,798 views
- 3:55
Amortization Tablesby AuditExcel2,848 views
- 8:55
Excel Magic Trick 526: Grading Pass / Fail or Letter Grade Formula IF, AND, VLOOKUP functionsby ExcelIsFun11,036 views
- 4:52
Excel Magic Trick 533: Date/Time Calculation excluding Holidays & Weekendsby ExcelIsFun6,361 views
- 8:12
Excel Magic Trick 531: Extract Numbers from Middle of Text String BB34G to 34 (2 methods)by ExcelIsFun5,852 views
- 7:54
Amortization Schedule - Interest Paid, Principal Paid, Balance Dueby REALPROforWindows4,257 views
- 3:15
Excel Magic Trick 530: Does Text String Contain Repair OR Rework? OR SEARCH ISNUMBER functionsby ExcelIsFun1,976 views
- 2:15
Excel Magic Trick 525: Advanced Filter With Wild Cardsby ExcelIsFun4,376 views
- 5:01
Excel Magic Trick 547: Calculating Last Time File Was Accessed From Server Computerby ExcelIsFun1,289 views
- 7:11
Excel Magic Trick 548: Data Validation Drop-Down List In A Cell Same Sheet or Different Sheetby ExcelIsFun34,115 views
- 10:29
Excel Magic Trick 532: Count Blanks In Dynamic Range INDEX MATCH COUNTBLANK functionsby ExcelIsFun3,587 views
- 2:31
Excel Magic Trick 560: Conditional Formatting Select OK, Column Numbers Get Font Whiteby ExcelIsFun2,787 views
- 13:18
Excel Magic Trick 559: Extract Nth Word In Text Stringby ExcelIsFun3,892 views
- 1:40
Excel Magic Trick 523: Fill In Blanks With Custom Number Formatted Numberby ExcelIsFun1,582 views
- 10:39
Excel Finance Trick #8: Complete Loan Analysisby ExcelIsFun10,862 views
So basically i want to be able to say to myself, if you make an additional payment of £100 a month, you will finish your loan of in say 20 years rather than 30 years and also your loan interest will also reduce. I dont want it to be fixed at £100 pm because sometimes i make a an extra payment and sometimes less
Thank you
emailuznow 2 years ago
I got your e-mail and comments. I'll make a video in a few days...
ExcelIsFun 2 years ago
Fantastic video
Mike, can i use the formula you have provided in Excel Magic Trick 407: Amortization Table W Variable Rate to make it a variable Interest table?
emailuznow 2 years ago
Yes, but you have to be careful what the loan contract says becasue in 407, the PMT updates as soon as the principal or rate changes which is usually not the case in the contact.
ExcelIsFun 2 years ago