The Development Pro Forma, Explained Line by Line
A pro forma isn't a snapshot of a finished building. It's a story about time — money going out for two years before a single dollar comes in. Get the timeline wrong and the best deal on paper still fails.
The first pro forma I ever saw for a storage deal was a single column: stabilized revenue at the top, expenses below, net operating income at the bottom, a value at the very end. It looked complete. It was almost useless — because it described a building that was already full, already paid for, already done. It said nothing about the eighteen-to-thirty-six months of empty units, construction draws, and debt service you have to survive to get to that column.
That gap is the whole job. A development pro forma is not one column — it's a timeline, month by month or year by year, that follows your money from the day you close on the dirt to the day you sell a stabilized asset. The shape of that timeline, more than any single number in it, is what decides your return. This guide builds one from scratch.
Two deals with identical stabilized NOI can return 25% and 9%. The only difference is how long the building sat empty while the clock ran. That's what the pro forma is for.
Two pro formas live inside every deal
The word "pro forma" gets used for two different things, and conflating them is the first mistake. You need both.
The stabilized pro forma is the single column — what the building earns in a normal year once it's full. Revenue, vacancy, operating expenses, NOI. It answers "what is this asset worth when it's done?" and it feeds your yield on cost and exit value.
The development (or cash-flow) pro forma is the timeline. It answers the harder question: "what does it cost me, in time and cash, to create that stabilized asset — and what do I actually make?" This is where construction costs get drawn down month by month, where the building fills along a lease-up curve, where interest accrues on the construction loan, and where your equity goes negative before it ever goes positive.
The stabilized pro forma tells you if the building is good. The development pro forma tells you if the deal is good. Those are different questions, and plenty of good buildings have been terrible deals.
Sources and uses: where the money comes from and goes
Before the timeline, you size the deal. Uses are everything the project costs; sources are everything that pays for it. They have to balance to the penny — that reconciliation is the first thing a lender checks.
| Uses (total project cost) | |
|---|---|
| Land | $1.00M |
| Hard costs (building + site work) | $3.85M |
| Soft costs (A&E, permits, impact fees) | $0.45M |
| Contingency (~8%) | $0.30M |
| Construction-period interest reserve | included below |
| Total uses | $5.50M |
| Sources | |
|---|---|
| Construction loan (~65% of cost) | $3.58M |
| Sponsor + investor equity (~35%) | $1.92M |
| Total sources | $5.50M |
This is the same 55,000-square-foot, single-story drive-up deal we underwrite in the main underwriting guide — a $5.5M all-in cost, financed roughly 65% debt / 35% equity. Two things that trip up first-timers live in this table. The contingency is not optional padding; on a ground-up project something always comes up, and 7–10% of hard costs is the price of not getting a capital call at the worst moment. And the interest reserve — money the loan itself funds to pay its own interest during construction and lease-up — is the line that keeps the deal alive through the months when the building earns nothing. Leave it out and your sources don't actually cover your uses.
The J-curve: why your equity goes negative first
Here's the shape that defines development. Plot your cumulative cash position over time and it looks like the letter J: a long dip below zero, then a climb back up and past it at the sale.
- Months 0–18 — construction. You draw down equity and loan to build. Cash out, nothing in. Your cumulative position falls to its deepest point right around the certificate of occupancy.
- Months 12–48 — lease-up. The building opens empty and fills at roughly 2–3% of rentable space per month. Revenue ramps, but for a long stretch it doesn't cover debt service and operating costs — the interest reserve absorbs the shortfall. Stabilization (≈85–90% occupied) now typically runs around 36 months, longer than it did a few years ago.
- Month ~36–48 — stabilized + exit. The building hits its stabilized NOI, you refinance or sell, and the J-curve shoots up past zero into profit.
Building the timeline, line by line
A development pro forma is just these rows, projected across each period (monthly is best for storage because lease-up is the whole story):
- Occupancy % — driven by your lease-up curve, climbing from 0 toward stabilized.
- Gross potential rent — your unit-mix revenue at full occupancy.
- × occupancy → in-place rent — what you actually collect that month.
- + other income — tenant insurance (8–10% of revenue at scale), admin and late fees, retail.
- = effective gross income (EGI).
- − operating expenses — running roughly 35% of EGI once stabilized, higher as a percentage early when revenue is thin but fixed costs (taxes, insurance, a manager) are already there.
- = net operating income (NOI).
- − debt service — interest on the drawn construction balance, covered by the reserve until NOI can carry it.
- − remaining capital outflows — construction draws still going out in early periods.
- = net cash flow — negative for a long time, then positive. This row is the J-curve.
The discipline that separates a real pro forma from a fantasy is rows 1 and 6. If occupancy in row 1 jumps to stabilized in month two, you've written fiction. If operating expenses in row 6 are a flat 30% from day one, you've ignored that a quarter-full building still pays full property taxes and a full manager's salary. The early months should look ugly. That's correct.
What the timeline pays out
Run the whole thing and three return metrics fall out the bottom — and they answer three different questions:
| Metric | What it answers |
|---|---|
| Profit on cost | How much value did I create? ($7.33M stabilized value − $5.5M cost ≈ $1.83M, or 33%) |
| Equity multiple | How many times did I get my money back? (~1.7× on the equity) |
| IRR | What annual return did the timing earn? (low-to-mid 20s% for a ~3-year hold) |
Notice profit on cost says nothing about time, equity multiple says nothing about time, and only IRR captures the J-curve. A deal can have a fat profit and a fat multiple and still post a mediocre IRR because the money was tied up too long. This is exactly why the development pro forma exists and the stabilized column alone doesn't: the stabilized building sets profit, but the timeline sets the return.
Build your own timeline, not just a snapshot
The free calculator gives you the stabilized read — yield on cost and a go/walk verdict — in two minutes. The full Excel model runs the whole development pro forma: monthly lease-up curve, interest reserve, profit, equity multiple, and a live IRR.
Open the free calculator → Get the full modelThe four places a pro forma lies
- Instant lease-up. If the building is stabilized in year one, the pro forma is wrong before you read another row. Model the real 24–36 month fill.
- No interest reserve. Sources have to cover the carry through lease-up. A pro forma that funds construction but not the empty-building months runs out of cash in month 14.
- Flat-percentage expenses from day one. A quarter-full facility's OpEx is a much higher share of its thin revenue. Early NOI is worse than the stabilized ratio implies.
- Stale costs. A 2023 cost basis is wrong: light-gauge steel is up 9–14% year over year, and climate product carries the A2L refrigerant cost bump. Garbage in the uses column poisons every return below it.
Where to go from here
A pro forma is only as honest as the market assumptions feeding it — which is what a feasibility study exists to supply (real demand, real comps, a real absorption forecast). And the whole timeline ultimately gets judged by one comparison: your yield on cost against the exit cap rate. The pro forma is the machine; the spread is the verdict it produces.
For a public reference build, A.CRE maintains a well-regarded self-storage development model. This article is educational, not investment advice — every deal turns on its own diligence, and current cost and rate data should be pulled fresh.