Mortgage Repayment Calculator VS Investment Returns Spreadsheet
Spreadsheet to calculate Mortgage Repayment VS Investment Return. Your money works for you.
*** Digital Download: Apple Numbers and Microsoft Excel Spreadsheet ***
When is the best time to make extra mortgage payments or to invest? Both scenarios are investing in your future and this worksheet will let you run the numbers and calculate which works best for you.
To use the chart simply enter the Original mortgage value, APR Mortgage Rate and the length of the amortization in months (full term of the mortgage) in Canada and the United States it is usually 300 months (25 Years) or 360 months (30 Years).
The monthly payment is calculated automatically and the chart is built to show a visual representation of the amount of time to pay off the loan. Then enter a value into each month that you wish to make an extra payment. Then enter the expected average investment return and your applicable tax rate to calculate the increase in wealth.
The spreadsheet has 4 sheets:
Summary - that compares three scenarios of repayment
A - Mortgage Repayment Plan - Using extra payments to pay down the mortgage faster then start investing
B - Investment Plan - Investing first and paying off the mortgage at a later date
C - Custom Plan - Enter month by month data of either extra mortgage payments or investment contributions to either track past performance or predict future outcomes
*** Enter Values into cells that have a WHITE background colour only***
This chart is good for loans up to 360 months in length and can accommodate variable extra payments each month to track a mortgage or predict how soon a mortgage can be paid off or how soon an investment will be worth more than the outstanding mortgage balance.
Check out the video demo here: