Financial Models Don’t Calculate Value — They Narrate It

Summary

Financial models—especially in commercial real estate (CRE)—are often seen as precise, objective tools that determine value. This article challenges that idea. It explores how underwriting models actually tell a story about an asset’s future, breaking down how each component (lease-up, cash flows, taxes, capital plans) reflects assumptions and intent. It then confronts a harder truth: models frequently evolve to justify a negotiated price, not discover it. Through examples, we’ll unpack both the storytelling power and the practical limitations of financial models.

The Model as a Narrative Engine

Looking at a CRE underwriting model as just a set of calculations is a mistake. A well-built model is a structured narrative—it encodes how an underwriter believes an asset will evolve over time.

Every tab, every schedule, every assumption answers a question:

“What needs to happen for this investment to work?”

Take a value-add multifamily deal in Dallas. The in-place rents may be below market, occupancy might be suboptimal, and operating costs could be inefficient. The model doesn’t just crunch numbers—it lays out a transformation plan:

• How quickly units will be renovated

• How much rents can be pushed

• When stabilized occupancy will be achieved

In effect, the model tells the story of moving from “today’s reality” to “tomorrow’s potential.”

Lease-Up: The Timeline of Belief

The lease-up schedule is one of the clearest expressions of this narrative.

Consider an office repositioning in Atlanta. A vacancy-heavy building is underwritten with a 24-month lease-up plan. The model specifies:

• Timing of tenant acquisitions

• Tenant Improvement (TI) allowances

• Leasing commissions

• Free rent periods

But beneath these inputs lies a deeper story:

• Is the sponsor buying occupancy through aggressive concessions?

• Are higher TI costs justified by higher headline rents?

• Which spaces are assumed to lease faster—and why?

The lease-up schedule doesn’t just project occupancy—it reveals the strategy and confidence level of the underwriter.

Cash Flow: The Economic Reality Check

If the lease-up is the plan, the cash flow is the consequence.

A discounted cash flow (DCF) model shows when money comes in and when it goes out—but more importantly, it reveals timing risk.

Imagine an industrial deal in Chicago. Two models may show identical IRRs, but:

• One assumes early leasing and stable cash flows

• The other backloads income with delayed stabilization

The difference?

Capital timing.

Needing debt earlier reduces equity returns. Delayed cash inflows increase risk exposure.

The cash flow statement, therefore, tells a story about:

• Liquidity pressure

• Financing dependency

• Sensitivity to delays

A single missed lease assumption can ripple through the entire model.

Real Estate Taxes: The Hidden Inflection Point

Tax assumptions often look mechanical—but they’re deeply contextual.

In states like California, property tax reassessment rules (e.g., under Proposition 13) can significantly alter post-acquisition expenses. In contrast, markets like Houston may see more frequent reassessments aligned with market value.

A model that assumes flat taxes versus one that underwrites a sharp increase post-sale is telling two very different stories:

• One assumes cost stability

• The other anticipates margin compression

The tax schedule, therefore, encodes local regulatory reality into the financial narrative.

Operating Assumptions: Signals of Asset Complexity

Subtle line items often reveal the most about an asset.

Property Management

A higher management fee might indicate:

• Operational complexity

• Tenant issues

• Need for active repositioning

Utilities

Are expenses benchmarked to historicals, or is there an assumption of renegotiation?A reduction in utility costs implies:

• Operational efficiency gains

• Or optimistic cost restructuring

Capital Plan

A heavy upfront CapEx plan suggests a transformation story:

• Renovations to justify rent increases

• Deferred maintenance being addressed

Tenant Replacement

Replacing below-market tenants with higher-paying ones sounds straightforward—but it assumes:

• Lease rollover timing

• Market demand depth

• Execution capability

Each of these inputs is a character in the story—together, they define how believable the narrative is.

The Uncomfortable Truth: The Model Follows the Price

Here’s where theory meets reality.

Transactions don’t happen in spreadsheets. They happen in the market.

A buyer and seller negotiate a price based on:

• Market sentiment

• Competitive bidding

• Strategic fit

• Timing pressures

Only after this does the model come into full focus.

In many cases, the underwriting process becomes an exercise in:

“What needs to be true for this price to make sense?”

For example, in a competitive multifamily acquisition in Phoenix, a buyer may stretch assumptions:

• Faster lease-up

• Higher exit cap compression

• More aggressive rent growth

The model is then calibrated until the IRR meets the investment threshold.

At this point, the model is no longer discovering value—it is rationalizing it.

When the Story Breaks

The danger lies in execution.

If even one key assumption fails:

• Lease-up is slower

• Costs run higher

• Tenants don’t renew

The entire narrative begins to unravel.

A delayed lease in year one doesn’t just affect that year—it cascades:

• Lower cash flows

• Higher debt reliance

• Reduced distributions

• Lower exit valuation

What looked like a coherent story in Excel becomes a fragmented reality on the ground.

Conclusion: Model as Proof, Not Truth

Financial models are powerful—but not because they calculate value with precision.

They are powerful because they:

• Structure thinking

• Force assumptions into the open

• Provide an auditable trail

But ultimately, they serve a more pragmatic role:

They justify a price that has already been negotiated.

The model is not the transaction—it is the documentation of belief behind it.

And like any story, its strength lies not in how well it is written, but in how closely it matches reality over time.