Real Estate Acquisition Portfolio Model (Buy - Upgrade - Rent - Exit)Real Estate Acquisition Portfolio Model consists of a financial model in excel and an investment proposal in PowerPoint for the acquisition of a real estate residential apartments portfolio at below replacement cost, with further renovation and short term renting through online platforms, and exiting the investment as soon as the rental income has stabilized. The model generates the cash flows of the portfolio investment, as well as the cash flows of

assumptions regarding Dividend Payout Ratio

Hard & Soft costs are calculated as well

tax on rental income

costs splits between direct costs (for the various services provided as percentage margins

ensuring that expenses are properly managed and controlled

It includes comprehensive projections for fleet utilization

Don't forget you need to enable macros only in order to calculate the Internal Rate of Return (IRR) otherwise you don't need it everything is calculated on the spot

free cash flows to the firm

Finally sensitivity tables are derived to take into account all three scenarios and both exit value methods

Internal Rate of Return and Cash on Cash Multiple

Once the General Assumptions

- The option to delay: a project that is negative from a net present value perspective now