RE Investment Fund Model – Mobile Home Park Development

Commercial Real Estate Properties, Development, Financial Model, Investment, Mobile Home, Real Estate, Residential Properties

10-year Financial Projections, Cap Rate (Capitalization Rate), Cash Flow Projections, Excel, Financial Analysis, Financial Feasibility, Financial Model, Financial Modeling, Financial modelling, Financial Projections, Financial Statements, Financing, Forecast, Forecasting, Free Cash Flows, Investor Cash Flows, Investors, IRR (Internal Rate of Return), NPV (Net Present Value), Rental Income, Revenue Projections

The RE Investment Fund – Mobile Home Park Development financial model projects monthly future cash flows for a real estate investment fund pertaining to mobile home parks. It accounts for the development and management of a mobile home park, costs for each unit, levered free cash flow, and an investor cash waterfall. The tabs included are:

Fund Summary
Inputs
Mobile Home Unit Schedule
Annual and Monthly Investor Cash Flows

The flow of the model starts with the Input tab to enter most of the assumptions that will drive the model. Here assumptions such as project timeline, mobile home costs, finance terms, and investor returns are entered and flow into the MH Unit Schedule and Investor Cash Flows tabs. The model is built to allow for up to 10 different Mobile Home projects. The MH Unit Schedule breaks out the Mobile Home purchase and development schedule along with the projected revenue renting out the units.

The Investor Cash Flow tab includes important aspects such as Mobile Home purchasing costs, revenue, levered free cash flow, and a cash flow waterfall for investors. In the Cash Flow Waterfall section, equity invested, cash flow distribution and IRR can be adjusted for GP/LP. In this section, IRR and NPV is calculated for GP/LPs and the project as a whole. Other metrics include Equity multiple and Unlevered/Levered Cash on Cash multiples.

Lastly, the Fund Summary has key metrics for the project. In this tab there is an annual summary of cash flows for the life of the investment, ROI, and IRR metrics.

All cells in blue font are input cells where custom information can be entered. All cells in black font are formulas set to streamline the model.

You must log in to submit a review.