Ok, so first you're doing some really picky selection there.
Dude, it’s a friggin’ spreadsheet, did you want me to list 999 different scenarios?
Go ahead and put in examples of net positive returns over 40 years but with periods of rising and falling equity prices.
See what happens. Can you find examples where option 2 is better? Sure. Are lots and lots of real-life scenarios where option 2 is worst? Yes.
I pulled examples from the Japanese stock market because the examples here are talking about 35yr loans at 1.5% and such. But it’s not like I couldn’t pull any number of examples from any of the other equity markets around the world.
And then you're assuming net returns of roughly 0% in 40 years. That's plain absurd. I mean, a 20 year period of averaging yearly 5% losses?
Really? You think it’s absurd? You shouldn’t. In the last 100 years, we have
four 10-year periods where real equity returns were negative, and one
20-year period with zero real returns. It’s not absurd at all.
15 year mortgage would have an annual payment around double that of the 35 year. Yours is only 1/3 more. The actual numbers for 1.5% mortgages would be 1.57mil and 2.98mil per year
No, my numbers are fine; in the 15yr example, 10mn is paid down, so it’s only a 30mn loan, not 40mn. I’ve rounded up for all three scenarios to factor in house repairs and such. You are right that I forgot the ‘tax break’, so Option 2 would have a slightly higher tax break. Whoopee, somehow I don’t think the Y8500 difference per month between option 2 and 3 changes all that much. It’s not 4 million in tax money, it’s less (the deduction is only on the balance of the loan, so as the loan balance goes down so does the deduction – but fine, let’s call it 4 million, and let’s call it 3 million for the 30mn 15yr loan. The 35yr loan pays 11 million in total interest, or 7 million even after the ‘major’ (LOL LOL LOL) 4 million in ‘free interest’. The 30mn 15yr loan pays 3.5 million, which is only half of your 35yr loan even ignoring the tax deduction for the 15yr loan..
I think the scenarios you picked are a bit far-fetched and would not happen in a properly diversified portfolio
What do you think the biggest draw-down (peak to trough) has been in the past 100 years for developed nation government bonds?
Third: there is no period of 35 years where the global economy has gone down.
If you’re thinking of returns based on economic growth you are seriously misguided. Ignore economic growth, because the correlation between real stock returns and economic growth is *
negative*.
I'll happily and comfortably stand by my numbers and scenarios as - at the very least - reasonable.