All Industries – Financial Forecasting Model: 5 Year FRC / 3-Statement Model / DCF Valuation

All Industries, General Excel Financial Models

5-year Financial Projections, Accounting, Accounts Payable, Accounts Receivable, Amortization, Budget, Budgeting, Business Valuation, Calculator, Cash Flow Analysis, Cash Flow Projections, Chart, Dashboard, DCF Model, Debt Schedule, Discount Rate, Dividends, Excel, Financial Analysis, Financial Debt, Financial Model, Financial Modeling, Financial Planning, Financial Projections, Financial Ratios, Financial Reporting, Financial Statements, Financing, Forecast, Forecasting, Income Statement, Intangible Assets, NPV (Net Present Value), Profitability Analysis, Return on Invested Capital (ROIC), Return on Investment (ROI), Terminal Value, Three Statement Model | Three Financial Statements, Valuation, WACC (Weighted Average Cost of Capital)

Model Description & Objectives

Overview & Main Objective : A fully comprehensive Financial Forecasting Model, suitable for all types of companies in all industries. The main objective is to develop a 5 year Financial Forecast for the business by using a 3-Statement Model (Income Statement, Balance Sheet, Cash Flow). Moreover, to provide a Valuation for the Business by using a Discounted Cash Flow Model.

Financial Forecast : A 5 year Financial Forecast is performed for the 3 main Financial Statements: Income Statement, Balance Sheet & Cash Flow Statement. Moreover, one can see the main Financial Ratios in the relevant worksheet.

Business Valuation : A Business Valuation is performed in the relevant worksheet using a Discounted Cash Flow model to calculate the intrinsic value of the Company.

It is assumed that the Company’s Shares are not trading in the Stock Exchange, and therefore we compare the Intrinsic Price of the Company to the existing Book Value.

The required Return on Equity is calculated through the Capital Asset Pricing Model (CAPM). The WACC of the firm is then calculated taking into account also the cost of Dept.

Model Contents : The model contains 3 types of worksheets (w/s). Input w/s; Reporting w/s, where no input is required; and there is also a supporting w/s containing the abbreviations.

Input Worksheets :

Model Settings : Here you may fill in the required info in the “Model Setup” section.
Financial Assumptions & Calculations : In this w/s you may input the assumptions for the Income Statement and the Balance Sheet. The rest of the calculations for the Cash Flow Statement and the various financial schedules are performed automatically.
Financial Statements : This w/s contains the 5 year Forecast for the 3 main Financial Statements. You may input the required data in the respective cells concerning the “Actual” period. All calculations concerning the “Forecast” period are performed automatically, using also the input from the “Fin. Assumptions & Calculations” w/s.
Business Valuation : Here you may perform a Valuation for your Business by using a Discounted Cash Flow method: Input the required data to estimate the Required Return on Equity (%) (Cost of Equity), and the WACC of the Firm. By using the Discounted Free Cash Flow to Firm method, the Valuation for the Business is performed automatically. All you need to input is the Terminal Growth Rate, and number of shares outstanding in order to end up with an Intrinsic Value per Share for the Business.

Reporting Worksheets :

Executive Summary & Charts w/s: In the Financials Executive Summary w/s you may review the key data of your 5 year Forecast, and relevant charts, that may help you have a better understanding of your Business Forecast, and perhaps decide on fine-tuning adjustments needed.
Financial Ratios : Here you may see the values of the main Financial Ratios: Profitability & Return, Liquidity, Leverage, Asset Utilization.

We, at Stan Simons Consultants, will be available to assist you in any inquiries you may have and/or any challenges you may encounter concerning this model. We are committed to providing a smooth customer experience and after-sales service. Moreover, we will be available in the case you may need to tailor the model to specific business needs.

You must log in to submit a review.