Back to Tools
Investor Tools

Development Pro Forma

How to use /Enter your project cost and assumptions, and the value test and financing read update as you type. Your numbers stay on your device.

Sample numbersThis page opens with a sample project — type your own numbers over it. Reset brings the sample back.
$
$21,250
%
Acquisition Cost
Land plus closing costs.
$871,250
$2,736,000
$/sf
$820,800
%
$0

Use 0% when the project does not include a construction manager fee.

% hard
$0

Use 0% when the project does not include a developer fee credit.

% hard
Build Cost
Hard costs, soft costs, contingency, and modeled fees.
$3,556,800
Rent Entry
$3.01/sf
$

Total monthly parking income for the building.

$
$11,808
%
$70,848
%
%
As-Complete Value
$212,544 NOI at 4.50% cap.
$4,723,200
Select the social outcome path

Choose the affordability, energy efficiency, and accessibility outcomes that apply. The financing path updates in the live read.

Affordability
50 pts

Common entry path for small new-construction projects.

Energy Efficiency
50 pts

Common high-efficiency path for the model.

Accessibility
0 pts

No accessibility outcome selected.

Assumptions only. Final scoring, affordability levels, energy targets, accessibility treatment, premiums, and proceeds require lender and CMHC confirmation.

%

MLI Select take-out uses a 1.10x minimum debt coverage test.

1.10x

Automatically set by the selected MLI point tier.

50 yrs
Debt Test
Policy Cap
95%
Min DCR
1.10x
Capital Required
85.6% modeled loan-to-cost.
$638,880
Workable range/6.7% margin
Value Test

A $4.43M project worth $4.72M complete.

Completed value is above project cost by $295,150. The project is in range, but rents, cap rate, hard cost, and financing should be stress-tested before going deeper.

$4.43M
$4.72M
Cost to Build
Value When Done
+$295,150
6.7% yours
Completed Value
$4,723,200
Project Cost
$369,004 per unit
$4,428,050
Value Created
6.7% margin
+$295,150
Capital Required
$638,880
Capital Stack

Equity still required

$638,880
Capital Stack
Current debt/equity against the policy cap.
85.6% LTC
Debt 85.6%Equity 14.4%$417,477 gap
Project Cost
$4,428,050
Supportable Loan
Limited by DCR
$3,789,170
DCR Capacity
$3,789,170 before DCR binds
85.6%
Policy Cap
$4,206,648
95%
Capital Requirement
$638,880
DCR Buffer
None
MLI Select Path

Points unlock the amortization path

Points unlock financing

100 modeled points

100 pts unlocks 95% LTC with a 50-year amortization.

95%LTC cap
50 yrAmort.
1.10xDCR
050 pts / 40 yr70 pts / 45 yr100 pts / 50 yr
Affordability
50 pts
10% affordable
Energy
50 pts
50 pts energy
Accessibility
0 pts
Not modeled
Development Return

What the capital is buying

Cash flow + paydown + 3% appreciation
Yield on Cost
4.80%

NOI $212,544

Value Gap
+$295,150

6.7% margin

Return on Capital
28.90%

$184,639 modeled annual benefit

Effective Capital
$638,880

14.4% of project cost

Cap-Rate Sensitivity

Completed value at common exit caps

Click a row to model it
What this means for you

$638,880 of modeled capital controls a modeled $4,723,200 completed asset.

The current read is limited by DCR; that is the next assumption to test. The project is in range, but rents, cap rate, hard cost, and financing should be stress-tested before going deeper.

Items to Confirm1

Supportable loan is below the 95% target LTC. Check NOI, DCR, rate, amortization, and completed value.

Model Note

MLI Select points are modeled through affordability, energy efficiency, and accessibility. Proceeds remain subject to lender review and CMHC approval.