Financial Modeling Workshop

Explore the presentation of profit and loss statements: accrual, cash, and class bases, and learn how FPNA uses these formats for budgeting, forecasting, and scenario analysis.

Create a forecasted income statement for 2020–2023 by linking revenue growth, 18% cost of sales, operating expenses, depreciation on opening assets, capex, and tax via an if function.

Link income statement forecasts to the retained earnings ledger, apply a 3% dividend payout, and compare top-down and bottom-up EBITDA calculations in a practical Excel model.

Build a three-statement financial model for the Alpha Bravo Charlie case study, using 10.5% revenue growth and IFRS policies to project margins, capex, working capital, debt, and taxes.

Explore how to read historical financial information from income statements, balance sheets, and cash flow statements, linking revenues, costs, and taxes to projections in an IFRS framework.

Format and construct a five-year to ten-year financial model from historical data, linking income statement, balance sheet, and cash flow with subtotals, depreciation, ebitda, DuPont analysis, and FP&A assumptions.

Add assumptions to both historical and forecast data to drive a robust financial model. Explore revenue growth, COGS, expenses, working capital, CapEx, taxes, and scenario analysis.

Analyze historical data from 2015–2019 to create dynamic revenue growth and expense assumptions, linking COGS, payroll, fixed costs, depreciation, interest, taxes, CapEx, and working capital days.

Forecast the income statement from 2020–2024 using a vertical model, applying revenue growth, cost of goods sold percentage, and payroll and overhead expenses to compute gross and after-tax profits.

Prepare a depreciation schedule for future years, applying 15% of opening PPE and linking depreciation to the income statement and cash flow statement, with CapEx considerations.

Build a debt and interest schedule in excel, with opening, closing balances and 2020–2024 repayments, then compute interest as the average balance times 5% linked to the income statement.

Forecast the balance sheet by linking assets, liabilities, and equity to the income statement and cash flow, using debt, equity, retained earnings, and working capital schedules.

Explore the retained earnings schedule, linking opening balances, net income, dividends, and transfers from revaluation surplus to the balance sheet and consolidated group equity, within IFRS consolidation standards.

Build a working capital schedule within the balance sheet by forecasting accounts receivable, inventory, and accounts payable using 365-day revenue methods, and calculate days and the cash conversion cycle.

Compute working capital days from accounts receivable and payable balances using 365-day normalization, link to the balance sheet, and assess the cash conversion cycle.

Format and present a forecasted balance sheet with clear assets, liabilities, and shareholder equity, aligning with the income statement, comprehensive income, revaluation surplus, and cash flow schedules.

Explore the vertical financial model, covering income statement, balance sheet, cash flow, and schedules for depreciation, property plant equipment, loans, working capital, and retained earnings.

Learn to build a cash flow statement from historical to projected data, linking income statements and balance sheets, applying indirect and direct methods, and adjusting non-cash items.

Complete the three-statement financial model by finishing the cash flow statement, including operating, investing, and financing activities, with subtotals, opening and closing cash balances, and scenario analysis.

Explore scenario analysis in a financial model by adjusting revenue growth from 10.5% to 12% and beyond, and analyzing impacts on the income statement, balance sheet, and cash flow.

Build a three‑statement financial model with scenario analysis in Excel, linking live cases to assumptions and comparing best, normal, and worst cases on revenue and profits.