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.