Financial modelling
23 practice items · needed by 1 role
Easy 8Medium 9Hard 6
Practice questions
- Reading a revenue varianceeasy
- Break-even volumeeasy
- Reading a cost varianceeasy
- Spotting a variable costeasy
- Totals by region and montheasy
- Locking a cell referenceeasy
- When to use Goal Seekeasy
- Margin of safetyeasy
- Retained earnings roll-forwardmedium
- XLOOKUP default behaviourmedium
- Sales needed for a target profitmedium
- Flexing the budget for volumemedium
- Splitting price and volumemedium
- Two-way lookup in a gridmedium
- Using an Excel data tablemedium
- What a 12-month rolling forecast coversmedium
- Markup versus marginmedium
- Operating leverage and EBIThard
- Probability-weighted scenarioshard
- Reading a tornado charthard
- Fixed costs rise, break-even moveshard
- Handling an interest circularityhard
- IRR with irregular dateshard