Have you ever wondered how to analyze and project your ROI in commercial real estate investment? The term is “pro forma”, a fancy way for evaluating if you are investing in a winner, and with what factors. Today, we are starting a two-part series.
A well-built commercial real estate pro forma projects how a property may perform under different assumptions about rent, vacancy, financing, operating expenses, capital improvements, appreciation, and exit value.
But experienced investors know that a commercial real estate pro forma is only useful if the assumptions behind it are realistic.
A spreadsheet can calculate a cap rate, internal rate of return, cash-on-cash return, or projected future value. The harder part is deciding what numbers should go into the model in the first place.
That requires knowledge of the property, financing environment, local rental market, operating costs, tenant demand, land economics, future capital requirements, and broader economic climate.
For that reason, I view a pro forma as a dynamic financial framework, not simply a one-time acquisition worksheet.
It should help investors answer a larger question:
What is the best real estate strategy for this property over the next 3, 5, 10, 15, or 20 years?
– To watch Pt 1 as a video
– To listen to Pt 1 as a podcast
👉 To learn more, you can access, for a small fee, more case studies
👉 Subscribe to The Ivy Group newsletter
A commercial real estate pro forma is a financial projection that estimates a property’s future income, expenses, cash flow, financing obligations, and potential investment returns.
Investors and their commercial real estate advisors use the pro forma to evaluate financial feasibility and compare different strategies.
Depending on the property and CRE investment objective, the model may include:
The purpose is to understand how the investment may perform under realistic operating and market conditions.
Investors frequently begin with the capitalization rate, or cap rate. We explained about what cap rate is and how to calculate and use it in one of our articles on https://theivygroup.com/blogs-commercial-property/.
Cap rate is generally calculated by dividing a property’s net operating income by its value or purchase price.
For example, if a property generates $500,000 of annual net operating income and is valued at $10 million, the cap rate would be 5.0%.
That is useful information, but it provides only a snapshot at one point in time.
It does not tell the investor what happens if:
Cap rate calculation excludes debt services such as interest rate changes and loan refi, large capital improvements (such as replacing HVAC systems), and taxes.
A serious commercial real estate pro forma should therefore look beyond today’s cap rate.
Different investment metrics answer different questions.
Internal rate of return, or IRR, estimates the annualized return of an investment over time based on projected cash flows and the eventual sale of the property.
IRR can be useful when comparing investments with different holding periods or different cash-flow patterns.
However, IRR is highly dependent on assumptions about future rent, expenses, financing, and the property’s eventual sale price. In a separate article, we have explained what IRR is and how to use it, available on https://theivygroup.com/blogs-commercial-property/.
A small change in exit value can materially change the projected IRR.
Return on investment, or ROI, compares the profit generated by an investment with the amount of capital invested.
ROI is straightforward, but it does not always capture the timing of cash flows.
Cash-on-cash return measures the annual cash flow generated relative to the investor’s actual cash invested.
For leveraged investors, this can be especially important because the amount of equity invested may be much smaller than the total property value.
Each metric has value, but none should be analyzed in isolation.
Financing is one of the most sensitive parts of commercial real estate underwriting.
Interest rates directly affect:
A property that appears attractive under one financing structure may look different when interest rates increase.
This is why experienced investors frequently evaluate several debt scenarios.
For example:
These scenarios should be tested before the investor becomes committed to a transaction.
One of the biggest weaknesses in a commercial real estate pro forma is unrealistic input.
The model may assume a certain rental rate, but can the property actually achieve that rent?
It may assume 3.0% annual rent growth, but does that assumption make sense for that particular submarket and property type?
It may assume a low vacancy rate, but what is happening with competing buildings nearby?
It may assume a favorable exit cap rate, but what if the market changes?
These questions require more than financial modeling.
They require local market intelligence.
In Fremont, Silicon Valley, and the Greater Bay Area, industrial, office, R&D, warehouse, flex, and investment properties can perform very differently even within the same city.
A property near major transportation infrastructure may have a different tenant pool than one several miles away.
A newer industrial building with strong loading, power, yard access, and clear height may command different economics than an older building of similar size that lacks those features.
A well-informed pro forma must reflect the actual characteristics of the property and the local market.
One of the easiest ways to overestimate a property’s future profitability is to underestimate costs.
Investors should distinguish between hard costs and soft costs.
Hard costs may include:
Soft costs may include:
For a property requiring repositioning or redevelopment, these costs can materially affect the entire investment thesis.
A building purchased at an attractive price may become less attractive after the investor calculates the capital required to make it competitive.
Commercial real estate has tax characteristics that may influence investor returns, including depreciation.
Depreciation allows investors to allocate certain property costs over time (39 years for commercial property) for tax purposes, subject to applicable tax laws and individual circumstances. Earlier we explained and discussed accelerated depreciation, cost segregation, and OBBBA bonus tax benefits for commercial real estate investment.
Investors may also evaluate strategies involving a 1031 Exchange, which may allow qualifying investors to defer certain capital gains taxes when exchanging investment real estate for another like-kind qualifying property. (Again, we discussed in depth various aspects of 1031 exchange in previous blog posts, available on https://theivygroup.com/blogs-commercial-property/.
Tax considerations can materially affect investment decisions, but they should be modeled with input from qualified tax and accounting professionals.
Commercial real estate brokers can help investors understand how different real estate strategies may affect transaction timing, value, financing, and replacement-property requirements, but tax advice should be consulted with licensed tax professionals.
Investors naturally want to understand what a commercial property may be worth 5, 10, or 20 years from now.
A pro forma may include projected appreciation, but appreciation should not be treated as guaranteed.
Future value depends on several variables, including:
An experienced investor should evaluate several scenarios:
If the investment only works under the most optimistic assumptions, the investor should understand that risk before moving forward.
We will continue in the upcoming Part 2, which addresses other important considerations such as how to use the pro forma for hold, refinance, reposition, or exit decisions over multiple time horizons. Stay tuned. (stop)
The Ivy Group helps investors evaluate commercial real estate opportunities throughout Fremont, Silicon Valley, and the Greater Bay Area using local market knowledge, investment analysis, transaction experience, and strategic planning.
A thoughtful pro forma can help investors compare scenarios before capital is committed and continue guiding decisions throughout the life of the investment.
👉 To learn more, you can access, for a small fee, case studies: https://theivygroup.com/courses
👉 Subscribe to The Ivy Group newsletter: https://theivygroup.substack.com/
📩 Contact The Ivy Group: https://theivygroup.com/contact-us/
The Ivy Group specializes in commercial sales, leasing, and investment advisory across Fremont, Silicon Valley, and the Greater Bay Area. With over 100 years of combined experience and designations including SIOR and CCIM, The Ivy Group provides strategic guidance for complex transactions in commercial real estate.
When you need to sell, buy, or lease, The Ivy Group is ready to help you reach your goals. Contact us with your next real estate needs.
All information shared here in this article, and in all blogs, case studies, and courses offered by The Ivy Group are for general education only, not as tax, legal, or investment advice. Please seek professional advice from tax, accounting, legal, and other professionals.
Copyright © 2026 by Tim Vi Tran, SIOR, CCIM. All rights reserved.
Previous
Next
