Every big business decision, whether it's an IPO, an acquisition, a loan or an investment, starts with someone who can read a company's numbers and explain what the business is worth. That skill sits under every analyst role in investment banking, equity research, FP&A, corporate finance and transaction advisory. This course takes you from complete beginner to job-ready analyst, step by step, using one company from the first lecture to the last: Saffron Foods Ltd, a fictional packaged-foods company from Pune. Everything is set in Indian context: Ind AS, the Companies Act, SEBI rules, NSE and BSE.

What you'll learn

• Module 1 · Finance & Accounting Foundations: the three financial statements, how they link, and how to read an Indian annual report.
• Module 2 · Financial Statement Analysis & Ratios: common-size and trend analysis, profitability, liquidity, efficiency, DuPont, cash flow quality, red flags and peer benchmarking.
• Module 3 · Financial Modelling in Excel: a complete three-statement model, built and balanced step by step, with scenarios and sensitivity tables.
• Module 4 · Valuation: enterprise vs equity value, FCFF, WACC for an Indian company, DCF, trading comparables, precedent transactions and the football field.
• Module 5 · Investment Banking in Practice: M&A, merger models, IPOs under SEBI ICDR, QIPs and rights issues, LBOs, the deal process and pitch books.
• Module 6 · Finance Careers & Technical Interviews: career paths, resume and LinkedIn, accounting and valuation interview questions, modelling tests and a 30-day preparation plan.

Learn by doing. Every model is built on screen in Excel, formula by formula, with the professional colour code (blue inputs, black formulas, green links). Practice files come with the lessons: student versions to fill in and solution versions to check your work. You finish with two live projects: a full valuation of Saffron Foods with a one-page investment summary, and an M&A pitch book for a fictional acquisition.

Who this course is for. BCom, BBA, MBA, CA and CFA students, freshers, and working professionals in finance, accounts, consulting and FP&A who want analyst roles. No finance background is needed: we start from zero.

What you get: 45 lectures + 2 live projects (14 h 32 min) · 6 module notes PDFs · 6 self-assessment tasks with scoring rubrics · 33 practice files (Excel models, templates, checklists, question banks) · EduBenchers certificate at 80% completion · letter of recommendation at 100% completion.

Educational only, not investment advice. The course teaches skills; it does not recommend buying or selling any security.