01 · START WITH THE SAME NEED
Compare the same cash amount.
A loan balance that includes fees is different from cash available to spend. Keep upfront and financed charges separate so each scenario has a clear starting point.
02 · KEEP TIME IN VIEW
Read the payment and the period.
A smaller regular payment can come with a longer repayment period. Look at total repayment and interest as well as the amount due each month.
03 · CHECK THE AGREEMENT
Bring the written conditions.
Security, changing rates, early-repayment terms and other obligations can matter beyond the arithmetic. Confirm what an actual provider’s agreement says.
Chosen numbers. Clearer possibilities.
Two loan scenarios, side by side
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
Keep the whole cost beside the payment.
Watch the numbers move
CAD · illustrated- A · remaining balance
- $10,600.77
- B · remaining balance
- $12,565.92
Move the slider with the arrow keys, or use Home and End. The schedule below contains every exact illustrated row.
- Both scenarios receive the same cash advance. Entered financed fees increase the principal; entered upfront fees are paid outside the loan.
- Total cash paid includes the entered fees and modelled interest. The entered annual interest rates are not fee-inclusive APRs.
- A lower monthly payment can reflect a longer repayment period and a larger total cost. These chosen scenarios do not rank lenders or offers.
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 |
|---|---|---|
| Cash advance in both scenarios | 15000 | CAD |
| A · annual interest rate | 8 | % / year |
| A · repayment period | 36 | months |
| A · financed fees | 300 | CAD |
| A · upfront fees | 0 | CAD |
| B · annual interest rate | 10 | % / year |
| B · repayment period | 60 | months |
| B · financed fees | 0 | CAD |
| B · upfront fees | 100 | CAD |
| Month | A · repayment CAD | A · interest CAD | A · principal paid CAD | A · balance CAD | A · cash paid incl. upfront CAD | B · repayment CAD | B · interest CAD | B · principal paid CAD | B · balance CAD | B · cash paid incl. upfront CAD |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | $0.00 | $0.00 | $0.00 | $15,300.00 | $0.00 | $0.00 | $0.00 | $0.00 | $15,000.00 | $100.00 |
| 1 | $479.45 | $102.00 | $377.45 | $14,922.55 | $479.45 | $318.71 | $125.00 | $193.71 | $14,806.29 | $418.71 |
| 2 | $479.45 | $99.48 | $379.97 | $14,542.58 | $958.90 | $318.71 | $123.39 | $195.32 | $14,610.97 | $737.42 |
| 3 | $479.45 | $96.95 | $382.50 | $14,160.08 | $1,438.35 | $318.71 | $121.76 | $196.95 | $14,414.02 | $1,056.13 |
| 4 | $479.45 | $94.40 | $385.05 | $13,775.03 | $1,917.80 | $318.71 | $120.12 | $198.59 | $14,215.43 | $1,374.84 |
| 5 | $479.45 | $91.83 | $387.62 | $13,387.41 | $2,397.25 | $318.71 | $118.46 | $200.25 | $14,015.18 | $1,693.55 |
| 6 | $479.45 | $89.25 | $390.20 | $12,997.21 | $2,876.70 | $318.71 | $116.79 | $201.92 | $13,813.26 | $2,012.26 |
| 7 | $479.45 | $86.65 | $392.80 | $12,604.41 | $3,356.15 | $318.71 | $115.11 | $203.60 | $13,609.66 | $2,330.97 |
| 8 | $479.45 | $84.03 | $395.42 | $12,208.99 | $3,835.60 | $318.71 | $113.41 | $205.30 | $13,404.36 | $2,649.68 |
| 9 | $479.45 | $81.39 | $398.06 | $11,810.93 | $4,315.05 | $318.71 | $111.70 | $207.01 | $13,197.35 | $2,968.39 |
| 10 | $479.45 | $78.74 | $400.71 | $11,410.22 | $4,794.50 | $318.71 | $109.98 | $208.73 | $12,988.62 | $3,287.10 |
| 11 | $479.45 | $76.07 | $403.38 | $11,006.84 | $5,273.95 | $318.71 | $108.24 | $210.47 | $12,778.15 | $3,605.81 |
| 12 | $479.45 | $73.38 | $406.07 | $10,600.77 | $5,753.40 | $318.71 | $106.48 | $212.23 | $12,565.92 | $3,924.52 |
| 13 | $479.45 | $70.67 | $408.78 | $10,191.99 | $6,232.85 | $318.71 | $104.72 | $213.99 | $12,351.93 | $4,243.23 |
| 14 | $479.45 | $67.95 | $411.50 | $9,780.49 | $6,712.30 | $318.71 | $102.93 | $215.78 | $12,136.15 | $4,561.94 |
| 15 | $479.45 | $65.20 | $414.25 | $9,366.24 | $7,191.75 | $318.71 | $101.13 | $217.58 | $11,918.57 | $4,880.65 |
| 16 | $479.45 | $62.44 | $417.01 | $8,949.23 | $7,671.20 | $318.71 | $99.32 | $219.39 | $11,699.18 | $5,199.36 |
| 17 | $479.45 | $59.66 | $419.79 | $8,529.44 | $8,150.65 | $318.71 | $97.49 | $221.22 | $11,477.96 | $5,518.07 |
| 18 | $479.45 | $56.86 | $422.59 | $8,106.85 | $8,630.10 | $318.71 | $95.65 | $223.06 | $11,254.90 | $5,836.78 |
| 19 | $479.45 | $54.05 | $425.40 | $7,681.45 | $9,109.55 | $318.71 | $93.79 | $224.92 | $11,029.98 | $6,155.49 |
| 20 | $479.45 | $51.21 | $428.24 | $7,253.21 | $9,589.00 | $318.71 | $91.92 | $226.79 | $10,803.19 | $6,474.20 |
| 21 | $479.45 | $48.35 | $431.10 | $6,822.11 | $10,068.45 | $318.71 | $90.03 | $228.68 | $10,574.51 | $6,792.91 |
| 22 | $479.45 | $45.48 | $433.97 | $6,388.14 | $10,547.90 | $318.71 | $88.12 | $230.59 | $10,343.92 | $7,111.62 |
| 23 | $479.45 | $42.59 | $436.86 | $5,951.28 | $11,027.35 | $318.71 | $86.20 | $232.51 | $10,111.41 | $7,430.33 |
| 24 | $479.45 | $39.68 | $439.77 | $5,511.51 | $11,506.80 | $318.71 | $84.26 | $234.45 | $9,876.96 | $7,749.04 |
| 25 | $479.45 | $36.74 | $442.71 | $5,068.80 | $11,986.25 | $318.71 | $82.31 | $236.40 | $9,640.56 | $8,067.75 |
| 26 | $479.45 | $33.79 | $445.66 | $4,623.14 | $12,465.70 | $318.71 | $80.34 | $238.37 | $9,402.19 | $8,386.46 |
| 27 | $479.45 | $30.82 | $448.63 | $4,174.51 | $12,945.15 | $318.71 | $78.35 | $240.36 | $9,161.83 | $8,705.17 |
| 28 | $479.45 | $27.83 | $451.62 | $3,722.89 | $13,424.60 | $318.71 | $76.35 | $242.36 | $8,919.47 | $9,023.88 |
| 29 | $479.45 | $24.82 | $454.63 | $3,268.26 | $13,904.05 | $318.71 | $74.33 | $244.38 | $8,675.09 | $9,342.59 |
| 30 | $479.45 | $21.79 | $457.66 | $2,810.60 | $14,383.50 | $318.71 | $72.29 | $246.42 | $8,428.67 | $9,661.30 |
| 31 | $479.45 | $18.74 | $460.71 | $2,349.89 | $14,862.95 | $318.71 | $70.24 | $248.47 | $8,180.20 | $9,980.01 |
| 32 | $479.45 | $15.67 | $463.78 | $1,886.11 | $15,342.40 | $318.71 | $68.17 | $250.54 | $7,929.66 | $10,298.72 |
| 33 | $479.45 | $12.57 | $466.88 | $1,419.23 | $15,821.85 | $318.71 | $66.08 | $252.63 | $7,677.03 | $10,617.43 |
| 34 | $479.45 | $9.46 | $469.99 | $949.24 | $16,301.30 | $318.71 | $63.98 | $254.73 | $7,422.30 | $10,936.14 |
| 35 | $479.45 | $6.33 | $473.12 | $476.12 | $16,780.75 | $318.71 | $61.85 | $256.86 | $7,165.44 | $11,254.85 |
| 36 | $479.29 | $3.17 | $476.12 | $0.00 | $17,260.04 | $318.71 | $59.71 | $259.00 | $6,906.44 | $11,573.56 |
| 37 | $0.00 | $0.00 | $0.00 | $0.00 | $17,260.04 | $318.71 | $57.55 | $261.16 | $6,645.28 | $11,892.27 |
| 38 | $0.00 | $0.00 | $0.00 | $0.00 | $17,260.04 | $318.71 | $55.38 | $263.33 | $6,381.95 | $12,210.98 |
| 39 | $0.00 | $0.00 | $0.00 | $0.00 | $17,260.04 | $318.71 | $53.18 | $265.53 | $6,116.42 | $12,529.69 |
| 40 | $0.00 | $0.00 | $0.00 | $0.00 | $17,260.04 | $318.71 | $50.97 | $267.74 | $5,848.68 | $12,848.40 |
| 41 | $0.00 | $0.00 | $0.00 | $0.00 | $17,260.04 | $318.71 | $48.74 | $269.97 | $5,578.71 | $13,167.11 |
| 42 | $0.00 | $0.00 | $0.00 | $0.00 | $17,260.04 | $318.71 | $46.49 | $272.22 | $5,306.49 | $13,485.82 |
| 43 | $0.00 | $0.00 | $0.00 | $0.00 | $17,260.04 | $318.71 | $44.22 | $274.49 | $5,032.00 | $13,804.53 |
| 44 | $0.00 | $0.00 | $0.00 | $0.00 | $17,260.04 | $318.71 | $41.93 | $276.78 | $4,755.22 | $14,123.24 |
| 45 | $0.00 | $0.00 | $0.00 | $0.00 | $17,260.04 | $318.71 | $39.63 | $279.08 | $4,476.14 | $14,441.95 |
| 46 | $0.00 | $0.00 | $0.00 | $0.00 | $17,260.04 | $318.71 | $37.30 | $281.41 | $4,194.73 | $14,760.66 |
| 47 | $0.00 | $0.00 | $0.00 | $0.00 | $17,260.04 | $318.71 | $34.96 | $283.75 | $3,910.98 | $15,079.37 |
| 48 | $0.00 | $0.00 | $0.00 | $0.00 | $17,260.04 | $318.71 | $32.59 | $286.12 | $3,624.86 | $15,398.08 |
| 49 | $0.00 | $0.00 | $0.00 | $0.00 | $17,260.04 | $318.71 | $30.21 | $288.50 | $3,336.36 | $15,716.79 |
| 50 | $0.00 | $0.00 | $0.00 | $0.00 | $17,260.04 | $318.71 | $27.80 | $290.91 | $3,045.45 | $16,035.50 |
| 51 | $0.00 | $0.00 | $0.00 | $0.00 | $17,260.04 | $318.71 | $25.38 | $293.33 | $2,752.12 | $16,354.21 |
| 52 | $0.00 | $0.00 | $0.00 | $0.00 | $17,260.04 | $318.71 | $22.93 | $295.78 | $2,456.34 | $16,672.92 |
| 53 | $0.00 | $0.00 | $0.00 | $0.00 | $17,260.04 | $318.71 | $20.47 | $298.24 | $2,158.10 | $16,991.63 |
| 54 | $0.00 | $0.00 | $0.00 | $0.00 | $17,260.04 | $318.71 | $17.98 | $300.73 | $1,857.37 | $17,310.34 |
| 55 | $0.00 | $0.00 | $0.00 | $0.00 | $17,260.04 | $318.71 | $15.48 | $303.23 | $1,554.14 | $17,629.05 |
| 56 | $0.00 | $0.00 | $0.00 | $0.00 | $17,260.04 | $318.71 | $12.95 | $305.76 | $1,248.38 | $17,947.76 |
| 57 | $0.00 | $0.00 | $0.00 | $0.00 | $17,260.04 | $318.71 | $10.40 | $308.31 | $940.07 | $18,266.47 |
| 58 | $0.00 | $0.00 | $0.00 | $0.00 | $17,260.04 | $318.71 | $7.83 | $310.88 | $629.19 | $18,585.18 |
| 59 | $0.00 | $0.00 | $0.00 | $0.00 | $17,260.04 | $318.71 | $5.24 | $313.47 | $315.72 | $18,903.89 |
| 60 | $0.00 | $0.00 | $0.00 | $0.00 | $17,260.04 | $318.35 | $2.63 | $315.72 | $0.00 | $19,222.24 |
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.
- Each scenario receives the same chosen cash advance. Financed fees increase its opening principal; upfront fees are paid at the start. Total cash paid includes repayments and upfront fees.
- Borrowing cost above the common cash advance = total cash paid − cash advance. It includes the entered fees and modelled interest. The difference is A minus B, not a lender ranking.
- The entered annual rate is nominal interest, not a fee-inclusive regulatory APR. No insurance, extra fees or prepayment penalties are inferred.
Go a little deeper
This compares entered assumptions.
It does not rank lenders, quote available products or decide eligibility. The annual interest rate you enter is not automatically a fee-inclusive APR. Applicable costs and the actual disclosure method need their own review.
