Financial Modelling, Financial Planning and DCF Valuation

Learn to populate a financial model with manufacturing inputs, including product lines, volumes, prices, costs, and production plans, using templates for flexibility and client-ready explanations.

Explore model inputs for a manufacturing company, including pricing, production costs, admin expenses, consulting fees, director and staff costs, currency choices, and software licenses for financial plans and DCF valuation.

Explore model inputs for staffing and cost assumptions in financial plans, detailing salaries, headcount flexibility, and expense categories such as marketing, IT, admin, travel, and subscriptions.

Explore how IFRS governs R&D classification versus business development or consultancy expenses, and build a five-year loan schedule with opening balances, interest, and effective rates to inform financial plans.

Set up model inputs for capex, working capital, dividends, and financing to capture expansion plans, licensing intangibles, and operating cycles.

Learn to build flexible financial model scenarios in Excel by creating a three-scenario framework (optimistic, base/realistic, pessimistic) with dropdowns or combo boxes and linked input ranges.

Build scenario models for optimistic, conservative, and pessimistic cases; configure inputs, lock columns, and use index to select scenarios, with copy of formulas for robust financial modelling.

Demonstrate building scenarios in excel with index and absolute references, formatting labels, and linking unit price and unit costs across products to compare optimistic, conservative, and worst-case inputs.

Model multiple scenarios by adjusting costs, line items, and optimistic and pessimistic cases, including marketing and R&D expenses, to build a flexible financial model.

Learn to build and update a revenue schedule in a financial model by linking scenario data, configuring product-line revenues from volume and price, and ensuring consistency across sheets.

Learn to build a cost of sales schedule that mirrors the revenue schedule, using unit costs, volumes, and multiple scenarios, and apply drag formulas to reflect the chosen scenario.

Build a working capital schedule by linking forecast revenue and cost of sales to receivables, payables, and inventory, and apply days outstanding with 365 or 360 day conventions.

Build a depreciation schedule in Excel using straight-line depreciation, linking inputs from the model imputes sheets and separating asset categories, capital expenditure, and salvage value.

Learn to extend a depreciation schedule across years with straight-line depreciation, dynamic inputs, and absolute references to compute net book value and amortisation.

Model the debt schedule to calculate interest expense and income across bank overdraft, revolver facilities, and multiple loans, linking it to cash flow and liquidity inputs.

Create and populate the equity schedule in Excel, detailing ordinary and preferred shares, buybacks, dividends, and opening/closing balances, tied to net income and retained earnings across scenarios.

Develop and implement a tax schedule within the financial model, using income tax rates, current and deferred taxes, and timing differences between accounting and tax treatment.