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. 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? 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 3 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. 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? 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 3 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

Principles of Accounting Volume 1
Principles of Accounting Volume 1
19th Edition
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax
Chapter9: Accounting For Receivables
Section: Chapter Questions
Problem 8PA: The following select financial statement information from Candid Photography. Compute the accounts...
See similar textbooks
icon
Related questions
Question
For questions # 33 - 40, refer to the following financial information for Disney (DIS). Use Excel formulas for all calculations. 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? 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 3 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. 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? 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 3 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
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
steps

Unlock instant AI solutions

Tap the button
to generate a solution

SEE SOLUTION
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS