Financial Analysis Internship in Kolkata

Task Objective: Analyse the financial statements of a listed company and understand its financial position.

Student Activities: 1.

Select one listed Indian company and download its latest annual report from a reliable public source.

2.

Study the balance sheet, profit and loss statement, and cash flow statement and identify the important financial figures.

3.

Prepare a simple table showing revenue, profit, assets, liabilities, operating cash flow, and other important figures.

4.

Explain what the financial statements indicate about the company performance, financial position, and cash generation.

Student Submission: Submit a 4-page Financial Statement Analysis Report in PDF format along with the Excel/Google Sheets file containing the collected figures.

Mode: This task can be completed remotely from home using publicly available information, spreadsheets, documents, presentation tools, or fictional business data where specified.

Task Objective: Calculate and interpret important financial ratios using three years of company data.

Student Activities: 1.

Collect three years of financial information for the selected company.

2.

Calculate liquidity, profitability, solvency, and efficiency ratios using a spreadsheet.

3.

Compare the ratio movement across the three years and identify positive or negative trends.

4.

Compare selected ratios with one competitor and explain the major differences.

Student Submission: Submit the completed ratio-analysis spreadsheet and a 3-page interpretation report explaining the financial trends.

Mode: This task can be completed remotely from home using publicly available information, spreadsheets, documents, presentation tools, or fictional business data where specified.

Task Objective: Estimate the value of a company using multiple valuation approaches.

Student Activities: 1.

Study comparable-company valuation and discounted cash flow valuation concepts.

2.

Select at least three comparable companies and calculate relevant valuation multiples.

3.

Prepare a simple DCF model using clearly stated revenue, margin, growth, and discount-rate assumptions.

4.

Compare the valuation results and explain why different methods may produce different values.

Student Submission: Submit the Excel valuation model and a valuation report containing assumptions, calculations, results, limitations, and conclusion.

Mode: This task can be completed remotely from home using publicly available information, spreadsheets, documents, presentation tools, or fictional business data where specified.

Task Objective: Combine the complete financial analysis into a professional academic equity-research style project.

Student Activities: 1.

Prepare a company overview covering the business model, products, market, competitors, and major risks.

2.

Include the financial statement analysis, ratio analysis, and valuation work completed in the previous tasks.

3.

Prepare a clear investment-style conclusion supported by financial evidence and clearly mention that it is an academic exercise.

4.

Create a professional presentation summarising the company, financial performance, valuation, risks, and conclusion.

Student Submission: Submit a complete Final Project consisting of a 8–10 page PDF report, Excel financial model, and 8–10 slide PowerPoint presentation.

Mode: This task can be completed remotely from home using publicly available information, spreadsheets, documents, presentation tools, or fictional business data where specified.