📌 What You Need:
- ChatGPT (Free or Plus – Plus preferred for large models and detailed reports)
- Excel or Google Sheets
- Access to financial databases (e.g., Screener.in, NSE India, RBI Bulletin, TradingView)
- Optional: SEBI, MCA, RBI, or GST portal links for compliance/reference
📊 1. Financial Modeling
Goal: Generate multi-sheet financial models and forecasting frameworks.
Prompt Example:
“Create a 5-year financial projection model for a fast-growing Indian D2C startup selling organic tea.”
ChatGPT Provides:
- Revenue breakdown by channel
- COGS, OPEX, EBITDA
- Cash flow forecasts
- Assumptions tab
- Excel formula structure (growth %, YoY, CAGR)
🧮 Follow-up:
“Add sensitivity analysis for CAC and retention rates.”
🏦 2. Investment Research
Goal: Analyze company fundamentals and market environment.
Prompt Example:
“Summarize the financial performance of Infosys for the last 3 years using key ratios.”
ChatGPT Gives:
- Revenue, profit growth
- Operating margin trends
- ROCE, ROE, PE ratio, EV/EBITDA
- Sector benchmarks
📈 Bonus:
“List key risks and opportunities for IT services exports from India.”
⚠️ 3. Risk Assessment
Goal: Identify portfolio or corporate financial risks and hedge options.
Prompt Example:
“Evaluate the currency risk for an Indian exporter billing in USD and suggest hedging strategies.”
ChatGPT Delivers:
- Risk exposure analysis
- Options like forward contracts, options, or natural hedging
- Sample hedge accounting entry
💼 Also try:
“Assess credit risk for a mid-cap NBFC lending to SMEs.”
🧾 4. Regulatory Reporting
Goal: Generate SEBI- or RBI-compliant reporting formats.
Prompt Example:
“Draft a regulatory compliance report for a listed NBFC under SEBI’s LODR Regulations.”
ChatGPT Provides:
- Section-wise breakdown (Board meetings, Related Party Transactions, Auditor info)
- Required attachments and disclosures
- Format aligned with SEBI templates
📋 Ask:
“List mandatory RBI filings for a Category II AIF fund in India.”
🧮 5. Budget Planning
Goal: Build department- or org-level budgets and variance analyses.
Prompt Example:
“Create an annual budget template for a manufacturing company with cost centers like procurement, R&D, marketing, and HR.”
ChatGPT Gives:
- Monthly and quarterly breakdown
- Fixed vs. variable costs
- Budget vs. actual variance column with formulas
- Graphs for visualization
📊 Bonus:
“Add a dashboard to highlight departments exceeding budgets.”
💰 6. Cash Flow Analysis
Goal: Manage liquidity and working capital needs.
Prompt Example:
“Analyze the cash flow of a B2B SaaS firm with long receivables cycle.”
ChatGPT Outputs:
- Cash conversion cycle
- Operating cash flow insights
- Recommendations: invoice factoring, contract restructuring, payment discounts
🧾 Bonus:
“Generate a 13-week cash flow forecast template in Excel.”
📉 7. Valuation Models
Goal: Build company valuation frameworks.
Prompt Example:
“Create a DCF model for Reliance Retail with projected FCF, WACC, and terminal value.”
ChatGPT Delivers:
- FCFF forecast
- WACC calculation based on cost of equity and debt
- Terminal value using perpetuity method
- Implied valuation and sensitivity table
📊 Add-on:
“Create a comparable company table with Indian retail firms like Trent, DMart, Spencer’s.”
📈 8. Market Research
Goal: Interpret macroeconomic and industry trends.
Prompt Example:
“Summarize current RBI monetary policy stance and its impact on credit growth.”
ChatGPT Provides:
- Repo rate and inflation outlook
- Impact on NBFCs and banks
- Market sectors positively/negatively affected
📚 Try also:
“Compare growth outlook of FMCG vs. pharma sector in India for FY26.”
🇮🇳 India-Specific Enhancements
🧾 9. Income Tax & GST Simulations
“Estimate the tax liability for an Indian salaried individual earning ₹24L/annum under both old and new regimes.”
📉 10. Screener-Based Research
“Give a peer comparison of PE, ROE, and promoter holding for Tata Elxsi, L&T Tech, and KPIT.”
🧭 Summary Cheatsheet
| Task | How ChatGPT Helps |
|---|---|
| 📊 Financial Modeling | Projections, Excel templates, ratio modeling |
| 🏦 Investment Research | Company summaries, ratio analysis, market dynamics |
| ⚠️ Risk Assessment | Credit/market risk analysis, forex exposure, hedge options |
| 🧾 Regulatory Reporting | Format-based SEBI/RBI/MCA reports with checklists |
| 🧮 Budget Planning | Excel budgets with cost centers, variance columns, visuals |
| 💰 Cash Flow Analysis | Liquidity planning, CCC insights, cash forecast templates |
| 📉 Valuation Models | DCFs, comparables, precedent transactions |
| 📈 Market Research | Macro analysis, RBI trends, sector studies |