Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please, fill the tables using the infromation in the data sheets E12 C E F G H 1 J K L 1 Level of Consolidation

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedPlease, fill the tables using the infromation in the data sheets

E12 C E F G H 1 J K L 1 Level of Consolidation - Company Annual Desc Population Source Data Format Ticker Symbol Adjustment Factor (Company) - Cumulative by ISO Currency Code Current Assets - Total Assets - Total Cast 2 c D STD CAT 1 USD 31967 74704 3C D STD CAT 1 USD 36244 76962 4 C D STD CAT 1 USD 38603 78509 5 C D STD CAT 1 USD 39193 78453 6 C D STD CAT 1 USD 39464 78324 7C D STD CAT 1 USD 43455 82793 8c D STD PLOW 1 USD 182.161 671.899 9 D STD PLOW 1 USD 198.113 685.176 10 C C D STD PLOW 1 USD 199.095 676.193 11 C D STD PLOW 1 USD 211.528 705.695 12 C C D STD PLOW 1 USD 217.187 579.202 13 C D STD PLOW 1 USD 220.431 572.476 14 15 L1 fax Assets - Total L M N R Liabilities - Total IN 61491 63196 1 Assets - Total Cash 2 74704 3 76962 1 7 78509 5 78453 5 78324 7 82793 Cash and Short-Term Investments 7168 7388 8261 8599 7857 8029 8284 8372 9352 9502 64429 63824 62946 0 P Common Shares Outstanding Earnings Per Share (Basic) - Including Extraordi Current Liabilities - Total 586.486 -0.11 26132 597.626 1.27 26931 575.543 10.39 28218 550.083 10.85 26621 545.304 5.51 25717 535.888 11.93 29847 22.502 1.71 51.392 22.591 2.42 80.783 22.701 1.91 79.068 22.795 2.13 78.103 22.857 -3.81 66.206 22.981 1.31 81.916 66277 B e 0 671.899 685.176 676.193 705.695 579.202 572.476 9254 18.609 36.875 27.82 35.665 41.03 36.964 10348 18.609 36.875 27.82 35.665 41.03 36.964 451.436 428.498 393.437 392.532 378.998 357.866 1 2 3 3 4 5 6 R - 1 Liabilities - Total 2 61491 3 63196 4 64429 5 63824 6 62946 7 66277 8 8 451.436 9 428.498 10 393.437 11 392.532 12 378.998 13 357.866 S T T U V W Net Income (Loss) Receivables - Total Revenue - Total Stockholders Equity - Parent Active/Inactive Status Marker -67 14503 38537 13137 A 754 16193 45462 13697 A 6147 17452 54722 14039 A 6093 17904 53800 14588 A 2998 16780 41 748 15331 A 6489 17375 50971 16484 A 39.009 80.13 416.268 220.463 A 55.324 79.12 474.927 256.678 A 43.905 81.485 524.067 282.756 A 49.166 87.871 571.71 313.163 A -86.553 83.195 480.154 200.204 A 30.691 72.257 541.453 214.61 A Price Close - Annual - Fiscal 92.74 157.58 127.07 147.68 182.02 206.74 33.65 37.8 35.89 55 42.77 39.06 14 15 10 Table 1 Liquidity, financial leverage and asset utilization ratios for Caterpillar (CAT) and Do uglas Dynamics, Inc. (PLOW) CAT PLOW Fiscal Quick Ratio Quick Ratio Year CAT Cash Ratio CAT PLOW PLOW Debt-to- Debt-to- Cash Ratio Equity Ratio EquityRatio (x) CAT PLOW Days in Days in Receivables Receivables (days) (days) CAT ROA PLOW ROA (%) 2016 2017 2018 2019 2020 2021 Table 2 Profitability, and market value ratios for Caterpillar (CAT) and Douglas Dynamics, Inc. (PLOW) Fiscal Year CAT Profit Margin Ratio (%) PLOW Profit Margin Ratio (%) CAT ROE (%) PLOW ROE (%) CAT P/E Ratio PLOW P/E Ratio) CAT Price-to-Sales ratio PLOW Prie-to-Sa les ratio (x) 2016 2017 2018 2019 2020 2021 E12 C E F G H 1 J K L 1 Level of Consolidation - Company Annual Desc Population Source Data Format Ticker Symbol Adjustment Factor (Company) - Cumulative by ISO Currency Code Current Assets - Total Assets - Total Cast 2 c D STD CAT 1 USD 31967 74704 3C D STD CAT 1 USD 36244 76962 4 C D STD CAT 1 USD 38603 78509 5 C D STD CAT 1 USD 39193 78453 6 C D STD CAT 1 USD 39464 78324 7C D STD CAT 1 USD 43455 82793 8c D STD PLOW 1 USD 182.161 671.899 9 D STD PLOW 1 USD 198.113 685.176 10 C C D STD PLOW 1 USD 199.095 676.193 11 C D STD PLOW 1 USD 211.528 705.695 12 C C D STD PLOW 1 USD 217.187 579.202 13 C D STD PLOW 1 USD 220.431 572.476 14 15 L1 fax Assets - Total L M N R Liabilities - Total IN 61491 63196 1 Assets - Total Cash 2 74704 3 76962 1 7 78509 5 78453 5 78324 7 82793 Cash and Short-Term Investments 7168 7388 8261 8599 7857 8029 8284 8372 9352 9502 64429 63824 62946 0 P Common Shares Outstanding Earnings Per Share (Basic) - Including Extraordi Current Liabilities - Total 586.486 -0.11 26132 597.626 1.27 26931 575.543 10.39 28218 550.083 10.85 26621 545.304 5.51 25717 535.888 11.93 29847 22.502 1.71 51.392 22.591 2.42 80.783 22.701 1.91 79.068 22.795 2.13 78.103 22.857 -3.81 66.206 22.981 1.31 81.916 66277 B e 0 671.899 685.176 676.193 705.695 579.202 572.476 9254 18.609 36.875 27.82 35.665 41.03 36.964 10348 18.609 36.875 27.82 35.665 41.03 36.964 451.436 428.498 393.437 392.532 378.998 357.866 1 2 3 3 4 5 6 R - 1 Liabilities - Total 2 61491 3 63196 4 64429 5 63824 6 62946 7 66277 8 8 451.436 9 428.498 10 393.437 11 392.532 12 378.998 13 357.866 S T T U V W Net Income (Loss) Receivables - Total Revenue - Total Stockholders Equity - Parent Active/Inactive Status Marker -67 14503 38537 13137 A 754 16193 45462 13697 A 6147 17452 54722 14039 A 6093 17904 53800 14588 A 2998 16780 41 748 15331 A 6489 17375 50971 16484 A 39.009 80.13 416.268 220.463 A 55.324 79.12 474.927 256.678 A 43.905 81.485 524.067 282.756 A 49.166 87.871 571.71 313.163 A -86.553 83.195 480.154 200.204 A 30.691 72.257 541.453 214.61 A Price Close - Annual - Fiscal 92.74 157.58 127.07 147.68 182.02 206.74 33.65 37.8 35.89 55 42.77 39.06 14 15 10 Table 1 Liquidity, financial leverage and asset utilization ratios for Caterpillar (CAT) and Do uglas Dynamics, Inc. (PLOW) CAT PLOW Fiscal Quick Ratio Quick Ratio Year CAT Cash Ratio CAT PLOW PLOW Debt-to- Debt-to- Cash Ratio Equity Ratio EquityRatio (x) CAT PLOW Days in Days in Receivables Receivables (days) (days) CAT ROA PLOW ROA (%) 2016 2017 2018 2019 2020 2021 Table 2 Profitability, and market value ratios for Caterpillar (CAT) and Douglas Dynamics, Inc. (PLOW) Fiscal Year CAT Profit Margin Ratio (%) PLOW Profit Margin Ratio (%) CAT ROE (%) PLOW ROE (%) CAT P/E Ratio PLOW P/E Ratio) CAT Price-to-Sales ratio PLOW Prie-to-Sa les ratio (x) 2016 2017 2018 2019 2020 2021

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A Full Guide To Bitcoin Investment

Authors: J.b. Yupangco

1st Edition

8389911302, 978-8389911308

More Books

Students also viewed these Finance questions

Question

=+ a. The president raises taxes to reduce the budget defi cit.

Answered: 1 week ago