Hey everyone,
I'm currently interning at a top-tier CA firm in India, in the M&A / Transaction Advisory space.
A little about my background:
- Undergraduate student pursuing Economics.
- Cleared CFA Level 1.
- Have a basic understanding of Excel and financial analysis.
I've also completed a few practical financial modelling projects as part of my learning, including:
- Investment & Loan Decision Analysis: Worked with NPV, IRR, sensitivity analysis, loan EMIs, interest calculations and amortisation schedules.
- Advanced Excel Sales Analysis: Used SUMIFS, VLOOKUP, INDEX-MATCH, Goal Seek, PivotTables and data tables.
- Sales Performance Dashboard: Built an interactive dashboard using PivotTables, slicers and GETPIVOTDATA.
However, I understand that completing these projects and actually working on financial models in a professional environment are two very different things.
Here's my current situation.
There's an ongoing DCF valuation assignment at my firm. An article assistant is currently working on the model, and she's someone I can approach for guidance whenever I get stuck.
I'm not officially assigned any responsibilities on this project. My opportunity is essentially to study the model, understand the assumptions, follow the valuation process and help out with smaller tasks wherever possible.
For instance, she recently gave me a task (if I could manage it) involving consolidating capital spares. The existing consolidated figure had references running across numerous sheets, with formulas linking to other sheets and those sheets linking further elsewhere. Essentially, I had to make sense of this rather complicated chain of references and see if I could simplify it.
These are the kinds of small but meaningful tasks I'd love to become capable of handling independently.
I'm not expecting to master financial modelling or become an expert overnight. I just want to develop a good enough understanding of DCF valuation, Excel and financial modelling to follow the actual assignment and be useful to the person working on it.
I'd appreciate advice from people who've worked in Valuations, Investment Banking, Transaction Advisory or Equity Research.
In particular, given that I'm not officially assigned to the project, how can I contribute meaningful insights without overstepping my role?
What would you recommend I focus on learning to become useful on an actual live valuation assignment?
Any practical advice or resources would be greatly appreciated.
Thanks!