Question

1 Approved Answer

Posted on Sep 23, 2024

PLEASE HELP ME ASAP with filling out the common size balance sheet begin{tabular}{|l|l|l|l|l|} hline multicolumn{5}{|c|}{ Common-Size Balance Sheet } hline 2014 & 2015 &

PLEASE HELP ME ASAP with filling out the common size balance sheet image text in transcribed

\begin{tabular}{|l|l|l|l|l|} \hline \multicolumn{5}{|c|}{ Common-Size Balance Sheet } \\ \hline 2014 & 2015 & 2016 & 2017 & 2018 \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline \end{tabular} analysis H K L M Income Statement Balance Sheet Ratio Analysis \begin{tabular}{|c|c|c|c|c|c|} \hline & ThantirC.C4,000 & MatsilDo,110: & E.minnil1,00 & & \\ \hline Equity and other investments & 1,004 & 793 & 726 & 1,086 & 1,203 \\ \hline Goodwill & 2,735 & 2,516 & 2,336 & 2,380 & 2,332 \\ \hline Other long-term assets & 1,799 & 1,869 & 1,855 & 2,563 & 2,381 \\ \hline Total non-current assets (Long-term) & 30,096 & 28,296 & 26,175 & 28.476 & 28,758 \\ \hline TOTAL ASSETS & 34,281 & 37,939 & 31,024 & 33,804 & 32,881 \\ \hline \multicolumn{6}{|l|}{ Current liabilities } \\ \hline Short-term debt & & & 77 & & \\ \hline Accounts payable & 860 & 875 & 756 & 925 & 1,208 \\ \hline Taxes payable & 497 & 464 & 534 & 541 & 482 \\ \hline Accrued liabilities & 1,391 & 1,612 & 1,407 & 1,425 & 1,284 \\ \hline Other current liabilities & & & 695 & & \\ \hline Total current liabilities & 2,748 & 2,950 & 3,468 & 2,891 & 2,974 \\ \hline \multicolumn{6}{|l|}{ Non-current liabilities } \\ \hline Long-term debt & 14,990 & 24,122 & 25,878 & 29.536 & 31,075 \\ \hline Deferred taxes liabilities & 1,624 & 1,704 & 1,817 & 1,119 & 1.216 \\ \hline Doferred revenues & & & & & 628 \\ \hline Other long-term liabilities & 2,066 & 2,074 & 2,064 & 3,525 & 3,178 \\ \hline Total non-current liabilities (Long-term) & 18,680 & 27,900 & 29,760 & 34,181 & 36,096 \\ \hline Total Liabilities & 21,428 & 30,851 & 33,228 & 37,072 & 39,070 \\ \hline \multicolumn{6}{|l|}{ Stockholders' equity } \\ \hline Common stock & 17 & 17 & 17 & 17 & 17 \\ \hline Additional paid-in capital & 6.239 & 6,533 & 6.758 & 7,072 & 7,376 \\ \hline Retained eamings & 43,294 & 44,594 & 46,223 & 48,326 & 50,487 \\ \hline Treasury stock & (35,177) & (41,177) & (52,109) & (56,504) & (61,529) \\ \hline Accumulated other comprehensive income & (1,520) & (2,880) & (3,093) & (2,178) & (2,610) \\ \hline Total stockholders' equity & 12,853 & 7,088 & (2,204) & (3,268) & (6,258) \\ \hline TOTAL LIABILITIES AND STOCKHOLDEA'S EQUI & 34,281 & 37,939 & 31,024 & 33,804 & 32,881 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{ MYSTERY COMPANY BALANCE SHEET } \\ \hline Consolidated Balance Sheet - USD (\$) \$ in Millions & 2014 & 2015 & 2016 & 2017 & 2018 \\ \hline \multicolumn{6}{|l|}{ Current assets } \\ \hline Cash and cash equivalents & 2,078 & 7,686 & 1,223 & 2,464 & 866 \\ \hline Recelvables & 1,214 & 1,299 & 1,474 & 1.976 & 2,442 \\ \hline Inventories & 110 & 100 & 59 & 59 & 51 \\ \hline Prepaid expenses & 783 & 559 & 565 & 828 & 695 \\ \hline Other current assets & & & 1,527 & & \\ \hline Total current assets & 4,186 & 9,643 & 4,849 & 5,327 & 4,053 \\ \hline \multicolumn{6}{|l|}{ Non-current assets } \\ \hline Property, plant and equipment & 39,126 & 37,692 & 34,443 & 36,626 & 37,194 \\ \hline Accumulated Depreciation & (14,569) & (14,575) & (13,186) & (14,178) & (14,351) \\ \hline Net property, plant and equipment & 24,558 & 23,118 & 21,258 & 22.448 & 22.843 \\ \hline Equity and other investments & 1.004 & 793 & 726 & 1,086 & 1.203 \\ \hline Goodwill & 2.735 & 2.516 & 2.336 & 2,380 & 2.332 \\ \hline Other long-term assets & 1.799 & 1.869 & 1.855 & 2.563 & 2.381 \\ \hline Total non-current assots (Long-term) & 30,096 & 28,296 & 26,175 & 28,476 & 28,758 \\ \hline TOTAL ASSETS & 34,281 & 37,939 & 31,024 & 33,804 & 32,881 \\ \hline \multicolumn{6}{|l|}{ Current liabilities } \\ \hline Short-term debt & & & 77 & & \\ \hline Accounts payable & 860 & 875 & 756 & 925 & 1,208 \\ \hline Taxes payable & 497 & 464 & 534 & 541 & 482 \\ \hline Accrued liabilities & 1,391 & 1,612 & 1,407 & 1.425 & 1,284 \\ \hline Other current liabilities & & & 695 & & \\ \hline Total current liabilities & 2,748 & 2,950 & 3,468 & 2.891 & 2,974 \\ \hline \multicolumn{6}{|l|}{ Non-current liabilities } \\ \hline Long-term debt & 14,990 & 24,122 & 25,878 & 29.536 & 31,075 \\ \hline Deferred taxes liabilities & 1,624 & 1,704 & 1,817 & 1.119 & 1,216 \\ \hline Deterred revenues & & & & & 628 \\ \hline Other long-lerm fiabilities & 2,066 & 2.074 & 2.064 & 3.525 & 3,178 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|} \hline \multicolumn{5}{|c|}{ Common-Size Balance Sheet } \\ \hline 2014 & 2015 & 2016 & 2017 & 2018 \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline \end{tabular} analysis H K L M Income Statement Balance Sheet Ratio Analysis \begin{tabular}{|c|c|c|c|c|c|} \hline & ThantirC.C4,000 & MatsilDo,110: & E.minnil1,00 & & \\ \hline Equity and other investments & 1,004 & 793 & 726 & 1,086 & 1,203 \\ \hline Goodwill & 2,735 & 2,516 & 2,336 & 2,380 & 2,332 \\ \hline Other long-term assets & 1,799 & 1,869 & 1,855 & 2,563 & 2,381 \\ \hline Total non-current assets (Long-term) & 30,096 & 28,296 & 26,175 & 28.476 & 28,758 \\ \hline TOTAL ASSETS & 34,281 & 37,939 & 31,024 & 33,804 & 32,881 \\ \hline \multicolumn{6}{|l|}{ Current liabilities } \\ \hline Short-term debt & & & 77 & & \\ \hline Accounts payable & 860 & 875 & 756 & 925 & 1,208 \\ \hline Taxes payable & 497 & 464 & 534 & 541 & 482 \\ \hline Accrued liabilities & 1,391 & 1,612 & 1,407 & 1,425 & 1,284 \\ \hline Other current liabilities & & & 695 & & \\ \hline Total current liabilities & 2,748 & 2,950 & 3,468 & 2,891 & 2,974 \\ \hline \multicolumn{6}{|l|}{ Non-current liabilities } \\ \hline Long-term debt & 14,990 & 24,122 & 25,878 & 29.536 & 31,075 \\ \hline Deferred taxes liabilities & 1,624 & 1,704 & 1,817 & 1,119 & 1.216 \\ \hline Doferred revenues & & & & & 628 \\ \hline Other long-term liabilities & 2,066 & 2,074 & 2,064 & 3,525 & 3,178 \\ \hline Total non-current liabilities (Long-term) & 18,680 & 27,900 & 29,760 & 34,181 & 36,096 \\ \hline Total Liabilities & 21,428 & 30,851 & 33,228 & 37,072 & 39,070 \\ \hline \multicolumn{6}{|l|}{ Stockholders' equity } \\ \hline Common stock & 17 & 17 & 17 & 17 & 17 \\ \hline Additional paid-in capital & 6.239 & 6,533 & 6.758 & 7,072 & 7,376 \\ \hline Retained eamings & 43,294 & 44,594 & 46,223 & 48,326 & 50,487 \\ \hline Treasury stock & (35,177) & (41,177) & (52,109) & (56,504) & (61,529) \\ \hline Accumulated other comprehensive income & (1,520) & (2,880) & (3,093) & (2,178) & (2,610) \\ \hline Total stockholders' equity & 12,853 & 7,088 & (2,204) & (3,268) & (6,258) \\ \hline TOTAL LIABILITIES AND STOCKHOLDEA'S EQUI & 34,281 & 37,939 & 31,024 & 33,804 & 32,881 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{ MYSTERY COMPANY BALANCE SHEET } \\ \hline Consolidated Balance Sheet - USD (\$) \$ in Millions & 2014 & 2015 & 2016 & 2017 & 2018 \\ \hline \multicolumn{6}{|l|}{ Current assets } \\ \hline Cash and cash equivalents & 2,078 & 7,686 & 1,223 & 2,464 & 866 \\ \hline Recelvables & 1,214 & 1,299 & 1,474 & 1.976 & 2,442 \\ \hline Inventories & 110 & 100 & 59 & 59 & 51 \\ \hline Prepaid expenses & 783 & 559 & 565 & 828 & 695 \\ \hline Other current assets & & & 1,527 & & \\ \hline Total current assets & 4,186 & 9,643 & 4,849 & 5,327 & 4,053 \\ \hline \multicolumn{6}{|l|}{ Non-current assets } \\ \hline Property, plant and equipment & 39,126 & 37,692 & 34,443 & 36,626 & 37,194 \\ \hline Accumulated Depreciation & (14,569) & (14,575) & (13,186) & (14,178) & (14,351) \\ \hline Net property, plant and equipment & 24,558 & 23,118 & 21,258 & 22.448 & 22.843 \\ \hline Equity and other investments & 1.004 & 793 & 726 & 1,086 & 1.203 \\ \hline Goodwill & 2.735 & 2.516 & 2.336 & 2,380 & 2.332 \\ \hline Other long-term assets & 1.799 & 1.869 & 1.855 & 2.563 & 2.381 \\ \hline Total non-current assots (Long-term) & 30,096 & 28,296 & 26,175 & 28,476 & 28,758 \\ \hline TOTAL ASSETS & 34,281 & 37,939 & 31,024 & 33,804 & 32,881 \\ \hline \multicolumn{6}{|l|}{ Current liabilities } \\ \hline Short-term debt & & & 77 & & \\ \hline Accounts payable & 860 & 875 & 756 & 925 & 1,208 \\ \hline Taxes payable & 497 & 464 & 534 & 541 & 482 \\ \hline Accrued liabilities & 1,391 & 1,612 & 1,407 & 1.425 & 1,284 \\ \hline Other current liabilities & & & 695 & & \\ \hline Total current liabilities & 2,748 & 2,950 & 3,468 & 2.891 & 2,974 \\ \hline \multicolumn{6}{|l|}{ Non-current liabilities } \\ \hline Long-term debt & 14,990 & 24,122 & 25,878 & 29.536 & 31,075 \\ \hline Deferred taxes liabilities & 1,624 & 1,704 & 1,817 & 1.119 & 1,216 \\ \hline Deterred revenues & & & & & 628 \\ \hline Other long-lerm fiabilities & 2,066 & 2.074 & 2.064 & 3.525 & 3,178 \\ \hline \end{tabular}