Answer 1-4 based on the link provided: Discuss year 2018

https://docs.google.com/spreadsheets/d/1sJucsYpSSaUijd2ptjdmWjluDICCTJ2_HjyzhMffEL0/edit#gid=679851468 

Or, see attachment.

Please see all the tabs of the google sheet/link for a better understanding.

1.  Review the 14 financial ratios shown across the tabs and make some conclusions or judgments about the values, trends, or comparisons with the other companies. For example, if one company has a significantly higher debt-to-equity ratio than the other two, what might be driving this?

2.  Has the company you are analyzing seen any major changes in its ratios in the past three years? Which of the three companies is most liquid in the most current year?  

3.  How has your company managed short-term liabilities over the last three years?

4.  Analyze liquidity, profitability, financing (leverage), and activity for your company. Where is it strong?

Transcribed Image Text:

B1 1 2 3 4 5 6 7 Data Analytics Labs 8-1 and 8-3 X +8-3A- Google Sheets X с docs.google.com/spreadsheets/d/1sJucsYpSSaUijd2ptjdmWjluDICCTJ2_HjyzhMffELO/edit#gid=679851468 Apps G Google Translate P Pace Portal Dell Financial Servic... Handshake M McGraw-Hill Connect Citizenship and Im... Course Hero Home | Chegg.com Pace Alumni Mento... NYU Langone Healt... 8-3A 188 Last edit was seconds ago File Edit View Insert Format Data Tools Extensions Help iXBRLAnalyst 27 $ %0.00 123- Calibri 100% Y 10 B IS A G 1₁ ▾ fx To edit this sheet, log into your Google Drive, then go to File > Make a Copy... This works with S&P 100 companies without additional login. For additional companies, see findynamics.com. A B C D E F G H 1 J K L M N To edit this sheet, log into your Google Drive, then go to File > Make a Copy.... This works with S&P 100 companies without additional login. For additional companies, see findynamics.com. Exploring Financial Ratios <---Edit these values to update the tables below. Main Company Ticker (e.g. MSFT) Most Recent Year Period Round to Comparable 1 Ticker XOM 2018 Q2 1,000,000 CVX (e.g. 2014) (e.g. FY or Q2) (e.g. 100,000) (e.g. FB) Welcome to financial ratios using XBRL and Excel Online. Feel free to change any of the values in the box to the left. This table will automatically refresh and pull the most recent financial statement information from the SEC. Once you've chosen some companies for comparison, click through the sheets below to explore different financial ratios and complete the given questions. Comparable 2 Ticker COP (e.g. AAPL) Financial Facts Exxon Mobil Corp Chevron Corp Conocophillips Balance Sheet 2015 2016 2018 [Cash, Cash Equivalents And Short Term Investments] 4,358 $ 4,775 $ 7,686 10,267 $ [Accounts Receivable, Current] 3,020 $ [Inventory] 1,019 $ [Other Current Assets] 8.306 $ [Current Assets] 21,827 $ 4,332 S 15.311 S 45,828 S 296,645 S 342,473 S 51,504 S 19,879 $ [Noncurrent Assets] 58,125 S [Assets] 13,168 Ś 16,672 6,075 Ś 6,644 2.621 S 3.312 26,626 $ 34,256 227,973 S 223,673 254,599 S 257,929 27,956 $ 31,862 79.255 $ 72,687 107,211 S 104,549 147,388 S 153,380 254,599 S 257,929 78,004 S [Current Liabilities] 9,926 S [Noncurrent Liabilities] 114,094 S 37.579 $ [Liabilities] 47.505 S [Stockholders Equity] 165.598 S 176,875 $ 342,473 S 30,499 $ [Liabilities & Equity] 78,004 $ Income Statement. [Sales, Net] 2018 42,236 24,744 8,882 S [Cost of Revenue] 2,922 $ [Interest Expense] 2016 57,694 S 40,641 $ 75 $ 715 S 1,681 S 34,480 $ 18.325 S 48 S 487 S 217 306 Ś (935) S [Income Taxes] 1.483 [Net Income] 1,466 S 3.422 (3,426) S Tax rate E 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 HH + O Facts - 9: Liquidity Financing $ $ $ $ $ S S $ $ S $ $ 4,343 S 25,957 S 4,364 S 21,291 S 51,647 $ 296.613 S 348,260 S 58,372 $ 110,890 $ 169,262 $ 178.998 Ś 348,260 $ 74,113 $ 52,512 $ 85 $ 2.692 $ 4,262 $ 20% 2015 Activity O Profitability 2017 4,042 $ 21,289 $ 11,135 $ 5.714 $ 42,180 $ 300,832 $ 343,012 $ 50,949 $ 106,225 S 157,174 S 185,838 S 343,012 S 56,026 S 44,190 Ś 158 S 892 S 3.264 S DuPont 2017 EC- 3,430 S $ S 26,993 14,373 5,759 $ 50,555 $ 298,235 $ 348,790 S 62,447 S 92,810 Ś 155.257 S 193,533 S 348.790 S 2018 71,456 $ - $ 147 $ 2.526 S 3,986 S Summary - 2017 2017 2018 ▼ $ $ $ $ S S S $ $ S $ S $ $ $ S S 2017 2017 2018 3,846 3,750 1,093 3.531 11,608 57.328 68,936 6,638 31.076 37,714 31.222 68,936 9,240 3,064 177 965 1,654 2018 0 MyChart - Home P Q R S Other bookmarks T 6 Share U ⠀ Reading list D 同 19 ( + 11:42 PM 10/20/2021 B1 1 2 3 4 5 6 7 Data Analytics Labs 8-1 and 8-3 X +8-3A- Google Sheets X с docs.google.com/spreadsheets/d/1sJucsYpSSaUijd2ptjdmWjluDICCTJ2_HjyzhMffELO/edit#gid=679851468 Apps G Google Translate P Pace Portal Dell Financial Servic... Handshake M McGraw-Hill Connect Citizenship and Im... Course Hero Home | Chegg.com Pace Alumni Mento... NYU Langone Healt... 8-3A 188 Last edit was seconds ago File Edit View Insert Format Data Tools Extensions Help iXBRLAnalyst 27 $ %0.00 123- Calibri 100% Y 10 B IS A G 1₁ ▾ fx To edit this sheet, log into your Google Drive, then go to File > Make a Copy... This works with S&P 100 companies without additional login. For additional companies, see findynamics.com. A B C D E F G H 1 J K L M N To edit this sheet, log into your Google Drive, then go to File > Make a Copy.... This works with S&P 100 companies without additional login. For additional companies, see findynamics.com. Exploring Financial Ratios <---Edit these values to update the tables below. Main Company Ticker (e.g. MSFT) Most Recent Year Period Round to Comparable 1 Ticker XOM 2018 Q2 1,000,000 CVX (e.g. 2014) (e.g. FY or Q2) (e.g. 100,000) (e.g. FB) Welcome to financial ratios using XBRL and Excel Online. Feel free to change any of the values in the box to the left. This table will automatically refresh and pull the most recent financial statement information from the SEC. Once you've chosen some companies for comparison, click through the sheets below to explore different financial ratios and complete the given questions. Comparable 2 Ticker COP (e.g. AAPL) Financial Facts Exxon Mobil Corp Chevron Corp Conocophillips Balance Sheet 2015 2016 2018 [Cash, Cash Equivalents And Short Term Investments] 4,358 $ 4,775 $ 7,686 10,267 $ [Accounts Receivable, Current] 3,020 $ [Inventory] 1,019 $ [Other Current Assets] 8.306 $ [Current Assets] 21,827 $ 4,332 S 15.311 S 45,828 S 296,645 S 342,473 S 51,504 S 19,879 $ [Noncurrent Assets] 58,125 S [Assets] 13,168 Ś 16,672 6,075 Ś 6,644 2.621 S 3.312 26,626 $ 34,256 227,973 S 223,673 254,599 S 257,929 27,956 $ 31,862 79.255 $ 72,687 107,211 S 104,549 147,388 S 153,380 254,599 S 257,929 78,004 S [Current Liabilities] 9,926 S [Noncurrent Liabilities] 114,094 S 37.579 $ [Liabilities] 47.505 S [Stockholders Equity] 165.598 S 176,875 $ 342,473 S 30,499 $ [Liabilities & Equity] 78,004 $ Income Statement. [Sales, Net] 2018 42,236 24,744 8,882 S [Cost of Revenue] 2,922 $ [Interest Expense] 2016 57,694 S 40,641 $ 75 $ 715 S 1,681 S 34,480 $ 18.325 S 48 S 487 S 217 306 Ś (935) S [Income Taxes] 1.483 [Net Income] 1,466 S 3.422 (3,426) S Tax rate E 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 HH + O Facts - 9: Liquidity Financing $ $ $ $ $ S S $ $ S $ $ 4,343 S 25,957 S 4,364 S 21,291 S 51,647 $ 296.613 S 348,260 S 58,372 $ 110,890 $ 169,262 $ 178.998 Ś 348,260 $ 74,113 $ 52,512 $ 85 $ 2.692 $ 4,262 $ 20% 2015 Activity O Profitability 2017 4,042 $ 21,289 $ 11,135 $ 5.714 $ 42,180 $ 300,832 $ 343,012 $ 50,949 $ 106,225 S 157,174 S 185,838 S 343,012 S 56,026 S 44,190 Ś 158 S 892 S 3.264 S DuPont 2017 EC- 3,430 S $ S 26,993 14,373 5,759 $ 50,555 $ 298,235 $ 348,790 S 62,447 S 92,810 Ś 155.257 S 193,533 S 348.790 S 2018 71,456 $ - $ 147 $ 2.526 S 3,986 S Summary - 2017 2017 2018 ▼ $ $ $ $ S S S $ $ S $ S $ $ $ S S 2017 2017 2018 3,846 3,750 1,093 3.531 11,608 57.328 68,936 6,638 31.076 37,714 31.222 68,936 9,240 3,064 177 965 1,654 2018 0 MyChart - Home P Q R S Other bookmarks T 6 Share U ⠀ Reading list D 同 19 ( + 11:42 PM 10/20/2021

Answer rating: 100% (QA)

1 The time interest earned ratio is how likely a company will be able to pay back creditors Exxon Mobil is the lowest at 2394 this seems that they are repaying their creditors back too fast and not in... View the full answer