Personal Loan Amortization Schedule
Free Apple Template; instant download link via email.
- Fully editable
- Instant delivery
- Works on Mac, iPad, iPhone
Preview
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)
How to use
- Download the file using the button above.
- Open it in Apple Numbers.
- Edit fonts, colors, and layout as needed.
- Print or export to PDF.
- Click to rate this package![Total: 73 Average: 2.9]
- Apple Numbers Template, Loan Templates [Mac Pages / Numbers], Schedule Templates [Mac Pages / Numbers]
- Version
- File Size 234.48 KB
- Downloads 22918
iWorkCommunity
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?
Shouldn’t the reference cell for each month’s interest be whatever the current outstanding principal balance is? It appears each interest calculation is referencing the original loan amount regardless of whether extra payments were made. That seems wrong.
I THINK (not an expert) the solution is to change the reference from “$B$9” to Column:J, Row:Previous Month’s Balance. Then copy and paste that formula for each cell in Column J by dragging the corner of the cell down the rest of the column.
Can someone check my work here?
Wow, I’m attempting to clean up some of these errors. This template was submitted years before I took over management. I think I have it fixed now. there was an issue with how it was calculating interest payments especially after an extra payment was made. I hope this helps!