On the same spreadsheet, complete an analysis for each ratio category similar to the one on page 97 of the text book . A ratio analysis includes a trend analysis, an industry comparison and a sentence summarizing your overall view of the company's financial performance in that category. Please be thorough, this is an analysis.

MYSTERY COMPANY BALANCE SHEET 2015 7,686 1,299 100 559 2017 2,464 1,976 59 828 2018 866 2,442 51 695 2019 899 2,224 50 385 9,643 37,692 (14,575) 23,118 793 2,516 1,869 28,296 37,939 2016 1,223 1,474 59 565 1,527 4,849 34,443 (13,186) 21,258 726 2,336 1,855 26,175 31,024 77 756 248 533 1,159 695 3,468 25,878 1,817 5,327 36,626 (14,178) 22,448 1,086 2,380 2,563 28,476 33,804 Consolidated Balance Sheet - USD ($) Sin Millions Cash and cash equivalents Receivables Inventories Prepaid expenses Other current assets Total current assets Property, plant and equipment Accumulated Depreciation Net property, plant and equipment Equity and other investments Goodwill Other long-term assets Total non-current assets (Long-term) TOTAL ASSETS Current debt and capital lease obligation Accounts payable Interest payable Taxes payable Accrued liabilities Other current liabilities Total current liabilities Long-term debt Deferred taxes liabilities Deferred income/liabilities Payables and accrued expenses Other long-term liabilities Total non-current liabilities (Long-term) Total Liabilities Common stock Additional paid-in capital Retained earnings Treasury stock Accumulated other comprehensive income Total stockholders' equity TOTAL LIABILITIES AND STOCKHOLDER'S EQUITY 4,053 37,194 (14,351) 22,843 1,203 2,332 2,381 28,758 32,881 3,558 52,312 (14,891) 37,421 1,270 2,678 2,584 43,953 47,511 680 988 338 579 1,036 874 233 464 1,379 925 279 541 1,208 297 482 987 1,146 2,950 24,122 1,704 2,891 29,537 1,119 2,074 27,900 30,851 17 6,533 44,594 (41,177) (2,879) 7,088 37,939 2,065 29,760 33,228 17 6,758 46,223 (52,109) (3,093) (2,204) 31,024 2,371 1,154 34,181 37,072 17 7,072 48,325 (56,504) (2,178) (3,268) 33,804 2,974 31,075 1,216 628 2,081 1,096 36,096 39,070 17 7,377 50,487 (61,529) (2,610) (6,258) 32,881 3,621 46,876 1,318 662 2,266 980 52,100 55,721 17 7,655 52,930 (66,329) (2,483) (8,210) 47,511 Balance Sheet Analysis List your observations from the Balance Sheet Analysis here: MYSTERY COMPANY BALANCE SHEET 2015 7,686 1,299 100 559 2017 2,464 1,976 59 828 2018 866 2,442 51 695 2019 899 2,224 50 385 9,643 37,692 (14,575) 23,118 793 2,516 1,869 28,296 37,939 2016 1,223 1,474 59 565 1,527 4,849 34,443 (13,186) 21,258 726 2,336 1,855 26,175 31,024 77 756 248 533 1,159 695 3,468 25,878 1,817 5,327 36,626 (14,178) 22,448 1,086 2,380 2,563 28,476 33,804 Consolidated Balance Sheet - USD ($) Sin Millions Cash and cash equivalents Receivables Inventories Prepaid expenses Other current assets Total current assets Property, plant and equipment Accumulated Depreciation Net property, plant and equipment Equity and other investments Goodwill Other long-term assets Total non-current assets (Long-term) TOTAL ASSETS Current debt and capital lease obligation Accounts payable Interest payable Taxes payable Accrued liabilities Other current liabilities Total current liabilities Long-term debt Deferred taxes liabilities Deferred income/liabilities Payables and accrued expenses Other long-term liabilities Total non-current liabilities (Long-term) Total Liabilities Common stock Additional paid-in capital Retained earnings Treasury stock Accumulated other comprehensive income Total stockholders' equity TOTAL LIABILITIES AND STOCKHOLDER'S EQUITY 4,053 37,194 (14,351) 22,843 1,203 2,332 2,381 28,758 32,881 3,558 52,312 (14,891) 37,421 1,270 2,678 2,584 43,953 47,511 680 988 338 579 1,036 874 233 464 1,379 925 279 541 1,208 297 482 987 1,146 2,950 24,122 1,704 2,891 29,537 1,119 2,074 27,900 30,851 17 6,533 44,594 (41,177) (2,879) 7,088 37,939 2,065 29,760 33,228 17 6,758 46,223 (52,109) (3,093) (2,204) 31,024 2,371 1,154 34,181 37,072 17 7,072 48,325 (56,504) (2,178) (3,268) 33,804 2,974 31,075 1,216 628 2,081 1,096 36,096 39,070 17 7,377 50,487 (61,529) (2,610) (6,258) 32,881 3,621 46,876 1,318 662 2,266 980 52,100 55,721 17 7,655 52,930 (66,329) (2,483) (8,210) 47,511 Balance Sheet Analysis List your observations from the Balance Sheet Analysis here