Input values in the white boxes.

When available, make selection from drop down list.

You may alter the regular payment provided by inputting a Custom Payment in the box provided.

You may enter a unique payment in the Mortgage Table tab.

Go to the Report tab to view the results of the calculator.

Go to Cash Flows tab to view annual cash flows.

**Time Horizon (Years)**

Input the length of time you wish to analyze using this model.

**Annual Inflation Rate**

Input the annual inflation rate

**Property Value Annual Growth Rate**

Input the rate at which property values will grow annually

**Annual Rental Increase**

Input the rate at which rent will increase annually

**Marginal Tax Rate**

Input the your marginal tax rate.

**Country**

Choose which country the mortgage will be borrowed in.

**Current Property Value**

Input the current market value of the property.

**Down Payment/Current Equity**

Input the amount of the down payment or the amount of the homeowner’s equity.

**Mortgage Insurance Fees**

Input the amount of mortgage insurance fees paid to the lender or insurance company to insure a high ratio mortgage if applicable.

**Finance Mortgage Insurance Fees**

Choose whether the mortgage insurance fees will be financed by adding the amount to the mortgage balance or not, if applicable.

**Suite Sq Ft % of Total Sq Ft**

Input the percentage amount of the total square feet of the home that the basement/secondary suite occupies.

**Monthly Rental Income**

Input the monthly rental income.

**Bad Debt Costs %**

Input the percentage of rent allowed for bad debts that are not collected.

**Vacancy (Lost Rent) Costs %**

Input the percentage of rent allowed for vacancies between tenants.

**Annual Insurance Costs**

Input the amount paid annually for house insurance.

**Annual Property Taxes**

Input the amount paid annually for property taxes.

**Annual Utilities**

Input the amount of utilities paid annually for the entire house.

**Annual Maintenance Costs**

Input the amount paid annually for maintenance costs.

**Annual Other Costs**

Input the amount paid annually for any other costs associated with ownership and maintenance of the house.

**Mortgage Balance**

This is the amount of the initial or current mortgage balance.

**Interest Rate Type**

Choose which type of interest rate your mortgage will have.

**Interest Rate**

Input the annual interest rate stated by the lender.

**Amortization**

Input the number of years that it will take to repay the mortgage.

**Payments per Year**

Choose how frequent you will make mortgage payments

**Payment**

This is the regular payment amount you will be pay according to the variables chosen.

**Custom Payment**

You may alter the regular payment by entering the desired payment amount in this box. Return to the default payment by entering a ZERO value.

**Skip a Payments per Year**

Input the number of skipped payments every year.

**Double Up Payment Amount**

Input the amount of each double up payment to be made. Enter “MAX” to automatically fully double up these payments.

**Double Ups per Year**

Input the number of double up payments made every year.

**Lump Sum Payment Amount**

Input the amount of the regular annual lump sum payment that will be made every year.

**Annual Percentage Increase**

Input the percentage amount that the regular payment will be increased by every year.

**Unique Payment**

Input the amount of each unique payment to be made only in the chosen year.

Fixed Rate in Canada are compounded semi-annually, all other rates types in USA and Canada are compounded at the payment frequency.

All calculations are made on the assumption that the year is divided equally by the amount of payments made per year.

Double up payment(s) are applied to the first payment(s) of the year.

Skips are applied on the final payment(s) of the year.

Lump Sum payments and Unique payments are applied to the final balance of a year.

Growth rates are applied at the end of the year.

Equity is calculated as the final property value (beginning value + annual growth) of the year less the ending balance of the mortgage (less all end of year payments), less any outstanding liabilities.

Taxes are paid at the end of each year, on the taxable income less the expected taxable deductions. Negative taxes are added to income on the assumption that the homeowner will have other sources of income to which the taxable losses can be applied. All tax effects are calculated at the marginal tax rate provided.

Expenses will grow annually at the rate of inflation, rent will grow annually at the rate of growth provided by the user.

This model allows for mortgage insurance fees to be included in the mortgage balance is the finance mortgage insurance fees option is selected.

All expenses and mortgage interest are assumed to be tax deductible expenses prorated by the proportion of the square feet that the basement/secondary suite occupy in the house.

All results are calculated based on the input variables provided by the user, and assumptions that are believed to be reasonable. UltimateCalculators.com does not make any express or implied warranties with respect to the information or results in connection to this, or any other calculator. UltimateCalculators.com will not be held liable for any losses or damages resulting from any errors or omissions in any information or results, or any action or decision made by users in reliance on any information or results. Please consult Instructions & Assumptions for further details.