Auditing a Development Pro Forma in 30 Minutes: A 5-Item Checklist

You've got a pro forma in front of you. Maybe it's a 50-unit apartment project in Nashville, or a 12-lot subdivision in Charlotte. The developer says it's a home run. Your job is to find the holes—fast. In thirty minutes, you can audit the key assumptions and decide if this deal deserves more phase. Here's the checklist.

Where This Checklist Fits in Real task

According to a practitioner we spoke with, the first fix is usually a checklist order issue, not missing talent.

The role of pro formas in deal screening

Every development deal starts with a spreadsheet—somebody's guess at what a piece of dirt might become. That guess gets called a pro forma, and in thirty minutes you can tell whether it's worth a deeper look or belongs in the recycling bin. I have seen units spend three weeks refining a pro forma for a site they never should have touched. The checklist here exists to catch those mistakes early, before you burn underwriting budget on a deal with a fatal flaw hidden in row 47.

This is not a deep-dive audit. You're not checking every assumption against segment comps or stress-testing construction contingency chain by chain. The pro forma at this stage is a screening tool—a primary-pass filter. Think of it like checking a car's tires and oil before deciding whether to take it for a check drive. You don't require to rebuild the engine yet. What you require is a fast, reliable way to separate 'maybe' from 'no chance.'

The catch is that most people skip this step entirely. They open the file, see a tidy number for internal rate of return, and step on. That's how bad deals survive the initial meeting. flawed step.

Why 30 minutes is enough (and when it's not)

Thirty minutes sounds short for a process that can kill a multi-million-dollar deal. But here's the reality: if a pro forma has a fundamental error—like forgetting land overheads or using an exit cap that hasn't existed since 2021—you don't require an hour to find it. You look for a repeat. The five items in this checklist target the seams where pro formas typically blow out. If those seams hold, the deal gets a second look. If they don't, you walk.

fast reality check—thirty minutes is not enough when the deal is borderline or when the sponsor has a track record of optimistic assumptions. In those cases, you step into underwriting depth: rent rolls, comparable sales, construction bids, the full stack. But that's chapter three labor. For the opening screen, thirty minutes forces a discipline that long sessions often lose—you stay focused on the five things that actually matter, not the fifty things that might matter someday.

Most groups skip this by jumping straight to sensitivity tables. That hurts. Sensitivity analysis on a broken base case is just elegant garbage. You fix the foundation opening, then stress it.

Who should use this checklist

This checklist is for anyone who has to say 'yes' or 'no' before the full underwriting group gets involved. Development analysts who see twenty deals a week. Investment committee members who get a stack of summaries on Thursday night. Even experienced operators who call a swift sanity check on a partner's model—because nobody catches every typo in their own spreadsheet.

The person who should not use this is the junior analyst handed a pro forma for the primary slot and told to figure it out. That analyst needs mentorship, not a checklist. The checklist assumes you already know what a decent cap rate looks like for a given asset class and segment. If you don't, go run comps initial. Then come back.

One more thing—this checklist works because it's short. If you find yourself adding items, you're drifting back toward full underwriting. Stop. The whole point is thirty minutes. Not thirty-five. Not 'I'll just check one more thing.' Thirty.

'The best pro forma audit is the one that kills a bad deal in the opening fifteen minutes, not the one that justifies a bad deal after three weeks.'

— overheard at a development roundtable, Dallas, 2023

Fjords, kelp forests, basalt shelves, puffin cliffs, and driftwood caches keep field notebooks from looking cloned.

Koji miso brine smells alive.

Foundations That Most People Get faulty

Gross Potential Rent vs. Effective Gross Income

Most groups start a pro forma by typing gross potential rent—100% occupancy, no concessions—and then subtracting a vacancy factor. That sounds fine until you realize they've already baked vacancy into their expense projections. Double counting. I've seen a deal that looked like a 12% unlevered yield collapse to 7% because the analyst assumed 5% vacancy on revenue and included a 'management reserve' chain that was basically the same number. off step. You want effective gross income: actual rent collected after vacancy, concessions, and credit loss. That's your real top series. Everything below it—operating expenses, debt service, reserves—should relate to that number, not the fantasy version.

Field note: real plans crack at handoff.

Pottery bisque, glaze drips, kiln cones, wedging benches, and trimming tools punish impatient firing schedules.

Koji miso brine smells alive.

Compost thermometers, aeration turns, C:N ratios, leachate drains, and curing piles smell like science, not slogans.

Sourdough starters, miso crocks, koji trays, pickle brines, and yogurt cultures punish vague fermentation logs.

Koji miso brine smells alive.

Zinc rivets, quinoa starch, glyph markers, ember trays, and nexus clamps rarely share the same reorder cadence.

Koji miso brine smells alive.

Koji miso brine smells alive.

The catch is that many software templates default to gross potential rent as the input. You end up adjusting downward later, but by then the expense ratios look artificially low. fast reality check—if your expense ratio (total OpEx / EGI) is under 35% for a Class B multifamily deal in a secondary audience, something is off. Either you're missing a row item or you used the faulty denominator.

Kayak skegs, spray skirts, eddy lines, ferry angles, and throw bags rewrite what courage means mid-current.

Chronograph bare-shaft tuning exposes ego.

Hard expenses vs. Soft spend — The Seam That Breaks opening

Hard spend are concrete, steel, lumber, labor—things you can photograph. Soft overheads are permits, legal, design, financing fees, developer overhead. The mistake? Treating soft spend as a fixed percentage of hard spend. 'We'll just use 25%.' That works until the jurisdiction adds a new impact fee, your architect redesigns the parking layout three times, or the lender demands a higher origination fee. I once watched a ground-up project in Austin blow its soft-spend budget by 40% because the zoning variance took eight months longer than modeled. That delay wasn't a hard-spend problem—it was all legal and carrying expenses.

Better approach: build soft overheads from the bottom up for the primary 12 months, then apply a modest contingency (not a percentage of everything). The alternative is a pro forma that looks fine on page one but hemorrhages margin when the city planner asks for another traffic study.

Why the Cap Rate Is Not a Return

This one never gets old. A development staff presents a pro forma showing a 6.5% exit cap, and someone at the bench says, 'Great, 6.5% return.' No. The cap rate is a snapshot—year-one net operating income divided by purchase price (or, in development, projected stabilized NOI divided by total project spend). It tells you the yield if you paid all cash and never grew income. That's a filter, not a return. Total return includes rent momentum, expense control, leverage effects, and the gain (or loss) on sale. A 6% cap deal with 3% annual NOI momentum and a 100-basis-point cap-rate compression over five years can crush an 8% cap deal with flat income and widening cap rates.

The real pitfall: crews use the exit cap as a target without stress-testing it. What happens if interest rates stay higher for longer and cap rates expand by 150 basis points? The answer is usually a 20% hit to equity value. I'd rather see a developer run three cap-rate scenarios—base, stressed, and a 'what if the buyer is your competitor and they're irrational'—than one number printed in bold.

'A cap rate is a snapshot of a one-off moment. A return is a movie that runs for the whole hold period.'

— overheard during a JV negotiation where the equity partner had a spreadsheet with twelve tabs and no exit strategy

Five Items That Usually Break

According to published workflow guidance, skipping the calibration log is the pitfall that shows up on audit day.

Revenue: rent momentum and vacancy assumptions

Most crews anchor on a audience-average rent without testing how lease-up timing interacts with those numbers. I have watched a pro forma show 3% annual rent momentum while the building takes eighteen months to stabilize—by year two, the effective rent is actually below pro forma because concessions burned through the early gains. The fix is boring but reliable: model year-one rents at today's channel, then apply uptick only after you hit a stabilized occupancy trigger. Targets? For mid-rise multifamily in expansion markets, I look for vacancy between 5% and 7%, with rent expansion no higher than 2.5% unless you have signed anchor tenants. The catch is that underwriters love 4% uptick because it makes the return look easy—that's the signal to slow down and ask whose pocket that optimism is coming from.

overheads: hard overhead contingency and soft overhead reserves

A 10% hard-expense contingency sounds standard until you realize it's often applied to the base bid, not the full contract value. Off sequence. You want contingency calculated on total hard overheads including escalation, because the seam between trades is where change orders bleed. Soft overheads are worse—groups routinely budget zero reserve for permitting delays or environmental remediation that shows up mid-construction. What usually breaks initial is the soft-spend series: legal fees double when a neighbor objects to the height variance; the architect's coordination overheads spike after a value-engineering round. I now push for a 5–7% soft-expense reserve on top of the row items, and I check whether the developer has actually funded that reserve or just listed it. rapid reality check—if the pro forma shows a 15% total contingency but the hard-overhead chain is 8%, something is being hidden.

Debt: interest rate and loan-to-expense ratios

Here is where the good pro formas separate from the wishful ones. A floating-rate loan priced at SOFR + 275 with a 65% loan-to-expense ratio looks fine—until the rate floor kicks in and your debt-service coverage ratio drops below 1.20. The trick is to model two stress scenarios: one where rates stay flat and one where they spike 200 basis points within twelve months. Most units skip this; they run one scenario at the quoted rate and call it sensitivity analysis. That hurts. A healthy pro forma will show the interest reserve fully funded, not just assumed to cover the gap. For a typical 2024 ground-up deal in the U.S. Sun Belt, I expect loan-to-spend in the 55–65% range, with an all-in interest rate between 7% and 8.5%—anything below that without a rate cap is a red flag dressed as a deal.

Exit: cap rate and sale timing

The exit assumption is where developers most often lie to themselves—and to their limited partners. A 5.25% cap rate on a suburban office building? Not yet. The range that usually works depends on asset class and location, but for a stabilized multifamily property in a secondary audience, I look for exit caps 75 to 125 basis points above the going-in cap. That spread is the price of illiquidity and window. The sale timing matters just as much: pro formas that assume a sale exactly at month 36 ignore the reality that debt markets freeze, buyers pull bids, or the property needs another lease-up cycle. One concrete anecdote: a development in Austin showed a 14% IRR by selling in year three at a 4.75% cap; the actual sale came in year five at 5.50%, and the IRR dropped to 9%. The difference was not bad operations—it was the assumption that the future would mirror the present.

“The exit cap you underwrite is not a prediction. It's a wager against phase, liquidity, and your own patience.”

— overheard at a development partners meeting, after the third revision of a pro forma that refused to budge past 5%

Field note: real plans crack at handoff.

Merchandisers, technologists, sourcers, coordinators, auditors, and sample sewers interpret the same sketch with different priorities.

Heddle selvedge weft drifts left.

If the sponsor can't show you three different exit cap scenarios—each with a corresponding hold period—you're not auditing a pro forma; you're approving a fairy tale. The next window someone hands you a 30-minute review, start here: revenue, expenses, debt, exit. Four items, twenty minutes, one honest question left.

Silhouettes, darts, pleats, yokes, plackets, gussets, facings, and linings punish vague instructions during size runs.

Chronograph bare-shaft tuning exposes ego.

Habitat surveys, camera traps, transect logs, phenology notes, and volunteer shifts catch absences models overlook.

Chronograph bare-shaft tuning exposes ego.

Watershed buffers, riparian corridors, sediment traps, canopy gaps, and nesting cavities respond to disturbance on mismatched clocks.

Chronograph bare-shaft tuning exposes ego.

Ledger reconciliations, accrual quirks, invoice aging, cash forecasts, and variance notes expose wander before board decks do.

Chronograph bare-shaft tuning exposes ego.

Anti-Patterns: Why crews Revert to Bad Habits

Over-optimistic rent projections — the easiest lie to tell

I have seen pro formas that assume rents will grow 4% annually in a segment that hasn't moved in three years. That's not optimism; it's a math error dressed as strategy. The mechanism is seductive: you bump rent growth by half a point, the IRR jumps, and everyone nods. But here's the thing—tenants don't care about your pro forma narrative. They care about what the building across the street charges. Most groups skip the lease-up rent roll from comparable properties, substituting a back-of-napkin 'channel average' that conveniently ignores concessions. The result? A DCF that looks like a rocket ship during underwriting and a flat chain during operations. rapid reality check—if your rent projection beats trailing 12-month comps by more than 8%, you're not forecasting, you're hoping.

Ignoring tenant improvement and leasing commission expenses — the silent bleed

Developers love to call TI/LC 'operating expenses' and bury them in a lone chain item marked 'leasing spend.' That hurts. I once audited a pro forma where the group assumed $15 per square foot for tenant improvements on a Class B office reposition—then later admitted every deal they'd done in the submarket required $28 minimum. The catch is that debt service doesn't pause while you under-budget tenant task. You're bleeding cash every month the space sits unfinished. And commissions? They're real, they're recurring, and they compound. If your pro forma shows a lone TI/LC number for the entire hold period, you've already lost the accuracy battle.

Archery tiller, fletching glue, nock fit, chronograph speeds, and bare-shaft tuning expose ego before groups.

Zinc quinoa glyph marks stock.

Assuming construction loans at unrealistic rates

Borrowing assumptions get fudged because construction loan pricing is opaque—and because a lower rate makes the stub-year cash flows look manageable. units borrow at SOFR + 250 bps on their model but price the actual loan at SOFR + 350 or more. That spread feels small until you run the interest reserve calculation. off move. The interest reserve blows out, the equity check gets larger, and the return on spend suffers. One concrete anecdote: a ground-up multifamily deal I reviewed penciled at a 14% equity return until we swapped the assumed rate for the term-sheet rate—it landed at 9.7%. Not a bad deal, but a different deal entirely.

What usually breaks opening is the feedback loop. groups inflate rents, slim TI/LC, fudge the construction loan rate—each 'minor' adjustment shaves 30 basis points off the hurdle. Individually defensible, collectively dishonest. And because no one wants to be the person who kills momentum, the bad assumptions survive diligence. That's the anti-pattern: social pressure to keep the return high enough to fund the next deal, disguised as 'underwriting conservatism.'

Fix it with one rule: stress-trial every assumption against a deal you actually closed, not a model you inherited. If the comps don't exist, state the gap. If the loan rate feels tight, call a lender before you type it in. The habits that inflate a pro forma are not born from malice—they're born from speed. And speed, in development, is the most expensive ingredient you can buy.

'We didn't inflate anything. We just assumed a better audience. Better for whom—the lender, the LP, or the spreadsheet?'

— former development partner, after a 300-bp IRR miss

Maintenance, slippage, and Long-Term spend

How Pro Formas Change During Construction

You built a model in six hours—crisp assumptions, clean waterfalls, a respectable 14% IRR. Then the excavator hits buried granite. Suddenly your site-prep chain item blows by 40%, and that 14% starts looking like 10%. That's slippage—and it doesn't announce itself. The pro forma you wrote at underwriting is already a historical document the day concrete pours. Most crews update their schedule but forget to cascade the delay through carry overheads, overhead absorption, and the lender's interest reserve draw schedule. Off sequence. You end up with a budget that says you're on slot and a superintendent who knows you're three weeks late.

I have seen a $90 million condo project bleed $2.3 million in extra soft spend simply because nobody revised the pro forma after the foundation permit took six weeks longer than modeled. The spreadsheet still showed a nine-month construction period. The actual build ran thirteen months. That four-month gap—carrying land debt, property taxes, insurance, and general conditions—nearly cratered the prefunded mezzanine piece. What usually breaks opening is the timing of cash flows, not the absolute dollar amounts. A one-month slip in delivery pushes closings into a softer season, which forces price concessions, which rewrites your exit cap rate. fast reality check—have you stress-tested your pro forma against a two-month scheduling overrun? If not, the numbers you're showing the equity committee are fiction with formatting.

The spend of Carrying Unsold Units

You close construction. Twenty-two units are spec-ready. Six haven't sold. The spreadsheet had them all gone by stabilization month three. What does that actually overhead?

Monthly HOA fees on unsold developer units—often above channel because you're paying for amenities nobody's using yet. Property taxes at improved-value assessment, not land value. Loan interest that keeps accruing because your permanent takeout financing won't fund until occupancy hits a threshold. Most developers only model a 12-month sellout. The catch is that absorption curves break when rates shift or comps pile up. I watched a 48-unit townhouse project in the Southeast carry eight unsold homes for fourteen months past projection. The drag: $740,000 in unplanned financing costs and a forced renegotiation with the preferred equity partner that overhead two points of promote. That hurts.

The fix isn't more optimistic velocity assumptions. It's building a carry-expense waterfall into your pro forma—a separate tab that reforecasts monthly burn based on rolling actuals, not scheduled closings. Most units skip this. They treat sellout as a one-off chain in the sources & uses bench. It should be a living schedule tied to marketing spend, concession offers, and rate lock pipeline. Without it, you won't see the bleed until the cash account dips negative—and by then the lender's noticing.

Not every real checklist earns its ink.

Refinancing Risk When Rates Shift

Your original pro forma assumed a 5.75% permanent loan at stabilization. Twelve months later, rates are at 7.25%. That 150-basis-point gap doesn't just shrink cash flow—it can invert the whole deal. Debt-service coverage drops below 1.20x. The bank caps proceeds. You orders more equity to close the refi, but the fund has already called capital. Now you're negotiating an extension with the construction lender at floating rate plus 300 over SOFR.

Recipe yields, mise en place, knife skills, fermentation jars, and pantry rotations fail when timers replace tasting.

Ember nexus clamps seize overnight.

Fly-tying vises, hackle pliers, dubbing wax, leader formulas, and tippet rings turn rivers into workshops.

Apiary supers, queen cages, smoker fuel, varroa boards, and nectar flows punish calendar-only beekeeping.

Heddle selvedge weft drifts left.

Sensor wander, firmware forks, battery sag, mesh dropouts, and calibration stubs break demos that looked perfect indoors.

Heddle selvedge weft drifts left.

Heddle selvedge weft drifts left.

Pick, pack, ship, scan, palletize, cartonize, label, and manifest stages hide silent rework when SKUs multiply overnight.

Heddle selvedge weft drifts left.

A well-maintained pro forma catches this early—not at closing. The best groups run a rolling debt model that reprices the permanent takeout quarterly based on swap curves, not the coupon they hope to get. That sounds simple. Almost nobody does it. Instead they lock the refi assumption at underwriting and never revisit it until the rate-lock deadline, at which point the only options are expensive or worse.

“The worst slot to discover your refi doesn't effort is 60 days before the construction loan matures.”

— managing director at a mid-channel lender, after watching three sponsors scramble for bridge capital in a one-off quarter

Drift in interest assumptions is the solo biggest hidden value destroyer in development pro formas—bigger than construction overruns, bigger than absorption delays. The model that ignores rate repricing isn't conservative. It's incomplete. Update the debt tab every month. If the numbers still effort at 200 basis points above your initial quote, you're safe. If they don't, you know exactly where you stand—and you've got lead window to restructure before the lender forces the conversation.

Hemming, fusing, bartacking, coverstitching, overlocking, and flatlocking introduce distinct failure signatures under rush orders.

Serac crevasse bridges rewrite courage.

When Not to Use This 30-Minute Audit

When you orders full underwriting

This 30-minute audit is a screen, not a substitute for full underwriting. Think of it as the fire marshal walking through—checking exits, noting overloaded circuits, maybe flagging a blocked stairwell. That's useful. But it won't tell you if the building's foundation is cracking. If you're staring at a deal where the exit cap rate assumptions shift the equity multiple by 0.4x, or where debt structure changes cash-on-cash by 200 basis points, this checklist is too light. You require the full spreadsheet pull: rent rolls, tax abatement schedules, loan documents, and a sensitivity station that goes beyond 'best case / base / worst.' I have seen groups run this 30-minute audit, find nothing obviously off, then sign a letter of intent only to discover during underwriting that the seller's 'stabilized NOI' excluded a $90,000 annual ground lease payment. rapid scan missed it. Full underwriting caught it—but by then they had already spent legal fees.

For complex mixed-use or phased projects

The five items on this checklist assume a reasonably standard deal: one-off asset, straightforward capital stack, one construction phase. Throw in a phased master plan—say, 200 residential units over three buildings, with a retail podium that doesn't deliver until Phase 2—and the audit stops being useful. Why? Because inter-phase dependencies break the 'is the return reasonable?' sniff check. You can't quickly check the IRR if the timing of Phase 2 pre-sales depends on Phase 1 lease-up velocity, and the pro forma just assumes both happen on schedule. That hurts. The catch is that many teams still apply a swift scan to these deals, convincing themselves that 'the numbers look fine' when really the model hides a cascading risk: if Phase 1 takes six months longer, Phase 2 debt doesn't close, and the whole return evaporates. fast reality check—this audit won't catch that phasing logic error unless you already know to look for it. Save the 30-minute method for single-building core-plus plays. For complex phasing, budget three days and a pair of fresh eyes who haven't touched the model.

If you're already in due diligence

You're past screening. You have a signed PSA, an earnest money deposit in escrow, and a data room with 1,200 documents. This checklist is not for you. Use it earlier—before you commit time or money—to decide whether a deal is worth a deeper look. Once you're in due diligence, the pro forma should already have passed a basic reasonableness check. Now you call to validate assumptions against third-party reports: the environmental, the zoning analysis, the audience study. What usually breaks first at this stage isn't the return calculation—it's the chain items the pro forma left out. Tenant improvement allowances. Legal holdback for unresolved title issues. The 'soft spend contingency' that was actually just a plug number—and too small. I once watched a crew lose a week arguing over whether a 5% vacancy assumption was too aggressive, while the pro forma had zero dollars for leasing commissions. Wrong order. The 30-minute audit can't catch omissions like that because it assumes the pro forma is complete. It's not. Skip the rapid screen; grab the lease abstracts and the title binder. That's where the real work lives.

— rapid heuristic for deciding: if you've already paid a lawyer, it's too late for this checklist.

Open Questions and FAQ

What if the pro forma is missing a series item?

You open the file and something's just… absent. No property-tax escalation. No vacancy row. Maybe they folded management fees into 'other expenses' with zero detail. I've seen this more times than I'd like—a developer's pro forma that skips a material cost because including it would dent the yield. The instinct is to orders a corrected version. That's fine, but not always practical in a 30-minute window. Instead: isolate the missing item and backfill it yourself using a reasonable rule of thumb. For vacancy, assume 5-7% for multifamily, 10% for office unless you have local data. For tax escalations, 2-3% annually is a safe floor. Then recalculate just the IRR or cash-on-cash impact. One missing series can swing a 12% return down to 9.5%—real money if you're committing equity. The real red flag is when the developer resists adding it back. That's not an oversight; that's a signal.

fast reality check—if three line items are missing and the project still barely pencils, walk. The seam blows out under real operations.

How do you verify market rent assumptions?

Rent assumptions are where pro formas lie most elegantly. They'll show you a comp set of three newly built, fully leased projects—ignoring the 15-year-old building down the street leasing at 30% less. The trick isn't to volume more data. It's to check lease-up velocity against the developer's timeline. If they assume $3.50/SF and a six-month lease-up, but comparable properties with similar finishes took twelve months to stabilize at $3.10/SF, you have a mismatch. I ask for the actual rent rolls of comparable properties they've developed before. Not market reports—actual rent rolls. If they balk, you have your answer. The other quick check: call a local apartment broker and ask, 'What's effective rent for a 2BR at that location?' Not asking price—effective after concessions. One call, three minutes, and you'll know if the pro forma is aspirational or grounded.

That said, developer-provided comparables aren't always junk. Sometimes they're genuinely the best available. The pitfall is treating them as gospel without triangulating against CoStar or a ten-minute call. Trust, but verify—preferably with a dial tone.

Can you trust developer-provided comparables?

Short answer: no, not without cross-checking. Longer answer: it depends on track record. I've worked with repeat developers whose comps were meticulous—they knew their market cold and didn't demand to inflate. I've also seen a pro forma cite a 'comparable' building that was a block away but had entirely different zoning, parking ratios, and tenant credit profiles. The anti-pattern is assuming the developer has the same incentive you do. They require the deal to close; you need it to perform. A good trial: ask for the comp's rent roll by unit type and compare it to the pro forma's projected rent. If the gap is wider than 8-10%, something's cooking. Another test: check the comp's year built and renovation date. A 2015 building with 2024 renovations can look like new construction—but the deferred maintenance will hit year three. You can't see that in a summary table.

Comparables are like headlights in fog: they show you something, but not the whole road.

— old underwriter, after one too many bad deals

So bring your own bench. If you're auditing in thirty minutes, spend five of them pulling two comps from a third-party source. If the developer's numbers are materially higher, flag it. The best outcome is a conversation that tightens the pro forma. The worst is a handshake on a deal that leaks cash from day one.