Role capstone3-5 focused daysAdvanced
Full initiation report
Equity Research portfolio artifact 1 of 5
Build
Model, memo, dashboard, notebook, or deck.
Explain
Clear assumptions, insight, and recommendation.
Show
Resume bullet and interview story.
What you are doing
Act as a junior Equity Research analyst. Use public information to produce a decision-ready work product for a manager or interview panel.
Show that you can apply Accounting fluency, Valuation, Equity research, Research writing, Financial modeling in a practical analyst workflow, not only explain the theory.
What to make
Equity Research portfolio artifact 1 of 5
Deliverables
- Professional brief
- Financial model or analytical workbook
- Presentation deck
- Source log
- Interview talking points
- Source and assumption log
- One-page executive summary
- Final output file
How to start
- Pick one listed company and define the valuation date.
- Collect financial statements for at least three years.
- Choose 4-6 comparable companies and capture market multiples.
- Create an assumptions tab with revenue, margin, capex, working capital, WACC, and terminal growth.
Step-by-step execution
- Build historical financials and clean one-off items.
- Forecast revenue, costs, taxes, capex, and working capital.
- Calculate DCF value, trading comps value, and transaction comps value where possible.
- Run sensitivity on WACC, terminal growth, exit multiple, and margin assumptions.
- Write a final recommendation explaining upside/downside, key risks, and what would change your view.
Data and sources
- Annual reports, investor presentations, exchange filings, SEBI/RBI/NSE/BSE pages, and official company disclosures.
- Latest annual report
- Quarterly results or investor presentation
- NSE/BSE price history
- Peer company filings
- Public transaction/news sources
Tools to use
- Excel or Google Sheets
- Docs
- Slides
- Public filings
- Google Docs
- Excel
Quality rubric
- Clear problem statement and role context
- Source-backed assumptions
- Clean model, memo, notebook, or dashboard
- Decision recommendation with risks
- Resume bullet and interview talk track
Resume bullet
Built a Equity Research capstone on full initiation report using public sources, structured analysis, and a decision-ready output.
Interview talk track
- Problem: explain the business question and why it matters for Equity Research.
- Method: describe the data collected, assumptions made, and analysis performed.
- Decision: state the recommendation, key risk, and what would change your view.
Linked skills
Accounting fluencyBuild a clean three-statement bridge for a listed Indian companyFinancial modelingCreate a three-statement model with scenarios and sensitivity tablesValuationValue one public company using DCF, trading comps, and transaction compsEquity researchWrite an initiation-style stock pitch with thesis, model, and risksResearch writingPublish a concise research note with evidence, charts, and risks
Related projects
Build a clean three-statement bridge for a listed Indian companyIndustry-ready proof for accounting fluencyCreate a three-statement model with scenarios and sensitivity tablesIndustry-ready proof for financial modelingValue one public company using DCF, trading comps, and transaction compsIndustry-ready proof for valuationWrite an initiation-style stock pitch with thesis, model, and risksIndustry-ready proof for equity research