How to Build a Commercial Real Estate Development Pro Forma in Canada

1. Define the decision and version

State whether the model supports an initial site screen, land offer, condition waiver, rezoning decision, lender discussion, joint venture or construction start. Record the author, review date, currency, tax treatment, measurement units and scenario name.

Do not let one workbook silently serve every purpose. A preliminary acquisition screen and a lender-ready draw model require different evidence, detail and review.

• Decision and decision-maker
• Parcel and ownership perimeter
• Concept and planning status
• Effective date and evidence cut-off
• Base, downside and upside version

2. Build the parcel and entitlement case first

Tie the model to legal parcels, registered interests, access, current land use, policy, proposed use, density, height, parking, setbacks, environmental constraints and approval sequence. Gross site area is not automatically developable area.

Treat unapproved density and use as scenarios. Planning professionals and the approving authority determine the actual application path; a spreadsheet cannot establish permission.

• Legal area and net developable area
• Current and proposed rights
• Road, utility and dedication effects
• Approval sequence and appeal risk
• Conditions, securities and agreements

3. Reconcile gross, rentable and sellable area

Create an area schedule from site area through gross floor area to rentable, usable or saleable area. Document efficiency, common areas, parking, loading, mechanical space and exclusions.

A small efficiency change can affect both revenue and cost. Keep every area measure named and avoid applying a revenue rate to one denominator and a cost rate to another without a visible reconciliation.

4. Source the completed-project value

Build gross development value from the project's expected disposition or stabilized-income path. For sales, show units or area, price, absorption, incentives and closing costs. For retained income, build occupancy, rents, recoveries, operating costs, stabilization and an independently supportable exit-value scenario.

Label brokerage evidence, owner assumptions, third-party reports and appraisals separately. Commercially can coordinate market evidence but does not provide an appraisal through this guide or calculator.

5. Separate hard construction from site delivery

Hard costs can include building structure, envelope, systems, interiors, contractor requirements and construction contingency. Site work and servicing can include demolition, grading, remediation, roads, utility extensions, stormwater, landscaping and external works.

Statistics Canada's Building Construction Price Index measures contractor-price change for selected new buildings, but its technical guide excludes items such as land, design, land development and real-estate fees. Use it as context, not a parcel-specific construction quote.

6. Capture soft costs and professional scope

Build a discipline-level budget for architecture, planning, civil, structural, mechanical, electrical, environmental, geotechnical, survey, legal, accounting, appraisal, insurance, project management and other required work.

Tie allowances to scope, stage, tax treatment and escalation. A percentage placeholder can support an early screen but should be replaced as the design and consultant team define the work.

7. Trace fees, levies and government charges

Identify application fees, permits, inspections, off-site levies, local improvements, utility charges, securities and agreement obligations using the correct authority, bylaw, rate, effective date and triggering event.

Municipal charges are not interchangeable across jurisdictions or sites. Confirm current estimates with the authority and qualified project advisors before a land condition is waived or a budget is relied upon.

8. Model financing, carry and time

A development model should recognize the timing of deposits, land closing, design, approvals, construction draws, interest, lender fees, equity, taxes, insurance, lease-up and sale proceeds. Simple totals can conceal a cash shortfall or interest exposure.

For an initial screen, keep any simplified financing allowance clearly labelled. Before capital is committed, use a period-by-period cash flow reviewed against actual lender terms and project timing.

9. Keep contingency and escalation visible

Separate design contingency, construction contingency, escalation and owner reserve where those concepts differ. Record the base, percentage, duration and reason for each amount.

Do not use contingency to hide known omitted scope. Move identified work into its proper budget category and retain contingency for uncertainty that remains.

10. Define the required return

State whether the decision uses profit on cost, profit on revenue, margin, internal rate of return, equity multiple or another measure. These metrics are not equivalent.

The required return belongs to the developer, investor and capital stack. Commercially does not publish or recommend a universal profit threshold; the calculator applies only the rate entered by its user.

11. Model phasing, absorption and exit

For multi-phase or lease-up projects, show when each phase consumes land, infrastructure and capital and when revenue becomes available. Reflect downtime, tenant inducements, commissions, marketing, closing and unsold or vacant inventory.

Keep the exit assumption consistent with the ownership plan. A project sold on completion, sold after stabilization and held long term do not share the same cash-flow or valuation logic.

12. Run sensitivities that can change the land decision

Test the variables that could reverse the decision: revenue, rent, cap rate, area efficiency, hard cost, servicing, levy, interest rate, approval time, construction duration, lease-up and required return.

Show changes one at a time and in combined downside cases. A single base case can appear precise while concealing the dependency that actually controls the residual.

13. Control sources, review and limitations

Give every material assumption a source, effective date, owner, status and next verification action. Reconcile revisions rather than overwriting them without a record.

Commercially can coordinate commercial-property search, market evidence and transaction process. Qualified planning, design, engineering, environmental, construction, appraisal, lending, tax and legal professionals control their estimates, opinions, approvals and advice. This framework is not a valuation, construction estimate, lender model or development approval.