
Last version published: 19/10/2018 15:58
Publication number: ELQ-80461-4
View all versions & Certificate

Mortgage payment Excel Calculator
Flexible, simple mortgage calculator in Excel/Spreadsheet
Further information
To allow the user to assess the impact of different mortgages
When assessing different mortgage options. Works particularly well for fixed term mortgages
Adaptable but not optimal for variable mortgage - lacks flexibility to change interest rates every month -> instead it's limited just to an initial fixed interest period and an assumed rate thereafter
Reviews
Write a review
People using this Best Practice also downloaded
More Best Practices from ModellingGuy
Personal budget Excel Model
Personal budget tool for tracking spending, setting budgets and analysing spending habits1,1801add_shopping_cart$25.00by ModellingGuy
WACC (Weighted Average Cost of Capital) Excel Calculator
WACC calculation template to help the user think about all of the components of their WACC calculation895Discussadd_shopping_cart$15.00by ModellingGuy
Solar Farm Investment Excel Model Template
Solar farm investment assessment model in Excel448Discussadd_shopping_cart$40.00by ModellingGuy
Wind Farm Investment Excel Model
Wind farm investment assessment model in Excel431Discussadd_shopping_cart$45.00by ModellingGuy
Acquisition Planning Excel Model Template
Acquisition planning model for up to 10 bolt on acquisitions (assumes that you already own the platform asset)3742add_shopping_cart$90.00by ModellingGuy
Anaerobic Digestion Plant Excel Model
Anaerobic digestion plant investment assessment model364Discussadd_shopping_cart$40.00by ModellingGuy
Platform & Bolt on Acquisition Planning Excel Model Template
Acquisition planning model including the initial purchase of a platform asset and up to 10 bolt on acquisitions314Discussadd_shopping_cart$100.00by ModellingGuy
Generic forecast financial Excel Model Template
Generic forecasting model including valuation calculations288Discussadd_shopping_cart$45.00by ModellingGuy
Simple three statement Excel cash flow model
Simple three statement (cash flow, Balance Sheet and Income statement) forecasting model & valuation550Discussadd_shopping_cart$30.00by ModellingGuy
Basic CRM system Excel Model
Simple CRM system for tracking your team/sales contacts and leads330Discussadd_shopping_cart$25.00by ModellingGuy
The Complete Valuation Templates Bundle
This bundle of valuation templates offers a variety of corporate caluculations.292Discussadd_shopping_cart$85.00by ModellingGuy
Valuation - Best Practice Template
Valuation is both an art and a science. This template guides the user to consider multiple ways to value their company48Discussadd_shopping_cart$50.00by ModellingGuy
Any questions on Mortgage Payment Excel Calculator?
The user community and author are here to help. Go ahead!