See attached doc

1 answer below »
Answered 6 days AfterMar 18, 2021

Answer To: See attached doc

Khushboo answered on Mar 25 2021
147 Votes
a. Financial data analysis section:
Table 1:
    
    Caterpiller Inc.
    Industrial
     
    2017
    2018
    2019
    2020
    2017
    2018
    2019
    2020
    TEV/Total reven
ue (Avg)
    2.41
    2.36
    1.92
    2.18
    1.4
    1.3
    1.3
    1.8
    P/E
    94.25
    57.6
    13.15
    17.13
    17.5
    16.5
    16.2
    25.3
    P/BV
    4.7
    5.81
    5.08
    5.28
    2.2
    2
    1.9
    2.6
    ROE
    5.60%
    44.20%
    42.50%
    20.00%
    11.50%
    10.00%
    9.20%
    2.30%
    Net income margin
    1.70%
    11.20%
    11.30%
    7.20%
    5.00%
    4.30%
    3.60%
    1.60%
    Current ratio
    1.3
    1.4
    1.5
    1.5
    1.2
    1.2
    1.2
    1.3
    Total debt to equity
    253.40%
    259.90%
    261.90%
    245.70%
    84.50%
    79.10%
    82.70%
    73.90%
    Total debt to capital
    71.70%
    72.20%
    72.40%
    71.10%
    45.80%
    44.20%
    45.30%
    42.50%
    The interest coverage ratio
    15.9
    27.5
    26.1
    14.7
     5.90
     5.50
     4.90
     4.00
    Altman Z Score
    2.08
    2.55
    2.54
    2.3
     
     
     
     
Table 2:
     
    Duke Energy corporation
    Utilities
     
    2017
    2018
    2019
    2020
    2017
    2018
    2019
    2020
    TEV/Total revenue (Avg)
    4.81
    4.75
    5.2
    5.42
    2.1
    2.3
    2.4
    2.7
    P/E
    21.66
    19.42
    21.44
    23.2
    15.2
    16.6
    16.2
    19.4
    P/BV
    1.43
    1.34
    1.48
    1.45
    1.4
    1.5
    1.5
    1.6
    ROE
    7.40%
    6.10%
    7.80%
    2.20%
    8.20%
    7.10%
    7.30%
    6.40%
    Net income margin
    13.20%
    11.10%
    15.20%
    5.90%
    8.40%
    7.30%
    7.90%
    8.50%
    Current ratio
    0.7
    0.6
    0.6
    0.5
    1.3
    1.2
    1.3
    1.4
    Total debt to equity
    130.40%
    132.20%
    131.20%
    130.60%
    84.20%
    85.90%
    87.30%
    78.10%
    Total...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here