Role capstone5-7 focused daysAdvanced
Cap table and dilution model
Venture Capital portfolio artifact 4 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 Venture Capital analyst. Use public information to produce a decision-ready work product for a manager or interview panel.
Show that you can apply Deal sourcing, Unit economics, Fundraising and cap tables, Investment memo writing, Finance product management in a practical analyst workflow, not only explain the theory.
What to make
Venture Capital portfolio artifact 4 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
- PowerPoint / Google Slides
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 Venture Capital capstone on cap table and dilution model using public sources, structured analysis, and a decision-ready output.
Interview talk track
- Problem: explain the business question and why it matters for Venture Capital.
- Method: describe the data collected, assumptions made, and analysis performed.
- Decision: state the recommendation, key risk, and what would change your view.
Linked skills
Deal sourcingCreate a sector target list with screening logic and outreach notesInvestment memo writingWrite a 2-page investment committee memo for a deal or stockFinance product managementWrite a PRD for a fintech feature with metrics and risksUnit economicsModel contribution margin, CAC payback, and LTV for a startupFundraising and cap tablesCreate a startup cap table with dilution and option pool scenarios
Related projects
Create a sector target list with screening logic and outreach notesIndustry-ready proof for deal sourcingWrite a 2-page investment committee memo for a deal or stockIndustry-ready proof for investment memo writingWrite a PRD for a fintech feature with metrics and risksIndustry-ready proof for finance product managementModel contribution margin, CAC payback, and LTV for a startupIndustry-ready proof for unit economics