Mortgage payment Excel Calculator

Flexible, simple mortgage calculator in Excel/Spreadsheet

by ModellingGuy
Professional financial modeller focussing on quality, easy to use, forecasting and M&A cash flow modelsFollow 19

1 review85 views|Start the discussion!|Bookmark

Description
Want to know how much is left on your mortgage? Or planning to take out a mortgage but not sure what the right period length and interest rate might be? Or maybe you aren't sure how long to fix your mortgage for? Perhaps you want to compare an interest only to a repayment mortgage? Finally, maybe you want to know what the impact of overpaying on your mortgage might be on the length of your mortgage.

If you want to know the answer to any of these questions simply and easily then this is the right mortgage tool for you.

Outputs include:
1) Length of mortgage - both during the initial fixed period and thereafter; and after the affects of over-repayment
2) Amount of interest paid in both the initial interest period and post initial period
3) Amount of principal paid in both the initial interest and post initial interest periods
4) Amount overpaid in each period
5) Effective total amount paid for the property after accounting for the interest
6) Total effective mortgage term after taking into account overpayments
7) Effective additional payment for the property over and above the initial principal mortgage taken out (after factoring in all interest payments)
8) Mortgage balance over the life of the mortgage term
9) Interest paid in each year over the life of the mortgage term

Inputs include:
1) Mortgage type - either interest only or repayment
2) Mortgage drawdown date
3) Drawdown amount
4) Full mortgage term in years
5) Initial period (i.e. the first fixed interest period) of mortgage in years
6) Initial and post initial interest rates
7) Overpayment of the mortgage in each period

This business tool includes
1 excel tool