Personal finance template
Loan Repayment Calculator Template (Amortization)
Calculate your monthly payment and see how much of each payment goes to interest and principal over the whole loan.
Starts with 25 free credits. No card needed.
What's inside
| Row | A | B |
|---|---|---|
| 1 | Input | Value |
| 2 | Loan amount | 300,000 |
| 3 | Annual rate | 5% |
| 4 | Years | 10 |
| 5 | Monthly payment | =PMT(B3/12,B4*12,-B2) |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
B5 =PMT(B3/12,B4*12,-B2)
Monthly payment for a fixed-rate loan.
C9 =B9*$B$3/12
Interest part of a payment in the schedule.
Make it yours by asking
Try a request like this in Tabstra:
"Build a loan calculator with loan amount, annual interest rate and term in years, monthly payment and a full amortization schedule"