# Development Pro Forma Model Build a development pro forma for ground-up real estate projects. Handle construction draws, capitalised interest, lease-up absorption, and GP/LP promote structures in one institutional-grade workbook. - Canonical: https://finamodel.com/templates/development-pro-forma-model - Excel download: https://finamodel.com/templates/development-pro-forma.xlsx - Category: Real Estate - Model type: Project finance - Difficulty: Intermediate - Audiences: Developers & sponsors, Bankers & advisors, Developers, Equity sponsors, Land bankers, Construction lenders - Tags: development, real-estate, construction, pro-forma, debt-draw ## Overview A real estate development pro forma models the complete lifecycle of a ground-up multifamily project: land acquisition, construction draw period, lease-up, permanent financing, and disposition. For a 200-unit garden-style apartment community, the model captures the tension between development costs ($51 million all-in: hard costs, soft costs, contingency, developer fee, and interest during construction) and operational cash flows that only begin after stabilization. The projection spans from pre-development through a five-year hold period to exit, with Yield on Cost (NOI divided by total development cost) as the critical underwriting metric. The model links hard costs per square foot ($180/sf for garden-style construction) to total building area, applies soft costs and contingency, and solves for interest during construction based on the progressive draw schedule. Permanent financing is sized at 60% LTC (loan-to-cost, a key distinction from loan-to-value) of total development cost, reflecting agency debt market conventions. Operating assumptions include a 7% Year 1 vacancy (lease-up in progress), declining to 5% at stabilization, with rent growth of 3% annually and operating expenses at 35% of effective gross income (stabilized). The return waterfall shows unlevered IRR on the full development-to-exit cash flow series plus levered IRR to equity, capturing both the development spread (YoC minus cap rate) and the leverage impact on equity returns. This template is built for institutional capital evaluating regional development opportunities with 150–200 unit counts and 18-month to 24-month construction periods. ## What's included - Monthly S-curve construction draw and interest reserve logic - Hard cost budget with contingency management - Unit-mix modelling with absorption and vacancy assumptions - Automated debt sizing based on LTC and LTV - Multi-tier IRR hurdle waterfall with promote and catch-up provisions - Land acquisition costs and carrying costs during development - Hard cost build schedule linked to timeline - Soft costs: architecture, permits, insurance, and contingency - Presale or lease-up revenue schedule with absorption rates - Debt draw schedule and repayment logic - Developer fee and return waterfall to equity ## Development Pro Forma Model: Construction Draws, Refinance, and JV Waterfall A development pro forma model supports ground-up real estate investment decisions by projecting costs, revenues, and returns across the full project lifecycle. This template implements a complete development pro forma model for a 200-unit multifamily project, covering construction draws, lease-up absorption, refinance at stabilisation, and JV waterfall distributions, all tied to a 12-sheet workbook with checks to ensure internal consistency. Rates and financial results described here reflect illustrative model settings, not industry benchmarks. ### Revenue and Operational Drivers The model's revenue build begins with gross potential rent, calculated from unit mix and average monthly rent per unit type. - During lease-up, vacancy and concessions reduce gross potential rent, while ancillary income from fees adds to effective gross income. - Operating expenses are split into fixed costs, such as property taxes and insurance, and variable costs that scale with occupancy, like management fees and utilities. - This structure keeps fixed costs from collapsing during lease-up, making the Year-1 DSCR dip more realistic. ### Calculation Flow and Debt Structure The model follows a sequential calculation flow: development costs are capitalised during an 8-quarter construction period, with capitalised interest solved in the Construction_Draw schedule. - A construction loan sized at 65% of loan-to-cost funds the draws, then refinances to a permanent loan at stabilisation. - The permanent loan, sized at 60% of total development cost, replaces construction debt, with any shortfall funded by an equity refi call. - This refinance event is modelled explicitly and tied to sources and uses, ensuring the construction loan is retired. ### Outputs and Returns Analysis Key outputs include stabilised yield on cost, unlevered and levered internal rates of return, equity multiple, and the development spread. - The model computes these metrics from cash flows that net capital reserves from both unlevered and levered series, ensuring comparability. - At exit, the model toggles between a sale or cash-out refinance, using forward NOI to derive exit value. - Waterfall distributions follow a three-tier structure, with return of capital, an 8% compounding preferred return, and a promote split, driving GP IRR above LP IRR. ### Practical Use and Validation This template is designed for evaluating whether to proceed with a development project, with a focus on internal consistency. - Hard-coded checks validate that sources equal uses, DSCR meets a 1.25x covenant, and the waterfall reconciles to levered equity cash flows. - A soft flag highlights a thin development spread without blocking results. - Scenario toggles and an exit mode switch allow users to test variations in rents, costs, and disposition strategies, making the model a practical tool for underwriting and sensitivity analysis. ## Built for ground-up development analysis Use this model when construction financing, absorption timing, and joint venture economics drive the feasibility of a real estate project. ## Handles construction financing complexity A proper development pro forma manages monthly interest accruals, capitalisation into the loan balance, and the balancing of sources between equity and debt. ## Useful for capital raising and feasibility Present professional sources and uses alongside clear GP/LP distribution schedules to support investor conversations and site acquisition decisions. ## Built for ground-up development analysis Use this model when construction financing, absorption timing, and joint venture economics drive the feasibility of a real estate project. ## Handles construction financing complexity A proper development pro forma manages monthly interest accruals, capitalisation into the loan balance, and the balancing of sources between equity and debt. ## Useful for capital raising and feasibility Present professional sources and uses alongside clear GP/LP distribution schedules to support investor conversations and site acquisition decisions. ## Features - **Timeline-based cost absorption:** Allocate costs (hard, soft, carrying) to each period based on construction schedule, not pro-rata. - **Presale and lease-up modeling:** Forecast revenue from presales, lease commencement, and rental income with realistic absorption curves. - **Debt and equity waterfall:** Model construction draws, permanent financing, and distribute cash to debt service, developer, and equity holders. ## Use cases - **Development underwriting and approval:** Test project returns (IRR, equity multiple) and debt service coverage to support investment committee decisions. - **Bridge financing and construction loan applications:** Support draw schedules and debt sizing with detailed cost and revenue projections. - **Equity raise and syndication:** Show investor returns, timeline to cash flow positive, and sensitivity to absorption or cost overruns. ## Frequently asked questions ### What is a development pro forma? It is a financial model used to evaluate ground-up real estate projects, covering acquisition, construction costs, financing, lease-up, and investor returns. ### Who uses development pro formas? Real estate developers, investment analysts, private equity funds, and commercial lenders use them for feasibility analysis and capital raising. ### What should a development pro forma include? It should include construction budgets, draw schedules, debt sizing, absorption assumptions, operating pro forma, exit analysis, and equity waterfall mechanics. ### How does the interest reserve work? The model estimates total interest incurred during construction based on the draw schedule, then sizes the loan or equity contribution to ensure sufficient liquidity throughout the build period. ### Can it handle mixed-use developments? Yes. The unit-mix and revenue schedules support multiple residential floorplans alongside commercial or retail components, each with its own absorption profile. ## Related templates - [Leveraged Buyout Model](https://finamodel.com/templates/lbo-model) - [Construction Draw Schedule](https://finamodel.com/templates/construction-draw-model) - [Ground Lease Economics Model](https://finamodel.com/templates/ground-lease-model)