fmcg industry capital structure analysis_final excel file
TRANSCRIPT
PROWESS DATA
FMCG INDUSTRY
Annual Annual Annual Annual AnnualRs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. CroreL - 5 L - 4 L - 3 L - 2 L - 1
Company Name Sales Sales Sales Sales SalesDabur India Ltd. 1372.52 1641.57 2128.17 2435.93 2891.51Godrej Consumer Products Ltd. 692.26 799.42 923.28 1135.37 1301.58Hindustan Unilever Ltd. 12108.87 13189.7 14895.56 21949.17 18462.34I T C Ltd. 16236.65 19505.06 21467.38 23247.84 26399.63Nestle India Ltd. 2643.96 2944.2 3647.49 4472.04 5232.59
Annual Annual Annual Annual Annual Annual Annual Annual Annual AnnualRs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. CroreL L - 5 L - 4 L - 3 L - 2 L - 1 L L - 5 L - 4 L - 3 Sales Gross fi Gross fi Gross fi Gross fi Gross fi Gross fi Assets Assets Assets
3311.37 341.29 408.01 484.19 570.48 710.54 778.8 792.46 801.99 1155.572514.37 166.28 283.46 337.13 269.06 274.64 1472.94 252.22 455.41 569.33
20598.89 2476.34 2576.26 2854.72 3353.8 3859.44 4062.28 6609.42 7480.02 6830.0730633.57 6627.14 8264.51 10086.52 11772.71 13241.54 14438.41 13318.26 15235.23 17549.22
6382.78 972.27 1096.51 1253.49 1514.02 1720.42 2203.61 1115.61 1241.27 1448.63
Annual Annual Annual Annual Annual Annual Annual Annual Annual AnnualRs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. CroreL - 2 L - 1 L L - 5 L - 4 L - 3 L - 2 L - 1 L L - 5Assets Assets Assets PBIT PBIT PBIT PBIT PBIT PBIT PBT
1574.16 1767.28 2428.92 218.19 288.46 371.26 435.26 537.12 607.33 215.07877.38 1189.69 2361.94 134.26 156.72 180.18 194.07 300.53 543.12 131.77
8451.52 9519.04 10223.11 1721.29 2187.9 2355.85 3094.71 2857.37 2880.08 1702.119785.21 23357.69 25844.21 3278.7 3971.67 4618.34 4861.07 6100.03 7334.22 3262.92
1733.94 2082.46 2607.06 469.27 480.97 629.46 774.46 918.38 1146.19 469.06
Annual Annual Annual Annual Annual Annual Annual Annual Annual AnnualRs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore (%) (%) (%) (%) (%)L - 4 L - 3 L - 2 L - 1 L L - 5 L - 4 L - 3 L - 2 L - 1 PBT PBT PBT PBT PBT RONW RONW RONW RONW RONW
284.09 364.32 424.28 526.84 596.66 47.94 57.18 68.26 58.89 57.9149.34 169.24 186.57 299.15 536.91 189.24 123.8 113.39 46.83 36.43
2177.17 2330.35 3069.39 2850.39 2879.84 58.17 61.12 82.95 134.34 86.313963.04 4601.07 4832.69 6027.03 7275.9 26.35 27.06 26.7 24.87 29.09
480.53 628.61 772.82 916.98 1145.11 88.34 76.11 88.32 120.39 125.43
Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual(%) (%) (%) (%) (%) (%) (%) Times Times TimesL L - 5 L - 4 L - 3 L - 2 L - 1 L L - 5 L - 4 L - 3 RONW ROCE ROCE ROCE ROCE ROCE ROCE Quick ra Quick ra Quick ra
50.73 48.74 60.09 70.11 59.48 57.57 52.41 0.25 0.32 0.3234.11 187.59 80.86 61.51 37.25 35 30.69 0.15 0.23 0.1884.38 44.68 61.08 82.93 134.33 86.33 84.4 0.29 0.29 0.2133.14 26.27 26.96 26.57 24.75 28.97 33.03 0.36 0.39 0.41
115.07 88.34 76.11 88.32 120.39 125.43 115.07 0.24 0.3 0.22
Annual Annual Annual Annual Annual Annual Annual Annual Annual AnnualTimes Times Times Times Times Times Times Times Times TimesL - 2 L - 1 L L - 5 L - 4 L - 3 L - 2 L - 1 L L - 5 Quick ra Quick ra Quick ra Current Current Current Current Current Current Debt equ
0.35 0.33 0.49 0.78 1.03 0.92 0.93 0.95 1.15 0.051.5 0.68 0.48 0.72 0.77 0.84 2.03 1.22 1.19 0.06
0.46 0.44 0.41 0.65 0.66 0.62 0.9 0.79 0.82 0.020.46 0.28 0.41 1.32 1.45 1.48 1.62 0.96 1.13 0.01
0.3 0.25 0.28 0.64 0.68 0.66 0.67 0.6 0.63 0.04
Annual Annual Annual Annual Annual Annual Annual Annual Annual AnnualTimes Times Times Times Times Times Times Times Times TimesL - 4 L - 3 L - 2 L - 1 L L - 5 L - 4 L - 3 L - 2 L - 1 Debt equ Debt equ Debt equ Debt equ Debt equ Interest Interest Interest Interest Interest
0.05 0.03 0.19 0.14 0.25 69.64 64.03 53.79 39.65 52.011.02 0.91 0.12 0.01 0.18 53.13 19.02 16.48 25.8 218.070.03 0.06 0.2 0 0 82.98 174.23 84.58 116.5 381.080.02 0.02 0.01 0.01 0.01 207.69 453 260.62 169.15 83.320.04 0.01 0 0 0.01 2177.19 1019.61 673.14 473.9 660.58
BSE BSE BSEAnnual Annual Annual Annual Annual Annual AnnualTimes Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Rs. Rs.L L - 5 L - 4 L - 3 L - 2 L - 1 L L - 5 L - 4 L - 3 Interest Intan Intan Intan Intan Intan Intan 365 days 365 days 365 days
56.69 10.96 16.82 19.59 21.07 21.74 21.7 102.29 102.28 102.2782.26 36.89 71.33 71.61 4.35 4.35 1080.63 397.78 397.74 397.81
11563.54 185.08 174.99 209.26 257.88 263.65 263.65 326.35 326.72 327.11125.51 103.86 139.89 177.83 202.71 254.19 313.26 191.71 191.83 191.97
1068.63 52.83 53.63 53.63 53.63 53.63 58.88 4037.94 4039.73 4041.68
BSE BSE BSE BSE BSE BSE BSE BSE BSE BSE
Rs. Rs. Rs. Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs.L - 2 L - 1 L L - 5 L - 4 L - 3 L - 2 L - 1 L L - 5 365 days 365 days 365 days 365 day 365 day 365 day 365 day 365 day 365 day EPS
102.25 102.24 102.23 17813.02 17810.48 17808.54 17806.36 17803.61 17802.69 2.79397.85 397.99 398.16 12871.68 12870.5 12872.77 12874.18 12878.46 12884.17 12.37327.49 327.93 328.41 70562.52 70639.09 70721.19 70801.25 70894.63 70995.74 10.58192.12 192.27 192.41 148703.9 148802.8 148919 149038.8 149163.9 149276.7 7.48
4043.53 4045.6 4048.52 38932.11 38949.39 38968.1 38985.95 39005.97 39034.13 96.88
BSE BSE BSE BSE BSE BSE BSE BSE BSE BSE
Rs. Rs. Rs. Rs. Rs. Rs. Rs. Rs. Rs. Rs.L - 4 L - 3 L - 2 L - 1 L L - 5 L - 4 L - 3 L - 2 L - 1EPS EPS EPS EPS EPS BV per ShaBV per ShaBV per ShaBV per ShaBV per Sha
2.79 2.79 2.79 2.79 2.79 7.09 7.09 7.09 7.09 7.0912.37 12.37 12.37 12.37 12.37 59.18 59.18 59.18 59.18 59.1810.58 10.58 10.58 10.58 10.58 14.78 14.78 14.78 14.78 14.78
7.47 7.47 7.47 7.47 7.47 26.23 26.22 26.22 26.22 26.2296.88 96.88 96.88 96.88 96.88 128.51 128.51 128.51 128.51 128.51
BSE
Rs.LBV per Share
7.0959.1814.7826.22
128.51
PROCESSED DATA
FMCG INDUSTRY
Annual Annual Annual Annual AnnualTimes Times Times Times TimesL - 5 L - 4 L - 3 L - 2 L - 1
Company Name Debt equ Debt equ Debt equ Debt equ Debt equDabur India Ltd. 0.05 0.05 0.03 0.19 0.14Godrej Consumer Products Ltd. 0.06 1.02 0.91 0.12 0.01Hindustan Unilever Ltd. 0.02 0.03 0.06 0.2 0I T C Ltd. 0.01 0.02 0.02 0.01 0.01Nestle India Ltd. 0.04 0.04 0.01 0 0
Annual Annual Annual Annual Annual Annual Annual Annual Annual AnnualTimes (%) (%) (%) (%) (%) (%) (%) (%) (%)L L - 5 L - 4 L - 3 L - 2 L - 1 L L - 5 L - 4 L - 3 Debt equ RONW RONW RONW RONW RONW RONW ROCE ROCE ROCE
0.25 47.94 57.18 68.26 58.89 57.9 50.73 48.74 60.09 70.110.18 189.24 123.8 113.39 46.83 36.43 34.11 187.59 80.86 61.51
0 58.17 61.12 82.95 134.34 86.31 84.38 44.68 61.08 82.930.01 26.35 27.06 26.7 24.87 29.09 33.14 26.27 26.96 26.570.01 88.34 76.11 88.32 120.39 125.43 115.07 88.34 76.11 88.32
Annual Annual Annual Annual Annual Annual Annual Annual Annual Annual(%) (%) (%) Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. CroreL - 2 L - 1 L L - 5 L - 4 L - 3 L - 2 L - 1 L L - 5 ROCE ROCE ROCE Sales Sales Sales Sales Sales Sales PBIT
59.48 57.57 52.41 1372.52 1641.57 2128.17 2435.93 2891.51 3311.37 218.1937.25 35 30.69 692.26 799.42 923.28 1135.37 1301.58 2514.37 134.26
134.33 86.33 84.4 12108.87 13189.7 14895.56 21949.17 18462.34 20598.89 1721.2924.75 28.97 33.03 16236.65 19505.06 21467.38 23247.84 26399.63 30633.57 3278.7
120.39 125.43 115.07 2643.96 2944.2 3647.49 4472.04 5232.59 6382.78 469.27
Annual Annual Annual Annual Annual Annual Annual Annual Annual AnnualRs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. CroreL - 4 L - 3 L - 2 L - 1 L L - 5 L - 4 L - 3 L - 2 L - 1 PBIT PBIT PBIT PBIT PBIT PBT PBT PBT PBT PBT
288.46 371.26 435.26 537.12 607.33 215.07 284.09 364.32 424.28 526.84156.72 180.18 194.07 300.53 543.12 131.77 149.34 169.24 186.57 299.152187.9 2355.85 3094.71 2857.37 2880.08 1702.1 2177.17 2330.35 3069.39 2850.39
3971.67 4618.34 4861.07 6100.03 7334.22 3262.92 3963.04 4601.07 4832.69 6027.03480.97 629.46 774.46 918.38 1146.19 469.06 480.53 628.61 772.82 916.98
Annual Annual Annual Annual Annual Annual Annual Annual Annual AnnualRs. Crore Times Times Times Times Times Times Times Times TimesL L - 4 L - 3 L - 2 L - 1 L L - 4 L - 3 L - 2 L - 1 PBT DOL DOL DOL DOL DOL DFL DFL DFL DFL
596.66 1.642937 0.968349 1.192054 1.251282 0.900218 1.015382 1.019049 1.025879 1.019513536.91 1.080686 0.966157 0.33559 3.747212 0.866304 1.049417 1.064642 1.040199 1.004613
2879.84 3.03701 0.593532 0.662308 0.482768 0.068679 1.004928 1.010943 1.008249 1.0024497275.9 1.04996 1.618404 0.633701 1.879969 1.261546 1.002178 1.003753 1.005873 1.012112
1145.11 0.219558 1.292445 1.019007 1.092698 1.128489 1.000916 1.001352 1.002122 1.001527
Annual Annual Annual Annual Annual Annual Annual Annual Annual AnnualTimes Times Times Times Times Times Times Rs. Crore Rs. Crore Rs. CroreL L - 5 L - 4 L - 3 L - 2 L - 1 L L - 5 L - 4 L - 3DFL Interest Interest Interest Interest Interest Interest Gross fi Gross fi Gross fi1.017883 69.64 64.03 53.79 39.65 52.01 56.69 341.29 408.01 484.191.011566 53.13 19.02 16.48 25.8 218.07 82.26 166.28 283.46 337.131.000083 82.98 174.23 84.58 116.5 381.08 11563.54 2476.34 2576.26 2854.721.008016 207.69 453 260.62 169.15 83.32 125.51 6627.14 8264.51 10086.521.000943 2177.19 1019.61 673.14 473.9 660.58 1068.63 972.27 1096.51 1253.49
Annual Annual Annual Annual Annual Annual Annual Annual Annual AnnualRs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. CroreL - 2 L - 1 L L - 5 L - 4 L - 3 L - 2 L - 1 L L - 5 Gross fi Gross fi Gross fi Intan Intan Intan Intan Intan Intan Assets
570.48 710.54 778.8 10.96 16.82 19.59 21.07 21.74 21.7 792.46269.06 274.64 1472.94 36.89 71.33 71.61 4.35 4.35 1080.63 252.223353.8 3859.44 4062.28 185.08 174.99 209.26 257.88 263.65 263.65 6609.42
11772.71 13241.54 14438.41 103.86 139.89 177.83 202.71 254.19 313.26 13318.261514.02 1720.42 2203.61 52.83 53.63 53.63 53.63 53.63 58.88 1115.61
Annual Annual Annual Annual Annual Annual Annual Annual Annual AnnualRs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. Crore Rs. CroreL - 4 L - 3 L - 2 L - 1 L L - 5 L - 4 L - 3 L - 2 L - 1Assets Assets Assets Assets Assets Tangible AsTangible AsTangible AsTangible AsTangible As
801.99 1155.57 1574.16 1767.28 2428.92 781.5 785.17 1135.98 1553.09 1745.54455.41 569.33 877.38 1189.69 2361.94 215.33 384.08 497.72 873.03 1185.34
7480.02 6830.07 8451.52 9519.04 10223.11 6424.34 7305.03 6620.81 8193.64 9255.3915235.23 17549.22 19785.21 23357.69 25844.21 13214.4 15095.34 17371.39 19582.5 23103.5
1241.27 1448.63 1733.94 2082.46 2607.06 1062.78 1187.64 1395 1680.31 2028.83
BSE BSE BSEAnnual Annual Annual Annual Annual Annual AnnualRs. Crore Times Times Times Times Times Times Rs. Rs. Rs.L L - 5 L - 4 L - 3 L - 2 L - 1 L L - 5 L - 4 L - 3Tangible AsTangibilityTangibilityTangibilityTangibilityTangibilityTangibility 365 days 365 days 365 days
2407.22 0.98617 0.979027 0.983047 0.986615 0.987699 0.991066 102.29 102.28 102.271281.31 0.853739 0.843372 0.874221 0.995042 0.996344 0.542482 397.78 397.74 397.819959.46 0.971998 0.976606 0.969362 0.969487 0.972303 0.97421 326.35 326.72 327.11
25530.95 0.992202 0.990818 0.989867 0.989754 0.989118 0.987879 191.71 191.83 191.972548.18 0.952645 0.956794 0.962979 0.96907 0.974247 0.977415 4037.94 4039.73 4041.68
BSE BSE BSE BSE BSE BSE BSE BSE BSE
Rs. Rs. Rs. Rs. Rs. Rs. Rs. Rs. Rs. TimesL - 2 L - 1 L L - 5 L - 4 L - 3 L - 2 L - 1 L L - 5 365 days 365 days 365 daysBV per ShaBV per ShaBV per ShaBV per ShaBV per ShaBV per ShaM/B Ratio
102.25 102.24 102.23 7.09 7.09 7.09 7.09 7.09 7.09 14.42736397.85 397.99 398.16 59.18 59.18 59.18 59.18 59.18 59.18 6.721528327.49 327.93 328.41 14.78 14.78 14.78 14.78 14.78 14.78 22.08051192.12 192.27 192.41 26.23 26.22 26.22 26.22 26.22 26.22 7.308807
4043.53 4045.6 4048.52 128.51 128.51 128.51 128.51 128.51 128.51 31.42121
Annual Annual Annual Annual AnnualTimes Times Times Times Times Times Times Times Times TimesL - 4 L - 3 L - 2 L - 1 L L - 5 L - 4 L - 3 L - 2 L - 1M/B Ratio M/B Ratio M/B Ratio M/B Ratio M/B Ratio Quick ra Quick ra Quick ra Quick ra Quick ra14.42595 14.42454 14.42172 14.42031 14.4189 0.25 0.32 0.32 0.35 0.336.720852 6.722034 6.72271 6.725076 6.727949 0.15 0.23 0.18 1.5 0.6822.10555 22.13194 22.15765 22.18742 22.21989 0.29 0.29 0.21 0.46 0.447.316171 7.32151 7.327231 7.332952 7.338291 0.36 0.39 0.41 0.46 0.2831.43514 31.45032 31.46471 31.48082 31.50354 0.24 0.3 0.22 0.3 0.25
Annual Annual Annual Annual Annual Annual AnnualTimes Times Times Times Times Times TimesL L - 5 L - 4 L - 3 L - 2 L - 1 L Quick ra Current Current Current Current Current Current ratio
0.49 0.78 1.03 0.92 0.93 0.95 1.150.48 0.72 0.77 0.84 2.03 1.22 1.190.41 0.65 0.66 0.62 0.9 0.79 0.820.41 1.32 1.45 1.48 1.62 0.96 1.130.28 0.64 0.68 0.66 0.67 0.6 0.63
ARRANGED DATA FOR ANALYSIS
FMCG INDUSTRY
Annual Annual Annual AnnualTimes (%) (%) Times
Company Name Debt equity ratio RONW ROCE DOLL - 4 Dabur India Ltd. 0.05 57.18 60.09 1.6429365693L - 3 0.03 68.26 70.11 0.9683492928L - 2 0.19 58.89 59.48 1.1920540763L - 1 0.14 57.9 57.57 1.2512816276L 0.25 50.73 52.41 0.9002183189L - 4 Godrej Consumer Products Ltd. 1.02 123.8 80.86 1.0806862907L - 3 0.91 113.39 61.51 0.9661565854L - 2 0.12 46.83 37.25 0.3355899134L - 1 0.01 36.43 35 3.7472124913L 0.18 34.11 30.69 0.8663040055L - 4 Hindustan Unilever Ltd. 0.03 61.12 61.08 3.0370100028L - 3 0.06 82.95 82.93 0.5935319085L - 2 0.2 134.34 134.33 0.662307865L - 1 0 86.31 86.33 0.4827678139L 0 84.38 84.4 0.0686790592L - 4 I T C Ltd. 0.02 27.06 26.96 1.0499597514L - 3 0.02 26.7 26.57 1.618404278L - 2 0.01 24.87 24.75 0.6337009764L - 1 0.01 29.09 28.97 1.8799692472L 0.01 33.14 33.03 1.2615462972L - 4 Nestle India Ltd. 0.04 76.11 76.11 0.2195580676L - 3 0.01 88.32 88.32 1.2924450417L - 2 0 120.39 120.39 1.0190065573L - 1 0 125.43 125.43 1.0926977964L 0.01 115.07 115.07 1.1284894055
Annual Annual Annual Annual Annual AnnualTimes Times Times Times Times TimesDFL Interest cover Tangibility Ratio M/B Ratio Quick ratio Current ratio1.0153824492 64.03 0.9790271699148 14.425952045 0.32 1.031.0190491875 53.79 0.983047327293 14.424541608 0.32 0.921.0258791364 39.65 0.9866150836001 14.421720733 0.35 0.931.0195125655 52.01 0.9876986102938 14.420310296 0.33 0.951.0178828814 56.69 0.9910659881758 14.418899859 0.49 1.151.0494174367 19.02 0.8433719066336 6.7208516391 0.23 0.771.0646419286 16.48 0.8742205750619 6.7220344711 0.18 0.84
1.040199389 25.8 0.9950420570334 6.7227103751 1.5 2.031.0046130704 218.07 0.9963435853037 6.7250760392 0.68 1.221.0115661843 82.26 0.5424820274859 6.7279486313 0.48 1.191.0049284162 174.23 0.9766056775249 22.105548038 0.29 0.661.0109425623 84.58 0.9693619538306 22.131935047 0.21 0.621.0082491961 116.5 0.9694871455076 22.157645467 0.46 0.91.0024487877 381.08 0.9723028792819 22.187415426 0.44 0.79
1.000083338 11563.54 0.9742103919453 22.219891746 0.41 0.821.0021776212 453 0.9908179922456 7.3161708619 0.39 1.451.0037534747 260.62 0.9898667861022 7.3215102975 0.41 1.481.0058725058 169.15 0.9897544681103 7.3272311213 0.46 1.621.0121121016 83.32 0.9891175026298 7.3329519451 0.28 0.961.0080155032 125.51 0.9878789098216 7.3382913806 0.41 1.131.0009156556 1019.61 0.9567942510493 31.435141234 0.3 0.681.0013521898 673.14 0.9629788144661 31.450315151 0.22 0.661.0021220983 473.9 0.9690704407304 31.464710917 0.3 0.671.0015267509 660.58 0.9742468042603 31.480818613 0.25 0.61.0009431408 1068.63 0.9774151726466 31.50354058 0.28 0.63