RRSP Drawdown Excel - Free Template

1. Open the RRSP Drawdown Model sheet and review the layout. The table runs year by year, with age, opening balance, withdrawal, tax withheld, and ending balance.
2. Go to Assumptions & Tax and enter your starting balance, expected return, and withdrawal assumptions. Use the sheet to set one clear scenario instead of mixing several plans in one table.
3. Fill in the yearly withdrawal amounts on the model. If you want to test a steady retirement income of $40,000 a year, enter that amount and compare the net cash received after withholding.
4. Check the Summary Dashboard after each change. Use it to see whether the account lasts to your target age and whether the ending balance is still positive.
5. Read the Notes column for any flags or planning comments. If the withdrawal rate rises too high, treat it as a sign to slow the drawdown or reset the assumptions.
6. Use the Instructions sheet when you hand the file to someone else. It explains the workflow so another person can update the model without guessing.

This template is for the person who is about to start withdrawals and wants the numbers in front of them before the first transfer hits the bank. A retiree in Ottawa, a bookkeeper helping a client at year-end, or a spouse planning household income can all use it to see how much cash comes out after withholding.

Image 1, the RRSP Drawdown Model sheet, shows the core table. The columns cover Year, Age, Start RRSP Balance, Investment Return %, Gross RRSP Withdrawal, Withholding Tax %, Withholding Tax $, Net RRSP Cash Received, End RRSP Balance, Required Min. Withdrawal %, RRSP Drawdown Status, and Notes.

Where the template fits in real life

If you are 65 with a $420,000 RRSP and you want to test a $35,000 withdrawal, this sheet shows the cash you actually receive after tax withheld. If the portfolio earns 5% and you withdraw $35,000, the ending balance can still be projected instead of guessed.

Who usually uses it

Self-employed people moving from T2125 income into retirement, couples shifting from work income to pension income, and accountants doing planning for a client all use the same basic question: how much can you take out without draining the account too quickly? This template answers that with a row-by-row schedule instead of a vague rule of thumb.

Once you reach age 71, your RRSP must be collapsed and moved to an RRIF or annuity by the end of that year. The minimum withdrawal starts in the next year, and the rate rises with age, which is why a drawdown model needs an age column and a minimum withdrawal percentage column.

The withholding tax on RRSP withdrawals is not your final tax bill. For example, if you withdraw $50,000 in Ontario and your institution withholds 20%, you receive $40,000 cash, but your actual income tax result is settled on your personal return, often on the T1 with other income.

How the numbers work

For a $15,000 withdrawal, the usual withholding is 10% in Canada, so $1,500 is held back and $13,500 is paid to you. For a $50,000 withdrawal, the withholding often rises to 20%, so $10,000 is withheld and $40,000 reaches your bank account.

Why that matters for planning

You should model the withholding rate separately from the long-term tax effect because those are not the same thing. If you are using the RRSP to fill an income gap before CPP and OAS start, the sheet helps you keep the cash flow visible without losing track of the later tax settlement.

That same cash-flow view belongs alongside a TFSA room tracker when you want to keep withdrawals and available contribution room from crossing over later in the year.

The biggest mistake is taking too much too soon and only noticing after the account has already dropped by six figures. A $500,000 RRSP that earns 4% but pays out $60,000 a year can still shrink quickly once you add market swings and tax withheld.

Another common error is forgetting that the withholding is only a prepayment. If you take out $35,000 and get $31,500 after 10% withholding, you may still owe more at filing time if other income pushes you into a higher bracket.

Typical failures

People also skip the year-by-year schedule and use one flat number for the whole retirement. That causes problems when the account hits age 71, when the mandatory minimum starts, or when a spouse dies and the household income changes sharply.

What it costs

A bad drawdown plan can cost you thousands in unnecessary tax, lost investment growth, or a forced sale at the wrong time. If you withdraw an extra $20,000 every year for five years, the account can be down $100,000 of principal before you even see the compounding effect.

The spreadsheet works best when you update it on a fixed schedule instead of whenever you remember. Most people should review it once a quarter, and many bookkeepers or advisors tie that review to the same date they check tax instalments or household spending.

Image 2, the Summary Dashboard, gives you the quick view you need for that routine. Image 3, Assumptions & Tax, is where you change the return rate or withholding assumptions, and image 4, Instructions, tells you how to keep the process consistent.

Simple habits that keep it alive

• Copy the prior year’s assumptions before you change the withdrawal rate.
• Review the model on the same day you look at bank statements or investment statements.
• Use the Notes column to flag a change in lifestyle spending or tax withholding.
• Stop using the spreadsheet when the plan becomes an actual RRIF projection or a more complex household retirement model.

If your plan now includes multiple accounts, pension income, and projected tax by province, this file has done its job. At that point, you need a broader retirement model, not a simple RRSP drawdown sheet.