Financial Model

What's Inside a CRE Model

• Income: the rent roll, market rents, lease-up, vacancy and concessions, leading to effective gross income.
• Expenses: operating expenses, split between fixed costs and variable costs, leading to NOI.
• Capital: capital expenditures, TI and leasing commissions, and reserves.
• Financing: loan amount, rate, amortization and fees, leading to levered cash flow and DSCR.
• Exit: sale price from a going-out cap rate, less costs of sale.
• Returns: IRR, equity multiple, cash-on-cash, and the waterfall if there are partners.

Pro Forma vs. Financial Model

People use the words loosely. A pro forma is usually the projected income statement, often a single stabilized year. A full financial model runs the whole hold period, month by month or year by year, adds financing and the sale, and lets you change assumptions and watch the results move. A discounted cash flow analysis is the valuation method most models are built around.

Stress-Testing: Where Models Earn Their Keep

A model that only shows the base case is a sales document. Run the downside: vacancy up, rent growth flat, the exit cap 50 to 100 basis points higher than going in, insurance and taxes up. In Florida, test insurance hard; the insurance market has moved faster than most models assumed. Then ask what has to be true for the deal to lose money. If the answer is "not much," you've learned more than the base case could tell you.

A Hypothetical Daytona Beach Example

A buyer is modeling a 96-unit multifamily property in Daytona Beach. The seller's model shows a strong IRR, built on 4% annual rent growth, flat insurance, and an exit cap equal to the going-in cap. In this example, the buyer rebuilds the model with 2.5% rent growth, a 20% insurance increase in year one, and an exit cap 75 basis points higher.

The IRR drops sharply, and the DSCR in year one gets tight. The buyer doesn't walk. It uses the model to support a lower price and to size the loan to the conservative case, so the deal still works if things go only half as well as the seller promised. Hypothetical scenario and figures.

Common Model Mistakes

• Growing rents and holding expenses flat.
• Exiting at a lower cap rate than you bought at without a reason.
• Leaving out capital reserves, leasing costs or closing costs (see sources and uses).
• Hard-coding numbers inside formulas where nobody can see them.
• Trusting a seller's model without rebuilding it from the rent roll and trailing financials.

From the Desk

I've never seen a deal go bad because the spreadsheet had a formula error. I've seen plenty go bad because the spreadsheet was right and the assumptions were wishful. Build the model to find the weak spot, not to win the argument.

Run the Numbers

Build and stress-test a deal with our free underwriting tools.

What is a financial model in commercial real estate?

A projection of a property's income, expenses, capital costs, financing and sale over a hold period, used to estimate cash flow and returns.

What's the difference between a pro forma and a financial model?

A pro forma is usually a projected income statement; a full model covers the whole hold period, financing, the sale and returns.

What returns does a CRE model calculate?

Typically IRR, equity multiple, cash-on-cash return, DSCR and, for partnerships, the distribution waterfall.

What assumptions matter most in a model?

Rent growth, vacancy, operating expenses (especially insurance and taxes in Florida) and the exit cap rate.

How do you stress-test a real estate model?

Run downside cases with higher vacancy, slower rent growth, higher expenses and a higher exit cap, and find the break-even point.

Should I trust the seller's financial model?

Use it as a starting point, but rebuild it from the rent roll, trailing financials and your own assumptions.

Article Summary

A financial model projects a property's income, expenses, financing and sale to estimate returns such as IRR and equity multiple. Its real value is stress-testing the few assumptions a deal depends on, like rent growth, insurance costs and the exit cap rate.

Key Takeaways

• ✓Models project income, expenses, debt, sale and returns.
• ✓A pro forma is one part of a full model.
• ✓Rent growth and exit cap drive most of the result.
• ✓Stress-test insurance and taxes in Florida.
• ✓Rebuild seller models from source documents.
• ✓Use the model to find the weak spot.

About Michael R. Linton

Michael R. Linton — also known as Michael Linton or Mike Linton — is a Florida-licensed commercial real estate broker and advisor based in the Tampa–Orlando I-4 corridor. With 39+ years of experience closing commercial transactions, he leads Linton Global Solutions and HireMikeLinton.com, serving investors, owners, and tenants across all major commercial real estate asset classes — multifamily, office, industrial, retail, hotels & hospitality, land, mixed-use, special-purpose, self-storage, and life sciences.

Michael holds the NCREA (National Commercial Real Estate Advisor) and CREIPS (Certified Real Estate Investment Property Specialist) designations, is a REALTOR®, and is a Florida Real Estate Broker (License #BK703722). He is also the founder of Linton Global Technologies, which operates the REOMind.ai AI-powered REO disposition platform serving a network of banks.

Ready to Talk About Your Financial Model Deal?

Get a free consultation with Michael R. Linton — 39 years of CRE experience. Zero pressure.

Works Cited

1. CFA Institute. "Real Estate Investments: Valuation and Analysis." CFA Institute, https://www.cfainstitute.org/. Accessed Sep 29, 2026.
2. Florida Department of Business and Professional Regulation. "License Verification: Michael R. Linton, Florida Broker BK703722." MyFloridaLicense.com, https://www.myfloridalicense.com/wl11.asp. Accessed Sep 29, 2026.
3. Florida Legislature. "Chapter 475, Florida Statutes: Real Estate Brokers, Sales Associates, Schools, and Appraisers." Online Sunshine, http://www.leg.state.fl.us/statutes/index.cfm?App_mode=Display_Statute&URL=0400-0499/0475/0475.html. Accessed Sep 29, 2026.

Disclosure & Compliance

Disclosure: This article discusses proprietary technology developed by Linton Global Technologies. Michael R. Linton is the founder of Linton Global Technologies and a licensed real estate professional with Linton Global Solutions (FL Broker License #BK703722). This content is for informational purposes only and does not constitute investment, legal, or financial advice.

Compliance Statement: All CREDDS and REOMind.ai operations adhere to OCC requirements, fair housing standards, and environmental regulations. Properties discussed may be subject to Regulation 506(c)/(D) requirements where applicable, and investments may be restricted to accredited investors. Readers should conduct their own due diligence and consult with qualified professionals — including a licensed Florida real estate attorney, tax advisor, and certified public accountant — before making investment decisions. Past performance does not guarantee future results.