3-Statement Model with DCF Valuation (MS Excel Model Template)

Description
The financial model is built based on a sample company data.

This is a fully integrated 3-statement financial model (Income Statement, Balance Sheet and Cash Flow Statement) of a company using Excel. The 3-statement model includes IS, BS and CFS but also includes some complex calculations and detailed schedules. The model also includes a DCF template using data from your projections and assumptions used in the 3-statement model to calculate the the "fair" value per share of a company based on simple assumptions.

You can control the inputs and assumptions in the model such as revenue growth, costs Tax rate, Working Capital, Capital Expenditures (Capex), Depreciation, Free Cash Flow Terminal Growth Rate, Number of Shares, Current Share Price etc.

The model also includes sensitivity analysis to check how the derived Equity Price changes when there is change to inputs such as WACC and Terminal Growth Rate.

The model contains a macro to print the file as a PDF.

Please note that this model may not ideal for input in the decision making process and it doesn't incorporate detailed analysis. A very comprehensive model (available on request) should be used instead for detailed calculations and precise valuation.

City Research 2019.

Please feel free to contact us should you have any questions.