The Complete Investment Banking Interview Course

Master Excel income and expense analysis with sumifs, precise criteria, and absolute and relative references. Flag budget exceedances in blue and summarize results using iferror and countifs.

Learn to compute market cap and net margins by sector, and identify stocks above 100 billion market cap using vlookup, averageifs, and countifs in Excel for investment banking cases.

Track accounting from journal to ledger to trial balance and three financial statements (income statement, balance sheet, cash flow). Contrast accrual with cash principles, including unearned revenue, accounts receivable.

Create a month-long set of financial statements: income statement, balance sheet, and cash flow. Record capital, investments, depreciation, revenue recognition, and expenses to show accruals across statements.

Explain the indirect cash flow method, starting from net income, adjusting for non-cash items like depreciation and non-operating gains, and linking balance-sheet changes to operating and investing cash flows.

Master ratio analysis as a benchmarking tool using vertical, cross sectional, and trend analyses to assess debt to equity and gross profit margin.

Analyze profitability ratios like gross margin, EBITDA margin, and net margin through vertical and common size analysis, highlighting material consumption as a percentage of sales and economies of scale.

Learn the logic of activity turnover ratios—receivables, inventory, and payables—and convert turnover into days to assess working capital. Compare performance with peers to gain context.

Learn how to compute return on assets and operating ROA using net income and EBIT over total assets, and preview interpreting these ratios with real company comparisons.

Analyze solvency ratios for long-term obligations, including debt-to-equity and debt-to-capital. Assess debt-to-assets and the interest coverage ratio with industry context.

Explore solvency and return ratios, including the financial leverage ratio and fixed charge coverage ratio, then master ROE, ROCE, ROA, and operating ROA with asset, equity, debt, and lease considerations.

Compare Birger and Asian paints through valuation and liquidity ratios, including price-to-earnings, price-to-book, price-to-sales, and current, quick, and cash ratios, plus notes on receivable and payable days.

Practice financial statement analysis by identifying and fixing balance sheet and cash flow errors, including checksum issues, working capital changes, retained earnings, and missing entries.

Learn to forecast financial statements from limited data by setting stable assumptions for average selling price (ASP), headcount, costs, and growth, then build and validate a multi-year model in Excel.

Explore valuation variants from present-value models (dividends, free cash flow to equity and firm) to multipliers (p/e, p/b, p/s, p/cf, ev/ebitda), including dividends, share repurchases, and Gordon growth terminal value.

Explore Gordon growth and dividend models, learn present-value valuation, terminal value, and how free cash flow to equity and free cash flow to firm inform enterprise and equity value.

Learn how to calculate the cost of capital and apply the weighted average cost of capital (WACC) to capital structure decisions, including debt versus equity and the tax shield.

Learn to practically calculate a stock's beta and the cost of equity using CAPM, including market risk premium, data gathering, and covariance-based beta estimation.

Craft a concise, recruiter-friendly resume using a simple format and resume builders, prioritizing reverse chronology, header hygiene, LinkedIn, and quantifiable achievements aligned with equity research.

Assess offer letters for illegal clauses such as non-compete; understand probation, notice, and buyout terms; and prepare an exit checklist covering assets, form 16, and experience letters.

Explore persistent systems and its IT services to the BFSI sector, using quarterly reports and financial statements to build revenue drivers and forecast a three-year outlook.

learn to build a DCF valuation for equities, set perpetual growth and WACC, forecast free cash flow to equity, compute terminal value, and derive intrinsic value and investment recommendations.