Property development pro forma: connect the budget, cash and outcome

Start with the decision and the forecast period

In US real estate discussions, a request for the pro forma usually means the projected financial case, but the intended contents still need agreement. A construction lender, an equity partner and a development manager may each need a different view. State the asset, proposed work, ownership interest, currency, reporting date and decision the model supports. Specify whether it ends at completion, sell-out, refinancing or a later disposal.

The Office of the Comptroller of the Currency discusses pro forma projections within its commercial real estate lending guidance and expects the assumptions to be assessed against the project and market. Its context is bank supervision, not a universal developer template. For your own brief, identify the evidence needed to make each major forecast credible and who will update it when the project changes.

Sources: Office of the Comptroller of the Currency: Comptroller's Handbook: Commercial Real Estate Lending, version 2.0

Build a small set of connected schedules

Start with quantities: units, areas and the uses within the scheme. Connect those quantities to prices, rents and construction scope. A budget built from an obsolete design may reconcile mathematically while describing the wrong project. Give each schedule a version and retain the bridge from the design to the financial assumptions.

Separate the development budget from the operating forecast. Construction expenditure creates or changes the asset; operating income describes what the completed property may earn. For a for-sale project, model sales contracts and collections. For a retained property, include lease-up, recurring operating costs, capital expenditure and the eventual exit or refinance. Do not treat an estimated completed value as a cash receipt unless the strategy includes a transaction that produces it.

Reconcile a simple sources-and-uses example

Consider an invented for-sale project in US dollars. Land costs $4m, construction $10m, professional and project fees $2m, contingency $1m, and financing charges $1m. Total budgeted uses are $18m. Assume these include every project use for this simplified example, with no selling costs, tax or other adjustments. Proposed funding comprises $7m equity and $11m debt principal. These are example amounts, not suggested loan terms.

Sources equal uses at $18m, but the funding is not revenue. Suppose all units are sold and collected for $23m after development, with no earlier sales receipts. On the stated cost basis, project surplus after the budgeted financing charges is $5m. Repaying the $11m debt principal leaves $12m for equity, comprising the original $7m contribution plus $5m profit. Subtracting the principal again in the project profit calculation would double-count the financing.

Check the cash bridge behind the totals

Place the same $18m of uses into three development periods: $6m, $8m and $4m. One arithmetically balanced funding schedule contributes equity of $6m, $1m and zero, and draws debt principal of zero, $7m and $4m. Each period closes at zero before sales. The fourth period collects $23m, repays $11m debt principal and distributes $12m. This demonstrates the links between schedules; it does not establish that a lender would fund those uses or accept those dates.

If $2m of the second-period debt draw becomes unavailable until the third period, the aggregate sources still total $18m. Nevertheless, the second period has a $2m gap unless another available source or a changed payment schedule covers it. A balanced total therefore needs a period-by-period availability check. Keep undrawn commitments distinct from cash already received.

Label results so different readers can compare them

For the worked example, the $5m surplus is 27.78% of the $18m stated cost base and 21.74% of $23m sales receipts. The $12m equity distribution divided by the $7m contribution is approximately 1.714 times. None of these ratios accounts for the elapsed time. An IRR requires the actual timing of equity contributions and distributions, and an NPV requires an explicit discount rate.

For an income-producing property, state the operating-income definition before showing a capitalisation rate or debt-coverage measure. An operating forecast, an estimated property value and cash distributable to investors answer different questions. Keep an assessed value's basis and date visible. Do not relabel a developer's sales or rent assumption as an independent appraisal.

Make the next review easier

Present the base case with the most important inputs, unresolved conditions and changes since the prior issue. Include a downside that follows a coherent commercial story: slower absorption may affect collections, holding expenditure and repayment timing together. The reviewer should be able to trace an output movement back to changed assumptions without reconstructing the entire workbook.

Use the pro forma as a connected forecast that can be revised through acquisition, design and delivery. Preserve the approved version and reconcile actual expenditure and receipts to the forecast as evidence arrives. A larger model is useful only when it makes the decision, remaining uncertainty and required action clearer.

• Budget totals reconcile to the payment schedule.
• Funding is classified by source, availability and repayment obligation.
• Sales or operating assumptions have supporting evidence and a stated date.
• Project and equity results identify their cost, cash-flow and timing basis.
• Every material unresolved item has an owner and next action.