Finance Desk · Beyond the IB course
Advanced financial analysis
Four tools for undergraduates, MBA students, professionals and teachers that take the Finance Desk past the IB course: a forecast whose three statements link and balance, a comparator for investment projects, break-even scenarios for two cost structures, and a dashboard that takes return on equity apart. Each starts from Emberly Roasters, the Financial Laboratory’s fictional coffee roaster, and says exactly which parts the IB course uses.
- Beyond the IB course
- Undergraduate, MBA, professional and teacher
- Simulated data Example: Emberly Roasters, fictional
Emberly Roasters, beyond the course
Simulated data A fictional business; every figure below is worked by the tool it links to.
- Lowest year-end cash, base case −$14,425 end of 2027; profit over five years $172,806
- Highest NPV at 8.625%, the WACC $49,956 Second roaster for supermarket orders
- Indifference volume 3,765.6 bags a month: automating pays above it, outsourcing below
- Return on equity, 2025 22.1% down from 41.4% in 2022
Section 01: The four tools
Each with inputs you can change, results that follow, charts drawn from the figures, saving in this browser and a CSV of everything; and each a complete worked example without JavaScript.
-
Integrated forecast
Will the plan make a profit, and can the business pay for it, year by year?
A three to five year forecast built from drivers: a statement of profit or loss, a statement of cash flows and a balance sheet that balances every year, with base, upside and downside scenarios and two strategic alternatives side by side.
Example −$14,425 -
Capital budgeting comparator
Which project adds most value, and how much do the answers depend on the estimates and the discount rate?
Two or three projects compared by net present value at any discount rate, internal rate of return, payback, discounted payback and the profitability index, with a tornado chart of what moves NPV and a WACC helper that sets the discount rate.
Example $49,956 -
Break-even scenarios
Which cost structure earns more, at what volume does the answer change, and which carries more risk?
Two cost structures side by side, higher fixed and lower variable costs against the reverse: break-even, margin of safety, degree of operating leverage and the indifference volume at which one becomes better.
Example 3,765.6 bags -
Financial performance dashboard
What has driven the return to the owners over several years, and how far can each measure be trusted?
Several years of accounts read through the DuPont analysis of return on equity, the cash conversion cycle, interest cover and gearing, beside the IB’s own ratios, with a reading of each movement and the limits of each measure.
Example 22.1%
Section 02: Where the IB course stops
What the course covers in each area, and what this mode adds beyond it.
| Area | The IB course | Beyond it, in this mode |
|---|---|---|
| Financial statements | IB 3.4 IB 3.7 The statement of profit or loss and the statement of financial position, in set layouts, and a cash flow forecast of receipts and payments. | All three statements forecast together from drivers, with a statement of cash flows built from profit, balancing every year; scenarios and strategic alternatives. |
| Investment appraisal | IB 3.8 Payback and the average rate of return; at HL, net present value with the guide’s table of discount factors at five rates. | NPV at any rate, the internal rate of return and its pitfalls, discounted payback, the profitability index, a tornado, and the discount rate from the WACC and the CAPM. |
| Break-even and cost structure | IB 5.5 IB 5.6 Break-even, the margin of safety and the effect of changes in price or cost; at HL, operating leverage (named, with no formula) and cost to make against cost to buy. | Two cost structures side by side, the degree of operating leverage as a formula, and the indifference volume. |
| Ratio analysis | IB 3.5 IB 3.6 Profitability and liquidity ratios; at HL, stock turnover, debtor and creditor days and gearing, with the guide’s formulas. | Return on equity and its DuPont split, the cash conversion cycle, interest cover and all borrowing to equity, read over several years. |
The course’s content is described in the platform’s words from the Business management guide (first assessment 2024), checked against the guide on 29 October 2026; the formulas the guide gives are on the formula sheet. Each tool’s page sets out its own line in full.
Section 03: Who it is for
-
Undergraduates
The methods of a first course in corporate finance and financial analysis, worked on one business, with every formula and working shown. The undergraduate pathway.
-
MBA students and professionals
A quick, transparent model to test a plan, an investment or a cost structure against your own figures, and to explain the result to others. The MBA pathway.
-
Readers of the finance modules
The ideas behind these tools, with real companies, cases and further reading, are in the six finance modules of Advanced Management and Strategy. Advanced financial management.
-
Teachers
Extension for able IB students after the course’s methods are secure, labelled so that nothing beyond the syllabus is mistaken for it. The teachers’ pathway.
Arjun Agrawal | The Business Brief, https://the-business-brief-dun.vercel.app/finance-desk/advanced/. Original teaching material, not an IB publication. The organizations in the teaching cases are fictional unless a case says otherwise.