The Pro Forma Deep Dive: A 10-Point Checklist for Modern Developers to Stress-Test Project Assumptions

Every development deal starts with a pro forma that looks great on paper. The question is whether it survives contact with reality. We've seen too many projects where the underwriting assumed 3% annual rent growth, construction came in 15% over budget, and the exit cap expanded by 100 basis points. Suddenly that 18% IRR turns into a single-digit return — or worse, a loss. This article walks through a 10-point checklist to stress-test your assumptions before you commit equity or sign a loan. Use it as a review framework for your next deal.

1. Why Pro Forma Assumptions Fail — and What We Can Do About It

Pro formas fail for one reason more than any other: optimism bias. Developers want the deal to work, so they unconsciously push assumptions to the optimistic end of the range. Rent growth projections get set at the top of historical trends. Operating expenses get modeled as a flat percentage of revenue, ignoring that insurance and property taxes have been rising faster than inflation. Construction costs assume no material price spikes. The result is a base case that is really a best case.

We need to shift from asking "what is the most likely outcome?" to "what range of outcomes is plausible?" That means modeling not just a base case, but also a downside case and a stress case. The stress case should reflect conditions we have seen in the last two downturns: a 20% drop in revenue, a 15% increase in operating costs, and a 200-basis-point expansion in exit cap rates. If the deal still shows a positive return under those conditions, it is probably solid. If it breaks even or loses money, the underwriting needs to be adjusted — either by lowering the acquisition price, increasing equity, or restructuring the debt.

Another common failure is ignoring the time value of money in a rising rate environment. A pro forma that shows a 15% IRR over five years might look attractive, but if interest rates increase during the hold period, the cost of debt eats into cash flow. We recommend stress-testing the debt service coverage ratio (DSCR) under a 200-basis-point rise in interest rates. If the DSCR drops below 1.2, the deal is too leveraged.

The takeaway: build your pro forma with humility. Assume that some assumptions will be wrong. The goal is not to predict the future perfectly, but to understand which variables have the biggest impact on returns, and to ensure the deal can absorb bad news.

2. The 10-Point Checklist: What to Review Before You Commit

We have organized the checklist into ten items, grouped into four categories: revenue, costs, financing, and exit. Each item includes a specific question to ask and a red flag to watch for. Use this as a review agenda for your next investment committee meeting.

Revenue assumptions

1. Rent growth: What annual rent growth rate is assumed? Compare it to the trailing five-year average for the submarket. If the pro forma assumes 3% but the market has delivered 2%, that is a red flag. Also check whether the model includes rent concessions or free rent periods — those are real costs that reduce net effective rent.

2. Occupancy: What stabilized occupancy is assumed? For multifamily, 93-95% is typical. For office, 85-90% is more realistic in many markets. If the pro forma assumes 95% occupancy for a Class B office building in a suburban market, that needs a reality check. Also look at the lease-up period — how long does it take to reach stabilized occupancy? Many models assume a linear lease-up that is faster than what actually happens.

3. Other income: What is included in other income? Parking fees, laundry, storage, and pet rent can add 5-10% to revenue, but those projections are often optimistic. Check whether the assumptions are based on comparable properties or just a percentage of gross rent.

Cost assumptions

4. Operating expenses: What expense growth rate is used? Property taxes and insurance have been rising 5-7% annually in many markets. If the model uses 2-3% growth, it is understating reality. Also check whether the model includes a management fee — typically 3-5% of effective gross income — and whether that fee is realistic for the asset type.

5. Capital expenditures: Does the pro forma include a reserve for capital expenditures? Many models assume zero CapEx in the first few years, but real properties require ongoing investment. A rule of thumb is $300-$500 per unit per year for multifamily, or $0.50-$1.00 per square foot for commercial. If the model does not include CapEx, the cash flow is overstated.

6. Construction costs (for development deals): What contingency is included? Industry standard is 5-10% of hard costs. If the contingency is less than 5%, that is a red flag. Also check whether the model includes escalation for labor and materials — many construction contracts have escalation clauses that pass cost increases to the developer.

Financing assumptions

7. Interest rate and terms: What interest rate is assumed? Is it fixed or floating? If floating, what spread over SOFR? Stress-test the model with a 200-basis-point increase in rates. Also check the loan-to-cost (LTC) ratio — if it is above 70%, the deal is highly leveraged and more sensitive to cash flow shortfalls.

8. Debt service coverage: What DSCR is projected? Lenders typically require 1.25x or higher. If the pro forma shows a DSCR of 1.10x in the first year, the deal will struggle to get financing — and if it does, there is no room for error.

Exit assumptions

9. Exit cap rate: What cap rate is used to calculate the sale price? Compare it to current market cap rates for similar assets. If the pro forma uses a cap rate that is 50 basis points lower than current market, that assumes compression — which may not happen. Use a range: base case at current market, downside case at +100 basis points.

10. Exit timing: What hold period is assumed? Most pro formas use a 5-year hold, but market conditions may force a longer hold. Test what happens if you hold for 7 or 10 years — does the IRR still meet your target? Also check whether the model assumes a sale at the end of the hold period, or does it allow for refinancing? A refinancing assumption can mask a weak exit.

3. How to Stress-Test Each Assumption: Practical Methods

Stress-testing is not just about changing one number at a time. The most informative analysis is a multi-variable stress test that changes several assumptions simultaneously. For example, what happens if rent growth is 1% lower, operating expenses are 2% higher, and the exit cap is 100 basis points higher? That scenario is more realistic than changing one variable in isolation.

We recommend using a tornado chart to identify which variables have the biggest impact on returns. Rent growth, exit cap rate, and construction costs (if applicable) are usually the most sensitive variables. Focus your stress-testing on those. If a 1% change in rent growth changes the IRR by 2%, that assumption deserves extra scrutiny.

Another method is scenario analysis: create three scenarios — base, downside, and stress. The downside scenario might reflect a mild recession (rent growth flat, occupancy 2% below stabilized, exit cap +75 bps). The stress scenario might reflect a severe recession (rent down 5%, occupancy 10% below stabilized, exit cap +200 bps). If the stress scenario still shows a positive cash-on-cash return of at least 5%, the deal has a margin of safety.

Don't forget to stress-test the construction timeline for development deals. Construction delays are common — a 6-month delay can push the project into a different interest rate environment and increase carrying costs. Model what happens if completion is delayed by 6 or 12 months. The impact on returns can be significant, especially if the loan has a maturity date that the project cannot meet.

4. Common Pitfalls in Pro Forma Underwriting

Even experienced developers fall into these traps. Here are the most common ones we see.

Pitfall 1: Using market averages without verifying. A pro forma might assume 5% vacancy because "that's the market average." But the market average includes Class A properties with high occupancy. If your asset is Class B or C, vacancy might be 7-8%. Always benchmark against comparable properties, not the entire market.

Pitfall 2: Ignoring leasing costs. Many models assume that leases renew automatically with no cost. In reality, tenant improvements (TIs) and leasing commissions can be significant — $20-$50 per square foot for office space, and $500-$1,000 per unit for multifamily. If the model does not include these costs, it overstates net operating income (NOI) in years with lease expirations.

Pitfall 3: Assuming constant expenses as a percentage of revenue. Operating expenses are not a fixed percentage of revenue. Property taxes and insurance are based on assessed value and market conditions, not on your rental income. Model them as line items with their own growth rates.

Pitfall 4: Using a single exit cap rate. Cap rates change over time. A deal that looks good at a 5% cap might be underwater at a 6.5% cap. Always model a range of exit cap rates and understand the breakeven cap rate — the cap rate at which your return drops to zero.

Pitfall 5: Overlooking the cost of capital. Equity is not free. If your pro forma shows a 12% IRR but your equity investors expect a 15% return, the deal destroys value. Make sure your return thresholds are aligned with your cost of capital.

5. Implementing the Checklist: A Step-by-Step Process

Knowing the checklist is one thing; using it consistently is another. Here is a process to integrate stress-testing into your deal flow.

Step 1: Build the base case pro forma

Start with realistic assumptions based on market data and comparable properties. Do not use the seller's pro forma as your base — they are incentivized to show optimistic numbers. Build your own from scratch using third-party data sources (CoStar, REIS, local market reports).

Step 2: Run the 10-point checklist

Go through each of the ten items and document your assumptions. For each assumption, note the source of the data and the rationale. If an assumption is aggressive, flag it and consider adjusting it downward.

Step 3: Build three scenarios

Create base, downside, and stress scenarios. The downside scenario should reflect a mild recession (e.g., rent growth 0%, occupancy 90%, exit cap +100 bps). The stress scenario should reflect a severe recession (e.g., rent decline 5%, occupancy 85%, exit cap +200 bps). Calculate key metrics (IRR, equity multiple, cash-on-cash return) for each scenario.

Step 4: Identify the key variables

Use a sensitivity analysis to see which variables have the largest impact on returns. Focus your due diligence on those variables. For example, if the deal is highly sensitive to rent growth, spend extra time researching market rents and lease-up velocity.

Step 5: Set decision rules

Define what returns you need in each scenario. For example: "We will proceed only if the base case IRR is above 15%, the downside IRR is above 10%, and the stress IRR is above 5%." If the deal does not meet these thresholds, either renegotiate the terms or walk away.

This process takes time, but it prevents costly mistakes. One bad deal can wipe out the profits from several good ones. The checklist is a tool to protect your capital and your reputation.

6. Real-World Example: How One Deal Survived the Stress Test

Let's look at a composite example based on common patterns we have observed. A development team was underwriting a 200-unit multifamily project in a Sun Belt market. The base case assumed 3% annual rent growth, 93% stabilized occupancy, a 5.5% exit cap rate, and construction costs of $250,000 per unit. The projected IRR was 16%.

When the team applied the 10-point checklist, they found several issues. First, the rent growth assumption of 3% was above the market's five-year average of 2.2%. Second, the exit cap rate of 5.5% was 50 basis points below current market cap rates for similar projects. Third, the construction cost contingency was only 4% — below the recommended 7% for that market. The team adjusted the base case to 2.5% rent growth, a 6.0% exit cap, and a 7% contingency. The revised base case IRR dropped to 13%.

They then built a downside scenario: rent growth 1%, occupancy 90%, exit cap 7.0%, and a 6-month construction delay. The downside IRR was 8%. The stress scenario — rent decline 2%, occupancy 85%, exit cap 8.0%, and a 12-month delay — showed a 3% IRR. The team decided that the stress scenario was too risky given the amount of equity required. They went back to the seller and negotiated a lower land price, which improved the returns. The deal eventually closed with a different capital stack that included more equity and a lower loan-to-cost ratio.

The key lesson: the stress test did not kill the deal — it made the team aware of the risks and allowed them to adjust the terms. Without the checklist, they might have proceeded with the original underwriting and faced significant losses if the market turned.

7. Frequently Asked Questions

Q: How many scenarios should I run?
A: At least three: base, downside, and stress. Some teams also run an upside scenario, but that is less critical. The downside and stress scenarios are where you learn the most about risk.

Q: What is the most important assumption to stress-test?
A: Exit cap rate and rent growth are usually the most impactful. For development deals, construction costs and timeline are also critical. Use a sensitivity analysis to identify the top three variables for your specific deal.

Q: How do I get reliable data for assumptions?
A: Use third-party market reports from firms like CoStar, CBRE, or local brokerage houses. Do not rely solely on the seller's data. For construction costs, get bids from at least three general contractors. For operating expenses, ask property managers for actuals from comparable properties.

Q: What if my stress scenario shows a loss? Should I walk away?
A: Not necessarily. A loss in the stress scenario means the deal is risky, but you might still proceed if you can adjust the terms — lower the purchase price, reduce leverage, or add more equity. The stress test tells you how much buffer you need. If you cannot achieve a reasonable return even after adjustments, then walking away is the right move.

Q: How often should I update the stress test during the project?
A: At every major milestone: when you get updated construction bids, when interest rates change, when market conditions shift, and before you close on financing. The assumptions you made at underwriting may no longer be valid six months later.

Q: Is this checklist applicable to all property types?
A: Yes, with adjustments. For office and retail, pay extra attention to tenant credit quality and lease expiration schedules. For industrial, focus on rent growth and vacancy. For hospitality, stress-test revenue per available room (RevPAR) and occupancy. The principles are the same, but the specific assumptions differ.

Q: What is the biggest mistake developers make when stress-testing?
A: Not doing it at all, or doing it only superficially. Many developers run a single scenario with optimistic assumptions and call it a day. The value of stress-testing is in the discipline of questioning every assumption and preparing for the worst. That discipline separates successful developers from those who lose money in downturns.