Personal finance template
Loan Comparison Template
Compare offers from different lenders. Monthly payment, total paid and total interest are calculated for each.
Opening a template uses no credits.
What's inside
| Row | A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| 1 | Lender | Amount | Rate | Years | Monthly | Total paid | Interest |
| 2 | Bank A | 250,000 | 0.049 | 5 | =PMT(C2/12,D2*12,-B2) | =E2*D2*12 | =F2-B2 |
| 3 | Bank B | 250,000 | 0.059 | 7 | =PMT(C3/12,D3*12,-B3) | =E3*D3*12 | =F3-B3 |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
E2 =PMT(C2/12,D2*12,-B2)
Monthly payment with PMT.
G2 =F2-B2
Everything paid minus the loan amount.
Make it yours by asking
Try a request like this in Tabstra:
"Create a loan comparison with lender, amount, rate, years, monthly payment, total paid and total interest"