User inputs are shaded in green Starting value of house $ House inflation rate (avg) 600,000 2.00%
Interest rate Term in years Principal Monthly payment Difference
$ $
6.38% 30 417,000 $ 2,602 $ $ 936,553 $ 320,129 $ 1,256,682 $ 8.00%
5.88% 15 417,000 3,491 889 628,341 628,341 1,256,682 8.00%
P&I payments $ Side fund payments $ Total of all payments $ Average net investment rate of return
Using 30 year mortgage plus side fund End of year values Mortgage Balance 1 $ 412,227 15 $ 323,548 30 $ Side fund $ 11,071 $ 307,713 $ 1,325,297 Existing inv account $ 450,360 $ 1,322,795 $ 4,196,128
Using 15 year mortgage plus side fund beginning in year 15 End of year values Mortgage Balance 1 $ 399,133 15 $ 30 $ Side fund $ $ 43,460 $ 839,563 Existing inv account $ 450,360 $ 1,322,795 $ 4,196,128
Difference between 30 yr & 15 yr mortgag No mortgage payments (15 yr pmt) to side fund only
End of year values
Mortgage Balance 1 $ 15 30 $ -
Side fund $ 43,460 $ 1,207,945 $ 5,202,523
*Existing inv account $ $ $ -
Difference between 30 yr & no mortgag
*Assume Existing investment account is used to payoff principal amount to achieve no mo
de fund Value of home Net Worth $ 612,000 $ 661,204 $ 807,521 $ 2,114,481 $ 1,086,817 $ 6,608,242
ginning in year 15 Value of home Net Worth $ 612,000 $ 663,227 $ 807,521 $ 2,173,776 $ 1,086,817 $ 6,122,508 485,734 7.9%
n 30 yr & 15 yr mortgage $
side fund only
Value of home Net Worth $ 612,000 $ 655,460 $ 807,521 $ 2,015,466 $ 1,086,817 $6,289,340 318,902 5.1%
een 30 yr & no mortgage $
mount to achieve no mortgage status.