Real Estate Development Pro Forma Package: Complete Guide

A real estate development pro forma is not just a spreadsheet. It is the financial model plus the evidence package that lets a developer, lender, or investor decide whether the project works. The spreadsheet projects every dollar in and out — from land acquisition through construction, lease-up or sales, and eventual exit. The package around it proves that each number is defensible: site control, plans, comps, GC estimates, term sheets, environmental reports, sponsor financials.

This guide walks through what a complete pro forma package contains, who reads it and what they need it to answer, the math behind each section, and a real folder structure you can copy. It applies whether you are underwriting a single infill lot, a 38-lot subdivision, a build-to-rent community, or an affordable housing tax-credit deal.

What is a development pro forma?#

A development pro forma is a forward-looking financial model of a real-estate project. It begins with assumptions (site, product, costs, prices, schedule, financing), projects a monthly cash flow from land close through stabilization or sell-out, and outputs the metrics that determine whether the deal gets capital: project IRR, LP net IRR, equity multiple, residual land value, peak equity exposure, and stabilized yield on cost.

The most important framing: a pro forma is not a forecast, it is a decision machine. The same model with different land prices, costs, or absorption assumptions tells you whether to buy, option, renegotiate, or walk. A good pro forma exposes the deal's sensitivity to its three or four most fragile inputs. A bad one buries them in a single optimistic number.

Pro forma vs underwriting package vs draw package#

These three documents are related but distinct, and conflating them is the most common source of confusion when a developer first meets institutional capital.

Pro forma: The financial model (typically Excel) that projects costs, revenue, and returns over the life of the deal. Pre-close artifact.
Underwriting package: The pro forma plus all supporting documents a lender, agency, or LP needs to validate the assumptions in the model. Pre-close artifact.
Draw package: The post-close artifact that proves work was completed and authorizes the lender to fund a construction draw. Built monthly during construction.

The pro forma is the headline. The underwriting package is the audit trail. The draw package is the operating system that runs after capital is committed.

Who uses the pro forma package?#

A serious pro forma package serves four distinct audiences. Each cares about a different subset of the same model. Designing the package with the audience in mind is the difference between getting a term sheet and getting silence.

For the developer, the pro forma answers the questions that determine whether to proceed at all:

Can I pay the asking price for the land?
What density, product, or unit mix makes the deal work?
How much equity do I need at closing, at permits, during construction, and at peak exposure?
What happens if construction costs rise 10%?
What happens if sales or rents come in 5% lower?
What is the residual land value?
Should I buy, option, renegotiate, or walk?

This is the only audience that uses every tab of the model. Everyone else reads a specific slice.

The construction lender#

The lender cares less about the upside and more about collateral, budget control, repayment, and draw mechanics. A senior construction lender's underwriting package typically asks for:

Approved development budget by line item
Sources and uses statement
Loan-to-cost and loan-to-value: $\text{LTC} = \dfrac{\text{Loan Amount}}{\text{Total Project Cost}}$ and $\text{LTV} = \dfrac{\text{Loan Amount}}{\text{Stabilized Value}}$
Interest reserve calculation
Construction schedule
Borrower equity in first (typical requirement)
Third-party cost review
Appraisal
Environmental, zoning, and title
GC contract and bonding
Draw schedule
Lien waiver process
Exit or takeout source (for rental, the permanent loan term sheet; for for-sale, the absorption schedule)

Freddie Mac's institutional underwriting checklist is a useful reference for the format an institutional package takes: transaction narrative, pro forma financial statements, rent roll, historical and budgeted financials, borrower certifications, organizational charts, financial statements, liquidity validation, credit reports, zoning documentation, pre-construction analysis, appraisal with market study, and environmental report.

The LP investor#

LPs read the deck and the model very differently than lenders. They want a clear story plus the metrics that let them benchmark this deal against the other twelve in their pipeline:

Deal summary and sponsor thesis
Capital stack and use of proceeds
Base, downside, and upside cases
Project IRR: the rate that solves $\displaystyle \sum_{t=0}^{n} \dfrac{CF_t}{(1+r)^t} = 0$
LP net IRR (after the waterfall)
Equity multiple: $\text{EM} = \dfrac{\sum \text{Distributions}}{\sum \text{Equity Invested}}$
Preferred return and promote structure
Peak equity exposure and distribution timing
Key risks and mitigants
Exit assumptions

The affordable housing / public subsidy reviewer#

Subsidy underwriting is the most documentation-heavy form of development underwriting. State HFAs, HUD, and tax-credit allocators want a more compliance-oriented package:

Sources and uses broken out by funding source
Operating pro forma over 15 to 20+ years
Rent restrictions, unit mix, and AMI affordability levels
Eligible costs (for tax-credit basis)
Subsidy gap: $\text{Subsidy Gap} = \text{Total Uses} - \text{Conventional Sources}$
Developer fee limits
Evidence that other sources are committed
Environmental review
Documented market need
Comparable project costs
Readiness to proceed

HUD's HOME underwriting guidance and California HCD's DR-MHP checklist both ask reviewers to verify that the pro forma includes a sources-and-uses statement, a minimum 20-year operating pro forma, market rents and vacancies that support viability, entitlement evidence, and comparable development costs.

What goes inside the model?#

A complete development model has eleven tabs (or sections in a single sheet). Each feeds the next, so errors in early tabs compound downstream. Build them in order.

01_Assumptions
02_Sources_Uses
03_Development_Budget
04_Construction_Cash_Flow
05_Debt_Model
06_Revenue_or_Sales_Model
07_Operating_Pro_Forma
08_Exit_Valuation
09_Returns_Waterfall
10_Sensitivities
11_Dashboard

01 Assumptions#

One tab, one source of truth. Every input the rest of the model uses lives here: land price, lot count, unit mix, GBA, sale prices or rents, hard cost PSF, soft cost percentage, contingency, loan terms, equity terms, schedule, exit cap rate or sale month. Color-code inputs (blue) versus formulas (black) so reviewers can change a number and see it flow through.

02 Sources and uses#

The one-page snapshot of total capitalization. Every dollar in uses must equal every dollar in sources: $\text{Total Sources} = \text{Total Uses}$ . Typical uses for a residential development:

Land acquisition (purchase price plus closing costs)
Hard costs (horizontal site work + vertical construction)
Soft costs (design, permits, fees, insurance, legal)
Financing costs (loan fees, interest reserve)
Developer fee
Contingency (typically 5–10% of hard costs)

Sources: senior construction loan, mezzanine or preferred equity, LP equity, GP equity. The ratio of debt to total cost is your loan-to-cost. Residential construction lenders typically advance 60–70% LTC; the balance is equity.

03 Development budget#

Hard and soft cost breakdown at the line-item level. Hard costs split into horizontal (grading, roads, utilities, stormwater, landscaping) and vertical (foundation, framing, MEP, finishes, GC overhead and fee). Soft costs include architecture and engineering, civil engineering, environmental and geotech studies, permits and impact fees, construction management, developer overhead, marketing and sales commissions, legal, insurance, and property taxes during construction.

In 2025–2026 residential vertical hard costs range from $130–$180/SF for entry-level product to $200–$280/SF for upscale suburban. Always anchor the budget to a contractor estimate or recent comps. National averages such as the NAHB cost-of-constructing-a-home survey are a sanity check, not an input.

04 Monthly construction cash flow#

A month-by-month grid from land close through final unit sale (or stabilized operations). Cash outflows include the land close (typically month 0), monthly construction draws weighted by the schedule of values, soft cost payments (architecture and permits front-loaded, marketing back-loaded), loan fees, and operating costs during sell-down. Cash inflows include construction loan draws (offsetting equity outflows), unit sales, and deposit releases. The cumulative net column gives peak equity exposure, which is the actual capital at risk — not the headline total equity figure.

05 Debt model#

Models the senior construction loan and any subordinate debt at the monthly level. Tracks drawn balance, monthly interest accrual, fees, and repayment. Interest is calculated on the drawn balance only:

\text{Monthly Interest}_t = \text{Drawn Balance}_{t-1} \times \dfrac{\text{Annual Rate}}{12}

Interest reserve is sized to cover this through the construction period and into a lease-up or sell-down window. Mis-sizing the interest reserve is the most common error in early-draft pro formas; a six-month entitlement slip on a $20M project can add $300–500K of carry that vaporizes the developer fee.

06 Revenue or sales model#

For-sale projects: unit-by-unit sales schedule with closing dates, sale price, commissions (3–5%), and closing costs. Modeled in monthly increments that match local absorption — pull median absorption from the last 18 months of MLS comps. For rental projects: lease-up schedule, vacancy stabilization, market rent by unit type, other income (parking, fees), and bad debt. Stabilized NOI feeds the exit valuation.

07 Operating pro forma#

For rental developments and affordable housing, a multi-year operating pro forma is required: scheduled rent growth, vacancy, operating expense ratio, replacement reserves, and stabilized NOI. Affordable housing reviewers want 15–20+ years to test debt service coverage under restricted rents.

08 Exit valuation#

For-sale: total net sale proceeds = sum of unit closings net of commissions and closing costs. For rental: stabilized value $V = \dfrac{\text{NOI}}{\text{Cap Rate}}$ . Be conservative on both inputs — cap rates have compressed in some BTR markets and a 50-bps cap rate error moves stabilized value by 8–12%.

09 Returns and waterfall#

Convert the monthly cash flow grid into project IRR, LP net IRR (after the GP/LP waterfall), and equity multiple. Standard residential development targets a project IRR of 18–22%, LP net IRR of 14–18%, and an equity multiple of 1.7×–2.0× over a 24–36 month hold. See the GP/LP waterfall guide for the three-tier structure, return-of-capital, preferred return, and promote math.

10 Sensitivities#

The two-variable sensitivity table is standard: LP net IRR across a range of land costs on one axis and revenue per unit on the other. This shows the deal's margin of safety. Secondary sensitivities: construction cost vs. exit cap rate (BTR), absorption pace vs. hard cost inflation (for-sale), interest rate vs. loan maturity extension. Run ±10–20% on the most likely inputs.

11 Dashboard#

One page. The five numbers that matter (project IRR, LP net IRR, equity multiple, peak equity, residual land value), the sources and uses summary, and a tornado chart of sensitivities. This is what an LP reads first. If the dashboard is well-built, half the LPs decide here.

What supporting documents go in the package?#

Around the model sits the evidence package. Lenders and agencies do not ask for "a pro forma." They ask for a package that proves the inputs are defensible. The categories below are what an institutional capital provider expects to see.

Executive summary: one-page deal summary, investment memo, key risks and mitigants
Site control: PSA or LOI, title report, ALTA survey, parcel map, zoning summary
Plans and entitlements: site plan, floor plans, elevations, entitlement status, permit timeline
Market research: sale comps, rent comps, land comps, absorption analysis, third-party market study
Cost estimates: GC estimate, schedule of values, soft cost budget, contingency rationale, cost benchmark notes
Financing: sources and uses, construction loan term sheet, equity term sheet, interest reserve calc, capital stack summary
Diligence: Phase I environmental site assessment, geotech report, environmental clearances, utility availability
Sponsor and borrower: sponsor bio, track record, organizational chart, sponsor financial statements, real estate owned schedule
Draw package templates: draw request form, AIA G702/G703 or equivalent, invoice log, lien waiver log, change order log, inspection report template

For affordable housing, add: rent restriction certifications, AMI documentation, tax-credit basis calculations, soft-source commitment letters, deferred developer fee schedule, operating and replacement reserves, and a 15–20+ year operating pro forma showing DSCR under restricted rents.

Example folder structure#

Below is a concrete folder structure for a residential development pro forma package. Copy it directly when you start your next deal — the discipline of laying out the empty folders before you fill them is the single biggest improvement most developers can make to their workflow.

River_Run_Townhomes_Pro_Forma_Package/
│
├── 00_Read_Me/
│   ├── Package_Index.pdf
│   ├── Version_History.md
│   └── Assumption_Log.xlsx
│
├── 01_Executive_Summary/
│   ├── Investment_Memo.pdf
│   ├── One_Page_Deal_Summary.pdf
│   └── Key_Risks_and_Mitigants.pdf
│
├── 02_Model/
│   ├── Development_Pro_Forma.xlsx
│   ├── Sensitivity_Output.pdf
│   └── Residual_Land_Value_Output.pdf
│
├── 03_Land_and_Site/
│   ├── PSA_or_LOI.pdf
│   ├── Title_Report.pdf
│   ├── ALTA_Survey.pdf
│   ├── Parcel_Map.pdf
│   └── Zoning_Summary.pdf
│
├── 04_Plans_and_Entitlements/
│   ├── Site_Plan.pdf
│   ├── Floor_Plans.pdf
│   ├── Elevations.pdf
│   ├── Entitlement_Status.pdf
│   └── Permit_Timeline.pdf
│
├── 05_Market_Research/
│   ├── Sale_Comps.xlsx
│   ├── Rent_Comps.xlsx
│   ├── Land_Comps.xlsx
│   ├── Absorption_Analysis.xlsx
│   └── Market_Study.pdf
│
├── 06_Costs/
│   ├── GC_Estimate.pdf
│   ├── Schedule_of_Values.xlsx
│   ├── Soft_Cost_Budget.xlsx
│   ├── Contingency_Support.pdf
│   └── RSMeans_or_Cost_Benchmark_Notes.pdf
│
├── 07_Financing/
│   ├── Sources_and_Uses.pdf
│   ├── Construction_Loan_Term_Sheet.pdf
│   ├── Equity_Term_Sheet.pdf
│   ├── Interest_Reserve_Calc.xlsx
│   └── Capital_Stack_Summary.pdf
│
├── 08_Diligence/
│   ├── Phase_I_ESA.pdf
│   ├── Geotech_Report.pdf
│   ├── Environmental_Clearance.pdf
│   └── Utility_Availability.pdf
│
├── 09_Sponsor_Borrower/
│   ├── Sponsor_Bio.pdf
│   ├── Track_Record.pdf
│   ├── Organizational_Chart.pdf
│   ├── Financial_Statements.pdf
│   └── Real_Estate_Owned_Schedule.xlsx
│
└── 10_Draw_Package_Template/
    ├── Draw_Request_Form.pdf
    ├── AIA_G702_G703_or_Equivalent.pdf
    ├── Invoice_Log.xlsx
    ├── Lien_Waiver_Log.xlsx
    ├── Change_Order_Log.xlsx
    └── Inspection_Report_Template.pdf

Scenario-specific pro formas#

"Residential development pro forma" is too broad to be useful. The tabs you need, the cost categories, and the return metrics all change based on the product type. The six scenarios below cover the vast majority of small-to-mid-sized residential deals.

Scenario 1: Raw land / subdivision#

Used when evaluating whether to buy land, entitle lots, install horizontal infrastructure, and either sell finished lots or build homes. The defining metric is residual land value and finished lot value.

Key tabs: land acquisition, entitlement timeline, horizontal development budget, lot yield analysis, finished lot sales schedule, absorption, phasing, residual land value.

See the raw land underwriting guide and the subdivision pro forma walkthrough for full templates.

Scenario 2: Single spec home or small homebuilder project#

Used by builders deciding whether to buy one lot or several lots and build homes for sale. The model is simpler than a subdivision: lot purchase, vertical hard costs, soft costs, construction loan, sales price, brokerage and closing costs, profit margin, return on equity, residual lot value.

See the construction loan draw schedule guide for how to model the revolver across a rolling pipeline of 3–5 starts per month.

Scenario 3: Townhome or infill for-sale development#

Mid-sized for-sale projects with a distinct mix of products and phasing logic. Key tabs: unit mix, sale comps, absorption schedule, vertical construction by phase, HOA and common area costs, model home and marketing costs, construction loan draws, release prices.

Scenario 4: Build-to-rent or multifamily rental#

The model pivots from a sale to a stabilized cash-flow exit. Key tabs: rent roll, lease-up, vacancy, operating expenses, NOI, stabilized value, exit cap rate, permanent loan refinance, DSCR, yield on cost. DSCR is the critical lender metric:

\text{DSCR} = \dfrac{\text{NOI}}{\text{Annual Debt Service}}

Yield on cost is the developer-facing metric that determines the spread over the exit cap rate:

\text{YoC} = \dfrac{\text{Stabilized NOI}}{\text{Total Project Cost}}

A target spread of 150–200 bps over the exit cap rate is typical for BTR. See the BTR pro forma guide for the complete walkthrough.

Scenario 5: Affordable / LIHTC / subsidized housing#

Compliance-driven modeling. Key tabs: unit mix by AMI, tax credit pricing, permanent debt sizing, soft funding sources, deferred developer fee, operating reserve, replacement reserve, 15–20+ year operating pro forma, compliance assumptions. The model has to demonstrate that DSCR holds under restricted rents for the full compliance period, and that the subsidy gap closes with committed soft sources.

Scenario 6: Rehab or adaptive reuse#

Existing structure complicates everything. Key tabs: acquisition, existing income (if any), tenant relocation, rehab scope, hard cost by trade, phasing during occupied operations, operating disruption, stabilized operations, refi or sale. Contingency runs higher (15–20%) because demo and discovery surprises are normal.

Worked example: 24-townhome infill development#

The following is a deliberately small example so the math is easy to follow. Numbers are illustrative, not market-specific.

Land purchase:              $3.0M
Units:                      24 townhomes
Average sale price:         $725,000
Gross sellout:              $17.4M
Hard costs:                 $9.2M
Soft costs:                 $1.8M
Financing / carry:          $0.9M
Contingency:                $0.6M
-----------------------------------------
Total project cost:         $15.5M
Profit before tax:          $1.9M
Construction loan:          65% LTC
Equity required:            $5.4M
Project duration:           30 months

Core ratios:

\text{LTC} = \dfrac{\$10.1\text{M}}{\$15.5\text{M}} = 65\% \qquad \text{Profit Margin} = \dfrac{\$1.9\text{M}}{\$17.4\text{M}} = 10.9\%

Now run three cases:

Base case: as modeled. LP net IRR $\approx 16\%$ , equity multiple $\approx 1.7\times$ .
Downside case: hard costs +10%, sale prices −5%, absorption +6 months. Project profit collapses to roughly $\$0.1\text{M}$ ; LP net IRR falls below the preferred return.
Upside case: sale prices +5%, no schedule slip. Project profit rises to about $\$2.8\text{M}$ ; LP net IRR $\approx 22\%$ .
Residual land value case: hold returns constant, back-solve for the land price that delivers the LP's 14% net IRR threshold. If $\text{RLV} < \text{Asking Price}$ , renegotiate or walk.

This is the central insight of the pro forma: the same model produces four different decisions depending on which input you flex. See the residual land value guide for the full back-solve math.

Common lender questions#

If you cannot answer these in writing with documentation, the construction loan term sheet will either not come or come with conditions you do not want.

What is the LTC and LTV at close? Stabilized LTV?
How is the interest reserve sized? What if construction extends 6 months?
What is the construction schedule? What is the critical path?
What is the borrower equity, and is it in first (typical lender requirement)?
Who is the GC? Are they bonded? Has the schedule of values been reviewed?
What is the appraisal value? Is there a third-party cost review?
Is there a Phase I ESA? Geotech? Title? Survey? Zoning letter?
What is the take-out source — sale absorption schedule or permanent loan term sheet?
What is the DSCR at stabilization under the permanent loan?
What are the lien waiver and draw inspection procedures?

Common investor questions#

What is the deal in one sentence?
What is the project IRR, LP net IRR, and equity multiple?
What is the peak equity exposure and when does it occur?
What is the waterfall — pref, promote tiers, catch-up?
What are the three things that could go wrong, and how are they mitigated?
What is the exit assumption? What cap rate or absorption pace supports it?
How does this deal pencil if construction costs rise 10%?
How does it pencil if sale prices or rents come in 5% lower?
What is the sponsor's track record on similar product?
What is the GP co-invest percentage?

Common mistakes and red flags#

The list below is what a careful reviewer scans for before they pick up the phone. Avoid all of these.

No source shown for sales or rent comps
No absorption analysis
No interest reserve or one that does not cover schedule slippage
No property tax or insurance carry during construction
No contingency, or contingency below 5%
Soft costs suspiciously low (under 8% of hard cost for a typical deal)
Hard costs stale (more than 6 months old in a moving market)
Land basis not shown per unit or per buildable SF
Debt proceeds assumed without a lender term sheet supporting them
Exit cap rate lower than the trailing-12-month transaction cap for the submarket
No sensitivity table
No monthly cash flow — just an annual model
Equity need shown only as total equity, not peak exposure with timing
Developer fee counted as profit but not actually financeable

Research sources and benchmarks#

The pro forma is only as good as the data behind it. The sources below are the ones institutional underwriters rely on. Cite them in the model so reviewers can verify your numbers.

Public and official sources

Census New Residential Construction — permits, starts, completions, and units under construction
Census Building Permits Survey — state, county, place, and MSA permit data
FRED — housing permits, starts, rates, and macro time series
HUD HOME underwriting notice — sources and uses, operating pro forma, subsidy review standards
HUD MAP Lender Underwriter Narrative — FHA multifamily underwriting narrative structure
Freddie Mac multifamily underwriting checklist — institutional package checklist
State HFA / LIHTC QAPs — affordable housing underwriting standards

Industry and model sources

NAHB Cost of Constructing a Home survey — national construction cost category benchmark. NAHB's 2024 survey put construction at 64.4% of sales price, finished lot 13.7%, and builder profit 11.0%; within construction cost, interior finishes were 24.1%, major systems rough-ins 19.2%, and framing 16.6%.
A.CRE residential land development model — back-of-the-envelope land and subdivision modeling reference
A.CRE single-family home construction model — homebuilder modeling reference
AIA G702 / G703 resources — construction payment application references

NAHB itself cautions that its survey is based on a subset of builders and is not designed to estimate a specific house in a specific location. National averages are starting points; local bids are the input.

FAQ#

How long does it take to build a development pro forma?#

For a boutique developer or analyst building the model from scratch in Excel, a complete residential development pro forma takes 8–20 hours depending on complexity. That includes sourcing comp data, structuring the monthly cash flow, and building the waterfall correctly. Many sponsors take longer because they iterate on assumptions while building, which doubles the time.

What is the difference between an underwriting package and a draw package?#

The underwriting package is pre-close. It contains the pro forma and every supporting document a lender or LP needs to validate assumptions. The draw package is post-close. It is the monthly artifact that proves work was completed, costs match the approved budget, lien waivers are in order, and the lender can safely release funds. Both are essential, but they exist for different reviewers and different moments in the deal.

What does a construction draw package contain?#

Typically a draw request form, AIA G702/G703 (or an equivalent application for payment with schedule of values), invoice log, lien waiver log, change order log, and a third-party inspection report. Live Oak Bank and most institutional construction lenders pay against percentage of completion assessed by an inspector, require lien waivers, verify insurance and licensing, and require approved change orders. Final payment requires certificate of occupancy, full lien releases, and a punch list.

What is the difference between project IRR and LP net IRR?#

Project IRR is the return on total equity, GP and LP combined, computed from the monthly cash flow before the waterfall. LP net IRR is the return on LP equity only, after the preferred return and GP promote have been paid through the waterfall. LP net IRR is the number investors actually receive. With a typical 8% preferred return and a 70/30 promote, LP net IRR usually lands 3–5 percentage points below project IRR.

What is residual land value?#

Residual land value is the maximum land price the deal can support and still hit the LP's target return. Solve the pro forma backwards: hold revenue, costs, and target return constant, and back-solve for land. If the residual is below the asking price, the deal does not pencil at that land basis. See the residual land value guide for the full derivation.

Why does the lender require equity to fund first?#

Equity in first protects the lender's basis. If the developer puts in their equity before the loan draws begin, the lender knows it is funding into a project that already has skin in the game. If the project gets in trouble, the equity gets wiped out before the loan principal is impaired. This is standard for construction lending and is rarely negotiable.

What is the difference between LTC and LTV?#

LTC is loan-to-cost: $\text{LTC} = \dfrac{\text{Loan}}{\text{Total Project Cost}}$ . LTV is loan-to-value: $\text{LTV} = \dfrac{\text{Loan}}{\text{Appraised or Stabilized Value}}$ . Construction lenders typically size the loan to the lower of an LTC cap (often 65–70%) and an LTV cap (often 60–65% of as-completed appraised value). Both have to clear.

How do I model the GP/LP waterfall correctly?#

A standard three-tier development waterfall pays back capital first, then a preferred return (typically 8% per year), then a promoted split (often 70% LP / 30% GP above the pref, sometimes with an additional tier above an IRR hurdle). The mistake most pro formas make is computing the pref on contributed equity rather than on the running balance after capital has been returned. The GP/LP waterfall guide walks through the full mechanics with a worked example.

River builds development pro forma packages — sourced market data, full sensitivity analysis, GP/LP waterfall, residual land value, and a investor-ready memo — from a single deal description. Try the River development analyst on your next deal.