Pro Forma Tool

Our Pro Forma Tool is designed to help craft developers in Canada evaluate the financial feasibility of their housing projects with ease. Complete the sections to determine your project's feasibility.

Crunch your Project Numbers

Rental Income

Monthly Rent: $0

Annual Rent: $0

Input the specifics for each unit included in your project. Include the number of each unit type, the area of each unit, and the rent per unit.

Unit Profile 1

Is Affordable

Type of unit:

Number of units:

Unit area (sq ft):

Rent per unit ($):

Storage Rent ($):

Parking Rent ($):

Monthly Rent:

Annual Rent:

Income Summary

GPI: $0

EGI: $0

NOI: $0

Total monthly income 12 months

Annual Gross Potential Income (GPI)

Your project’s maximum potential revenue assuming all units are occupied at the highest achievable rental rate.

Vacancy & Bad Debt Allowance

An estimate of how often and for how long units may remain vacant, expressed as a percentage of the GPI.

GPI $0Vacancy Rate 3%

GPI Vacancy

Effective Gross Income (EGI)

Effective gross income (EGI) is the Gross Potential Income plus other income minus vacancy.

Calculate Operating Expenses (OpEx)

EGI $0OpEx Rate 20%

EGI OpEx

Annual Net Operating Income (NOI)

The net operating income figure is a property's full income, minus the total operating expenses. This formula is typically used to quickly calculate the profitability of a particular investment.

Project Costs

Total Cost: $0

Land Cost

The cost of your land or land + existing building cost.

Enter lot value ($):

Hard Cost

Costs related to the physical construction of your project such as: labour, materials, utilities, landscaping, off-site improvements, etc.

$265/sq ftGross Floor Area 0 sq ft

$ / sq ft:

Soft Cost

Costs not directly related to the physical construction, but necessary to the development project. This includes costs such as pre-development studies, design, financing, legal and administrative expenses.

$60/sq ftGross Floor Area 0 sq ft

$ / sq ft:

Contingency

A reserve fund to cover unexpected costs during the project development.

Total Contingency ($):

Financing

Annual Debt Service: $0

DSCR: 0

Equity

Equity may be a downpayment in cash, land, or deferred fees.

Recommended: 5% of Project Cost for 5+ units or 25% of Project Cost for < 5 units.

Equity Rate %Project Cost $0

Project Total Cost Equity

Loan Amount

The total cost of your project not covered by equity. This is the amount you will borrow.

Monthly Debt Service

Annual Payment:$0

The amount you must repay each month on your loan.

Mortgage Calculator

Set Custom Loan Amount

Loan Amount ($):

Interest Rate (%):

Amortization Period (years):

Monthly payment:

Annual payment:

NOI / Annual Debt Service

Debt-Service-Coverage-Ratio (DSCR)

The amount of breathing room in your cash flow to cover your debts. Most banks will expect a DSCR of at least 1.25, or 1.1 for CMHC MLI Select.