Assisted Living Acquisition Pro Forma Financial Model

Made to order Assisted living Pro Forma Cash Flow Model

The contents are as follows:

- Assumptions Tab

- Annual & Monthly Cash Flows;

- Flexible Rent Roll with the specific Assisted living type of costs;

- Financing/Loan Amortization + Refinancing;

- Waterfall Structure.

This model is:

- Clean and transparent;

- Professional;

- Reliable;

- 100% dynamic;

- Easy to use, understand and modify;

- Prepared by an industry professional with a significant track record;

- Institutional quality;

- Presentable;

- Includes only useful information.

MAIN PURPOSE OF THE MODEL

This multifamily acquisition model will help you to:

- Present main economics of an investment opportunity;

- Estimate rates of return and measure NPV for a multifamily acquisition;

- Measure operating, capital and financing costs;

- Present the cash flow of an investment;

- Perform valuation of an investment property;

- Assess the feasibility of the refinancing option and an amount of taking out;

- Assess a range of rental and exit scenarios;

- Assess a range of financing options.

KEY OUTPUTS



- Dashboard with all the main metrics;

- Cost/Unit, Sale Price/Unit, Net Rental Revenue;

- NOI, Debt Service, Net Leveraged Cash Flow;

- Exit Sale Price is calculated on stabilized NOI and assumed exit cap rate;

- DSCR, Cash on Cash Return, IRR, Equity Multiple, Net Profit;

- Financing components including refinancing of the senior loan;

- Common Equity Waterfall.

In case you have any questions or concerns before purchase, please feel free to contact me directly.

If you have specific requirements for the model or need a consultation, please also contact me.