Scribd Logo
Upload

Welcome to Scribd!

  • 26 views

    Dupont Analysis

    Uploaded by

    TECH BABA
    The document contains financial data from Colgate-Palmolive (India) Ltd and Hindustan Unilever Ltd over the past 5 years, including net profit, revenue, assets, equity, and ratios calculated from a DuPont analysis. Specifically, it shows the companies' net profit margins, asset turnover ratios, and financial leverage have remained relatively stable from 2015 to 2020, with Hindustan Unilever generally performing better on ratios like return on equity. The data suggests both companies have maintained consistent and profitable operations over the period examined.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Dupont Analysis

    Uploaded by

    TECH BABA
    26 views5 pages
    The document contains financial data from Colgate-Palmolive (India) Ltd and Hindustan Unilever Ltd over the past 5 years, including net profit, revenue, assets, equity, and ratios calculated from a DuPont analysis. Specifically, it shows the companies' net profit margins, asset turnover ratios, and financial leverage have remained relatively stable from 2015 to 2020, with Hindustan Unilever generally performing better on ratios like return on equity. The data suggests both companies have maintained consistent and profitable operations over the period examined.

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains financial data from Colgate-Palmolive (India) Ltd and Hindustan Unilever Ltd over the past 5 years, including net profit, revenue, assets, equity, and ratios calculated from a DuPont analysis. Specifically, it shows the companies' net profit margins, asset turnover ratios, and financial leverage have remained relatively stable from 2015 to 2020, with Hindustan Unilever generally performing better on ratios like return on equity. The data suggests both companies have maintained consistent and profitable operations over the period examined.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    26 views5 pages

    Dupont Analysis

    Uploaded by

    TECH BABA
    The document contains financial data from Colgate-Palmolive (India) Ltd and Hindustan Unilever Ltd over the past 5 years, including net profit, revenue, assets, equity, and ratios calculated from a DuPont analysis. Specifically, it shows the companies' net profit margins, asset turnover ratios, and financial leverage have remained relatively stable from 2015 to 2020, with Hindustan Unilever generally performing better on ratios like return on equity. The data suggests both companies have maintained consistent and profitable operations over the period examined.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 5

    Company : Colgate-Palmolive (India) Ltd

    Industry : Personal Care - Multinational


    Year Mar 20 Mar 19 Mar 18 Mar 17 Mar 16 Mar 15

    5 factor dupont analysis


    Reported Net Profit/NI 816.47 775.57 673.37 577.43 581.17
    Net profit before interest
    and tax/EBIT 1052.98 1145.05 983.03 851.43 835.28
    Profit Before Tax/EBT 1,043.36 1,142.55 983.03 851.43 835.28
    Net Sales/Revenue 4,525.08 4,462.43 4,187.97 3,981.82 3,868.19
    Average Total assets 2,615.23 2,595.18 2,437.26 2,156.77 1,852.39
    Average shareholders
    equity 1,520.46 1,485.68 1,399.21 1,152.42 900.68

    Dupont analysis colgate

    Operating
    Tax Interest profit Asset Financial
    5 factor anlaysis burden burden margin Turnover leverage

    Mar 20 0.78 0.99 0.23 1.73 1.72 0.54

    Net profit Asset Financial


    margin Turnover leverage
    3 factor anlaysis 0.18 1.73 1.72 0.54

    ROE 0.54
    Company : Hindustan Unilever Ltd
    Industry : Personal Care - Multinational
    Year Mar 20 Mar 19 Mar 18 Mar 17 Mar 16

    5 factor dupont analysis


    Reported Net Profit/NI 6,738.00 6,036.00 5,237.00 4,490.00 4,137.00
    Net profit before interest and
    tax/EBIT 9,198.00 8,550.00 7,305.00 6,418.00 5,961.00
    Profit Before Tax/EBT 9,092.00 8,522.00 7,285.00 6,396.00 5,946.00
    Net Sales 38,785.00 38,224.00 34,525.00 31,890.00 31,061.00
    Average Total assets 18,433.50 17,210.00 15,742.50 14,171.50 13,595.05

    Average shareholders equity 7,845.00 7,367.00 6,782.50 6,384.50 5,001.89

    Dupont analysis Hindustan

    Operating
    Interest profit Asset Financial
    5 factor anlaysis Tax burden burden margin Turnover leverage

    Mar 20 0.74 0.99 0.24 2.10 2.35

    Net profit Asset Financial


    margin Turnover leverage
    3 factor anlaysis 0.17 2.10 2.35

    ROE 0.86
    Mar 15

    0.86

    0.86
    Company : Colgate-Palmolive (India) Ltd
    Industry : Personal Care - Multinational
    Year Mar 20 Mar 19 Mar 18 Mar 17 Mar 16 Mar 15
    Net Block + 1,122.86 1,190.85 1,145.92 1,108.11 1,008.14 781.58

    Capital Work in Progress+ 190.03 198.70 158.58 166.59 78.37 141.18


    Investments + 18.62 31.15 31.16 31.16 31.16 37.13
    Other Assets+ 260.43 195.62 167.49 149.17 110.16 59.28
    Total Current Assets 1,012.04 1,010.16 1,060.72 855.62 775.06 682.71

    Total assets 2,603.98 2,626.48 2,563.87 2,310.65 2,002.89 1,701.88


    Average Total assets 2,615.23 2,595.18 2,437.26 2,156.77 1,852.39

    Total shareholders equity 1,594.16 1,446.75 1,524.61 1,273.80 1,031.04 770.32


    Average shareholders
    equity 1,520.46 1,485.68 1,399.21 1,152.42 900.68
    Company : Hindustan Unilever Ltd
    Industry : Personal Care - Multinational
    Year Mar 20 Mar 19 Mar 18 Mar 17 Mar 16 Mar 15
    Net Block + 5,056.00 4,343.00 4,142.00 4,024.00 2,914.00 2,457.53

    Capital Work in Progress+ 513.00 373.00 430.00 203.00 386.00 479.01


    Investments + 1,500.00 2,949.00 3,111.00 3,779.00 2,780.00 3,277.93
    Other Assets+ 1,612.00 1,180.00 927.00 739.00 581.00 583.90
    Total Current Assets 10,660.00 8,681.00 8,284.00 5,846.00 7,091.00 6,639.73

    Total assets 19,341.00 17,526.00 16,894.00 14,591.00 13,752.00 13,438.10


    Average Total assets 18,433.50 17,210.00 15,742.50 14,171.50 13,595.05

    Total shareholders equity 8,031.00 7,659.00 7,075.00 6,490.00 6,279.00 3,724.78


    Average shareholders
    equity 7,845.00 7,367.00 6,782.50 6,384.50 5,001.89

    You might also like