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 calculator
Flexible, simple mortgage calculator54 remove_red_eyeDiscuss$2.00by ModellingGuyBand Mortgage Equity Capitalization or Atkerson format Ellwood
Incorporate and understand a financing's impact on value and compute the cap rate.437 remove_red_eyeDiscussRental Property Investment Model
A model for calculating returns on rental properties5,702 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.17 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 ratio494 remove_red_eyeDiscussCalculate Effective Rent Spreadsheet
Determine effective rent of landlords and tenants while considering discount rates and uneven rent payments.1,822 remove_red_eye2 chat_bubbleDiscounted Cash Flow (DCF) Analysis with IRR and NPV
Several spreadsheets that can be used for the analysis of a real estate investment from various perspectives10,468 remove_red_eye2 chat_bubbleCapital Budgetting Workbook
This model can be adapted to illustrate concepts related to capital budgeting analysis of projects170 remove_red_eyeDiscussfreeby Matt EvansCommercial Real Estate Financial Model
Compute a Commercial Real Estate Valuation and Financial Feasibility of your Investment Project - excel model4,435 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,078 remove_red_eye4 chat_bubblefreeby Amit TandonRental Property Investment Model
A model for calculating returns on rental properties5,702 remove_red_eye6 chat_bubblefreeby Amit TandonLeveraged Buyout LBO Model - DCF
A comprehensive LBO model in excel of business acquisition2,082 remove_red_eyeDiscussfreeby Amit Tandon
Any questions on Property Mortgage Calculator?
The user community and author are here to help. Go ahead!
