Development Appraisal Model Template
Executive Summary
Key Takeaways
- ✓ The template separates the GDV build, cost and drawdown schedule, finance module, and residual land value output into distinct, formula-driven blocks, with residual land value calculated rather than entered as a static figure.
- ✓ GDV is built bottom-up from unit or phase-level pricing and a phased absorption schedule, not entered as a single top-line assumption.
- ✓ Interest during construction references the drawdown schedule directly, resolving the circularity between total funding requirement and debt sizing through a controlled iterative approach.
- ✓ This is a structural template for how to organize the appraisal, not a source of specific pricing, cost, or financing assumptions — every figure must be sourced and justified for the specific transaction.
- ✓ Using this structure directly supports the checks in the Real Estate Development Model Checklist, since every line is already isolated and traceable back to its underlying calculation.
Purpose¶
This template sets out how a real estate development appraisal should be structured as a standalone, auditable schedule, following the build methodology in Development Appraisal Model Structure. It is a structural template — it does not provide specific pricing, cost, or financing assumptions, which must be sourced and justified for each transaction.
Template Structure¶
Section 1 — GDV Build
| Line | Value | Notes |
|---|---|---|
| Unit/phase pricing schedule | [input, per unit or phase] | See Gross Development Value |
| Absorption/sales velocity schedule | [input, per unit or phase, per period] | See Sales Absorption Rate |
| Total GDV | = SUMPRODUCT(pricing, absorption) |
Calculated bottom-up, never a single top-line input |
Section 2 — Cost and Drawdown Schedule
| Line | Value | Notes |
|---|---|---|
| Construction cost (phased against build programme) | [input, per period] | Against an actual cost curve, not straight-line |
| Contingency | [input, explicit %] | Shown as its own line, not netted against other costs |
| Professional fees | [input] | |
| Total Development Cost | = SUM(above) |
Section 3 — Finance Module
| Line | Value | Notes |
|---|---|---|
| Senior debt | = calculated (against LTC threshold) |
See Loan-to-Cost Ratio |
| Interest during construction | = calculated (from drawdown schedule) |
Resolves circularly with total funding requirement |
| Sponsor equity | = Total Funding Requirement − Senior Debt |
Calculated residual |
Section 4 — Residual Land Value or Returns Output
Residual Land Value = Total GDV − Total Development Cost − Capitalized Interest − Required Developer Profit
In a fixed-price appraisal, land cost is instead an input in Section 3, and this section outputs a margin and IRR at that price. This cell should always be a live formula, never a static value carried from an earlier appraisal — see Residual Land Value.
How to Use This Template¶
Populate the GDV build first, from unit or phase-level pricing and absorption assumptions, then the cost and drawdown schedule against the actual construction programme. Size senior debt against the resulting total development cost and a stated loan-to-cost threshold, with interest during construction referencing the drawdown schedule directly. Resolve the resulting circularity (interest depends on debt drawn, which depends on total cost, which includes capitalized interest) through a controlled iterative calculation, documented explicitly in the model's assumptions log. Calculate residual land value (or margin/IRR, in a fixed-price appraisal) as the final, live output.
This structure directly supports the checks in the Real Estate Development Model Checklist, particularly the requirement that residual land value be calculated live rather than carried as a static input.
Common Pitfalls¶
Entering GDV as a single top-line figure rather than building it bottom-up from unit or phase-level pricing and absorption, which removes the ability to test how phasing and sales pace drive value.
Carrying residual land value forward as a static figure from an earlier feasibility study rather than letting it recalculate live from the current GDV and cost assumptions.
Estimating interest during construction as a static lump sum rather than referencing the drawdown schedule, which prevents the funding requirement from responding correctly to a change in the construction schedule.
Netting contingency against other cost lines rather than showing it explicitly, which conceals the project's actual cost risk buffer.
Continue Reading¶
Related Pillars¶
Related Technical Guides¶
Related Glossary¶
Related Checklists¶
Related Resources¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
Does this template provide specific pricing, cost, or financing assumptions?
No. This is a structural template for organizing the appraisal — every unit price, absorption rate, construction cost, and financing term must be sourced and justified for the specific transaction being modelled, following the guidance in the Development Appraisal Model Structure technical guide.
Why does the template separate GDV, cost, finance, and residual land value into distinct blocks?
So each block can be independently sourced, dated, and audited, and so residual land value resolves through formula alone from the preceding blocks rather than a manually entered figure that would mask any underlying error in the GDV or cost build.
How does the template handle the interest-during-construction circularity?
The interest during construction line references the drawdown schedule directly rather than a static estimate, and the resulting circularity between total funding requirement and debt sizing is resolved through a controlled iterative calculation, consistent with the Development Appraisal Model Structure guidance.
Can this template be used for both a fixed-price and a residual land value appraisal?
Yes. The same block structure supports both — in a fixed-price appraisal, land cost is an input to the finance module and the output is a margin or IRR; in a residual appraisal, a target return is the input and residual land value is solved for as the output, with the underlying calculation chain unchanged between the two.
How should this template be adapted for a phased scheme?
By replicating the GDV and cost/drawdown blocks per phase, consistent with Development Phasing Model Structure, with a consolidated summary layer aggregating the phase-level blocks into a whole-scheme residual land value or returns output.
Related Articles
Development Appraisal Model Structure
A development appraisal model differs structurally from a standing-asset model because it builds value forward from land and construction cost, through a phased sales or leasing velocity schedule, to a gross development value, with a residual land value calculated as an output rather than assumed as an input. This guide sets out the module architecture — assumptions, GDV build, cost and drawdown schedule, finance, and residual land value or returns output — that makes such a model auditable across the development lifecycle from feasibility through to completion.
Gross Development Value
Gross development value (GDV) is the total projected value of a real estate development once completed and fully sold or let, typically the sum of projected sales proceeds for a build-to-sell scheme or the capitalized value of stabilised income for a build-to-rent scheme. GDV is the anchor figure for a development appraisal, driving both project viability and the residual land value or debt sizing calculated from it. It should be built bottom-up from unit or phase-level pricing and a phased sales or leasing absorption schedule, not entered as a single top-line assumption.
Residual Land Value
Residual land value is the value attributable to land after deducting all development costs and required developer profit from a scheme's gross development value. It is the standard method for determining what a site can support as a competitive land bid, and, in a fixed-price appraisal, the same calculation instead flexes to test the return achieved at a known land price. Residual land value should be calculated live from the model's own cost and revenue assumptions, not carried forward as a static figure from an earlier, separate appraisal.
Real Estate Development Model Checklist
This checklist covers the structural checks specific to real estate development financial models, on top of the general financial model audit baseline. It focuses on development phasing and cost drawdown mechanics, residual land value calculation, sales and leasing absorption assumptions, and interest during construction. It is intended for developers, lenders financing development, and advisors reviewing a development model ahead of a funding or investment decision.