Chosen numbers. Clearer possibilities.
Your auto-loan worksheet
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
See what is financed, and what is paid.
Financed principal$23,850.00
Monthly payment$461.09
Modelled interest$3,815.22
Chosen tax$1,350.00
Total cash paid$32,665.22
Applied trade value$3,000.00
Watch the numbers move
CAD · illustrated- Financed balance
- $19,633.21
- Cumulative repayments
- $5,533.08
Move the slider with the arrow keys, or use Home and End. The schedule below contains every exact illustrated row.
- Tax is applied only to your entered taxable amount; no province, rebate or trade-in tax rule is inferred.
- Total cash paid includes cash down, upfront fees and repayments. Applied trade value is shown separately and is not cash paid.
- The rate is a chosen illustration. Ownership costs and unentered fees are excluded.
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 |
|---|---|---|
| Vehicle price | 30000 | CAD |
| Cash down payment | 5000 | CAD |
| Trade-in value applied | 3000 | CAD |
| Chosen taxable amount | 27000 | CAD |
| Chosen tax percentage | 5 | % of chosen taxable amount |
| Fees added to the loan | 500 | CAD |
| Fees paid separately upfront | 0 | CAD |
| Chosen annual interest rate | 6 | % / year |
| Repayment period | 60 | months |
| Month | Opening balance CAD | Interest CAD | Payment CAD | Principal paid CAD | Closing balance CAD | Cumulative repayments CAD |
|---|---|---|---|---|---|---|
| 0 | $23,850.00 | $0.00 | $0.00 | $0.00 | $23,850.00 | $0.00 |
| 1 | $23,850.00 | $119.25 | $461.09 | $341.84 | $23,508.16 | $461.09 |
| 2 | $23,508.16 | $117.54 | $461.09 | $343.55 | $23,164.61 | $922.18 |
| 3 | $23,164.61 | $115.82 | $461.09 | $345.27 | $22,819.34 | $1,383.27 |
| 4 | $22,819.34 | $114.10 | $461.09 | $346.99 | $22,472.35 | $1,844.36 |
| 5 | $22,472.35 | $112.36 | $461.09 | $348.73 | $22,123.62 | $2,305.45 |
| 6 | $22,123.62 | $110.62 | $461.09 | $350.47 | $21,773.15 | $2,766.54 |
| 7 | $21,773.15 | $108.87 | $461.09 | $352.22 | $21,420.93 | $3,227.63 |
| 8 | $21,420.93 | $107.10 | $461.09 | $353.99 | $21,066.94 | $3,688.72 |
| 9 | $21,066.94 | $105.33 | $461.09 | $355.76 | $20,711.18 | $4,149.81 |
| 10 | $20,711.18 | $103.56 | $461.09 | $357.53 | $20,353.65 | $4,610.90 |
| 11 | $20,353.65 | $101.77 | $461.09 | $359.32 | $19,994.33 | $5,071.99 |
| 12 | $19,994.33 | $99.97 | $461.09 | $361.12 | $19,633.21 | $5,533.08 |
| 13 | $19,633.21 | $98.17 | $461.09 | $362.92 | $19,270.29 | $5,994.17 |
| 14 | $19,270.29 | $96.35 | $461.09 | $364.74 | $18,905.55 | $6,455.26 |
| 15 | $18,905.55 | $94.53 | $461.09 | $366.56 | $18,538.99 | $6,916.35 |
| 16 | $18,538.99 | $92.69 | $461.09 | $368.40 | $18,170.59 | $7,377.44 |
| 17 | $18,170.59 | $90.85 | $461.09 | $370.24 | $17,800.35 | $7,838.53 |
| 18 | $17,800.35 | $89.00 | $461.09 | $372.09 | $17,428.26 | $8,299.62 |
| 19 | $17,428.26 | $87.14 | $461.09 | $373.95 | $17,054.31 | $8,760.71 |
| 20 | $17,054.31 | $85.27 | $461.09 | $375.82 | $16,678.49 | $9,221.80 |
| 21 | $16,678.49 | $83.39 | $461.09 | $377.70 | $16,300.79 | $9,682.89 |
| 22 | $16,300.79 | $81.50 | $461.09 | $379.59 | $15,921.20 | $10,143.98 |
| 23 | $15,921.20 | $79.61 | $461.09 | $381.48 | $15,539.72 | $10,605.07 |
| 24 | $15,539.72 | $77.70 | $461.09 | $383.39 | $15,156.33 | $11,066.16 |
| 25 | $15,156.33 | $75.78 | $461.09 | $385.31 | $14,771.02 | $11,527.25 |
| 26 | $14,771.02 | $73.86 | $461.09 | $387.23 | $14,383.79 | $11,988.34 |
| 27 | $14,383.79 | $71.92 | $461.09 | $389.17 | $13,994.62 | $12,449.43 |
| 28 | $13,994.62 | $69.97 | $461.09 | $391.12 | $13,603.50 | $12,910.52 |
| 29 | $13,603.50 | $68.02 | $461.09 | $393.07 | $13,210.43 | $13,371.61 |
| 30 | $13,210.43 | $66.05 | $461.09 | $395.04 | $12,815.39 | $13,832.70 |
| 31 | $12,815.39 | $64.08 | $461.09 | $397.01 | $12,418.38 | $14,293.79 |
| 32 | $12,418.38 | $62.09 | $461.09 | $399.00 | $12,019.38 | $14,754.88 |
| 33 | $12,019.38 | $60.10 | $461.09 | $400.99 | $11,618.39 | $15,215.97 |
| 34 | $11,618.39 | $58.09 | $461.09 | $403.00 | $11,215.39 | $15,677.06 |
| 35 | $11,215.39 | $56.08 | $461.09 | $405.01 | $10,810.38 | $16,138.15 |
| 36 | $10,810.38 | $54.05 | $461.09 | $407.04 | $10,403.34 | $16,599.24 |
| 37 | $10,403.34 | $52.02 | $461.09 | $409.07 | $9,994.27 | $17,060.33 |
| 38 | $9,994.27 | $49.97 | $461.09 | $411.12 | $9,583.15 | $17,521.42 |
| 39 | $9,583.15 | $47.92 | $461.09 | $413.17 | $9,169.98 | $17,982.51 |
| 40 | $9,169.98 | $45.85 | $461.09 | $415.24 | $8,754.74 | $18,443.60 |
| 41 | $8,754.74 | $43.77 | $461.09 | $417.32 | $8,337.42 | $18,904.69 |
| 42 | $8,337.42 | $41.69 | $461.09 | $419.40 | $7,918.02 | $19,365.78 |
| 43 | $7,918.02 | $39.59 | $461.09 | $421.50 | $7,496.52 | $19,826.87 |
| 44 | $7,496.52 | $37.48 | $461.09 | $423.61 | $7,072.91 | $20,287.96 |
| 45 | $7,072.91 | $35.36 | $461.09 | $425.73 | $6,647.18 | $20,749.05 |
| 46 | $6,647.18 | $33.24 | $461.09 | $427.85 | $6,219.33 | $21,210.14 |
| 47 | $6,219.33 | $31.10 | $461.09 | $429.99 | $5,789.34 | $21,671.23 |
| 48 | $5,789.34 | $28.95 | $461.09 | $432.14 | $5,357.20 | $22,132.32 |
| 49 | $5,357.20 | $26.79 | $461.09 | $434.30 | $4,922.90 | $22,593.41 |
| 50 | $4,922.90 | $24.61 | $461.09 | $436.48 | $4,486.42 | $23,054.50 |
| 51 | $4,486.42 | $22.43 | $461.09 | $438.66 | $4,047.76 | $23,515.59 |
| 52 | $4,047.76 | $20.24 | $461.09 | $440.85 | $3,606.91 | $23,976.68 |
| 53 | $3,606.91 | $18.03 | $461.09 | $443.06 | $3,163.85 | $24,437.77 |
| 54 | $3,163.85 | $15.82 | $461.09 | $445.27 | $2,718.58 | $24,898.86 |
| 55 | $2,718.58 | $13.59 | $461.09 | $447.50 | $2,271.08 | $25,359.95 |
| 56 | $2,271.08 | $11.36 | $461.09 | $449.73 | $1,821.35 | $25,821.04 |
| 57 | $1,821.35 | $9.11 | $461.09 | $451.98 | $1,369.37 | $26,282.13 |
| 58 | $1,369.37 | $6.85 | $461.09 | $454.24 | $915.13 | $26,743.22 |
| 59 | $915.13 | $4.58 | $461.09 | $456.51 | $458.62 | $27,204.31 |
| 60 | $458.62 | $2.29 | $460.91 | $458.62 | $0.00 | $27,665.22 |
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.
- Chosen tax = taxable amount × chosen tax percentage, rounded to cents. Financed principal = vehicle price + chosen tax + financed fees − cash down − applied trade value.
- Total cash paid = cash down + upfront fees + loan payments. The separately shown trade-in value is excluded from cash paid. Fuel, maintenance, insurance, registration and resale value are excluded.
