Investment Banking Analyst — Competency Roadmap

You'll learn

• Accrual Accounting — revenue and expense recognition independent of cash movement
• Revenue Recognition (ASC 606 / IFRS 15) — contract obligations and delivery criteria
• COGS vs OPEX — direct production costs versus overhead operating expenditures
• Operating Working Capital — operating current assets minus operating current liabilities

How to work through it

1. 1Download the latest 10-K filing of an established public corporate (e.g., Apple or Microsoft)
2. 2Map the revenue-to-net-income bridge on the income statement
3. 3Identify current vs non-current assets, liabilities, and shareholder equity components
4. 4Trace cash flow generation across Operating, Investing, and Financing activities

You'll learn

• Tax Shield — tax savings generated by deductible expenses like depreciation and interest
• Non-Cash Charges — expenses that reduce earnings without an immediate cash outflow
• Retained Earnings Link — net income minus dividends flowing into balance sheet equity
• Net Working Capital Changes — cash impact of changes in accounts receivable, inventory, and payables

How to work through it

1. 1Set up a 3-column table: Income Statement, Cash Flow Statement, Balance Sheet
2. 2Walk through the pre-tax income impact, tax shield calculation, and net income change
3. 3Carry net income to cash from operations and adjust for non-cash expenses and working capital
4. 4Flow ending cash to the balance sheet and verify that Assets equal Liabilities plus Equity

You'll learn

• Standardised Financial Normalisation — stripping non-recurring items from recurring operating results
• Depreciation Waterfall — connecting fixed asset gross values, accumulated depreciation, and capex
• Balance Check Flags — logical formulas validating balance sheet integrity across periods

How to work through it

1. 1Create a clean Excel sheet with standardised headers and period dates
2. 2Input historical Income Statement data and compute operating profit metrics
3. 3Populate historical Balance Sheets and historical Cash Flow Statements
4. 4Implement balance checks to confirm total assets match total liabilities and equity

You'll learn

• Paste Special Operations — executing value, formula, and format pasting via Alt shortcuts
• Worksheet Navigation — toggling sheets and referencing multi-tab workbooks via keyboard
• Formula Auditing Shortcuts — tracing precedents (Ctrl+[) and dependents (Ctrl+]) rapidly

How to work through it

1. 1Disable gridline defaults and enable calculation iteration options
2. 2Drill cell selection and navigation: Ctrl+Arrow keys, Shift+Arrow, Ctrl+Shift+Arrow
3. 3Drill ribbon shortcuts via Alt keys for formatting, alignment, and paste special
4. 4Complete a timed cell manipulation drill covering data population and formatting

You'll learn

• Two-Way Lookups — dynamically pulling values across rows and columns via INDEX/MATCH
• Debt Repayment Logic — capping debt paydown at available cash flow using MIN/MAX functions
• Scenario Selectors — switching base, upside, and downside operating cases via a master index

How to work through it

1. 1Implement two-way table lookups using INDEX and MATCH
2. 2Construct scenario toggles using CHOOSE and OFFSET based on a single case selector cell
3. 3Build cash sweep debt repayment logic using MIN, MAX, and logical booleans
4. 4Format error handling with IFERROR to prevent broken outputs across dashboards

You'll learn

• Universal Font Colour Conventions — Blue (hardcode), Black (formula), Green (cross-link), Red (warning)
• Custom Number Formatting Syntax — controlling positive, negative, zero, and text display formats
• Model Auditability — structural rules that allow external reviewers to inspect calculations instantly

How to work through it

1. 1Set custom number formatting for currencies ($#,##0;($#,##0);"-"), percentages, and multiples
2. 2Apply font colour standards across inputs, calculations, and cross-sheet references
3. 3Establish clean header hierarchies, column sizing, and print area borders
4. 4Audit the entire sheet using Go To Special (F5) to verify colour compliance

You'll learn

• Working Capital Drivers — converting cash conversion cycle days into balance sheet values
• Fixed vs Variable Cost Forecasting — structuring operating expenses as a function of volume or revenue
• Segmented Revenue Drivers — modelling top-line growth across geography or product lines

How to work through it

1. 1Calculate historical revenue growth trends and operating margin averages
2. 2Build working capital schedules using DSO, DIO, and DPO turnover drivers
3. 3Project future Accounts Receivable, Inventory, and Accounts Payable based on projected revenue and COGS
4. 4Link calculated operational projections to the future Income Statement rows

You'll learn

• Circular Reference Loops — managing interest expense driven by ending cash while ending cash is driven by interest
• Debt Amortisation vs Cash Sweeps — mandatory fixed repayments versus surplus cash paydowns
• Capital Expenditure Ratios — aligning CapEx forecasting with depreciation and revenue expansion

How to work through it

1. 1Build fixed asset roll-forward: Beginning PP&E + CapEx - Depreciation = Ending PP&E
2. 2Construct a multi-tier debt schedule with opening balance, repayments, additions, and closing balance
3. 3Calculate interest expense on average debt balances using an active circular calculation loop
4. 4Implement a revolver toggle that automatically draws liquidity when cash drops below the minimum balance

You'll learn

• Cash Flow Integration — linking operating, investing, and financing outputs into cash flow balances
• Elimination of Plugs — ensuring mathematical equality between assets and liabilities via organic balance links
• Scenario Switch Integration — embedding live case switches that update all three statements concurrently

How to work through it

1. 1Link net income from the income statement to the top of the cash flow statement
2. 2Feed cash flow financing and investing line items directly into corresponding balance sheet line items
3. 3Route ending cash from the cash flow statement to the balance sheet asset section
4. 4Stress-test the model by altering revenue growth assumptions to ensure no formula breaks

You'll learn

• Treasury Stock Method (TSM) — calculating dilution from options, RSUs, and convertible instruments
• Enterprise Value Core Bridge — the capital structure-neutral measure of a firm's core operational value
• Minority Interest / Non-Controlling Interest — accounting rationale for adding subsidiary equity into EV

How to work through it

1. 1Extract basic shares outstanding and in-the-money options/warrants from 10-K notes
2. 2Apply the Treasury Stock Method (TSM) to determine net new shares and diluted share count
3. 3Identify non-operating assets (excess cash, equity investments) and non-equity claims (debt, minority interest)
4. 4Compute Enterprise Value using EV = Equity Value + Debt + Preferred + Non-Controlling Interests - Cash

You'll learn

• EBITDA Normalisation — adjusting reported numbers for one-off charges to reflect underlying run-rate cash generation
• Operating Multiples vs Equity Multiples — when to match EV multiples with pre-debt metrics and P/E with net income
• Peer Group Selection Criteria — evaluating margins, growth profiles, and risk characteristics

How to work through it

1. 1Define a peer group based on geography, industry, business model, and financial size
2. 2Scrub historical filings to adjust EBITDA for restructurings, litigation, and stock compensation
3. 3Calculate EV/Revenue, EV/EBITDA, P/E, and PEG multiples across all peer companies
4. 4Apply peer group median multiples to the target company's metrics to establish an implied valuation range

You'll learn

• Control Premium — the additional price paid above market equity value to secure 100% operational control
• LTM Metrics at Deal Announcement — anchoring multiples on historical trailing data available on the deal date
• Strategic vs Financial Sponsor Pricing — variations in valuation multiples between corporate buyers and PE funds

How to work through it

1. 1Screen for relevant industry M&A transactions over the prior 3-5 years
2. 2Extract transaction values, enterprise values, and LTM EBITDA from deal press releases and proxy statements
3. 3Compute EV/LTM EBITDA and EV/LTM Sales multiples at the time of announcement
4. 4Calculate unaffected share price premiums (1-day and 30-day premiums) paid by acquirers

You'll learn

• Free Cash Flow to Firm (FCFF) — the capital structure-neutral cash stream available to debt and equity holders
• NOPAT / EBIAT — operating earnings adjusted for cash taxes without factoring in debt tax shields
• Capital Reinvestment Rate — net balance of CapEx and working capital required to sustain projected growth

How to work through it

1. 1Calculate Net Operating Profit After Tax (NOPAT) using NOPAT = EBIT * (1 - Tax Rate)
2. 2Add back non-cash Depreciation and Amortisation from supporting schedules
3. 3Subtract Capital Expenditures and adjust for cash consumed or freed by Net Working Capital
4. 4Verify that financing items (interest expense, debt repayments) are excluded from the cash flow stream

You'll learn

• Capital Asset Pricing Model (CAPM) — formal framework linking systematic market risk (Beta) to expected equity returns
• Beta Un-levering and Re-levering — isolating fundamental operating business risk from financial leverage risk
• After-Tax Cost of Debt — factoring the tax-deductibility of interest into corporate financing costs

How to work through it

1. 1Identify the appropriate 10-Year Government Bond yield as the risk-free rate
2. 2Collect raw equity betas for peer companies and un-lever them using their debt-to-equity ratios
3. 3Calculate the median unlevered asset beta and re-lever it to the target firm's capital structure
4. 4Calculate Cost of Equity via CAPM: Ke = Rf + Beta * ERP, and calculate after-tax Cost of Debt
5. 5Blend components using market value capital weights to determine the final WACC

You'll learn

• Mid-Year Convention — adjusting discounting to assume cash flows arrive evenly across the year rather than year-end
• Gordon Growth Implied Multiples — reconciling perpetual growth assumptions against long-term GDP growth constraints
• Excel What-If Data Tables — using TABLE() functions to automate multi-variable valuation output matrices

How to work through it

1. 1Calculate Terminal Value under the Gordon Growth Method: TV = [UFCF * (1 + g)] / (WACC - g)
2. 2Calculate Terminal Value under the Exit Multiple Method: TV = Final Year EBITDA * Target EV/EBITDA Multiple
3. 3Discount projected cash flows and Terminal Value to present value using WACC and mid-year convention
4. 4Deduct net debt to reach Equity Value and divide by diluted shares to output implied price per share
5. 5Set up dynamic Excel Data Tables (Data > What-If Analysis) across WACC and growth/multiple ranges

You'll learn

• Seniority and Security Hierarchy — order of capital claims during corporate liquidation and restructuring
• Incurrence vs Maintenance Covenants — restrictions on taking specific actions versus continuous financial metric tests
• Credit Ratings Framework — qualitative and quantitative thresholds defining investment grade vs speculative grade

How to work through it

1. 1Map the corporate debt hierarchy from senior secured bank debt down to subordinated unsecured notes
2. 2Analyse key leverage and coverage credit ratios: Debt/EBITDA, Net Debt/EBITDA, EBITDA/Interest
3. 3Review typical debt covenants: maintenance covenants versus incurrence covenants
4. 4Write a 1-page debt financing recommendation for a hypothetical acquisition scenario

You'll learn

• Primary vs Secondary Capital — issuing new shares to fund corporate cash versus selling existing shareholder stakes
• Overallotment / Greenshoe Option — price stabilisation mechanism granting underwriters the right to sell extra shares
• Dual-Track Process — simultaneously running an M&A sale and an IPO process to maximise seller valuation and deal certainty

How to work through it

1. 1Map the timeline of an IPO from bake-off and prospectus drafting to the investor roadshow and pricing
2. 2Calculate post-money valuation, gross proceeds, primary dilution, and secondary proceeds in equity offerings
3. 3Examine the role of underwriting syndicates, stabilisation agents, and overallotment (greenshoe) options
4. 4Summarise the strategic trade-offs between an IPO, a direct listing, and a dual-track M&A sale process

You'll learn

• Sources & Uses Table — accounting schedule detailing where deal capital originates and how it is deployed
• Premium Over Unaffected Share Price — establishing the acquisition consideration required to secure shareholder approval
• Transaction & Financing Fees — capitalise vs expense accounting treatment for M&A and debt issuance costs

How to work through it

1. 1Calculate fully diluted target equity value and total acquisition enterprise value based on offer premium
2. 2Set up the Uses table: purchase of target equity, refinancing of target existing debt, and advisory/financing fees
3. 3Set up the Sources table: acquirer new senior debt, new equity issuance, and balance sheet cash deployed
4. 4Verify that Total Sources equals Total Uses identically

You'll learn

• Goodwill Creation — excess purchase price paid over the fair market value of net identifiable assets acquired
• Deferred Tax Liabilities in M&A — tax consequences of asset write-ups that do not have tax-basis step-ups
• Incremental Amortisation — ongoing income statement expense from amortising newly written-up intangible assets

How to work through it

1. 1Determine the excess purchase price over historical target book value of equity
2. 2Allocate excess value to identifiable intangible assets (patents, customer lists) and write up fixed assets
3. 3Calculate Deferred Tax Liabilities (DTL) arising from asset fair value adjustments
4. 4Assign the remaining unallocated purchase price to newly created Goodwill

You'll learn

• EPS Accretion / Dilution — whether post-transaction earnings per share are higher (accretive) or lower (dilutive)
• Cost vs Revenue Synergies — hard cost reductions (headcount, systems) versus speculative cross-selling revenue upside
• Break-Even Synergy Analysis — calculating the exact synergy level required to avoid diluting acquirer earnings

How to work through it

1. 1Combine acquirer and target standalone revenue and operating income forecasts
2. 2Incorporate pre-tax cost synergies and revenue synergies alongside phase-in integration costs
3. 3Adjust pro-forma net income for new debt interest, foregone interest on cash, and incremental D&A
4. 4Calculate new total pro-forma shares outstanding based on stock consideration issued
5. 5Compute pro-forma EPS, determine dollar and percentage accretion/dilution, and construct synergy sensitivity tables

You'll learn

• Internal Rate of Return (IRR) — the annualised compounded return generated on the sponsor's invested equity
• Multiple on Invested Capital (MoIC) / Cash-on-Cash — total cash returned divided by initial cash equity invested
• Paper LBO Method — streamlined pen-and-paper LBO math used to test leverage and return mechanics during interviews

How to work through it

1. 1Identify the characteristics of an ideal LBO candidate: stable cash flows, low capex, strong asset base, operational upside
2. 2Study the three primary value creation levers: deleveraging, EBITDA growth, and multiple expansion
3. 3Memorise mathematical shortcuts to approximate IRR from MoIC across standard 3, 4, and 5-year hold periods
4. 4Complete 5 timed mental/paper LBO problem sets calculating required exit multiples and ending IRRs

You'll learn

• Debt Cash Sweep — covenant mechanism routing 100% of residual free cash flow to accelerate debt retirement
• Subordinated / Mezzanine Debt — high-yield, flexible debt tranches featuring PIK (Payment-in-Kind) interest options
• Management Equity Rollover — aligning management incentives by having founders roll existing equity into the new entity

How to work through it

1. 1Set up Entry Multiple assumptions and calculate initial Sponsor Equity contribution via Sources & Uses
2. 2Build dynamic 5-year operating forecast income statement and cash flow generation
3. 3Construct a multi-tranche debt waterfall with mandatory term loan amortisation and dynamic cash sweep
4. 4Model management incentive equity options and fee structures

You'll learn

• Returns Waterfall — sequential order of cash distribution among senior debt, preferred equity, and common equity holders
• Multiple Arbitrage — generating investment returns when the exit EV/EBITDA multiple exceeds the entry purchase multiple
• Two-Way Sensitivity Analysis in LBOs — stress-testing sponsor returns against adverse macroeconomic and operating conditions

How to work through it

1. 1Calculate Exit Enterprise Value using varied EV/EBITDA exit multiples
2. 2Deduct remaining debt balances and add ending cash to determine Total Ending Equity Value
3. 3Distribute proceeds between Sponsor Equity and Management Incentive Option pools
4. 4Compute net IRR and MoIC using Excel XIRR and formulaic return functions
5. 5Construct two-way data tables varying Entry Multiple vs Exit Multiple and Leverage Levels vs IRR

You'll learn

• Quick Access Toolbar (QAT) Optimisation — placing high-frequency commands within Alt+Number reach
• Grid and Guide Systems — establishing uniform slide borders and component spacing
• Lead-In Action Titles — structuring slide headers as complete, declarative analytical takeaways rather than passive labels

How to work through it

1. 1Customise the Quick Access Toolbar with alignment, distribution, and grouping commands
2. 2Master alignment shortcuts: Align Left, Center, Right, Top, Middle, Bottom, Distribute Horizontally/Vertically
3. 3Implement institutional slide grids, margin guidelines, and standardized color palettes
4. 4Format data tables in PowerPoint to match Excel institutional standards identically

You'll learn

• Valuation Football Field Chart — bar chart synthesising diverse valuation methodologies into an implied valuation range
• Executive Profiling Architecture — organising company operational, financial, and strategic data into dense, scannable layouts
• Transaction Structuring Diagrams — visually mapping entity relationships, cash movements, and post-closing ownership

How to work through it

1. 1Build a structured 1-page Company Profile featuring key metrics, business description, and shareholder breakdown
2. 2Construct an Industry Landscape slide comparing competitors across product capabilities and financial size
3. 3Build a Valuation Football Field chart visually plotting valuation ranges across Comps, Precedents, DCF, and 52-week highs
4. 4Draft a Strategic Rationale slide illustrating transaction synergies and market expansion opportunities

You'll learn

• Credit Spread Dynamics — how high-yield and investment-grade spreads reflect macroeconomic risk appetite
• Cross-Border M&A Mechanics — regulatory scrutiny (CFIUS, CMA, EC), currency risk, and geopolitical headwinds
• Market-Moving Macro Data — Non-Farm Payrolls, CPI/inflation prints, and central bank forward guidance

How to work through it

1. 1Read the morning global market wrap covering S&P 500, FTSE 100, 10-Yr Treasury yields, and commodity prices
2. 2Track active M&A transactions: acquirer, target, deal value, premium paid, and financing structure
3. 3Analyse central bank interest rate decisions and their direct impact on leveraged loan markets and M&A activity
4. 4Maintain a deal journal logging one notable transaction per week with valuation and strategic commentary

You'll learn

• SEC Form DEFM14A / UK Scheme Documents — definitive proxy statements containing target background and fairness opinions
• Fairness Opinions — third-party bank analyses validating whether transaction financial terms are fair to shareholders
• Integration and Execution Risk Analysis — identifying antitrust hurdles, cultural clash, and supply chain frictions

How to work through it

1. 1Select an active or recently closed major transaction in a sector of personal interest
2. 2Extract background and rationale from merger filings (SEC DEFM14A or UK Scheme of Arrangement documents)
3. 3Analyse the valuation multiples paid relative to historical trading comps and precedent transactions
4. 4Detail the financing structure (cash, debt tranches, equity) and assess pro-forma leverage and synergy execution risks
5. 5Record a 10-minute presentation walking through the deal thesis as if presenting to an investment committee

You'll learn

• US vs UK Recruitment Divergence — informational interview cold-call pipelines (US) versus online screening tests and ACs (UK)
• Spring Insight Weeks — UK/EMEA first-year pipeline programs that fast-track directly to penultimate-year summer internships
• Rolling Admissions Dynamics — how early submissions gain significant advantages in European hiring systems

How to work through it

1. 1Map the US recruiting calendar: sophomore/junior spring accelerated timeline and Superday schedules
2. 2Map the UK/EMEA recruiting calendar: Autumn deadlines, Spring Insight Weeks, rolling applications, and Assessment Centres
3. 3Identify alternative entry routes: Off-Cycle internships, Boutique regional internships, and Lateral analyst hiring
4. 4Compile target firm lists categorised into Bulge Bracket, Elite Boutique, and Middle Market tiers

You'll learn

• Action-Result Bullet Construction — leading with strong finance verbs and anchoring outcomes with hard numerical metrics
• Single-Page Finance Standard — strict 1-page constraint with 0.5-inch margins and uniform font sizing
• Applicant Tracking System (ATS) Formatting — structuring headers and text to ensure error-free automated parsing

How to work through it

1. 1Format the CV into standard sections: Education, Professional Experience, Leadership & Projects, Skills & Interests
2. 2Write accomplishment bullets using the framework: Action Verb + Context/Project + Quantified Result
3. 3Incorporate financial modelling projects and portfolio deal teardowns into the Experience/Projects section
4. 4Align your LinkedIn profile with professional headshot, concise summary, and verified financial modelling credentials

You'll learn

• Informational Call Etiquette — steering conversations professionally without asking directly for a job on the initial call
• Warm Referral Mechanics — positioning an informational relationship so the banker forwards your CV to recruiting
• Networking CRM Architecture — tracking outreach status, follow-up cadences, and personal conversational notes

How to work through it

1. 1Identify university alumni and industry professionals at target banks using LinkedIn search
2. 2Draft concise, professional 100-word cold email templates requesting a 15-minute introductory call
3. 3Prepare a structured question framework for calls focusing on group culture, deal flow, and career advice
4. 4Maintain a CRM tracker logging contact details, conversation notes, and scheduled follow-ups every 6-8 weeks

You'll learn

• Numerical Reasoning Test Speed — rapid mental arithmetic and chart data extraction under tight time constraints
• HireVue Automated Assessment Criteria — eye contact, delivery pace, structured keyword usage, and confidence
• Situational Judgement Alignment — balancing client priorities, compliance, and team collaboration in scenario tests

How to work through it

1. 1Practise timed numerical reasoning drills focusing on percentages, currency conversions, and financial chart reading
2. 2Study bank core competency values to align with Situational Judgement Test scoring metrics
3. 3Practise answering standard 30-second preparation / 90-second response HireVue prompts with clear eye contact
4. 4Review video recordings to eliminate filler words, adjust audio/lighting setup, and ensure crisp pacing

You'll learn

• STAR Method — structuring stories through Situation, Task, Action, and Quantified Result
• The 90-Second Resume Pitch — framing past education and work experience as a logical progression toward banking
• 'Airport Test' Dynamic — demonstrating humility, intellectual curiosity, and conversational ease under pressure

How to work through it

1. 1Craft a 90-second chronological resume pitch connecting background, inflection points, and finance passion
2. 2Draft authentic, specific answers for 'Why Banking?' and 'Why This Firm?' referencing specific deals and culture
3. 3Map 6 versatile personal experiences into the STAR framework (Situation, Task, Action, Result) to cover diverse behavioral prompts
4. 4Record and audit your delivery to ensure answers sound conversational rather than robotic

You'll learn

• IFRS 16 / ASC 842 Lease Accounting — capitalizing operating leases onto the balance sheet and its effect on EBITDA and EV
• Advanced Valuation Nuances — handling non-operating assets, equity investments, and pension deficits in EV bridges
• Rapid Technical Articulation — explaining mathematical financial models concisely without pen and paper

How to work through it

1. 1Drill advanced accounting links: impairment charges, debt refinancing, operating lease capitalization (IFRS 16/ASC 842)
2. 2Drill valuation nuances: un-levering beta with net debt vs total debt, negative enterprise value, terminal growth constraints
3. 3Drill transaction questions: EPS accretion drivers, LBO debt capacity limits, equity purchase price adjustments
4. 4Conduct timed mock technical interviews with a peer or mentor and review recorded answers

You'll learn

• Assessment Centre Group Dynamics — demonstrating leadership through consensus-building without dominating peers
• Time-Constrained Information Synthesis — identifying crucial valuation data quickly within dense briefing documents
• Executive Case Presentation — delivering structured transaction recommendations under direct cross-examination

How to work through it

1. 1Review a simulated 20-page AC case study briefing pack containing financial profiles of three acquisition targets
2. 2Evaluate financial metrics, strategic fit, regulatory hurdles, and valuation multiples under a 60-minute time constraint
3. 3Prepare a structured 5-minute presentation arguing for the optimal acquisition target
4. 4Practise positive group exercise dynamics: active listening, building on others' ideas, and collaborative time management