0% found this document useful (0 votes)
92 views66 pages

Equity Analysis and Insights Guide

The document provides instructions for analyzing various financial documents and reports, including equity research, annual reports, conference calls, and IPOs. It emphasizes the importance of clarity, precision, and structured analysis while assessing financial health, management commentary, and market trends. Additionally, it offers prompts for forensic accounting and sentiment analysis, guiding users to extract actionable insights and identify potential risks.

Uploaded by

vedant.rajmane
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
92 views66 pages

Equity Analysis and Insights Guide

The document provides instructions for analyzing various financial documents and reports, including equity research, annual reports, conference calls, and IPOs. It emphasizes the importance of clarity, precision, and structured analysis while assessing financial health, management commentary, and market trends. Additionally, it offers prompts for forensic accounting and sentiment analysis, guiding users to extract actionable insights and identify potential risks.

Uploaded by

vedant.rajmane
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Please note that our docs are available for viewing only.

To make your own copy:


“File” option > “Make a copy” > Save the file to your Google Drive.
You'll be able to edit your own copy of the doc and also have access to
our original data for reference.

Bonus:
AI Course subscribers can join our SOIC Membership with our coupon
code: SOICAI to receive Rs. 2,000 off.
Rs. 13,000 for 1 year and Rs. 27,999 for 3 years.
SOIC Membership: [Link]
SOIC Membership Brochure: here

For Equity Research remember this while Giving Prompts

1. Define role for the AI:


You are a world class Equity analyst, You are a top Forensic expert, You are a fund
manager at world’s best fund, You specialise as an Equity analyst in comparing
peers

OR

2. Define your own role: I am a novice in Finance and want to understand the
balance sheet, Explain this to me as if I am a 12 year old

3. Be as precise as possible with your instructions

4. In the end use sentences like:

A) Positive reinforcement: I will reward you if you do this task well

B) Put the onus on LLM: Can I trust you to do this?

C) If you have any questions related to this specific task or need any further
information, feel free to ask them
Financial Statements of Business in 2 mins

“You are a world class Equity analyst who specialises in understanding and doing
Financial statement analysis of a Business well.”
I have given you an Image/PDF above.
Analyse the following points well between 2021- till the latest data.

1. Does the company have a weak or a strong balance sheet?


2. How are the key Leverage ratios (Debt/equity, Cash flow/Ebitda, Debt/Ebitda) like
of the business over the years? Does it show improvement or is it weakening?
3. Are the cash flows strong or weak over the time period?
4. Can the company fund its growth using internal accruals?
5. How are the growth rates of the company in terms of Sales/Profits over the time
period?
6. How is the Cash flow from operations compared to Net profits. Is the company
converting its profits into cash flows?
7. How are the Profitability ratios of the business over the time period? (ROE,
ROCE)
8. Has the company been able to maintain its margins during the time period?
9. Do a Pitrioski score on the basis of Data I have given you
Give me the answer in a crisp & easy to understand form
I will reward you if you do it well and you can ask me specific questions before you
proceed to do the task.

Annual Reports Prompts

You are a world class Equity analyst who specialises in understanding and doing
Annual report analysis of a Business well

Analyse the following data from the CCL's 2024 annual report based on the following
pointers:

● Summary of MD, Chairman, CEO, CFO letters covering key business


highlights, potential opportunities, weaknesses and overall business strategy

● Key highlights mentioned regarding industry growth and key industry triggers
and trends
● Related Party transactions of the company

● Contingent liability of the company

● Miscellaneous expenses as a % of revenue

● Any future capex plans or commercialisation of the capex done in the past

● Is there any concerning Auditor note or any qualified opinion on the company

● Any aggressive accounting policies used by the company

● Management remuneration summary - Also give it as % of revenue. Also find


if the remuneration is linked to the PAT and how it moves down a year.

● Any KMP resignations

● Is the business walking the talk in terms of execution

● Also do a detailed governance check on management and company through


this annual report

● Give me the answer in a crisp & easy to understand form

● Summarise your key findings in a conclusion in the end

I will reward you if you do it well and you can ask me specific questions before you
proceed to do the task.

Analyse Concalls in Depth

I am going to give you a conference call transcript, you being my senior analyst have
to analyse it. I am a fund manager, and this is one of our portfolio companies.
Provide a detailed and comprehensive analysis of the discussion, structured as
follows:

Instructions:

• Be factual and comprehensive. Avoid assumptions or unsupported inferences.


• Prioritize the most critical points in each section.
• For industry- and company-specific details, focus on providing a deep explanation
of the topics discussed (do not summarize). Ensure clarity and depth in your
explanation to help me fully understand management’s perspective.

1. Executive Summary
Provide a concise summary of the call, highlighting:
• Overall performance
• Key topics discussed
• Management’s tone and sentiment

2. Detailed Analysis
Develop each point with supporting evidence from the transcript:
• Business Model Evolution:
Analyze changes, revenue impact, cost structure, working capital, and competitive
positioning.
• Industry Operating Environment:
Analyze industry cycles, regulatory changes, or technological disruptions.
• Management's Tone and Sentiment:
Identify shifts or inconsistencies in tone and sentiment.
• Key Business Insights:
Highlight critical insights into the business and its environment.
• Qualitative and Quantitative Guidance:
Analyze guidance, focusing on industry-specific metrics.
• Key Performance Indicators (KPIs):
Examine trends, expectations, and drivers for KPIs.
• Capital Allocation Strategy:
Assess management’s plans and rationale for capital deployment.

3. Industry and Company Specific Details


Fully explain the industry and company specific details shared during the call.
Instead of summarizing, provide a clear, in-depth explanation of the following, also
point out whatever you think was very interesting and helpful insight within this
section:
● Industry-Specific Insights:
● Discuss any commentary about the broader industry environment, including:
Market trends
● Competitive landscape and positioning
● Regulatory or policy changes affecting the industry
Economic or geopolitical factors impacting the sector
● Supply chain dynamics or disruptions
● Company-Specific Insights:

Explain any company-specific details discussed, including:


● Operational challenges or opportunities
● Strategic priorities or initiatives unique to the company
● Customer demand trends, order flows, or client-specific updates
● Management's Thought Process:

Analyze how management contextualized these industry and company dynamics,


including their strategy to navigate challenges or capitalize on opportunities.

4. Forward-Looking Statements and Guidance


Provide a detailed analysis of management’s forward-looking statements and
guidance, including:
● Revenue Expectations:
Commentary on future revenue growth, including specific quantitative
guidance or targets (if provided).
● Margin Expectations:
Management’s view on gross, operating, and net margins, including potential
pressures or improvements.
● Growth Drivers:
Insights into organic growth, market expansion, product pipeline, cross-selling
opportunities, or new markets.
● Profit After Tax (PAT):
Management’s PAT guidance, key drivers, and any notable shifts or trends.
● Quantitative Guidance:
Highlight all forward-looking quantitative data provided during the call (e.g.,
revenue growth rates, EBITDA margins, cost guidance).
● Recovery and Growth Expectations:
Analyze management’s commentary on recovery timelines and “greenshoots.”
Address:
● Expected timing for recovery or growth acceleration.
● Management’s confidence levels in achieving these timelines.
● Factors contributing to recovery (e.g., demand rebound, cost optimization,
regulatory changes).

5. Risk Assessment
Provide a thorough risk analysis, covering:
● Competitive threats
● Regulatory challenges
● Technology disruption
● Execution risks
● Market-specific risks

Note: This section is critical. Prioritize a deep analysis with supporting evidence.

6. Comparison to Peers
Compare the company’s performance, growth outlook, and any specific mention
about competitions.
7. Long-Term Strategy
Discuss the long-term vision and how the call’s information aligns with it.

8. Analyst Q&A
Provide a detailed account of the Q&A session:
• Key Questions and Responses:
For each key question, clearly state the question, the analyst who asked it, and
management's complete response.
• Recurring Themes:
Highlight recurring questions or concerns raised by analysts and management’s
responses.
• Dodged/Partial Answers:
Flag any incomplete responses, speculate on potential reasons, and note
implications.
• Follow-Up Questions:
Suggest follow-up questions for areas needing clarification.
• Margin Analysis:
Analyze margins and profitability drivers across business segments, including
management's strategies for addressing margin pressures.

9. Quantitative Data
Provide a table summarizing key quantitative data points, their source, and
significance. Ensure accuracy and context.

10. Key Insights Table


Summarize critical takeaways in a table:
• Key Insight | Impact (Positive/Negative) | Evidence from the Call

11. Connecting the Dots


Integrate points from the discussion into the broader narrative, highlighting
connections between management’s messaging and financial/strategic implications.

12. Who were the Analysts on Call (name and firm name)

Analyse Concalls in Brief


You are a financial research assistant analyzing a company’s earnings conference
call transcript. Your task is to extract all critical information objectively, without using
external data or prior assumptions. Use only the content and tone of the transcript to
produce a comprehensive summary and a reasoned investment stance. Follow the
structure below strictly. Analyse the attached con-call.
Output Format:

1. Management Commentary:
● Key statements from leadership (CEO, CFO)
● Tone, clarity, and confidence of responses
● Areas of focus or concern emphasized

2. Future Outlook and Guidance:


● Forward-looking statements on revenue, margins, or volume
● Demand visibility or uncertainties
● Qualitative or quantitative projections

3. Industry and Macro Trends:


● Management commentary on industry growth, cyclicality, or regulation
● Any broader economic observations (cost, demand, inflation, etc.)
4. Competitive Landscape / Peer Comparison:
● Any mentions or implications of performance vs. competitors
● Positioning, pricing power, or strategic differentiation

5. Risks and Concerns:


● Raw material, forex, regulatory, customer churn, etc.
● Management warnings or cautious statements
● Anything repeated across multiple responses

6. Growth Drivers and Strategic Initiatives:


● New product lines, geographies, services, partnerships
● Cost efficiency programs, technology adoption
● Capex plans, innovation, or M&A activity

7. Product Mix and Portfolio Trends:


● Volume/value shift, premiumization, diversification
● New launches and category performance

8. Financial Highlights (if disclosed):


● Revenue, EBITDA, net profit, margins (brief only)
● Debt, working capital, cash flow commentary

9. Sentiment Analysis:
● Overall tone of the call: Positive / Neutral / Negative
● Confidence level: High / Moderate / Low
● Any notable shift from prior con-calls (based on language used)

Give me a brief conclusion at the end which summarises all key pointers
Credit: Shared by one of our tribe members, Mayank Bajpai

DU Pont Analysis Prompt


You are an expert Financial analyst who specialises understanding financial
statement analysis.

Use the following Link for data: [Link]

Analyse the ROE of the company and do a detailed DU Pont analysis in such a way
that a 15 year old kid can understand.
Break down the ROE and simplify what is driving the ROE out of all the 3 parts of Du
Pont.

USE data between FY21-FY25. Treat MARCH 2025 as FY25.

Please ask me any questions that you have before starting.

Sentiment Analysis Prompt


You are an expert financial analyst in the Indian Diagnostics sector who tracks each
and every result within the industry.

Go through the Q4FY25 concalls of Dr. Lal Pathlabs, Thyrocare, Metropolis, Krsnaa
Diagnostics, Vijaya Diagnostics & Suraksha Diagnostic

Make a table on their Growth guidance and do a sentiment analysis along with a
comparison on their FY24-FY25 performance

If you have any specific questions. Please ask.

IPO DRHP Prompts

Prompt for DRHP reading and extracting key info

You're a financial analyst with expertise in IPO and equity research. I will provide you
with a Draft Red Herring Prospectus (DRHP) of a company. Your task is to extract
and
summarize the most relevant and actionable insights. Please provide detailed
responses under the following sections:

1. Business Overview
Summarize the company’s core business activities, products/services, revenue
streams, and geographical reach.

2. Industry & Market Overview


Highlight industry trends, growth potential, competition, market size and market
share of the industry as described in the DRHP.

3. Objects of the Issue


Clearly list how the IPO proceeds will be used (e.g., debt repayment, expansion,
working capital, OFS).

4. Financial Highlights (Last 3 years)


Revenue EBITDA & EBITDA margin Net profit & margin Cash from operations EPS
(Earnings per share) Return Ratios (ROE, ROCE)

5. Cash Flow Analysis


Summarize trends in operating, investing, and financing cash flows. Flag any
mismatches between profits and cash flow.

6. Risk Factors
List the most critical and specific risks that could impact business or
investor interests.

7. Promoter & Management Analysis


Names and background of promoters Promoter holding (pre and post IPO) Any past
legal, regulatory, or financial controversies

8. Related Party Transactions


List major related party dealings and comment if they seem abnormal or conflict-
prone.

9. Peer Comparison & Valuation


Compare revenue, margins, and valuation multiples
(P/E, P/B, EV/EBITDA) Is the IPO pricing fair compared to peers?

10. Red Flags (If Any)


Identify and explain any of the following:
● Negative cash flows with positive profits
● Sudden profit spike before IPO
● Large OFS component
● Auditor qualifications or change Heavy dependence on few clients
● Legal proceedings
● Please structure the answer clearly using bullet points or headers for each
section.
● Flag any potential fraud risks or governance concerns clearly

Forensic Accounting Prompts


You are a forensic accounting expert who specialises in detecting accounting fraud,
and earnings manipulation. I am attaching an annual report for you to do thorough
analysis (use consolidated financials).

Your goal is to conduct a detailed forensic check, examining the financial statements
and disclosures for potential red flags that might indicate red flags in accounting,
fraudulent accounting and earnings manipulation. Please make your analysis as
follows:

1. Brief Summary
Pointers on your key findings and a checklist based on green/yellow/red indicating
accounting quality.

2. Revenue Recognition Analysis


Aggressive revenue recognition practices, working capital analysis, channel stuffing.

3. Cash Flow Discrepancies


Compare the cash flows with PAT and EBITDA, and see if earnings are being
converted into cash flows or not, triangulate with debt on the balance sheet.

4. Related Party Transactions


Provide details of all major RTPs, and highlight RTPs that seem suspicious, check
for loans given to related parties.

5. Do a thorough check of the Balance Sheet


Any write offs of assets or equity, inventory concerns, receivables aging, loans to
other parties.

6. Check the contingent liabilities and compare it with Net-worth


If contingent liabilities size is 10% higher than the net-worth, flag it as a major red
flag, also flag any major court cases/litigations.
7. Do a check on Miscellaneous expenses and flag out any expenses which
seem suspicious.
See how much Miscellaneous expenses are as a % of sales. If it is higher than 3%,
flag it out.

8. Management Discussion Analysis


Are any inconsistencies related to the guidance and financial metrics, or any other
warning signs related to slowing growth?

9. Check the Auditors report and read the CARO report carefully.
Check the Key Audit matters and see if the Auditor's opinion is Qualified or
Unqualified. Assign a Green/Yellow/Red flag on the basis of Auditors Observations.

For each identified red flag, please:


• Quote the specific section, page number, and language from the annual report
• Explain why this represents a potential concern
• Quantify the financial impact where possible
• Make a checklist with Green (indicating clean), Yellow (indicating amber), Red
(Indicating red) on all the points given above. Give the company a score in the end
on the basis of
Accounting Quality: Good, Average, Bad.

Avoid speculation without evidence. Your analysis should solely rely on information
contained within the document.

Use precise accounting terminology while making your explanations accessible.


Simply to understand any potential red flags. Signal out the pints which require
further investigation.

The idea is to understand the accounting quality and not to label everything as a
fraud.

If you need any clarifications or require additional context to complete your analysis,
please ask specific questions. I will reward you if you do the task well.

P2P Analysis
You are an expert financial analyst in the Indian Diagnostics sector who tracks each and
every result within the industry.

Go through the Q4FY25 concalls of Dr. Lal Pathlabs, Thyrocare, Metropolis, Krsnaa
Diagnostics, Vijaya Diagnostics & Suraksha Diagnostic.
Make a table on their Growth guidance and do a sentiment analysis along with a comparison
on their FY24-FY25 performance. If you have any specific questions, please ask.

Financial Statement Analysis Prompts

“You are a world class Equity analyst who specialises in understanding and doing
Financial statement analysis of a Business well.”

I have given you an Image/PDF above.


Analyse the following points well between 2021- till the latest data
1. Does the company have a weak or a strong balance sheet?
2. How are the key Leverage ratios (Debt/equity, Cash flow/Ebitda, Debt/Ebitda) like
of the business over the years? Does it show improvement or is it weakening?
3. Are the cash flows strong or weak over the time period?
4. Can the company fund its growth using internal accruals?
5. How are the growth rates of the company in terms of Sales/Profits over the time
period?
6. How is the Cash flow from operations compared to Net profits. Is the company
converting its profits into cash flows?
7. How are the Profitability ratios of the business over the time period? (ROE,
ROCE)
8. Has the company been able to maintain its margins during the time period?
9. Do a Pitrioski score on the basis of Data I have given you.

Give me the answer in a crisp & easy to understand form. I will reward you if you do
it well and you can ask me specific questions before you proceed to do the task.
Annual Report Prompt

You are a world class Equity analyst who specialises in understanding and doing Annual
report analysis of a Business well.

Analyse the following data from the CCL's 2024 annual report based on the following
pointers:
● Summary of MD, Chairman, CEO, CFO letters covering key business
highlights, potential opportunities, weaknesses and overall business strategy
● Key highlights mentioned regarding industry growth and key industry triggers
and trends
● Related Party transactions of the company
● Contingent liability of the company
● Miscellaneous expenses as a % of revenue
● Any future capex plans or commercialisation of the capex done in the past
● Is there any concerning Auditor note or any qualified opinion on the company
● Any aggressive accounting policies used by the company
● Management remuneration summary - Also give it as % of revenue. Also find
if the remuneration is linked to the PAT and how it moves down a year
● Any KMP resignations
● Is the business walking the talk in terms of execution
● Also do a detailed governance check on management and company through
this annual report
● Give me the answer in a crisp & easy to understand form
● Summarise your key findings in a conclusion in the end

I will reward you if you do it well and you can ask me specific questions before you
proceed to do the task.

Forensics Prompt

You are a forensic accounting expert who specialises in detecting accounting fraud,
and earnings manipulation. I am attaching an annual report for you to do thorough
analysis (use consolidated financials).

Your goal is to conduct a detailed forensic check, examining the financial statements
and disclosures for potential red flags that might indicate red flags in accounting,
fraudulent accounting and earnings manipulation. Please make your analysis as
follows:
1. Brief Summary (Pointers on your key findings and a checklist based on
green/yellow/red indicating accounting quality).

2. Revenue Recognition Analysis (Aggressive revenue recognition practices, working


capital analysis, channel stuffing).

3. Cash Flow Discrepancies (compare the cash flows with PAT and EBITDA, and
see if earnings are being converted into cash flows or not, triangulate with debt on
the balance sheet).

4. Related Party Transactions (Provide details of all major RTPs, and highlight RTPs
that seem suspicious, check for loans given to related parties).

5. Do a thorough check of the Balance Sheet (Any write offs of assets or equity,
inventory concerns, receivables aging, loans to other parties).

6. Check the contingent liabilities and compare it with Net-worth (If contingent
liabilities size is 10% higher than the net-worth, flag it as a major red flag, also flag
any major court cases/litigations).

7. Do a check on Miscellaneous expenses and flag out any expenses which seem
suspicious. See how much Miscellaneous expenses are as a % of sales. If it is
higher than 3%, flag it out.

8. Management Discussion Analysis: are any inconsistencies related to the guidance


and financial metrics, or any other warning signs related to slowing growth).

9. Check the Auditors report and read the CARO report carefully. Check the Key
Audit matters and see if the Auditor's opinion is Qualified or Unqualified. Assign a
Green/Yellow/Red flag on the basis of Auditors Observations.

For each identified red flag, please:


• Quote the specific section, page number, and language from the annual report
• Explain why this represents a potential concern
• Quantify the financial impact where possible
• Make a checklist with Green (indicating clean), Yellow (indicating amber), Red
(Indicating red) on all the points given above. Give the company a score in the end
on the basis of Accounting Quality: Good,Average, Bad.

Avoid speculation without evidence. Your analysis should solely rely on information
contained within the document.
Use precise accounting terminology while making your explanations accessible.
Simply to understand any potential red flags. Signal out the pints which require
further investigation.

The idea is to understand the accounting quality and not to label everything as a
fraud.
If you need any clarifications or require additional context to complete your analysis,
please ask specific questions. I will reward you if you do the task well.

IPO DRHP Analysis Prompts

Prompt for DRHP reading and extracting key info.

You're a financial analyst with expertise in IPO and equity research. I will provide you
with a Draft Red Herring Prospectus (DRHP) of a company. Your task is to extract
and summarize the most relevant and actionable insights. Please provide detailed
responses under the following sections:

1. Business Overview Summarize the company’s core business activities,


products/services, revenue streams, and geographical reach.

2. Industry & Market Overview Highlight industry trends, growth potential,


competition, market size and market share of the industry as described in the DRHP.

3. Objects of the Issue Clearly list how the IPO proceeds will be used (e.g., debt
repayment, expansion, working capital, OFS).

4. Financial Highlights (Last 3 years) Revenue EBITDA & EBITDA margin Net profit
& margin Cash from operations EPS (Earnings per share) Return Ratios (ROE,
ROCE)

5. Cash Flow Analysis Summarize trends in operating, investing, and financing cash
flows. Flag any mismatches between profits and cash flow.

6. Risk Factors List the most critical and specific risks that could impact business or
investor interests.

7. Promoter & Management Analysis Names and background of promoters Promoter


holding (pre and post IPO) Any past legal, regulatory, or financial controversies.

8. Related Party Transactions List major related party dealings and comment if they
seem abnormal or conflict-prone.

9. Peer Comparison & Valuation Compare revenue, margins, and valuation multiples
(P/E, P/B, EV/EBITDA) Is the IPO pricing fair compared to peers?

10. Red Flags (If Any) Identify and explain any of the following:
● Negative cash flows with positive profits
● Sudden profit spike before IPO
● Large OFS component
● Auditor qualifications or change Heavy dependence on few clients
● Legal proceedings
● Please structure the answer clearly using bullet points or headers for each
section.
● Flag any potential fraud risks or governance concerns clearly

P2P Analysis Prompts

You are an expert financial analyst in the Indian Diagnostics sector who tracks each
and every result within the industry.
Go through the Q4FY25 concalls of Dr. Lal Pathlabs, Thyrocare, Metropolis, Krsnaa
Diagnostics, Vijaya Diagnostics & Suraksha Diagnostic.
Make a table on their Growth guidance and do a sentiment analysis along with a
comparison on their FY24-FY25 performance.
If you have any specific questions please ask.

DU PONT ROE Prompt

You are an expert Financial analyst who specialises understanding financial


statement analysis.
Use the following Link for data: [Link]
Analyse the ROE of the company and do a detailed DU Pont analysis in such a way
that a 15 year old kid can understand.
Break down the ROE and simplify what is driving the ROE out of all the 3 parts of Du
Pont.
USE data between FY21-FY25. Treat MARCH 2025 as FY25.
Please ask me any questions that you have before starting.
Finding Growth Triggers (One Pager Prompt):
10 Pointer Growth Checklist

You are an expert Equity Analyst who works at a world class equity research firm.
You specialise in creating a checklist of growth triggers based on fundamental
analysis along with a one paragraph reasoning.

I am attaching the key documents (annual reports, concalls, credit ratings, equity
reports, you can even go through management interviews,you can find reports from
the free equity group on telegram as well here: [Link]/researchreportss for brokerage
models and initiation coverage,
[Link] of AARTI
Pharmalabs. Create the checklist on the basis of following pointers:

1. Growing TAM for the industry & value migration trend

2. Is there a presence of operating leverage?

3. Is the company climbing up the value chain? (forward integration or value added
products)

4. How much is the company investing in expanding? (Capex plans: brownfield or


others. Any M&A plans)

5. Is the company expanding geographically?

6. Any new products or business segments being launched?

7. Is the company going through deleveraging? (Say Yes only if substantial debt is
going to be repaid)

8. Is there any corporate action coming up in the business like fund raise,
demergers, warrants or anything else. Is there any corporate action coming up in the
business like fund raise, demergers, warrants or anything else. Has there been any
mergers, acquisitions or strategic stake investments?

9. Has there been a management change and the new management is driving the
changes in the business?

10. Is the order book of the company expanding (Only valid for businesses with an
order book based KPI. Ignore if it is irrelevant for the specific business mentioned
above)
If you have any questions, please specify them. The pure purpose of this analysis is
for you to give me a checklist of growth triggers mentioned above. In the end give
me a conclusion on what are the key growth triggers/metrics I should track in this
business along with the likelihood scenario of the growth panning out or not.
(Make sure your answer is forward looking and you can even use data that is outside
the resources I have given you).

Do the task the way a world class experienced equity analyst will do. If you do it well,
I will reward you by using even more CHAT GPT.

Fundamental Checklist for Thesis Building/Risk reward analysis


(One Pager)

You are a fundamental equity research analyst preparing a professional-grade,


forward-looking investment report on Shivalik Bi Metals.

Your goal is to use only the latest available data (Q4FY25 or TTM), recent investor
presentations, and sector-specific valuation frameworks to arrive at a structured
investment thesis.

Avoid outdated metrics and focus on what drives the next 2–3 years of value
creation.

Structure the report as follows:

1. Company Snapshot
● Briefly describe what the company does
● Break down revenue by segment, geography, and product line
● Classify the business as B2B, B2C, or hybrid
● Note key customers, manufacturing footprint, distribution reach
● Mention promoter group, ownership structure, and group companies if
applicable

2. Business Model and Industry-Specific Unit Economics


● Explain how the company earns its money
● Use industry-specific KPIs to explain business economics
● Examples:
○ Cement: Realisation per tonne, cost per tonne
○ Hospitals: ARPOB, Occupancy rate
○ Chemicals: Contribution margin per kg, capacity utilization
○ AMC: AUM mix, Yield on AUM
○ Retail: SSSG, Gross margin per sq ft
● Focus on gross margin drivers, working capital cycle, and fixed cost leverage

3. Growth Drivers and Key Catalysts


● List near-term and structural growth triggers
● Highlight order book strength, plant expansion, new product launches
● Mention macro drivers: infra push, consumption shift, policy support
● Track management guidance and whether it’s credible
● Use Q4FY25 earnings call and investor deck to extract forward-looking
triggers

4. Industry Positioning and Competitive Edge


● Map the company’s standing in its sector
● Is it a volume leader, margin leader, or niche specialist
● Benchmark vs peers on size, cost, ROCE, and innovation
● Highlight moats: distribution, brand, cost advantage, contracts, or R&D
● Mention whether competition is local, global, or fragmented

5. Valuation – Based on Industry-Relevant Metrics Only


● Use valuation metrics that are relevant to the sector
● Examples:
○ EV/EBITDA for industrials, B2B
○ EV/Tonne for cement
○ Price/AUM for AMCs
○ EV/Bed for hospitals
● EV/Sales or Price/Sales for emerging tech or D2C
● Compare current valuation to 5-year average and peer group
● Indicate whether stock is pricing in full growth or has scope for re-rating

6. Financial Summary (Use Q4FY25 or TTM Only)


● Show Revenue, EBITDA, PAT CAGR (3 or 5 years)
● Mention margin trends, working capital days, inventory turns
● Capex plans vs FCF generation
● ROCE vs WACC to indicate capital efficiency
● Balance sheet health: net debt, D/E ratio, interest coverage
● Comment on cash flows vs accruals

7. Risk Assessment
● Mention both sectoral and company-specific risks
● Customer concentration or cyclicality
● Raw material or currency volatility
● Execution risks in expansion
● Regulatory overhang (NLEM, pollution norms, pricing caps)
● Corporate governance, promoter pledging, or opaque disclosures
● Tech disruption or import substitution where applicable

8. Investment Checklist
● Factor Yes or No Comment
● Clear structural growth driver Infra, policy, consumption shift etc
● Margin expansion tailwind Cost leverage or better product mix
● Capital efficiency ROCE > Cost of Capital
● Clean balance sheet Low net debt or positive FCF
● Attractive valuation Below 5Y average or peer discount
● Execution credibility Management has met past guidance
● No material governance red flag Clean auditor history, disclosures, pledging
● Moat or entry barrier Brand, cost, distribution, IP

9. Bull, Base, Bear Case Scenarios – Quantified and Realistic


● Build three forward-looking scenarios with reasonable assumptions
● Use industry KPIs and FY26E–27E drivers to project margins, growth, and
ROCE
● Avoid artificial optimism or outdated assumptions
● Example (for cement):
○ Bull: Realisation up 6%, capacity addition ahead of plan, EBITDA/tonne
₹1200
○ Base: Volume CAGR 7%, stable RM cost, EBITDA/tonne ₹950
○ Bear: Demand slows, pricing war resumes, EBITDA/tonne ₹750
● Include implied upside/downside vs current market price for each case
● Use valuation re-rating as a lever in the Bull case only if justified.

10. Management Commentary (Optional)


● Summarize tone from latest concall or investor update
● Highlight confidence triggers: “doubling capacity,” “margin levers in play,” etc
● Note tone shifts – from expansionary to cautious or vice versa
● Mention any red flags or guidance downgrades

11. Conclusion
● Frame the company as one of the following:
● A secular compounder with earnings visibility
● A turnaround with optionality
● A cyclical near the bottom/top of the cycle
● Fully valued, with limited room for surprises
● Clearly state what would make the stock re-rate or underperform

Data Sources to Use


● Q4FY25 earnings call transcript and investor presentation
● [Link] for updated ratios and cash flow data
● [Link]/researchreportss for brokerage models and initiation coverage
● Credit rating reports (CRISIL, ICRA) for capex and debt outlook
● Company annual report and investor day decks
● Regulatory filings and SEBI disclosures
● YouTube or CNBC interviews for management intent

Important:
● Use the most recent data available. Do not rely on FY24 unless it is the latest
available.
● Prioritize FY25 run-rate, TTM, or Q4 commentary to stay relevant.
● All financial modeling and valuation must align with the company's sector
norms.

Technical Analysis: Dow Theory, Stage Analysis

You are an expert technical analyst who works at a world class investing firm. You
are analysing medium to long term investors and judge the given stock on a weekly
timeframe.

Analyse the XYZ stocks technicals on the following parameters:

1. Dow theory:
What is the Dow theory indicating?
Is the stock in primary/secondary uptrend or downtrend?

2. Stage analysis as per Stan Weinstein


Is the stock entering stage 2 on back of increasing relative strength?
Is the 30 WEMA rising?

3. Is there any noticeable increase in volumes along with the rising price? What is
the Price volume signal indicating?

4. Check if relative strength vs Nifty 50, Nifty 500 and the sector the company
operates in is rising or falling?

5. What is the possible resistance on the weekly chart? What are the potential
support areas?

6. Suggest entry pointers on the basis of:


A. Chart patterns like ascending triangle, cup and handle, flat base breakout etc.
B. Alternate entry on a low-volume pullback to support levels or moving
averages (10W or 30W MA)
C. Entry pointers on the basis of continuation buying or any possible signs of
reversal
D. Vstop turning positive

7. Suggest a stop-loss level based on recent swing lows, moving averages, or chart
structure.
A. Highlight clear exit signals such as:
B. Breakdown below the 30-week MA on strong volume or VSTOP turning
Negative
C. Loss of relative strength and sideways price action
D. Signs of transition into Stage 3 distribution

Create a table/checklist of all the pointers mentioned above


If you have any questions please specify. I will reward you if you do the task well.

LTI Prompt

Please analyze XYZ Stock on the weekly timeframe from a long-term technical
investing perspective. I am providing the following key chart overlays:

30-week exponential moving average (30-WEMA)

Weekly volume data

SOIC Long Term Indicator (LTI) with VSTOP, RSI, ADX, and CRS modules
(Explanation of the SOIC LTI is included below)

1. Stage 2 Breakout Confirmation (Stan Weinstein framework):


Has the stock broken out above a valid base?
● Is the 30-WEMA clearly rising and supporting the trend?
● Was the breakout accompanied by a significant increase in weekly volume?

2. Relative Strength vs Nifty 50:


● Check if the stock is outperforming Nifty 50 using the CRS (Comparative RS)
from the LTI tool
● Is the RS line making new highs and above its 52-week moving average?

3. Entry Zones:
● Primary: Breakout with strong volume confirmation
● Alternate: Pullback entry near the 10W/30W MA or breakout zone, ideally on
low volume and with VSTOP acting as support

4. Stop-Loss Placement:
Suggest logical stop-loss: below recent swing low, VSTOP line, or just under the 30-
WEMA

5. Exit Criteria:
Breakdown below the 30-WEMA with volume spike
● Loss of RS vs Nifty and prolonged sideways action
● Any early signs of Stage 3 distribution
● 6. Alternate Exit Strategy:
● Trailing stop-loss using VSTOP
● Two consecutive lower highs with weakening volume
● RSI dipping below 45 and ADX falling below 20 as trend weakness
confirmation
● About the SOIC Long Term Indicator (LTI)
● The SOIC LTI is a composite technical tool designed for long-term trend
validation and low-risk entries. It includes:
● VSTOP (Volatility Stop):
● Length: 10, Multiplier: 2
● Helps in dynamic stop-loss placement and trend following

RSI (Relative Strength Index):


Length: 14, Buy Zone ≥ 45
Identifies strength in momentum; values above 45 indicate bullish bias

CRS (Comparative Relative Strength):


● Benchmarked to NSE:NIFTY, with a 52-week MA
● Helps compare stock performance relative to the index

ADX (Average Directional Index):


Length: 14, Buy Signal ≥ 20
Indicates strength of trend; values above 20 show a sustainable move

Valuation Prompts

Our Must Watch YT video: [Link]


v=Bosc2Dr5mQk&t=2028s)

1. Valuations across sectors:


[Link]

2. Complete prompt for finding valuation ratios across sectors

You are a world class valuation analyst. Today, you have to do the the following
task:

Explain what are the key valuation ratios used to value different sectors in India.
Make a table and give a one line description on why that particular ratio is used.

Specify if you have any questions. If you do the task well, I will reward you.

3. Complete Prompt for finding growth triggers of a company

You are a world class analyst who specialises in finding growth triggers of a
company: Margin expansion, capacity expansion, deleveraging, capex, geographical
expansion, corporate action, backward integration.

Your task is to go through the documents above. Find the key growth triggers and
their timeline. List out all the growth drivers in a table format.

If you have any specific questions, please ask. If you do the task well, I will reward
you.

4. Complete prompt for BULL/BASE/BEAR analysis

You are a world class valuation analyst. Your task is to make a BULL/BASE/BEAR
scenario of Interarch using PE ratio analysis and also make an IRR scenario in all
the scenario analysis.

Go through the data above and make the Bull/Base/Bear scenario analysis.

In the Bull scenario, assume 17.5% revenue growth next year with double digit
EBITDA Margin, in FY27 assume 20% revenue growth with 11.5% EBITDA margin
and in FY28 assume 20% revenue growth with 12% EBITDA margin. Assign a PE of
35 times in the Bull scenario.

In Base scenario, assume 15% revenue growth next year, 18% revenue growth in
FY27 and 18% revenue growth in FY28. Assume margins going to 11% by FY28. In
base scenario assign a pe of 30 times.

In bear scenario, assume 15% growth for next 3 years and margins only going to
10% by FY28. In the Bear scenario, assign a PE of 20 times.
If you have any specific questions, please ask. If you do the task well I will reward
you.

5. Complete Prompt for DCF Analysis

You are a financial modeling expert specializing in discounted cash flow (DCF)
valuations. I am providing you with financial data in the form of [balance
sheets/income statements/cash flow statements] for a RR Kabel along with the
screener link of the data.

[Link]

Your task is to build a comprehensive DCF model and provide detailed valuation
commentary. Please use the following structure:

1. Company Summary (What does the company do)

2. Historical Financial Analysis


• Revenue/Sales growth trends with CAGR calculations
• Margin analysis (gross, operating, EBITDA, net) with commentary on
expansion/contraction
• Cash conversion cycle and working capital efficiency
• Current leverage ratio analysis (Debt/EBITDA, interest coverage) with
sustainability assessment
• Return metrics (ROE, ROIC) comparison to cost of capital

3. DCF Model Assumptions


• Revenue growth projections (detailed by segment if data available)
• Margin evolution projections with specific drivers
• Working capital requirements as percentage of revenue
• CapEx forecasts with clear rationale for fixed asset growth
• Depreciation and amortization schedules
• Tax rate assumptions

4. DCF Valuation
• 5-10 year explicit forecast period with fully modeled financial statements
• Use 10% as WACC
• Use 2% as the Terminal value growth rate
• Enterprise Value to Equity Value bridge
• Per share value calculation

5. Valuation Insights
• Key driver of valuation for the business and risks
• Specific analysis of growth sustainability
• Detailed assessment of margin expansion potential
• Capital structure optimization recommendations
• Liquidity and funding analysis for growth initiatives

Present your model with specific numerical projections, not just general statements.
Include tables with year-by-year forecasts. Clearly articulate your assumptions and
methodology for each component of the model. Be precise about growth rates,
margin trajectories, and capital requirements with explicit percentages and
time periods.

If you have any specific financial data points, industry context, or require additional
information to refine your model assumptions, please ask. If you do the task well, I
will reward you.

Prompts for different sectors

EMD Sector
Generate a highly detailed, institutional-grade research report on the Indian
Electronics Manufacturing & Design (EMD) sector, aimed at investors managing
public market portfolios. The report should assess the full-stack opportunity in India’s
electronics value chain—from components to final assembly—highlighting structural
growth drivers like import substitution, PLI schemes, and China+1. Include a granular
deep dive into PG Electroplast Ltd. as the company case study, analyzing its
strategic positioning, capabilities, client base, financial metrics, and future scalability.

1. Industry Landscape: Indian EMD Ecosystem


Market size of Indian electronics manufacturing in FY25E, with CAGR outlook to
FY30
Segmentation across value chain:
● PCB assembly
● Final box build / EMS
● Component manufacturing (SMT, plastics, die casting, semiconductors)
● Split by end-use: white goods, TVs, mobiles, automotive electronics, IoT
devices
● India’s global share in EMD exports and import dependence on China/Korea
● Role of Make in India, PLI, SPECS, Modified Electronics Manufacturing
Clusters (EMC 2.0)

2. Structural Drivers & Trends


● Demand push: domestic consumption, formalization of brands, D2C brands
outsourcing production
● Cost and policy tailwinds: labor arbitrage vs China, subsidies under PLI
● Integration from EMS to ODM/IDM: who's moving up the value chain?
● Backward integration: plastics, PCBs, tooling, SMT lines, component
localization
● Challenges in deep-tech: chip design/fabrication, R&D spending, IP creation
● Increasing role of design + manufacturing vs pure contract assembly

3. Competitive Landscape & Key Players


● Key listed EMS/ODM players: Dixon Tech, Amber, PG Electroplast, Syrma
SGS, Kaynes, Elin Electronics, Avalon Tech
● Specialization by segment: who plays where – TVs, ACs, medical devices,
lighting, etc.
● Key customer base: large OEMs like Xiaomi, LG, Panasonic, Samsung,
Havells, Voltas, etc.
● Margin profile differentiation – who owns IP/design vs who is pure EMS
● Comparison of capex intensity, asset turns, order visibility

4. Sector Financials & Metrics


● Gross/EBITDA margin trends across major players
● ROCE/ROE vs capex cycle (FY20–FY25E)
● Capacity utilization and revenue/plant benchmarking
● PLI inflows booked, capex linked to incentive targets
● Working capital cycle, dependency on OEM credit terms
● Export share, FX sensitivity, and global contracts

5. Deep Dive: PG Electroplast Ltd.


● Business profile: evolution from plastic injection molding to full-stack EMS
● Key segments: washing machines, air-conditioners (IDUs, ODUs), TVs,
components
● Client portfolio: mix of OEMs vs new-age brands
● ODM capabilities: where PGEL designs end-to-end vs just assembles
● Backward integration: plastics, tooling, PCB assembly – how far have they
gone?
● Capex plans & execution: new factories (Ahmedabad, Uttar Pradesh), PLI
allocation status
● Utilization and topline ramp-up: how much capacity is monetized, FY26/27
revenue visibility
● Financial metrics: EBITDA trends, gross margin changes due to product mix
shift
● Return metrics & asset turns: are returns improving with higher-value
segments like ODM/white goods?
● Strategic commentary: Management’s view on competition, long-term targets,
and MNC client additions
● Concerns: client concentration, margin volatility, scaling design capabilities
6. Peer Benchmarking Table
Company FY24
Revenue
EBITDA Margin
ROCE
ODM %
End Segments
PLI Status
Capex FY25
EPG Electroplast,
Dixon Tech,
Syrma SGS,
Amber Enterprises,
Avalon Tech

7. Investment Lens: Analyst Angle


● Which companies are transitioning from EMS to ODM/IP owners?
● Who is best positioned to benefit from China+1 realignment in electronics?
● How defensible are client relationships in white goods and TV EMS?
● Capital allocation: who balances growth and return on capital most efficiently?
● Long-term industry risks: margin compression, client insourcing, global
competition.

8. Bonus Strategic Add-ons You Can Request


“Include FY24 concall commentary and brokerage insights on PGEL’s ODU/IDU
opportunity.”
“Break down revenue by end-use category and geography (domestic vs export).”
“Map capex to addressable opportunity by vertical: ACs vs TVs vs small appliances.”
“Compare PGEL’s path to ODM vs Dixon or Syrma SGS.”
“Assess working capital discipline across peers, especially during growth spurts.”
“Include valuation table: TTM P/E, EV/EBITDA, PEG, Price/Sales vs FY25 growth
potential.”

Use the credit rating reports, companies conference calls (let me know if you need
links of the same), research reports from several sell sides , and all relevant
sources. I am a fund manager and I am using it as my core and sole senior analyst,
hence the purpose is to make investment decisions based on this. heavy on
analysis, keep the output PDF style. as insightful and detailed as we can get.
Jewellery

You are a world class Equity analyst who specialises in understanding and doing
Financial statement analysis of a Business well. Your analysis must be 100%
factually accurate - if you're uncertain about any number or fact, explicitly state
"unable to verify" rather than guessing. The purpose is to make investment decisions
based on this. heavy on analysis, keep the output PDF style. as insightful and
detailed as we can get. Analyze the industry and company using Uploaded
documents: Credit rating notes, annual reports, conference call transcripts, DRHP,
and rating links and External sources: you have freedom to choose links, blogs,
PDFs, notes which you find to be relevant. The goal is to understand the industry
and company like someone who has no background to it. By the end of this report, I
should have a very strong grip about the company and industry. Don’t make the tone
very salesy, keep it relevant and neutral.

Generate a detailed, strategic research report on the Indian Jewellery Industry, with
a focused deep dive on Kalyan Jewellers India Ltd. The report should be structured
to support institutional investment decisions and offer a comprehensive view of
sector trends, regulatory landscape, financial metrics, competitive positioning, and
business model analysis. Include the following sections:

1. Industry Overview
Size of the Indian jewellery market in FY25 and projected growth through FY28.
Share of gold, diamond, and studded jewellery in the total market.
Market structure: organised vs. unorganised, share of top several players.
Demand drivers:
● Cultural significance and weddings
● Income growth, rural gold affinity
● Urban shift towards branded jewellery
● Financialization of gold (SGBs, gold loans, ETFs)

2. Recent Structural Shifts (FY22–FY25)


● Accelerated shift from unorganised to organised retail post-COVID
● Rise of studied jewellery, lighter designs, and fashion-led pieces
● Increased acceptance of online gold sales, video consultations, phygital
models
● Growing interest in franchise/light asset models for Tier 2/3 expansion
● Rise of Lab grown diamonds
● Formalization via mandatory hallmarking, GST, and PAN-linked gold
purchases
3. Regulatory Environment
● Hallmarking rules and their impact on organised players
● Import duty changes and their effect on gold prices and inventory planning
● RBI & SEBI views on digital gold, Sovereign Gold Bonds (SGBs)
● FEMA guidelines and compliance on overseas expansions (esp. Middle East
operations)
● Taxation on jewellery purchases and implications for high-ticket items

4. Industry Structure & Key Players


● Major players: Titan (Tanishq), Kalyan Jewellers, Malabar Gold, Senco,
Thangamayil, PC Jeweller

Segment focus:
● Titan: studded/fashion + working capital-light franchise model
● Kalyan: hyperlocal + wedding jewellery + Middle East
● Malabar: high-volume gold + global expansion
● Regional players vs. pan-India formats: brand loyalty, pricing power, design
moat
● Market share movement over last 5 years

5. Kalyan Jewellers – Company Deep Dive


● Business model: own stores vs. franchise, India vs. Middle East
● Revenue mix: gold vs. diamond vs. other (coins, watches, solitaires)
● Recent expansion in Tier 2/3 cities and franchise rollout
● Lighter balance sheet shift: franchisee-led model, working capital efficiencies
● Digital initiatives: D2C platform, virtual try-ons, "My Kalyan" customer
engagement
● Customer base profile: wedding-led, South-focused legacy, evolving urban
appeal

6. Financial & Operating Metrics (FY19–FY26E)


● Revenue growth and segmental trends
● EBITDA margins, gross margins (gold vs. diamond), operating leverage
● Working capital days and inventory turns (jewellery retail tends to be WC-
heavy)
● ROE/ROCE trends and capital employed analysis
● Net debt and cash flow generation (including franchise deposits and cash
conversion)

7. Store Economics & Expansion Strategy


● Store count and additions: India vs. Middle East
● Store productivity: revenue per sq. ft., EBITDA per store, payback period
● Franchisee performance metrics (FOCO vs. COCO)
● New store formats: smaller-format stores in low-cost towns
● Expansion plans into East/North India and international (GCC, Southeast
Asia)

8. Consumer & Brand Strategy


● Marketing intensity: brand ambassadors, wedding campaigns, vernacular
focus
● Loyalty programs and EMI offerings
● Brand positioning vs. Tanishq and Malabar: mass premium vs. aspirational
● E-commerce contribution and omni-channel capabilities
● Trust-building strategy: purity, transparency, hallmarking, buyback

9. Risks and Challenges


● Gold price volatility and impact on consumer demand
● Regulatory/tax changes affecting demand elasticity
● Inventory management risk in a fashion/category-heavy model
● Competitive pricing pressure, especially in Middle East
● Cyclical slowdown in discretionary or wedding spend

10. Peer Comparison


● Compare Kalyan with Titan (Tanishq), Senco, Malabar (where available), and
Thangamayil
Benchmark on:
● Gross margins (diamond mix), EBITDA%, ROCE
● Store productivity and working capital cycle
● Debt metrics and return on capital

11. Investor Lens


● Can Kalyan scale profitably outside South India without brand dilution?
● Will franchise expansion structurally improve ROCE and FCF profile?
● Key KPIs to track: same-store sales growth, franchise share, diamond mix,
ROCE
● Valuation lens: P/E, EV/EBITDA, FCF yield, vs. Titan and upcoming IPOs in
jewellery space
● Red flags: high gold price exposure, slower wedding season, low-margin
Middle East business drag

Exchange Industry

You are a world class Equity analyst who specialises in understanding and doing
Financial statement analysis of a Business well. Your analysis must be 100%
factually accurate - if you're uncertain about any number or fact, explicitly state
"unable to verify" rather than guessing.
The purpose is to make investment decisions based on this. heavy on analysis, keep
the output PDF style. as insightful and detailed as we can get. Analyze the industry
and company using Uploaded documents: Credit rating notes, annual reports,
conference call transcripts, DRHP, and rating links and external sources: you have
freedom to choose links, blogs, PDFs, notes which you find to be relevant.
The goal is to understand the industry and company like someone who has no
background to it. By the end of this report, I should have a very strong grip about the
company and industry. Don’t make the tone very salesy, keep it relevant and neutral.

Generate a detailed, investor-focused research report on the Indian Financial


Exchange Industry, with broad and deep coverage across equity, commodity, debt,
and multi-asset trading platforms. Include the following sections:

1. Industry Overview
● Evolution of India’s financial exchange landscape from BSE’s legacy to NSE’s
dominance and emergence of MCX, NCDEX, and IFSC platforms.
● We want to focus more on BSE.
● Total size of Indian exchange-traded volumes in FY25: cash equity, F&O,
commodities, currency, SLB, and debt.
● Core functions of exchanges: listing, trading, clearing, settlement,
surveillance, and data dissemination.
● Role of SEBI and IFSC Authority in shaping the regulatory framework.
● Differentiation between exchanges, clearing corporations, and depositories.

2. Recent Structural Trends (FY23–FY25)


● Rapid growth in index options and expiry-day volumes (weekly contracts, zero
DTE analogs).
● Rise of retail participation in derivatives and the associated regulatory
response.
● Growth of co-location services, algo trading, and intra-day volume
intensification.
● NSE’s dominance in F&O, but rising interest in MCX’s new contracts
(especially options on metals/energy).

SEBI’s push for:


● Fee rationalization
● Mutual fund, SLB, and debt product growth
● Interoperability of clearing corporations
● T+0 and instant settlement (and its implications)

3. Key Players in India


● Overview of major exchanges:
● NSE: Equity & derivatives behemoth, large private market business (now
approaching IPO)
● BSE: Focus on SME listings, mutual funds, and BSE StAR platform
● MCX: Commodity futures and options leader; undergoing tech platform
migration
● NCDEX: Agri-focused derivatives
● India INX, NSE IFSC: Offshore listings and GIFT City evolution
● Competitive dynamics: product innovation, liquidity network effects, and tech
capabilities

4. Business Models of Exchanges


● Revenue drivers: transaction charges, annual listing fees, data sales,
technology services, colocation, and IPO/follow-on listings.
● Comparison of transaction-led models (NSE) vs. annuity-fee models (BSE’s
StAR MF).
● Economics of newer verticals: ESG indices, carbon trading, green bonds, and
international depository receipts.
● How clearing corporations (e.g., NSE Clearing, ICCL) act as risk and revenue
centers.

5. Global Landscape and Benchmarking


● Overview of global exchanges: CME Group, ICE, Nasdaq, LSE, SGX, HKEX
Comparison of operating models:
● Indian exchanges’ focus on transaction revenue and volumes
● Global peers’ diversification into data, analytics, clearing, SaaS, and cloud
trading infrastructure
● Global expansion via M&A (ICE/Bakkt, CME/NEX, LSE/Refinitiv) why India
hasn’t seen similar deals
● Benchmark valuation multiples: EV/EBITDA, P/E, EV/Revenue, FCF yields

6. India’s Unique Positioning


● India’s volume-led growth vs. globally fee-led revenue models
● Heavy retail and options trading concentration — sustainability and risk
● Regulatory protectionism and its role in shaping a two-player oligopoly
● Scope for international relevance via NSE IFSC, India INX, and future foreign
listings
● Data monetization potential — still under-penetrated compared to global
peers

7. Key Company Commentary (as per availability)


● NSE: Market share trends, upcoming IPO, governance updates, expansion
into fixed income & ESG
● BSE: Growth of mutual fund platform (StAR MF), INX ambitions, and
optionality in commodity segments
● MCX: Transition to new technology platform, energy contracts performance,
metals options ramp-up
● Use of earnings calls, SEBI filings, and investor decks where available

8. Opportunities and Risks


Opportunity areas:
● Growth in mutual fund and debt exchange volumes
● Potential launch of carbon credits, electricity trading, spot exchanges
● Monetization of data, indices, and tech stack

Risks:
● Regulatory price caps or forced competition
● Excessive reliance on options (e.g., Nifty Bank, DTE-style contracts)
● Governance issues (e.g., past concerns at NSE)
● Tech/platform risks (e.g., MCX migration)

9. Investor Lens
● Which platforms offer operating leverage, annuity-style income, or global
expansion potential?
● Key valuation metrics across India and global exchanges: P/E, EV/Revenue,
ROIC, FCF yield

Questions to assess:
● Is NSE's dominance priced in pre-IPO?
● Can BSE's MF or GIFT platform scale into a margin-accretive business?
● Is MCX truly differentiated, or dependent on one asset class cycle?
● Can any Indian exchange move beyond volumes into data/IP-led annuity
models?
QSR

You are a world class equity analyst who specialises in understanding and doing
financial statement analysis of a Business well. Your analysis must be 100%
factually accurate–if you're uncertain about any number or fact, explicitly state
"unable to verify" rather than guessing.

The purpose is to make investment decisions based on this, heavy on analysis, and
keep the output PDF style, as insightful and detailed as we can get. Analyze the
industry and company using Uploaded documents: Credit rating notes, annual
reports, conference call transcripts, DRHP, and rating links and External sources:
you have freedom to choose links, blogs, PDFs, notes which you find to be relevant.
The goal is to understand the industry and company like someone who has no
background to it. By the end of this report, I should have a very strong grip about the
company and industry. Don’t make the tone very salesy, keep it relevant and neutral.

Generate a comprehensive and data-backed research report on the Indian Quick


Service Restaurant (QSR) Industry with a focused company deep dive on Jubilant
FoodWorks Ltd. The report should mirror the structure and analytical rigor of
investor-grade industry deep dives (like those done for the food delivery sector), and
include the following sections:

1. Industry Overview
● Market size of the Indian QSR sector in FY25, and projected growth through
FY28
● Structural trends post-COVID (delivery, digital orders, app-based loyalty,
value meals, etc.)
● Urban vs. Tier-2/3 demand split and penetration levels
● Key demand drivers: disposable income growth, shift toward organized dining,
younger demographics, nuclear families, value meals, convenience-led dining
behavior

2. Segmental Landscape & Key Players


● Breakdown of formats: dine-in, takeaway, delivery, digital kitchen/cloud-only
QSR
● Overview of organized vs. unorganized QSR share in India
● Listed & notable private players: Jubilant FoodWorks, Devyani International,
Westlife Foodworld, Sapphire Foods, Wow! Momo, Burger Singh, etc.
● Entry of global chains (e.g., Tim Hortons, Popeyes) and competitive
implications

3. Financial & Operational Benchmarking


● Metrics: Same Store Sales Growth (SSSG), AOV, delivery mix, store EBITDA
margin, cost per store, digital contribution to sales
● Unit economics: breakeven per store, capex/store vs. return profile, food cost
as % of sales, royalty fees for global franchisees
● Loyalty program penetration and retention stats (if available)
● Delivery aggregator partnerships: Swiggy/Zomato vs. in-house apps

4. Company Deep Dive: Jubilant FoodWorks


● Business segments: Domino’s India, Dunkin’ Donuts, Hong’s Kitchen,
Popeyes, etc.
● Growth strategy: store additions, regional penetration, multi-brand play
● Digital strategy: own app vs. third-party delivery, loyalty, personalization
● Financial profile (FY19–FY26E): revenue, EBITDA, margins, SSSG, RoCE,
free cash flows
● Capex and new store rollout plans
● Commentary on Popeyes performance and long-term potential
● Margin pressures and drivers: dairy inflation, raw material volatility, royalty
costs
● Management commentary, earnings call insights, and investor communication
highlights

5. Competitive Landscape
● Peer benchmarking: Westlife (McDonald’s), Devyani (KFC/Pizza Hut),
Sapphire (Yum brands)
● Differentiation across formats, product innovation, pricing, geography
● Brand strength, ad spend as % of revenue, marketing strategy,
influencer/YouTube tie-ups

6. Risks and Challenges


● Input cost inflation and pricing power
● Competitive intensity and promotional aggression
● Regulatory risks (FSSAI, labor, tax on delivery)
● Execution risks in Tier-2 expansion or newer brands

7. Investor Lens
● Key valuation metrics: EV/EBITDA, EV/store, PEG
● Historical and forward multiples vs. peer group
● What needs to go right for Jubilant to outperform?
● What are the red flags or early signs of operational stress?
● Use the credit rating reports, companies conference calls (let me know if you
need links of the same), research reports from several sell sides, and all
relevant sources.
I am a fund manager and I am using it as my core and sole senior analyst, hence the
purpose is to make investment decisions based on this. heavy on analysis, keep the
output PDF style. as insightful and detailed as we can get.

Food Delivery

You are a world class equity analyst who specialises in understanding and doing
financial statement analysis of a business well. Your analysis must be 100% factually
accurate, if you're uncertain about any number or fact, explicitly state "unable to
verify" rather than guessing.

The purpose is to make investment decisions based on this. heavy on analysis, keep
the output PDF style. as insightful and detailed as we can get. Analyze the industry
and company using Uploaded documents: Credit rating notes, annual reports,
conference call transcripts, DRHP, and rating links and External sources: you have
freedom to choose links, blogs, PDFs, notes which you find to be relevant.

The goal is to understand the industry and company like someone who has no
background to it. By the end of this report, I should have a very strong grip about the
company and industry. Don’t make the tone very salesy, keep it relevant and neutral.

Create a comprehensive deep-dive report on the Indian food delivery industry, with a
focus on Zomato and Swiggy. The report should include:

● Market Size and Growth


● Current market size (FY24/FY25 est.) and projected CAGR through FY28
Breakdown by metros, Tier-2/3 cities
● Penetration rates: urban households using food delivery apps vs addressable
market
● Post-COVID structural shifts and consumer behaviour trends
● Industry Structure and Key Players
● Overview of key players: Zomato, Swiggy, Zepto Cafe, Magicpin, EatSure,
Thrive, etc.
● Business model evolution: from food delivery to quick commerce and dining-
out aggregation
● Share of market between Zomato and Swiggy, any niche challengers gaining
traction
● Operating & Financial Metrics
● Orders per day, AOV (Average Order Value), delivery costs per order, take
rates
● Blended contribution margin per order: pre- and post-marketing cost
● Customer retention, repeat order rate, cohort analysis where available
● EBITDA margins, platform unit economics
● Company-Level Deep Dives

Zomato:
● Blinkit integration impact
● Profitability roadmap
● Loyalty programs (Gold)
● Hyperpure supply chain and how it differentiates Zomato from Swiggy
● International exits and capital efficiency post-acquisition spree

Swiggy:
● Quick-commerce scale via Instamart
● IPO readiness and investor interest
● Expansion in dining-out/payments (Swiggy Dineout)
● Employee cost control, restructuring updates
● Industry Capex, Tech & Logistics
● Investment in logistics infrastructure (dark stores, kitchens, delivery partners)
● Fleet optimization: gig model vs on-roll delivery personnel
● AI-driven recommendation and routing improvements
● Cloud kitchen partnerships and monetization of user data

Challenges and Risks


● Rising delivery partner costs and churn
● High marketing and discounting intensity
● Unit economic stress in smaller cities
● Threat from q-commerce crossover (e.g. Zepto entering food)
● Regulatory overhangs: gig worker laws, FSSAI scrutiny, MDR caps
● Strategic Shifts and Differentiators
● Pivot to profitability and cost discipline (Zomato vs Swiggy contrast)
● Use of loyalty programs (Gold vs Super) and monetization strategies
● Restaurant onboarding fees, commission structures and exclusivity
● Dining-out monetization vs food delivery core – which will scale?
● Investor Metrics to Track
● Orders per user per month (frequency)
● Net take rate vs contribution margin
● Gross order value (GOV) growth vs AOV stability
● Break-even per city and national PAT expectations
● Free cash flow trends and capital allocation discipline
● Conclusion: Who Leads and Why
● Zomato vs Swiggy on scale, profitability, customer metrics, execution
● Future of the industry: consolidation, adjacencies, and monetization roadmap
Data Centres

You are a world class Equity analyst who specialises in understanding and doing
Financial statement analysis of a Business well. Your analysis must be 100%
factually accurate, if you're uncertain about any number or fact, explicitly state
"unable to verify" rather than guessing. The purpose is to make investment decisions
based on this. heavy on analysis, keep the output PDF style. as insightful and
detailed as we can get. Analyze the industry and company using Uploaded
documents: Credit rating notes, annual reports, conference call transcripts, DRHP,
and rating links and External sources: you have freedom to choose links, blogs,
PDFs, notes which you find to be relevant. The goal is to understand the industry
and company like someone who has no background to it. By the end of this report, I
should have a very strong grip about the company and industry. Don’t make the tone
very salesy, keep it relevant and neutral.

Generate an advanced and investment-focused research report on the Indian Data


Centre industry, aimed at long-only public equity fund managers and institutional
investors. The report must capture both macro-level trends and stock-specific
actionable angles. The goal is to identify investible proxies in the listed space —
companies that directly own, operate, lease, or build data centres, or act as enablers
(utilities, power infra, cooling tech, construction EPC, REITs, telecom/fiber players,
etc.).

1. Industry Overview:
● India’s Data Centre Boom FY25 estimated market size in MW capacity and
revenue, with CAGR through FY30
● Installed capacity vs upcoming capacity: key cities (Mumbai, Chennai,
Hyderabad, Delhi-NCR, Pune, Bengaluru)
● Global context: India’s share in global data centre capacity, how it compares
to Singapore, Indonesia, UAE
● Key demand drivers:
○ Surge in cloud adoption (AWS, Azure, GCP)
○ Digital India push,
○ UPI volume explosion,
○ OTT/video,
○ AI/ML workloads
● Government data localization mandates 5G rollout + edge computing
● Economics of a data centre: MW capacity cost, asset turn, revenue per MW,
utilisation breakeven, margins
● Power cost and availability as a critical constraint

2. Data Centre Ecosystem Map:


● Who Does What Operators (hyperscale + colocation): Yotta (Hiranandani
Group), Nxtra (Bharti Airtel), Jio Data Centres (Reliance), NTT Global, STT,
GDC India, Adani, ConneX, CtrlS, WebWerks
● Construction & EPC: Sterling Wilson Renewable Larsen & Toubro (L&T) PSP
● Projects Power & Utilities: NTPC (data centre MoUs), Adani Power, JSW
Energy (RE projects for DCs)
● RE dependency: Open Access, Solar + Battery Storage CAPEX REITs and
Infra
● Owners: Brookfield India REIT (BIRET), Embassy REIT — exposure through
tech parks with captive data centres IRB Infra, RailTel (network infra + edge
data play)
● Network / Fiber providers: RailTel, Tata Communications, Sterlite
Technologies
● Cooling & Infra Tech: Blue Star (precision cooling), Voltas, Johnson Controls-
Hitachi

3. Financial & Operating Metrics (Where Available)

● Cost/MW to build (₹80–120 cr), RoCE potential (8–15%), breakeven capacity


utilization
● EBITDA margins for colocation models vs hyperscale
● Power cost per MW and efforts toward renewable/green data centres
● Average lease duration (5–10 years), pricing per rack/sqft
● Capex visibility — phased capacity rollout (FY25–28)

4. Listed Market Plays (Direct & Indirect)


● Bharti Airtel (Nxtra Data) Data centre JV with Carlyle (25% stake) Nxtra to
triple capacity to 400+ MW by FY27
● Financials: revenues not disclosed separately but tracked via infra business
● Key risk: power availability, competition from Jio Reliance Industries (Jio Data
Centres)
● Ambitious plans to build over 500 MW capacity, likely via Jio
● Platforms Integrates with Jio Cloud + enterprise SaaS stack Indirect exposure
via RIL stock
● Adani Enterprises (AdaniConneX JV) JV with EdgeConneX — target 1 GW
pan-India capacity
● Focus on renewable-powered hyperscale DCs Capex-heavy, early-stage
monetization
● Hiranandani Yotta (via partner plays) Not listed directly, but EPC exposure via
Sterling & Wilson or power infra players
● Navi Mumbai facility already live with 50 MW+
● Larsen & Toubro EPC contractor for multiple data centres (confidential clients)
● Focus on turnkey build + MEP + cooling infrastructure
● Tata Communications Cloud & hosting services with international DC
exposure
● Emerging indirect beneficiary of edge and cross-border traffic
● RailTel Government-owned, operates edge data centres across India
● Direct infra plus monetization via PSU + defence clients
● Brookfield / Embassy REIT Potential for data centre assets to be added into
REITs with long-term leases
● Currently not major contributors to topline, but strategic future angle

5. What to Watch / Investment Risks


● High capital intensity, slow payback
● Power availability and cost inflation
● Competitive intensity and pricing pressure
● Regulatory challenges: land, zoning, sustainability
● Return dilution due to long gestation before monetization

6. Bonus Add-Ons You Can Request for Deeper Insights


● “Include FY24/FY25 planned capacity additions and capex per MW for top 5
players”
● “Break down how hyperscale vs colocation economics work in Indian context”
● “Map REIT-level exposure to data centre tenants by region”
● “List all infra/cooling/tech companies with any DC-related revenue or order
books”
● “Add comparison of India vs Singapore/Indonesia in cost/MW and rack
pricing”
● “Segment players by scale vs asset-light edge providers” include companies
like anant raj, E2E, TD power as well.

I am expecting you to go through the company conference calls of E2E and Anant
Raj. Use the credit rating reports, companies conference calls (let me know if you
need links of the same), research reports from several sell sides , and all relevant
sources. I am a fund manager and I am using it as my core and sole senior analyst,
hence the purpose is to make investment decisions based on this. heavy on
analysis, keep the output PDF style. as insightful and detailed as we can get.

FMCG

Generate a deeply analytical, institutional-grade research report on the Indian FMCG


(Fast-Moving Consumer Goods) industry from the lens of a buy-side equity analyst
with over a decade of experience. The report must simulate the rigour and foresight
expected at a long-only public markets fund, with a focus on: Secular trends,
Channel evolution, Margin drivers, Capital allocation, Risks to valuation multiples,
Category leadership, Portfolio resilience, and innovation.
Use a strategic investor’s lens — looking beyond near-term quarterly beats/misses
— to assess long-term positioning, pricing power, and execution capability.

1. Sector Structure & Market Map


● Size of Indian FMCG sector in FY25E, expected CAGR through FY30.
● Breakdown by segments: food & beverages, personal care, home care,
hygiene, discretionary.
● Organized vs unorganized share, and pace of formalization.
● Rural vs urban demand share, and commentary on convergence/divergence
trends.
● Global FMCG benchmark (India vs SE Asia, LATAM on per capita FMCG
spend).

2. Demand Drivers & Structural Growth Themes


● Penetration headroom: per capita consumption gaps across core categories.
● Aspirational consumption trends: premiumization, grooming, healthy snacking,
wellness.
● Shift from unbranded to branded: packaged staples, detergents, OTC
● Women workforce participation, nuclear families, urbanization effects Lifestyle
shifts and discretionary tailwinds: skin care, coffee, baby care, pet food.

3. Channel Dynamics & Distribution Shifts


● General trade vs modern trade vs e-commerce vs D2C — share, growth,
profitability
● Rural reach: distributor productivity, sachet strategy, direct vs indirect model
● Digital-first strategies:
CRM, last-mile integration, omnichannel readiness
● Trade margins and their influence on route-to-market strategy
● Commentary on GT consolidation and FMCG’s push for lower working capital
cycles

4. Operating & Financial Metrics


● Gross and EBITDA margin trends by category (food, HPC, discretionary).
● Price vs volume growth: decomposition of historical revenue growth
● ROCE, ROIC, working capital cycles — capital efficiency metrics
● Brand investment (A&P as % of sales), and its correlation with market share
● Capex trends: automation, backward integration, in-house manufacturing vs
outsourcing Inventory days, channel filling dynamics during festive/lean
quarters.

5. Key Players & Strategic Positioning


● Break down the strategic posture of key listed names:
● Company Core Categories
● FY24/FY25 Rev (₹ Cr)
● EBITDA Margin
● Rural Share Innovations Launched
● GTM Strength
● Export Share

● Include: HUL – Portfolio breadth, scale advantage, pricing power ITC – Foods
expansion, margin reset, FMCG demerger narrative Nestle – Premium play,
nutrition dominance, portfolio resilience Dabur – Ayurveda positioning, rural
portfolio Britannia – Margin volatility, dairy push Marico – Premiumisation via
Saffola, youth brands Godrej Consumer – Category churn, turnaround
commentary Emami, Colgate, Tata Consumer, Jyothy Labs – category-
specific insights

6. Watchpoints & Risks (What Needs Focus Now)


● Input cost volatility: soft commodity cycles (palm oil, milk, wheat), packaging
● Ad wars: A&P intensity and risk to margins
● Rural drag: what’s cyclical vs structural, impact of agri distress
● Category saturation in urban pockets
● Private labels and channel-owner competition in e-comm/MT
● Valuation excesses: FMCG as “safe compounder” — multiple sustainability vs
real growth

7. Frameworks to Evaluate Business Quality


● Gross margin stability across cycles → proxy for pricing power
● Brand power vs trade dependency (D2C leverage, MT/GT balance)
● Innovation success rate: % of revenue from new launches
● Category adjacencies – success/failure in cross-segment expansion
● Resilience in volume growth across cycles
● Cash flow consistency vs accounting earnings

8. Strategic Add-Ons You Can Ask For:


● “Break down the FMCG sector into Defensives vs Aspirational vs Growth
tailwinds categories.”
● “Compare FMCG companies on capital allocation track record: dividend
payout, buybacks, acquisitions.”
● “Highlight how FMCG players responded during inflationary cycles and
volume compression periods (e.g., FY23).”
● “Include recent commentary from Q4FY24 concalls and brokerage reports.”
● “Map category-level innovation index vs revenue growth.”
● “Include valuation table — TTM P/E, EV/EBITDA, PEG — and assess what’s
justified based on forward growth.”
● “Showcase top 3 priorities for each management team over FY25–27 based
on disclosed capex, digital, brand roadmap.”
● “Segment the industry into ‘Compounders’, ‘Rebuilders’, and ‘Category
Laggards’.

3. DMart Deep Dive:


● Operational and Financial Analysis Business Model:
● Dissect DMart's EDLC (Everyday Low Cost) and EDLP (Everyday Low Price)
strategies and their effectiveness in the Indian context.
● Store Expansion:
Evaluate DMart's cluster-based expansion approach, focusing on store count
growth, geographic penetration, and real estate ownership vs. leasing
strategies.
● Product Mix:
Analyze the revenue contribution from various segments: food & groceries,
apparel, general merchandise, and private labels.
● Supply Chain Efficiency:
Assess DMart's procurement practices, inventory turnover rates, and logistics
management.
● Financial Metrics:
Review key financial indicators such as revenue growth, EBITDA margins,
PAT margins, ROCE, and ROE over the past five years.

4. Strategic Initiatives and Innovations


● Digital Transformation:
Explore DMart's foray into e-commerce through DMart Ready, its
performance, and scalability.
● Technology Adoption:
Assess investments in automation, data analytics, and customer relationship
management systems.
● Customer Engagement:
Evaluate loyalty programs, in-store experience enhancements, and marketing
strategies.

5. Risk Assessment
● Competitive Pressures:
Analyze threats from new entrants, aggressive pricing by competitors, and the
impact of e-commerce giants.
● Operational Challenges:
Identify risks related to supply chain disruptions, labor shortages, and
regulatory compliance.
● Financial Risks:
Assess the implications of margin pressures, capital expenditure
requirements, and debt levels. LinkedIn
6. Future Outlook and Investment
● Thesis Growth Projections:
Forecast DMart's revenue and profit growth over the next five years,
considering market trends and internal strategies.
● Valuation Analysis:
Compare DMart's valuation multiples with industry peers and assess the
justification based on growth prospects.
● Investment Rationale:
Formulate a long-term investment thesis, highlighting DMart's strengths,
potential catalysts, and areas of concern.

Passenger Vehicle

You are a world class equity analyst who specialises in understanding and doing
Financial statement analysis of a Business well. Your analysis must be 100%
factually accurate, if you're uncertain about any number or fact, explicitly state
"unable to verify" rather than guessing. The purpose is to make investment decisions
based on this. heavy on analysis, keep the output PDF style. as insightful and
detailed as we can get. Analyze the industry and company using Uploaded
documents: Credit rating notes, annual reports, conference call transcripts, DRHP,
and rating links and External sources: you have freedom to choose links, blogs,
PDFs, notes which you find to be relevant.

The goal is to understand the industry and company like someone who has no
background to it. By the end of this report, I should have a very strong grip about the
company and industry. Don’t make the tone very salesy, keep it relevant and neutral.

Generate a comprehensive and investor-grade research report on the Indian


Passenger Vehicle (PV) OEM industry, tailored for long-term institutional investors
and public market fund managers. The report should offer a full-spectrum analysis of
the sector—market sizing, competitive structure, product mix, capex intensity, and
EV transition—while including a granular strategic deep dive on Hyundai Motor India
Ltd (unlisted, but highly relevant as the second-largest OEM in India and planning
IPO). Ensure the tone is analytical, data-rich, and suitable for top-down and bottom-
up investment evaluation.

1. Industry Overview
● Indian Passenger Vehicle market size in FY25 (in volume and value), with
growth outlook till FY28
● Segmental breakup: hatchbacks, sedans, SUVs, MUVs, electric PVs
● Evolution of consumer preference: shift toward SUVs, premiumization, urban
vs rural demand
● Penetration vs global benchmarks (cars/1,000 population)
● Export opportunity: key geographies for Indian PVs, India as a manufacturing
hub.

2. Competitive Landscape & Structure


● Key OEM players: Maruti Suzuki, Hyundai, Tata Motors, Mahindra, Kia,
Honda, Toyota, Skoda-Volkswagen, MG, Renault-Nissan
● Volume trends: market share movement over FY20–FY25
● EV landscape: who’s ahead in PV EV offerings (Tata, MG, Hyundai)
● Differentiation by drivetrain: ICE vs CNG vs EV vs Hybrid B2C vs B2B
● Segment share: fleet sales, ride-sharing, subscription models.

3. Operating & Financial Metrics


● KPIs: production volume, domestic sales, exports, average realization per
vehicle, ASP growth
● Operating leverage: margin expansion due to volume recovery
● Gross and EBITDA margins across OEMs
● ROCE and ROE trends Inventory days, working capital cycle for major players
● Capex trends: new platforms, greenfield/brownfield plants, localization.

4. Strategic Themes & Trends


● Electrification roadmap and localization: PLI scheme impact, EV value chain
● Chip shortage easing and its impact on production SUV dominance and
premiumization trends
● Shift to high-margin variants, connectivity features, ADAS inclusion
● Role of government policies: FAME II, import duties, safety mandates
● Urban demand recovery vs rural drag Used car market dynamics and its
effect on OEM sales

5. Challenges & Risks:


● Pricing pressure from competition, regulatory cost inflation (BS6 norms, EV
compliance)
● Global supply chain risks (e.g., lithium, semiconductors)
● Weak rural sentiment or fuel price shocks
● High capex burden for EV platforms, battery localisation
● Peer Benchmarking Table
OEM FY24 Volume Market Share EBITDA Margin ROE Capex (₹ Cr) EV % of
Sales Exports % ASP (₹) (Include Maruti, Hyundai, Tata, Mahindra, Kia)

Case Study: Hyundai Motor India Ltd


● Market positioning: No. 2 in India by volumes, stronghold in urban SUV
segment
● Product portfolio: Creta, Verna, Venue, Exter, i20, Tucson, Kona EV
● Export presence: manufacturing hub for 85+ countries Revenue and margin
trends (from rating reports / proxy sources)
● Upcoming IPO: structure, valuation expectations, assets under India ops
● Capex cycle: plant expansions, EV manufacturing facility in Tamil Nadu
● EV roadmap: Ioniq 5, Kona, mass-market EVs for India Commentary on
localization, backward integration (batteries, motors)
● Management commentary from recent interviews and press releases keep a
section about how we should look at this sector from investor POV.
● Use the credit rating reports, companies conference calls (let me know if you
need links of the same), research reports from several sell sides, and all
relevant sources.

I am a fund manager and I am using it as my core and sole senior analyst, hence the
purpose is to make investment decisions based on this. Heavy on analysis, keep the
output PDF style. as insightful and detailed as we can get.

Footwear

You are a world class equity analyst who specialises in understanding and doing
financial statement analysis of a business well. Your analysis must be 100% factually
accurate, if you're uncertain about any number or fact, explicitly state "unable to
verify" rather than guessing. The purpose is to make investment decisions based on
this. heavy on analysis, keep the output PDF style, as insightful and detailed as we
can get.

Analyze the industry and company using Uploaded documents: Credit rating notes,
annual reports, conference call transcripts, DRHP, and rating links and External
sources, you have freedom to choose links, blogs, PDFs, notes which you find to be
relevant.

The goal is to understand the industry and company like someone who has no
background to it. By the end of this report, I should have a very strong grip about the
company and industry. Don’t make the tone very salesy, keep it relevant and neutral.

Generate a detailed, investor-grade research report on the Indian Footwear Industry,


with a focused deep dive on Metro Brands Ltd. The report should be data-rich and
strategic, suitable for long-term institutional investment decisions. Cover the full
ecosystem, from industry growth trends to evolving consumer behavior, brand
segmentation, and competitive dynamics. Include the following sections:
1. Industry Overview
● Size of the Indian footwear industry in FY25 and expected CAGR through
FY28 Breakdown across categories: men’s, women’s, kids, and
athleisure/sportswear
● Market segmentation: organized vs. unorganized, premium vs. mass, branded
vs. non-branded
● Demand drivers: Rising discretionary incomes
● Urban lifestyle shifts
● Aspiration for branded/formal/casual wear
● Footwear as a fashion accessory

2. Industry Structure & Competitive Landscape


● Key segments: Formal wear, casual, fashion/luxury, sports/athleisure, ethnic,
school wear
● Major players: Metro Brands, Bata, Relaxo, Khadim, Campus, Adidas/Nike
(India ops), Puma, Skechers
● Global brands' India strategy (through licensing, JVs, direct retail, or
marketplace)
● How pricing, margin profile, and channel mix differ across players
● Market share estimates and competitive positioning matrix

3. Recent Trends (FY23–FY25)


● Shift towards premiumisation and branded retail post-COVID
● Strong growth in athleisure/sportswear and open footwear (sandals, sliders)
● Increased penetration of D2C and online marketplaces (AJIO, Myntra,
Amazon Fashion)
● Expansion into Tier 2/3 cities, growing importance of mall-based retailing
● Resilience of women’s and occasion-wear categories despite discretionary
volatility
● Cost pressure from raw materials (PU, rubber) and imported inventory cycles

4. Metro Brands Ltd. – Company Deep Dive


● Business model overview: multi-brand, multi-category premium footwear
player
● Brand portfolio: Owned brands: Metro, Mochi, Walkway
● Licensed/JV brands: FitFlop, Crocs, FILA (newer launches)
● Retail footprint strategy: Number of stores, cities covered, store size strategy
High presence in malls and premium retail zones
● Store economics and payback
● Online vs. offline revenue mix and omni-channel integration
● Focus on asset-light distribution, in-house design, vendor partnerships

5. Financial Profile (FY19–FY26E)


● Revenue growth trajectory and category-wise contribution
● Gross margins, EBITDA margins, and return ratios vs. peers
● Inventory cycle management and working capital trends
● Capex strategy for store expansion and brand onboarding
● Cost breakdown: rentals, employee cost, marketing intensity

6. Brand Strategy and Consumer Positioning


● Value proposition of each brand: aspirational, mid-premium, fashion-forward
● Target demographic and customer segmentation
● Role of exclusive brand outlets (EBOs) vs. multi-brand format stores (MBOs)
● Store productivity metrics: revenue per sq. ft, ASP trends, footfall recovery
post-COVID
● Marketing & branding spend, loyalty programs, celebrity/influencer tie-ins

7. Technology & Distribution


● Online strategy: own D2C portal vs. marketplaces vs. brand websites
● Supply chain model: domestic sourcing vs. imported
● SKUs Technology investments in POS systems, inventory planning, data
analytics

8. Risks and Challenges


● Exposure to discretionary slowdown or premium fatigue in Tier-1 cities
● Competitive aggression from MNC sportswear and D2C challenger brands
Inventory markdown risk in a seasonal/fashion-sensitive category
● Fluctuation in raw material and forex (for imported product lines)
● Mall dependency and potential impact of lease renegotiations

9. Peer Comparison
● Benchmark Metro Brands against: Relaxo (mass market), Bata (mid-
premium), Campus (athleisure)
● Global peers (Puma India, Skechers, Nike) in terms of ASPs, margins, growth
rates
● Comparative analysis: store count, ASP, gross margins, EBITDA/store, return
on capital

10. Investor Lens


● Can Metro scale sustainably while maintaining its premium positioning?
● Is its Crocs partnership a game-changer or margin diluter?
● Key metrics to track: SSSG, store additions, ASP growth, channel mix, and
gross margin stability
● Red flags: demand fatigue in discretionary spend, over-reliance on Crocs,
inventory buildup
● Valuation lens: EV/EBITDA, P/E, ROCE, and peer-relative multiples in Indian
retail
Use the credit rating reports, companies conference calls (let me know if you need
links of the same), research reports from several sell sides, and all relevant sources.

I am a fund manager and I am using it as my core and sole senior analyst, hence the
purpose is to make investment decisions based on this, heavy on analysis, and keep
the output PDF style, as insightful and detailed as we can get.

Health Insurance

You are a world class equity analyst who specialises in understanding and doing
financial statement analysis of a business well. Your analysis must be 100% factually
accurate, if you're uncertain about any number or fact, explicitly state "unable to
verify" rather than guessing.

The purpose is to make investment decisions based on this. heavy on analysis, keep
the output PDF style. as insightful and detailed as we can get. Analyze the industry
and company using Uploaded documents: Credit rating notes, annual reports,
conference call transcripts, DRHP, and rating links and External sources: you have
freedom to choose links, blogs, PDFs, notes which you find to be relevant.

The goal is to understand the industry and company like someone who has no
background to it. By the end of this report, I should have a very strong grip about the
company and industry. Don’t make the tone very salesy, keep it relevant and neutral.

Generate a deep-dive industry research report on the Indian Health Insurance


Sector, designed for institutional investors and fund managers. The report should be
highly analytical, data-backed, and suitable for making long-term investment
decisions. Include the following sections and structure:

1. Industry Overview
● Market size of the Indian health insurance industry in FY25 and growth
projections through FY28
● Breakdown of retail, group (corporate), and government schemes (Ayushman
Bharat, state-level Yojanas)
● Penetration metrics: health insurance penetration as % of GDP, per capita
premium, sum assured per insured
● Drivers of growth: rising healthcare costs, increasing awareness post-COVID,
digital distribution, tax incentives (80D), Ayushman Bharat PMJAY coverage,
medical inflation
● Structural tailwinds: urbanization, lifestyle disease prevalence, hospital infra
expansion, low base of insured population
2. Regulatory Landscape
● Role and impact of IRDAI: sandbox regulations, digital-only players,
commission reforms
● Recent changes: Bima Sugam, extended product flexibility, solvency margin
tweaks, portability rules
● TPA regulation, mandatory disclosures, capital adequacy, reinsurance norms
● Upcoming regulatory shifts and their potential impact on growth/profitability

3. Industry Structure & Players


● Market structure: public vs. private players, standalone health insurers vs.
composite players
● Key categories:
Standalone Health Insurers (SAHIs): Star Health, Niva Bupa, Care Health,
ManipalCigna
● Life/General Composite Insurers:
HDFC Ergo, ICICI Lombard, New India Assurance, SBI General Digital-first
insurers and insur-techs: Acko, Digit, Navi Health, Plum (group), etc.
● Market share, premiums, and growth by player type
● Retail health premium trends vs. group health premiums
● Government scheme participants: New India, Oriental, NIA, etc.

4. Distribution Landscape
● Agent-driven vs. bancassurance vs. digital/aggregator vs. corporate tie-ups
● Share of policybazaar, bank channels, direct digital apps in retail premium
Impact of new platforms like Bima Sugam on distribution commissions and
channel power
● Trends in POSP (Point of Sale Persons), broker share, and channel mix
evolution

5. Product Design and Innovation


● Trends in customized plans, OPD coverage, wellness-linked premiums,
disease-specific covers (diabetes, cancer), mental health
● Penetration of top-up/super top-up plans and indemnity vs. benefit-based
plans
● Product IRR analysis: impact of waiting periods, room rent capping, sub-limits
on profitability
● ESG/Preventive Health as differentiators (rewards for active lifestyle, Fitbit
integrations, etc.)

6. Operating Metrics & Financial Benchmarking


● Key financials (FY19–FY26E where available):
GWP (Gross Written Premium), NEP (Net Earned Premium), Net Incurred
Claims (NIC), Loss Ratio, Combined Ratio, Solvency Ratio, Operating
Expense
● Ratio Claims analysis:
COVID impact, frequency trends, inflation trends (esp. in private hospitals)
● Persistency, renewal ratios, and customer retention metrics
● Capital allocation and solvency margin buffers vs. IRDA norms

7. Company Deep Dive: [Pick 1–2 listed players]


● Example: Star Health & Allied Insurance Market positioning and focus areas:
retail leadership, hospital network, claim settlement benchmarks
● Growth strategy: tier-2 expansion, agency buildout, digital journey
● Operating performance: expense ratios, loss ratio trends, underwriting
profitability
● New initiatives: tech stack, CRM, vertical integration (TPAs)
● Product suite and evolution Valuation multiples: P/E, EV/NEP, P/GWP vs.
peers If needed, can also do a secondary focus on Niva Bupa / HDFC Ergo or
Digit (once listed)

8. Emerging Trends & Tech Disruption


● Insurtech-led models (Acko, Digit, Plum): tech-enabled underwriting,
embedded insurance (with e-commerce, rideshare, etc.)
● Role of TPAs vs. in-house claims management and digitization
● Health analytics, wearables, AI-led underwriting and fraud detection
● API stack and UPI-linked premium payments via Bima Sugam

9. Risks and Industry Challenges


● Pricing pressures due to hospital rate negotiations and unregulated medical
inflation Adverse selection and high loss ratios in mass-market products
Fraud risk, moral hazard, and claim inflation due to diagnostic and admission
practices
● Regulatory risk (e.g., IRDAI pushing for low-margin government products)
● Long claim settlement cycles and litigation risk 10. Investor
● Lens Valuation comparison: Star Health vs. ICICI Lombard vs. Digit (post
listing), across EV/EBITDA, EV/NEP, P/GWP Potential re-rating triggers:
scale leverage, regulatory clarity, digital success, profitable group retail mix
● Red flags: elevated combined ratios, one-off claims spikes, too-aggressive
pricing in newer segments
● Key questions:
● Is there a moat in hospital networks or agent ecosystems?
● Can any player achieve a sustainable 95% combined ratio in a rising claims
environment?
● Is the embedded model (Acko/Digit) disrupting faster than legacy models can
adapt?
Use the credit rating reports, companies conference calls (let me know if you need
links of the same), research reports from several sell sides, and all relevant sources.

I am a fund manager and I am using it as my core and sole senior analyst, hence the
purpose is to make investment decisions based on this. heavy on analysis, keep the
output PDF style. as insightful and detailed as we can get.

Tyre Industry

You are a world class equity analyst who specialises in understanding and doing
financial statement analysis of a business well. Your analysis must be 100% factually
accurate, if you're uncertain about any number or fact, explicitly state "unable to
verify" rather than guessing.

The purpose is to make investment decisions based on this. heavy on analysis, keep
the output PDF style. as insightful and detailed as we can get. Analyze the industry
and company using Uploaded documents: Credit rating notes, annual reports,
conference call transcripts, DRHP, and rating links and External sources: you have
freedom to choose links, blogs, PDFs, notes which you find to be relevant.

The goal is to understand the industry and company like someone who has no
background to it. By the end of this report, I should have a very strong grip about the
company and industry. Don’t make the tone very salesy, keep it relevant and neutral.

Generate a detailed research report on the Indian Tyre Industry, with a company-
specific deep dive on Balkrishna Industries Ltd (BKT). The report should include:

1. Industry Overview:
● Market size of the Indian tyre industry in FY25 and outlook through FY28
● Segmental breakdown: Passenger Vehicle (PV), Two-Wheeler, Commercial
Vehicle (CV), Off-Highway Tyres (OHT), Agri, Mining & Industrial segments
● Demand drivers: Auto OEM production trends, replacement market demand,
rural/agri cycles, mining & infra capex, global off-highway demand
● Export vs Domestic mix – India’s position as a global manufacturing hub

2. Industry Structure and Players:


● Key players: MRF, Apollo Tyres, CEAT, JK Tyre, Balkrishna Industries (BKT),
TVS Srichakra
● Segment focus comparison – who plays in which space (e.g., BKT in OHT vs
CEAT in 2Wheeler/PV)
● Organized vs unorganized market dynamics
● OEM vs replacement vs export mix for each major player

3. Operational & Financial Metrics:


● Revenue and EBITDA trends FY22–FY25E across key players
● Segment-wise revenue share (TBR, PCR, 2W, OHT, Agri)
● Margins by segment (OHT vs PV vs CV tyres)
● Capex cycles, capacity utilization, and volume growth
● Return ratios (ROCE/ROE), working capital intensity, inventory trends

Key Industry Trends:


● Raw material trends: natural rubber, crude derivatives (carbon black, synthetic
rubber), and the impact on margins
● Export opportunity from China+1 strategy
● Radialisation in CV segment,
● PCR replacement tailwinds
● EV impact: change in tyre specs, demand for low rolling resistance tyres
● Sustainability trends: use of green materials, carbon-neutral plants, EPR
norms
● Regulatory Environment: Import duties, BIS regulations on tyre quality, anti-
dumping measures
● Export incentives (RoDTEP, FTAs, EU compliance)
● Scrappage policy impact on replacement demand

4. Company Deep Dive: Balkrishna Industries Ltd (BKT)

Business Overview:
● Focus on Off-Highway Tyres (OHT) including agriculture, mining,
construction, industrial, and forestry.
● Export-heavy model (~70–75% revenue from exports) – key geographies (EU,
US, LATAM).
● Product mix and SKU diversity (~2,700 SKUs), niche market leadership.
● Volume trends vs realization trends FY22–FY25
● Operating margin profile vs peers – why BKT maintains 25–28% EBITDA
margins.
● Capex programs: Bhuj expansion, carbon black capacity, Waluj plant —
impact on volume and margin.
● Backward integration strategy (carbon black, captive power, in-house moulds)
and its margin advantages.
● R&D investments, brand initiatives (e.g., MotoGP sponsorship), digital &
dealer strategy.
● Raw material sourcing: latex, rubber chemicals, cost pass-through
mechanisms.
● Key risks: weather dependency (agri), freight & container cost volatility, EU
demand slowdown.
● BKT vs Peers: Benchmark against CEAT, MRF, JK Tyres on the following:
Volume growth, Margin profile, Export share, Return ratios, Capex intensity
Specialization, and pricing power.

Investor Perspective:
● What metrics investors track in the tyre space: Volume vs realization
contribution
● Raw material cost (% of sales)
● Export order book visibility
● ROCE > WACC sustainability
● EBITDA/t per tonne of tyre sold
● Revenue per tonne vs input cost per tonne
● Valuation range: EV/EBITDA or P/E for major tyre stocks, and premium
justified for BKT due to niche and export-led business.

Cables

You are a world class equity analyst who specialises in understanding and doing
financial statement analysis of a business well. Your analysis must be 100% factually
accurate, if you're uncertain about any number or fact, explicitly state "unable to
verify" rather than guessing. The purpose is to make investment decisions based on
this. heavy on analysis, keep the output PDF style, as insightful and detailed as we
can get.

Analyze the industry and company using Uploaded documents: Credit rating notes,
annual reports, conference call transcripts, DRHP, and rating links and External
sources: you have freedom to choose links, blogs, PDFs, notes which you find to be
relevant.

The goal is to understand the industry and company like someone who has no
background to it. By the end of this report, I should have a very strong grip about the
company and industry. Don’t make the tone very salesy, keep it relevant and neutral.

Create a comprehensive research report on the Indian Cables & Wires industry,
including a deep dive on Polycab India Ltd. The report should include:

1. Industry Overview:
● Market size in FY25 and growth outlook through FY28
● Segmental breakdown: Power cables, Control cables, House wires, Optical
fiber, Specialty cables
● Demand drivers: Infra push (T&D, railways, smart cities), real estate recovery,
electrification, industrial capex, EV and solar energy segments
● Export opportunity: which geographies Indian players are expanding to

2. Industry Structure & Players:


● Key listed players: Polycab, KEI Industries, RR Kabel, Havells (wires), Finolex
Cables, Apar Industries (specialty cables)
● Unlisted players and fragmented tail – regional/contract manufacturers
● Market share estimates and positioning (organized vs unorganized market)
● Comparison of B2B vs B2C mix among key players

3. Operating & Financial Metrics:


● Revenue, EBITDA, PAT growth (FY22–FY25E)
● Segment contribution to sales (Cables & Wires vs FMEG or EPC where
applicable) EBITDA margins, ROCE, ROE trends
● Capex cycles, capacity utilization, working capital cycles
● Price realization trends vs raw material volatility (copper/aluminium)

4. Key Operational KPIs:


● Volume growth (km/tonne), price realization, channel mix (distribution vs
institutional)
● Contribution of project vs retail business
● Dealer network strength and geographic penetration
● Inventory and receivable cycles – key to working capital efficiency
● Exports as % of revenue, product approvals, and certifications

5. Trends & Strategic Themes:


● Shift from unorganized to organized players post-GST and quality standard
enforcement (BIS, CPR norms)
● Backward integration in copper/aluminum processing
● Entry into adjacent segments: FMEG, optical fiber, EPC Emerging themes:
Solar cables, EV charging infra, defense/aerospace, smart building wiring
● Raw material risk management: hedging strategies and procurement models
● Policy & Regulatory Factors: Govt capex and housing electrification push
(e.g., PMAY, DDUGJY, Saubhagya) BIS standards, safety certifications ,
export compliance PLI schemes (if any), import duties, anti-dumping
regulations

6. Company Deep Dive:


Polycab India Ltd Business overview:
● Cables & Wires (~85%+ of revenue), FMEG (~10%), EPC & others
● Revenue & segmental growth (3Y CAGR), export share, margin trends
● Volume vs realization analysis over FY22–FY25
● Dealer/distributor expansion, channel strength, B2C share Capex plans,
capacity addition, new product launches
● Export strategy: key markets, certifications, opportunity size Balance sheet
analysis: ROCE, cash conversion, asset turns, working capital
● Competitive advantages: backward integration, brand equity, distribution,
operating leverage
● Risks: commodity cost fluctuations, FMEG margin drag, working capital
intensity
● Benchmark vs Peers:
Table comparing Polycab vs KEI, Finolex, RR Kabel, Havells (wire segment)
on: Revenue/EBITDA/PAT Margin profile ROCE Export share
● Dealer network size B2C/B2B mix "Include commentary from recent earnings
calls and management guidance (esp. on FMEG turnaround or export
momentum).”

Wealth Management

You are a world class equity analyst who specialises in understanding and doing
financial statement analysis of a business well. Your analysis must be 100% factually
accurate, if you're uncertain about any number or fact, explicitly state "unable to
verify" rather than guessing.

The purpose is to make investment decisions based on this. heavy on analysis, keep
the output PDF style. as insightful and detailed as we can get. Analyze the industry
and company using Uploaded documents: Credit rating notes, annual reports,
conference call transcripts, DRHP, and rating links and External sources, you have
freedom to choose links, blogs, PDFs, notes which you find to be relevant. The goal
is to understand the industry and company like someone who has no background to
it. By the end of this report, I should have a very strong grip about the company and
industry. Don’t make the tone very salesy, keep it relevant and neutral.

Generate a detailed industry research report on the Indian Wealth Management and
Financial Advisory industry, focusing on listed players. The report should include:

1. Market Overview:
● Size of Indian wealth management AUM in FY25 (segmented by HNI/UHNI,
retail, family office)
● Growth outlook through FY28: driven by financialization of savings, rising
affluence,
● DII flows Penetration levels vs global benchmarks (e.g., WM AUM as % of
GDP)
● Shift from transaction-based to fee-based advisory model (RIA vs ARN
landscape)
2. Key Players & Landscape:
● Listed entities: 360 ONE (IIFL Wealth), Nuvama Wealth (Edelweiss), Prudent
Corporate Advisory, Anand Rathi Wealth, NJ Advisory, ASK Group (if
relevant)
● Unlisted or global competitors with domestic presence: ICICI, Kotak Wealth,
Julius Baer, Credit Suisse, etc.

● Player comparison: AUM, client mix (HNI vs UHNI vs mass affluent),


geography, channel strategy

● Revenue & Business Model Breakdown:


○ Transaction vs recurring revenue split (e.g., trail commissions,
PMS/AMC fees, brokerage)
○ Advisory AUM vs distribution AUM vs discretionary AUM Fee yields (%
of AUM), net flows, SIP share, insurance/loan cross-sell

● Breakup by product: MF, PMS, AIF, insurance, bonds, equity

● Financial and Operating Metrics: Revenue and PAT growth (FY22–FY25E)


EBITDA/PAT margins, ROE/ROCE trends Client acquisition cost (CAC),
wallet share, RM productivity

● Channel metrics: number of partners/IFAs, average ticket size, client


stickiness, churn Break-even AUM per RM / per city

3. Strategic & Structural Trends:


● Shift toward digital wealth platforms & hybrid advisory
● Regulatory changes:
TER caps, RIA vs distributor conflict, SEBI fee capping frameworks
● Emergence of AIFs, PMS and direct plans
● Consolidation trends and entry of fintechs into HNI space
● Margin headwinds due to TER cuts, yield compression, competition

4. Investor View:
● What KPIs matter most to investors: AUM growth, fee yields, share of
recurring revenue
● Valuation ranges: EV/EBITDA or P/E multiples of listed wealth managers
● Commentary from recent earnings calls and investor presentations

5. Case Study – Deep Dive:


● Pick one: 360 ONE or Prudent Corporate Advisory Services Break down AUM
by product/channel
● Partner/IFA network evolution New initiatives (e.g., PMS/AIF expansion,
digital platforms)
● Benchmarking vs peers on return ratios, net flows, client growth

● Include commentary on differences in approach between players targeting


UHNI (e.g., 360 ONE) vs retail/MFD-heavy models (e.g., Prudent, NJ).
● “Segment AUM growth by geography (metro vs non-metro) and by investor
cohort (new age investors, family offices, professionals).”
● “Highlight evolving competition from fintechs (Groww, Zerodha-backed
platforms) in advisory and investment tech.”

Use the credit rating reports, companies conference calls (let me know if you need
links of the same), research reports from several sell sides , and all relevant sources.

CDMO CRO

You are a world class equity analyst who specialises in understanding and doing
financial statement analysis of a business well. Your analysis must be 100% factually
accurate, if you're uncertain about any number or fact, explicitly state "unable to
verify" rather than guessing.

The purpose is to make investment decisions based on this, heavy on analysis, keep
the output PDF style, as insightful and detailed as we can get. Analyze the industry
and company using Uploaded documents: Credit rating notes, annual reports,
conference call transcripts, DRHP, and rating links and External sources: you have
freedom to choose links, blogs, PDFs, notes which you find to be relevant.

The goal is to understand the industry and company like someone who has no
background to it. By the end of this report, I should have a very strong grip about the
company and industry. Don’t make the tone very salesy, keep it relevant and neutral.

Create a detailed industry report on the Indian CDMO/CRO (Contract Development


& Manufacturing Organization / Contract Research Organization) sector. The report
should include:

Market Landscape:
● Estimated market size for FY25 and projected growth through in future, but
also how does the short terms looks like Breakdown of domestic vs export
opportunity
● Key demand drivers: patent cliffs, outsourcing trends, cost arbitrage, China+1,
biotech funding cycles

● Value chain segmentation: preclinical CRO, clinical CRO (phases I–IV), drug
substance (API/intermediates), and drug product (formulations)

● Key Players (listed & unlisted):


Major Indian CDMO/CROs like Syngene, Suven Pharma, Gland Pharma,
Aragen, Anthem Biosciences, Divi’s (custom synthesis), Piramal Pharma
Solutions, Neuland Labs, Laurus Labs (CDMO), Sai Life Sciences, etc.

● Global context: how Indian players compare with Lonza, Catalent, WuXi, etc.
Ownership patterns – private equity involvement, MNC partnerships

Financial & Operational Metrics:


● Revenue, EBITDA, PAT trends for top players (FY18–FY25E) Export share,
R&D intensity, asset turnover, order book visibility
● EBITDA margin ranges (API vs formulations vs biologics)
● Capex cycles, utilization levels, ROCE/ROE trends
● Operational KPIs: Client concentration (top 5 clients as % of revenue)
● Repeat business/share of long-term contracts
● Pipeline visibility, molecule count under development
● Biotech vs Big Pharma share in revenue
● Regulatory audit status (USFDA, EMA, PMDA) for key sites

● Strategic Themes: Shift from generics to NCE/biologics-focused development


● Vertical integration: from DMPK to scale-up to commercial supply India's
competitive edge: cost, quality, compliance, turnaround times

● Risks: US biotech slowdown, FDA warning letters, input cost pressures

● Future Outlook: Emerging segments like ADCs, gene therapy platforms,


HPAPI, oncology-focused CDMOs Role of CDMO partners in 505(b)(2) and
orphan drugs
● Digitalization and automation trends in CROs (eClinical, remote monitoring,
data analytics).
● Highlight valuation ranges (EV/EBITDA, PE multiples) for Indian CDMO/CRO
players.”
● “Discuss PE/VC activity or consolidation trends in the space.

Case Study:
● Detailed profile of a player like Syngene or Suven Pharma Client mix, revenue
segmentation, expansion plans
● Operational and financial benchmarking vs global peers
● Growth drivers (biologics, integrated services, animal toxicology, etc.)

Hotels

You are a world class equity analyst who specialises in understanding and doing
financial statement analysis of a Business well. Your analysis must be 100%
factually accurate, if you're uncertain about any number or fact, explicitly state
"unable to verify" rather than guessing.

The purpose is to make investment decisions based on this. heavy on analysis, keep
the output PDF style. as insightful and detailed as we can get. Analyze the industry
and company using uploaded documents: credit rating notes, annual reports,
conference call transcripts, DRHP, and rating links and external sources, you have
freedom to choose links, blogs, PDFs, notes which you find to be relevant.

The goal is to understand the industry and company like someone who has no
background to it. By the end of this report, I should have a very strong grip about the
company and industry. Don’t make the tone very salesy, keep it relevant and neutral.

Generate a deep-dive industry overview for the Indian Hotel Sector, with a focus on
premium business hotel operators. The report should include:

● Market size (FY25) and growth outlook through FY28 Major listed and unlisted
players (e.g., Indian Hotels, Chalet, Lemon Tree, SAMHI Hotels, Royal
Orchid, OYO if relevant)
● Breakdown by hotel type (luxury, mid-scale, budget), and demand segments
(business vs leisure, international vs domestic)
● Operating KPIs: RevPAR, ADR, Occupancy rate, EBITDA margins, room
additions planned
● Return ratios: ROCE, ROE trends for top players
● Commentary on capex cycles, asset-light vs asset-heavy models
● Peer benchmarking table (beds/rooms, revenue, margins, growth, valuations)
● Key industry trends: medical tourism, spiritual tourism, weddings, MICE,
corporate travel recovery Impact of regulatory issues: GST, licensing,
sustainability mandates (ESG)
● Funding activity (PE/VC/REIT interest in hotel assets, IPOs)
● “Include granular metrics like ARPOB equivalents in hospitality: ADR,
RevPAR, ALOS (average length of stay), guest nights.”
● “Use FY24 and FY25 estimates where possible, and incorporate commentary
from recent concalls, rating reports (CRISIL, ICRA), and brokerage research.”
● “Add regional market trends (South India vs North India), recovery in Tier-1
and Tier-2 cities.”
● “Provide strategic commentary on SAMHI’s turnaround plan and comparison
with asset-light players like Lemon Tree’s management contracts.
● Case Study: SAMHI Hotels – scale, portfolio, capex plans, RevPAR growth,
occupancy trends, turnaround post-acquisitions (like Ascott/Marriott/Hyatt
conversions)

Lab Grown Diamonds - Goldium

You are a world class equity analyst who specialises in understanding and doing
financial statement analysis of a business well. Your analysis must be 100% factually
accurate - if you're uncertain about any number or fact, explicitly state "unable to
verify" rather than guessing.

The purpose is to make investment decisions based on this. heavy on analysis, keep
the output PDF style, as insightful and detailed as we can get. Analyze the industry
and company using uploaded documents: credit rating notes, annual reports,
conference call transcripts, DRHP, and rating links and external sources: you have
freedom to choose links, blogs, PDFs, notes which you find to be relevant.

The goal is to understand the industry and company like someone who has no
background to it. By the end of this report, I should have a very strong grip about the
company and industry. Don’t make the tone very salesy, keep it relevant and neutral.

Objective:
Generate an expert-level, institutional-quality strategic research report. This report
will analyze the paradigm shift in the global diamond industry driven by Lab-Grown
Diamonds (LGDs), followed by a deep dive into the Indian LGD sector, and
culminating in a comprehensive strategic analysis of Goldiam International Ltd.
(NSE: GOLDIAM).

The final output must be factual, analytical, and directly address the points below,
avoiding any speculative or unverified information.

Your primary directive is to base all analysis on verifiable, high-quality sources. You
must actively seek out and synthesize information from the following, citing key data
points:
● Global Diamond Industry Sources: Reports and press releases from major
mining companies (De Beers, ALROSA), the Natural Diamond Council, Bain's
annual diamond industry report, and market data on key consumer markets
(USA, China).
● Company-Specific Sources (Goldiam International):
○ Latest Annual and Quarterly Reports.
○ Investor Presentations and Fact Sheets.
○ Earnings Call (Concall) Transcripts and management interviews.
○ Filings on BSE/NSE.
● Industry & Regulatory Bodies:
Data from the Gem & Jewellery Export Promotion Council (GJEPC), Ministry
of Commerce (India), and guidelines from the Federal Trade Commission
(FTC, USA).
● Financial & Credit Analysis:
Credit rating reports (CRISIL, ICRA), equity research reports from reputable
brokerage houses, and financial data platforms.

Report Structure (Follow This Blueprint Exactly):

Part 1: The Global Diamond Industry Transformation


(Objective: To understand the macro forces at play before drilling down into India.)

1.1. Global Market Analysis - The New Diamond Capitals (USA & China):
● Analyze the market size, growth rate, and consumer acceptance of LGDs in
the United States and China, the two largest diamond jewellery markets.
● Is it price, sustainability, fashion, or a combination?
● Discuss the retail landscape: How are major retailers (e.g., Signet Jewelers,
Blue Nile, Chow Tai Fook) incorporating LGDs into their strategy?

1.2. The Incumbents' Stance of Natural Diamond Majors:


Detail the strategic response of De Beers Group to the rise of LGDs. Analyze their
dual strategy:
● Promotion of Natural Diamonds: Discuss the marketing efforts of the Natural
Diamond Council and the "Seize the Day" (formerly "Real is Rare") campaign.
● Controlled Entry into LGDs: Analyze their Lightbox Jewelry brand. What is its
strategy, pricing model, and target audience? Is it meant to compete directly
or to segment the market and protect the value of natural diamonds?
● Briefly cover the stance of other major producers like ALROSA on the LGD
market.
● Discuss the importance of the US Federal Trade Commission (FTC)
guidelines, which classify both mined and lab-grown stones as "diamonds."
How has this influenced marketing and consumer perception?

Part 2: India's Rise as the Global LGD Powerhouse


(Objective: To connect global trends to the specific dynamics of the Indian market.)
2.1. Market Size, Scale, and Projections:
● Provide the current market size (in INR crore) and projected CAGR for the
Indian LGD industry for the next 5 years.
● Detail India's dominant share in the global processing of LGDs, especially
leveraging the existing infrastructure in Surat.

2.2. The India Growth Story - Key Drivers:


● Go beyond generic points. For each driver, provide specific Indian context:
● Price Arbitrage: How is it influencing the massive Indian wedding market?
● Domestic Consumption: Profile the Indian consumer for LGDs. Is it a Tier-1
city phenomenon? How is it perceived in bridal vs. fashion jewellery?
● Government Policy & 'Make in India': Analyze the impact of the removal of
import duty on LGD seeds and the Production Linked Incentive (PLI) scheme,
if applicable.

2.3. Export-Import (EXIM) Analysis:


● Using the latest GJEPC data, create a comparative analysis showing the
growth trajectory of polished LGD exports from India versus the trend for
polished natural diamond exports over the last 3 years.

2.4. Competitive Ecosystem:


Map out the key players in the Indian LGD market, categorizing them:
● Integrated Players: (e.g., Goldiam)
● Pure-Play LGD Retail Brands: (e.g., Limelight, Aurelee)
● Traditional Giants with LGD Verticals: (e.g., Tanishq, Senco Gold)

Part 3: In-Depth Strategic Analysis: Goldiam International Ltd.


(Objective: A granular, data-backed analysis of the target company.)

3.1. Company Vitals & Business Model:


● Provide a snapshot of Goldiam: business history, leadership, and its strategic
pivot from a traditional exporter to an LGD-focused powerhouse.
● Detail its business model: B2B focus on major US retailers and the nascent
B2C "Origem" brand strategy.

[Link] Analysis:
● Create a summary table of Goldiam's financial performance for the last 3-5
fiscal years (Revenue, EBITDA, PAT, and Margins %).
● Analyze the Balance Sheet strength: focus on the Debt-to-Equity ratio and
cash flow generation (Cash Flow from Operations).
● From the latest investor presentation or annual report, provide the revenue
split between the LGD jewellery segment and the natural diamond segment.
Analyze the growth rate of each.
3.3. Management Commentary & Strategic Outlook (from Concalls):
● Synthesize key insights from the management's commentary in the last two
earnings calls. Focus on:
● Guidance on future growth and margins.
● Commentary on the order book from US clients.
● Plans for the expansion of the "Origem" retail brand.
● Update on backward integration and capex for LGD manufacturing.

3.4. Peer Benchmarking:


● Create a table comparing Goldiam International to its closest listed peers.
● Compare them on: Market Cap, P/E Ratio, ROE, ROCE, and 3-Year Sales
Growth.

3.5. Investment Rationale & Key Risks:


● Investment Thesis (Bull Case): Summarize the key arguments FOR investing
in Goldiam. (e.g., strong export relationships, high-growth segment, healthy
balance sheet).
● Key Risks (Bear Case): Summarize the potential risks. (e.g., over-reliance on
the US market, execution risk in the domestic retail strategy, potential for LGD
price erosion due to oversupply, high competition).

Prompt for Class 4


You are a world class equity analyst who specialises in making value chains. I have
given you the information related to XYZ CO above which is a lead recycler. I want
you to make a detailed value chain image starting right from raw materials to the
different types of products that Pondy oxides is dealing in. Make the image in a very
simple way that I can use in a presentation and explain the value chain from first
principles.

If you have any questions, feel free to ask. If you do the task well I will reward you.

Hari om vs Sambhv Prompt

You are a world class equity analyst who specialises in making value chains &
comparing two companies within the same value chain. I have given you the
information related to HARI OM Pipes and Sambhv Sponge which are into the steel
tubes sector. You can even use information outside the domain of what I have given
you for a better explanation. I want you to make a detailed value chain comparative
analysis of the two. Make the image of value of both the companies in a very simple
way that I can use in a presentation and explain the value chain from first principles.
Explain the key differences in the products/business of both the companies using the
value chain analysis. If you have any questions, feel free to ask. If you do the task
well I will reward you

Walk The Talk | Prompt for Class 5

Upload all concalls of different businesses.

Give this prompt to check for the company walking the talk or not.

"Analyze [Company Name]'s 'walk the talk' from FY20 to FY25. Create a table with
columns: Year/Period, Management Guidance (Quantitative & Qualitative), Actual
Outcome, Indicator (green dot for achieved, yellow for almost met, red for missed,
double green for overachieved). Source from annual reports, earnings calls, and
financial data. Focus on revenue growth, EBITDA margins, product launches,
exports, and approvals. Include indicators and a summary."

You might also like