SmartHelping / Real Estate / Excel
Multifamily Acquisition Financial Model
Underwrite a multifamily acquisition with historical operating data, a 20-unit-type rent roll, monthly value-add assumptions, flexible debt and three joint venture waterfall options. Follow the deal from closing through refinance, exit and investor returns.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the model in action
Walk through the underwriting structure and outputs.
See how historical property performance, rent roll assumptions, financing, reserves and partnership terms connect to the pro forma and investor returns.
What the model includes
A complete acquisition, operating and investor-return framework.
Start with the property's historical performance and existing rent roll, build a detailed forward operating plan, then evaluate financing, reserves, exit value and partnership economics.
Review T12, T6, T3 or T1 performance
Drop historical operating results into the model and select the look-back period that best supports the underwriting case and forward assumptions.
Model as many as 20 unit types
Compare existing and potential rent by unit type, quantify loss-to-lease and build the revenue opportunity from the actual unit mix.
Build the complete closing requirement
Summarize acquisition funding and costs at both a high level and a granular level, including capital needs that occur in Period 0.
Adjust the operating plan month by month
Model loss-to-lease, economic vacancy, bad debt, concessions, renovation vacancy, value-add premiums and the timing of other income and expenses.
Use the assumptions that fit the deal
Add as many as 10 ancillary income items and toggle operating expenses between historical T12 values, manual assumptions or T12-plus adjustments.
Combine acquisition, capex and seller financing
Model separate acquisition, capital expenditure and seller-note debt, then choose whether the seller note is refinanced or remains outstanding through exit.
Plan for operating burn and cash shortfalls
Forecast reserve needs during softer operating periods so the capital plan reflects potential lease-up pressure, vacancy and timing risk.
Toggle among three partnership structures
Compare a simple preferred return, IRR hurdles with optional GP catch-up, or hard preferred equity above a subordinated LP/GP hurdle waterfall.
Connect monthly operations to annual results
Review monthly and annual pro formas, T12 and stabilized views, DSCR, cash-on-cash returns, project returns and LP/GP investment outcomes.
Bring decision-ready context into the file
Model acquisition, asset-management, debt-placement, guarantor, disposition, setup and construction fees, supported by a comparable tab, KPIs and 21 visualizations.
Joint venture flexibility
Choose the waterfall that matches the capital structure.
Each option includes inputs for LP and GP contributions, distribution splits and applicable return thresholds. Change the selected structure and review the resulting investment, distributions, IRR and equity multiple.
Simple preferred return
Define how cash is shared during the preferred-return phase, during return of capital and after contributed equity has been repaid.
IRR hurdles with optional GP catch-up
Split cash based on the LP reaching defined IRR hurdles. The optional catch-up can direct cash to the GP until its stated catch-up return is achieved.
Hard preferred equity plus IRR hurdles
Place a preferred-equity leg first in priority, with an optional equity kicker, then distribute remaining cash through a three-tier hurdle structure between the subordinated LP and GP.
Project-level alternative
If the acquisition is not a joint venture, use the project-level cash flows and returns without relying on the partnership waterfall outputs.
In-depth overview
Take a deeper look at the acquisition logic.
This extended walkthrough covers the historical analysis, operating assumptions, financing, reserves, outputs and investor return structures in more detail.
How to use it
Move from historical property data to a defensible acquisition case.
-
Load the property history and rent roll
Enter historical operating results and the unit mix, then choose the relevant T12, T6, T3 or T1 reference period.
-
Build the forward operating plan
Set rents, loss-to-lease, vacancy, concessions, bad debt, value-add premiums, other income, expenses and the timing of operational changes.
-
Define funding and partnership terms
Complete sources and uses, enter acquisition and supplemental debt, set refinance assumptions and choose the appropriate JV waterfall.
-
Review feasibility and stress the deal
Evaluate the pro formas, reserves, DSCR, cash-on-cash return, LP/GP outcomes, KPIs and exit results as the major assumptions change.
Who gets value from it
Built for the people underwriting and presenting a multifamily deal.
Multifamily sponsors
Translate a rent roll, historical operations and a value-add plan into a connected acquisition and investor-return case.
Acquisition teams
Compare actual property performance with forward assumptions, financing options, reserves and exit outcomes.
Investors and capital partners
Review project-level economics and LP/GP outcomes under several preferred-return and hurdle structures.
Analysts, advisors and consultants
Use a visible, fully editable framework to test assumptions and explain how operating changes affect cash flow and returns.
Also available in these bundles
Need a broader modeling library?
The Multifamily Acquisition Financial Model is also included in the Real Estate and Super Smart bundles.
Real Estate Bundle
Explore acquisition, development, operating and investor-return models across multiple real estate strategies.
View Real Estate BundleSuper Smart Bundle
Get the complete SmartHelping template collection for real estate, operating forecasts, valuation, finance and more.
View Super Smart BundleRelated real estate models
Explore other acquisition, development and operating strategies.
Hotel Deal Analysis - Advanced
Underwrite hotel operations, financing, value creation and investment returns.
Explore the hotel modelFix and Flip Scaling Model
Plan repeated property acquisitions, renovations, sales and business growth.
Explore the fix-and-flip modelSenior Living Underwriting Model
Evaluate senior-living operating assumptions, occupancy, costs and returns.
Explore the senior-living modelSale-Leaseback Analysis
Compare a sale-leaseback structure with alternative ownership and financing scenarios.
Explore the sale-leaseback modelRetail Construction
Forecast the construction, financing and operating economics of a retail property.
Explore the retail construction modelLot Development
Model land development, lot release timing, costs, sales and project returns.
Explore the lot-development modelStrip Mall Acquisition Model
Underwrite tenant revenue, operating costs, financing and returns for a strip center.
Explore the strip-mall modelApartment Building Model
Evaluate apartment-building acquisition assumptions, operations, debt and investment performance.
Explore the apartment modelSingle-Tenant Industrial
Model lease income, expenses, financing and exit returns for a single-tenant asset.
Explore the industrial modelMobile Home Parks
Forecast lot rent, occupancy, operating costs, financing and investor returns.
Explore the mobile-home-park modelMixed-Use Real Estate
Combine multiple property uses in one leveraged acquisition and operating forecast.
Explore the mixed-use modelSelf Storage - Up to 6 Deals
Compare and consolidate the economics of as many as six self-storage investments.
Explore the self-storage modelRental Property Scaling
Plan the acquisition, operation and financing of a growing rental-property portfolio.
Explore the rental-scaling modelCondo Development
Forecast development costs, unit sales, financing and returns for a condo project.
Explore the condo modelShort-Term Rentals
Model nightly rates, occupancy, operating costs and returns across an STR portfolio.
Explore the STR modelUnit-Based Real Estate Acquisition
Build a 10-year acquisition forecast using units, rent, occupancy and operating assumptions.
Explore the unit-based modelAssisted Living Facility / Nursing Home
Connect resident capacity, occupancy, staffing and operating costs to long-term returns.
Explore the assisted-living modelShort-Term Rental Arbitrage
Evaluate leased-unit economics, occupancy, rates, operating costs and expansion.
Explore the rental-arbitrage modelHotel Development / Acquisition
Forecast hotel development or purchase assumptions, operations, financing and exit value.
Explore the hotel modelReal Estate IRR Sensitivity Analysis
Test how occupancy and other assumptions affect property-level investment returns.
Explore the sensitivity modelMultifamily Acquisition - Annual Model
Use a streamlined annual-only structure for a multifamily acquisition.
Explore the annual multifamily modelReal Estate Flipping Calculator
Estimate purchase, renovation, holding and sale economics for an individual flip.
Explore the flipping calculatorProperty Management Business
Forecast managed units, fee revenue, staffing, overhead and business cash flow.
Explore the property-management modelReal Estate Brokerage
Model transaction volume, commissions, agent splits, operating costs and profitability.
Explore the brokerage modelReal Estate Development
Track development budgets, actual spending, timing and remaining project costs.
Explore the development modelReal Estate Checklist
Organize real estate diligence and project tasks in a structured template.
Explore the real estate checklistRental Property ROI Calculator
Estimate cash flow and investment return for a rental-property opportunity.
Explore the rental ROI calculatorRelated capital-structure tools
Compare financing and distribution structures.
Seller Financing
Model seller-financed purchase terms, payments, balances and investment outcomes.
Explore the seller-financing modelCash Flow Waterfall - 3 IRR Hurdles
Distribute cash across three LP return hurdles and changing LP/GP splits.
Explore the IRR waterfallCash Flow Waterfall with GP Catch-Up
Add a GP catch-up mechanism to a three-hurdle partnership distribution structure.
Explore the catch-up waterfallPreferred Equity
Model a senior preferred-equity leg, repayment priority and subordinate equity returns.
Explore the preferred-equity modelPreferred Return
Model preferred returns, return of capital and residual partnership distributions.
Explore the preferred-return modelZero-Down Seller Financing
Evaluate a real estate purchase funded through seller-financing structures with no initial equity.
Explore the zero-down modelCost Segregation Study
Estimate asset reclassification, accelerated depreciation and potential tax-timing effects.
Explore the cost-segregation modelQuestions before you buy
A few useful details.
What type of acquisition is this model designed for?
The model is designed for multifamily acquisitions with potentially light renovations where the acquisition and initial sources and uses occur in Period 0. Monthly operating assumptions can then reflect value-add improvements over time.
How much historical information can I analyze?
The historical tab accepts T12 information and can display T12, T6, T3 or T1 analysis so you can compare different recent operating periods.
How many unit types and ancillary-income items can I enter?
The rent roll supports as many as 20 unit types. The model also supports up to 10 ancillary income items, including four high-level items and six driven by unit assumptions.
Which joint venture structures are included?
You can toggle among a simple preferred return, IRR hurdles with an optional GP catch-up, or a hard preferred-equity leg over a subordinated three-tier LP/GP IRR waterfall.
Can the model refinance the acquisition debt?
Yes. The debt structure can include acquisition debt, capex debt and a seller note, with an option to refinance the applicable balances. The seller note can be rolled into the refinance or remain outstanding through exit.
Is the model editable and is it included in a bundle?
Yes. The Excel file is fully unlocked and editable. It is also included in the Real Estate Bundle and the Super Smart Bundle linked above.
Underwrite the property and the partnership together
Build a more defensible multifamily acquisition case.
Connect historical operations, the rent roll, value-add assumptions, financing, reserves, exit value and LP/GP returns in one 10-year Excel model. One-time purchase for $75.
