The model has multiple house analysis database through which you can set the expense, mortgage expense, refinacing expense details and accordingly the expecteded financial income statement is also created along with a graphical keyboard
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.
