You can't skip this if you want a job in finance | CA Nandini Agrawal

Finance-career skills emphasized (with finance-specific framing)

1) Excel (core finance tool; heavy use in audit/PE)

Uses in roles described

• Data cleaning, extracting insights, building linked models.
• Financial calculations, e.g., Receivable = (Invoice amount including GST) − TDS.
• Market sizing and revenue/cost projections (done in Excel).
• Private equity expectations: “80–90% on Excel” (data collation + financial modeling).

Proficiency levels mentioned

• Beginners: basic to intermediate (structure, options, formatting, linking, formulas).
• PE: expectation of advanced Excel; pre-joining speed/formula exercises.

Learning resources / distribution

• Mentions a free ~1-hour Excel masterclass (link in description).
• Also notes learning on the job, depending on the company/role.

---

2) Professional writing (memo / executive summary; ongoing feedback loop)

Writing requirements by function

• Audit-style: audit procedures + conclusion, written clearly.
• PPT writing: titles + an executive summary slide that lets executives understand key outcomes “in one slide”.

Implied writing framework

1. Start with the bottom line (brief conclusion/hypothesis/running answer).
2. Provide detailed analysis.
3. End with conclusion + recommendation.

Process advice

• Even after years, expect feedback; writing is an “ongoing journey”.
• Mentions using AI dictation / voice-to-text to improve speed and reduce memo-production time.

Example (voice-to-text memo content)

• Scenario: evaluating investment in Blinkit.
• Explicit “investment memo” points:
  • Path to profitability exists but still needs proof
  • Benchmarking: not a concern; “stands out vs competitors”
  • Competitors used: Zepto, Swiggy Instamart
  • Notes past cash burn as a consideration
• Tool mentioned: Disper Flow (AI voice-to-text)
• Mentions a free 1 month Pro subscription via link (promotional disclosure implied)

---

3) PPT / storytelling (consulting-style deck construction)

Step-by-step deck framework (“story boarding”)

• Decide what goes on slide 1.
• Maintain slide-to-slide continuity.
• Example market/company research flow:
  • Market size (e.g., “Quick market = 100b/200b…”)
  • Identify top players capturing ~70–80%
  • Include local players
  • Explain business model
  • Explain inventory management
  • Assess risks / flaws in business model

Slide writing / visual rules

• Slide titles should be short (e.g., 5–6 words conveying the slide’s point).
• Avoid too much body text (otherwise it becomes “more of a dog”, i.e., less visually intuitive).

Learning advice

• Learn PPT basics: formatting, inserting slides, dragging boxes, changing colors.
• Notes that Notes AI can generate PPT, but you still need baseline PPT knowledge to edit/communicate.
• Recommends learning shortcuts.

---

4) Financial modeling (project fundamentals → valuation)

Definition and scope

• Modeling/projection of company financial statements for future periods.
• Example horizon: Reliance results released to public at FY26 end + one more quarter; model horizon next 5 years.

Explicit model outputs

• Revenue, costs, profits, cash flow, balance sheet for the next 5 years.

Assumptions logic requirement (what must be justified)

• Revenue growth example:
  • Revenue increases by 15%
  • Justification: nominal growth 11–12%
  • Telecom sector profits drive the remainder so overall ~3% comes from that sector
• Margin example:
  • 28% → 32% over 5 years (drivers must be explained)
• End goal:
  • Connect profits to valuation (profit becomes 1.5x / 2x / 3x)

Valuation methods explicitly named

• DCF (discounted cash flow)
• PE-based approach
  • Example logic: after 5 years profit targets map to an earnings multiple (mentions a “20x return threshold” concept)
  • Illustrative target pricing logic:
    • If after 2 years profit = ₹100 crore
    • Apply 20x → valuation ₹2000 crore
    • Divide by shares (illustrative 2000 crore shares) → ₹1 per share

Investment decision framework (how the model informs price)

• Investors have a minimum return threshold (example: at least 20% return).
• If the model doesn’t meet the threshold, adjust the investment price downward (“buy more at a cheaper price”).
• Target price is tied to projected profits and the chosen valuation multiple.

Learning resources / timeline

• Mentions a financial modeling class “this week” and also 25th–26th July (year not stated).

---

5) Communication (verbal + structured presentation; ties to career advancement)

Key emphasis

• Communication is necessary in finance—especially when stepping up toward leadership (“CEO/CFO meetings”).
• Verbal communication matters as much as technical skill.

Example of what good communication looks like

• Present a thesis (e.g., M&A opportunity) with structured reasons:
  • Revenue growth driver (e.g., revenue up 30% in next two years after acquisition)
  • Synergy/capabilities
  • Strong management and client base
• Handle counter-questions quickly because the deck + analysis are ready.

Structure-building advice

• If you struggle with structure, practice structured problem-solving (mentions consulting interview practice).

---

Step-by-step / methodology items explicitly shared

• Professional writing structure

  • Bottom line (conclusion/hypothesis)
  • Detailed analysis
  • Conclusion & recommendation

• PPT storytelling / deck construction

  • Slide 1: key market/company point
  • Slides connect logically (market size → players/market share → business model → inventory management → risks)
  • Slide titles: short (5–6 words) summarizing the slide’s point

• Financial modeling workflow

  • Build assumptions for the next 5 years
  • Project financial statements: revenue/costs/profit/cash flow/balance sheet
  • Link assumptions to justification (growth drivers, margins)
  • Valuation: DCF and/or PE multiple → derive target price
  • Compare to investor return threshold (example 20%) to determine attractiveness/required entry price

• Communication approach

  • Present hypothesis quickly
  • Prepare data/deck for follow-up questions

---

Instruments / tickers / companies / sectors mentioned

Companies

• PwC, Blinkit, Zepto, Swiggy Instamart, Reliance

Sectors / themes

• Telecom sector (used as growth driver in a modeling example)
• M&A opportunity

Tickers

• No specific stock/ETF/bond tickers were provided (company names were used as examples).

Tools

• Excel, PPT, Disper Flow (voice-to-text), generic “chat with AI” / AI tools

---

Key numbers & explicit recommendations / cautions

• Excel formula example: Receivable = Invoice (incl. GST) − TDS
• Market share example (illustrative): top players capture ~70–80%
• Writing/recommendation:
  • Executive summary first slide
  • Memo writing can be shortened (cut by 50% without changing meaning)
• Financial modeling numbers (illustrative)
  • Revenue growth: 15%
  • Nominal growth: 11–12%
  • Sector contribution: ~3%
  • Margin: 28% → 32% over 5 years
  • Profit growth target: 1.5x / 2x / 3x
  • Return threshold: at least 20% return
  • PE/target price example:
    • Profit after 2 years: ₹100 crore
    • Apply 20x → valuation ₹2000 crore
    • 2000 crore shares → ₹1 per share (illustrative)
• Memo investment example (Blinkit)
  • Profitability path: “exists but still needs proof”
  • Notes past cash burn as a concern
• Communication example
  • Revenue growth after acquisition: 30% over two years

---

Disclaimers / promotional language

• Tool promotions are mentioned (e.g., link in description, free Pro subscription for 1 month).
• No explicit “not financial advice” disclaimer appears in the provided subtitles.

---

Presenter / source attribution

• Presenter: CA Nandini Agrawal (implied by video title and speaking content)
• Referenced sources/tools (not presenters):
  • PwC, GIC, BCG
  • Disper Flow, generic AI tools, YouTube learning resources