Chosen numbers. Clearer possibilities.
A clearer card payoff plan
Live examples in Canadian dollars. Change any assumption to make the illustration yours.
Your numbers
Use digits and a decimal point. Monetary inputs accept cents; repayment periods use whole months. These are examples, never lender offers.
Your illustration
A finish line under your chosen assumptions.
Payoff months33
Interest in shown schedule$1,521.01
Payments in shown schedule$6,521.01
Remaining balance$0.00
First-month interest$83.29
Watch the numbers move
CAD · illustrated- Card balance
- $3,463.78
- Cumulative payments
- $2,400.00
Move the slider with the arrow keys, or use Home and End. The schedule below contains every exact illustrated row.
- The last payment is capped at the amount owing.
- Chosen interest is applied to the opening balance, then chosen new charges are added, then the month-end payment is applied. All interest is rounded to cents.
- One-rate monthly illustration only. Actual minimum payments, daily calculations, grace periods, fees and payment allocation depend on the agreement. New charges stop when the starting balance has cleared.
Save is optional and stays in this browser until you remove it or clear browser data. Inputs are not sent by this worksheet. Sharing a summary with Mitey is a separate choice.
Your entered assumptions
| Assumption | Value | Unit |
|---|---|---|
| Starting card balance | 5000 | CAD |
| Chosen annual interest rate | 19.99 | % / year |
| Fixed monthly payment | 200 | CAD / month |
| New charges each month | 0 | CAD / month |
| Maximum months to show | 600 | months |
| Month | Opening balance CAD | Interest CAD | New charges CAD | Payment CAD | Balance reduction CAD | Closing balance CAD | Cumulative payments CAD |
|---|---|---|---|---|---|---|---|
| 0 | $5,000.00 | $0.00 | $0.00 | $0.00 | $0.00 | $5,000.00 | $0.00 |
| 1 | $5,000.00 | $83.29 | $0.00 | $200.00 | $116.71 | $4,883.29 | $200.00 |
| 2 | $4,883.29 | $81.35 | $0.00 | $200.00 | $118.65 | $4,764.64 | $400.00 |
| 3 | $4,764.64 | $79.37 | $0.00 | $200.00 | $120.63 | $4,644.01 | $600.00 |
| 4 | $4,644.01 | $77.36 | $0.00 | $200.00 | $122.64 | $4,521.37 | $800.00 |
| 5 | $4,521.37 | $75.32 | $0.00 | $200.00 | $124.68 | $4,396.69 | $1,000.00 |
| 6 | $4,396.69 | $73.24 | $0.00 | $200.00 | $126.76 | $4,269.93 | $1,200.00 |
| 7 | $4,269.93 | $71.13 | $0.00 | $200.00 | $128.87 | $4,141.06 | $1,400.00 |
| 8 | $4,141.06 | $68.98 | $0.00 | $200.00 | $131.02 | $4,010.04 | $1,600.00 |
| 9 | $4,010.04 | $66.80 | $0.00 | $200.00 | $133.20 | $3,876.84 | $1,800.00 |
| 10 | $3,876.84 | $64.58 | $0.00 | $200.00 | $135.42 | $3,741.42 | $2,000.00 |
| 11 | $3,741.42 | $62.33 | $0.00 | $200.00 | $137.67 | $3,603.75 | $2,200.00 |
| 12 | $3,603.75 | $60.03 | $0.00 | $200.00 | $139.97 | $3,463.78 | $2,400.00 |
| 13 | $3,463.78 | $57.70 | $0.00 | $200.00 | $142.30 | $3,321.48 | $2,600.00 |
| 14 | $3,321.48 | $55.33 | $0.00 | $200.00 | $144.67 | $3,176.81 | $2,800.00 |
| 15 | $3,176.81 | $52.92 | $0.00 | $200.00 | $147.08 | $3,029.73 | $3,000.00 |
| 16 | $3,029.73 | $50.47 | $0.00 | $200.00 | $149.53 | $2,880.20 | $3,200.00 |
| 17 | $2,880.20 | $47.98 | $0.00 | $200.00 | $152.02 | $2,728.18 | $3,400.00 |
| 18 | $2,728.18 | $45.45 | $0.00 | $200.00 | $154.55 | $2,573.63 | $3,600.00 |
| 19 | $2,573.63 | $42.87 | $0.00 | $200.00 | $157.13 | $2,416.50 | $3,800.00 |
| 20 | $2,416.50 | $40.25 | $0.00 | $200.00 | $159.75 | $2,256.75 | $4,000.00 |
| 21 | $2,256.75 | $37.59 | $0.00 | $200.00 | $162.41 | $2,094.34 | $4,200.00 |
| 22 | $2,094.34 | $34.89 | $0.00 | $200.00 | $165.11 | $1,929.23 | $4,400.00 |
| 23 | $1,929.23 | $32.14 | $0.00 | $200.00 | $167.86 | $1,761.37 | $4,600.00 |
| 24 | $1,761.37 | $29.34 | $0.00 | $200.00 | $170.66 | $1,590.71 | $4,800.00 |
| 25 | $1,590.71 | $26.50 | $0.00 | $200.00 | $173.50 | $1,417.21 | $5,000.00 |
| 26 | $1,417.21 | $23.61 | $0.00 | $200.00 | $176.39 | $1,240.82 | $5,200.00 |
| 27 | $1,240.82 | $20.67 | $0.00 | $200.00 | $179.33 | $1,061.49 | $5,400.00 |
| 28 | $1,061.49 | $17.68 | $0.00 | $200.00 | $182.32 | $879.17 | $5,600.00 |
| 29 | $879.17 | $14.65 | $0.00 | $200.00 | $185.35 | $693.82 | $5,800.00 |
| 30 | $693.82 | $11.56 | $0.00 | $200.00 | $188.44 | $505.38 | $6,000.00 |
| 31 | $505.38 | $8.42 | $0.00 | $200.00 | $191.58 | $313.80 | $6,200.00 |
| 32 | $313.80 | $5.23 | $0.00 | $200.00 | $194.77 | $119.03 | $6,400.00 |
| 33 | $119.03 | $1.98 | $0.00 | $121.01 | $119.03 | $0.00 | $6,521.01 |
The method, in plain language
- All figures are chosen CAD assumptions, not an account statement or credit decision.
- Each modelled month: round opening balance × annual nominal rate / 12 to cents, add chosen new charges, then apply the smaller of the chosen payment or amount owing. The final payment is capped at the balance.
- If the first payment does not reduce the opening balance, the model reports that state rather than a payoff date. If a positive balance remains at the chosen horizon, the result is beyond the horizon, not paid off.
- A zero starting balance needs no payoff schedule; future purchases are not forecast after the starting balance has cleared.
- This one-rate monthly model excludes actual transaction dates, grace periods, different purchase/cash-advance rates, fees, promotional expiries, issuer allocation rules and minimum-payment rules. Check the agreement and statement.
