Chosen numbers. Clearer possibilities.
Your borrowing budget
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
Give the payment some breathing room.
Monthly budget headroom$400.00
Chosen new payment$300.00
Remainder after chosen payment$100.00
Illustrative principal$14,795.53
Watch the numbers move
CAD · illustrated- Illustrative loan balance
- $12,288.56
- Cumulative budget remainder
- $1,200.00
Move the slider with the arrow keys, or use Home and End. The schedule below contains every exact illustrated row.
- Headroom is a worksheet remainder, not a recommended maximum payment.
- The chosen payment fits within these entered costs; unentered costs can change the picture.
- The principal is a present-value calculation at the entered rate and period. It does not predict what a lender would offer.
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 |
|---|---|---|
| Monthly take-home income | 4000 | CAD / month |
| Living and housing costs | 2100 | CAD / month |
| Existing debt payments | 500 | CAD / month |
| Planned savings | 400 | CAD / month |
| Other commitments | 200 | CAD / month |
| A little breathing room | 400 | CAD / month |
| Chosen new monthly payment | 300 | CAD / month |
| Chosen annual interest rate | 8 | % / year |
| Repayment period | 60 | months |
| Month | Monthly take-home CAD | Monthly commitments incl. reserve CAD | Scenario payment CAD | Scenario interest CAD | Scenario principal paid CAD | Scenario balance CAD | Cumulative budget remainder CAD |
|---|---|---|---|---|---|---|---|
| 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $14,795.53 | $0.00 |
| 1 | $4,000.00 | $3,600.00 | $300.00 | $98.64 | $201.36 | $14,594.17 | $100.00 |
| 2 | $4,000.00 | $3,600.00 | $300.00 | $97.29 | $202.71 | $14,391.46 | $200.00 |
| 3 | $4,000.00 | $3,600.00 | $300.00 | $95.94 | $204.06 | $14,187.40 | $300.00 |
| 4 | $4,000.00 | $3,600.00 | $300.00 | $94.58 | $205.42 | $13,981.98 | $400.00 |
| 5 | $4,000.00 | $3,600.00 | $300.00 | $93.21 | $206.79 | $13,775.19 | $500.00 |
| 6 | $4,000.00 | $3,600.00 | $300.00 | $91.83 | $208.17 | $13,567.02 | $600.00 |
| 7 | $4,000.00 | $3,600.00 | $300.00 | $90.45 | $209.55 | $13,357.47 | $700.00 |
| 8 | $4,000.00 | $3,600.00 | $300.00 | $89.05 | $210.95 | $13,146.52 | $800.00 |
| 9 | $4,000.00 | $3,600.00 | $300.00 | $87.64 | $212.36 | $12,934.16 | $900.00 |
| 10 | $4,000.00 | $3,600.00 | $300.00 | $86.23 | $213.77 | $12,720.39 | $1,000.00 |
| 11 | $4,000.00 | $3,600.00 | $300.00 | $84.80 | $215.20 | $12,505.19 | $1,100.00 |
| 12 | $4,000.00 | $3,600.00 | $300.00 | $83.37 | $216.63 | $12,288.56 | $1,200.00 |
| 13 | $4,000.00 | $3,600.00 | $300.00 | $81.92 | $218.08 | $12,070.48 | $1,300.00 |
| 14 | $4,000.00 | $3,600.00 | $300.00 | $80.47 | $219.53 | $11,850.95 | $1,400.00 |
| 15 | $4,000.00 | $3,600.00 | $300.00 | $79.01 | $220.99 | $11,629.96 | $1,500.00 |
| 16 | $4,000.00 | $3,600.00 | $300.00 | $77.53 | $222.47 | $11,407.49 | $1,600.00 |
| 17 | $4,000.00 | $3,600.00 | $300.00 | $76.05 | $223.95 | $11,183.54 | $1,700.00 |
| 18 | $4,000.00 | $3,600.00 | $300.00 | $74.56 | $225.44 | $10,958.10 | $1,800.00 |
| 19 | $4,000.00 | $3,600.00 | $300.00 | $73.05 | $226.95 | $10,731.15 | $1,900.00 |
| 20 | $4,000.00 | $3,600.00 | $300.00 | $71.54 | $228.46 | $10,502.69 | $2,000.00 |
| 21 | $4,000.00 | $3,600.00 | $300.00 | $70.02 | $229.98 | $10,272.71 | $2,100.00 |
| 22 | $4,000.00 | $3,600.00 | $300.00 | $68.48 | $231.52 | $10,041.19 | $2,200.00 |
| 23 | $4,000.00 | $3,600.00 | $300.00 | $66.94 | $233.06 | $9,808.13 | $2,300.00 |
| 24 | $4,000.00 | $3,600.00 | $300.00 | $65.39 | $234.61 | $9,573.52 | $2,400.00 |
| 25 | $4,000.00 | $3,600.00 | $300.00 | $63.82 | $236.18 | $9,337.34 | $2,500.00 |
| 26 | $4,000.00 | $3,600.00 | $300.00 | $62.25 | $237.75 | $9,099.59 | $2,600.00 |
| 27 | $4,000.00 | $3,600.00 | $300.00 | $60.66 | $239.34 | $8,860.25 | $2,700.00 |
| 28 | $4,000.00 | $3,600.00 | $300.00 | $59.07 | $240.93 | $8,619.32 | $2,800.00 |
| 29 | $4,000.00 | $3,600.00 | $300.00 | $57.46 | $242.54 | $8,376.78 | $2,900.00 |
| 30 | $4,000.00 | $3,600.00 | $300.00 | $55.85 | $244.15 | $8,132.63 | $3,000.00 |
| 31 | $4,000.00 | $3,600.00 | $300.00 | $54.22 | $245.78 | $7,886.85 | $3,100.00 |
| 32 | $4,000.00 | $3,600.00 | $300.00 | $52.58 | $247.42 | $7,639.43 | $3,200.00 |
| 33 | $4,000.00 | $3,600.00 | $300.00 | $50.93 | $249.07 | $7,390.36 | $3,300.00 |
| 34 | $4,000.00 | $3,600.00 | $300.00 | $49.27 | $250.73 | $7,139.63 | $3,400.00 |
| 35 | $4,000.00 | $3,600.00 | $300.00 | $47.60 | $252.40 | $6,887.23 | $3,500.00 |
| 36 | $4,000.00 | $3,600.00 | $300.00 | $45.91 | $254.09 | $6,633.14 | $3,600.00 |
| 37 | $4,000.00 | $3,600.00 | $300.00 | $44.22 | $255.78 | $6,377.36 | $3,700.00 |
| 38 | $4,000.00 | $3,600.00 | $300.00 | $42.52 | $257.48 | $6,119.88 | $3,800.00 |
| 39 | $4,000.00 | $3,600.00 | $300.00 | $40.80 | $259.20 | $5,860.68 | $3,900.00 |
| 40 | $4,000.00 | $3,600.00 | $300.00 | $39.07 | $260.93 | $5,599.75 | $4,000.00 |
| 41 | $4,000.00 | $3,600.00 | $300.00 | $37.33 | $262.67 | $5,337.08 | $4,100.00 |
| 42 | $4,000.00 | $3,600.00 | $300.00 | $35.58 | $264.42 | $5,072.66 | $4,200.00 |
| 43 | $4,000.00 | $3,600.00 | $300.00 | $33.82 | $266.18 | $4,806.48 | $4,300.00 |
| 44 | $4,000.00 | $3,600.00 | $300.00 | $32.04 | $267.96 | $4,538.52 | $4,400.00 |
| 45 | $4,000.00 | $3,600.00 | $300.00 | $30.26 | $269.74 | $4,268.78 | $4,500.00 |
| 46 | $4,000.00 | $3,600.00 | $300.00 | $28.46 | $271.54 | $3,997.24 | $4,600.00 |
| 47 | $4,000.00 | $3,600.00 | $300.00 | $26.65 | $273.35 | $3,723.89 | $4,700.00 |
| 48 | $4,000.00 | $3,600.00 | $300.00 | $24.83 | $275.17 | $3,448.72 | $4,800.00 |
| 49 | $4,000.00 | $3,600.00 | $300.00 | $22.99 | $277.01 | $3,171.71 | $4,900.00 |
| 50 | $4,000.00 | $3,600.00 | $300.00 | $21.14 | $278.86 | $2,892.85 | $5,000.00 |
| 51 | $4,000.00 | $3,600.00 | $300.00 | $19.29 | $280.71 | $2,612.14 | $5,100.00 |
| 52 | $4,000.00 | $3,600.00 | $300.00 | $17.41 | $282.59 | $2,329.55 | $5,200.00 |
| 53 | $4,000.00 | $3,600.00 | $300.00 | $15.53 | $284.47 | $2,045.08 | $5,300.00 |
| 54 | $4,000.00 | $3,600.00 | $300.00 | $13.63 | $286.37 | $1,758.71 | $5,400.00 |
| 55 | $4,000.00 | $3,600.00 | $300.00 | $11.72 | $288.28 | $1,470.43 | $5,500.00 |
| 56 | $4,000.00 | $3,600.00 | $300.00 | $9.80 | $290.20 | $1,180.23 | $5,600.00 |
| 57 | $4,000.00 | $3,600.00 | $300.00 | $7.87 | $292.13 | $888.10 | $5,700.00 |
| 58 | $4,000.00 | $3,600.00 | $300.00 | $5.92 | $294.08 | $594.02 | $5,800.00 |
| 59 | $4,000.00 | $3,600.00 | $300.00 | $3.96 | $296.04 | $297.98 | $5,900.00 |
| 60 | $4,000.00 | $3,600.00 | $299.97 | $1.99 | $297.98 | $0.00 | $6,000.03 |
The method, in plain language
- All figures are chosen CAD assumptions, not offers, approvals or a prediction of a credit limit.
- A nominal monthly-compounded annual rate is divided by 12. Payments occur at month end; no rate changes, skipped payments or unentered fees are assumed.
- Opening principal and each monthly interest charge are rounded to the nearest cent. The scheduled payment is rounded to cents, with a minimum of one cent for a positive loan; the final payment adjusts to clear the balance.
- The schedule is an illustration. Contracts can use different day counts, compounding, rounding, fees or prepayment rules.
- Budget headroom = take-home income − living costs − existing debt payments − planned savings − other commitments − reserve. A negative value is a shortfall.
- Illustrative principal is the present value of the chosen new payment at the chosen rate and number of months. It is not a lender limit. Budget assumptions repeat each month in the displayed schedule; a positive remainder is not an investment return.
