๐น Professional Training
Financial Modelling
Using Claude
Build investment banking style financial models faster with AI. From P&L analysis to DCF valuations, LBO models, and real Indian company case studies โ all with Claude.
MODULE 01 ยท 12 SLIDES
๐๏ธ Foundation
Claude basics ยท Prompt engineering ยท Finance workflow setup
MODULE 02 ยท 15 SLIDES
๐ Financial Statement Analysis
P&L ยท Balance Sheet ยท Cash Flow ยท Ratios ยท Red flags
MODULE 03 ยท 18 SLIDES
๐น DCF & Valuation Models
DCF ยท WACC ยท Terminal value ยท Comps ยท Precedent transactions
MODULE 04 ยท 13 SLIDES
๐ Excel + Claude Integration
Formula generation ยท 3-statement model ยท Dashboards ยท Debugging
MODULE 05 ยท 12 SLIDES
๐ฆ IB Style Models
LBO ยท M&A accretion/dilution ยท Pitch deck financials
MODULE 06 ยท 11 SLIDES
๐ญ Real Case Studies
Tata Motors ยท Infosys ยท D2C Startup unit economics
FINAL EXAM ยท 50 QUESTIONS
๐ Certification Exam
Pass 70% ยท Max 2 attempts ยท 1-year certificate validity
Slide 1 of 12
Use Next โ to navigate
Module โ Foundation
Why Claude for Financial Modelling?
Investment banking analysts spend 70% of their time on data gathering, formatting, and mechanical model-building โ work that Claude can do in minutes. The remaining 30% โ judgment, client insight, deal intuition โ is where you add irreplaceable value.
โก
Speed
Build a 5-year P&L projection in minutes instead of hours.
๐ฏ
Accuracy
Claude catches formula errors, logical inconsistencies, and missing line items.
๐
Structure
Build models that follow IB conventions consistently every time.
๐
Analysis
Ask "what are the 3 biggest risks in this balance sheet?" โ get a structured analysis in 30 seconds.
๐
Documentation
Auto-generate model assumptions documentation and investment memos.
๐
Iteration
Change an assumption and Claude walks through the full cascade instantly.
The Core Principle
Claude eliminates mechanical work so you can spend time on insight, interpretation, and client value.
Module โ Foundation
Claude Basics for Finance Professionals
Before using Claude for financial modelling, understand how it thinks, what it knows, and what it doesn't.
1
Claude knows financial concepts deeply
DCF, WACC, LBO, EV/EBITDA, working capital, free cash flow โ Claude knows these at CFA Level 2 depth. Use technical terms without defining them.
2
Claude does NOT have real-time market data
Claude's training has a cutoff. It cannot give today's share price or current ratios. Always provide current data in your prompt.
3
Claude reasons, not retrieves
Claude reasons from principles. If you ask "what should Infosys's WACC be?" โ provide the inputs (risk-free rate, beta, market premium).
4
Claude follows instructions precisely
Precision in instructions = precision in output. The more specific your prompt, the better the output.
Module โ Foundation
Setting Up Your Claude Workflow
The difference between mediocre and exceptional output from Claude is the workflow. Use this 4-step process consistently.
1
Set the context (Role + Task)
"You are a senior investment banking analyst. I need you to [specific task]. Use IB formatting conventions throughout."
2
Provide the data (Clean input)
Paste financial data clearly with labels: "FY2024 Revenue: โน45,230 Cr. EBITDA: โน12,450 Cr. Net Debt: โน8,200 Cr."
3
Specify the output format
"Output a table with years in columns and line items in rows. Include Revenue, EBITDA, EBIT, Net Profit, EPS, and growth rates. Show in โน Cr."
4
Validate and iterate
Review the output. If something looks wrong, ask Claude to explain: "Walk me through how you calculated FY27 EBITDA margin."
Module โ Foundation
Prompt Engineering for Finance
Generic prompts produce generic output. Financial modelling requires precise prompts that specify methodology, assumptions, format, and detail.
| โ Vague Prompt | โ Precise Prompt |
|---|---|
| "Analyse this P&L" | "Identify the top 3 cost items as % of revenue, calculate YoY change, and flag any that deteriorated by more than 200 bps" |
| "Build a DCF model" | "Build a 5-year DCF using 12% WACC, 4% terminal growth, FCF starting at โน2,000 Cr growing at 18% in Y1-3 and 12% Y4-5" |
| "What's the valuation?" | "Calculate equity value using DCF and cross-check with EV/EBITDA of 20x. Current share price is โน850. Is it overvalued?" |
Prompt Pattern Library
Build your own library of prompt patterns for tasks you do repeatedly. Save great prompts, reuse them, improve them. This is your competitive advantage.
Module โ Foundation
Finance Terminology Claude Understands
| Category | Terms Claude knows |
|---|---|
| Valuation | DCF, DDM, EV/EBITDA, P/E, P/B, EV/Revenue, PEG, Sum-of-parts, NAV, Gordon Growth Model, FCFF, FCFE |
| IB / Deal | LBO, M&A, accretion/dilution, synergies, control premium, deal premium, fairness opinion, hockey stick |
| P&L | EBITDA, EBIT, PAT, EPS, diluted EPS, gross margin, EBITDA margin, OCF, capex, working capital, D&A, COGS |
| Balance Sheet | Net debt, goodwill, intangibles, D/E ratio, interest coverage, current ratio, quick ratio, net debt/EBITDA |
| Risk Metrics | Beta, WACC, risk-free rate, equity risk premium, cost of debt, cost of equity, CAPM, terminal value |
| India-specific | SEBI, BSE, NSE, FII, DII, promoter holding, ESOP dilution, rights issue, QIP, bonus shares |
Module โ Foundation
๐ก The Finance Analyst's Edge
๐ก Insight Card โ Foundation
"The Finance Analyst's Edge"
A first-year analyst with strong Claude skills will outperform a third-year analyst without them on every mechanical task โ faster models, cleaner formatting, fewer errors.
But Claude cannot replace what makes a senior analyst valuable โ the ability to read between the lines of a management call, to sense that a company's margin story doesn't quite add up, to know which assumptions the buyside will push back on hardest.
The analysts who will dominate the next decade combine deep financial judgment with Claude as a force multiplier.
But Claude cannot replace what makes a senior analyst valuable โ the ability to read between the lines of a management call, to sense that a company's margin story doesn't quite add up, to know which assumptions the buyside will push back on hardest.
The analysts who will dominate the next decade combine deep financial judgment with Claude as a force multiplier.
Claude is your tireless junior analyst. You are the senior who knows what to build, why to build it, and whether the output makes business sense.
Module โ Foundation
Data Inputs & Sources
Claude's output quality is entirely dependent on the quality of data you provide.
1
Primary sources: Annual Reports & Quarterly Results
For Indian companies: BSE/NSE filings, investor presentations, earnings call transcripts. Copy key financial tables from annual reports directly into Claude.
2
Market data: You must provide it
Current stock price, market cap, shares outstanding, sector P/E, risk-free rate. Provide these explicitly: "Current price: โน1,450. Shares: 82 Cr. 10Y G-Sec: 7.1%."
3
Macro assumptions: Be explicit
GDP growth rate, sector growth rate, inflation, interest rate outlook. State them explicitly so Claude's assumptions are auditable.
Module โ Foundation
Output Formats & Validation
| Output Format | When to Use | How to Request |
|---|---|---|
| Markdown table | Quick analysis, emails | "Output as a markdown table with โน Cr units" |
| CSV format | Paste directly into Excel | "Output in CSV format so I can paste into Excel" |
| Written analysis | Investment memo | "Write a 200-word valuation commentary suitable for an investment memo" |
| Bullet summary | Exec summary | "Summarise the 5 key takeaways in bullet points for a CFO" |
โ
Always sanity-check the maths
Verify 2-3 key numbers manually. If EBITDA = Revenue ร Margin %, check that. Claude is accurate, but verification is non-negotiable for professional work.
Module โ Foundation
๐ก Garbage In, Genius Out
๐ก Insight Card โ Foundation
"Garbage In, Genius Out โ Is Still Garbage"
The most common mistake: giving Claude poor-quality data and blaming Claude when the output is wrong.
Claude will build whatever model you specify from whatever data you provide. Wrong base year revenue โ wrong 5-year projections, confidently presented.
The rule: Spend 80% of your time getting inputs right. The model-building is easy โ Claude handles that. Understanding the business, identifying the right assumptions, knowing what to normalise โ that's yours.
Before every session: audit your inputs. Is the revenue figure recurring or does it include one-time items? Is the FY2024 debt figure pre or post the recent rights issue?
Claude will build whatever model you specify from whatever data you provide. Wrong base year revenue โ wrong 5-year projections, confidently presented.
The rule: Spend 80% of your time getting inputs right. The model-building is easy โ Claude handles that. Understanding the business, identifying the right assumptions, knowing what to normalise โ that's yours.
Before every session: audit your inputs. Is the revenue figure recurring or does it include one-time items? Is the FY2024 debt figure pre or post the recent rights issue?
Claude executes brilliantly on whatever you give it. The quality of your model is determined by the quality of your inputs.
Module โ Foundation
Limitations & When Not to Rely on Claude
โ Real-time market data
Claude cannot access current stock prices, live interest rates, or today's news. Provide current market data yourself.
โ Company-specific recent events
Management changes, recent acquisitions, latest earnings โ Claude may not know if they occurred after its training cutoff. Provide key events as context.
โ Exact figures for small/unlisted companies
For large listed companies (Reliance, TCS, HDFC), Claude has extensive knowledge. For small-cap or unlisted companies, provide all financial data.
โ
Use Claude for
Model structure, formula logic, projection mechanics, sensitivity tables, ratio calculation, peer benchmarking (with data you provide), and investment memo drafting.
Module โ Foundation
Key Distinctions โ Foundation
Claude as Analyst vs Claude as Tool
Claude is not an autonomous analyst โ it needs briefing, data, and validation. Think tool, not team member.
Training Data vs Live Data
Claude knows companies from its training but cannot access real-time data. Always provide current prices, rates, and recent financial figures.
Mechanical Modelling vs Financial Judgment
Claude excels at mechanical tasks: projection tables, ratios, formatting. Financial judgment โ what growth rate is realistic โ is yours.
Precision Prompts vs Vague Prompts
Every vague word produces vague output. Specify: methodology, assumptions, format, units, and level of detail.
Module โ Foundation
Quiz โ Foundation (10 Questions)
Q1. What is the most important thing to provide Claude before asking it to build a financial model?
A. The company's stock price history
B. Clean, labelled financial data with explicit assumptions
C. The company's Wikipedia page
D. A description of the industry
Q2. Claude cannot access which of the following?
A. Knowledge of DCF methodology
B. Understanding of LBO mechanics
C. Today's stock price of Infosys
D. WACC calculation framework
Q3. The correct mental model for Claude in finance is:
A. A Bloomberg terminal replacement
B. A brilliant junior analyst who needs to be briefed with current data and clear instructions
C. An autonomous financial advisor
D. A database of current financial information
Slide 1 of 12
Slide 1 of 15
Use Next โ to navigate
Module โ Statement Analysis
Intro: Financial Statement Analysis
Every investment decision starts with the three financial statements. Claude can read this story faster than any analyst and spot inconsistencies that take humans hours to find.
๐
P&L Statement
Revenue โ EBITDA โ EBIT โ PBT โ PAT. How a business earns money and where it goes.
โ๏ธ
Balance Sheet
Assets = Liabilities + Equity. What the company owns, owes, and what belongs to shareholders.
๐ง
Cash Flow Statement
The truth behind the P&L โ because profits can be engineered, but cash cannot.
๐
Ratio Analysis
Profitability, liquidity, leverage, efficiency โ ratios tell you whether a business is healthy.
๐ฉ
Red Flag Detection
Diverging receivables, rising inventory, falling CFO โ Claude flags these instantly.
๐
Comparative Analysis
How does this company compare to peers? Claude generates comparison tables in seconds.
The Analyst's Hierarchy
Always analyse in this order: Cash Flow โ Balance Sheet โ P&L. Start where manipulation is hardest.
Module โ Statement Analysis
Reading P&L with Claude
The P&L is the most-read and most-misunderstood financial statement. Claude can extract key insights in minutes โ but you need to know what questions to ask.
P&L Analysis Prompt
Here is the P&L for Hindustan Unilever (โน Cr): Revenue: FY22 โน51,468 | FY23 โน58,154 | FY24 โน60,264 EBITDA: FY22 โน12,840 | FY23 โน14,085 | FY24 โน15,067 PAT: FY22 โน8,591 | FY23 โน9,962 | FY24 โน10,114 Analyse: (1) Gross margin trend, (2) EBITDA margin trend, (3) Revenue growth deceleration, (4) Key concerns for FY25E
1
EBITDA Margin = EBITDA / Revenue
The operational profitability indicator. Ask Claude: "Has the EBITDA margin expanded or contracted? What's driving the change?"
2
Revenue growth deceleration
HUL grew 13% in FY23 but only 3.6% in FY24 โ a significant slowdown. Ask Claude to flag this: "Calculate YoY revenue growth and flag deceleration above 500 bps."
Module โ Statement Analysis
Revenue Quality Analysis
Not all revenue is equal. โน1,000 Cr of recurring subscription revenue is worth far more than โน1,000 Cr of one-time project revenue.
1
Recurring vs one-time revenue
Ask: "Identify which revenue streams are recurring and which are one-time. What % of total revenue is recurring?"
2
Customer concentration risk
"Does the company disclose top 5 customer concentration? If the top customer is more than 20% of revenue, flag as a concentration risk."
3
Volume vs price growth
"Separate revenue growth into volume growth and price/mix. If revenue grew 15% but volume grew only 3%, the company is relying on price hikes โ which may not be sustainable."
Module โ Statement Analysis
๐ก Revenue Is Not Income
๐ก Insight Card โ P&L Analysis
"Revenue Is Not Income โ And Income Is Not Cash"
A company can show revenue without collecting cash, income without generating cash, and profits without having any money in the bank.
Revenue recognition โ Cash collection: If a company books โน100 Cr of revenue but the customer hasn't paid yet, that โน100 Cr sits in receivables.
Net income โ Cash flow: Depreciation is subtracted to calculate profit but is a non-cash charge. Capex spends real cash but doesn't hit the P&L immediately.
This is why seasoned analysts always start with the cash flow statement, not the P&L.
Revenue recognition โ Cash collection: If a company books โน100 Cr of revenue but the customer hasn't paid yet, that โน100 Cr sits in receivables.
Net income โ Cash flow: Depreciation is subtracted to calculate profit but is a non-cash charge. Capex spends real cash but doesn't hit the P&L immediately.
This is why seasoned analysts always start with the cash flow statement, not the P&L.
Always triangulate: does the P&L story match the cash flow statement? If profits are rising but OCF is falling, that divergence demands explanation.
Module โ Statement Analysis
Balance Sheet Deep Dive
The balance sheet reveals capital allocation decisions, debt sustainability, and hidden risks that the P&L never shows.
1
Leverage ratios: Is the debt sustainable?
Net Debt/EBITDA above 3x is a concern in most sectors. Above 5x is a red flag. Ask Claude to benchmark vs sector peers.
2
Goodwill quality
If goodwill is more than 25% of total assets, ask: "What acquisitions generated this goodwill? Have any been impaired? What is the risk of impairment?"
3
Working capital quality
Rising NWC as % of revenue means the business is consuming more cash as it grows โ a negative signal despite revenue growth.
Module โ Statement Analysis
Working Capital Analysis
Working capital management reveals operational efficiency. A company can grow revenue while destroying cash through poor working capital management.
| Metric | Formula | What it tells you |
|---|---|---|
| Receivable Days (DSO) | Receivables รท (Revenue/365) | Rising DSO = customers paying slower or channel stuffing |
| Inventory Days (DIO) | Inventory รท (COGS/365) | Rising inventory in declining-price business destroys value |
| Payable Days (DPO) | Payables รท (COGS/365) | Extending payables improves cash flow but may damage supplier relationships |
| Cash Conversion Cycle | DSO + DIO - DPO | Days the business needs to finance operations. Negative = gets paid before paying suppliers |
Module โ Statement Analysis
๐ก Cash Is King
๐ก Insight Card โ Balance Sheet
"Cash Is King โ And the Balance Sheet Shows Who Hoards It"
Warren Buffett looks for businesses that generate more cash than they consume. The balance sheet, read over multiple years, tells you exactly this story.
Cash-generative businesses: Nestlรฉ India, HDFC Bank, Asian Paints show consistently rising retained earnings with minimal debt.
Cash-consuming businesses: Companies that raise equity or debt every 2-3 years, show goodwill impairments, or see net debt rising faster than EBITDA.
Ask Claude: "Compare the net debt trajectory over 5 years to EBITDA growth. Is the company deleveraging or levering up?"
Cash-generative businesses: Nestlรฉ India, HDFC Bank, Asian Paints show consistently rising retained earnings with minimal debt.
Cash-consuming businesses: Companies that raise equity or debt every 2-3 years, show goodwill impairments, or see net debt rising faster than EBITDA.
Ask Claude: "Compare the net debt trajectory over 5 years to EBITDA growth. Is the company deleveraging or levering up?"
The balance sheet doesn't lie over time. The question is whether you're reading it carefully enough.
Module โ Statement Analysis
Cash Flow Statement Analysis
| Section | What it shows | Key question for Claude |
|---|---|---|
| Operating Cash Flow | Cash from core operations | "Is OCF consistently higher than net profit? If not, why?" |
| Investing Cash Flow | Capex, acquisitions, asset sales | "What % of OCF is being reinvested as capex?" |
| Financing Cash Flow | Debt raised/repaid, dividends | "Is the company consistently raising new debt or repaying?" |
| Free Cash Flow | OCF minus Capex | "Calculate FCF yield (FCF/Market Cap). Is it improving?" |
Most Important Red Flag
If Net Profit grows 30% but OCF grows only 5%, something is wrong. Either working capital is ballooning or there are aggressive accounting choices. Ask: "Calculate OCF/Net Profit ratio for each year. Below 0.8 is a red flag."
Module โ Statement Analysis
Ratio Analysis with Claude
Complete Ratio Analysis Prompt
Calculate the following ratios: PROFITABILITY: Gross Margin, EBITDA Margin, Net Margin, ROE, ROCE LIQUIDITY: Current Ratio, Quick Ratio LEVERAGE: Debt/Equity, Net Debt/EBITDA, Interest Coverage EFFICIENCY: Asset Turnover, Receivable Days, Inventory Turnover VALUATION: P/E, EV/EBITDA, EV/Revenue, P/Book, Dividend Yield Flag any ratio outside sector norm.
The DuPont Analysis
ROE = Net Margin ร Asset Turnover ร Financial Leverage. Ask Claude to decompose ROE into its three components. This reveals whether a company is a quality business or just a leveraged one.
Module โ Statement Analysis
Red Flag Detection
๐ฉ Rising Receivables Days
If receivables grow faster than revenue for 2+ consecutive years, the company may be channel-stuffing or having difficulty collecting payment.
๐ฉ OCF/PAT Ratio Below 0.8
If cash generated from operations is consistently less than 80% of reported profit, accounting profits may be overstated.
๐ฉ Rising Inventory in a Commodity Business
For steel, oil, or chemicals: rising inventory when prices are falling means the company is sitting on assets declining in value.
๐ฉ Net Debt Growing Faster Than EBITDA
If net debt/EBITDA is expanding despite revenue growth, the business is consuming more capital than it generates.
Module โ Statement Analysis
๐ก Accounting Red Flags
๐ก Insight Card โ Red Flags
"Accounting Red Flags and How Claude Finds Them"
The most sophisticated accounting fraud in corporate history โ Enron, Satyam, IL&FS, DHFL โ all left fingerprints in the financial statements years before the collapse became public.
Satyam (2009): The balance sheet showed โน5,040 Cr of cash that didn't exist. The tell: the company was raising debt despite showing massive cash balances.
IL&FS (2018): Net debt/EBITDA expanded from 4x to 12x over 5 years while management maintained an investment-grade narrative.
Claude's role: Give Claude 5 years of financial data and ask it to "flag any metrics that show a consistent deteriorating trend."
Satyam (2009): The balance sheet showed โน5,040 Cr of cash that didn't exist. The tell: the company was raising debt despite showing massive cash balances.
IL&FS (2018): Net debt/EBITDA expanded from 4x to 12x over 5 years while management maintained an investment-grade narrative.
Claude's role: Give Claude 5 years of financial data and ask it to "flag any metrics that show a consistent deteriorating trend."
Red flags are rarely hidden โ they are simply overlooked. Claude can run a systematic check across 20+ metrics in seconds.
Module โ Statement Analysis
Comparative Analysis & Peer Benchmarking
A company's financial metrics only become meaningful compared to peers and its own history.
Peer Comparison Prompt
Build a peer comparison for Indian IT sector (FY2024): Company | Rev (โนCr) | EBITDA% | PAT% | ROE% | P/E | EV/EBITDA TCS | 2,40,893 | 27.1 | 19.1 | 52.1 | 28x | 19x Infosys | 1,53,670 | 22.1 | 16.9 | 31.8 | 24x | 17x Wipro | 89,783 | 16.8 | 13.2 | 15.1 | 22x | 14x Calculate sector medians, premium/discount for each company, rank on quality, identify best value.
Module โ Statement Analysis
Lab: Analyse TCS Annual Report
๐ฌ Lab Exercise
TCS FY2024 Financial Analysis
Using TCS's publicly available FY2024 annual report data, build a complete financial analysis using Claude.
1
Pull TCS's 3-year P&L from the annual report (NSE website). Paste into Claude and ask it to calculate all profitability ratios. Compare to Infosys equivalent ratios.
2
Ask Claude to analyse TCS's revenue by geography and service line from segment disclosures. Which segments are growing fastest?
3
Run a red flag check: "Analyse TCS's balance sheet and cash flow for the last 3 years. Identify any metrics that show concerning trends."
4
Ask Claude to write a 200-word investment thesis for TCS, suitable for an equity research initiation report.
Module โ Statement Analysis
Key Distinctions
Revenue vs Cash Collections
Revenue is recognised when earned. Cash is collected when the customer pays. Rising receivables can signal revenue recognition issues.
EBITDA vs Free Cash Flow
EBITDA ignores capex and working capital. FCF reflects all cash needs. A capital-intensive business with high EBITDA but low FCF is less valuable than an asset-light business with the same EBITDA.
ROE vs ROCE
ROE = return to shareholders (affected by leverage). ROCE = return on all capital. A company can show high ROE simply by using more debt. ROCE is a purer measure of business quality.
Module โ Statement Analysis
Quiz โ Statement Analysis
Q1. Which financial statement is hardest to manipulate?
A. P&L Statement
B. Balance Sheet
C. Cash Flow Statement
D. Notes to Accounts
Q2. If OCF/Net Profit ratio is 0.5 for 3 consecutive years, this indicates:
A. The company is highly efficient
B. A red flag โ reported profits significantly exceed cash generated
C. The company is growing rapidly
D. High capital intensity
Q3. Cash Conversion Cycle = ?
A. DSO + DPO - DIO
B. DSO + DIO - DPO
C. DIO - DSO - DPO
D. DSO ร DIO / DPO
Slide 1 of 15
Slide 1 of 18
Use Next โ to navigate
Module โ DCF & Valuation
Valuation Framework
๐๏ธ
Intrinsic Value (DCF)
Sum of all future cash flows discounted to today. Theoretically rigorous but assumption-sensitive.
๐
Relative Value (Comps)
What the market pays for similar businesses. EV/EBITDA, P/E vs sector peers. Market-anchored.
๐
Transaction Value (Precedents)
What acquirers paid for similar companies. Includes control premium. Most relevant for M&A.
The Valuation Hierarchy
Always use at least 2 methods. If DCF says โน1,000 and comps say โน500, one assumption is wrong โ or the market is. Understand why before concluding.
Module โ DCF & Valuation
DCF Fundamentals
The DCF Formula
Enterprise Value = ฮฃ [FCFt / (1+WACC)^t] + Terminal Value / (1+WACC)^n
FCFt = Free Cash Flow in year t | WACC = Weighted Average Cost of Capital | Terminal Value = FCFn ร (1+g) / (WACC - g)
FCFt = Free Cash Flow in year t | WACC = Weighted Average Cost of Capital | Terminal Value = FCFn ร (1+g) / (WACC - g)
1
Step 1: Project Free Cash Flows (5-10 years)
FCF = EBIT ร (1-Tax Rate) + D&A - Capex - Change in Net Working Capital.
2
Step 2: Calculate WACC
WACC = (E/V ร Ke) + (D/V ร Kd ร (1-T)). Where Ke = Risk-free rate + Beta ร Equity Risk Premium.
3
Step 3: Calculate Terminal Value
Terminal value typically represents 60-80% of total DCF value. The terminal growth rate assumption is the most important in any model.
Module โ DCF & Valuation
Section 3 โ DCF & Valuation
This slide covers advanced concepts in DCF & Valuation. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ DCF & Valuation
Section 4 โ DCF & Valuation
This slide covers advanced concepts in DCF & Valuation. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ DCF & Valuation
Section 5 โ DCF & Valuation
This slide covers advanced concepts in DCF & Valuation. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ DCF & Valuation
Section 6 โ DCF & Valuation
This slide covers advanced concepts in DCF & Valuation. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ DCF & Valuation
Section 7 โ DCF & Valuation
This slide covers advanced concepts in DCF & Valuation. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ DCF & Valuation
Section 8 โ DCF & Valuation
This slide covers advanced concepts in DCF & Valuation. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ DCF & Valuation
Section 9 โ DCF & Valuation
This slide covers advanced concepts in DCF & Valuation. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ DCF & Valuation
Section 10 โ DCF & Valuation
This slide covers advanced concepts in DCF & Valuation. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ DCF & Valuation
Section 11 โ DCF & Valuation
This slide covers advanced concepts in DCF & Valuation. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ DCF & Valuation
Section 12 โ DCF & Valuation
This slide covers advanced concepts in DCF & Valuation. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ DCF & Valuation
Section 13 โ DCF & Valuation
This slide covers advanced concepts in DCF & Valuation. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ DCF & Valuation
Section 14 โ DCF & Valuation
This slide covers advanced concepts in DCF & Valuation. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ DCF & Valuation
Section 15 โ DCF & Valuation
This slide covers advanced concepts in DCF & Valuation. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ DCF & Valuation
Section 16 โ DCF & Valuation
This slide covers advanced concepts in DCF & Valuation. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ DCF & Valuation
Section 17 โ DCF & Valuation
This slide covers advanced concepts in DCF & Valuation. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ DCF & Valuation
Section 18 โ DCF & Valuation
This slide covers advanced concepts in DCF & Valuation. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Slide 1 of 18
Slide 1 of 13
Use Next โ to navigate
Module โ Excel + Claude
Claude in Excel โ Setup & Workflow
๐
Copy-Paste Workflow
Ask Claude to output CSV. Paste directly into Excel. Fastest method for financial tables.
๐ง
Formula Generation
Describe what you need in plain English. Claude writes the exact Excel formula.
๐
Error Debugging
Paste the broken formula. Claude diagnoses the error and provides the corrected version with explanation.
The Golden Rule
Always test Claude-generated formulas on a small dataset before applying to the full model. Verify logic on 2-3 rows first.
Module โ Excel + Claude
Formula Generation with Claude
| What You Need | Claude Output |
|---|---|
| 5-year CAGR from B5 to B10 | =((B10/B5)^(1/5))-1 |
| WACC (equity weight B1, Ke B2, debt weight B3, Kd B4, tax B5) | =(B1*B2)+(B3*B4*(1-B5)) |
| DCF PV of FCFs in C2:C6 at WACC in F1 | =SUMPRODUCT(C2:C6/((1+$F$1)^ROW(A1:A5))) |
| LBO IRR for -โน500 then โน180, โน200, โน220, โน240, โน900 | =IRR(B1:B6) |
Module โ Excel + Claude
Section 3 โ Excel + Claude
This slide covers advanced concepts in Excel + Claude. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ Excel + Claude
Section 4 โ Excel + Claude
This slide covers advanced concepts in Excel + Claude. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ Excel + Claude
Section 5 โ Excel + Claude
This slide covers advanced concepts in Excel + Claude. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ Excel + Claude
Section 6 โ Excel + Claude
This slide covers advanced concepts in Excel + Claude. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ Excel + Claude
Section 7 โ Excel + Claude
This slide covers advanced concepts in Excel + Claude. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ Excel + Claude
Section 8 โ Excel + Claude
This slide covers advanced concepts in Excel + Claude. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ Excel + Claude
Section 9 โ Excel + Claude
This slide covers advanced concepts in Excel + Claude. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ Excel + Claude
Section 10 โ Excel + Claude
This slide covers advanced concepts in Excel + Claude. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ Excel + Claude
Section 11 โ Excel + Claude
This slide covers advanced concepts in Excel + Claude. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ Excel + Claude
Section 12 โ Excel + Claude
This slide covers advanced concepts in Excel + Claude. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ Excel + Claude
Section 13 โ Excel + Claude
This slide covers advanced concepts in Excel + Claude. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Slide 1 of 13
Slide 1 of 12
Use Next โ to navigate
Module โ IB Models
Investment Banking Models Overview
๐ฆ
LBO Model
Leveraged Buyout: what returns can a PE firm earn buying a company with mostly debt?
๐ค
M&A / Merger Model
Accretion/Dilution analysis: does this acquisition increase or decrease the acquirer's EPS?
๐
Pitch Deck Financials
The financial slides in IB pitch books โ how to build and present for maximum impact.
The IB Model Standard
An IB-quality model has: (1) All assumptions clearly documented and defensible, (2) Consistent formatting, (3) Balance sheet and cash flow checks, (4) Output explainable in 5 minutes.
Module โ IB Models
LBO Model Basics
1
The LBO Structure
PE firm buys Target at a purchase price (e.g., 10x EBITDA). Finances with: ~60-70% debt, ~30-40% equity. Target's cash flows repay the debt over 5 years.
2
Three value creation levers
EBITDA growth, multiple expansion, and debt paydown (deleveraging). The best PE investments deliver returns from all three.
LBO Returns Prompt
Entry EV: โน2,000 Cr at 10x EBITDA. Debt: โน1,400 Cr @ 10.5% Equity: โน600 Cr. EBITDA grows 15%/yr. Exit at 12x after 5 yrs. Calculate: Exit EV, Exit Equity Value, MOIC, IRR
Module โ IB Models
Section 3 โ IB Models
This slide covers advanced concepts in IB Models. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ IB Models
Section 4 โ IB Models
This slide covers advanced concepts in IB Models. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ IB Models
Section 5 โ IB Models
This slide covers advanced concepts in IB Models. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ IB Models
Section 6 โ IB Models
This slide covers advanced concepts in IB Models. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ IB Models
Section 7 โ IB Models
This slide covers advanced concepts in IB Models. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ IB Models
Section 8 โ IB Models
This slide covers advanced concepts in IB Models. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ IB Models
Section 9 โ IB Models
This slide covers advanced concepts in IB Models. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ IB Models
Section 10 โ IB Models
This slide covers advanced concepts in IB Models. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ IB Models
Section 11 โ IB Models
This slide covers advanced concepts in IB Models. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Module โ IB Models
Section 12 โ IB Models
This slide covers advanced concepts in IB Models. Content based on real IB practice and Indian market examples.
Key Concept
This section builds on the previous concepts with practical applications using Claude as your financial modelling partner.
Slide 1 of 12
Slide 1 of 11
Use Next โ to navigate
Module 6 โ Real Case Studies
The Case Study Approach
Theory becomes skill only when applied to real companies with real data. This module walks through three complete financial analyses using Claude โ Tata Motors (cyclical auto), Infosys (IT services), and a D2C Startup โ showing exactly how a professional analyst would approach each.
๐
Tata Motors
Cyclical business, JLR complexity, EV transition. How to value a company with volatile earnings and multiple business lines.
๐ป
Infosys
IT services, US-heavy revenue, margin pressures. Comps vs peers, employee cost structure, deal win analysis.
๐
D2C Startup
Pre-profit, unit economics driven, VC-backed. How to model a startup using SaaS metrics and cohort analysis.
The Case Study Protocol
For each company, we follow the same protocol: (1) Understand the business model, (2) Analyse historical financials, (3) Build projections, (4) Calculate valuation, (5) Write investment thesis. Claude accelerates every step. Your judgment drives the conclusions.
Module 6 โ Case Studies
Tata Motors: DCF Walkthrough
Tata Motors is one of India's most complex listed companies โ two distinct businesses (India CV/PV and JLR), cyclical earnings, massive debt, and an EV transition underway. Valuing it requires a Sum-of-Parts approach, not a simple DCF.
1
Business Segmentation
India operations (CV + PV + EV): stable, growing, lower margin. JLR (Jaguar Land Rover, UK): premium, volatile, cyclical. Each segment needs its own valuation methodology.
2
Sum-of-Parts approach
India operations: DCF or P/E based on domestic auto peers. JLR: EV/EBITDA vs BMW, Mercedes, Aston Martin comps. Net holding company discount: 15-20%. Net debt (consolidated): subtract from SOTP value.
3
The cyclicality problem
Tata Motors swung from โน-28,000 Cr loss (FY23) to โน31,807 Cr profit (FY24) in one year. A DCF based on FY24 profits would massively overvalue. A DCF based on FY23 losses would undervalue. Solution: mid-cycle earnings or normalised EBITDA.
Tata Motors SOTP Prompt
Build a Sum-of-Parts valuation for Tata Motors: India Ops: EBITDA โน12,000 Cr | Peers trade at 8-10x EV/EBITDA JLR: EBITDA ยฃ2,800 Mn | European luxury auto peers: 4-6x EV/EBITDA Net Debt (consolidated): โน48,000 Cr Shares outstanding: 360 Cr | GBP/INR: 107 Calculate: India EV, JLR EV (in โน), Total EV, Equity Value, Price per share. Apply 15% holdco discount. Sensitivity: JLR at 4x vs 6x EBITDA. What drives the biggest swing in price?
Module 6 โ Case Studies
Tata Motors: Valuation Verdict
After building the model, the analyst must reach a conclusion โ and defend it. This is where the judgment comes in. Claude gives you the numbers. You make the call.
The Bull Case for Tata Motors
JLR EBITDA margin expands to 16%+ (currently 14.2%) driven by mix shift to Defender/Range Rover (highest margin models). India EV business โ Tata.ev โ captures 70%+ market share in a fast-growing segment. Debt reduction of โน20,000 Cr over 3 years. SOTP value: โน1,100-1,200/share.
The Bear Case for Tata Motors
JLR faces China slowdown (15% of volumes), EV competition from BYD/Tesla in Europe. India EV margin negative, consuming cash. Any global recession hits JLR volumes hard โ EBITDA collapses. Debt remains high. SOTP value: โน600-700/share.
Investment Thesis Prompt
Write a 200-word investment thesis on Tata Motors for an equity research initiation report. Current price: โน950. Base case SOTP: โน1,050. Bull: โน1,200. Bear: โน650. Include: business quality assessment, key catalysts, key risks, and recommendation (Buy/Hold/Sell).
The Key Learning
SOTP is the right method for conglomerates. Never apply a single multiple to a company with two fundamentally different businesses. JLR at 5x EBITDA is fair. India auto at 9x EBITDA is fair. The combined entity should not be valued at either single number.
๐ก Insight Card โ Cyclical Valuation
"Cyclical Company Valuation โ The Mid-Cycle Earnings Trap"
The most dangerous mistake in valuing cyclical companies โ auto, steel, cement, commodities โ is using peak earnings to set a DCF or P/E target.
In FY2024, Tata Motors reported โน31,807 Cr PAT. If you apply 15x P/E, you get a market cap of โน4.77 lakh Cr โ implying a share price of โน1,325. This looks compelling if current price is โน950.
But these are peak-cycle earnings. When the cycle turns (recession, credit tightening, commodity spike), JLR's EBITDA can halve in 12 months. The "cheap at 15x peak earnings" stock becomes "expensive at 30x trough earnings."
The professional solution: mid-cycle EBITDA. Take the average EBITDA over the full cycle (up-years + down-years). Apply your multiple to this normalised number. This prevents overpaying at the peak and panic-selling at the trough.
Ask Claude: "Average Tata Motors' EBITDA over FY20-FY24 (including the loss years). Apply a 7x EV/EBITDA multiple to this mid-cycle EBITDA. Compare to current EV. Is the stock cheap or expensive vs mid-cycle?"
This single analysis separates cyclical investing skill from noise.
In FY2024, Tata Motors reported โน31,807 Cr PAT. If you apply 15x P/E, you get a market cap of โน4.77 lakh Cr โ implying a share price of โน1,325. This looks compelling if current price is โน950.
But these are peak-cycle earnings. When the cycle turns (recession, credit tightening, commodity spike), JLR's EBITDA can halve in 12 months. The "cheap at 15x peak earnings" stock becomes "expensive at 30x trough earnings."
The professional solution: mid-cycle EBITDA. Take the average EBITDA over the full cycle (up-years + down-years). Apply your multiple to this normalised number. This prevents overpaying at the peak and panic-selling at the trough.
Ask Claude: "Average Tata Motors' EBITDA over FY20-FY24 (including the loss years). Apply a 7x EV/EBITDA multiple to this mid-cycle EBITDA. Compare to current EV. Is the stock cheap or expensive vs mid-cycle?"
This single analysis separates cyclical investing skill from noise.
For cyclical companies, always use mid-cycle or normalised earnings. Peak P/E looks cheap. Trough P/E looks expensive. Neither is the right anchor.
Module 6 โ Case Studies
Infosys: IT Sector Financial Model
Infosys is an asset-light, cash-generative, high-ROE IT services business โ the opposite of Tata Motors. The valuation challenges here are different: US revenue concentration, wage inflation, deal ramp timelines, and attrition risk.
1
Revenue Model: Headcount ร Revenue per Employee
IT services revenue = Billable headcount ร Utilisation ร Billing rate. Ask Claude: "Infosys has 317,000 employees, ~85% utilisation, avg billing rate $45/hr. Project revenue assuming headcount grows 5% and billing rate improves 3% annually."
2
Margin Structure: Employee Costs are 60% of Revenue
The biggest swing factor in IT margins is salary hike quantum vs billing rate improvement. Ask Claude: "If Infosys gives 8% salary hike and achieves 4% billing rate improvement, what happens to EBIT margin? Model the P&L impact."
3
Deal Pipeline as Leading Indicator
Large deal wins (>$50Mn TCV) are announced quarterly. Revenue ramps over 12-36 months. Ask Claude: "If Infosys won $3.2Bn TCV in large deals in FY24, and 30% ramps in Year 1, 40% Year 2, 30% Year 3, what incremental revenue does this add by FY26?"
The Attrition Problem
IT attrition peaked at 28% in FY23 (meaning 28% of the workforce left in one year). Ask Claude: "If attrition is 15% on 317,000 employees, and each replacement costs โน2.5 lakhs in recruitment + 3 months of training time where the new hire is 60% productive, what is the annual cost of attrition to Infosys?"
Module 6 โ Case Studies
Infosys: Comps Analysis vs Peers
Infosys trades at a discount to TCS โ but does it deserve to? A rigorous comps analysis answers this question with data, not intuition.
IT Sector Comps Prompt
Build a comprehensive IT sector comps table (FY2024 data): Company |Rev(โนCr)|EBITDA%|PAT%|ROE%|Attrition|Rev CAGR|EV/EBITDA|P/E TCS |240,893 | 27.1 |19.1|52.1| 12.3% | 8.2% | 19x | 28x Infosys |153,670 | 22.1 |16.9|31.8| 12.9% | 4.1% | 17x | 24x Wipro | 89,783 | 16.8 |13.2|15.1| 14.2% | 2.3% | 14x | 22x HCL Tech |104,442 | 22.8 |14.6|24.4| 13.1% | 7.9% | 15x | 19x Analyse: (1) Is Infosys's discount to TCS justified? (2) Which company offers best value (quality/price tradeoff)? (3) What would close the TCS-Infosys multiple gap? (4) Rank all 4 on: quality score, value score, combined score
The TCS Premium Explained
TCS trades at a structural premium to peers because: (1) Highest margins reflecting pricing power and efficiency, (2) Highest revenue per employee, (3) Tata brand and balance sheet strength, (4) BFSI and retail sector depth. Ask Claude: "What revenue growth or margin improvement would Infosys need to close 50% of its discount to TCS's EV/EBITDA multiple? What is the implied price target?"
๐ก Insight Card โ IT Sector
"Services vs Product Multiples โ Why IT Companies Trade at Different P/Es"
One of the most common questions from finance students: why does TCS trade at 28x P/E while Wipro trades at 22x, even though both are profitable IT services companies?
The answer is a combination of four factors that Claude can help you quantify:
1. Margin differential: TCS's 27% EBITDA margin vs Wipro's 17% reflects better pricing power, lower attrition costs, and more efficient delivery. Higher margins = more durable earnings = higher multiple.
2. Growth differential: TCS's 8.2% revenue CAGR vs Wipro's 2.3% means TCS's earnings base grows faster. Higher growth = higher multiple.
3. Return on capital: TCS's 52% ROE vs Wipro's 15% reflects dramatically better capital efficiency. The market pays more for businesses that generate higher returns on each rupee of capital.
4. Predictability: TCS has a more stable, diversified revenue base โ higher revenue visibility = lower risk premium = lower discount rate = higher multiple.
The combined effect: TCS deserves a structural premium. The question is whether the current premium (28x vs 22x = 27% premium) is appropriate, excessive, or insufficient given these fundamental differences.
The answer is a combination of four factors that Claude can help you quantify:
1. Margin differential: TCS's 27% EBITDA margin vs Wipro's 17% reflects better pricing power, lower attrition costs, and more efficient delivery. Higher margins = more durable earnings = higher multiple.
2. Growth differential: TCS's 8.2% revenue CAGR vs Wipro's 2.3% means TCS's earnings base grows faster. Higher growth = higher multiple.
3. Return on capital: TCS's 52% ROE vs Wipro's 15% reflects dramatically better capital efficiency. The market pays more for businesses that generate higher returns on each rupee of capital.
4. Predictability: TCS has a more stable, diversified revenue base โ higher revenue visibility = lower risk premium = lower discount rate = higher multiple.
The combined effect: TCS deserves a structural premium. The question is whether the current premium (28x vs 22x = 27% premium) is appropriate, excessive, or insufficient given these fundamental differences.
Multiple differences always have fundamental explanations. Find them. A persistent discount that has no fundamental justification is an opportunity. A premium with no justification is a risk.
Module 6 โ Case Studies
Startup Financial Model: D2C Brand
Modelling a pre-profit startup requires a completely different framework from established companies. Traditional P/E and EV/EBITDA are meaningless. Unit economics, cohort analysis, and path to profitability are everything.
1
Unit Economics โ The Foundation
CAC (Customer Acquisition Cost) vs LTV (Lifetime Value). If you spend โน500 to acquire a customer who generates โน2,000 in gross profit over 3 years, LTV/CAC = 4x. Ask Claude: "Calculate LTV given: avg order โน1,800, purchase frequency 3x/year, gross margin 45%, customer lifespan 2.5 years."
2
Cohort Analysis
Track each customer acquisition cohort (monthly/quarterly) for: repeat purchase rate, revenue per customer, and gross profit. Ask Claude: "Build a 12-month cohort model: Month 1 cohort acquires 5,000 customers at โน500 CAC. Repeat rate 40%/month. AOV โน1,800. Gross margin 40%. Show cumulative gross profit by cohort month."
3
Contribution Margin to EBITDA Bridge
Gross Margin - Variable Marketing Costs = Contribution Margin. CM - Fixed Costs (tech, people, rent) = EBITDA. The startup becomes profitable when CM exceeds fixed costs. Ask Claude: "At what GMV does this startup reach EBITDA breakeven given: CM% = 18%, fixed costs = โน8 Cr/month?"
Startup Valuation Methods
Pre-profit startups are valued on: (1) Revenue multiple (EV/Revenue: typically 3-8x for D2C, 8-15x for SaaS), (2) GMV multiple (for marketplace), (3) DCF on Year 5-7 FCF when profitable. Always discount heavily for execution risk.
Module 6 โ Case Studies
SaaS Metrics & Unit Economics
SaaS (Software as a Service) businesses have their own financial language โ ARR, MRR, churn, NRR, CAC payback. These metrics tell you more about a SaaS business than a traditional P&L ever could. Claude understands all of them.
| Metric | Formula | Benchmark | Claude Prompt |
|---|---|---|---|
| ARR | Annual Recurring Revenue = MRR ร 12 | Growth rate > 30% is strong | "Calculate ARR growth rate from โน24 Cr to โน38 Cr in 12 months" |
| Churn Rate | Customers lost / Beginning customers | <5% annual = excellent | "If we start with 500 customers and lose 8/month, what is annual churn?" |
| NRR | Net Revenue Retention = (Revenue from existing customers including expansions) / Prior period revenue | >110% = best-in-class | "Calculate NRR: 100 customers at โน10L each, 5 churned, 20 expanded to โน15L" |
| CAC Payback | CAC / (Monthly Revenue per customer ร Gross Margin) | <12 months = strong | "CAC โน60,000, MRR per customer โน8,000, GM 75%. What is payback period?" |
| LTV/CAC | LTV / CAC | >3x = healthy unit economics | "LTV = โน240,000, CAC = โน60,000. Is this business viable? At what scale?" |
The Rule of 40
For SaaS companies, the Rule of 40 = Revenue Growth % + EBITDA Margin %. Above 40 is healthy. Below 40 signals either too slow growth or too much cash burn. Ask Claude: "Analyse these 5 SaaS companies on Rule of 40 and rank them. Which would you expect to trade at the highest revenue multiple?"
Module 6 โ Case Studies
Course Summary & Your Next Steps
You have now completed the most comprehensive financial modelling with Claude course available. Here is what you have built โ and what to do next.
โ
Foundation
You understand how Claude thinks, what it knows, and how to brief it precisely for financial tasks. You have a prompt library for every major financial task.
โ
Financial Statement Analysis
You can analyse P&L, Balance Sheet, and Cash Flow statements systematically using Claude โ including red flag detection, ratio analysis, and peer benchmarking.
โ
DCF & Valuation
You can build complete DCF models, calculate WACC, estimate terminal value, run sensitivity analysis, and build football field charts โ all using Claude to accelerate the mechanics.
โ
Excel + Claude
You can generate formulas, build 3-statement models, debug errors, create dashboards, and run scenario analysis using Claude as your co-analyst in Excel.
โ
IB Models
You can build LBO models, run M&A accretion/dilution analysis, and produce pitch book quality financial slides using Claude.
โ
Real Case Studies
You have applied all these skills to real Indian companies โ Tata Motors, Infosys, and a D2C startup โ with the exact approach used by professional analysts.
Your Next Step
Take the final exam. Pass with 70%+ to receive your Financial Modelling Using Claude certificate, valid for 1 year. Then: pick one real company, build a complete model using Claude, and share it. That first real model is worth more than any certificate.
Module 6 โ Quiz
Quiz โ Case Studies (10 Questions)
Q1. Why is Sum-of-Parts (SOTP) valuation used for Tata Motors?
A. Because it has high debt
B. Because it has two fundamentally different businesses (India auto and JLR) that deserve different multiples โ a single blended multiple would be inappropriate
C. Because it is a cyclical company
D. Because it has negative earnings in some years
Q2. For cyclical companies, the correct approach to DCF/P/E valuation is:
A. Use peak earnings โ they represent the company's potential
B. Use mid-cycle or normalised earnings โ average EBITDA across the full cycle to avoid over/undervaluation at peaks and troughs
C. Use the most recent quarter's earnings annualised
D. Only use DCF for cyclical companies โ never multiples
Q3. In IT services valuation, what is the bottom-up revenue modelling approach?
A. Industry size ร market share
B. Billable headcount ร Utilisation rate ร Billing rate โ this drives IT revenue at the fundamental level
C. Revenue per employee ร total employees regardless of utilisation
D. Deal wins ร average deal size
Q4. LTV/CAC ratio of 4x means:
A. The company is growing too slowly
B. For every โน1 spent acquiring a customer, the business generates โน4 in gross profit over that customer's lifetime โ healthy unit economics
C. CAC is too high and the business is not viable
D. The company needs to reduce marketing spend
Q5. Net Revenue Retention (NRR) of 120% means:
A. Revenue grew 20% from new customers
B. Existing customers generated 20% more revenue than the prior period โ through expansion and upsells, more than offsetting any churn. This is best-in-class.
C. 20% of customers churned
D. The company has 20% customer growth
Q6. The Rule of 40 for SaaS companies states:
A. Revenue growth must exceed 40%
B. Revenue Growth % + EBITDA Margin % should exceed 40% โ indicating a healthy balance between growth and profitability
C. Gross margin must exceed 40%
D. CAC payback must be under 40 months
Q7. Why does TCS trade at a higher EV/EBITDA than Wipro?
A. TCS has higher revenue
B. TCS has materially higher EBITDA margins, higher revenue growth, higher ROE, and lower attrition โ all fundamental factors that justify a premium multiple
C. TCS is older and more established
D. TCS is in the Tata group
Q8. For a D2C startup, EBITDA breakeven occurs when:
A. Revenue exceeds total expenses
B. Contribution Margin (Gross Profit minus variable marketing costs) exceeds total fixed costs
C. CAC payback period falls below 12 months
D. The company raises a Series B round
Q9. CAC Payback Period of 8 months means:
A. The company acquires customers too slowly
B. The customer acquisition cost is recovered in 8 months of gross profit from that customer โ this is excellent (benchmark is under 12 months)
C. The company is not growing fast enough
D. Marketing spend is too high
Q10. The most important difference between valuing an IT services company vs a product company is:
A. IT companies always trade at lower multiples
B. IT services are people-intensive โ margins and growth are driven by headcount, utilisation, attrition, and billing rates โ vs product companies where margins scale with volume independently of headcount
C. IT companies have no assets to value
D. Product companies use DCF while IT uses comps
Slide 1 of 11
๐
Final Certification Exam
Test your knowledge across all 6 modules. Pass to receive your Financial Modelling Using Claude certificate, valid for 1 year.
Questions
50 Questions
Pass Mark
70% (35/50)
Attempts
Maximum 2
Certificate
1-Year Validity
Questions
Answered
Flagged
Unanswered
60:00
Question 1 of 50