Financial modeling is one of the most important skills you need to develop as an investment banking candidate. It shows up in interviews, in internship performance reviews, and throughout your career as an analyst and beyond. But there’s an enormous amount of confusion about what financial modeling actually means in the context of IB, what banks actually test for in interviews, and the most efficient way to learn it.
I’ve coached hundreds of students through the IB recruiting process, and financial modeling is consistently one of the areas where students either get ahead — or fall behind. This guide will give you a clear, practical framework for how to learn financial modeling and what to actually prepare for.
What Is Financial Modeling in Investment Banking?
Financial modeling in IB refers to building quantitative representations of a company’s financial performance and value. The output of a model is typically a range of value for a company or asset — which is what a banker uses to advise clients on deal pricing, financing structure, and strategic alternatives.
The core models you need to know as an IB analyst:
- Three-Statement Model: The foundation of everything. Links the income statement, balance sheet, and cash flow statement in a dynamic, integrated model.
- Discounted Cash Flow (DCF) Model: Values a company based on the present value of its projected future free cash flows.
- Comparable Company Analysis (Comps): Values a company by benchmarking against trading multiples of similar public companies.
- Precedent Transaction Analysis: Values a company using multiples from prior M&A transactions in the same sector.
- Leveraged Buyout (LBO) Model: Analyzes the financial feasibility of a private equity acquisition using significant debt financing.
- Merger Model (Accretion/Dilution): Analyzes the EPS impact of a proposed merger or acquisition on the buyer.
Of these, the three-statement model and DCF are the most fundamental. The LBO model and merger model are tested at the more advanced end of analyst interviews — mostly for senior summer analyst roles at top banks and in PE interviews.
What Banks Actually Test in Financial Modeling Interviews
Here’s something important to understand: most IB interviews do not require you to build a full financial model from scratch in the room. The modeling tests that people worry about are primarily a feature of:
- Private equity interviews (where case studies often include building an LBO model)
- Some elite boutique superdays (Evercore, Centerview, PJT Partners)
- Certain off-cycle IB roles
What bulge bracket IB interviews typically test for is conceptual modeling knowledge — meaning, can you explain how to build a DCF, what goes into an LBO model, and how the three statements connect? You’re expected to talk through models intelligently, not necessarily build one in front of them.
That said, you absolutely should be able to build these models from scratch. For two reasons:
- If you understand how to actually build the model, the conceptual questions become trivially easy to answer
- Once you’re in the seat as an intern or analyst, you’ll be expected to build models quickly and accurately
The Three-Statement Model: Start Here
The three-statement model is the bedrock of all IB financial modeling. If you can’t build a clean, properly linked three-statement model, nothing else will work right. Here’s what you need to master:
Income Statement
Revenue down through EBIT (operating income). Know where depreciation & amortization live on the income statement. Understand the difference between EBIT and EBITDA. Know how taxes flow through to net income.
Balance Sheet
Current assets and liabilities, long-term assets (including PP&E and goodwill from M&A), and the equity section. The balance sheet must always balance — assets = liabilities + equity. This sounds obvious but students get tripped up on it constantly.
Cash Flow Statement
Cash from operations (starting from net income), cash from investing (capex, acquisitions), and cash from financing (debt issuance/repayment, equity issuance). The ending cash balance on the CFS feeds back into the balance sheet — this is the key link students often get wrong.
The Key Links
In an interview, you’ll almost certainly be asked: “How do the three financial statements link together?” The answer needs to be crisp and complete:
- Net income from the income statement is the starting point for the cash flow statement (indirect method)
- Ending cash from the cash flow statement flows to cash on the balance sheet
- Net income flows to retained earnings in the equity section of the balance sheet
- Depreciation is added back on the CFS and reduces PP&E on the balance sheet
Get this answer completely fluent. It’s asked in nearly every serious IB interview. Our free technical cheatsheet has a clear walkthrough of this linkage that you can memorize and internalize.
How to Build a DCF Model
The DCF is the second most fundamental model in IB. In an interview, you should be able to walk through the full DCF methodology in 2-3 minutes — not at a surface level, but with genuine depth.
The five steps of a DCF:
- Project Free Cash Flows: Forecast revenue, EBITDA, EBIT, taxes, D&A, capex, and changes in working capital for a 5-10 year projection period. Unlevered free cash flow (UFCF) = EBIT x (1 – tax rate) + D&A – capex – changes in working capital.
- Calculate the Discount Rate (WACC): Weighted average cost of capital, which blends the cost of equity (using CAPM) and after-tax cost of debt, weighted by capital structure.
- Calculate the Terminal Value: Either using the Gordon Growth Model (perpetuity growth rate approach) or the exit multiple approach (applying an EV/EBITDA multiple to year 10 EBITDA).
- Discount Cash Flows and Terminal Value to Present Value: Apply the WACC as the discount rate to each year’s UFCF and to the terminal value.
- Calculate Enterprise Value and Equity Value: Sum the PV of FCFs and PV of terminal value to get enterprise value, then subtract net debt to get equity value, then divide by shares outstanding for implied share price.
Be prepared to discuss the limitations of a DCF (highly sensitive to terminal value and discount rate assumptions, difficult to apply to cyclical or pre-revenue companies) and when you’d use a DCF versus comps.
LBO Modeling: The Key to PE Recruiting
The leveraged buyout model is the most complex of the standard IB models, and it’s the one tested most rigorously in private equity interviews. Even if you’re only targeting IB right now, understanding LBO logic will make you a significantly stronger analyst candidate.
The core question an LBO model answers: given a purchase price, a debt/equity financing structure, and a set of operating assumptions, what return (IRR) does a PE firm generate at exit?
Key components of an LBO model:
- Sources and Uses: How the deal is financed (equity from the PE fund, various tranches of debt) and what the money is used for (purchase price, fees, refinancing existing debt)
- Debt Schedule: Tracks each tranche of debt, mandatory amortization, cash sweeps, and ending balances
- Operating Model: Projects revenue, EBITDA, capex, and free cash flow over the hold period (typically 5 years)
- Exit Analysis: Assumes an exit multiple and calculates enterprise value at exit, net debt at exit, equity value to the PE firm, and IRR/MOIC
The rule of thumb for LBO returns: a transaction generally needs to generate a 20%+ IRR and 2x+ MOIC to be attractive to most PE funds.
The Best Ways to Learn Financial Modeling
Now that you know what to learn, here’s how to actually learn it efficiently:
Build Models From Scratch
The single best way to learn financial modeling is to build models from scratch using public company filings. Download 10-K reports from the SEC for a company you’re interested in and try to build a three-statement model. You’ll get stuck. That’s the point — struggling through the problem is how you truly learn.
Use Quality Online Courses
Wall Street Prep and Breaking Into Wall Street (BIWS) are the two most widely respected financial modeling courses for IB prep. They’re thorough, taught by practitioners, and include actual Excel files you can work through. These are worth the investment if you’re serious about modeling skills.
Practice Talking Through Models Out Loud
Being able to build a model is different from being able to articulate how you built it in an interview. Practice explaining your models — DCF walkthrough, three-statement linkages, LBO mechanics — out loud, without notes, until it’s completely fluent. Do mock interviews with friends, classmates, or a coach who can give you real feedback.
Use Our Free Resources
We’ve built out a significant set of free preparation materials for IB candidates at every level. Visit our free resources page to access practice questions, technical walkthroughs, and other content. And if you want to see the kind of results structured preparation produces, check our track record.
Common Financial Modeling Interview Questions
Here are the questions you should absolutely have cold before any serious IB interview:
- “Walk me through a DCF.” (Expect a full 2-3 minute answer)
- “How do the three financial statements link?”
- “If depreciation increases by $10, what happens to the three financial statements?”
- “What is WACC and how do you calculate it?”
- “Walk me through an LBO at a high level.”
- “What is free cash flow and how do you calculate it?”
- “When would you use a DCF versus a comps analysis?”
- “What is the terminal value in a DCF and why does it matter so much?”
Want Personalized Investment Banking Coaching?
Wall Street Mastermind has helped thousands of students land offers at Goldman Sachs, Morgan Stanley, JPMorgan, and every top bank. If you want personalized coaching to break into IB, apply here to learn more about how we can help you.
