Role capstone7-10 focused daysAdvanced
Credit sector outlook
Credit Rating Agencies 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 Credit Rating Agencies analyst. Use public information to produce a decision-ready work product for a manager or interview panel.
Show that you can apply Credit analysis, Financial modeling, Fixed income, Research writing, Indian financial regulation in a practical analyst workflow, not only explain the theory.
What to make
Credit Rating Agencies 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
- Define the business model and key operating drivers.
- Create clean input, historicals, forecast, output, and checks tabs.
- Separate assumptions from formulas.
- Decide base, upside, and downside scenarios before modeling.
Step-by-step execution
- Build historical P&L, balance sheet, and cash flow lines.
- Create drivers for revenue, cost, margin, capex, working capital, and debt.
- Link the statements and add balance checks.
- Create scenario and sensitivity outputs.
- Write a finance-manager style summary with the main movement, risk, and decision required.
Data and sources
- Public filings, official regulatory material, public datasets, company career/domain research, and a documented source log.
- Company annual report
- Quarterly filings
- Investor presentation
- Public industry data
- Synthetic operating dataset if company data is unavailable
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 Credit Rating Agencies capstone on credit sector outlook using public sources, structured analysis, and a decision-ready output.
Interview talk track
- Problem: explain the business question and why it matters for Credit Rating Agencies.
- Method: describe the data collected, assumptions made, and analysis performed.
- Decision: state the recommendation, key risk, and what would change your view.
Linked skills
Financial modelingCreate a three-statement model with scenarios and sensitivity tablesCredit analysisPrepare a credit memo with ratios, covenants, and rating driversFixed incomeAnalyze a bond using duration, convexity, yield, spread, and credit riskResearch writingPublish a concise research note with evidence, charts, and risksIndian financial regulationMap one product or role to SEBI/RBI/NISM compliance obligations
Related projects
Create a three-statement model with scenarios and sensitivity tablesIndustry-ready proof for financial modelingPrepare a credit memo with ratios, covenants, and rating driversIndustry-ready proof for credit analysisAnalyze a bond using duration, convexity, yield, spread, and credit riskIndustry-ready proof for fixed incomePublish a concise research note with evidence, charts, and risksIndustry-ready proof for research writing