1. The dataset under Q9 show Maruti Suzukis 2021 September Sales data which has been downloaded from a trustable website on internet. Use appropriate lookup functions to check:

1. If net sales of Sharda motor is better than net Tata motors. Give suitable reasons to substantiate your answers.
2. Bajaj performed better in Jun21 than Jun20. If you are working for Bajaj, which lookup function would you use to check which companies performed better in 2021 than Bajaj in 2020. (5 marks)

D E F G H K Jun-21 YOY %-Change P/E* Net Sales (Rs m) -3,859 PAT (Rs m) Net Sales (%) PAT (%) 175.10% 40,879 -2,508 N.A. ### J11 % fx B Click on title Jun-20 to sort Net Sales PAT Name (Rs m) (Rs m) ASHOK LEYLAND 14,860 5 ATUL AUTO 266 BAJAJ AUTO 30,792 7 EICHER MOTOR 8,182 8 ESCORTS LIMITED 10,893 1,854 FORCE MOTORS 10 HERO MOTOCORP 29,691 11 HINDUSTAN MOTORS 0 -68 322 -64 21.20% N.A. N.A. NM no 009 5,279 102 940 73,860 19,743 17,018 10,592 2.765 1,888 139.90% 141.30% 56.20% 100.60% 2605.80% 100.80% ### ### ### -632 6,433 16 247.00% N.A. N.A. 564 -2 55,028 0 3,920 1 85.30% -100.00% 595.30% N.A. 17 ### 49 -51 275 2 460.50% N.A. N.A. 12 KINETIC ENGG. 13 M&M 14 MARUTI SUZUKI ###### 41,106 -1,286 -2,470 -207 1,91,719 1,77,764 -7,487 4,391 60.20% 332.50% NA NA ### ### 0 0 -53 N.A. N.A. N.A. 15 PREMIER LIMITED 4 -57 0 -35 -100.00% N.A. N.A. 16 SCOOTERS IND 17 SHARDA MOTOR -95 355.10% N.A. ### 1,036 287 4,717 1,000 269 -334 -523 247.80% N.A. N.A. 18 SML ISUZU -43,206 107.60% N.A. N.A. ###### ## 19,397 1,462 #### ### -83,842 -1,800 171 6,64,065 46,893 1,936 -152 240 141.80% 32.40% N.A. 40.70% 19 TATA MOTORS 20 TVS MOTORS 21 VST TILLERS Sector Aggregate 23 24 25 26 ### ### -87,834 13,01,653 -29,755 117.20% N.A. 22 D E F G H K Jun-21 YOY %-Change P/E* Net Sales (Rs m) -3,859 PAT (Rs m) Net Sales (%) PAT (%) 175.10% 40,879 -2,508 N.A. ### J11 % fx B Click on title Jun-20 to sort Net Sales PAT Name (Rs m) (Rs m) ASHOK LEYLAND 14,860 5 ATUL AUTO 266 BAJAJ AUTO 30,792 7 EICHER MOTOR 8,182 8 ESCORTS LIMITED 10,893 1,854 FORCE MOTORS 10 HERO MOTOCORP 29,691 11 HINDUSTAN MOTORS 0 -68 322 -64 21.20% N.A. N.A. NM no 009 5,279 102 940 73,860 19,743 17,018 10,592 2.765 1,888 139.90% 141.30% 56.20% 100.60% 2605.80% 100.80% ### ### ### -632 6,433 16 247.00% N.A. N.A. 564 -2 55,028 0 3,920 1 85.30% -100.00% 595.30% N.A. 17 ### 49 -51 275 2 460.50% N.A. N.A. 12 KINETIC ENGG. 13 M&M 14 MARUTI SUZUKI ###### 41,106 -1,286 -2,470 -207 1,91,719 1,77,764 -7,487 4,391 60.20% 332.50% NA NA ### ### 0 0 -53 N.A. N.A. N.A. 15 PREMIER LIMITED 4 -57 0 -35 -100.00% N.A. N.A. 16 SCOOTERS IND 17 SHARDA MOTOR -95 355.10% N.A. ### 1,036 287 4,717 1,000 269 -334 -523 247.80% N.A. N.A. 18 SML ISUZU -43,206 107.60% N.A. N.A. ###### ## 19,397 1,462 #### ### -83,842 -1,800 171 6,64,065 46,893 1,936 -152 240 141.80% 32.40% N.A. 40.70% 19 TATA MOTORS 20 TVS MOTORS 21 VST TILLERS Sector Aggregate 23 24 25 26 ### ### -87,834 13,01,653 -29,755 117.20% N.A. 22