Discounted Cash Flow (DCF) Valuation Model

Agriculture, All Industries, Business Consulting Services, Construction, Entertainment, Financial Model, Financial Services, General Excel Financial Models, Health Care, Hospitality, Infrastructure, Manufacturing, Media, Mining Industry, Transport

5-year Financial Projections, Accounts Receivable, Budgeting, Cash Flow Analysis, Cost Projections, DCF Model, Debt Schedule, Debt Security, Discount Rate, Excel, Financial Analysis, Financial Debt, Financial Due Diligence, Financial Feasibility, Financial Modeling, Financial modelling, Financial Projections, Financial Ratios, Financial Statements, Financing, Forecast, Forecasting, Income Statement, Inventory, Investing Cash Flows, Revenue Projections, Scenario Analysis, Sensitivity Analysis, Terminal Value, Three Statement Model | Three Financial Statements, Valuation, Valuation Services, VC Valuation, WACC (Weighted Average Cost of Capital)

This file contains a comprehensive three-statement financial model, incorporating the Balance Sheet, Profit and Loss Account, Cash Flow Statement, and additional supporting schedules, outlined as follows:

Input (Assumption) Tab: This section consolidates key assumptions related to revenue projections, operating costs, capital expenditures (Capex), depreciation rates, debt structure, working capital, and tax rate assumptions.
Balance Sheet and Profit and Loss Account: The Balance Sheet and Profit and Loss Account are constructed based on the historical data from the past four years, along with other assumptions derived from the supporting schedules. A five-year financial projection is provided, supported by both vertical and horizontal analysis for deeper insight.
Revenue Model Tab: This tab includes data on annual capacity, utilization, and pricing, from which revenue is projected. The revenue projections are directly linked to the Profit and Loss Account.
Working Capital Schedule: This schedule outlines the calculation of current assets such as trade receivables, inventory, and other current assets, based on days outstanding. It also forecasts current liabilities, including trade payables and other liabilities. Additionally, projections for working capital loans are included.
Asset Schedules: Individual asset schedules are prepared and consolidated into the total Property, Plant, and Equipment (PPE). The PPE schedule is split into two parts: one for PPE and depreciation as per the Companies Act, and another for tax-related calculations in accordance with applicable tax laws.
Equity Schedule: This schedule reflects the breakdown of share capital, retained earnings, and other equity components. Profit after tax is linked to retained earnings/other equity, with the corresponding impact reflected in the Balance Sheet.
Debt Schedule: The debt schedule captures loan additions, repayments, and calculates quarterly loan repayment schedules, which are subsequently reflected in the annual repayment tab.
Charts: Visual representations are provided for key metrics, including Revenue, COGS, EBITDA, EBIT, PAT, and Total Debt, along with their respective margin percentages.
DCF Valuation: In the Discounted Cash Flow (DCF) valuation section, Free Cash Flow to the Firm (FCFF) is calculated, followed by the determination of equity value after appropriate adjustments. Sensitivity analysis for both equity value and value per share is also included.

You must log in to submit a review.