Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Describe the changes of the Comparative Balance Sheet Analysis. (300 word min.) Report Date 2016 2017 2018 Increase/ Decrease % Change Increase/ Decrease % Change
Describe the changes of the Comparative Balance Sheet Analysis. (300 word min.)
Report Date | 2016 | 2017 | 2018 | Increase/ Decrease | % Change | Increase/ Decrease | % Change |
Long term debt excluding current liabilities | $ 14,394,000 | $ 15,564,000 | $ 14,391,000 | $ 1,170,000 | 8.13% | $ (1,173,000) | -7.54% |
Deferred Revenue - extended protection plans | $ 763,000 | $ 803,000 | $ 827,000 | $ 40,000 | 5.24% | $ 24,000 | 2.99% |
Other liabilities | $ 843,000 | $ 955,000 | $ 1,149,000 | $ 112,000 | 13.29% | $ 194,000 | 20.31% |
Total Liabilities | $ 27,974,000 | $ 29,418,000 | $ 30,864,000 | $ 1,444,000 | 5.16% | $ 1,446,000 | 4.92% |
Common Stock | $ 433,000 | $ 415,000 | $ 401,000 | $ (18,000) | -4.16% | $ (14,000) | -3.37% |
Capital in excess of par value | $ - | $ 22,000 | $ - | $ 22,000 | $ (22,000) | -100.00% | |
Retained Earnings | $ 6,241,000 | $ 5,425,000 | $ 3,452,000 | $ (816,000) | -13.07% | $ (1,973,000) | -36.37% |
Accumulated other comprehensive income (loss) | $ (240,000) | $ 11,000 | $ (209,000) | $ 251,000 | -104.58% | $ (220,000) | -2000.00% |
Total Shareholder's Equity | $ 6,434,000 | $ 5,873,000 | $ 3,644,000 | $ (561,000) | -8.72% | $ (2,229,000) | -37.95% |
Total Liabilities & Shareholder's Equity | $ 34,408,000 | $ 35,291,000 | $ 34,508,000 | $ 883,000 | 2.57% | $ (783,000) | -2.22% |
Report Date | 2016 | 2017 | 2018 | Increase/ Decrease | % Change | Increase/ Decrease | % Change |
$ in Millions | |||||||
Cash & Cash Equivalents | $ 2,538 | $ 3,595 | $ 1,778 | $ 1,057 | 41.65% | $ (1,817) | -50.54% |
Receivables, Net | $ 2,029 | $ 1,952 | $ 1,936 | $ (77) | -3.79% | $ (16) | -0.82% |
Merchandise Inventory | $ 12,549 | $ 12,748 | $ 13,925 | $ 199 | 1.59% | $ 1,177 | 9.23% |
Other current assets | $ 608 | $ 638 | $ 890 | $ 30 | 4.93% | $ 252 | 39.50% |
Total Current Assets | $ 17,724 | $ 18,933 | $ 18,529 | $ 1,209 | 6.82% | $ (404) | -2.13% |
Net Property and Equipment | $ 21,914 | $ 22,075 | $ 22,375 | $ 161 | 0.73% | $ 300 | 1.36% |
Goodwill | $ 2,093 | $ 2,275 | $ 2,252 | $ 182 | 8.70% | $ (23) | -1.01% |
Other assets | $ 1,235 | $ 1,246 | $ 847 | $ 11 | 0.89% | $ (399) | -32.02% |
Total Assets | $ 42,966 | $ 44,529 | $ 44,003 | $ 1,563 | 3.64% | $ (526) | -1.18% |
Short Term Debt | $ 710 | $ 1,559 | $ 1,339 | $ 849 | 119.58% | $ (220) | -14.11% |
Accounts Payable | $ 7,000 | $ 7,244 | $ 7,755 | $ 244 | 3.49% | $ 511 | 7.05% |
Accrued Salaries and related expenses | $ 1,484 | $ 1,640 | $ 1,506 | $ 156 | 10.51% | $ (134) | -8.17% |
Sales Tax Expenses | $ 508 | $ 520 | $ 656 | $ 12 | 2.36% | $ 136 | 26.15% |
Deferred Revenue | $ 1,669 | $ 1,805 | $ 1,782 | $ 136 | 8.15% | $ (23) | -1.27% |
Income Tax Payable | $ 25 | $ 54 | $ 11 | $ 29 | 116.00% | $ (43) | -79.63% |
Current Installments of Long term debt | $ 542 | $ 1,202 | $ 1,056 | $ 660 | 121.77% | $ (146) | -12.15% |
Other current expenses | $ 2,195 | $ 2,170 | $ 2,611 | $ (25) | -1.14% | $ 441 | 20.32% |
Total Current Liabilities | $ 14,133 | $ 16,194 | $ 16,716 | $ 2,061 | 14.58% | $ 522 | 3.22% |
Long term debt excluding current Installments | $ 22,349 | $ 24,267 | $ 26,807 | $ 1,918 | 8.58% | $ 2,540 | 10.47% |
Deferred Income Tax | $ 296 | $ 440 | $ 491 | $ 144 | 48.65% | $ 51 | 11.59% |
Other long term liabilities | $ 1,855 | $ 2,174 | $ 1,867 | $ 319 | 17.20% | $ (307) | -14.12% |
Total Liabilities | $ 38,633 | $ 43,075 | $ 45,881 | $ 4,442 | 11.50% | $ 2,806 | 6.51% |
Common Stock, Par Value $0.05 | $ 88 | $ 89 | $ 89 | $ 1 | 1.14% | $ - | 0.00% |
Paid in Capital | $ 9,787 | $ 10,192 | $ 10,578 | $ 405 | 4.14% | $ 386 | 3.79% |
Retained Earnings | $ 35,519 | $ 39,935 | $ 46,423 | $ 4,416 | 12.43% | $ 6,488 | 16.25% |
Accumulated other comprehensive income (loss) | $ (867) | $ (566) | $ (772) | $ 301 | -34.72% | $ (206) | 36.40% |
Treasury Stock, at cost | $ (40,194) | $ (48,196) | $ (58,196) | $ (8,002) | 19.91% | $ (10,000) | 20.75% |
Total Shareholder's Equity | $ 4,333 | $ 1,454 | $ (1,878) | $ (2,879) | -66.44% | $ (3,332) | -229.16% |
Total Liabilities & Shareholder's Equity | $ 42,966 | $ 44,529 | $ 44,003 | $ 1,563 | 3.64% | $ (526) | -1.18 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started