The Real Estate Development Modeling Master Class

Explore the real estate development process from land acquisition and entitlement through construction, leasing, stabilization, and exit, and learn to build pro forma cash flows with inputs and outputs.

Maximize dynamism with dynamic formulas that auto-update outputs across the pro forma, enable monthly and annual cashflow projections, and verify with error checks for IRR and NPV.

Build a land acquisition and ground-up development model alongside course videos, with step-by-step guidance and downloadable checkpoints to reinforce practical Excel skills.

Configure the real estate development model by removing grid lines, setting Franklin Gothic Book size 10, and enabling partial calculation with iterative calculation for a clean, ready summary tab.

Label the summary tab and build a reusable property details table with fields like units, buildings, net rentable area, average unit size, site details, and revenue-linked formulas, using precise formatting.

Build land acquisition and lease-up information tables, calculating land price per acre and per rentable square foot, include closing costs, and apply custom month formatting for lease timing.

Build and populate a construction financing information table with fields for construction loan amount, maximum loan-to-cost, one-month SOFR index, interest rate spread, loan fee, and construction loan term.

Explain how to build a permanent financing information table in Excel, including refinance month, loan amount, cap rate, LTV, DSCR, debt yield, interest rate index and spread, and amortization details.

Build a total cost and sale details framework for real estate development modeling, calculating total project costs, per unit and per square foot metrics, and stabilized yield on cost.

Build a sale information table with hold period, exit cap rate, and closing costs, then implement a circuit breaker using an on-off data validation switch to handle iterative model errors.

Model sources and uses of capital for a construction financing period, linking equity and debt, land costs, hard and soft costs, and total capital with Excel formulas.

Determine post-construction additional equity and calculate project-level returns using levered IRR, levered equity multiple, and levered average stabilized cash on cash.

Learn revenue modeling for real estate development by projecting stabilized rents, other income, vacancy losses, and growth, and constructing an Excel revenue tab with unit types and rent metrics.

Learn how to build stabilized rent tables with total and weighted average rows, using sum and sumproduct to compute weighted average square footage and rent per month.

Build a stabilized other income table for development, detailing line items such as application fees, late fees, pet rent, garage income, and storage income, with dollars per unit per month.

Develop a year-by-year vacancy loss model for a 10-year hold, detailing physical vacancy, credit loss, concessions, and other losses, to project NOI and support sale price estimates.

Build a month-by-month net rental revenue model by creating a 132-month timeline, mapping months to years with a round-up formula, and calculating stabilized rents, lease-up percentage, and net rental revenue.

Calculate month-one stabilized rents by multiplying units by weighted average rent, then apply monthly market rent growth using year-specific growth data to project rents across the full analysis period.

Explain and implement the percentage of lease up complete using month-based if statements, from 0% before start to 100% at stabilization, then apply to net rental revenue.

Build stabilized and actual other income projections in a real estate model by creating a stabilized other income timeline, applying growth, and phasing income by the lease-up completion percentage.

Build a stabilized operating expenses table for a multifamily project, listing line items with dollars per unit per year, total expenses, and fixed vs variable costs, including payroll and utilities.

Build a hold period stabilized operating expenses model by inputting per unit costs, formatting currency, and using sumproduct to derive fixed expense share with error protection.

Create two tables to track additional operating expense assumptions and property tax information, including property management fee, expense growth, capital reserves per unit, and reassessment options.

learn to project annual property tax growth rates by building a 10-year model in Excel, incorporating assessed value and fixed charge increases for construction, hold period, and sale periods.

Learn to model hold-period and construction-period property taxes in Excel, calculating year-by-year assessed value, fixed charges, and total taxes, with reassessment-on-sale rules.

Develop month-by-month stabilized and actual operating expense projections for the hold period, using stabilized expense assumptions, annual expense growth, and insurance premiums timing to produce monthly figures.

Translate stabilized operating expenses into actual projections by splitting each line item into fixed and variable costs and building month-by-month, lease-up driven weighted averages with dynamic Excel formulas.

Build a construction budget in the real estate development model, detailing hard and soft costs with a cash flow timeline, ramp up and ramp down, and a construction budget tab.

In this hard costs build-out, format currency, calculate per-unit costs as total material costs divided by units, and track month start and end to derive total months and subtotals.

Create a subtotal row, apply bold black text, and copy Excel formulas to sum totals, compute per unit costs, and derive month start and end with min, max, and if.

Create a month-by-month timeline and cash flow projections for construction budgets, including an acquisition period, formatting, and a bell-curve cost model driven by a standard deviation parameter.

Apply the s-curve framework to model construction cost cash flows in Excel, using if and or logic and norm.dist to allocate monthly costs and peak midpoints with tail adjustment.

Create Excel construction checks to ensure total costs match projected cash flows across hard and soft cost tables. Use formatting to flag errors in red and OK statuses in green.

Build the soft costs table and integrate capitalized real estate taxes, insurance, and marketing into the construction budget, linking to the expenses tab for monthly cash flow.

Develop capitalized insurance and marketing costs during construction with month-based if formulas linked to expenses, and apply an s-curve framework to soft costs before finalizing the total construction budget.

Learn to construct a contingency equal to 10 percent of hard plus soft costs, apply it to monthly cash flows, and finalize the total capital budget.

Create a monthly cashflow tab in Excel, then roll up the data into annual cashflow projections with a clear year-by-year view.

Format the revenue section to show gross potential rental revenue with physical vacancy, credit losses, concessions, and other losses, then compute net rental income month-by-month after lease-up.

Apply physical vacancy calculations during lease-up using if and hlookup to map year-by-year stabilized vacancy rates to gross potential rental revenue.

Model credit loss, concessions, and other loss in monthly cash flows by building a dynamic Excel formula that adjusts net rental income through lease up, stabilization, and market rent growth.

Build and automate other income in a real estate development model by linking to revenue, copying formulas across months, and calculating total other income and effective gross revenue.

Build operating expenses in a model, including payroll, property taxes, insurance, and management fees tied to effective gross revenue, and set capital expense reserves after lease-up with annual expense growth.

Analyze monthly property taxes and net operating income by accounting for lease-up timing, potential sale reassessment, and fixed charge assessments, then compute net operating income from gross revenue minus expenses.

Showcases calculating capital expenses from construction costs, using the construction budget tab, and modeling cash flow before and after debt service across a hold period to a sale.

Outline acquisition and sale information to calculate land purchase price, closing costs, sale proceeds, and costs of sale, yielding total unlevered cash flow and guiding levered cash flow planning.

Outline the loan information section to compute total levered cash flow using construction loan proceeds, permanent loan proceeds, loan fees, and loan payoff within the monthly cash flow tab.

Format and clean a real estate cashflow model in Excel, apply borders and remove zeros, and use SUMIF to total line items over the projected hold period.

Transform a monthly cash flow model into an annual 10-year projection using sumifs, year-based calculations, and dynamic sums of gross potential rental revenue and cash flow after debt service.

Build a financing tab to model construction loan and permanent financing, track interest costs, equity contributions, and funding percentages, and align checks with the summary tab.

Construct an operating metrics table with a header, a long timeline to month 132, and three line items for total land/construction/financing costs, operating shortfalls, and positive operating cash flow.

Model total land, construction, and financing costs by incorporating land price, closing and loan fees, and monthly construction costs to forecast operating shortfalls and positive cash flow.

Build and link the equity financing table to operating metrics, track starting, equity draws, and ending balances month by month, and model construction loan amount, fees, and operating shortfalls.

Determine starting equity and monthly equity draws from land, construction costs, and operating shortfalls, and verify funding with checks before construction loan proceeds.

Copy and relabel equity financing as construction financing, and model starting loan balances, construction loan draws, and capitalized and interest expenses.

Build an interest rate model for construction loans by projecting monthly SOFR index rates plus spread, creating an index rate forward curve, and importing Chatham Financial forward curves in Excel.

Builds the all-in interest rate for each month using iferror and hlookup against month ending dates, then computes monthly interest expense, capitalized interest, and loan payoff through the construction term.

Develop a permanent financing model for real estate development by converting construction financing into a schedule, including starting balance, payments (principal and interest), payoff, and ending balance, with Excel formulas.

Learn to model permanent financing by incorporating assumptions, distinguishing interest-only periods, and calculating monthly loan payments using PMT, considering construction loan term and loan balance.

Learn to model permanent financing by calculating loan payoff and ending loan balances with Excel formulas, validate results with error checks, and quantify equity and debt shares.

Finalize the monthly and annual cashflow tabs by integrating financing values and interest payments and principal payments, and consolidate checks in a dedicated checks tab.

Connect summary tab to revenue tab for units and net rentable square footage, then project forward 12 months noi to derive refinance loan amount with cap rate and ltv.

Compute the going in debt service ratio from 12 months net operating income over amortizing debt service, then derive going in debt yield as NOI over permanent financing loan amount.

Finalize the summary tab by linking total project costs, calculating the stabilized yield on cost from NOI, and outlining levered returns like IRR.

Compute levered IRR with Excel's XIRR on monthly cash flows, and determine levered equity multiple and cash-on-cash returns using SUMIF and AVERAGEIFS for the stabilization period.

Create a checks tab to verify the four checks in the model. Use conditional formatting and if statements to validate construction funding, cash flows, loan balances, and equity contributions.

Adjust land acquisition price, lease up period, and financing terms to see in real time how levered IRR, levered equity multiple, and cash-on-cash shift, guiding development decisions.

Improve your land acquisition and ground up development modeling through practice and iteration, and customize pro forma templates. Explore the advanced real estate development modeling masterclass for commercial lease insights.