
Ever opened an Excel sheet and felt lost? Wondered how bankers forecast a company’s future in one file? Think 3 Statement Modeling is only for finance geniuses? It isn’t. Every analyst started at zero. No jargon, no fear. This guide shows beginners how to learn 3 Statement Modeling step by step. You’ll see what the model is, which skills help, and how to build your first one. Ready to begin? Follow the plan, and the numbers will start to make sense.
What Is 3 Statement Modeling and Why Do Bankers Use It?
3 Statement Modeling links a company’s income statement, balance sheet, and cash flow statement in one Excel file. Change one assumption, and all three statements update together.
This is called an integrated model. Bankers use it to see how choices affect profit, cash, and debt. Three kinds of choices matter:
- Operating choices, such as cutting prices
- Investing choices, such as buying a machine
- Financing choices, such as borrowing more
The same forecasts feed other models.
| Model | What it needs |
|---|---|
| DCF | Future cash flows to discount |
| M&A | Forecasts for both companies |
| LBO | A forecast that handles new debt |
Without strong 3 Statement Modeling, these models stand on weak ground.
How Do the Three Statements Link Together?
Links are the heart of the model. Keep these five in mind:
- Net income flows into retained earnings on the balance sheet.
- Depreciation reduces profit, then gets added back in cash flow.
- Changes in working capital affect the balance sheet and cash flow.
- Borrowing shows up as a financing inflow in cash flow.
- Ending cash on the cash flow statement becomes cash on the balance sheet.
If one link breaks, the balance sheet will not balance.
- 1Income statementShows: ProfitabilityLinks via Net income
- 2Cash-flow statementShows: Cash movementLinks via Ending cash
- 3Balance sheetShows: Assets and fundingLinks via Balance check
Which Skills Should You Build Before You Start?
- Accounting: Learn how the three statements connect.
- Excel: Learn keyboard shortcuts and basic formulas.
- Reading reports: Find data in annual reports and filings.
- Industry knowledge: Know what drives revenue and margins.
- Attention to detail: One wrong decimal can break a model.
Accounting matters most. Without it, you can copy a template but not fix it when it breaks. Beginners who learn 3 Statement Modeling should start with how the statements link.
How Do You Do 3 Statement Modeling Step by Step?
| Step | What to do | Beginner tip |
|---|---|---|
| 1. Collect data | Get three or more years of reports | Start with annual reports |
| 2. Enter history | Type in past income statement and balance sheet | Keep units consistent |
| 3. Forecast income | Start with revenue, then costs | Use growth rates and margins |
| 4. Forecast balance sheet | Link working capital and capex to revenue | Use roll-forward schedules |
| 5. Build cash flow | Pull every line from other statements | Never hardcode a number |
| 6. Add plugs | Revolver covers shortfalls; cash holds surplus | Test both cases |
| 7. Check balance | Assets must equal liabilities plus equity | Trace errors through cash flow first |
Cash flow deserves extra care. It only reconciles changes in the balance sheet. A hardcoded number there will break the balance.
Plugs can create a circular reference. Interest depends on debt, and debt depends on cash. Learn this after your first clean model.
Follow this order every time. Practice makes 3 Statement Modeling feel natural.
How Should You Format and Structure Your Model?
- Blue for inputs, black for formulas
- Green for links to other sheets
- Keep all inputs in one section
- Use the same units and decimals everywhere
- Never mix cell links with typed numbers
Clean format helps others check your work. Good habits show in every 3 Statement Modeling test.
Which Time Period Should Your Model Use?
| Period | Common use |
|---|---|
| Annual | DCF and LBO models |
| Quarterly | Equity research and M&A |
| Monthly | Restructuring and project finance |
| Weekly | 13-week cash flow in bankruptcy |
Beginners should start with annual models. They are simpler to build and check. Annual 3 Statement Modeling is the best place to begin.
What Mistakes Should Beginners Avoid?
- Hardcoding numbers in the cash flow statement
- Skipping accounting basics
- Using unrealistic growth and margin guesses
- Ignoring circular references in interest
- Forgetting to test scenarios
Test your model with a base case and a weak case. A sensitivity table shows how one input moves earnings per share. Strong 3 Statement Modeling always includes these checks.
Why Does This Skill Matter for an Investment Banking Career?
- Hiring often includes a modeling test or walk-through.
- Juniors are expected to build and check models.
- DCF, M&A, and LBO work all rest on these forecasts.
Many new bankers also build models for industries they barely know. Learn to find industry facts fast.
How Can a Structured Course Speed Up Your Learning?
Self-study works, but a plan saves time. Merit Shot’s Investment Banking program suits beginners, as it needs no coding background. Classes run on weekends and evenings, and every session is recorded. Learners get mentorship from industry professionals, mock interviews, and placement support. Small batches help doubts get cleared faster.
That flexibility helps you practise the 3 Statement Model alongside a job.
How Can You Practise 3 Statement Modeling Every Week?
| Week | Focus |
|---|---|
| 1 | Accounting links and Excel shortcuts |
| 2 | Historical statements for one company |
| 3 | Income statement forecast |
| 4 | Balance sheet and cash flow |
| 5 | Plugs, checks, and scenarios |
| 6 | Rebuild the model from scratch, timed |
Use a real public company. Keep each model clean. Rebuilding the same model from memory is the fastest way to master 3 Statement Modeling.
Conclusion
3 Statement Modeling is a skill you can learn in small steps. Start with accounting and Excel. Build a simple annual model. Check every link. Practise until you can rebuild it from memory. With steady effort, this skill becomes the base for DCF, M&A, and LBO work.
Ready to start your investment banking journey? Explore the Investment Banking program at Merit Shot. Talk to a career advisor and pick the right plan for you.
Click here to explore our premier investment banking course and accelerate your high-paying finance career today. Follow us on Instagram and Facebook to stay updated with more investment banking career advice, industry insights, and professional finance tips.
FAQs
1. How long does it take to learn 3 Statement Modeling?
Many beginners build a basic model in a few weeks with regular practice. Mastery takes more projects and feedback.
2. Can a non-finance student learn financial modeling?
Yes. Start with accounting basics and Excel. Practise on one company at a time.
3. Which Excel skills do I need for 3 Statement Modeling?
Learn cell references, SUM and IF formulas, and keyboard shortcuts. Add lookup functions later.
4. Is 3 Statement Modeling asked in investment banking interviews?
Often, yes. Interviews may include a modeling test or a walk-through of how the statements link.
5. Do I need Bloomberg or Capital IQ to start?
No. Annual reports and Excel are enough for your first models. Data tools help later.




