Role capstone7-10 focused daysAdvanced
Full analyst interview deal book
Investment Banking portfolio artifact 5 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 Investment Banking analyst. Use public information to produce a decision-ready work product for a manager or interview panel.
Show that you can apply Accounting fluency, Financial modeling, Valuation, M&A analysis, Credit analysis in a practical analyst workflow, not only explain the theory.
What to make
Investment Banking portfolio artifact 5 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
- Public sources
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 Investment Banking capstone on full analyst interview deal book using public sources, structured analysis, and a decision-ready output.
Interview talk track
- Problem: explain the business question and why it matters for Investment Banking.
- 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 compsM&A analysisWrite an accretion/dilution note for a public acquisitionCredit analysisPrepare a credit memo with ratios, covenants, and rating drivers
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 accretion/dilution note for a public acquisitionIndustry-ready proof for m&a analysis