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
Set Up
Accounts Balances
Step 2 Asset Allocation
TFSA Result
RRSP Result
Corp Result
Personal Acct Result
Portfolio Summary
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. 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 Acknowledge & Agree To The Above
You must agree to the terms of use for the navigation tabs to appear at the top.
Questions To Optimize Interface & Tax Efficiency
Are you investing through a CCPC (Private Cor
p)?
No
Yes
Do you plan to start using a CCPC in the futur
e?
No
Yes
What province are you taxed in?
Alberta
British Columbia
Manitoba
New Brunswick
Newfoundland
Northwest Territories
Nova Scotia
Nunavut
Ontario
Prince Edward Island
Quebec
Saskatchewan
Yukon
Income of the person that the personal taxable account is attributed to
Regular Income minus RRSP Deduction
Ineligible Dividends (From Corp)
Eligible Dividends
Your tax rate on interest and foreign dividends
Your effective marginal tax rate on eligible dividends
Select Strategy To Use For TFSA
Global Diversification
Max Tax Efficiency
The TFSA goal is growth. A global strategy spreads out around the world by market size. The tax efficiency strategy may contain more Non-North American Developed Markets or Canadian than their market weight - especially with large portfolios.
After the above is answered, open the input tabs to proceed
Inputs Closed
Inputs Open
Opening Account Balances
$CAD to $USD Exchange if using $USD Accounts
(Ignore if not using)
All TFSAs
Do you use a $USD TFSA (usually not worth it)?
No
Yes
$CAD TFSA Account Balance (
in $CAD
)
$USD TFSA Account Balance (
in $USD
)
Total Opening Balance ($CAD)
All RRSPs
Do you use a $USD RRSP?
No
Yes
$CAD RRSP Account Balance (
in $CAD
)
$USD RRSP Account Balance (
in $USD
)
Opening Balance ($CAD)
Corporate Investments
Do you use a $USD Corp Account?
No
Yes
$CAD Corp Account Balance (
in $CAD
)
$USD Corp Account Balance (
in $USD
)
Opening Balance ($CAD)
Personal Taxable Investment Account
Do you use a $USD Personal Taxable?
No
Yes
$CAD Personal Taxable Account Balance (
in $CAD
)
$USD Personal Taxable Account Balance (
in $USD
)
Opening Balance ($CAD)
Total Portfolio
Opening Balance ($CAD)
Step 1:
Determine your risk tolerance and an appropriate stocks:bonds ratio that fits that. This can be done via discussion with a financial advisor and/or you could use the Vanguard Questionnaire, Investin' Intestin' Testor, and look at historical returns and volality to help. Mulitple modalities are best to guess, but experience teaches.
Risk Tolerance & Asset Allocation
Vanguard Risk Tolerance Questionnaire
Desktop/Tablet: Returns & Volatility Visualizer
Desktop/Table: Investing Intestinal Fortitude Tester
Mobile: Returns & Volatility Visualizer
Mobile: Investing Intestinal Fortitude Tester
Step 2:
Decide how much of your equity allocation to make as Canadian equities versus foreign.
Do you want to simply put a stock:bonds ratio and have stocks distributed as 1/3 Canadian & 2/3 Foreign or set your own custom allocations?
Stock:Bonds With Auto Distribution
Custom Asset Allocation
Conservative
Aggressive
Bonds
Stocks
Canadian Equity
"0"
US Equity
"0"
Non-North America Developed Markets
"0"
Emerging Markets
"0"
Bonds
"0"
Step 3: Enter them below & make sure ad
ds up to 100%
Canadian Equity
US Equity
Non-North America Developed Markets
Emerging Markets
Bonds
Total
TFSA Strategy
The TFSA goal is growth. A global strategy spreads out around the world by market size. The tax efficiency strategy may contain more Canadian than its market weight - especially with large portfolios.
Can be changed between Global vs Max Tax Efficiency in the Set Up Tab.
Canadian Dollar TFSA
Asset Class
ETF
Amount
Canadian Equity
VCN
US Equity
XUU
Non-NA Developed
XEF
Emerging Markets
XEC
Bonds
VAB
TOTAL IN ACCOUNT
U.S. Dollar TFSA
CAD to USD
Asset Class
ETF
Amount ($CAD)
Non-NA Developed
IEFA
Emerging Markets
IEMG
TOTAL IN ACCOUNT
Canadian Dollar RRSP
Asset Class
ETF
Amount
Canadian Equity
VCN
US Equity
XUU
Non-NA Developed
XEF
Emerging Markets
XEC
Bonds
VAB
TOTAL IN ACCOUNT
U.S. Dollar RRSP
CAD to USD
Asset Class
ETF
Amount ($CAD)
US Equity
ITOT
Non-NA Developed
IEFA
Emerging Markets
IEMG
TOTAL IN ACCOUNT
Canadian Dollar Corporate Account
Asset Class
ETF
Amount
Canadian Equity
VCN
US Equity
XUU
Non-NA Developed
XEF
Emerging Markets
XEC
Bonds
ZDB
TOTAL IN ACCOUNT
U.S. Dollar Corporate Account
CAD to USD
Asset Class
ETF
Amount ($CAD)
US Equity
ITOT
Non-NA Developed
IEFA
Emerging Markets
IEMG
TOTAL IN ACCOUNT
Canadian Dollar Corporate Account
Asset Class
ETF
Amount
Canadian Equity
VCN
US Equity
XUU
Non-NA Developed
XEF
Emerging Markets
XEC
Bonds
ZDB
TOTAL IN ACCOUNT
U.S. Dollar Corporate Account
CAD to USD
Asset Class
ETF
Amount ($CAD)
US Equity
ITOT
Non-NA Developed
IEFA
Emerging Markets
IEMG
TOTAL IN ACCOUNT
Goal Portfolio Composition (In $CAD)
Global Diversification TFSA Strategy. Can Change In TFSA Result Tab.
Asset Class
ETFs
TFSA
RRSP
Corp
Taxable
Portfolio
Allocation
Canadian Equity
VCN (Cdn EQ)
US Equity
XUU (Cdn-Listed US EQ)
""
ITOT (US-Listed US EQ)
Non-NA Developed
XEF (Cdn-Listed Non-NA Dev
'd)
""
IEFA (US-Listed Non-NA Dev'
d)
Emerging Markets
XEC (Cdn-Listed EMM)
""
IEMG (US-Listed EMM)
Bonds
VAB (Canadian Bond Index)
""
ZDB (Discount Bonds)
TOTALS
Max Tax Efficiency TFSA Strategy. Can Change In TFSA Result Tab.
Asset Class
ETFs
TFSA
RRSP
Corp
Taxable
Portfolio
Allocation
Canadian Equity
VCN (Cdn EQ)
US Equity
XUU (Cdn-Listed US EQ)
""
ITOT (US-Listed US EQ)
Non-NA Developed
XEF (Cdn-Listed Non-NA Dev
'd)
""
IEFA (US-Listed Non-NA Dev'
d)
Emerging Markets
XEC (Cdn-Listed EMM)
""
IEMG (US-Listed EMM)
Bonds
VAB (Canadian Bond Index)
""
ZDB (Discount Bonds)
TOTALS
Step by Step How To Buy ETFs Video
About the example ETFs used & their role
Print All Information
Please host the converted page in server to use Print All.
Reset
Print All