Skill project3-7 daysStarter
ABS Waterfall Model - Indian NBFC Securitization
A credit memo or rating note with borrower profile, ratio analysis, risk rating, downside case, and monitoring triggers.
Steps
5
Outputs
7
Excel for waterfall modelCRISIL ABS methodology document (free from crisil.com) as referenceExcel or Google SheetsPowerPoint / Google Slides
Open project workspaceOpen full project briefWhat to do
Scenario
You are working as a Investment Banking. Your manager asks you to use Structured Finance to answer a real business or investment question and present a decision-ready output.
Objective
Show that you can apply Structured Finance in a practical analyst workflow, not only explain the theory.
How to start
- Pick a borrower, issuer, or sector case.
- Collect financials, debt schedule, ratings, business profile, and management commentary.
- Define the lending/rating question and time horizon.
Step-by-step execution
- Analyze revenue quality, margins, leverage, coverage, liquidity, and working capital.
- Identify business, financial, management, and industry risks.
- Run base and stress cases for cash flow and debt servicing.
- Assign an internal risk view or rating direction.
- Write monitoring triggers and early warning signals.
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
- Credit rating rationale
- RBI/SEBI filings where relevant
- Sector data
- Company news and lender disclosures
Quality checklist
- Credit ratios are calculated consistently.
- Cash flow analysis matters more than accounting profit.
- Risk view is supported by evidence.
- Stress case is severe but plausible.
- Memo ends with a clear lend/avoid/watch recommendation.
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 credit memo or rating note with borrower profile, ratio analysis, risk rating, downside case, and monitoring triggers. for Structured Finance, using Excel for waterfall model, CRISIL ABS methodology document (free from crisil.com) as reference to convert raw information into a decision-ready finance output.