Showing posts with label investment. Show all posts
Showing posts with label investment. Show all posts

Saturday, December 15, 2007

Free Money: ESPP


If your company is offering Employee Stock Purchase Plan (ESPP), then you have a money tree. It can give you an outrageous, guaranteed return rate.

ESPP is a plan where you pledge a percentage of your after-tax salary to be deducted every paycheck period during the plan's offering period ('offering' because you are offering your salary to the great company of yours).

At the end of the offering period, the collected money is used to buy the company's stocks at a discounted price. The discount rate is set in the plan and is applied to the lower stock price at the beginning and ending of the offering period. The exact stock pricing vary among plans; some use only the stock price at the end of the period.

My company's offerring period lasts for 3 months, and the lower stock price is purchased at a 5% discount. That means, if you sell it on the same day, it becomes a guaranteed rate of at least 5%. The exact return rate is calculated as thus:

Return rate
= profit/contribution
= (sale proceed - contribution) / contribution
= (purchased share * price per share - contribution) / contribution
= ((contribution / (price per share * (1 - discount rate))) * price per share) / contribution
= 1/(1 - discount rate) - 1

For me, it's 1/(1-.05) - 1 = 5.26%. Imagine that, my money grows 5.26% within 3 months! If you were to put the contribution in a savings account, you'd need to find one with an APY of 18.97% to get the same return rate!

So, let me just restate this amazing tidbit: 5% ESPP discount has the same return rate as a 18.97% APY savings account!

Look can really be deceiving. Without running the numbers, I wouldn't have figured out that the ho-hum, just so-so discount rate is actually an amazing 18.97% APY. Furthermore, had my company stopped being the cheap-ass they were and offered a 15% discount rate like many other companies, that would equal 71.22% APY with $500/month contribution.

I have a google spreadsheet that you can copy and start playing around with if you have a google account. To use it, simply replace the bolded fields with your numbers. The comparison is between putting $500/mo to the ESPP plan or letting it compound in a savings account. Unfortunately because I am not skilled in spreadsheet programming, you'd have to figure out the Savings Acount APR manually by trial-and-error: put in various figures until the difference is close to zero.

If you do not have a google account, you still can view it but not play with it.

The return rate calculated by the spreadsheet is actually the minimum guaranteed rate. If the the stock price is rising during the offering period, your return rate will be even higher to the point of being mind-boggling! If the stock price is dropping like a lead, you will still make the minimum guaranteed rate as long as your company is still traded.

But, but, surely, something this good must have a bunch of gotchas, right? Yes:

1. Some companies prevents this activity by putting a holding period: you have to wait for several days/weeks after the end of the offering period before you are allowed to sell the stocks.

This introduces risk. If the stock price drops before the holding period is over, you have to choose whether to keep the stocks or sell them at a loss. If you want to keep the stock, be mindful not to keep too many eggs in one basket because your income is already a big and significant egg in that basket (your job is an investment too!).

2. The reason some companies prevent this is because the spirit of ESPP is to help employees become owners. For me, this present an ethical dilemma, but I believe that I am not doing the company or any other employees any significant harm. Furthermore, if the company really wants to emphasize the ownership benefit, it can enforce a holding period. In the meantime, it is really a very low-hanging fruit that I simply has to take advantage of.

Anyway, don't be shy to share your numbers.

Friday, December 14, 2007

Mortgage After-Tax APR Comparison

Just want to drop a quick note that I have a spreadsheet that may help you answering that flummoxing question: should I invest or prepay.


Mortgage After-Tax APR Comparison

Invest or Pre-Pay the Mortgage?


Now I come to the point where many others have came upon: to invest or prepay my mortage?

Factoring in interest deduction, my after-tax mortgage interest rate is 3.7%. That's 3.7% guaranteed after-tax investment rate.

I need an investment vehicle that offers a before-interest-tax 5.16% APR to beat that. An equivalent investment vehicle delivering the same kind of rate guarantee is CD. Since CDs are usually advertised in APY with monthly compounding, the equivalent APY is 5.28%. A quick check at bankaholic.com showed only 7 banks offering CDs with higher APY.

The highest is offered by KeyDirect at 5.7% for 120 months (10 years). Unholy cow! But that is the longest CD term I've ever seen and is offered by a bank that I don't want to do business with any longer.

The next one is CountryWide's 5.45% but only for 3 months. Sounds good except that it needs a $10K initial deposit. But building up to $10K takes time and all the while the collected money will be sitting in lower-than-5.16%-APR accounts. The other CD offers do not seem good as well. So, it seems my mortgage gives me the highest guaranteed investment rate for now.






Let's go a riskier route: stock market (includes mutual funds). The tax rate for capital gain is 15%, so, the minimum APR to beat the mortgage's rate is 4.35%. If I invest in various low-expense-ratio index funds or ETFs like VFINX, VTI, SPY, my risk of not making more than 4.35% APR over the next 3-5 years (expecting a baby, see below) is very low. Investing it in stock market gives you the best bang for your time.

Yet, 36% of my income is already in stock market in the forms of 401k and IRA. For me putting extra money in the same basket just increases the risk needlessly. Furthermore, if we own the house, we will be less affected by a recession. That is the virtue of not putting all your eggs in one basket.

Readers who are still with me at this point would probably think, 'this guy is going to prepay'. I would have, but my better half, well, being better, she gives me a better argument.

'We are still young', she argued, 'what is youth without risk?'. We have no children yet. We can basically take as much risk as we want now. We can even be fools and go back to the 30K debt hole we came from without affecting any innocents.

I bought it. For better or worse, I liked the argument. Perhaps I'm just greedy instead of being young. For now, I am reducing the amount of pre-payment from $1500 to $1000/month. Over time, I'll move more and more to the stock market.

When our risk-equation changes, like when we have a baby, I will have to revisit this topic again.

UPDATE 2007-Dec-14: I have a spreadsheet that may help you answering that flummoxing question: should I invest or prepay.

Mortgage After-Tax APR Comparison Goggle spreadsheet.

----
Formulas:
Effective APR = APR * (1-TaxRate)
APR = Effective APR / (1-TaxRate)
APY = (1 + APR/q)^q - 1, where q is number of compounding per year.