I attached a modifiable spreadsheet showing the following exercise...
$500K mortgage
4% interest rate
$8000 per month to devote to mortgage or investing
5% investment return
After 30 years, plowing the extra $ into investments instead of mortgage yields a >$200K difference in favor of not paying off the mortgage. If you make it only a 4% return over 4 years it is still in favor of the investments. If you make it 8% or 10%, the differences are millions of dollars. If you think the odds are good the mortgage payment would be a better idea, you have to be forecasting stock returns approaching 1% over the next 30 years.
(too complicated to account for all the tax possibilities, but they are almost always in favor of not paying off the mortgage. Also apologize for anything weird when I converted it to an excel spreadsheet)
$500K mortgage
4% interest rate
$8000 per month to devote to mortgage or investing
5% investment return
After 30 years, plowing the extra $ into investments instead of mortgage yields a >$200K difference in favor of not paying off the mortgage. If you make it only a 4% return over 4 years it is still in favor of the investments. If you make it 8% or 10%, the differences are millions of dollars. If you think the odds are good the mortgage payment would be a better idea, you have to be forecasting stock returns approaching 1% over the next 30 years.
(too complicated to account for all the tax possibilities, but they are almost always in favor of not paying off the mortgage. Also apologize for anything weird when I converted it to an excel spreadsheet)
Attachments
Last edited: