Real Estate Financial Modeling - The Complete Guide

Explore the office property type within real estate, contrast suburban and CBD locations, anchor-tenant versus single-tenant structures, and compare office, industrial, retail, multifamily, and hospitality modeling.

Explore office properties' unique characteristics - floor plates, CBD vs suburban layouts, tenant counts, build-outs, tenant improvement dollars, open office plans, and long five-to-ten year leases.

Underwrite industrial properties similarly to office deals, focusing on large, single-floor facilities in outskirts industrial parks near highways, airports, or rail for warehousing and manufacturing.

Explore industrial properties' unique traits: massive single-tenant facilities with long leases, minimal build-out, and high ceilings, while buyers face lower cap rates but higher relative costs than offices.

Explore retail basics across stores, restaurants, and malls, and examine how online shopping and economic cycles influence the risky, physical retail landscape.

Explore how retail centers vary in size and layout, anchor tenants stabilize cash flow and attract visitors, while tenancy risks and higher maintenance costs shape investments.

Multifamily includes apartments, condos, student housing, and townhomes—more than one unit—excluding single-family homes, and requires labor-intensive management and potentially countercyclical demand.

Multifamily properties command the highest purchase prices due to strong demand and lower risk, yet require ongoing capital expenditures and intensive management, with reliable occupancy and easier loan access.

Hospitality properties, including hotels, motels, and resorts near airports or business districts, face high vacancy and maintenance. Their cyclical guest turnover makes revenue forecasting difficult and increases investment risk.

Explain risk profiles for core and core plus: core offers low risk with long leases to strong tenants in primary markets; core plus adds moderate risk via near-term expirations.

Explore real estate risk profiles from core to opportunistic, detailing value property and core plus strategies, lease-up challenges, obsolescence, and underwriting variations.

Analyze the real estate market before underwriting, focusing on vacancy rates, absorption, and new construction, using Colliers reports for Northern Virginia in the DC market.

Define inventory as the total rentable square feet of a market's asset type, estimate market size by summing building square feet, and prefer markets with high inventory for office properties.

Learn how vacancy equals availability divided by inventory, calculate the vacancy rate, and interpret high rates; context matters by market and asset type, as shown in the Northern Virginia market.

Analyze absorption, defined as total square feet leased, to gauge market health: positive absorption lowers vacancy, negative absorption raises it, guiding investments in high-absorption markets.

Learn how cap rate, defined as operating income divided by property value, measures return on cash purchases. Higher cap rates mean lower prices, while lower cap rates mean higher prices.

Market rent is the average rent for a given asset class in the market; compare it to your property's rent to gauge alignment. Rising rents indicate a strong leasing market.

Explore how gross domestic product reveals the economy's size and health, how GDP trends affect real estate, and how government factors and regional comparisons shape markets.

Examine how unemployment and GDP are closely linked and how unemployment shapes real estate demand for space, hotels, restaurants, and apartments, including Virginia's relatively low rate due to government spending.

Assess industry diversification as a key to recession resilience, highlighting manufacturing, financial services, insurance, and oil, and compare Houston's dependency with Denver's diverse economy to understand vacancy risks.

Compute net operating income by deriving gross operating income from total potential revenue, subtracting vacancies and operating expenses, and excluding capital expenditures and debt service.

Compute the cap rate by dividing net operating income by property value, and use it to estimate value and compare investments, noting that higher noi and lower expenses raise value.

Explore cash on cash return and equity multiple, calculating free cash flow after capex and debt service, and learn why time value of money matters for investment performance.

Learn about internal rate of return (IRR), including uncovered and levered IRR, and construct cash flows that reflect time value of money and all costs except depreciation.

Explore unleveraged and levered internal rate of return on a real estate deal, showing how debt service and a 50% loan-to-value raise returns when debt costs are below property yields.

Model a stabilized industrial property to forecast cash flows and valuation, using a DeKalb, Illinois building with dock doors, office space, and a $3.25 psf net lease.

Explore the real estate financial model setup, including sale-leaseback assumptions, acquisitions and sources and uses, rental and debt schedules, and a cash-flow and summary page for returns.

Review main industrial property assumptions for a sale-leaseback: 15-year lease, initial rent $3.25/sf with 2.5% escalations, 2.5% vacancy, tenant reimbursements for cam and taxes, plus capital reserves and capex timing.

Build a monthly rental schedule from assumptions, using rent per square foot with 2.5% compounding escalations, calculate end-of-month dates, and derive monthly and annual rent for cash flow consolidation.

Forecast rental income using named monthly rent. Use sumifs to project cash flow and extend revenue to year 7, then zero in year 8 after the sale in year 6.

Calculate and inflate expenses, including real estate taxes per square foot and cam, with 2 percent inflation compounded annually; apply 90 percent reimbursement income and cap flows at year 7.

Add a 2.5% vacancy factor to total property income, subtract operating expenses to compute NOI, reflecting rental revenue, reimbursement income, or other income through year 7 before dropping to zero.

Calculate a property's purchase price using a cap rate approach, selecting a going cap rate from experience and market factors, and build a dynamic model driven by assumptions.

Calculate disposition price using an index and match approach to locate year-specific values, adjust for the forward year, and estimate sale price with a cap rate and 3% selling costs.

Set a capital reserves line at 10 cents per square foot to cover unexpected capital expenditures, a rainy day fund, inflating with inflation and compounding toward the sale year.

Model capital expenditures by scheduling inflated ac unit replacements in year two and year three. Use current-year checks to lock these costs into the plan.

Set up the debt schedule with financing assumptions: 60% ltv, loan amount from purchase price, 4.5% interest, 10-year term with 30-year amortization and two years interest-only, then compute annual payment.

Learn to build a debt schedule with two years of interest-only payments, then move to amortizing principal, using Excel formulas to set beginning amounts and calculate principal.

Calculate interest equals beginning amount times the rate, compute principal, and populate an amortization table, including interest-only years and fixed negatives with an if statement.

Link the debt service line in the cash flow tab to the named debt schedule, using a lookup to pull interest and principal by year with exact match.

Explore how to fill out sources and uses for a real estate deal, computing closing costs, transfer taxes, and loan fees, then balance debt and equity to match total uses.

Finalize the cash flow by accounting for acquisition costs, debt proceeds, sale year dynamics, and loan payoff to calculate levered and unlevered returns.

Calculate levered IRR and the equity multiple for real estate using yearly cash flows, showing 12.3% levered IRR, 8% unleveraged IRR, and 1.81x equity multiple.

Learn to build a sensitivity data table in a real estate model to show how changing going-in and exit cap rates affects levered IRR, using what-if analysis.

Create a one-page summary linking property data, returns, and sensitivity figures to present a clear investment recommendation to the boss.

Evaluate a value add multifamily opportunity by renovating lakeside villas to capture rent premiums and boost value, and outline underwriting steps and data access.

Explore the model overview for real estate financial modeling, detailing assumptions, property and unit-level cash flows, rent roll, waterfall, IRR, and debt schedule.

Learn to populate the assumptions tab for a value-add multifamily deal, setting acquisition date, cap rate, LTV, debt, forward 12 months, and exit, with unit groupings and vacancy assumptions.

Learn how to model value-add renovations by upgrading about half the units to premium, accounting for two-month downtime, renovation costs per unit, and premium rents to boost cash flow.

Build a dynamic rent roll for 127 premium upgrade units by calculating completion months and status (pre renovation, renovation, post renovation) to drive unit-level cash flow and lease-up timing.

Explore how to set up the unit cash flow model, apply inflation-driven rent increases for standard and renovated units, and calculate construction costs to drive the property cash flow.

Calculate unit-level cash flow by projecting each unit's rent with annual inflation and compounding to build a detailed rent roll. Track standard and premium units, using countifs to enumerate upgrades.

Count renovated units from the rent roll by status post renovation, adjust the formula to exclude standard units, and compute total rental revenue from standard and renovated units.

Calculate total construction costs by counting units currently in renovation, multiply by per-unit renovation costs, and divide by the two-month duration to avoid double counting.

Project the property cash flow by forecasting rental revenue to month 30 (sale) with revenue after sale zero, then apply per-unit operating expenses—insurance, utilities, taxes, repairs, payroll, and management—with inflation.

Apply a vacancy factor to real estate cash flow to calculate net operating income, then incorporate capex and a per-unit replacement reserve to model capital planning.

Build a debt service and amortization schedule to compute unlevered and levered IRR, using a 65% LTV, 3% origination fees, 5% interest, and 120/300 month terms with 12 months interest-only.

Fill the debt schedule in the property cash flow using a lookup for monthly interest. Copy the formula to compute principal, applying it after month 12 and through month 30.

Model the acquisition and sale within the property cash flow and waterfall by calculating purchase price, closing costs, loan origination, selling costs, and final loan payoff in the sale month.

Explore the sources and uses in real estate private equity, detailing sponsor and limited partner equity splits, and how purchase price, closing costs, and debt origination shape the waterfall.

Explain the sponsor and limited partner relationship and the promote structure, with IRR hurdles of 10, 15, and 20 percent, shifting from 80/20 to 50/50 to align incentives.

Learn how equity waterfalls work in real estate models, detailing tiered splits for sponsor and LP, cash flow timing, negative equity funding, and calculating 10, 15, 20, and 20+ returns.

Explain how to model tier 1 in an equity waterfall, starting with zero beginning balance, 10% required return, and sponsor-funded negative cash flows through a max formula.

learn to compute equity waterfall and capital repaid in a multi-tier real estate model, including sponsor–LP splits and IRR versus XIRR for monthly cash flows.

Dive into the equity waterfall pt. iii, detailing the LP section and how to compute beginning balances, required returns, and monthly distributions to sponsor and LP with max/min formulas.

Demonstrates building tiered equity waterfalls for sponsor and LP, copying formulas across tiers, applying required returns (10%, 15%, 20%), calculating capital repaid and cash to distribute to reach target IRR.

Compute the final tier of the equity waterfall with a 50/50 split, distribute the remaining cash, and verify zero cash left by matching checkpoints to each tier.

Calculate total project cash flow and levered IRR, then assess sponsor and LP returns, return multiples, and distributions to illustrate risk and motivation in real estate financing.

Use sensitivity analyses on LTV, exit cap rate, and rent growth to assess the overall project IRR. Present a data-driven acquisition recommendation with conservative assumptions.

Congratulations on completing the real estate financial modeling course; apply principles to any property type. Explore the financial analysis, financial modeling, and corporate and project evaluation courses for credit analysis.