HOME
Portfolio Case Study
Mixed Use Development Model
Integrated development, financing, and equity return model for institutional real estate analysis
This model was built to evaluate a mixed use development through the full capital cycle, from development budget and draw timing through debt structure, lease up, operating cash flow, and exit returns. Each module is linked so that changes to cost, timing, or financing assumptions flow directly through to investor outcomes. The result is a single workbook that supports both internal decision making and investor reporting.
A$18.1M
Total Uses
Total project capital deployed
A$10.0M
Senior Debt
Construction and term financing
10.3%
Equity IRR
Levered return to equity investors
2.03x
Equity Multiple
Net equity proceeds over invested capital
At a Glance
Project Overview
Four dimensions define the scope of this model: asset type, physical program, capital structure, and analytical outputs. Each is summarized below.
Asset Type
Mixed use urban development combining residential and street-level retail in a single strata building.
Physical Program
36 residential units and 850 sqm of retail gross leasable area across 4,200 sqm total gross floor area.
Capital Structure
A$8.1M investor equity alongside A$10.0M senior debt. Construction starts 2027, operations commence 2029, exit in 2035.
Model Outputs
Development costs, debt schedule, operating pro forma, sources and uses, equity returns, and 14-point audit check suite.
Background
The Situation
The Modeling Challenge
Mixed use development projects require a model that can hold phased construction draws, variable financing mechanics, staggered lease up, and a multi-year operating history before an exit event. Most spreadsheet approaches treat these as separate workbooks, which creates version control problems and makes sensitivity testing unreliable.
This model was built to connect all four stages in a single linked workbook, so that any change to a cost line, a draw assumption, or a lease up rate propagates through to the debt schedule and the equity return waterfall without manual reconciliation.
Decision Quality and Investor Readability
The goal was not simply to produce an IRR. The goal was to build a model that could support investor decision making at each stage of the capital cycle. That means a clearly structured assumptions page, a development budget that ties to a quarterly draw schedule, a debt module that calculates interest during construction, and an operating pro forma that feeds cleanly into an exit valuation.
Readability was treated as a modeling standard, not an afterthought. The workbook is structured so that an investor or lender can follow the logic from inputs to outputs without needing to reverse engineer formulas. All audit checks are visible and labeled. Every summary panel references the underlying schedule that produced it.
The project spans a construction period from 2027 to 2029, followed by a six-year hold period to exit in 2035. That timeline required the model to handle both development-phase accounting and stabilized-asset accounting within the same structure.
Architecture
Model Architecture
The workbook is organized as a linear analytical chain. Each module receives outputs from the prior stage and passes its results to the next. The structure below reflects the actual tab sequence in the workbook.
Assumptions
Costs, timeline, financing terms, lease rates, cap rate
Development Budget
Land, hard costs, soft costs, phased draw schedule
Debt and Draws
Senior facility, drawdowns, IDC, repayment
Lease Up and Operations
Revenue ramp, NOI, operating cash flow
Exit Value
Cap rate applied to stabilized NOI
Equity Returns
IRR, equity multiple, net proceeds
Each layer is directly linked to the one before it. Timing, cost, leverage, and operating assumptions all flow through to investor outcomes. There are no manual inputs between modules. A change to the construction draw schedule, for example, automatically updates interest during construction, which flows to total project cost, which updates the sources and uses, which recalculates equity at entry and net proceeds at exit.
Contents
What the Workbook Includes
The model is organized into six functional modules. Each is self-contained but linked to the broader analytical chain.
Assumptions and Timeline
Central inputs page covering project dates, unit mix, retail GLA, cost per sqm, financing terms, lease rates, cap rate, and hold period. All downstream schedules reference this page.
Development Budget and Phased Draw Schedule
Itemized cost budget covering land at A$2.8M, hard costs at A$11.5M, and soft costs at A$1.4M. Draws are phased quarterly across the construction period.
Debt Schedule and Interest During Construction
Senior facility of A$10.0M modeled with quarterly drawdowns, accruing interest during construction, and scheduled repayment on stabilization. DSCR calculated at Year 3 at 1.50x.
Revenue and Lease Up
Residential and retail revenue modeled separately with lease up ramp assumptions. Operating expenses, vacancy, and net operating income tracked annually from 2029 through exit.
Sources and Uses
Summary reconciliation of total project uses at A$18.1M against equity and debt sources. Confirms that the capital structure is fully funded with no gaps or circular references.
Equity Returns and Audit Checks
Equity IRR of 10.3%, multiple of 2.03x, and net proceeds of A$14.05M. Accompanied by 14 labeled audit checks that all pass, covering balance, timing, and return consistency.
Selected Outputs
Key Model Panels
The following panels represent the primary output sections of the workbook. Each is designed to be presentation-ready and directly traceable to its source assumptions.
1
Development Budget and Quarterly Draws
Total development cost of A$17.3M is itemized by cost category and phased quarterly across the 2027 to 2029 construction window. Land at A$2.8M, hard costs at A$11.5M, and soft costs at A$1.4M are each shown as separate line items with draw timing. The quarterly draw schedule feeds directly into the debt facility utilization calculation.
2
Debt Schedule and Capital Structure
The A$10.0M senior facility is drawn against the quarterly construction schedule. Interest during construction accrues on the outstanding balance and is capitalized into total project cost. The schedule shows opening balance, drawdowns, interest, and repayment through to full discharge. Year 3 DSCR of 1.50x is calculated from stabilized NOI divided by annual debt service.
3
Lease Up and Operating Pro Forma
Residential and retail revenues are modeled from first occupancy in 2029 with lease up ramp rates applied to both income streams. The pro forma shows gross revenue, vacancy allowance, operating expenses, and net operating income annually through the 2035 exit year. Exit NOI of A$1.23M reflects a stabilized, fully leased asset.
4
Sources and Uses Summary
Total uses of A$18.1M are reconciled against A$8.1M investor equity and A$10.0M senior debt. The summary confirms that sources equal uses with no residual gap. Fees, interest during construction, and contingency are each shown as discrete line items within the uses column to avoid aggregation that obscures cost structure.
5
Equity Return Outputs
Net equity proceeds of A$14.05M at the 2035 exit are derived from gross property value of A$23.45M, after debt repayment and transaction costs. The equity IRR of 10.3% is calculated on a quarterly cash flow basis. The 2.03x equity multiple represents total net distributions divided by contributed equity of A$8.1M.
6
Audit Checks
14 labeled audit checks cover balance sheet integrity, sources and uses reconciliation, debt drawdown consistency, return calculation cross-checks, and NOI to value linkage. All 14 checks pass. The audit panel is visible on the summary tab so that reviewers can confirm model integrity without opening individual schedules.
Results
Key Takeaways
Four outputs summarize the financial result produced by this model. Each figure is drawn directly from the workbook and is traceable to its source schedule.
Capital Structure
A$18.1M total uses supported by A$8.1M equity and A$10.0M senior debt. The structure is fully reconciled with no funding gap and no circular references in the sources and uses summary.
Exit Valuation
Exit NOI of A$1.23M, reflecting a stabilized and fully leased asset in 2035, supports a gross property value of A$23.45M based on the cap rate assumption held in the central inputs page.
Equity Proceeds
Net equity proceeds reach A$14.05M at exit after full debt repayment and transaction costs, representing a net gain of A$5.95M on invested equity of A$8.1M over the hold period.
Investor Returns
10.3% equity IRR and 2.03x equity multiple, calculated on a quarterly cash flow basis with 14 of 14 audit checks passing. Year 3 DSCR of 1.50x confirms adequate debt service coverage at stabilization.
10.3%
Equity IRR
Levered, quarterly cash flow basis
55%
Debt Coverage
A$10.0M debt on A$18.1M total uses
14/14
Audit Checks
All checks pass across all modules
Standards
Build Standards
The technical standards applied to this model reflect a professional modeling practice oriented toward institutional review, investor reporting, and due diligence readiness. Each standard below was applied throughout the workbook, not selectively.
Structural Standards
Clear Input Structure
All assumptions are consolidated on a single inputs page. No hardcoded values are embedded in formula cells. Every input is labeled and carries a unit descriptor.
Linked Schedules
Each module references upstream outputs directly. There are no copy-paste links, no manual bridges, and no values that require recalculation by the user.
Transparent Assumptions
Cap rate, lease rates, construction timeline, financing terms, and exit assumptions are each visible, labeled, and editable in a single location. Sensitivity analysis can be run by changing one cell.
Quality and Presentation Standards
Audit Logic
14 labeled checks are embedded across the workbook and displayed on the summary tab. Checks cover balance sheet integrity, drawdown consistency, sources and uses reconciliation, and return calculation cross-verification.
Presentation Ready Outputs
Summary panels are formatted for direct use in investor materials. Font sizing, table structure, and color coding follow a consistent system throughout. No reformatting is required before sharing with an investor or lender.
Review Friendly Structure
Tab naming, row labeling, and formula structure are all organized to support third-party review. A new reviewer can trace any output back to its source assumption in under two minutes.
Model Specifications
Technical Reference
The table below summarizes the key parameters of the model as built. All figures are as modeled and reflect the base case assumptions held in the central inputs page.