Financial Models

Building / acquiring, operating and the dissolution of mobile home parks (MHPs) can take a wide range of financial planning. This sophisticated model allows for the user to plan out all of these dynamics from 1 to 40 MHPs over a 16 year period and includes three separate waterfall outputs for various joint venture structures.

They each have configurations for all relevant acquisition costs and/or development costs, financing assumptions, and total initial investment as well as all revenue logic and expense items along with logic for growth therein. Specific configurations include: Start Month, # of Months, Until Rev. Starts, Annual NOI, Entry Cap Rate, Entry Acquisition Cost, Construction/Other Cost, Total Acquisition Cost, Debt%, Equity. Revenue assumptions are configurable per MHP based on Unit Count, Starting Weighted Average Lot Rent, Lot Rent Growth (year 2-4), Stabilized Rent Growth (per year), Initial Occupancy, Vacancy Improvement per Month, Stabilized Occupancy. There are up to 17 operating expense items for each park as well as an expense rate growth therein. Final outputs include P&L per park and all of those get aggregated to total cash flow over the same timeline.