imported post
Rolo, awesome post!! I'll have to look for those books at the library... thanks for your recommedations.
I found part of your post intriguing in particular because I was looking over someone's reasoning behind one should pay off your mtg first even before any $ goes to investments... To be honest, I'm going to have to look it over again because at the time I didn't have much time. I'm trying to find the link but can't find it at the moment so I'll copy/paste at the end and I would love to her your response to the information when you get time because I was under the impression like you had said but we've only had our mtg since Jan. and this moneymgmt(?good name?) is becoming to be a hobby of mine too(wink). Hopefully, I'll find the link that I'll add later. The person who wrote it I believe his name is in the info.
p.s. My dh loves the PT Cruiser. I thought maybeyour site was the link but doesn't look like it...
The following is Copy/paste... not written by me... I would reference but still looking for it so will add when I find it:
Prepaying your mortgage vs. investing: the perennial decision. This material summarizes and extends a discussion about prepaying held on FIA mailing list during November of 2003.
The gold standard text for prepaying is "The Bankers Secret" by Marc Eisenson. It is likely to be available in your local library. The book is thick, but it's 90%+ tables. The material itself is only about 40 pages, and written at the 8th grade level. Computer users with a spreadsheet package can run out their own amortization table pretty easily, so there's no need to buy anything. Now, just make sure everyone avoids the "biweekly payment conversion" scam... ;-)
Carolyn spake: "I think that at some point you have to almost become obsessed with the goal of paying your mortgage off early."
Jonathan: Absolutely. And it's fun too. I still have the amortization tables we used.
And then this little bit popped in (again from Caroyln):
"I'm glad Penny Yunuba raised the point about fully funding your retirement accounts before paying off mortgages early. I absolutely, enthusiastically concur."
Jonathan: Augh!!!!!!!! This is conventional wisdom and in many cases is simply **not** the best thing to do. Everyone *must* run the numbers in order to determine the best thing for them. Please note that the discussion following applies only to US citizens considering prepaying their home mortgage. There are accounting reasons why this discussion does not apply to investment or business properties (although even then I'd assert you need to run the numbers out).
I too heard that "wisdom" about funding your retirement accounts before prepaying your mortgage. Being spreadsheet-savvy, I decided to model the situation and see what the reality actually was. Here is what I found. First off, some definitions and assumptions:
1) You can afford a building and want one enough to actually buy one.
2) You have arranged your financial affairs such that the mortgage is your only debt and you have an adequate (whatever that means to you and your family, if any) cushion already built up to stave off financial emergencies. If you have no cushion, this whole discussion is moot - go fund a minimal cushion first!
3) You have excess money that you can choose to either prepay your mortgage with or invest with each month. This amount is assumed to be the same each month to make the spreadsheet manageable. In reality, we found this amount to be highly variable, though there was seldom a month we didn't have some excess we could prepay with.
4) The measure of "wealth" is net worth. That is, increasing your net worth is the goal, *not* avoiding taxes. We'll come back to taxes. I think any YMOYLers who have thought about their personal cash-flow will agree with this definition (note 1). My definition is just a way of measuring relative value differences in the spreadsheet model, nothing more. Feel free to disagree that this is a valid discrimination method and contact me to discuss it.
So I set off to model the accumulation of net worth across time. I picked a period of 60 years to model for various reasons, none germane here. The real point is that it's more than 30 years a conventional mortgage can last. I did the modeling in Excel-97 and with the Analysis Toolpak installed for the financial functions (note 4). I modeled four possible scenarios:
1) Conventional wisdom (CW) is to put money into investments, not your mortgage, to preserve your tax deduction and earn compound interest on your investments.
2) No Invest (NI) is paying your mortgage off before you invest a single penny. The whole extra amount is sent in as a Regular Prepayment, to use Eisenson's terms.
3) Splitting the difference (50/50) - pay 50% of what you can invest into your mortgage to retire it early, and invest the rest.
4) Irregular prepayments (IP) is paying as many principle payments as you have money for each period. Unused "investment principle" carries over to the next period. Investments begin after mortgage pay off. This is an Irregular prepayment scheme as Eisenson would label it. Incidentally, this is the approach my wife and I took while prepaying our mortgage, and we are not sorry in the least, even though it can underperform some of the other models.
Then I ran the numbers. That is, I put a sheet together for each model. Each sheet calculates net worth across 720 months. I created another sheet to make comparisons and collect the data in one place to make graphing easy. Finally I created a chart page with a graph of all four options and a common place to change numbers and run scenarios from. That's the workbook associated with this file.
So let's discuss a few scenarios. The common elements of all the scenarios below will be the amount borrowed: $150,000; 30 year conventional mortgage, $0 down, average tax rate of 20% (see note 1 for the calculation), and a mortgage interest rate of 7%. This makes the principle and interest portion of a mortgage payment $997.95 per month. I'm also assuming there is $302.05 available to invest each month. As a point of comparison, these numbers represent the median values in my current housing market (12/2003 in the Midwest) and roughly equate to an annual income of $52,000 as the bankers calculation of acceptable income to support this amount of indebtedness (note 5). All the numbers below take place at month 360 - just when you'd have paid off the last mortgage payment under the conventional wisdom.
Consider for the moment you are considering the NI option vs. the CW option (this is the most radical choice you can make to many). Further assume that the rate earned on investments is 7% *pretax* and earnings are not taxed each year. If you follow CW, at 30 years your net worth is $688,540.27. If you follow NI, at 30 years your net worth is $511,897.14. I don't know about you, but the mutual funds in my tax deferred accounts are making nowhere close to 7%+ at the end of 2003.
Now, I picked 7% for the tax-deferred return precisely because it was a relatively high return (Treasury bonds are returning around 5% during 12/2003) and because it was close to the equivalency point (7.101%) between NI and CW scenarios. Here's a table with various investment rates/net worths to consider:
I-Rate CW NI 50/50 IP
3.000% $325,667.86 $420,082.81 $370,456.29 $422,468.13
4.000% $358,405.99 $440,774.37 $393,880.75 $443,494.19
5.000% $398,911.77 $463,517.49 $421,748.44 $466,589.76
6.000% $449,213.46 $488,537.40 $455,141.02 $491,977.49
6.825% $499,899.24 $511,070.10 $487,811.77 $514,822.20
7.000% $511,897.14 $516,085.42 $495,431.84 $519,904.45
8.000% $590,265.11 $546,442.06 $544,368.35 $550,645.67
9.000% $688,540.27 $579,920.55 $604,178.40 $584,506.62
10.00% $812,129.95 $616,870.68 $677,707.39 $621,827.72
11.00% $967,966.82 $657,683.30 $768,595.52 $662,986.97
12.00% $1,164,949.57 $702,795.19 $881,506.86 $708,404.96
13.00% $1,414,513.08 $752,694.63 $1,022,425.64 $758,550.59
14.00% $1,731,366.40 $807,927.62 $1,199,039.80 $813,944.61
15.00% $2,134,448.57 $869,104.89 $1,421,237.62 $875,166.40
16.00% $2,648,167.14 $936,909.69 $1,701,751.26 $942,861.97
17.00% $3,304,003.93 $1,012,106.67 $2,056,991.02 $1,017,749.48
I picked 3% to reflect the traditional inflation rate, and the rate at which conservative investors are making about now (end 2003) across their portfolios. Clearly prepaying makes sense before any investing at this rate. CW doesn't catch up to NI until 7.1%, as noted above. In fact, your best deal is the IP plan over the NI plan across all the rates in this example (note 2). Note the 50/50 option overtakes NI and IP after 8% as well. Finally at 14%, picked because it's exceedingly aggressive (note 3), but not out of the realm some brokers will try to sell you off at, now the CW and 50/50 start to look pretty good compared to NI and IP, though IP is still better than NI.
What's going on here? As you can see, *the more conservatively you invest, the more likely you are to benefit by prepaying!* It's not until you start taking serious risk (more than 8%) in the investment markets that you start to see the CW and 50/50 models start to pay off. As a YMOYLer, I think you have to be realistic about what you can get in the bond market. And by the way, that's the downfall of this model: assuming a steady rate of return on the investments and that your tax rate will remain the same.
Now, about those taxes. I chose to model with taking taxes into effect. If we go back to the 7% model and assume combined federal, state, and city income taxes average 20%, then the effective rate of the mortgage is in fact around 5.83%. It depends on how close you are to itemizing being better than the standard deduction without mortgage interest and several other variables. I never managed to see more than $0.25 tax return per $1 mortgage interest (note 1).
So I hope you're convinced that you *must* run the numbers when deciding between prepaying your mortgage and investing. As a rule of thumb, if you can make more than 1.5-2.0%+ over your mortgage rate on your total investment portfolio, then splitting 50/50 has a good chance of increasing your net worth faster than any of the other methods. And remember, that's 2%+ pretax. You'll have to increase that by your average investment tax rate if you're investing post-tax.
I'd be delighted to take any feedback you may have on this write-up or the workbook, especially if you find an error. Note that you may disagree with the ways I've handled the tax factor in the workbook. If so, change the sheets to suit your inclinations. But I'm not going to help you if you change the workbook formulas or VBA code! So do this *at your own risk*!
Note: Please read *ALL* the comments on the PlayTime sheet of the workbook before doing anything with it!
(Note 1) There are tax-phobes that will refuse to understand this definition because they "lose their deduction" and are so desperate to screw Uncle Sam that they do stupid things financially even though it's demonstrable to an 8 year old that the deduction is worth far less than freedom from debt (prepaying). But I digress. If you want to debate this point, we can. But before you get your e-mail client all fired up to send me mail, please consider the following scenario and do the math for your situation. You will need the current years tax forms, so it's best to consider this whole concept shortly after you file your taxes for the prior year.
First figure out how much mortgage interest you actually paid for the tax year. You ought to be able to just read this off your 1040 Schedule A. If you didn't itemize deductions, then you have **no excuse** for not prepaying - you aren't even using the mortgage deduction in the first place!
Next, run out your taxes as if you did not have the mortgage interest deduction. That is, pretend the house was already paid off and redo your taxes on that assumption. This may mean you take the standard deduction instead of itemizing; that's fine. Do what makes sense.
Now you should have three numbers:
1) The amount of mortgage interest you actually deducted, call it MI.
2) The amount of taxes you actually paid from your 1040, call it TP.
3) The amount of taxes your would pay if you did *not* deduct the interest, call it WP.
So make the following calculation: (WP - TP). This is the amount of tax you managed to avoid paying because you deducted your mortgage interest. (This is actually one amount the federal government directly subsidized your lifestyle by, but let's not get into political rants here.) If TP is greater than or equal WP, then something has been calculated wrong; go check your math again.
Now let's do the really interesting math. Calculate (WP - TP) divided by MI; this is the fraction of your mortgage dollar that you actually deducted. Let's call it PD, for Percent Deducted. The calculation result should be a fraction less than 1.0, for example 0.21, so convert it to a percent (multiply by 100 to get 21%). Again, if MI is less than (WP-TP) or if PD > 100%, you've got some math done incorrectly somewhere. When my marginal tax rate was 28%, the highest I ever saw PD was 25%. The *highest*; your numbers will vary because the tax rates have changed since I had a mortgage, among other things.
Let's put this in concrete experience though, because these numbers are rather abstract. In order to "earn" that interest deduction, you had to pay the mortgage holder MI dollars. You got back from the government PD*MI (or WP-TP) dollars. If your PD was 25%, you paid out a dollar to get back a quarter. If you didn't have your mortgage, you would have paid that quarter in taxes and had 75 cents left over in your pocket. Which would you rather have? 25 cents? Or 75 cents? Or rather, PD*MI or (1-PD)*MI? Remember, it's *your money* you went out an earned. Are you quite so tax-phobic now?
OK, if you're still not convinced by the math, go back and read the rest of this file before hitting send. ;-)
(Note 2) This is actually an anomaly related to the tax calculations from Eisensons's point of view. If you set taxes = 0.0%, you'll see that regular prepayments (the NI option) beats out irregular prepayments (IP plan) most every time.
(Note 3) For comparison, consider the average returns on a portfolio made up solely of:
Investment Return
Small Company Stocks 16.9%
Large Company Stocks 12.2%
Long Term Corp Bonds 6.2%
Long Term Govmt Bonds 5.8%
Intermed Trm Govmt Bnd 5.6%
US Treasury Bills 3.8%
Inflation 3.1%
Source: Ibbotson and Associates, SBBI 2003 Yearbook, pg. 33. Remember that return compensates for risk, so the more return, the more risk.
(Note 4) To turn on the Analysis Toolpak, make sure it's installed as part of your MS-Office installation. Then open up Excel-97, pull down on Tools | Add-ins and make sure all the Analysis Toolpak boxes are checked. Close Excel and then load the spreadsheet.
(Note 5) For the pedants among us, this is about $8,000 more than the median income for the USA in 2003, but pretty close to the median for my area.