Commercial Real Estate Financial Modeling Master Class

Explore commercial real estate investing fundamentals, including stable income, diversification, inflation protection, tax benefits from leverage, four strategies—core, core plus, value add, opportunistic—and property types and lease structures.

Learn pro forma modeling with acquisition, construction, permanent, refinance, and mezzanine debt, loan sizing by loan to cost and loan to value, and metrics like noi, cap rate, and irr.

Explore speculative development and build-to-suit, comparing risk, lease-up dynamics, and cash-flow potential. Outline the development process from land acquisition to lease-up and summarize hard and soft costs and construction financing.

Examine how joint ventures in commercial real estate allocate equity between LP and GP. Identify common fees and the equity waterfall driven by IRR and pref hurdles.

Use color coding to separate inputs and assumptions from outputs and formulas in financial models, with blue font for inputs and assumptions, black for outputs, and green for references.

Master essential Excel shortcuts for financial modeling, including paste across and down, copy and paste, paste special, and using arrow keys to navigate, select rows or columns, and manage sheets.

Explore common formatting shortcuts in Excel to apply bold, italic, currency, and percent formats, adjust borders and grid lines, autofit columns, and group or show/hide cells for cleaner worksheets.

Master formula auditing with a five plus two example, using F2 to edit, F4 to lock references, F9 to calculate, and tracing precedents with alt m d and alt mv.

Develop essential commercial real estate financial modeling practices by turning off grid lines, separating inputs from formulas to avoid hard coding, clarifying assumptions, and saving at A1 for easy orientation.

Input the property's basic information, including name, inland empire location, and industrial type; choose development or acquisition with spec or build-to-suit, validate data for 250,000 ft² and 5.7 acres.

Configure timing in a commercial real estate model by setting analysis periods, acquisition and development dates, and month-based milestones, then determine the first lease start from occupancy and rent roll.

Explore the non-multifamily rent roll from left to right, toggling tenants and classifying contracts vs speculative leases, to compute availability and occupancy timing. Model rent types, free rent, and commissions.

Model other revenue by calculating miscellaneous and parking income with unit types such as dollar per foot or per space, using square feet, overrides, and inflation.

Identify operating expenses that support property operations, including common area maintenance, taxes, insurance, and management fees, with some fees as a percentage of potential or effective gross revenue.

Capex covers improvements beyond standard operations, such as roof repairs or lobby renovations, and often includes a capital reserve to make underwriting more conservative.

Choose development as the investment type and enter costs as dollars, per foot, or per acre. Apply contingency, set timing, and distribute hard and soft costs to determine development costs.

Apply general inflation of 4% tapered over time, set vacancy and credit loss at 2.5% and 2% using percent of PGR, and fix stabilization in year five.

calculate purchase and sale prices using dollar per acre, dollar per foot, or dollar amount, including closing costs, then apply exit cap and forward noi for the sale.

Understand debt structures for construction, permanent, and refinance loans, with dynamic funding tied to sale and terms like sofr-based and fixed rates, loan-to-cost, loan-to-value, and exit cap.

Explore a four-tier joint venture equity waterfall with an IRR hurdle and monthly timing, detailing GP 5% and LP 95% contributions, promo mechanics, and checks.

Forecast monthly cash flow by applying inputs to rent, occupancy, reimbursements, and expenses, then compute NOI, Opex, and operating cash flow, including debt and equity financing dynamics.

Roll monthly cash flow into annual figures with a sumifs and index-matching formula you can drag across, locking references to align with year zero to four for levered cash flow.

Distribute profits through a tiered equity waterfall between the limited partner and the general partner, starting with an 8% pref. Compute return of equity and tiered pref using IRR checks.

Examine the summary page of a commercial real estate model, highlighting property info, key returns (IRR, equity multiple), debt and equity funding, and occupancy and cash flow projections.

Explore how unlevered and levered IRR, and equity and capital multiples, measure returns, and how peak equity and cash-flow allocation affect profits across debt scenarios.

Analyze a deal through location and market analysis, property type and condition, leases and tenant quality, cash flow projections, risk, sensitivity, due diligence, financing, regulatory, environmental, and structural assessments.

Celebrate completing the commercial real estate financial modeling master class and apply advanced techniques and insights to navigate the CRE market with expertise and confidence.

Explore Nouveautés' integrated valuation and deal management platform for commercial real estate, enabling dynamic underwriting of complex scenarios, layered debt structures, JV deals, AI-driven insights, and automated pipelines.