# Mobile Home Park Acquisition Model

Underwrite a manufactured housing community acquisition by modeling lot-rent growth, pad infill to stabilised occupancy, utility cost recovery, and a Year-7 cap-rate exit. Size levered IRR, equity multiple, cash-on-cash, and yield on cost with a built-in Base / Upside / Downside scenario toggle.

- Canonical: https://finamodel.com/templates/mobile-home-park-model
- Excel download: https://finamodel.com/templates/mobile-home-park.xlsx
- Category: Real Estate
- Model type: Underwriting
- Difficulty: Intermediate
- Audiences: Developers & sponsors, Investors & analysts, MHC Investors, Value-Add Sponsors, Real Estate LPs, Acquisition Analysts, MHC investors, Real estate sponsors, Acquisition analysts, Fund managers
- Tags: mobile-home-park, manufactured-housing, noi, value-add, infill, manufactured housing, lot rent, agency debt, IRR

## Overview

A Mobile Home Park (Manufactured Housing Community) Acquisition Model underwrites the value-add purchase and 7-year hold of a 120-pad community bought at 83% occupancy (100 occupied pads) for ~$6.0M, derived from $360K in-place trailing NOI capitalized at a 6.0% going-in cap rate (~$50K/pad). The thesis is classic MHC value creation: lot rents sit below market at $425/month and are pushed 4% annually (Base case), while a disciplined infill program brings ~4 vacant pads online per year toward a 95% stabilized occupancy (114 pads). Because residents own their own homes and maintain them, the community carries a very high NOI margin (~60-65%); the operator only maintains roads, utilities, and common infrastructure. The deal is financed with agency-style debt (70% LTV on purchase price, $4.2M at 6.0%, 30-year amortization with a 2-year interest-only period) and ~$2.2M of equity, plus a small capital-improvement budget funded at close.

The Operating_CF sheet drives revenue from four streams: Lot Rent (potential rent on all 120 pads times economic occupancy, net of a 2% credit loss), Home Rental Income from 15 park-owned homes earning a $325/month premium, Utility Reimbursement (RUBS, recovering 70% of the community's water/sewer/trash cost), and Other Income (3% of lot rent for late, application, and pet fees). Operating expenses are built per-pad and escalated at 2.5%: property taxes, on-site payroll and management, repairs and maintenance, gross utilities, insurance, and general and administrative, plus an off-site asset management fee of 4% of effective gross income. NOI flows to unlevered free cash flow after a per-pad capital reserve and infill capex (cost to ready each newly occupied pad, tapering to zero at stabilization). The Debt_Schedule rolls the loan forward with interest-only years then PMT-based amortization, testing DSCR and debt yield each year. The Returns sheet exits in Year 7 at a 6.25% cap on forward NOI, nets selling costs and the outstanding loan balance, and computes unlevered IRR, levered IRR, equity multiple, average cash-on-cash, and yield-on-cost.

This model suits manufactured-housing investors, value-add real estate sponsors, and institutional LPs evaluating MHC roll-ups, a sector prized for sticky tenancy, low turnover capex, and constrained new supply. A built-in scenario selector (Base / Upside / Downside) flexes lot-rent growth, infill pace, and exit cap rate. Typical levered IRRs land in the 13-18% range with a 1.8-2.5x equity multiple over the hold; the headline value-creation signal is yield-on-cost (stabilized NOI / total basis ~7.5-8%) running well above the going-in cap. Key sensitivities are achievable lot-rent growth (the dominant driver), infill absorption pace, expense recovery (RUBS adoption), and exit cap rate, where a 25 bp move materially shifts net sale proceeds and equity returns.

## What's included

- Scenario toggle driving lot-rent growth, infill pace, and exit cap rate
- Acquisition basis and Sources & Uses (price from in-place NOI and going-in cap)
- Occupancy infill ramp and four income streams including RUBS recovery
- Per-pad operating expenses plus asset management fee and NOI build
- Agency-style debt schedule with DSCR, debt yield, and cap-rate exit returns
- Four revenue streams: lot rent (dominant), park-owned-home rental premium, RUBS utility recovery, and other income
- Infill occupancy ramp from acquisition occupancy toward a stabilised cap, not a flat vacancy
- Below-market lot-rent mark-to-market with a separate lot-rent growth assumption
- Operating expense stack to NOI with structurally high (60-70%) MHC margins
- Agency-style senior debt (high LTV, long amortisation, IO period) and a cap-rate exit on forward NOI
- Scenario toggle (Base / Upside / Downside) driving rent growth, infill pace, and exit cap
- Acquisition basis and Sources & Uses (price from in-place NOI / going-in cap)
- Occupancy infill ramp toward stabilised pad count
- Four income streams: lot rent, park-owned home rental, RUBS utility recovery, other income
- Six per-pad operating expense lines plus asset management fee
- Agency-style debt schedule with interest-only period, DSCR, and debt yield
- Exit valuation and unlevered / levered return metrics
- Returns: unlevered IRR, levered IRR, equity multiple, average cash-on-cash, and yield-on-cost

## Mobile Home Park Acquisition Model: Underwriting Value-Add MHC Deals

This mobile home park model helps you evaluate a manufactured housing community acquisition over a 7-year hold. It builds up lot rent, home rental, utility recovery, and other income, then subtracts operating expenses and capital costs to produce net operating income.

From there, it sizes levered IRR, equity multiple, cash-on-cash, and yield on cost under Base, Upside, and Downside scenarios. Rates and financial results described here reflect illustrative model settings, not industry benchmarks.

### Operating Drivers: Occupancy, Rent Growth, and Utility Recovery

The model is built around four revenue streams, with lot rent contributing roughly 80% of effective gross income. Occupancy is not a flat input: it follows an infill ramp, where occupied pads grow from the acquisition level toward a stabilised cap.

- Each year, occupied pads are the lesser of the stabilised cap or the opening occupied pads plus the annual infill pace. Average occupied pads use a mid-year convention, so a pad filled during the year earns about half a year of rent.

- Below-market lot rents can be pushed toward market, and RUBS recovers a share of water, sewer, and trash costs from residents. Other income, such as late fees, is a small percentage of net lot rent.

### Calculation Flow: From Revenue to Net Operating Income

Effective gross income sums net lot rent, home rental premium, utility reimbursement, and other income. On the cost side, six per-pad operating expense lines cover property taxes, payroll, repairs, utilities, insurance, and general and admin.

- Fixed expenses are charged on all pads, while consumption-driven expenses like repairs, utilities, and capital reserve are charged only on average occupied pads, so vacant pads do not carry consumption costs. An asset management fee of 4% of EGI is added.

- Net operating income is EGI minus total operating expenses. Below NOI, a per-pad capital reserve and infill capex tied to the change in occupied pads are deducted to arrive at unlevered free cash flow.

### Outputs: Acquisition Basis, Debt, and Return Metrics

The acquisition sheet derives purchase price by capitalising an in-place NOI bridge built from the model's own drivers, rather than typing a broker figure. Total project basis adds closing costs, an acquisition fee, and a capital improvement budget.

- A single senior loan is sized at 70% loan-to-value with a fixed rate, 30-year amortisation, and a 2-year interest-only period. The debt schedule tracks interest on the live opening balance, principal, and closing balance, and tests DSCR and debt yield against a 1.20x covenant.

- Returns are calculated from unlevered and levered cash flow streams over a 7-year hold, exiting on a forward NOI capitalised at an exit cap rate. Metrics include unlevered IRR, levered IRR, equity multiple, average cash-on-cash, and yield on cost.

### Practical Use: Scenario Toggle and Validation Checks

A scenario toggle on the assumptions sheet flexes three drivers: lot rent growth, infill pace, and exit cap rate. Switching between Base, Upside, and Downside re-runs the model through named ranges.

- The checks sheet validates structural relationships, such as sources equalling basis, occupied pads not exceeding total pads, and minimum DSCR clearing the covenant. One check may return REVIEW if the broker-stated in-place NOI differs from the derived bridge by more than 2%, which highlights a diligence step rather than a model defect.

- Returns are pre-tax and exclude depreciation, so cost segregation benefits are not captured. The model is a values-only preview and does not include live formulas.

## Pad infill value-add engine

Occupied pads ramp from in-place occupancy toward a stabilised cap, with infill capex tied to the change in occupied pads so it tapers to zero at stabilisation.

## Utility recovery and income streams

Lot rent, park-owned home rental premium, RUBS utility reimbursement, and other income build effective gross income, the core levers of MHC value creation.

## Debt sizing, returns, and exit

An interest-only then amortising agency loan with DSCR and debt-yield tests feeds unlevered IRR, levered IRR, equity multiple, cash-on-cash, and yield on cost at a cap-rate exit.

## Four-stream revenue and the infill ramp

Lot rent dominates EGI, with a park-owned-home rental premium, RUBS recovery, and other income layered on; economic occupancy is driven by an infill pace toward a stabilised cap.

## NOI, agency debt, and the exit

A low-capex expense stack drives 60-70% NOI margins; agency-style senior debt and a cap-rate exit on forward NOI turn NOI into a levered equity return.

## The return profile

The model solves to unlevered IRR, levered IRR, equity multiple, average cash-on-cash, and yield-on-cost, so the contribution of each value-add lever is visible.

## Features

- **Pad infill value-add engine:** Occupied pads ramp from acquisition occupancy toward a stabilised cap, with infill capex tied to the change in occupied pads so it self-zeroes at stabilisation.
- **RUBS utility recovery:** Model a ratio utility billing system that recovers a share of water, sewer, and trash cost from residents, a core MHC value-add lever.
- **Agency debt and returns:** Interest-only then amortising senior loan with DSCR and debt-yield covenants, feeding unlevered IRR, levered IRR, equity multiple, cash-on-cash, and yield on cost.
- **Value-add levers made explicit:** Push below-market lot rents, infill vacant pads toward stabilised occupancy, and implement RUBS to recover utilities - each is a separate, flexable driver rather than a blended growth rate.
- **Infill ramp, not flat vacancy:** Economic occupancy is driven by an infill pace that fills vacant pads year by year toward a stabilised cap, capturing the real shape of an MHC turnaround.
- **Agency financing and cap-rate exit:** Fannie- and Freddie-style senior debt at high LTV and long amortisation, with an exit priced off a cap rate on forward NOI, drives the levered return.

## Use cases

- **Acquisition underwriting:** Test whether a community's in-place NOI, going-in cap, and value-add plan clear target levered IRR and equity multiple hurdles.
- **Value-add business plan:** Quantify the NOI lift from raising below-market lot rents, infilling vacant pads, and implementing utility billbacks.
- **Debt sizing and exit:** Size agency debt against DSCR and LTV, then stress the exit cap rate to see its impact on net sale proceeds and equity returns.
- **Acquisition go / no-go:** Underwrite a specific community at a purchase price and decide whether the levered IRR, equity multiple, and cash-on-cash clear the hurdle.
- **Value-add business plan sizing:** Quantify how much of the return comes from lot-rent mark-to-market, infill, and RUBS versus market rent growth.
- **Financing structuring:** Test LTV, amortisation, and interest-only period against DSCR and the levered return to size the agency loan.

## Frequently asked questions

### What is a mobile home park financial model?

A model that projects lot rent, occupancy, operating expenses, NOI, debt service, and exit value for a manufactured housing community, used for acquisition and value-add underwriting.

### Why are mobile home park NOI margins so high?

Residents own and maintain their own homes, so the operator only maintains roads, utilities, and common areas. Low turnover and minimal capex push stabilised NOI margins to 60 to 70%.

### What is RUBS and why does it matter?

A Ratio Utility Billing System bills water, sewer, and trash back to residents. Implementing RUBS is a common value-add lever that lifts effective gross income and NOI without raising base rent.

### What is a typical going-in cap rate for a mobile home park?

Going-in cap rates generally run 5.5 to 7.0% depending on market and condition. Below-market lot rents at acquisition drive yield-on-cost well above the going-in cap as the value-add plan executes.

### Can I model the infill and value-add business plan?

Yes. The model ramps occupied pads toward stabilisation, grows lot rents annually, and recovers utilities, with a scenario toggle to flex rent growth, infill pace, and exit cap rate.

### How does the infill ramp work?

Occupied pads equal the lesser of the stabilised-occupancy cap and occupied-at-acquisition plus the infill pace times the year, so economic occupancy climbs year by year rather than jumping to a flat stabilised number.

### Why is agency debt used?

Fannie Mae and Freddie Mac actively lend on manufactured housing communities at attractive terms - high LTV, long amortisation, and interest-only periods - which improves the levered return and is modeled directly.

### Who uses a mobile home park acquisition model?

MHC investors and aggregators, real estate sponsors and acquisition analysts underwriting value-add deals, and fund managers benchmarking against operators like ELS and Sun Communities.

## Related templates

- [Multifamily Residential Model](https://finamodel.com/templates/multi-family-model)
- [Self-Storage Operations Dashboard](https://finamodel.com/templates/self-storage-ops-model)
- [Real Estate Development Pro Forma Model](https://finamodel.com/templates/real-estate-model)
- [Self-Storage Facility Model](https://finamodel.com/templates/self-storage-model)
- [Student Housing Development Model](https://finamodel.com/templates/student-housing-model)