This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
Disclaimer
Disclaimer
Income & Spending
Asset Allocation
All-In-One ETF Info
ETF Info
TFSA Input
RRSP1 Input
RRSP2 Input
Corp Input
Personal1 Input
Personal2 Input
Joint Input
Portfolio Summary
Portfolio Overview
Retirement Summary
Yr1 Corp Cashflow
Yr1 Personal Cashflow
Drawdown Plan
Estate
Disclaimer: This calculator is basic and for illustrative/entertainment purposes. I have tried to make it accurate, but there is no warranty.
I am not a financial professional and do not sell any stocks, bonds, or funds. I do not provide specific financial advice
. There is no explicit or implicit recommendation for the ETFs used. They are examples and you should use whatever best suits you.
This calculator is intended to help DIY investors who ultimately make their own decisions and manage their portfolios on their own
. Selling investments can trigger taxes. Be sure that any suggestions for rebalancing your portfolio makes sense for you. You should do your own due diligence and consult experts as needed for your own situation.
You are responsible for your own investing decisions and will not sue Loonie Doctor or anyone associated with us.
I Do Not Agree
I Have Read & Agree With Above
The tool saves your entries to your web-browser.
This has the advantage of making it easier for you to come back to, but be aware in case you are using a public computer.
Are You Married or Single?
Married
Single
Enter Names To Label Accounts
Higher income Person
Lower Income Person
Retirement Age
Life Expectancy
NIH Life Expectancy Calculator
Province
AB
BC
MB
NB
NS
NF
ON
PE
PQ
SK
Rough Guess At Average Annual Total Return In The Long Run After Inflation
Equity (Stocks)
Bonds
Capital Gains Inclusion Rate
Corporate Nominal Accounts (If Known)
Capital Dividend Account
GRIP
eRDOTH
nRDTOH
Is the corp owner able to give spouse dividends before age 65?
No
Yes
Canada Pension Plan Worksheet
Years Contributing
Number of Low-Income Years That Can Be Excluded
Average T4 income Excluding Worst Years
Adjusted For Max Pensionable Income
Total Pensionable Earnings
Average Monthly Pensionable Earnings
Age Starting (60-70)
Estimated Monthly Benefit
Estimated Annual CPP Benefit
Other Pensions
Annual Amount
Age Starting
Survivor Benefit
Casual Work Income
Age
Retirement Target After-Tax Lifestyle Spending
Age
After-Tax Cashflow Target
Target Asset Allocation Selection
$CAD to $USD Exchange Rate
Select Input for your current Asset Allocation Strategy
Select
Stock:Bonds Ratio With Auto-Distribution (Same In Each Account)
Custom Allocation (Same In Each Account)
All-In-One-ETFs (Can Use Same or Different in Each Account)
Enter Specific Assets In Each Account
Conservative
Aggressive
Bonds
Stocks
Use a US Small Cap Value Factor Tilt?
Yes
No
Canadian All Cap EQ
"0"
US Total Market
"0"
US Small Cap Value EQ
"0"
Non-North America Developed Markets
"0"
Emerging Markets
"0"
Bonds
"0"
Step 3: Enter them below & make sure adds up to 100%
US Equity
Int'l (Non-North America) Developed Marke
ts
Emerging Markets
Canadian Bonds
Cash
Total
All-In-One Asset Allocation ETF Ticker
VEQT
XEQT
VGRO
XGRO
VCNS
XCNS
Canadian All-Cap Equity
30.34%
26.56%
24.52%
21.28%
12.26%
10.65%
US Total Stock Market
42.89%
45.14%
34.20%
36.15%
17.32%
18.08%
Non-NA Developed Market
19.30%
23.58%
15.56%
18.90%
7.74%
9.46%
Emerging Market
7.47%
4.65%
5.84%
3.73%
3.05%
1.87%
Bond Market
0.00%
0.00%
Management Expense Ratio (Fee)
0.25%
0.20%
0.24%
0.20%
0.24%
0.20%
Below are the ETFs used by the calculator. It is not a specific recommendation.
The dividend yield averaged over the past 5-10 years was used for calculating income and tax drags. The yield to maturity and adjustment for capital gains/losses is used for bonds.
You can change ETFs, fees, and gross (pre-fee & tax) yields. However, keep Canadian, US, Non-NA, bond status the same for the tax-drags to calculate properly.
Only replace a corp class ETF with another corp call ETF to maintain their tax calculations.
Asset Class (Index)
Symbol
Currency
Fees
Gross Yield
Total Fee & Tax Drag*
TFSA
RRSP
Corp
Personal
Pers#2
Joint
Canadian All Cap (FTSE)
CAD
CDN All Cap (S&P) Corp Class
CAD
US Total Market (CRSP)
CAD
US Total Market (S&P Core US)
USD
US Large Cap (Solactive) Corp Class
CAD
NDX 100 (US Large Cap Growth)
CAD
NDX 100 (US Large Cap Growth)
USD
NDX 100 Corp Class
CAD
US Small Cap Value
USD
Non-NA Developed (Core MSCI EAFE)
CAD
Non-NA Developed (Core MSCI EAFE)
USD
Non-NA Dev (Horizon EAFE) Corp Class
CAD
Emerging Markets (Core MSCI EMM)
CAD
Emerging Markets (Core MSCI EMM)
USD
Emerging Markets (Horizon EMM) Corp C
lass
CAD
Canadian Bond (FTSE)
CAD
Canadian Discount Bonds
CAD
CDN Bond (Solactive) Corp Class
CAD
*For new purchases at current tax rates. The initial net tax on eligible dividends flowed through a corp may be lower if enough dividends are dispensed (reported on input/rebalance tabs). For personal accounts, it is at top personal marginal rate.
CURRENT TFSA HOLDINGS & BALANCES
Enter Unused TFSA Contribution Room
CAD to USD Exchange Rate
TFSAs Total
in $CAD
After-Tax
Income
Fee & Tax Drag
Dividend or Interest (CAD)
Tax Drag
Fee Drag
Fee & Tax Drag
Asset Class
ETF Symbol
Value
ETF Currency
Value in $CAD
After-Tax Value
Canadian All Cap (FTSE)
VCN
CAD
CDN All Cap (S&P) Corp Class
HXCN
CAD
US Total Market (CRSP)
VUN
CAD
US Total Market (S&P Core US)
ITOT
USD
US Large Cap (Solactive) Corp Class
HULC
CAD
$
-
NDX 100 (US Large Cap Growth)
ZNQ
CAD
NDX 100 (US Large Cap Growth)
QQQ
USD
NDX 100 Corp Class
HXQ
CAD
US Small Cap Value
AVUV
USD
Non-NA Developed (Core MSCI EAFE)
XEF
CAD
Non-NA Developed (Core MSCI EAFE)
IEFA
USD
Non-NA Dev (Horizon EAFE) Corp Class
HXDM
CAD
Emerging Markets (Core MSCI EMM)
XEC
CAD
Emerging Markets (Core MSCI EMM)
IEMG
USD
Emerging Markets (Horizon EMM) Corp Class
HXEM
CAD
Canadian Bond (FTSE)
ZAG
CAD
CDN Bond (Solactive) Corp Class
HBB
CAD
$
-
$CAD Cash & Contributions
CAD
$USD Cash & Contributions
USD
Total Cash & Contributions
Account Total
CAD
Dividend or Interest (CAD)
Tax Drag
Fee Drag
Fee & Tax Drag
Asset Class
ETF Symbol
Value
ETF Currency
Value in $CAD
After-Tax Value
Canadian All Cap (FTSE)
VCN
CAD
CDN All Cap (S&P) Corp Class
HXCN
CAD
$
-
US Total Market (CRSP)
VUN
CAD
US Total Market (S&P Core US)
ITOT
USD
US Large Cap (Solactive) Corp Class
HULC
CAD
$
-
NDX 100 (US Large Cap Growth)
ZNQ
CAD
NDX 100 (US Large Cap Growth)
QQQ
USD
NDX 100 Corp Class
HXQ
CAD
$
-
US Small Cap Value
AVUV
USD
Non-NA Developed (Core MSCI EAFE)
XEF
CAD
Non-NA Developed (Core MSCI EAFE)
IEFA
USD
Non-NA Dev (Horizon EAFE) Corp Class
HXDM
CAD
Emerging Markets (Core MSCI EMM)
XEC
CAD
Emerging Markets (Core MSCI EMM)
IEMG
USD
Emerging Markets (Horizon EMM) Corp Class
HXEM
CAD
Canadian Bond (FTSE)
ZAG
CAD
CDN Bond (Solactive) Corp Class
HBB
CAD
$
-
$CAD Cash & Contributions
CAD
$USD Cash & Contributions
USD
Total Cash & Contributions
Account Total
CAD
TFSAs Total
in $CAD
After-Tax
Income
Fee & Tax Drag
Asset Class
ETF Symbol
Value
ETF Currency
Value in $CAD
After-Tax Value
Income (CAD)
Tax Drag
Fee Drag
Total Drag
Canadian All Cap (FTSE)
VCN
CAD
US Total Market (CRSP)
VUN
CAD
NDX 100 (US Large Cap Growth)
ZNQ
CAD
US Small Cap Value
AVUV
USD
Non-NA Developed (Core MSCI EAFE)
XEF
CAD
Emerging Markets (Core MSCI EMM)
XEC
CAD
Canadian Bond (FTSE)
ZAG
CAD
Cash
Cash
CAD
$
-
0.00%
0.00%
0.00%
All-In-One Asset Allocation ETF
Allocation
Value
Equity
After-Tax Value
Eligible Dividends
Other Income
Tax Drag
Fee Drag
Total Drag
Vanguard All Equity (VEQT)
100%
iShares All Equity (XEQT)
100%
Vanguard Growth ETF (VGRO)
80%
iShares Growth ETF (XGRO)
80%
Vanguard Conservative ETF (VCNS)
40%
iShares Conservative ETF (XCNS)
40%
Canadian FTSE Bond Index ETF (ZAG)
0%
$
-
0.00%
Cash
0%
$
-
$
-
0.00%
0.00%
Total For TFSAs
CAD to USD Exchange Rate
RRSPs Total
in $CAD
After-Tax*
Income
Fee & Tax Drag
*Applies average tax rate from RRSP withdrawals from simulated drawdown strategy
Dividend or Interest (CAD)
Tax Drag
Fee Drag
Fee & Tax Drag
Asset Class
ETF Symbol
Value
ETF Currency
Value in $CAD
After-Tax Value
Canadian All Cap (FTSE)
VCN
CAD
CDN All Cap (S&P) Corp Class
HXCN
CAD
US Total Market (CRSP)
VUN
CAD
US Total Market (S&P Core US)
ITOT
USD
US Large Cap (Solactive) Corp Class
HULC
CAD
$
-
NDX 100 (US Large Cap Growth)
ZNQ
CAD
NDX 100 (US Large Cap Growth)
QQQ
USD
NDX 100 Corp Class
HXQ
CAD
$
-
US Small Cap Value
AVUV
USD
Non-NA Developed (Core MSCI EAFE)
XEF
CAD
Non-NA Developed (Core MSCI EAFE)
IEFA
USD
Non-NA Dev (Horizon EAFE) Corp Class
HXDM
CAD
Emerging Markets (Core MSCI EMM)
XEC
CAD
Emerging Markets (Core MSCI EMM)
IEMG
USD
Emerging Markets (Horizon EMM) Corp Class
HXEM
CAD
Canadian Bond (FTSE)
ZAG
CAD
CDN Bond (Solactive) Corp Class
HBB
CAD
$
-
$CAD Cash & Contributions
CAD
$USD Cash & Contributions
USD
Total Cash & Contributions
CAD
Account Total
CAD
Dividend or Interest (CAD)
Tax Drag
Fee Drag
Fee & Tax Drag
Asset Class
ETF Symbol
Value
ETF Currency
Value in $CAD
After-Tax Value
Canadian All Cap (FTSE)
VCN
CAD
CDN All Cap (S&P) Corp Class
HXCN
CAD
$
-
US Total Market (CRSP)
VUN
CAD
US Total Market (S&P Core US)
ITOT
USD
US Large Cap (Solactive) Corp Class
HULC
CAD
$
-
NDX 100 (US Large Cap Growth)
ZNQ
CAD
NDX 100 (US Large Cap Growth)
QQQ
USD
NDX 100 Corp Class
HXQ
CAD
$
-
US Small Cap Value
AVUV
USD
Non-NA Developed (Core MSCI EAFE)
XEF
CAD
Non-NA Developed (Core MSCI EAFE)
IEFA
USD
Non-NA Dev (Horizon EAFE) Corp Class
HXDM
CAD
Emerging Markets (Core MSCI EMM)
XEC
CAD
Emerging Markets (Core MSCI EMM)
IEMG
USD
Emerging Markets (Horizon EMM) Corp Class
HXEM
CAD
Canadian Bond (FTSE)
ZAG
CAD
CDN Bond (Solactive) Corp Class
HBB
CAD
$
-
$CAD Cash & Contributions
CAD
$USD Cash & Contributions
USD
Total Cash & Contributions
CAD
Account Total
CAD
in $CAD
After-Tax
Income
Fee & Tax Drag
*Applies average tax rate from RRSP withdrawals from simulated drawdown strategy
Asset Class
ETF Symbol
Value
ETF Currency
Value in $CAD
After-Tax Value
Income (CAD)
Tax Drag
Fee Drag
Total Drag
Canadian All Cap (FTSE)
VCN
CAD
US Total Market (CRSP)
VUN
CAD
NDX 100 (US Large Cap Growth)
ZNQ
CAD
US Small Cap Value
AVUV
USD
Non-NA Developed (Core MSCI EAFE)
XEF
CAD
Emerging Markets (Core MSCI EMM)
XEC
CAD
Canadian Bond (FTSE)
ZAG
CAD
Cash
Cash
CAD
$
-
0.00%
0.00%
0.00%
All-In-One Asset Allocation ETF
Allocation
Value
Equity
After-Tax Value
Eligible Dividends
Other Income
Tax Drag
Fee Drag
Total Drag
Vanguard All Equity (VEQT)
100%
iShares All Equity (XEQT)
100%
Vanguard Growth ETF (VGRO)
80%
iShares Growth ETF (XGRO)
80%
Vanguard Conservative ETF (VCNS)
40%
iShares Conservative ETF (XCNS)
40%
Canadian FTSE Bond Index ETF (ZAG)
0%
$
-
0.00%
Cash
0%
$
-
$
-
0.00%
0.00%
Total For RRSPs
CAD to USD Exchange Rate
RRSPs Total
in $CAD
After-Tax*
Income
Fee & Tax Drag
*Applies average tax rate from RRSP withdrawals from simulated drawdown strategy
Dividend or Interest (CAD)
Tax Drag
Fee Drag
Fee & Tax Drag
Asset Class
ETF Symbol
Value
ETF Currency
Value in $CAD
After-Tax Value
Canadian All Cap (FTSE)
VCN
CAD
CDN All Cap (S&P) Corp Class
HXCN
CAD
US Total Market (CRSP)
VUN
CAD
US Total Market (S&P Core US)
ITOT
USD
US Large Cap (Solactive) Corp Class
HULC
CAD
$
-
NDX 100 (US Large Cap Growth)
ZNQ
CAD
NDX 100 (US Large Cap Growth)
QQQ
USD
NDX 100 Corp Class
HXQ
CAD
$
-
US Small Cap Value
AVUV
USD
Non-NA Developed (Core MSCI EAFE)
XEF
CAD
Non-NA Developed (Core MSCI EAFE)
IEFA
USD
Non-NA Dev (Horizon EAFE) Corp Class
HXDM
CAD
Emerging Markets (Core MSCI EMM)
XEC
CAD
Emerging Markets (Core MSCI EMM)
IEMG
USD
Emerging Markets (Horizon EMM) Corp Class
HXEM
CAD
Canadian Bond (FTSE)
ZAG
CAD
CDN Bond (Solactive) Corp Class
HBB
CAD
$
-
$CAD Cash & Contributions
CAD
$USD Cash & Contributions
USD
Total Cash & Contributions
CAD
Account Total
CAD
Dividend or Interest (CAD)
Tax Drag
Fee Drag
Fee & Tax Drag
Asset Class
ETF Symbol
Value
ETF Currency
Value in $CAD
After-Tax Value
Canadian All Cap (FTSE)
VCN
CAD
CDN All Cap (S&P) Corp Class
HXCN
CAD
$
-
US Total Market (CRSP)
VUN
CAD
US Total Market (S&P Core US)
ITOT
USD
US Large Cap (Solactive) Corp Class
HULC
CAD
$
-
NDX 100 (US Large Cap Growth)
ZNQ
CAD
NDX 100 (US Large Cap Growth)
QQQ
USD
NDX 100 Corp Class
HXQ
CAD
$
-
US Small Cap Value
AVUV
USD
Non-NA Developed (Core MSCI EAFE)
XEF
CAD
Non-NA Developed (Core MSCI EAFE)
IEFA
USD
Non-NA Dev (Horizon EAFE) Corp Class
HXDM
CAD
Emerging Markets (Core MSCI EMM)
XEC
CAD
Emerging Markets (Core MSCI EMM)
IEMG
USD
Emerging Markets (Horizon EMM) Corp Class
HXEM
CAD
Canadian Bond (FTSE)
ZAG
CAD
CDN Bond (Solactive) Corp Class
HBB
CAD
$
-
$CAD Cash & Contributions
CAD
$USD Cash & Contributions
USD
Total Cash & Contributions
CAD
Account Total
CAD
in $CAD
After-Tax
Income
Fee & Tax Drag
*Applies average tax rate from RRSP withdrawals from simulated drawdown strategy
Asset Class
ETF Symbol
Value
ETF Currency
Value in $CAD
After-Tax Value
Income (CAD)
Tax Drag
Fee Drag
Total Drag
Canadian All Cap (FTSE)
VCN
CAD
US Total Market (CRSP)
VUN
CAD
NDX 100 (US Large Cap Growth)
ZNQ
CAD
US Small Cap Value
AVUV
USD
Non-NA Developed (Core MSCI EAFE)
XEF
CAD
Emerging Markets (Core MSCI EMM)
XEC
CAD
Canadian Bond (FTSE)
ZAG
CAD
Cash
Cash
CAD
$
-
0.00%
0.00%
0.00%
All-In-One Asset Allocation ETF
Allocation
Value
Equity
After-Tax Value
Eligible Dividends
Other Income
Tax Drag
Fee Drag
Total Drag
Vanguard All Equity (VEQT)
100%
iShares All Equity (XEQT)
100%
Vanguard Growth ETF (VGRO)
80%
iShares Growth ETF (XGRO)
80%
Vanguard Conservative ETF (VCNS)
40%
iShares Conservative ETF (XCNS)
40%
Canadian FTSE Bond Index ETF (ZAG)
0%
$
-
0.00%
Cash
0%
$
-
$
-
0.00%
0.00%
Total For RRSPs
CURRENT CORPORATE HOLDINGS & BALANCES
CAD to USD Exchange Rate
Corp Total
in $CAD
After-Tax*
Income
Fee & Tax Drag
*Applies average tax rate during a simulated drawdown strategy during retirement
*Taxable part of cap gains taxed at corp rate and nRDTOH applied, then taxed at personal ineligible dividend rate or eligible dividend rate if GRIP available.
Unused realized capital losses carried forward from previous years (as negative number)
Included Loss
Corporate Investment Account
Unrealized Capital Gain/Loss
Dividend or Interest (CAD)
Tax Drag
Fee Drag
Fee & Tax Drag
Asset Class
ETF Symbol
Value
ETF Currency
Value in $CAD
After-Tax Value
Canadian All Cap (FTSE)
VCN
CAD
CDN All Cap (S&P) Corp Class
HXCN
CAD
US Total Market (CRSP)
VUN
CAD
US Total Market (S&P Core US)
ITOT
USD
US Large Cap (Solactive) Corp Class
HULC
CAD
$
-
NDX 100 (US Large Cap Growth)
ZNQ
CAD
NDX 100 (US Large Cap Growth)
QQQ
USD
NDX 100 Corp Class
HXQ
CAD
$
-
US Small Cap Value
AVUV
USD
Non-NA Developed (Core MSCI EAFE)
XEF
CAD
Non-NA Developed (Core MSCI EAFE)
IEFA
USD
Non-NA Dev (Horizon EAFE) Corp Class
HXDM
CAD
Emerging Markets (Core MSCI EMM)
XEC
CAD
Emerging Markets (Core MSCI EMM)
IEMG
USD
Emerging Markets (Horizon EMM) Corp Class
HXEM
CAD
Canadian Discount Bonds
ZDB
CAD
CDN Bond (Solactive) Corp Class
HBB
CAD
$
-
0.00%
$CAD Cash & Contributions
CAD
Net Unrealized Capital Gain/Loss (in CAD)
$USD Cash & Contributions
USD
Total Cash & Contributions
CAD
Account Total
CAD
Using Carried Losses To Offset
Corp Total
in $CAD
After-Tax
Income
Fee & Tax Drag
*Applies average tax rate during a simulated drawdown strategy during retirement
*Taxable part of cap gains taxed at corp rate and nRDTOH applied, then taxed at personal ineligible dividend rate or eligible dividend rate if GRIP available.
Unused
realized
capital losses carried forward from previous years (as negative number)
Included Loss
Current
unrealized
capital gains (losses): Enter losses as negative number
Incl. Gain (Loss)
Asset Class
ETF Symbol
Value
ETF Currency
Value in $CAD
Unrealized Capital Gain/Loss
After-Tax Value
Dividend or Interest (CAD)
Tax Drag
Fee Drag
Fee & Tax Drag
Canadian All Cap (FTSE)
VCN
CAD
"-"
US Total Market (CRSP)
VUN
CAD
NDX 100 (US Large Cap Growth)
ZNQ
CAD
US Small Cap Value
AVUV
USD
Non-NA Developed (Core MSCI EAFE)
XEF
CAD
Emerging Markets (Core MSCI EMM)
XEC
CAD
Canadian Bond (FTSE)
ZAG
CAD
Cash
Cash
CAD
$
-
$
-
0.00%
0.00%
0.00%
Account Total
CAD
Using Carried Losses To Offset
All-In-One Asset Allocation ETF
Allocation
Value
Equity
Unrealized Capital Gain/Loss
After-Tax Value
Eligible Dividends
Other Income
Tax Drag
Fee Drag
Total Drag
Vanguard All Equity (VEQT)
100%
iShares All Equity (XEQT)
100%
Vanguard Growth ETF (VGRO)
80%
iShares Growth ETF (XGRO)
80%
Vanguard Conservative ETF (VCNS)
40%
iShares Conservative ETF (XCNS)
40%
Canadian FTSE Bond Index ETF (ZAG)
0%
$
-
0.00%
Cash
0%
$
-
$
-
$
-
0.00%
0.00%
Total For Corp Account
Using Carried Losses To Offset
CAD to USD Exchange Rate
Account Total
in $CAD
After-Tax*
Income
Fee & Tax Drag
*Applies drawdown average marginal rate to the taxable portion of capital gains.
*Note that capital losses are treated with a negative tax rate based on the assumption that they are used to offset gains
Unused realized capital losses carried forward from previous years (as negative number)
Included Loss
Unrealized Capital Gain/Loss
Dividend or Interest (CAD)
Tax Drag
Fee Drag
Fee & Tax Drag
Asset Class
ETF Symbol
Value
ETF Currency
Value in $CAD
After-Tax Value
Canadian All Cap (FTSE)
VCN
CAD
CDN All Cap (S&P) Corp Class
HXCN
CAD
$
-
US Total Market (CRSP)
VUN
CAD
US Total Market (S&P Core US)
ITOT
USD
US Large Cap (Solactive) Corp Class
HULC
CAD
$
-
NDX 100 (US Large Cap Growth)
ZNQ
CAD
NDX 100 (US Large Cap Growth)
QQQ
USD
NDX 100 Corp Class
HXQ
CAD
$
-
US Small Cap Value
AVUV
USD
Non-NA Developed (Core MSCI EAFE)
XEF
CAD
Non-NA Developed (Core MSCI EAFE)
IEFA
USD
Non-NA Dev (Horizon EAFE) Corp Class
HXDM
CAD
Emerging Markets (Core MSCI EMM)
XEC
CAD
Emerging Markets (Core MSCI EMM)
IEMG
USD
Emerging Markets (Horizon EMM) Corp Class
HXEM
CAD
Canadian Discount Bonds
ZDB
CAD
CDN Bond (Solactive) Corp Class
HBB
CAD
$
-
$CAD Cash & Contributions
CAD
Net Unrealized Capital Gain/Loss (in CAD)
$USD Cash & Contributions
USD
Total Cash & Contributions
Account Total
CAD
Using Carried Losses To Offset
Account Total
in $CAD
After-Tax
Income
Fee & Tax Drag
*Applies drawdown average marginal rate to the taxable portion of capital gains.
*Note that capital losses are treated with a negative tax rate based on the assumption that they are used to offset gains
Unused
realized
capital losses carried forward from previous years (as negative number)
Included Loss
Current
unrealized
capital gains (losses): Enter losses as negative number
Incl. Gain (Loss)
Asset Class
ETF Symbol
Value
ETF Currency
Value in $CAD
Unrealized Capital Gain/Loss
After-Tax Value
Dividend or Interest (CAD)
Tax Drag
Fee Drag
Fee & Tax Drag
Canadian All Cap (FTSE)
VCN
CAD
"-"
US Total Market (CRSP)
VUN
CAD
NDX 100 (US Large Cap Growth)
ZNQ
CAD
US Small Cap Value
AVUV
USD
Non-NA Developed (Core MSCI EAFE)
XEF
CAD
Emerging Markets (Core MSCI EMM)
XEC
CAD
Canadian Bond (FTSE)
ZAG
CAD
Cash
Cash
CAD
$
-
$
-
0.00%
0.00%
0.00%
Account Total
CAD
Using Carried Losses To Offset
All-In-One Asset Allocation ETF
Allocation
Value
Equity
Unrealized Capital Gain/Loss
After-Tax Value
Eligible Dividends
Other Income
Tax Drag
Fee Drag
Total Drag
Vanguard All Equity (VEQT)
100%
iShares All Equity (XEQT)
100%
Vanguard Growth ETF (VGRO)
80%
iShares Growth ETF (XGRO)
80%
Vanguard Conservative ETF (VCNS)
40%
iShares Conservative ETF (XCNS)
40%
Canadian FTSE Bond Index ETF (ZAG)
0%
$
-
0.00%
Cash
0%
$
-
$
-
$
-
0.00%
0.00%
Total For Account
Using Carried Losses To Offset
CAD to USD Exchange Rate
Account Total
in $CAD
After-Tax*
Income
Fee & Tax Drag
*Applies drawdown average marginal rate to the taxable portion of capital gains.
*Note that capital losses are treated with a negative tax rate based on the assumption that they are used to offset gains
Unused realized capital losses carried forward from previous years (as negative number)
Included Loss
Unrealized Capital Gain/Loss
Dividend or Interest (CAD)
Tax Drag
Fee Drag
Fee & Tax Drag
Asset Class
ETF Symbol
Value
ETF Currency
Value in $CAD
After-Tax Value
Canadian All Cap (FTSE)
VCN
CAD
CDN All Cap (S&P) Corp Class
HXCN
CAD
$
-
US Total Market (CRSP)
VUN
CAD
US Total Market (S&P Core US)
ITOT
USD
US Large Cap (Solactive) Corp Class
HULC
CAD
$
-
NDX 100 (US Large Cap Growth)
ZNQ
CAD
NDX 100 (US Large Cap Growth)
QQQ
USD
NDX 100 Corp Class
HXQ
CAD
$
-
US Small Cap Value
AVUV
USD
Non-NA Developed (Core MSCI EAFE)
XEF
CAD
Non-NA Developed (Core MSCI EAFE)
IEFA
USD
Non-NA Dev (Horizon EAFE) Corp Class
HXDM
CAD
Emerging Markets (Core MSCI EMM)
XEC
CAD
Emerging Markets (Core MSCI EMM)
IEMG
USD
Emerging Markets (Horizon EMM) Corp Class
HXEM
CAD
Canadian Discount Bonds
ZDB
CAD
CDN Bond (Solactive) Corp Class
HBB
CAD
$
-
$CAD Cash & Contributions
CAD
Net Unrealized Capital Gain/Loss (in CAD)
$USD Cash & Contributions
USD
Total Cash & Contributions
Account Total
CAD
Using Carried Losses To Offset
Account Total
in $CAD
After-Tax
Income
Fee & Tax Drag
*Applies drawdown average marginal rate to the taxable portion of capital gains.
*Note that capital losses are treated with a negative tax rate based on the assumption that they are used to offset gains
Unused
realized
capital losses carried forward from previous years (as negative number)
Included Loss
Current
unrealized
capital gains (losses): Enter losses as negative number
Incl. Gain (Loss)
Asset Class
ETF Symbol
Value
ETF Currency
Value in $CAD
Unrealized Capital Gain/Loss
After-Tax Value
Dividend or Interest (CAD)
Tax Drag
Fee Drag
Fee & Tax Drag
Canadian All Cap (FTSE)
VCN
CAD
"-"
US Total Market (CRSP)
VUN
CAD
NDX 100 (US Large Cap Growth)
ZNQ
CAD
US Small Cap Value
AVUV
USD
Non-NA Developed (Core MSCI EAFE)
XEF
CAD
Emerging Markets (Core MSCI EMM)
XEC
CAD
Canadian Bond (FTSE)
ZAG
CAD
Cash
Cash
CAD
$
-
$
-
0.00%
0.00%
0.00%
Account Total
CAD
Using Carried Losses To Offset
All-In-One Asset Allocation ETF
Allocation
Value
Equity
Unrealized Capital Gain/Loss
After-Tax Value
Eligible Dividends
Other Income
Tax Drag
Fee Drag
Total Drag
Vanguard All Equity (VEQT)
100%
iShares All Equity (XEQT)
100%
Vanguard Growth ETF (VGRO)
80%
iShares Growth ETF (XGRO)
80%
Vanguard Conservative ETF (VCNS)
40%
iShares Conservative ETF (XCNS)
40%
Canadian FTSE Bond Index ETF (ZAG)
0%
$
-
0.00%
Cash
0%
$
-
$
-
$
-
0.00%
0.00%
Total For Account
Using Carried Losses To Offset
JOINT PERSONAL TAXABLE ACCOUNT HOLDINGS & BALANCES
CAD to USD Exchange Rate
Account Total
in $CAD
After-Tax*
Income
Fee & Tax Drag
*Applies drawdown average marginal rate to the taxable portion of capital gains.
*Note that capital losses are treated with a negative tax rate based on the assumption that they are used to offset gains
Unused realized capital losses carried forward from previous years (as negative number)
Included Loss
Unrealized Capital Gain/Loss
Dividend or Interest (CAD)
Tax Drag
Fee Drag
Fee & Tax Drag
Asset Class
ETF Symbol
Value
ETF Currency
Value in $CAD
After-Tax Value
Canadian All Cap (FTSE)
VCN
CAD
CDN All Cap (S&P) Corp Class
HXCN
CAD
$
-
US Total Market (CRSP)
VUN
CAD
US Total Market (S&P Core US)
ITOT
USD
US Large Cap (Solactive) Corp Class
HULC
CAD
$
-
NDX 100 (US Large Cap Growth)
ZNQ
CAD
NDX 100 (US Large Cap Growth)
QQQ
USD
NDX 100 Corp Class
HXQ
CAD
$
-
US Small Cap Value
AVUV
USD
Non-NA Developed (Core MSCI EAFE)
XEF
CAD
Non-NA Developed (Core MSCI EAFE)
IEFA
USD
Non-NA Dev (Horizon EAFE) Corp Class
HXDM
CAD
Emerging Markets (Core MSCI EMM)
XEC
CAD
Emerging Markets (Core MSCI EMM)
IEMG
USD
Emerging Markets (Horizon EMM) Corp Class
HXEM
CAD
Canadian Discount Bonds
ZDB
CAD
CDN Bond (Solactive) Corp Class
HBB
CAD
$
-
$CAD Cash & Contributions
CAD
Net Unrealized Capital Gain/Loss (in CAD)
$USD Cash & Contributions
USD
Total Cash & Contributions
Account Total
CAD
Using Carried Losses To Offset
Account Total
in $CAD
After-Tax
Income
Fee & Tax Drag
*Applies drawdown average marginal rate to the taxable portion of capital gains.
*Note that capital losses are treated with a negative tax rate based on the assumption that they are used to offset gains
Unused
realized
capital losses carried forward from previous years (as negative number)
Included Loss
Current
unrealized
capital gains (losses): Enter losses as negative number
Incl. Gain (Loss)
Asset Class
ETF Symbol
Value
ETF Currency
Value in $CAD
Unrealized Capital Gain/Loss
After-Tax Value
Dividend or Interest (CAD)
Tax Drag
Fee Drag
Fee & Tax Drag
Canadian All Cap (FTSE)
VCN
CAD
"-"
US Total Market (CRSP)
VUN
CAD
NDX 100 (US Large Cap Growth)
ZNQ
CAD
US Small Cap Value
AVUV
USD
Non-NA Developed (Core MSCI EAFE)
XEF
CAD
Emerging Markets (Core MSCI EMM)
XEC
CAD
Canadian Bond (FTSE)
ZAG
CAD
Cash
Cash
CAD
$
-
$
-
0.00%
0.00%
0.00%
Account Total
CAD
Using Carried Losses To Offset
All-In-One Asset Allocation ETF
Allocation
Value
Equity
Unrealized Capital Gain/Loss
After-Tax Value
Eligible Dividends
Other Income
Tax Drag
Fee Drag
Total Drag
Vanguard All Equity (VEQT)
100%
iShares All Equity (XEQT)
100%
Vanguard Growth ETF (VGRO)
80%
iShares Growth ETF (XGRO)
80%
Vanguard Conservative ETF (VCNS)
40%
iShares Conservative ETF (XCNS)
40%
Canadian FTSE Bond Index ETF (ZAG)
0%
$
-
0.00%
Cash
0%
$
-
$
-
$
-
0.00%
0.00%
Total For Account
Using Carried Losses To Offset
Portfolio Summary
TFSAs
RRSP#1
RRSP#2
Corporation
""
""
Joint Taxable
Total Portfolio
Pre-Tax Value
Post-Tax Value
Fees & Taxes
""
""
Total Portfolio
Fee & Tax Drag
TFSAs
RRSP#1
RRSP#2
Corporation
""
""
Joint Taxable
Canadian All Cap
Total Portfolio
Value (Pre-Tax)
Allocation (Pre-Tax)
Value (Post-Tax)
Allocation (Post-Tax)
US Total Market
Total Portfolio
Value (Pre-Tax)
Allocation (Pre-Tax)
Value (Post-Tax)
Allocation (Post-Tax)
TFSAs
RRSP#1
RRSP#2
Corporation
""
""
""
NDX100 (US Large Cap Growth)
Total Portfolio
Value (Pre-Tax)
Allocation (Pre-Tax)
Value (Post-Tax)
Allocation (Post-Tax)
US Small Cap Value
Total Portfolio
Value (Pre-Tax)
Allocation (Pre-Tax)
Value (Post-Tax)
Allocation (Post-Tax)
Non-NA Developed
Total Portfolio
Value (Pre-Tax)
Allocation (Pre-Tax)
Value (Post-Tax)
Allocation (Post-Tax)
Emerging Markets
Total Portfolio
Value (Pre-Tax)
Allocation (Pre-Tax)
Value (Post-Tax)
Allocation (Post-Tax)
TFSAs
RRSP#1
RRSP#2
Corporation
""
""
""
Canadian Bond Market
Total Portfolio
Value (Pre-Tax)
Allocation (Pre-Tax)
Value (Post-Tax)
Allocation (Post-Tax)
Cash
"0"
Pre-Tax $CAD
Pre-Tax $USD
Post-Tax Total in CAD
Post-Tax Allocation (CAD)
Portfolio Summary
TFSAs
RRSP#1
RRSP#2
Corporation
""
""
Joint Taxable
Total Portfolio
Pre-Tax Value
Post-Tax Value
Fees & Taxes
""
""
Total Portfolio
Fee & Tax Drag
TFSAs
RRSP#1
RRSP#2
Corporation
""
""
Joint Taxable
Total Portfolio
Stocks (Equity)
Total Portfolio
Value (Pre-Tax)
Allocation (Pre-Tax)
Value (Post-Tax)
Allocation (Post-Tax)
Bonds
Total Portfolio
Value (Pre-Tax)
Allocation (Pre-Tax)
Value (Post-Tax)
Allocation (Post-Tax)
Cash
Pre-Tax $CAD
Post-Tax Total in CAD
Post-Tax Allocation
Progress Towards Retirement Cashflow Using Safe Initial Withdrawal Rates Based On Monte Carlo Simulations
Start Age (From Tax Info)
Estimated Age of Last Death (From Tax Info)
Longest Duration of Retirement (From Tax Info)
Target Personal Retirement Cashflow (From Tax Info)
Baseline Safe Withdrawal Rate*
Portfolio Fee & Tax Drag During Drawdown (Ex-RESP)
Net Safe Withdrawal Rate
After-Tax Portfolio Required
Current After-Tax Investment Portfolio
Current After-Tax Portfolio Including CPP/Pension/OAS
Progress Towards Retirement Cashflow Goal
Cashflow Gaps:
Can happen even if enough savings for the global retirement plan before OAS/Pensions kick in or if major fluctuations in spending targets. See chart below.
Baseline Safe Withdrawal Rate is initial pre-tax/fee withdrawal rate, increased by inflation annually with >95% success rate.
Based on Historical Data, Future Expected Returns, & Current Asset Allocation.
Anchored to Monte Carlo Simulations data with intrapolation between data points.
Extrapolation used for retirement durations under 5 years (ie. Not validated!)
Early Retirement Now Safe Withdrawal Rate Series
Canadian Article With Future Expected Returns Used
Retirement Cashflow Simulation
This uses an algorithm to sequentially draw funds each year to meet cashflow needs (if possible) while minimizing taxes and maximizing tax deferral. The version embedded in this calculator is limited to a 50 year retirement duration. It is also important to note that this approach while show a different result than the Monte Carlo simulations. This method uses a steady annual income and return based on your asset mix. Random returns can decrease portfolio survivability if there is a bad sequence of returns (that is what the Monte Carlo approach addresses). On the other hand, the Monte Carlo data doesn't fully account for optimal drawdown strategies nor for changing drawdown requirements that one may have during different stages of retirement (eg. more spending in early retirement for travel and more at the end for healthcare, with a dip in the middle years) . This model is used to calculate the average drawdown tax rates for the different tax-exposed accounts to determine after-tax asset allocation of the portfolio.
Corporation Investment Income
Current Year
Next Year
Corporate Eligible Dividend Income
Corporate Interest/Other Passive Income
Realized Capital Gains (Gross)
Total Taxable Capital Gain (Included Gain)
Corp Aggregate Investment Income
Corporation Notional Accounts
Current Year
Next Year
Capital Dividend Account
GRIP
eRDOTH
nRDTOH
Corporation Taxes
Current Year
Next Year
Elig Dividend Income: eRDTOH Collected
eRDTOH Refunded
Other Investment Income Tax Collected
nRDTOH Collected
nRDTOH Refunded
Net Corp Tax on Passive Income
Pre-dividend retained earnings
Net Retained Corporate Earnings To Invest
Current Year
Next Year
Pre-dividend retained earnings
Dividends Paid Out To Owner(s)
Net Corp Retained Earnings (Withdrawal)
Current Year
Next Year
Capital Dividend
Eligible Dividends
Ineligible Dividends
Total Dividends
Capital Dividend
$
-
$
-
Eligible Dividends
Ineligible Dividends
Total Dividends
Registered Account Dispensing of Funds
RRSP Withdrawal
RRSP Withdrawal Income Attribution (Pension Splitting)
TFSA Withdrawal (Contribution)
Personal Taxable Account Dispensing of Funds
Personal Account
Eligible Dividends
Foreign Dividends & Interest
Realized Capital Gain
Return of Capital
Total Personal Taxable Account Withdrawal
Joint Account
Eligible Dividends
Foreign Dividends & Interest
Realized Capital Gain
Return of Capital
Total Joint Taxable Account Withdrawal (Contribution)
Net Cashflow
Corporation Dividends (See Above)
RRSP Withdrawal
TFSA Withdrawal (Contribution)
Personal Account Withdrawal
Joint Account Withdrawal (Contribution)
Canada Pension Plan
Other Pension Plan
Casual/Part-Time Work Income
Taxable Income
Top Marginal Tax Rate
Personal Taxes & OAS Clawback
Net Cashflow
Liquidation of Corporate Estate
Initial Corp Account Balance
Capital Dividends To Dispense
Eligible Dividends To Dispense
Ineligible Dividends To Dispense
Gross Corp Tax
eRDTOH Refunded
nRDTOH Refunded
Net Corp Tax
Do you have a secondary will for Corp?
No
Yes
Probate On Corp
Liquidation of Personal Estate
Dividends From Corp (above)
RRSP Balance
TFSA Balance
Personal Account Balance
Capital Gain
Return of Capital
Joint Account Balance
Capital Gain
Return of Capital
Pre-Tax Assets
Taxable Income
Personal Tax
After-Tax Personal Estate
Probate on Personal Estate
Summary
Pre-Tax Estate Value
Personal & Corp Tax
Personal & Corp Probate
Tax & Probate Rate
Net Estate
Print All Information
Please host the converted page in server to use Print All.
Update
Reset
Print
Print All
Flowchart Of How The Drawdown Algorithm Works