AutoSave ON w Chapter - Saved Q v Home Insert Draw Design Layout References Mailings Review View Share Comments Outline Ruler One Page Print Web Focus Immersive Gridlines Zoom Zoom BE Multiple Pages New Switch Layout Layout Draft Arrange Split Reader Navigation Pane to 100% _ Page Width Window Macros All Windows Ch 12 Problem G The Walt Disney Company operates several ranges of products from theme parks and resorts to broadcasting and other creative content. The following balance sheet and Please only in excel and screenshot it. Thank you. Deere & Company manufactures, distributes, and supplementary data are for The Walt Disney Company. finances a full range of agricultural equipment; a broad range of industrial equipment for construction, forestry, and public works; and a variety of lawn and grounds care equipment. The company also provides credit, health care, and insurance products for businesses and the general public. Consider the following The Walt Disney Company information from the Deere & Company Annual Report: Consolidated Balance Sheet (in millions) For Year Ended September 30 (in millions) Year 1 Year 2 Year 3 Year 4 Assets Sales $12,791 $13,822 $11,751 $13,137 Cash and cash equivalents 842 Cost of goods sold 8,481 9.234 8,178 8.936 Receivables 3,599 Gross margin 4,310 4.588 3,573 4,201 Inventories 702 Operating expenses 2,69 2,841 3,021 3,236 Film and television costs 1,162 Net operating income $ 1,616 $ 1,747 $ 552 $ 965 Other 1,258 Total current assets 7,563 1. Prepare a statement showing the trend percentages for each item using Year 1 as the base year. 2. Prepare a horizontal analysis including the dollar and percent change for Year 4. Film and television costs, prepaid long term 5,339 3. Prepare a vertical analysis showing the common size percents for years 3 and 4. Investments 2,270 4. Comment on your analysis. Attractions, buildings, and equipment $16,160 Problem C The following data are for Toy Company: Accumulated depreciation -6,742 9,418 Project in process 1,995 December 31 Land 597 Current Prior Intangibles assets, net 16,117 Prepaid expenses 34,500 45,000 Other assets 1,428 Accrued liabilities 210,000 186,000 Total Long Term Assets 37,164 Cash in Bank / 1,095,000 975,000 Total Assets 44.727 Wages payable -0- 7,500 Accounts payable 14,000 585,000 Liabilities and stockholders' equity Merchandise inventory 1,342,500 1,437,000 Accounts payable and accrued liabilities $ 5,161 Bonds payable, due in 2025 515,00 594,000 Current portion of borrowing 2,502 Short Term Investment (marketable securities) 217,500 147,000 195,000 Unearned royalties 739 Notes payable (due in six months) 300,000 Total current liabilities 8,402 Accounts receivable, net 835,500 813,000 Cash flow from operating activities 92,000 180,000 Borrowings 6,959 Deferred income taxes 2,833 1. Compute the amount of working capital at both year-end dates. Other long-term liabilities 2.377 Compute the current ratio at both year-end dates. Minority interest 56 3. Compute the acid-test ratio at both year-end dates. Total long term liabilities 12,225 5 . Compute the cash flow liquidity ratio at both year-end dates. Comment briefly on the company's short-term financial position. Common shareholders' equity common shares ($.01 par value, 1,210,000 avg shares outstanding) 12,100 Retained earnings 2,767 Cumulative translation and other adjustments (27) Treasury shares (740) Total equity 24,100 Adapted from "Accounting Principles: A Business Perspective, Financial Accounting (Chapters 9 - 18)" A Textbook Equity Quen= College Textbook originally by Hermanson, Edwards, and Maher Adapted from "Accounting Principles: A Business Perspective, Financial Accounting (Chapters 9 - 18)" A Textbook Equity Seen= College Textbook originally by Hermanson, Edwards, and Maher Page 1 of 3 580 words X English (United States) Focus + 77%AutoSave ON w Chapter - Saved Q v Home Insert Draw Design Layout References Mailings Review View Share Comments Outline Ruler One Page Print Web Gridlines Multiple Pages Draft Focus Immersive Zoom Zoom New Arrange Split Switch Macros Layout Layout Reader Navigation Pane to 100% _ Page Width Window All Windows December 31 Current Prior Intangibles assets, net 16,117 Prepaid expenses 34,500 45,00 Other assets 1,428 Accrued liabilities 210,000 186,00 Total Long Term Assets 37,164 Cash in Bank A 1,095,000 75,000 Total Assets 44.727 Wages payable -0- 37,500 Accounts payable 714,00 585,000 Liabilities and stockholders' equity Merchandise inventory 1,342,500 1,437,000 Accounts payable and accrued liabilities $ 5,161 Bonds payable, due in 2025 615,000 594,000 Current portion of borrowing 2,502 Short Term Investment (marketable securities) 217,500 147,000 Unearned royalties 739 Notes payable (due in six months) 300,00 195,000 Total current liabilities 8,402 Accounts receivable, net $35,50 813,000 Borrowings 6,959 Cash flow from operating activities 192,000 180,000 Deferred income taxes 2,833 1. Compute the amount of working capital at both year-end dates. Other long-term liabilities 2,377 2. Compute the current ratio at both year-end dates Minority interest 56 3. Compute the acid-test ratio at both year-end dates. Total long term liabilities 12,225 4. Compute the cash flow liquidity ratio at both year-end dates. 5 . Comment briefly on the company's short-term financial position. Common shareholders' equity Common shares ($.01 par value, 1,210,000 avg shares outstanding) 12,100 Retained earnings 12,767 Cumulative translation and other adjustments (27) Treasury shares (740) Total equity 24,100 Adapted from "Accounting Principles: A Business Perspective, Financial Accounting (Chapters 9 - 18)" A Textbook Equity Onen= College Textbook originally by Hermanson, Edwards, and Maher Adapted from "Accounting Principles: A Business Perspective, Financial Accounting (Chapters 9 - 18)" A Textbook Equity Onen= Callage Textbook originally by Hermanson, Edwards, and Maher Total liabilities and stockholders' equity $ 44.727 Net income, $920. Income before interest and taxes, $3,231. Cost of goods sold, $21,321. Net sales, $25,402. Calculate the following ratios and show your computations. For calculations normally involving averages, such as average stockholders' equity, average accounts receivable, and average inventory, use year-end amounts. Disney does not have preferred shareholders or preferred dividends. 1. Current ratio. 2. Accounts Receivable 3. Days Sales Uncollected 4. Inventory Turnover 5. Days Sales in Inventory 6. Debt Ratio 7. Profit Margin Rati 8. Gross Margin Ratio 9. Return on common stockholder's equity 10. Basic Earnings per share Analyze each of these ratios. Page 3 of 3 580 words English (United States) Focus + 77%