Investor relations

Act as a junior Corporate Finance analyst. Use public information to produce a decision-ready work product for a manager or interview panel.

Show that you can apply Fpa, Treasury, Financial Modeling, Power Bi, Investor Relations in a practical analyst workflow, not only explain the theory.

• Define the business model and key operating drivers.
• Create clean input, historicals, forecast, output, and checks tabs.
• Separate assumptions from formulas.
• Decide base, upside, and downside scenarios before modeling.

1. Build historical P&L, balance sheet, and cash flow lines.
2. Create drivers for revenue, cost, margin, capex, working capital, and debt.
3. Link the statements and add balance checks.
4. Create scenario and sensitivity outputs.
5. Write a finance-manager style summary with the main movement, risk, and decision required.

• Professional brief
• Financial model or analytical workbook
• Presentation deck
• Source log
• Interview talking points
• Source and assumption log
• One-page executive summary
• Final output file

• Annual reports, investor presentations, exchange filings, SEBI/RBI/NSE/BSE pages, and official company disclosures.
• Company annual report
• Quarterly filings
• Investor presentation
• Public industry data
• Synthetic operating dataset if company data is unavailable

• Clear problem statement and role context
• Source-backed assumptions
• Clean model, memo, notebook, or dashboard
• Decision recommendation with risks
• Resume bullet and interview talk track

• Problem: explain the business question and why it matters for Corporate Finance.
• Method: describe the data collected, assumptions made, and analysis performed.
• Decision: state the recommendation, key risk, and what would change your view.

Act as a junior Corporate Finance analyst. Use public information to produce a decision-ready work product for a manager or interview panel.

Show that you can apply Fpa, Treasury, Financial Modeling, Power Bi, Investor Relations in a practical analyst workflow, not only explain the theory.

• Define the business model and key operating drivers.
• Create clean input, historicals, forecast, output, and checks tabs.
• Separate assumptions from formulas.
• Decide base, upside, and downside scenarios before modeling.

1. Build historical P&L, balance sheet, and cash flow lines.
2. Create drivers for revenue, cost, margin, capex, working capital, and debt.
3. Link the statements and add balance checks.
4. Create scenario and sensitivity outputs.
5. Write a finance-manager style summary with the main movement, risk, and decision required.

• Professional brief
• Financial model or analytical workbook
• Presentation deck
• Source log
• Interview talking points
• Source and assumption log
• One-page executive summary
• Final output file

• Public transaction announcements, DRHP/RHP filings, exchange releases, rating reports, and company presentations.
• Company annual report
• Quarterly filings
• Investor presentation
• Public industry data
• Synthetic operating dataset if company data is unavailable

• Clear problem statement and role context
• Source-backed assumptions
• Clean model, memo, notebook, or dashboard
• Decision recommendation with risks
• Resume bullet and interview talk track

• Problem: explain the business question and why it matters for Corporate Finance.
• Method: describe the data collected, assumptions made, and analysis performed.
• Decision: state the recommendation, key risk, and what would change your view.

Act as a junior Corporate Finance analyst. Use public information to produce a decision-ready work product for a manager or interview panel.

Show that you can apply Fpa, Treasury, Financial Modeling, Power Bi, Investor Relations in a practical analyst workflow, not only explain the theory.

• Define the business model and key operating drivers.
• Create clean input, historicals, forecast, output, and checks tabs.
• Separate assumptions from formulas.
• Decide base, upside, and downside scenarios before modeling.

1. Build historical P&L, balance sheet, and cash flow lines.
2. Create drivers for revenue, cost, margin, capex, working capital, and debt.
3. Link the statements and add balance checks.
4. Create scenario and sensitivity outputs.
5. Write a finance-manager style summary with the main movement, risk, and decision required.

• Professional brief
• Financial model or analytical workbook
• Presentation deck
• Source log
• Interview talking points
• Source and assumption log
• One-page executive summary
• Final output file

• Public filings, official regulatory material, public datasets, company career/domain research, and a documented source log.
• Company annual report
• Quarterly filings
• Investor presentation
• Public industry data
• Synthetic operating dataset if company data is unavailable

• Clear problem statement and role context
• Source-backed assumptions
• Clean model, memo, notebook, or dashboard
• Decision recommendation with risks
• Resume bullet and interview talk track

• Problem: explain the business question and why it matters for Corporate Finance.
• Method: describe the data collected, assumptions made, and analysis performed.
• Decision: state the recommendation, key risk, and what would change your view.