Based on your analysis, recommend whether Gupta should include Bajaj Consumer Care Ltd. In his companys portfolio
Vid WESPN Personal GATAE17-BOCSA SOFSIDA- B2000 MyCat istian Matthew and lacobed - Saved e Search 10ption Draw Page Layout Formulas Data Review View Automate Ara Help 10 B TABLES Accounting . - N o R B. 28.1 406.72 9.30% S 10.00 10.50 $ 11.20% 12.00 5 12.30 1 13.009 $ WACC 5.00 0.00 28205 530915 3400 3300 305 1040 52.01 20.34 14 5310 38 53454 SATA3 31.0459 30440 324 23 511 3.1 3.1 21 225 20 123932 56.05 2 31 2000 1999 199 247. : 100 19023 208.80.21.35 522273 E 316.50 320 924 34s D E H Valuation of BaCorp Using Discord Cash Flow Mo 2 5 Termine Autons FY1BE FYNDE FY20E FY21 FY22E Tamil Year Revenue growth 7078 9,5355 10.573 11.789513,1967 143184 EBITDA margin() 6.0565 6,680.0 7,4527 8.356. 9.400.0 10.2002 Working caso 2.6513 2.8546 3,1205 3.4134 3.793, 4. 1162 Perpety CAPEX 61.0 06.7 74.0 825 924 924 2.500.4 2.7873 2.0485 3,3508 3,7014 4.0230 COC Enter you WACC) 5058 6891 751 1.159.4 1.2007 1323 2.11 2.254 2.1914 2.4207 2.6310 01.0 58.7 740 125 324 92.4 Terminaluoferty 200.0 2000 2000 2000 Terminal valuesta perpetually -55.1 672 -1091 310 1.855.5 2.040.6 2.2260 2.183.1 2.3400 2.445. 0.90 0.81 372 0.65 0:50 1.6053 1.3437 1.5093 1.416.5 1.366 89175.15 7.700.4 4322 55.462.0 -100.0 3,5111 59,8444 147.5 405.72 25 Balance sheet PAL Cash Flow Hi evene en Taw Capes WWE WACC DCT 83,77115 2256 " 77.15 DO F41Chat Chris Copy of Bal Hanchi Vid WESPN Personal GATAE17-BOCSA SOFSIDA- B2000 MyCat istian Matthew and lacobed - Saved e Search 10ption Draw Page Layout Formulas Data Review View Automate Ara Help 10 B TABLES Accounting . - N o R B. 28.1 406.72 9.30% S 10.00 10.50 $ 11.20% 12.00 5 12.30 1 13.009 $ WACC 5.00 0.00 28205 530915 3400 3300 305 1040 52.01 20.34 14 5310 38 53454 SATA3 31.0459 30440 324 23 511 3.1 3.1 21 225 20 123932 56.05 2 31 2000 1999 199 247. : 100 19023 208.80.21.35 522273 E 316.50 320 924 34s D E H Valuation of BaCorp Using Discord Cash Flow Mo 2 5 Termine Autons FY1BE FYNDE FY20E FY21 FY22E Tamil Year Revenue growth 7078 9,5355 10.573 11.789513,1967 143184 EBITDA margin() 6.0565 6,680.0 7,4527 8.356. 9.400.0 10.2002 Working caso 2.6513 2.8546 3,1205 3.4134 3.793, 4. 1162 Perpety CAPEX 61.0 06.7 74.0 825 924 924 2.500.4 2.7873 2.0485 3,3508 3,7014 4.0230 COC Enter you WACC) 5058 6891 751 1.159.4 1.2007 1323 2.11 2.254 2.1914 2.4207 2.6310 01.0 58.7 740 125 324 92.4 Terminaluoferty 200.0 2000 2000 2000 Terminal valuesta perpetually -55.1 672 -1091 310 1.855.5 2.040.6 2.2260 2.183.1 2.3400 2.445. 0.90 0.81 372 0.65 0:50 1.6053 1.3437 1.5093 1.416.5 1.366 89175.15 7.700.4 4322 55.462.0 -100.0 3,5111 59,8444 147.5 405.72 25 Balance sheet PAL Cash Flow Hi evene en Taw Capes WWE WACC DCT 83,77115 2256 " 77.15 DO F41Chat Chris Copy of Bal Hanchi
