Distribution, Financial Model, Mining Industry, Oil & Gas, Service Businesses

5-year Financial Projections, Break-Even, Budget, Business Valuation, Cash Flow Analysis, CFO, Cost Calculation, Cost Projections, Customer Relationship Management (CRM), Dashboard, DCF Model, Excel, Financial Analysis, Financial Debt, Financial Due Diligence, Financial Feasibility, Financial Model, Financial Modeling, Financial Planning, Financial Projections, Financial Ratios, Financial Reporting, Financial Statements, Financing, Forecast, Forecasting, Fundraising, Investment Multiple, Investor Cash Flows, Investor Presentations, Investors, KPIs (Key Performance Indicators), NPV (Net Present Value), Pricing, Private Equity, Private Equity Waterfall Distribution Models, Profitability Analysis, Project Finance, Project Management, Project Plan, Real Estate Valuation, Rental Income, Replacement Cost, Return on Invested Capital (ROIC), Revenue Projections, Risk-Adjusted NPV, Sales Funnel, Sales Pipeline, Savings Rate, Startup Financial Models, WACC (Weighted Average Cost of Capital)

Full Title: DCF Valuation Model with 5 Years Actual, 1 Year Budget, and 5 Years Forecast – Oil and Gas Retail Marketing & Distribution Company

A detailed and user friend financial model that captures 5 years of Historical + 1 Year of Budget + 5 Years of the forecast period. The model includes three integrated financial statements, i.e., Income Statement, Balance Sheet and Cash Flow Statement, Discounted Cash Flow valuation, and in-depth financials & valuation analysis.

The model includes assumptions related to the following:

1. Business Drivers – Number of Stations [Company Owned Company Operated (CoCo) and Dealer Owned Dealer Operated (DoDo) Stations], Sales Volume by Product [Petrol, Diesel, Kerosine]
2. Revenue Assumption – Fuel and Oil Revenue, Fuel Transportation, Rental, Grocery & Export
3. Costs Assumptions – Fuel Cost, SG&A, and Other Overheads
4. Capital Expenditure and Depreciation/Amortization by Asset Class – Land, Building, Vehicles, Machinery & Tools, Computer & Systems, etc.
5. Working Capital Assumptions (Receivables, Payable, Inventory)
6. Long Term and Short-Term Bank Debt, Bank Overdraft
7. Share Capital (Issue of New shares, Reserve Accounts)
8. Dividend Payout
9. Interest Income and Expense calculations
10. Income Tax

The model runs comprehensive calculations based on the inputs provided by the user to generate precise outputs, which include:

1. Income Statement: Includes Historical and Forecasted Profit and Loss statement.
2. Balance Sheet: Includes Historical and Forecasted Balance Sheets.
3. Cash Flow Statement: Includes Historical and Forecasted cash flows.
4. Valuation: DCF-based valuation based on the Forecasted cash flows and discount rate assumptions
5. Valuation Ratio: A very detailed financial analysis covering:
– Price and EV-based valuation ratios
– Per Share Data like EPS, DPS, FCFF per share & more
– Margin ratios
– Return ratios
– Dupont Analysis
– Gearing Ratios
– Liquidity ratios
– Coverage Ratios
– Activity Ratios
– Investment rations
– Enterprise value.

This Best Practice includes:
1 Excel File