To learn financial modeling, start with accounting, practise the Excel skills you need, and build one complete model. Then test your assumptions and explain what the results mean. I recommend this order because each step gives you something you will use in the next one.
This guide gives you a learning plan. For an introduction to the subject, read financial modeling for beginners. If you already understand the basics, start with the practice tasks below.
What you should be able to do
Your first goal is to build a simple forecast that someone else can understand and check. By the end, you should be able to:
- Read an income statement, balance sheet and cash flow statement.
- Explain where your historical figures and assumptions came from.
- Connect the forecast through formulas instead of typing each result.
- Check that the statements reconcile.
- Change an assumption and explain its effect on profit and cash.
- Present your findings, including the limits of the model.
Understand the financial statements
Before forecasting a business, understand how it records its results. Learn what revenue, expenses, assets, liabilities and equity represent. Pay particular attention to the difference between profit and cash.
Practice: Choose a business with published annual reports. Find its three financial statements. Trace one example of capital expenditure, one debt movement and one working-capital movement. Note where each appears and how it affects cash.
You are ready to move on when: you can explain why a profitable company might still need cash, and how the balance sheet connects to the cash flow statement.
Use the examples in financial statement analysis for beginners to review these foundations.
Learn the Excel skills the model requires
You do not need to master every Excel feature before starting. Learn to use relative and absolute references, basic arithmetic, SUM, IF, SUMIFS, dates and a lookup method. Know how to trace a formula back to its inputs and recognize an error.
Keep inputs, calculations and outputs easy to identify. State the currency, units and time period. Use a consistent sign convention and document assumptions. A complicated formula is harder to check than a clear sequence of calculations.
Practice: Create a small revenue forecast using units sold and price. Put the assumptions in separate cells. Change the price and confirm that revenue updates without editing the calculation.
You are ready to move on when: you can copy formulas across periods, explain their references and find the cause of an incorrect result.
Choose one case and gather the data
Start with a straightforward business you can describe. Avoid learning several model types and industries at once. Write down the question your model will answer: for example, how much cash a growing business may need.
Collect the historical statements and record their sources. Keep reported figures separate from your adjustments and assumptions. If you use fictional data for practice, label it clearly.
Practice: Prepare a source sheet with the company, reporting periods, currency, units and links to the reports. Enter historical figures and reconcile them to the published statements before forecasting.
You are ready to move on when: another person can locate your source figures and understand any adjustments.
Build the forecast and supporting schedules
Forecast revenue from drivers that fit the business. Then work through operating costs, working capital, capital expenditure, depreciation, debt and interest. Connect the income statement, balance sheet and cash flow statement.
Keep the first version manageable. You should be able to explain each assumption. Adding more detail is useful when it helps answer the model’s question.
Practice: Complete a simple three-statement model. Add a balance-sheet check and a reconciliation between the cash flow statement and the change in cash.
You are ready to move on when: the statements reconcile and you can trace the effect of a change in sales through the model.
Test assumptions and find errors
A model should help you examine different outcomes. Change one important assumption at a time to understand its effect. Then compare a consistent set of assumptions for different scenarios.
Check the formulas as well as the answer. Look for inconsistent signs, missing links, unexplained hardcoded figures and assumptions that change between periods without a reason. A balanced balance sheet is a useful check, but it does not prove that every calculation or assumption is correct.
Practice: Test a slower-sales case and a higher-cost case. Explain what happens to cash and funding needs. Use sensitivity analysis in Excel to practise one- and two-variable data tables.
You are ready to move on when: you can identify the assumptions that matter most and explain why a result changes.
Learn valuation and the models relevant to your goal
Once you can build and check a forecast, choose the next skill according to the work you want to do. Learn the assumptions behind a valuation method before relying on its output.
- Investment banking: develop valuation skills and learn how transaction models answer specific deal questions.
- Private equity: practise acquisition financing, debt repayment and investment returns.
- Corporate finance: focus on operating forecasts, budgets, cash planning and business decisions.
- Startups: focus on revenue drivers, hiring, cash burn, runway and funding requirements.
- Real estate: learn property-level income, operating costs, financing and exit assumptions.
Advanced automation, VBA, R and simulation methods can come later when a task calls for them. They are not prerequisites for your first working model.
Explain your work and get it reviewed
Prepare a short explanation of the business, the question, your sources, the important assumptions and the result. Include what could make your conclusion change. A reviewer should be able to follow your reasoning without searching through every worksheet.
Practice: Ask another person to change an input, follow a calculation and find the source of a historical figure. Use their questions to improve the workbook. If you work alone, put it aside and review it again from the perspective of someone seeing it for the first time.
You are ready to move on when: you can explain the model without reading out the spreadsheet, and you can acknowledge what it does not establish.
Build a portfolio of work you understand
Keep a small selection of completed cases with a short brief, the source data, your workbook and a summary of your conclusions. Show how you corrected errors and improved an earlier version.
Use your own work or material you have permission to share. When practising from someone else’s template, credit it and follow its terms. Rebuilding an example helps you learn; presenting another person’s work as your own does not demonstrate your skills.
How to choose a financial modeling course
Compare the work you will actually complete. Look for clear prerequisites, relevant cases, exercise files, explained solutions and a way to assess your understanding. Check the Excel version, access period, current price and any feedback arrangements before enrolling.
If you are considering BIWS, read the FinanceWalk BIWS review alongside the provider’s current course details. A course can give you structure, but you still need to build and check the models yourself.
Common questions
Can I learn financial modeling on my own?
Yes. Follow a sequence, build models rather than only watching demonstrations, and compare your work with explained solutions. Arrange feedback where possible.
How long does it take?
It depends on your accounting knowledge, Excel experience, practice time and target role. Measure progress by the tasks you can complete independently. Building one simple model is a different goal from handling an unfamiliar case under interview conditions.
Should I start with a template?
A template can show you how a model is organized. Trace its formulas and assumptions, then rebuild a small example yourself. If you cannot explain a calculation, identify what you need to learn before using the result.
Can AI help me learn?
You can use AI to suggest an explanation or a formula to investigate. Check the result against the source data and your expected calculation. Keep learning how the model works so you can identify errors in generated output.
Your first task
Choose one business, open its annual report and identify its three financial statements. Write down three things you understand and three questions you need to answer. Start there, then work through the steps in this guide.
