✦Template Printable Ideas Insights

What is Pro Forma in Commercial Real Estate

By

In the dynamic world of commercial real estate (CRE), the term "pro forma" is ubiquitous, yet its significance can be overlooked by those new to the industry. Pro forma, from the Latin 'for the form,' is a crucial concept that guides strategic decisions and evaluates potential investments. But what does pro forma really mean in commercial real estate?

At its core, pro forma is a set of hypothetical assumptions and calculations used to forecast the financial performance of a property. It's a tool that allows CRE professionals to predict expenses like maintenance, insurance, and utilities, as well as revenue streams such as rental income and leasing commissions. However, it's essential to understand that pro formas are not just about numbers; they're a reflection of an investment thesis, a story about how a property will perform given specific circumstances.

Understanding Pro Forma Assumptions

Before delving into the components of a pro forma, it's vital to grasp the nature of its assumptions. The validity of a pro forma largely rests on the accuracy and realism of these assumptions. Assumptions can vary widely, from vacancy rates and rental increases to capital expenditure plans and exit strategies.

What Is Pro Forma in Real Estate?
What Is Pro Forma in Real Estate?
Actual vs Pro Forma Financials in Commercial Real Estate
Actual vs Pro Forma Financials in Commercial Real Estate
Pro Forma Real Estate: Everything You Need to Know
Pro Forma Real Estate: Everything You Need to Know

While some assumptions, like historical expense data or market trends, can be verified, others, like future rental increases or the timing of capital expenditures, are educated guesses. Therefore, it's crucial to understand that pro formas are not predictions but estimates based on best-case scenarios, worst-case outcomes, and everything in between.

Types of Assumptions in Pro Formas

Pro formas often include a mix of market- and property-specific assumptions. Market assumptions might include rental growth rates, vacancy rates, and tenant demand trends, while property-specific assumptions could involve lease-up periods, capital expenditure plans, or operating expenses.

Commercial Leases
Commercial Leases
the five types of commercial real estate that you should consider investing in infographical
the five types of commercial real estate that you should consider investing in infographical
Real Estate Pro-Forma: Full Guide, Excel Template, and More
Real Estate Pro-Forma: Full Guide, Excel Template, and More

It's expected that these assumptions evolve over time as more information becomes available. Consequently, pro formas are living documents, revised regularly to reflect changes in the market or the property's status. Regularly updating pro forma assumptions ensures they remain relevant and accurately reflect the current investment thesis.

Common Pitfalls in Assumptions

However, assumptions can lead to pitfalls if not handled meticulously. Overly optimistic or unrealistic assumptions can skew results and lead investors to underestimate risks. Therefore, it's crucial to base assumptions on sound research, historical data, and market conditions.

Particularly, it's essential to avoid the widespread practice of "graping" – using the most favorable assumptions from various sources to build the best-case scenario. Instead, CRE professionals should strive for balance, representing market expectations and accounting for unlikely yet plausible outcomes.

an info poster with the words 18 items to consider before leaving office space on it
an info poster with the words 18 items to consider before leaving office space on it
Five Tips On Buying Commercial Real Estate | Bellingham Real Estate Agents | Josh & Jolene Baijot
Five Tips On Buying Commercial Real Estate | Bellingham Real Estate Agents | Josh & Jolene Baijot
Commercial Real Estate Offering Memorandum Template, CRE OM Canva Template, Property Brochure, Investor Package, Fill in Guide - Etsy
Commercial Real Estate Offering Memorandum Template, CRE OM Canva Template, Property Brochure, Investor Package, Fill in Guide - Etsy
Real Estate Development Proforma Template | Property Investment Analysis Spreadsheet | ROI Calculator | Excel & Google Sheets |
Real Estate Development Proforma Template | Property Investment Analysis Spreadsheet | ROI Calculator | Excel & Google Sheets |
4 Types of Real Estate to Invest In
4 Types of Real Estate to Invest In
Real Estate Proforma Template, Investment Property Analysis Spreadsheet, Cash Flow Projection, Google Sheets, Excel Tool
Real Estate Proforma Template, Investment Property Analysis Spreadsheet, Cash Flow Projection, Google Sheets, Excel Tool

Key Components of a Pro Forma

With a solid understanding of pro forma assumptions, let's delve into the key components that makeup a typical pro forma statement:

1. **Revenue Streams:** This section forecasts rental income, leasing commissions, and any other revenue sources like parking fees or retail concourse income. It often breaks down income by lease type (gross, net, and modified gross) and tenant categories (office, retail, industrial).

Revenue Projection Methods

Revenue projections can be calculated using various methods, such as rollover averages, historical trends, or market comparables. Often, a combination of approaches is used to arrive at a realistic forecast. For instance, market comparables might dictate initial rental rates, with historical trends guiding rental growth over the holding period.

Commercial Real Estate Definition and Types
Commercial Real Estate Definition and Types

2. **Operating Expenses:** This element accounts for all outlays attributable to the property's operation, excluding debt service and capital expenditures. Common expense categories include insurance, property taxes, utilities, maintenance, and management fees.

Expense Allocation and Budgeting

Like revenue streams, expenses are often allocated differently based on the lease structure. For example, in a gross lease, the landlord pays all operating expenses, while in a triple net (NNN) lease, the tenant covers them. Accurate budgeting involves tracking historical expenses, understanding industry benchmarks, and incorporating inflation adjustments.

3. **Capital Expenditures (CapEx):** These are significant expenses incurred to obtain, maintain, or improve a long-term asset. Unlike operating expenses, CapEx is not incurred annually but rather on an as-needed basis, such as for roof replacements, elevators repairs, or cosmetic upgrades.

CapEx Planning and Reserves

Proactive CapEx planning is crucial for preserving the asset's value and preventing emergencies that could disrupt cash flow. Given their unpredictable nature, many properties maintain a reserve fund to handle unforeseen or uncertain CapEx needs. This fund is often held in trust and invested to generate additional income.

4. **Debt Service:** This includes all interest and principal payments due on property loans. It's calculated based on the loan terms and the property's value, with pro formas typically showing both initial debt service and the anticipated changes over the holding period.

Debt Service Coverage Ratios

Debt service is often evaluated in relation to net operating income (NOI) using ratios like Debt Service Coverage Ratio (DSCR) and Interest Coverage Ratio (ICR). These ratios help investors understand the earning power of the property and assess the quality of the underlying cash flow.

Using Pro Formas for Investment Analysis

Once compiled, pro formas help investors assess potential investments through various financial metrics. These include cash on cash return, return on investment (ROI), net operating income (NOI), and capitalization rate (cap rate).

Moreover, pro formas enable 'scenario planning,' allowing investors to explore hypothetical outcomes. For instance, what if we revised the lease structure? Or delayed planned CapEx? Such analyses allow investors to stress-test their investment thesis and make more informed decisions.

Pro Forma Metrics for Investment Analysis

Some key metrics derived from pro formas include:

  • Cash on Cash Return: Measures annual cash income as a percentage of invested capital.
  • Return on Investment (ROI): Calculates the actual return based on the initial investment and final sale proceeds.
  • Net Operating Income (NOI): Calculates income less operating expenses, revealing the property's earnings power.
  • Capitalization Rate (Cap Rate): A fundamental metric measuring the annual return on a property relative to its purchase price.

While pro formas provide valuable insights, it's crucial to remember that they're only one tool among many in the investor's toolkit. Other essential inputs include market research, physical inspections, management team assessments, and legal due diligence. Furthermore, no two pro formas are alike, reflecting each property's unique characteristics and investment goals.

Common Misconceptions about Pro Formas

Despite their prevalence, pro formas can be misunderstood. Here are a few common misconceptions:

  • Pro formas are static projections: In reality, pro formas should evolve with changes in the market, the property, or the investment thesis.
  • Higher numbers are always better: Not all high returns are generated by sound investment practices, and not all low returns signal poor investments.
  • Pro formas tell the whole story: Pro formas should complement, not replace, thorough due diligence and a nuanced understanding of the investment context.

In conclusion, pro formas stand at the heart of commercial real estate investment, illuminating the path to informed decision-making. However, they're not destination, but a journey – a living document that evolves with the investment and allows investors to test, refine, and ultimately validate their strategy. As such, pro formas are a powerful tool, albeit one that must be used with care, discretion, and an eye on the market.