Things are a little slow today at work so I've been daydreaming about buying a home again (used to own, but currently rent closer to work). Being the spreadsheet geek that I am, I ran the numbers on three scenarios and am really surprised by the results. Do these numbers look right to you guys or am I missing something in my analysis. The scenarios are 1-buy with traditional 80% mortgage, 2-save up and buy with cash, 3-rent forever. Here are the assumptions I'm using:
*5% return on invested savings
*60 yr total time frame
*Owning would allow for saving 631/mo with mortgage and 1105/mo when it's paid off
*Renting would allow for saving 1012/mo
*Renting and owning expenses would increase at the same rate, so I ignored that
*23K current savings (initial balance or downpayment depending on the scenario)
Buy with mortgage
| Mortgage |
Beginning Balance | 0 |
Years | 30 |
Monthly Deposits | 631 |
Ending Balance | 525,155.20 |
Rent until can pay with cash (assumes house costs 35K more than buying today)
| Rent | Own-no mortgage |
Beginning Balance | 23,000 | 45,026.89(157,145.67-150,000) |
Years | 10 | 20 |
Monthly Deposits | 1012 | 1105 |
Ending Balance | 95,026.89 | 576,494.25 |
Rent forever
| Mortgage |
Beginning Balance | 23,000 |
Years | 30 |
Monthly Deposits | 1012 |
Ending Balance | 945,003.86 |
**ETA Duh, after I posted I saw my error. I wouldn't be saving for 60yrs. When I cut that back to 30 yrs the numbers change a bit, but still interesting.
***Edited again because beginning balances weren't being included in the bottom 2 calcs