Comprehensive Guide to Commercial Property Revenue Modeling and Financial Analysis

Core Characteristics and Classification of Commercial Real Estate

• Definition of Commercial Property: Within the context of financial modeling, commercial property refers to real estate assets where the tenants are companies and businesses rather than individual residents.
• Major Asset Classes: Several property types share similar modeling conventions and fall under the commercial umbrella:
  • Office: Spaces utilized primarily for company operations and administration.
  • Retail: Facilities where companies sell goods and services to consumers.
  • Industrial: Properties used by companies for the storage of goods intended for future sale.
• Tenant Density: Commercial properties generally feature a lower volume of tenants compared to multifamily or hospitality assets. While hotels or multifamily buildings may house hundreds of individual entities, an average office building typically has between $1$ to $25$ tenants, unless the structure is exceptionally large.
• Lease Terminology and Duration: The length of cash flow associated with leases varies significantly by asset type:
  • Hotel: Leases are effectively overnight.
  • Multifamily: Average lease length is typically $1\,\text{year}$.
  • Commercial: The standard assumption for lease terms is $5\,\text{years}$, though specific leases may be shorter or longer.

Commercial Lease Structures

• Full Service (FSG): A structure where the tenant pays a base rent, and the landlord is responsible for all operating expenses. Under this structure, expense reimbursements to the landlord are typically zero or negligible.
• Modified Gross (MG): A hybrid lease structure that serves as a blend between Full Service and Triple Net. The landlord and tenant share responsibility for expenses based on negotiated terms, resulting in partial expense reimbursements.
• Triple Net (NNN): A lease structure where the tenant is responsible for paying all operating expenses (taxes, insurance, and maintenance) in addition to base rent. In properties with NNN leases, the landlord expects a significant volume of expense reimbursements.

The Revenue Build for Commercial Property

• Potential Base Rent (PBR): This is the top-line revenue figure calculated on the assumption that the building is $100\%$ occupied.
  • Formula: $\text{Potential Base Rent} = \text{Rent} \times \text{Square Footage}$
  • Rent Quotation: Rent for commercial property is primarily quoted in dollars per square foot per year ($\$/\text{sq ft/year}$). In certain geographic regions, it may be quoted monthly.
  • Currency Conversion Example: If rent is quoted at $\$36$ per square foot per year, the monthly equivalent is calculated as $\frac{36}{12} = \$3$ per square foot per month.
• Revenue Deductions: To move from Potential Base Rent to Total Rental Income, two primary deductions are applied:
  • Absorption and Turnover Vacancy: A deduction accounting for space that is vacant because a tenant recently vacated or because the space is currently being marketed to new tenants.
  • Rent Abatements: Often referred to as "free rent," these are incentives offered to tenants to sign a lease. For example, a landlord might offer the first $6\,\text{months}$ of a $5\text{-year}$ lease for free. This is analogous to concessions in multifamily modeling.
• Total Rental Income Calculation:
  • $\text{Total Rental Income} = \text{Potential Base Rent} - \text{Absorption and Turnover Vacancy} - \text{Rent Abatements}$

Additional Revenue Streams and Expense Reimbursements

• Expense Reimbursements: Landlords initially pay the operating expenses for the property. Based on the lease structure (NNN, FSG, or MG), the tenant reimburses the landlord for their share of these costs. This is categorized as a revenue stream.
• Other Revenue Sources:
  • Parking: In high-rise buildings located in downtown urban centers, structured parking garages can generate substantial revenue.
  • Storage Rent: Fees collected for the use of storage spaces within the building.
  • After-Hours Use: If tenants require access to the building or specific services (like HVAC or security) outside of standard hours (e.g., $9\,\text{AM}$ to $5\,\text{PM}$, Monday through Friday), the landlord may charge additional fees for these services.
  • Tenant-Specific Operations: High-density tenants, such as call centers that run $24\text{-hour}$ shifts, significantly increase operating expenses. Landlords may collect extra revenue to offset the intensified use of the building's infrastructure.

Final Vacancy and Credit Loss Deductions

• Effective Gross Revenue (EGR): The final revenue figure after all adjustments.
  • $\text{EGR} = \text{Total Rental Income} + \text{Expense Reimbursements} + \text{Other Revenue} - (\text{General Vacancy} + \text{Credit Loss})$
• Credit Loss: Represents "bad debt" or the assumption that a certain percentage of tenants (e.g., $2\%$)) will fail to pay their rent. It is a conservative accounting measure.
• General Vacancy: This is used in two ways:
  • Unleasable Space: Accounting for square footage that cannot be leased (e.g., a $500\text{-sq ft}$ unit in a $10,000\text{-sq ft}$ building that is non-functional).
  • Underwriting Buffer: Institutional investors rarely value a building at $100\%$ occupancy. Even if a building is fully leased, they will include a conservative vacancy assumption (typically between $2\%$ and $5\%$)) as a financial cushion.
• Comparison of Vacancy Types: Absorption and Turnover Vacancy appears above Total Rental Income and represents active efforts to lease vacant space. General Vacancy appears below Total Rental Income and represents permanently vacant space or conservative underwriting assumptions.

Retail-Specific Nuance: Percentage Rent

• Definition: Percentage rent is additional rent paid by a retail tenant once their gross sales exceed a predetermined threshold. It aligns the incentives of the landlord and the tenant.
• Incentive Alignment: Landlords are incentivized to maintain common areas (malls, parking lots, landscaping) to drive foot traffic. Increased traffic helps the tenant reach sales thresholds, which in turn results in higher rent for the landlord.
• Method 1: Artificial Breakpoint: The landlord and tenant agree upon both a specific percentage and a specific dollar threshold (the breakpoint).
  • Example: Percentage Rent = $5\%$, Artificial Breakpoint = $\$100$ in sales, Actual Sales = $\$150$.
  • Calculation: $\$150 - \$100 = \$50$ in excess sales.
  • Extra Rent: $0.05 \times 50 = \$2.50$
• Method 2: Natural Breakpoint: The parties agree only on a percentage. The breakpoint is calculated based on the base rent.
  • Formula: $\text{Natural Breakpoint} = \frac{\text{Base Rent}}{\text{Percentage Rent}}$
  • Example: Base Rent = $\$10$, Percentage Rent = $5\%$
  • Breakpoint Calculation: $\frac{10}{0.05} = \$200$
  • Excess Rent Calculation: If actual sales are $\$300$, the excess is $\$100$. Extra rent = $0.05 \times 100 = \$5$.

Financial Modeling Workflow and Argus Integration

• Argus Software: Because commercial leases have complex assumptions (step-ups, renewals, reimbursements), they are typically modeled in Argus rather than calculated manually in Excel from the start.
• Excel's Role: Modeling in Excel for commercial assets involves manipulating and reformatting Argus outputs rather than building the primary revenue engine from scratch.
• The Three Base Tabs:
  • Transaction Summary: Overarching deal details.
  • Inputs and Drivers: Contains property specifics (e.g., Office in Boston, MA, built in $2015$, totaling $81,685\,\text{sq ft}$, acquired in December $2020$).
  • Model: The primary pro forma showing cash flows over time.
• The Combo Tab: An integral dynamic sheet that aggregates multiple Argus outputs. It serves two purposes:
  • Aggregation: Summarizing data from multiple buildings within a single investment.
  • Scenario Comparison: Allowing the model to toggle between different versions (e.g., Scenario 1: Upside vs. Scenario 2: Downside) using a switch on the Inputs tab.
• Workflow Order: Argus Outputs $\rightarrow$ Numbered Data Tabs (1, 2, etc.) $\rightarrow$ Combo Tab $\rightarrow$ Model Tab.
• Tagging Exercise: To import data properly, analysts use SUMIF formulas to map raw Argus line items to the model's standardized format. It is crucial to ensure that row positioning is identical across the Combo and numbered data tabs to maintain the integrity of dynamic references.

Key Mathematical Metrics and Summary Statistics

• Physical Occupancy: The ratio of occupied space to total space.
  • $\text{Physical Occupancy} = \frac{\text{Occupied Square Footage}}{\text{Total Square Footage}}$
• Economic Occupancy: The ratio of actual revenue collected to the potential revenue if the building were perfectly leased.
  • $\text{Economic Occupancy} = \frac{\text{Actual Revenue Collected}}{\text{Potential Base Rent}}$
  • Economic occupancy is typically lower than physical occupancy due to deductions like rent abatements, general vacancy, and credit loss.
• In-Place Rent per Square Foot: The average annual rent paid by current tenants.
  • $\text{In-Place Rent} = \frac{\text{Potential Base Rent} - \text{Absorption and Turnover Vacancy}}{\text{Occupied Square Footage}} \times 12$

Transition to Expense Modeling: Multifamily Context

• Multifamily Dynamics: Characterized by short-term leases ($1$ to $2\,\text{years}$) and high turnover rates (approximately $50\%$). These properties are considered safe because owners can adjust rents quickly to market conditions.
• Business Plans: High turnover creates frequent opportunities for unit renovations, allowing landlords to upgrade interiors and immediately reset rents higher.
• Expense Build Structure: A standard multifamily model includes roughly nine expense categories (e.g., repairs and maintenance, utilities). While the summary model is streamlined, the actual Profit and Loss (P&L) statement can contain dozens of granular line items under each bucket over a multi-year (e.g., $12\text{-year}$) financial history.