Originally published: 29/06/2016 08:36
Publication number: ELQ-73613-1
View all versions & Certificate
Publication number: ELQ-73613-1
View all versions & Certificate
Property Mortgage Calculator
Model for calculating and tracking mortgage repayments
by Amit TandonExcel & VBA, Promoter - GlobaliConnect
Further information
To calculate key elements of a propert yprovide a comprehensive payment schedule
Relevant for property mortgages.
Easily adaptable to a variety of mortgage arrangements, including:
- Periodical, annual and adhoc repayments
- Accelerated weekly/bi-weekly payments
- Fixed rate and adjustable rate mortgages.
Reviews
People using this tool also downloaded
Mortgage payment Excel Calculator
Flexible, simple mortgage calculator in Excel/Spreadsheet60 remove_red_eyeDiscuss$25.00by ModellingGuyReal Estate - Property Acquisition Excel Model Template
Complete financial model for purchasing, holding, and selling all investment property types.72 remove_red_eyeDiscussBand Mortgage Equity Capitalization or Atkerson format Ellwood
Incorporate and understand a financing's impact on value and compute the cap rate.405 remove_red_eyeDiscussRental Property Investment Model
A model for calculating returns on rental properties6,054 remove_red_eye6 chat_bubblefreeby Amit TandonHow To Structure A Deal With A Seller To Make Finding A Buyer A Breeze
Joe Crump explains how to structure a deal that would be highly attractive to the potential buyer.27 remove_red_eyeDiscussfreeby Joe CrumpWhat's The Best Way To Structure Insurance In Different Deals?
Joe Crumps explains the best ways of structuring insurance for different deals.20 remove_red_eyeDiscussfreeby Joe CrumpSynthetic Rating & Cost of Debt
Allows you to estimate a rating and a cost of debt for your company from the firm's interest coverage ratio607 remove_red_eyeDiscussCapital Budgetting Workbook
This model can be adapted to illustrate concepts related to capital budgeting analysis of projects198 remove_red_eyeDiscussfreeby Matt EvansDiscounted Cash Flow (DCF) Analysis with IRR and NPV
Several spreadsheets that can be used for the analysis of a real estate investment from various perspectives11,032 remove_red_eye2 chat_bubbleCommercial Real Estate Financial Model
Compute a Commercial Real Estate Valuation and Financial Feasibility of your Investment Project - excel model4,611 remove_red_eye3 chat_bubblefreeby Will Ferrigno
More tools from Amit Tandon
Rental Property Investment Model
A model for calculating returns on rental properties6,054 remove_red_eye6 chat_bubblefreeby Amit TandonCash Flow Waterfall Model
A cash flow model for Real Estate based on a waterfall structure7,427 remove_red_eye4 chat_bubblefreeby Amit TandonLeveraged Buyout LBO Model - DCF
A comprehensive LBO model in excel of business acquisition2,008 remove_red_eyeDiscussfreeby Amit Tandon
Any questions on Property Mortgage Calculator?
The user community and author are here to help. Go ahead!
