Commercial Real Estate Properties, Financial Model, Investment, Real Estate

Excel, Financial Model, Financial Modeling, Financial Planning, Financial Projections, Startup Financial Models

The Real Estate JV Model analyses an equity joint venture investment. The model assumes the acquisition of a property unit and analyses the property to project the stream of rental income and also a potential sales of the property at a mark up within 7 years. The model helps users to quickly make a judgement call on an investment opportunity in the rental real estate business.

The model has a sensitivity table showing various Internal Rate of Return (IRR) and Return on Invested Cash (ROIC) points driven by selected rental escalation and and target exit sales margin. Users are able to update the target sales margin and rental escalation in the sensitivity matrix to suite preferred range

On the opening sheet, we also give a deep description of model drivers, legends and link to a Youtube video aimed at helping users understand the construction of the model from scratch.

Lastly, the model has dynamic charts that can be copied into investment teasers and pitch decks.

Target Users:
– Investment Analyst
– Postgrad and Undergrad students looking to understand more about rental real estate
– Individual Real Estate Investors
– Real Estate Business Development Professionals
– Real Estate Firms

File Type: .xlsx