LAB 05 — Policy X-Ray
Upload the illustration PDF you were given — Equitable Life, Manulife, Sun Life, Canada Life, any Canadian carrier. Get the real IRR year by year, the GIC return you'd need to beat it at any age, and the tax-free retirement income its cash value can support. Your PDF is parsed inside your browser — nothing is uploaded, nothing leaves this page.
ON — Ontario rates used as the example; the mechanics apply Canada-wide (Quebec’s system differs in some details).
Step 01 — Load the illustration
// 100% local: the file is read by JavaScript in this tab. No upload. No server. No storage.
Step 02 — Verify every number
Automatic extraction is never trusted blind. Check the column assignment, fix any cell (click to edit), and compare the totals below against the illustration's own summary page. Analysis unlocks only after you confirm.
Step 03 — IRR & what an investment must earn to match it
The breakeven answers: “what pre-tax return must a GIC earn, every single year, for its after-tax value to match this policy's cash value at the age you picked?” It moves with the comparison age — matching at 60 and matching at 85 are different questions — which is why the chart below shows the whole curve. GIC interest is taxed annually at your full marginal rate; corporate passive interest in ON is ≈50.2%. Illustrated values use the carrier's current dividend scale and are not guaranteed. Educational estimate, not advice.
Step 04 — Retirement income by collateral bank loan, vs taxable withdrawals
This models a collateral loan from a third-party bank, secured by the policy — not a policy loan from the insurer. The difference matters for tax: under current rules a bank collateral loan is not income, while a policy loan can become taxable once advances exceed the policy's adjusted cost basis (ACB). Bank terms (rate, lending limit, minimum loan size) are the bank's, not guaranteed, and can change — talk to an advisor before borrowing against a policy. Mechanics: you draw a level amount each year, interest capitalizes, and the balance must stay within the lending limit every year until the death benefit repays the loan — so the assumed age at death also sizes the income (this is how Manulife's IRP binds at life expectancy; with death set to the last draw year it reproduces Equitable's Preferred Retirement Solution). Nothing drawn counts toward the OAS clawback threshold. The comparison asks what fully-taxable income — an RRSP/RRIF withdrawal, rent, interest — must be, pre-tax, to net the same cash on top of your other income (2026 ON brackets; OAS clawback threshold $95,323, 15%; assumes draws at 65+). Educational estimate, not advice.
Read this before you fall in love with the number
Collateral-loan retirement income has real risks: if loan rates run above the dividend scale for years, the room shrinks; if the policy lapses with a loan outstanding, the whole gain becomes taxable at once; banks can change lending terms. And know which loan you're taking: a bank collateral loan (modelled here) is not taxable income under current rules, while a policy loan from the insurer can be taxed once it exceeds the policy's adjusted cost basis. Illustrated values are the carrier's current scale, not a promise. This tool shows the mechanics honestly — whether this structure fits you, and which lender to use, is a question for your own insurance and tax advisors.
Book a Tax Diagnostic
Thirty minutes, your illustration on the table, no products pitched. The first conversation is free — bring the PDF, leave with the math.
// the only variable in this plan that gets more expensive every year is your age