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

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
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
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