Personal finance template
Debt Payoff Planner Template
List each debt and its payment. See monthly interest and roughly how long until each is paid off.
Opening a template uses no credits.
What's inside
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Debt | Balance | Annual rate | Payment | Monthly interest | Months to pay off |
| 2 | Credit card | 30,000 | 0.18 | 2,000 | =B2*C2/12 | =NPER(C2/12,-D2,B2) |
| 3 | Car loan | 120,000 | 0.06 | 3,500 | =B3*C3/12 | =NPER(C3/12,-D3,B3) |
| 4 | Total | =SUM(B2:B3) | =SUM(D2:D3) | =SUM(E2:E3) |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
E2 =B2*C2/12
Interest added this month.
F2 =NPER(C2/12,-D2,B2)
NPER counts the payments needed to clear the balance.
Make it yours by asking
Try a request like this in Tabstra:
"Create a debt payoff planner with debts, balance, annual interest rate, monthly payment, monthly interest and months to pay off"