How to Calculate Mortgage

You will typically purchase an investment property with the aid of one or more mortgage loans. You give the lender a lien against the property and the lender gives you a mortgage loan. The lender can be a bank, insurance company, the property seller, or even a private third party. You can have more than one mortgage, called first mortgage, second, etc.

The parties can structure a mortgage loan in any of several ways. For example, you might pay interest only for a period of time, then the entire balance; interest only followed by amortizing principal and interest payments; amortizing payments for a time followed by an early payoff or "balloon"; or fixed principal payments plus interest. By far the most common is the loan that fully amortizes using a fixed periodic payment (combining interest and principal) over a specified time. Your home mortgage is probably just such a loan. Let's work now with the typical loan, which is fully amortized through the use of monthly payments of principal and interest.

Note that Canadian mortgages use a different compounding than mortgages in the US. Find more in this article: Differences Between American and Canadian Mortgage Calculation

Zilculator helps real estate professionals calculate mortgage payments easily. Never use a spreadsheet again! Analyze your own property or create investment reports for your clients.

• Professional-grade branded investment reports
• Loading data from MLS^®, Zillow^®, and Rentometer Pro^®
• Sales and Rental comps

Create your report in 2 minutes

Excel Spreadsheet Example

We prepared a simple example of mortgage payment calculation in an excel spreadsheet file. You can download the file, input your own numbers and calculate results in no time. The only thing we ask in return is for you to like our facebook page or follow us on twitter.