Homework Help is Here – Start Your Trial Now!
Business
Accounting
For questions #33-40, refer to the following financial information for Disney (DIS). Use Excel formulas for all calculations. millions) BALANCE SHEET: Assets: Cash Accounts Receivable Inventory Other Current Assets Fixed Assets, net Other Long-Term Assets Total Assets Liabilities and Equity: Accounts Payable Other Current Liabilities Long-term Debt Other Noncurrent Liabilities Common Stock Retained Earnings Total Liabilities and Equity ($ millions) INCOME STATEMENT: Sales Cost of Goods Sold General and Administrative Expenses Depreciation Expense Earnings Before Interest and Taxes Interest Expense Pretax Net Income Income Taxes Net Income SUPPLEMENTAL DATA: Average # shares outstanding throughout 2023 Current market price of DIS shares 2022 $4,017 8,633 588 2,651 28,406 51,494 $95,789 $6,490 13,105 19,119 12,071 36,248 8,756 $95,789 2023 $4,150 9,334 1,392 1,949 29,540 52,233 $98,598 $6,503 11,257 17,184 10,822 36,779 16,053 $98,598 FY2023 $59,434 35,737 5,743 3,011 14,943 682 14,261 1,663 $12,598 1,500 million $95.00 per share

For questions #33-40, refer to the following financial information for Disney (DIS). Use Excel formulas for all calculations. millions) BALANCE SHEET: Assets: Cash Accounts Receivable Inventory Other Current Assets Fixed Assets, net Other Long-Term Assets Total Assets Liabilities and Equity: Accounts Payable Other Current Liabilities Long-term Debt Other Noncurrent Liabilities Common Stock Retained Earnings Total Liabilities and Equity ($ millions) INCOME STATEMENT: Sales Cost of Goods Sold General and Administrative Expenses Depreciation Expense Earnings Before Interest and Taxes Interest Expense Pretax Net Income Income Taxes Net Income SUPPLEMENTAL DATA: Average # shares outstanding throughout 2023 Current market price of DIS shares 2022 $4,017 8,633 588 2,651 28,406 51,494 $95,789 $6,490 13,105 19,119 12,071 36,248 8,756 $95,789 2023 $4,150 9,334 1,392 1,949 29,540 52,233 $98,598 $6,503 11,257 17,184 10,822 36,779 16,053 $98,598 FY2023 $59,434 35,737 5,743 3,011 14,943 682 14,261 1,663 $12,598 1,500 million $95.00 per share

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Question

6

For questions #33-40, refer to the following financial information for Disney (DIS). Use Excel formulas for all calculations. ($ millions) BALANCE SHEET: Assets: Cash Accounts Receivable Inventory Other Current Assets Fixed Assets, net Other Long-Term Assets Total Assets Liabilities and Equity: Accounts Payable Other Current Liabilities Long-term Debt Other Noncurrent Liabilities Common Stock Retained Earnings Total Liabilities and Equity ($ millions) INCOME STATEMENT: Sales Cost of Goods Sold General and Administrative Expenses Depreciation Expense Earnings Before Interest and Taxes Interest Expense Pretax Net Income Income Taxes Net Income SUPPLEMENTAL DATA: Average # shares outstanding throughout 2023 Current market price of DIS shares 2022 $4,017 8,633 588 2,651 28,406 51,494 $95,789 $6,490 13,105 19,119 12,071 36,248 8,756 $95,789 2023 $4,150 9,334 1,392 1,949 29,540 52,233 $98,598 $6,503 11,257 17,184 10,822 36,779 16,053 $98,598 FY2023 $59,434 35,737 5,743 3,011 14,943 682 14,261 1,663 $12,598 1,500 million $95.00 per share
Transcribed Image Text:For questions #33-40, refer to the following financial information for Disney (DIS). Use Excel formulas for all calculations. ($ millions) BALANCE SHEET: Assets: Cash Accounts Receivable Inventory Other Current Assets Fixed Assets, net Other Long-Term Assets Total Assets Liabilities and Equity: Accounts Payable Other Current Liabilities Long-term Debt Other Noncurrent Liabilities Common Stock Retained Earnings Total Liabilities and Equity ($ millions) INCOME STATEMENT: Sales Cost of Goods Sold General and Administrative Expenses Depreciation Expense Earnings Before Interest and Taxes Interest Expense Pretax Net Income Income Taxes Net Income SUPPLEMENTAL DATA: Average # shares outstanding throughout 2023 Current market price of DIS shares 2022 $4,017 8,633 588 2,651 28,406 51,494 $95,789 $6,490 13,105 19,119 12,071 36,248 8,756 $95,789 2023 $4,150 9,334 1,392 1,949 29,540 52,233 $98,598 $6,503 11,257 17,184 10,822 36,779 16,053 $98,598 FY2023 $59,434 35,737 5,743 3,011 14,943 682 14,261 1,663 $12,598 1,500 million $95.00 per share
For questions #33-40, refer to the following financial information for Disney (DIS). Use Excel formulas for all calculations. ($ millions) SUPPLEMENTAL DATA: Average # shares outstanding throughout 2023 33. What was Disney's quick ratio at the end of fiscal 2023? (round to 2 decimal places) 34. What was Disney's inventory turnover for fiscal 2023? (round to nearest number) For balance sheet accounts, use the average of the beginning -of-year and end -of-year balances. 35. What was Disney's fixed asset turnover for fiscal 2023? (round to 2 decimal places) For balance sheet accounts, use the average of the beginning - of - year and end-of-year balances. 36. How many days sales in receivables did Disney average in fiscal 2023? (round to nearest number) For balance sheet accounts, use the average of the beginning - of - year and end-of-year balances. 37. What was Disney's Interest Coverage ratio in fiscal 2023? (round to nearest number) 38. What was Disney's Return on Equity in fiscal 2023? (round to nearest percentage) For balance sheet accounts, use the average of the beginning-of-year and end-of-year balances. 39. What is Disney's PE ratio based on its current market price? (round to 1 decimal place) 40. How much did Disney pay out in dividends during fiscal 2023?
Transcribed Image Text:For questions #33-40, refer to the following financial information for Disney (DIS). Use Excel formulas for all calculations. ($ millions) SUPPLEMENTAL DATA: Average # shares outstanding throughout 2023 33. What was Disney's quick ratio at the end of fiscal 2023? (round to 2 decimal places) 34. What was Disney's inventory turnover for fiscal 2023? (round to nearest number) For balance sheet accounts, use the average of the beginning -of-year and end -of-year balances. 35. What was Disney's fixed asset turnover for fiscal 2023? (round to 2 decimal places) For balance sheet accounts, use the average of the beginning - of - year and end-of-year balances. 36. How many days sales in receivables did Disney average in fiscal 2023? (round to nearest number) For balance sheet accounts, use the average of the beginning - of - year and end-of-year balances. 37. What was Disney's Interest Coverage ratio in fiscal 2023? (round to nearest number) 38. What was Disney's Return on Equity in fiscal 2023? (round to nearest percentage) For balance sheet accounts, use the average of the beginning-of-year and end-of-year balances. 39. What is Disney's PE ratio based on its current market price? (round to 1 decimal place) 40. How much did Disney pay out in dividends during fiscal 2023?
Expert Solution
steps

Step by step

Solved in 5 steps with 6 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Cash Flow Statement Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS