How to Build a Development Pro Forma Lenders Can Review
The schedules, checks and downside cases that turn a development appraisal into an auditable lending model.
A lender-ready development pro forma must do more than show an attractive margin. It must explain when money is required, what funds each stage, how interest accumulates and whether the project can repay under a credible downside case.
Start with the development programme
Start with the programme. Land completion, planning conditions, construction phases, practical completion, sales or lease-up and debt maturity should sit on one timeline. If the programme is annual while construction funding is monthly, the model can hide the point at which cash is actually tightest.
Build a cost plan lenders can trace
The cost plan should separate land, acquisition costs, construction, professional fees, statutory costs, marketing, contingency and finance costs. Each category needs a timing driver. Applying every cost evenly across construction is simple but often misleading, especially where deposits, enabling works or final retention are material.
Drive revenue from the units, not a blended rate
Revenue should be driven by the underlying commercial units. For a for-sale scheme, that means unit mix, achievable pricing, sales pace, deposits and completion receipts. For an income-producing scheme, it means space, rent, incentives, occupancy, operating costs and stabilisation. Mixed-use projects need separate logic before consolidation.
Model debt as a schedule, not a plug
Debt should be a schedule, not a plug. The model needs commitment, loan-to-cost or loan-to-value constraints, draw priority, interest rate, fees, interest payment or capitalisation, covenants and repayment. The minimum cash or equity requirement should follow from these rules.
Pre-build the downside cases
A lender will test the case. At minimum, include construction-cost inflation, programme delay, slower sales or lease-up, lower pricing or rent and a weaker exit valuation. The downside should flow through the same formulas as the base case rather than being typed into a separate summary.
Add visible checks
Finally, add visible checks: sources equal uses, the cash balance never falls below the allowed minimum, debt stays within commitment, repayment does not exceed available cash and all project cash is reconciled. Clear assumptions and consistent formula formatting shorten review time because the lender can follow the logic.