Proforma Tool
Our Pro Forma Tool is designed to help craft developers 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.00
/Annual Rent: $0.00
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
Monthly Rent:
$0.00
Annual Rent:
$0.00
Income Summary
GPI: $0.00
/EGI: $0.00
/NOI: $0.00
Total monthly income 12 months
Total monthly income 12 months
Annual Gross Potential Income (GPI)
$0.00Your 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.
GPIVacancy Rate
GPI Vacancy
GPI Vacancy
Effective Gross Income (EGI)
$0.00Effective gross income (EGI) is the Gross Potential Income plus other income minus vacancy.
Calculate Operating Expenses (OpEx)
$0.00EGI OpEx
EGI OpEx
Annual Net Operating Income (NOI)
$0.00The 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.00
Land Cost
$0.00The cost of your land or land + existing building cost.
Hard Cost
$0.00Costs related to the physical construction of your project such as: labour, materials, utilities, landscaping, off-site improvements, etc.
$265.00/sq ftGross Floor Area (0)
Soft Cost
$0.00Costs 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.
$0.00/sq ftGross Floor Area (0)
Financing
Annual Debt Service: $0.00
/DCSR: 0
Equity
$0.00Equity 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.00)
Project Total Cost Equity
Project Total Cost Equity
Loan Amount
$0.00The total cost of your project not covered by equity. This is the amount you will borrow.
Monthly Debt Service
The amount you must repay each month on your loan.
NOI / Annual Debt Service
NOI / Annual Debt Service
Debt-Service-Coverage-Ratio (DCSR)
0The 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.