Free Cash Flow Real Estate Valuation Template
The Free Cash Flow Real Estate Valuation Template helps to create a business plan for 10 years as well as estimate enterprise and equity values under certain assumptions.
The free cash flow valuation template includes the following worksheets: PL (Income Statement), BS (Balance Sheet), CF (Cash Flow), Operating Revenue Financing, CapEx, WACC, and Valuation. These are very powerful reporting and analysis sheets that are tailored for a real estate business. These sheets are adjustable for your company’s specific needs.
The functionality of the Free Cash Flow Real Estate Valuation Template:
- automatic creation of a Cashflow Statement, taking into account assumptions in the Income Statement and the Balance Sheet;
- a separate worksheet for calculation of WACC, which can be carried out in two ways: manually or using CAPM (assumptions for a real estate company operating in the US market are already there);
- a separate worksheet for valuation, which displays FCFF for each year, terminal firm value;
- sensitivity analysis for the company value to assumptions of WACC and terminal growth rate;
- detailed projections of financing activities and CAPEX.