Instructions

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. 

 

Descriptions

Conditions and Assumptions

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.

 

Property Information

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.

 

Rental Information

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 Details

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.

 

Repayment Options

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.

 

Assumptions

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.