A little perspective. A lot of possibility.
Clarity for your next move.
Model loans, leverage, and reverse mortgages — with rates that change mid-term, like real life.
Build your scenario
$
$
%
Canadian fixed rates compound semi-annually by law; variable rates compound monthly.
%
eff.0.00%
Length of your current rate contract; you renew at term end. Amortization is the full payoff horizon.
$
Lender cash at closing. Shown in the scenario title and netted against interest in the Payment card "i".
Rate changes
Available for variable rates only. Saved changes are retained.
Enter increases or decreases in percentage points. Each adjustment applies to the previous rate, in chronological order.
The payment holds at its original amount. If the rate climbs high enough that the payment no longer covers interest, it rises to cover interest only, then falls back once the rate drops. Only matters once a rate change is added.
Balance & cost over time
Balance owed
Principal paid to date
Interest paid to date
Total paid to date
Payment breakdown: principal vs interest
Principal portion
Interest portion
Show yearly schedule
Build your scenario
The loan
$
%
yrs
The investment
%
Entered rate is nominal; effective annual growth depends on the compounding chosen.
Account allocation
Split the borrowed amount across account types. Only the non-registered share has deductible interest; RRSP contributions earn a tax refund; TFSA growth is tax-free. Boxes auto-balance to 100%.
Non-Reg
$
%
TFSA
$
%
RRSP
$
%
%
Applies to non-registered money only.
Monthly contribution
Money added from cash flow, not from the loan. It earns the same return but carries no interest and no deduction, and never changes the amount borrowed.
$
Tax
%
%
The rate you expect when withdrawing from an RRSP. A lower rate than today is what makes an RRSP pull ahead.
Market changes
Vary the borrowing rate and/or market return at points in the horizon.
Enter increases or decreases in percentage points. Each adjustment applies to the previous rate, in chronological order.
Calculates as you go
Investment side — grows, then gets taxed on the way out
Loan side — the cost of borrowing to invest, plus the result
Wealth vs. cost of leverage
Investment value
Cumulative after-tax interest
Net benefit
Build your scenario
Your home
$
%
The reverse mortgage
Fixed reverse rates compound semi-annually; variable rates compound monthly.
%
eff.0.00%
yrs
%
$
Deducted from the cash the client receives, and added to the loan. Roughly $1,000 to $3,000 depending on lender, plus appraisal and independent legal advice.
$
Borrowed against the home and paid straight to the existing lender at closing. Like closing costs, it is part of the loan but is not cash the client can take or invest.
$
Calculates as you go
Loan balance vs. home equity
Home value
Loan balance
Remaining equity
Build your scenario
The new mortgage
$
$
% LTV
$
% LTV
$
% LTV
$
% LTV
Canadian fixed rates compound semi-annually by law; variable rates compound monthly.
%
eff.0.00%
What the new mortgage is paid on.
$
Stretch the amortization
The same mortgage, stretched. It can never be shorter than the agreed amortization — what this tab weighs is what extending buys.
The investment
%
Growth is taxed as a capital gain when it is sold.
%
Applies to a non-registered account only.
Tax
%
%
Pay it down — every dollar of the budget goes at the mortgage
Refinance and invest — the same budget, split
Net position over time
Pay it down
Refinance and invest
Build your scenario
$
$
%
Canadian fixed rates compound semi-annually by law; variable rates compound monthly.
%
eff.0.00%
%
Length of your current rate contract; you renew at term end. Amortization is the full payoff horizon.
Qualifying income
$
$
Use lender-accepted income before tax. This worksheet is for an owner-occupied home without rental income.
Combined gross annual income
Property expenses
$
$
$
Other debts · TDS
$
$
$
$
$
$
Qualification assumptions
%
%
%
%
%
%
Defaults: 39% / 44%, 50% of condo fees and 3% of unsecured balances. Custom settings require lender confirmation. Ground rent is included in full.
Your debt ratios
Calculates as you goMaximum mortgage amounti
—
i
—