tools: March 2008 Archives


Investment Spreadsheet - Part 3

| | Comments (0) | TrackBacks (2)
Spreadsheet Goodness

This is part 3 of a 3-part series.

Download the spreadsheet as:

In parts 1 and 2, we looked at retirement and taxable accounts. Now let's really dig deep into the rabbit hole.

Non-deductible IRAs

Say you have the option to put money in a non-deductible IRA? Is that the better option than putting it in a taxable account? Non-deductible IRAs defer taxes on growth until withdrawal with qualified capital gains/dividends converted to regular income.



The ending $29K number is less than holding taxable index funds. The only case this would make sense is for REITs, Bonds or high-turnover stock picking.

Variable Annuities

Variable annuities act just like non-deductible IRAs. You can treat the two the same except for two differences. (1) No limits on contributions. (2) It uses a nominal insurance contract to provide tax deferred growth which requires extra expenses (mortality risk expense) to pay for the insurance. Now if you called up Vanguard directly to open a VA, they would charge you a 0.30% M/E in addition to their standard fund expenses. (Other companies offering low-cost VAs include Fidelity at 0.25% and Jefferson Mutual at a fixed $240/year.) In this case, we modify the return from 10% to 9.70%.



The ending number is just a tad below a taxable account holding a diversified index portfolio so I would not use a VA to hold any investment that has a significant amount of qualified gains. On the other hand, if you have used up all money in your 401K/IRA/Roth IRA/HSA, using a VA to hold Bonds and REITs may produce better results than forcing other high yields into taxable. From these numbers, it does not "seem" like the complete ripoff people constantly say VAs are.

Variable Annuities Part 2

Unfortunately, low-cost VAs are not the norm in the industry. The typical insurance company will charge M/E of 0.75% to 2%. Let's use 1.25% as the average and see what happens.



This number is just slightly higher than the 100% income rate taxable option. Great, you saved on taxes -- too bad all the tax savings went to the insurance company. (Politically/economically, would it be better for an insurance company to earn profits versus the government collecting taxes? Well that's a totally different discussion.)

There are specific instances where a high-cost VA can provide some interesting benefits. For example, if you can't get life insurance due to health problems, some companies offer a death benefit rider to their VAs which may give you enough coverage for funeral expenses and a bit of inheritance tax.

Permanent Insurance: Whole Life, Universal Life, Variable Universal Life

Now let's kick this spreadsheet into high gear. Suppose you have an agent hot on your heels to sell you some type of permanent life insurance policy. First, if you don't max out your 401K/IRA/Roth IRA/HSA, there's no need to consider -- get term life and invest the difference. But say you do that already, you meet your desired allocation target in low tax-drag taxable accounts and you still have plenty of money to invest. Before we start popping numbers into our spreadsheet, we must look through a prospectus with a fine-toothed comb. From reading through a Western Reserve Variable Universal Life (VUL) prospective, I extracted out the following costs:
  • Sales Load
    • 6% for policies $0-$250K, years 1-10
    • 2.5% for policies $0-$250K, years 11+
    • 3% for policies $250K-$500K, years 1-10
    • 2.5% for policies $250-$500K, years 11+
    • 0% for policies $500K+
  • Standard Unit Charge
    • 0.096% of policy face value, years 1-10
    • 0%, years 11+
  • M/E
    • 0.75% years 1-10
    • 0.60% years 11-15
    • 0.30% years 16-20
    • 0% years 21+
  • Average fund expense ratio: 0.75% (+0.50% higher than Vanguard funds)
  • Cost of insurance: we will ignore this component for simplicity purposes -- the assumption here is you would pay this cost through term coverage also
With this in place, we begin with target premium numbers. Target premium is the amount the insurance company believes to be adequate to fund the policy. For a mid-30's non-smoker, the target premium looks to be about 0.70% of the policy face value. We will add the Sales Load and Standard Unit Charge to the W/D (withdrawal) column to simulate the charges.

100K VUL -- Target Premium



If tax rates stay the same, the 100K VUL will never catch up to the taxable portfolio. Now we are in historically low tax rates -- especially for long term capital gains and qualified dividends. In what kind of tax environment would this policy catch up after 30 years? So we go over to the Taxable Tax Rate cell and slowly increase the number. Right about 30% is when the two 30 year numbers match ...

... With major caveat. The "tax free" benefit of permanent insurance comes in the form of loans against the policy. At the time of passing, the death benefit payout pays off the loan leaving the remainder for your heirs. This means if you "borrow" money from your policy, it must remain in force or otherwise a total disaster occurs -- all money borrowed immediately gets converted to taxable income! So in effect, you can only tap some percentage of your policy for your own use with. In this case, I've randomly guessed 80% as the number.

250K VUL -- Target Premium



With lower sales load starting at the 250K threshold, this improves the VUL performance by ~3% over the full sales load but still not a very enticing option.

500K VUL -- Target Premium



With no sales load, this policy's total cash value almost matches the taxable portfolio after 30 years.

100K VUL -- 7-pay

For almost everybody, insurance is an absolutely horrible investment vehicle. However, there is a small subset that might be able to benefit from it. The Standard Unit Charge appears to be a fixed amount per year. To make it a smaller percentage, put more money in. For a mid-30's non-smoker, the quote I received says the IRS will allow annual contributions up to about 3.5% of policy face for 7 years. (This is called 7-pay because you fully fund your policy in 7 years.)



In this calculation, we bumped up the Max Borrow amount to 90% due to the larger CashValue:PolicyFace ratio.We see the 100K VUL funded at 7-pay limits catches up to a taxable portfolio after 30 years versus never at the target premiums.

250K VUL -- 7-pay



Break even at 17 years.

500K VUL -- 7-pay



Getting rid of the sales load has brought break even point to about 6.5 years. Sounds like a viable option -- assuming:

  • you max out all traditional retirement vehicles 401Ks, IRAs, HSAs, etc.
  • you have a portfolio of tax-efficient investments in taxable
  • you have a big emergency fund to avoid tapping into the policy early (surrender charges + losing the tax benefits)
  • you will have plenty of money in retirement so you can keep the policy in force
  • you don't need to tap all the money and will leave ~20% of the policy's cash value as death benefit for your heirs
This is the type of investment you might carefully consider if you are investing at 40K-50K annually (90K-100K for a couple), can guarantee that investment stream for the next 7 years and can live with the limitations. Obviously, this is beyond the realm of most mortals as the median household income in this country is 50K. Who has that much money after taxes and expenses? This is the reason why VULs are commonly referred to as retirement plans for the rich.

Final Words

Remember all numbers and projections I showed here are mere samples. Don't come away from these articles with the idea that X is always better than Y. It will always be up to you to do due diligence on your own situation and options. Research, analysis and critical thinking -- use your brain and it will be your most important tool to evaluate investments. Download and have at it.



Investment Spreadsheet - Part 2

| | Comments (0) | TrackBacks (4)
Spreadsheet Goodness

This is part 2 of a 3-part series.

Download the spreadsheet as:

Previously, we looked at samples of the usual assortment of retirement accounts. The standard retirement options are actually the easiest model since the math behind the taxes is straightforward -- either apply taxes before, after or never. Now let's look at taxable investments.

401K versus Taxable Index funds

I have seen the question asked before -- my employer does not offer matching, should I instead put my money into taxable investments and pay 15% tax on gains? Well head over to the Taxable section and give it a test. Now we have another variable to look at. Yr Distrib is the portion of gains that are distributed every year as a taxable event. For example, if you own a diversified portfolio with an average 2% dividend yield and 0.5% turnover, that would be a 25% yearly distribution based on a 10% annual return (2.5 / 10 = .25). We then put tax as 15% long-term capital gains + dividends, 25% regular income, 5% state income for a total of 22.5% as the effective tax rate.



At $30.5K after taxes, it's quite a beat-down from 401Ks. For a taxable account to break even, income tax rates would have increase up to 44% ((54666-30581)/54666) after you stop contributing while LTCG/QDIV rates remained constant.

Taxable Accounts: Growth Index Funds

Let's say you put decided to put everything into just Growth Index funds where average yields+turnover is about 5%? Does that improve the situation?



About 4.7% better -- certainly some potential for splitting assets across low yield and high yield categories if you invest more than the 401K+Roth IRA annual limits.

Taxable Accounts: Systems Trading

What if you prefer system trading where you turnover your portfolio every year? (Examples: Magic Formula, Dogs of the Dow, etc.)



Looks to be a 11%+ drag compared to the growth index option, 7%+ compared to total stock indexes. Do systems trading under tax-advantaged accounts if possible.

Taxable Accounts: Income Tax Rate

What if we have taxable investments/strategies at regular income tax rates -- say bonds or day trading. (For this exercise to isolate the tax consequences, assume bonds return 10%.)



Ouch, quite a big tax hit. We just went from $38K for 401Ks/Roth IRAs to $32K for Growth Index Funds to $24K in this case. Absolutely the top priority for sheltering under some type of retirement account (or to avoid completely in the case of day trading).

Taxable Accounts: REITs

With REITs, the yearly dividend distributions are taxed at income rates. However, the capital gains are at qualified rates. To get a close projection, set the yearly distribution to 40% (4% yield / 10% total return = 40%) and the default tax rate to 30%. At year 20, set yearly distribution to 0% (assume you sell before the big end of year distributions) and then the tax rate to 20%.



At these tax rates, it's about par with systems trading tax drag. At higher tax rates, the impact will be higher.

Taxable Accounts: Different Tax Rates?

Something to keep in mind -- we have historically low LTCG/QDIV tax rates. LTCG rates used to be 28% and there was no concept of QDIVs. And from the rumblings, it's possible qualified gains might have to be bumped up to 20% or 25% as part of fixing the AMT package. We are also at historic low dividend yields -- before the 90s boom period, 4%-4.5% was the average yield. Let's see what happens when we change these parameters.



So investments in an 80's like environment incur a 9% tax drag compared to the tax rates today.

Taxable Accounts: Cost Basis

One last variable to look at. Suppose you invested $5000 over the years and it has grown to $10,000 now. In addition, there has been about $1,000 in taxable distributions. So to account for only $4,000 of the starting balance being taxable, we would enter $6,000 in the Cost Basis field.



To be continued in part 3 (variable annuities, variable universal life) ...


About this Archive

This page is a archive of entries in the tools category from March 2008.

tools: February 2008 is the previous archive.

Find recent content on the main index or look in the archives to find all content.

March 2008: Monthly Archives

Pages

Powered by Movable Type 4.1