
Amortization schedule for personal loans with interest and missed payment calculations. This template includes calculations for extra payments to the principal and offers automatic calculations with entry of loan amount, simple interest rate, length of loan, and start date.
A running loan schedule that allows for extra payments and missed payments. All you need to know is Loan Amount, Simple Interest Rate, Length of loan in years, and loan start date. It shows a self adjusting Amortization schedule that adds interest to the principal if you miss a payment and subtracts from principal extra payments. Great for personal loans. Just stretch things down for a loan longer than 3 years. (Doesn’t do compound interest)
File Name | loan.zip |
---|---|
Downloads | 14330 |
File Size | 123 KB |
Download | Your download will start automatically. If it did not, please try reloading this page. |
how do I get the template?
Click link next to “download”
Thanks!
“Just stretch things down for a loan longer than 3 years”… Can someone please expound on this for me? I am tracking a 4 year payoff plan and do not understand how to stretch things down or find the formula so the rest of the spreadsheet will track on another 12 months of payments. Thank you.
Your math is wrong on this spread sheet, it does not compute the daily rate of interest correctly as extra payments are made.
I agree! this schedule is showing different calculations from my old one. How do I fix it?