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 | 10948 |
| File Size | 123 KB |
| Download | version 1 |
Similar Templates
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.