"Financial Odyssey: Navigating Past Performance Through Diverse Analytical Lens"

Embark on a captivating financial journey with 'Financial Odyssey,' our hackathon project. Delve deep into the past performance of two companies as we employ an array of financial statement analysis techniques. From ratio analysis to trend analysis, uncover insights crucial for informed decision-making in the dynamic world of finance."

1. Finance Hackathon Financial Analysis of Ambuja Cement & J.K. Lakshmi Cement Vivek Sengar Dhwani Patel Bhavya Detroja Dhruvi Dudhat Lipi Oza Sameer Shah Prince Vadher

2. OBJECTIVES To understand market valuation of companies. To identify companies financial position in the market using past data. To compute and analyze past performance of companies using different techniques of financial statement analysis.

3. AMBUJA CEMENT Owner name: Adani Group Founders:   Narotam Sekhsaria, Suresh Kumar Neotia Business Start-up : since 1983 Business type: Cement company Headquarter: Mumbai Giant Compressive Strength

4. MISSION To create value for all: Delighted Customers Inspired Employees Enlightened Partners Energised Society Loyal Shareholders Healthy Environment To be the most sustainable and competitive company in our industry. VISION

5. Horizontal analysis For profit and loss statement: Mar-23 Mar-22 ABSOLUTE CHANGE % CHANGE Total Revenue 20,937.70 16,532.99 4,404.71 26.64 Total Expenses 17,725.38 14,044.73 3,680.65 26.21 Profit/Loss Before Exceptional, ExtraOrdinary Items And Tax 3,212.32 2,488.26 724.06 29.10 Total Tax Expenses 501.56 360.61 140.95 39.09 Profit/Loss For The Period 2,553.49 2,051.09 502.40 24.49

6. Increase is seen in all the parameters which indicates that with increase in the revenue of a company expense also increase . Overall, it suggest that with increase revenue company is gaining more profit which also suggest that operational performance and tax implication are getting better.

7. For balance sheet: Mar-23 Mar-22 ABSOLUTE CHANGE % CHANGE Total Shareholders Funds 28,505.54 28,007.51 498.03 1.778201632 Total Capital And Liabilities 35,904.13 34,111.80 1792.33 5.25428151 Total Assets 35,904.13 34,111.80 1792.33 5.25428151 .

8. There is slight increase in the shareholder’s fund, capital & liabilities and assets which results in interpreting that company’s financial condition is good . Company is earning a profit which resulted in investing in assets which ultimately increase liability

9. VERTICAL ANALYSIS For profit and loss statement: Mar-23 Mar-22 Mar-23 % change Mar-22 % change Total Revenue 20,937.70 16,532.99 106.0445446 105.1107119 Total Expenses 17,725.38 14,044.73 89.77489649 89.29126359 Profit/Loss Before Exceptional, ExtraOrdinary Items And Tax 3,212.32 2,488.26 16.26964813 15.81944826 Total Tax Expenses 501.56 360.61 2.54028388 2.29262667 Profit/Loss For The Period 2,553.49 2,051.09 12.93282855 13.04008107 The company has experienced substantial revenue growth, effectively managing expenses, and improving profitability. The moderate increase in tax expenses indicates a relatively favorable tax scenario. Overall, it explain that company is in good condition and making profit.

10. For Balance sheet: Mar-23 Mar-22 Mar-23 % Change Mar-22 % Change Total Shareholders Funds 28,505.54 28,007.51 79.39348482 82.10504869 Total Non-Current Liabilities 975.12 667.89 2.715899257 1.957944172 Total Current Liabilities 6,423.47 5,436.40 17.89061593 15.93700714 Total Capital And Liabilities 35,904.13 34,111.80 100 100 Total Non-Current Assets 24,657.62 23,235.11 68.67627763 68.11458205 Total Current Assets 11,246.51 10,876.69 31.32372237 31.88541795 Total Assets 35,904.13 34,111.80 100 100 It gives the idea that company has retained earnings, and is trying to expand along with new investments. Therefore, looking at the data one can say that company is growing at its pace and have potential to compete in the market.

11. Trend analysis Ambuja Cements P&L (Trend Analysis) Change in %   Mar 23 Dec-22 Dec-21 Dec-20 Dec-19 Dec-18   Mar 23 Dec-22 Dec-21 Dec-20 Dec-19 Dec-18 Revenue From Operations [Gross] 19,744.25 15,729.12 13,793.56 11,174.97 11,352.76 10,977.00   179.8692721 143.2916097 125.658741 101.8034982 103.4231575 100 Other Income 952.27 803.87 285.64 372 426.52 374.98   253.9522108 214.3767668 76.17472932 99.20529095 113.7447331 100 Total Revenue 20,937.70 16,532.99 14,250.59 11,743.86 12,094.40 11,731.74   178.4705423 140.9253018 121.4703872 100.1033095 103.0912721 100 Cost Of Materials Consumed 7,677.48 1,305.55 4,555.26 3,126.79 3,580.84 3,558.92   215.7249952 36.68388163 127.9955717 87.85783328 100.6159172 100 Other Expenses 7,215.57 10,795.47 5,519.48 4,639.42 5,140.64 5,294.71   136.2788519 203.8916201 104.2451806 87.62368477 97.09011447 100 Total Expenses 17,725.38 14,044.73 11,399.65 9,329.48 10,146.38 10,095.72   175.5732132 139.1156847 112.9156712 92.4102491 100.5017968 100

12. J.K. LAKSHMI CEMENT Owner name : Arun Kumar Shukla Business Startup : since 1938 Business type: building material company Headquarter: JK Lakshmi Cement Ltd, Nehru House 4, Bahadur Shah Zafar Marg , New Delhi  India Ab Soch Karo Buland

13. MISSION To foster inspire capital and deliver best-in-class customer experience to achieve a turnover of INR 30,000 crore by 2030. To develop innovative solutions with a compelling value proposition To embrace sustainability for our shared future. To be the most trusted brand providing innovative building solutions, delivering excellence and unparalleled stakeholder experience by empowering human capital and harnessing the power of technology. VISION

14. Horizontal analysis For profit and loss statement: P&L OF JK (H) Mar-23 Mar-22 ABSOLUTE CHANGE % change Profit/Loss Before Exceptional, ExtraOrdinary Items And Tax 481.46 581.69 -100.23 -17.23 Total Tax Expenses 150.69 132.08 18.61 14.09 Profit/Loss For The Period 330.77 426.22 -95.45 -22.39

15. Company should try to decrease their expenses and also increase their income so that growth can occur.

16. For balance sheet: BS OF JK (H) Mar-23 Mar-22 ABSOLUTE CHANGE % change Total Capital And Liabilities 5,211.17 4,839.00 372.17 7.691052 Total Assets 5,211.17 4,839.00 372.17 7.691052 By looking at data, it seems that total asset and liabilities are increasing at same rate. So, company should focus on increasing asset with decreasing liabilities.

17. Vertical analysis For profit and loss statement: P&L OF JK (V) Mar-23 Mar-22 ABSOLUTE CHANGE Total Revenue 6,133.28 5,108.03 101.0473318 Total Expenses 5,651.82 4,526.34 93.11515707 Profit/Loss Before Exceptional, Extraordinary Items And Tax 481.46 581.69 7.932174684 Total Tax Expenses 150.69 132.08 2.482655679 Profit/Loss For The Period 330.77 426.22 5.449519005

18. Company needs to focus more on increasing revenue as profit for the period is decreasing and also focus on expense.

19. For balance sheet: BS OF JK (V) Mar-23 Mar-22 MAR-23 % CHANGE MAR-22 % CHANGE Total Shareholders Funds 2,723.74 2,452.35 52.26734112 50.67886 Total Non-Current Liabilities 1,137.10 1,239.50 21.82043572 25.6148 Total Current Liabilities 1,350.33 1,147.15 25.91222317 23.70634 Total Capital And Liabilities 5,211.17 4,839.00 100 100 Total Non-Current Assets 3,327.85 3,305.44 63.85993932 68.30833 Total Current Assets 1,883.32 1,533.56 36.14006068 31.69167 Total Assets 5,211.17 4,839.00 100 100

20. Company should try to increase asset as increase in asset is somewhat same to increase in liability which can affect companies growth.

21. Trend analysis: TREND OF JK P&L 2023 2022 2021 2020 2019 2018 Change in % Revenue From Operations [Gross] 6,069.71 5,038.11 4,381.03 4,039.87 3,878.10 3509.74   172.939 143.5465 124.8249 115.1045 110.4954 100 Other Income 62.23 67.25 74.47 50.08 56.26 68.1   91.38032 98.75184 109.3539 73.53891 82.6138 100 Total Revenue 6,133.28 5,108.03 4,459.18 4,093.58 3,938.60 3480.25   176.231 146.7719 128.1282 117.6232 113.17 100 Total Expenses 5,651.82 4,526.34 3,931.67 3,723.89 3,834.17 3377.54   167.3354 134.0129 116.4063 110.2545 113.5196 100 Profit/Loss Before Exceptional, ExtraOrdinary Items And Tax 481.46 581.69 527.51 369.69 104.43 102.71   468.7567 566.3421 513.5917 359.9357 101.6746 100 Total Tax Expenses 150.69 132.08 132.77 104.23 24.87 18.75   803.68 704.4267 708.1067 555.8933 132.64 100 Profit/Loss For The Period 330.77 426.22 363.82 235.23 79.56 83.96   393.9614 507.6465 433.3254 280.1691 94.75941 100

22. QUALITATIVE ANALYSIS FOLLOWING ARE THE REASONS FOR FLUCTUATIONS IN FINANCIALS OF BOTH THE COMPANIES: INTERNAL FACTORS: Production and operational costs Debt levels of company Product mix and pricing EXTERNAL FACTORS: Economic growth of company Government policies Competition

23. QUALITATIVE ANALYSIS KEY EVENTS : Expansion in east India. Focus on sustainability . KEY EVENTS : Acquisition by Adani group. Covid-19 pandemic AMBUJA CEMENTS JK LAKSHMI CEMENTS

24. R atio analysis Liquidity ratio The indicators of liquidity ratio i.e. current ratio and quick ratio. Current ratio shows the gradually increase from the year 2022 to 2023 that is 1.2 to 1.67. Quick ratio shows increase from year 2022 to 2023 that is 0.98 to 1.39. Profitability ratio Net profit margin has been increased from year 2022 to 2023 is 7.22 to 7.69. Solvency ratio Debt equity ratio remains same in both years that is 2022 to 2023 and is 0.00. Interest coverage ratio shows increase 2022 to 2023 is 27.53 to 30.07. Ambuja cement

25. R atio analysis Liquidity ratio The indicators of liquidity ratio i.e. current ratio and quick ratio. Current ratio shows the gradually increase from the year 2022 to 2023 that is 1.14 to 1.17. Quick ratio shows decrease from year 2022 to 2023 that is 0.8 to 0.66. Profitability ratio Net profit margin has been detoriated from year 2022 to 2023 is gradually 8.81 to 5.72. Solvency ratio Debt equity ratio shows decrease 2022 to 2023 is 0.74 to 0.66 Interest coverage ratio shows decrease 2022 to 2023 is 7.17 to 6.72. JK Lakshmi cement

26. Thank You