Financial modeling requires accounting knowledge, spreadsheet skills and business judgment. The useful test is what you can build, check and explain without following a demonstration.
Use this checklist to identify what to practise next. It is a self-assessment, not a hiring test or a professional qualification. If you are completely new, start with the beginner example.
Accounting and statement links
You need to understand the difference between earning revenue and collecting cash, between an expense and an asset purchase, and between borrowing and operating income.
Practice: a fictional business begins with cash of 20,000 and equity of 20,000. It buys equipment for 6,000 cash, then borrows 4,000. Ignore all other transactions. Closing cash is 18,000; equipment is 6,000; debt is 4,000; equity remains 20,000. Assets and liabilities plus equity both equal 24,000.
Ready when: you can explain each entry and why neither the equipment purchase nor the loan is sales revenue.
Excel formulas and references
Practise arithmetic, logical tests, sums, lookups and date handling. Learn relative, absolute and mixed references before relying on complicated functions. A short formula that another person can inspect is often more useful than a long formula that hides the logic.
Practice: place a tax-rate assumption in B2 and a series of positive taxable-profit amounts in B5:D5. In B6, enter =B5*$B$2 and copy it across. Confirm that the profit reference moves while B2 stays fixed. This is a reference exercise; real tax schedules can require losses, timing differences and jurisdiction-specific rules.
Ready when: you can predict which references change before copying a formula.
Business drivers and forecasting
A forecast should explain the business, not just extend last year’s totals. Depending on the company, revenue may depend on units and price, customers and spending, or capacity and utilization. Explain why the chosen drivers fit the business.
Practice: forecast monthly revenue from 500 customers spending 40 each. Then change customers to 450 and spending to 42. Revenue changes from 20,000 to 18,900. Identify which change offsets part of the volume decline.
Ready when: you can separate historical data, sourced assumptions and your own estimates.
Cash flow and supporting schedules
Cash forecasting requires more than applying a profit margin to revenue. Work through receivables, inventory, payables, capital expenditure, depreciation, debt and interest where relevant.
Practice: revenue is 100,000, all on credit, with no write-offs. Opening receivables are 10,000 and closing receivables are 15,000. Customer collections are 95,000: opening receivables plus credit sales minus closing receivables.
Ready when: you can explain why rising receivables reduce collections relative to recorded sales in this example.
Model structure and documentation
Make the period, units, currency and sign convention clear. Separate inputs from calculations. Record sources and dates. Give worksheets meaningful names and explain how a user should update the model.
Practice: give someone your workbook with a short instructions sheet. Ask them to change a sales assumption and find the resulting cash balance without your help.
Ready when: the person can complete the task and trace the result back to the changed input.
Error checks and review
A balanced balance sheet is necessary in a three-statement model, but it does not prove every assumption or formula is correct. Test formulas, links, opening balances and expected business relationships.
- Does opening cash plus net cash movement equal closing cash?
- Does opening debt plus borrowing minus repayments equal closing debt?
- Do forecast formulas behave consistently across periods?
- Are zero volume, a cost increase and delayed collections handled sensibly?
Practice: deliberately break one formula in a copy of your workbook. Check whether your review catches the error. Remove the error before using the file again.
Ready when: you can distinguish a spreadsheet error from a valid but unfavorable business result.
Scenarios and sensitivity
A scenario changes a connected set of assumptions. A sensitivity exercise isolates the effect of selected input changes. Use each to answer a specific question.
Practice: build a downside case with lower volume and slower customer collections. Then test price changes on their own. Explain why the two exercises produce different information.
Ready when: the scenario selector updates the intended inputs consistently and leaves the base assumptions recoverable.
Valuation for the role you want
Valuation is essential for some modeling roles and less central for others. An operating-budget role may focus on cash and performance, while a transaction role may require discounted cash flow, comparable-company analysis and financing mechanics.
Practice: explain which model output answers the decision in your case. If you calculate value, identify whether it relates to the whole business or the shareholders and show the bridge between them. Practise with the worked enterprise-to-equity value example.
Ready when: you can explain the assumptions and limits of the method instead of presenting one number as certain.
Communication and responsible use of AI
Write a short conclusion: the question, the base result, the main driver, a downside and the decision that still needs judgment. Show units and periods on every important output.
AI tools can help draft formulas or explanations. Check their outputs against the source data, a hand calculation and a test case. Do not place confidential employer or client data into a tool without authorization.
Ready when: you can explain a formula’s logic yourself and identify what evidence would change your conclusion.
Choose your next practice task
For each section, record one of three states: need help, can do with notes, can do independently. Start with the earliest foundation you cannot yet demonstrate. Do not average the results into a claim of professional readiness.
Use the study plan to arrange your practice. Before applying, compare your work with the actual job responsibilities and prepare to explain one complete model.
Reference
For principles on workbook clarity, inputs and review, see the ICAEW Financial Modelling Code. For the reference-copying exercise, see Microsoft’s cell-reference guide.
