Thursday 13 April 2017

Financial Basics 10 - Investing and Re-balancing

This post is about managing your investments and accounts, how to make investments and how to re-balance your portfolio of investments.  


We will revisit the example portfolio from post #7 and the determination of which funds we will put in particular accounts. Then I will propose an easy way to make the contributions and buy the funds each month. We will make use of a Google Sheets spreadsheet that helps us determine which funds to buy in each account. 


Investing Example

You will recall from the example in post #7 that we have a portfolio of 4 funds.  One in each of the asset classes; namely bonds, Canadian, US and International equity. I will assume that you will be investing in 3 different accounts, an RRSP, a TFSA and a Taxable savings account. All the accounts are at a single bank or broker and are self-directed. 

The table below shows the funds I am going to use in the example in this post. Your funds and percentages may be different. 


ClassETFPortfolio
Name(%)
BondXBB25
CanadianXIU30
USXSP30
InternationalXIN15
TOTAL100

We want to place the funds in accounts to minimize our taxes paid each year. The following table from post #9 shows the distribution of funds by account and by percentage. Remember this distribution is dependent on the proportion of your assets in each account. In this example 63% is in RRSP, 24% in TFSA and the rest in the Taxable account.  If that distribution changes then the percentage of funds in each account also changes. You can use my Portfolio Live spreadsheet to do this calculation for you. 


ClassETFPortfolioAccount (%)
Name(%)RRSPTFSATaxable
BondXBB2525
CanadianXIU301713
USXSP30237
InternationalXIN1515
TOTAL10063.024.013.0

The table below shows the distribution by amount for the one year of savings, if the contribution to the accounts are $14.4k RRSP, $5.5k TFSA and $3k to Taxable.


ClassETFPortfolioAccount ($)
Name($)RRSPTFSATaxable
BondXBB57005700
CanadianXIU690039003000
USXSP690053001600
InternationalXIN34003400
TOTAL229001440055003000

Let's use this example from post #9 and see how we would buy the funds in a way to minimize purchase costs and effort. 

If you are not familiar with self-directed accounts, the contributing of cash and purchase of funds are two separate banking transactions. The contribution or transfer of cash is free, but the purchase of ETFs will require a transaction fee (typically $10). Cash is contributed to an account as one step, and once this has cleared (in a day or two) the cash shows up within the account and then a fund purchase transaction can be executed. 

The table below shows the contributions made to each account by month and then the fund purchase transactions that are made using the cash within the account. The fund purchase transactions are shown by fund and by account. (You will see later on I show the same example, but with fund purchase transactions every 2 months instead of every month to save on transaction fees.)

The total savings in this example is $22.9k for the year, or an average of $1,910 per month. I've rounded this off to $1900 a month for 11 months and then $2000 for December.  

In January, $1900 is contributed to the RRSP and then XBB is purchased with this cash. RRSP contributions continue until $1100 in August which adds up the $14,400 room in the RRSP. Cash contributions continue to the TFSA and then the Taxable account.  

Three contributions of $1900 just happen to make up the $5700 target for XBB in the RRSP. In April, XIN is bought and then $1500 in May to make up the total $3400.  Also in May, $400 is used to purchase XSP, then XSP purchases continue until the $1100 in August which uses up all the cash in the RRSP. 

Also in August, contributions to TFSA begin and purchases in the TFSA account starting with $800 of XSP (Remember from the table above XSP will be in both the RRSP and TFSA) and another $800 toward XSP in September which finishes off all XSP purchases.  In September $1100 of XIU is purchased in the TFSA and purchases continue to November to fill the $5500 of room in the TFSA. The remaining $3000 of XIU is purchased in the Taxable account in November and December. 

Contributions ($)Fund Purchases ($)
XBB inXIN inXSP inXSP inXIU inXIU in
MonthRRSPTFSATaxableRRSPRRSPRRSPTFSATFSATaxable
January19001900
February19001900
March19001900
April19001900
May19001500400
June19001900
July19001900
August11008001100800
September19008001100
October19001900
November90010009001000
December20002000
Total1440055003000570034005300160039003000
By Account1440055003000
By Fund5700340069006900

The scenario shown above assumes that you make a fund purchase each month and it turns out there are 16 in the year. At $10 per trade, that's a total of $160 per year in transaction fees, which isn't that bad, but is it optimal? 

In January and February we contributed $1900 each month to the RRSP and then made a trade each month to buy the XBB fund. We could have contributed $1900 cash in each month and then made a single purchase of $3800 of XBB in February. This would have saved us a $10 transaction fee. If we assume we make an average of 5% growth (interest plus gains), then we would have lost $8 ($1900 x 5% x 1 / 12) in interest in 1 month, but saved $10 on transaction fees. 

The breakeven minimum amount to purchase, assuming you are only going to delay 1 month, is $2400 ($10 x 12 / 1 / 5%). For two months it would be $1200 ($10 x 12 / 2 / 5%).  Our monthly contribution is $1900, so we should delay the purchase a month until we have $3800. So let's recast the investment timing for our example year using this rule of thumb. 

You can see the contributions of cash continue monthly, but the fund purchases are every other month. You can see there is a purchase of $1600 of XSP in September, which is under my $2400 guideline, but there is only $1600 of XSP in the TFSA account so that purchase has to go ahead. 


Contributions ($)Fund Purchases ($)
XBB inXIN inXSP inXSP inXIU inXIU in
MonthRRSPTFSATaxableRRSPRRSPRRSPTFSATFSATaxable
January1900
February19003800
March19001900
April1900
May19003400
June19002300
July1900
August11008003000
September19001600
October1900
November90010003900
December20003000
Total1440055003000570034005300160039003000
By Account
14400
5500
3000
By Fund
5700
3400
6900
6900

That's only 8 purchase transactions at a cost of $80.  Pretty easy to manage!


About Re-balancing

Re-balancing is about keeping the percentages of your asset classes in your total investments close to the portfolio you decided to use.  

Here's a decent article in wikipedia on the subject.

Remember the portfolio percentages in the example again. 


ClassETFPortfolio
Name(%)
BondXBB25
CanadianXIU30
USXSP30
InternationalXIN15
TOTAL100


What can happen over time is that one of the investment funds appreciates more than the others, thus resulting in a higher percentage of the total than when originally purchased. It may mean that you will have to sell some of one fund and buy some of another. You will likely sell some of the fund that has increased (the high one) and buy more of the one that has gone down (the low one). In effect you are buying low and selling high.

If you sell a fund in the RRSP and TFSA accounts it does not incur any taxes, but if you sell a fund in the Taxable account that has realized a gain this will incur some income tax. Since this is tax payable today, and not deferred until we retire, this is something we try to avoid. So remember to:

Try at all costs to avoid selling funds in the Taxable account that have an unrealized capital gain. 

An unrealized capital gain is a stock or fund that has increased in value, but you haven't sold it yet.  If you sell it, then you will realize the gain and have to pay taxes on the gain. 

In a situation where you have stocks and mutual funds in a Taxable account that have a significant gain it is best to put off selling those until you retire or when you are at a lower marginal tax rate.

If you are actively saving, you may be able to re-balance by just changing which funds to buy each year. If you are actively selling, such as in retirement, you may be able to re-balance by just changing which funds you sell each year. 

The math to do this re-balancing while buying or selling is quite simple, but with three or four different ETFs, three (or four) accounts and a priority system where the funds are only in some accounts, it becomes an accounting problem. The best solution to this is to use a spreadsheet.


A real T-shirt I own - a present from some colleagues.

If you haven't read the post on my portfolio re-balancing spreadsheet - Portfolio Live, then you should do that now. I will show an example using that spreadsheet on how to determine which funds to buy in order to keep the portfolio in balance. 

The table below are the basic inputs to the Portfolio Live spreadsheet and is the same inputs used as the example above. The fund rank is the order to place the funds into the accounts. They are ranked in based on the amount of taxable income generated from their yield, same as presented in post #9. There are no existing fund units owned (blank values under # of units). 



The spreadsheet determines which funds to buy in each account. You will note these values are the same as the example above.  


Let's look at an example where the existing holdings are out of balance to the portfolio. We only have two existing funds and one of them is in the wrong account. We have 200 shares of XBB ($6400 worth) in the RRSP account and 200 shares of XIN ($4900 worth) in the TFSA account. We put these share units in the current holdings and then enter the amount of cash we are going to invest, which just happens to be the same annual contribution amounts in the example above. 


The spreadsheet then calculates the buy and sells you need to make in each account to balance the portfolio.



Note that the XIN in the TFSA is to be sold and then bought in the RRSP and there is just a small purchase of XBB since we already own some of that. The total amount of purchases is $22,900 which is the amount of cash we specified to be invested.  

You can use the spreadsheet with no cash specified, to do a pure re-balance. You can also use the spreadsheet with negative cash specified to determine the re-balance while you are withdrawing funds during retirement.  


Other Resources

Canadian Couch Potato has a short post on the subject of optimal asset allocation decisions.

Dave Liggat's post that inspired me to write my Portfolio Live spreadsheet.


Future Posts
  • Optimal frequency of re-investment of cash dividends (or interest).
  • Impact on portfolio re-balancing of increasing Bond % over time.
  • Impact on portfolio re-balancing of increasing percentage of income saved over time. 

Disclaimer:  These posts are not fully comprehensive financial advice.  You should seek your own qualified investment, tax and legal advice.

No comments:

Post a Comment