RE Investment Fund – Mobile Home Park with Lease Option

Financial Model, Investment, Mobile Home, Real Estate

10-year Financial Projections, 5-year Financial Projections, Break-Even, Cap Rate (Capitalization Rate), Cash Flow Analysis, Cash Flow Projections, Cash-on-Cash Multiple, Excel, Financial Analysis, Financial Model, Financial Modeling, Financial Planning, Financial Projections, Financial Ratios, Forecast, Forecasting, Investing Cash Flows, Investment Multiple, Investor Cash Flows, Investors, IRR (Internal Rate of Return), KPIs (Key Performance Indicators), Private Equity, Private Equity Waterfall Distribution Models, Real Estate Valuation, Return on Investment (ROI), Scenario Analysis, Three Statement Model | Three Financial Statements, Valuation

The RE Investment Fund – Mobile Home Park with Lease Option financial model projects monthly future cash flows for a real estate investment fund pertaining to mobile home parks. It accounts for purchase and transportation costs for each unit, a leasing schedule, levered free cash flow, and an investor cash waterfall. The tabs included are:

Fund Summary
Inputs
Mobile Home Leasing Schedule
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 Leasing Schedule and Investor Cash Flows tabs. The model is built to allow for up to 10 different Mobile Home projects. The MH Leasing Schedule breaks out the Mobile Home purchase and leasing schedule along with the projected revenue and interest from leasing 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.