Skill project3-7 daysIntermediate
Term Sheet Red-Line - Founder vs. Investor Perspective
A buyout model, debt schedule, returns bridge, investment memo, and IC-style recommendation.
Steps
5
Outputs
7
NVCA model term sheet (free PDF)Word for annotationExcel cap table to model economic impact of each clauseExcel or Google Sheets
Open project workspaceOpen full project briefWhat to do
Scenario
You are working as a Investment Banking. Your manager asks you to use Term Sheet Analysis to answer a real business or investment question and present a decision-ready output.
Objective
Show that you can apply Term Sheet Analysis in a practical analyst workflow, not only explain the theory.
How to start
- Pick a cash-generative company or realistic private-equity target.
- Define purchase price, entry multiple, debt quantum, interest, repayment, and exit cases.
- Build a short transaction overview and investment thesis before the model.
Step-by-step execution
- Build operating forecast and free cash flow.
- Layer purchase accounting and debt schedule.
- Calculate IRR, MOIC, leverage, repayment, and exit sensitivity.
- Identify value creation levers such as growth, margin, working capital, and multiple expansion.
- Write an investment committee memo with risks, mitigants, and final go/no-go.
What to submit
- Brief
- Model or notebook
- Charts or dashboard
- Resume bullet
- Source and assumption log
- One-page executive summary
- Final memo PDF
Data and sources
- Annual report
- Investor presentation
- Credit rating report if available
- Public peer multiples
- News on sponsor deals or sector transactions
Quality checklist
- Sources and uses reconcile.
- Debt schedule is linked to cash flow and covenants.
- Returns bridge clearly shows what drives IRR.
- Downside case is realistic.
- Memo is investor-grade and not only descriptive.
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.
Resume bullet
Built a a buyout model, debt schedule, returns bridge, investment memo, and ic-style recommendation. for Term Sheet Analysis, using NVCA model term sheet (free PDF), Word for annotation, Excel cap table to model economic impact of each clause to convert raw information into a decision-ready finance output.