Role capstone5-7 focused daysAdvanced
Regulatory impact note
Academia, Policy, and Advisory portfolio artifact 3 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 Academia, Policy, and Advisory analyst. Use public information to produce a decision-ready work product for a manager or interview panel.
Show that you can apply Research writing, Indian financial regulation, Statistics, Valuation, ESG analysis in a practical analyst workflow, not only explain the theory.
What to make
Academia, Policy, and Advisory portfolio artifact 3 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
- Public filings, official regulatory material, public datasets, company career/domain research, and a documented source log.
- 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 Academia, Policy, and Advisory capstone on regulatory impact note using public sources, structured analysis, and a decision-ready output.
Interview talk track
- Problem: explain the business question and why it matters for Academia, Policy, and Advisory.
- Method: describe the data collected, assumptions made, and analysis performed.
- Decision: state the recommendation, key risk, and what would change your view.
Linked skills
ValuationValue one public company using DCF, trading comps, and transaction compsStatisticsEstimate beta, volatility, correlations, and confidence intervalsResearch writingPublish a concise research note with evidence, charts, and risksIndian financial regulationMap one product or role to SEBI/RBI/NISM compliance obligationsESG analysisScore a company using BRSR and sustainability disclosures
Related projects
Value one public company using DCF, trading comps, and transaction compsIndustry-ready proof for valuationEstimate beta, volatility, correlations, and confidence intervalsIndustry-ready proof for statisticsPublish a concise research note with evidence, charts, and risksIndustry-ready proof for research writingMap one product or role to SEBI/RBI/NISM compliance obligationsIndustry-ready proof for indian financial regulation