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/Spreadsheet72 remove_red_eyeDiscuss$25.00by ModellingGuyBand Mortgage Equity Capitalization or Atkerson format Ellwood
Incorporate and understand a financing's impact on value and compute the cap rate.467 remove_red_eyeDiscussRental Property Investment Model
A model for calculating returns on rental properties6,387 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.21 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.12 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 ratio587 remove_red_eyeDiscussDiscounted 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,771 remove_red_eye2 chat_bubbleCapital Budgetting Workbook
This model can be adapted to illustrate concepts related to capital budgeting analysis of projects216 remove_red_eyeDiscussfreeby Matt EvansDashboard for Budget Data
Detailed and extensive dashboard tool for monitoring and visualising your budgeting354 remove_red_eyeDiscussCommercial Real Estate Financial Model
Compute a Commercial Real Estate Valuation and Financial Feasibility of your Investment Project - excel model5,125 remove_red_eye3 chat_bubblefreeby Will Ferrigno
More tools from Amit Tandon
Cash Flow Waterfall Model
A cash flow model for Real Estate based on a waterfall structure7,863 remove_red_eye4 chat_bubblefreeby Amit TandonRental Property Investment Model
A model for calculating returns on rental properties6,387 remove_red_eye6 chat_bubblefreeby Amit TandonLeveraged Buyout LBO Model - DCF
A comprehensive LBO model in excel of business acquisition2,307 remove_red_eyeDiscussfreeby Amit Tandon
Any questions on Property Mortgage Calculator?
The user community and author are here to help. Go ahead!
