Financial Modelling, Financial Planning and DCF Valuation

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.

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.

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.

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.

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.