Overview

 The unique tool will help you to make the optimal decision and
pick the best mortgage. The model follows the best practice in financial
modelling and VBA coding. The tool features the following functionality:

·        
Comparison of five mortgages with unique terms
and flexible repayment profiles;

·        
Monthly payment calculator;

·        
Ranking of the mortgage options based on the multiple
criteria – first monthly payment, average monthly payment, equity IRR, Money
Multiple, equity distribution at exit, actual mortgage repayment period;

·        
Visual presentation of the loan and payment
segregation;

·        
Ability to understand how government support
will enhance the financing of the house acquisition;

·        
Switch between fixed interest rate and floating;

·        
Assessment of the different house prices and how
it affects the mortgage;

·        
Overpayment features to assess the impact on the
reduction in monthly payments or mortgage terms;

·        
The feasibility assessment of the cashback
function;

·        
Flexible functionality to assess the sales
option including related breakage fees;

·        
Ability to assess the equity proceeds after the
sales process, to examine the amount available for the future acquisitions;

·        
Optimization of the exit process – macro to
determine the optimal date to sell the house.

The model will be expanded in the future to incorporate more
complex aspects. Stay in touch to see the new features. Please contact me
directly if you have any questions or suggestions. After purchase, use private
messages if you need help in populating the models.

Reviews Add a review
No reviews yet

More From Samir Asadov

Browse our top rated business templates. See All
Mortgage Calculator
1,829
0
 The unique tool will help you to make the optimal decision and pick the best mortgage. The model follows the…
Event Table Allocator
2,562
0
In the modern work environment to benefit the most from the events (Christmas Dinner, team-building sessions, client conferences), organizers are…
Project Finance Model - Advanced Senior Debt
2,377
0
This project finance model is an advance version of the model you can find under the following link: https://marketplace.corporatefinanceinstitute.com/financial-model-templates/project-finance-model-base/ The…
Project Finance Model - Dynamic Excel Visualization
2,660
0
This project finance model is an advance version of the model you can find under the following link: https://marketplace.corporatefinanceinstitute.com/financial-model-templates/project-finance-model-base/ It…
Project Finance Model - Scenarios & Ratios & Timeline
2,896
0
This project finance model is an advanced version of the model you can find under the following link: https://www.eloquens.com/tool/yZ54Hr1A/finance/project-finance-models/project-financing-model-scenarios-ratios It…
Project Finance Model - Scenarios & Ratios
2,727
0
This project finance model is an advance version of the model you can find under the following link: https://www.eloquens.com/tool/XvxKFxl5/finance/project-finance-models/project-finance-model-unlimited-scenarios It…
See All