• The balance sheet, income statement, and cash flow statement from the most recent fiscal quarter (from Mergent Online)
• The Ratios Most Recent Fiscal Qtr which will be July 1,2023 and July 1, 2022 worksheet in the Project Two Financial Formulas workbook.
  • For example, if the most recent fiscal quarter available is the third quarter in 2022, youll compare those results to the same financial calculations from the third quarter in 2021.

Use the documents to calculate key financial ratios.

Then open the following documents:

• The balance sheet, income statement, and cash flow statement from the same fiscal quarter one year ago
• The Ratios Same Fiscal Qtr 1 Year Ago worksheet

Use the documents to calculate the same financial ratios. Finally, compare those ratios and analyze your results.

Specifically, you must address the following rubric criteria:

1. Financial Calculations. Calculate accurate financial formulas to assess the businesss current financial health. Specifically, calculate the following formulas using the Ratios Most Recent Fiscal Qtr and the Ratios Same Fiscal Qtr 1 Year Ago worksheets in the Project Two Financial Formulas workbook: Please add the actual figures in the below ratios worksheet
   1. Working capital
   2. Current ratio
   3. Debt ratio
   4. Earnings per share
   5. Price/earnings ratio
   6. Total asset turnover ratio
   7. Financial leverage
   8. Net profit margin
   9. Return on assets
   10. Return on equity
2. Fiscal Quarter Comparison. Summarize the differences between the following:
   1. The results from your financial calculations of the most recent fiscal quarter
   2. The results of the same financial calculations of the same fiscal quarter from one year ago
      1. For example, if the most recent fiscal quarter available is the third quarter in 2022, youll compare those results to the same financial calculations from the third quarter in 2021.
3. Comparison Analysis. Explain what your calculations and comparison show about the businesss current financial health. Give examples to support your explanation for the following questions:
   1. Do the results show the business is financially healthy or unhealthy? Which results indicate this?
   2. What might be the causes of the businesss financial success or failure?
   3. Is more information needed to determine the businesss financial health? If so, which pieces of information might still be needed?
4. Short-Term Financing. Explain how potential short-term financing sources could help the business raise funds needed to improve its financial health. Base your response on the businesss current financial information.

\begin{tabular}{|c|c|c|} \hline & & \\ \hline= & & \\ \hline=5 & 7 & \\ \hline= & & E \\ \hline & = & \\ \hline \end{tabular} Disney (Walt) Co. (The) (NYS: DIS) Disney (Walt) Co. (The) (NYS: DIS) \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|l|}{ Exchange rate used is that of the Year End reported date } \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \multicolumn{7}{|l|}{ As Reported Quarterly Balance Sheet } \\ \hline \multirow[t]{2}{*}{ Report Date } & 07/01/2023 & 04/01/2023 & 12/31/2022 & 07/02/2022 & 04/02/2022 & 01/01/2022 \\ \hline & 3rd Quarter & 2nd Quarter & 1st Quarter & 3rd Quarter & 2nd Quarter & 1st Quarter \\ \hline Currency & USD & USD & USD & USD & USD & USD \\ \hline Audit Status & Unaudited & Unaudited & Unaudited & Unaudited & Unaudited & Unaudited \\ \hline Consolidated & Yes & Yes & Yes & Yes & Yes & Yes \\ \hline Scale & Millions & Millions & Millions & Millions & Millions & Millions \\ \hline Cash \& cash equivalents & 11458 & 10399 & 8470 & 12959 & 13272 & 14444 \\ \hline Receivables, net & 13112 & 12770 & 13993 & 13685 & 13746 & 14882 \\ \hline Inventories & 1900 & 1848 & 1830 & 1590 & 1428 & 1345 \\ \hline Content advances & 2369 & 1872 & 1300 & 1902 & 1796 & 1125 \\ \hline Licensed content costs \& advances & - & - & - & - & - & - \\ \hline Other current assets & 1335 & 1374 & 1319 & 1286 & 1185 & 1117 \\ \hline Total current assets & 30174 & 28263 & 26912 & 31422 & 31427 & 32913 \\ \hline Produced \& licensed content costs & 34607 & 36949 & 36266 & 34077 & 32349 & 30669 \\ \hline Investments & 3062 & 3387 & 3169 & 3236 & 3356 & 3549 \\ \hline Parks, resorts \& other property - attractions, buildings \& equif & 69819 & 69695 & 68253 & 65599 & 65247 & 65257 \\ \hline Parks, resorts \& other property - accumulated depreciation - a & 42112 & 41452 & 40641 & 39089 & 38783 & 38505 \\ \hline Parks, resorts \& other property before projects in progress \& I & 27707 & 28243 & 27612 & 26510 & 26464 & 26752 \\ \hline Parks, resorts \& other property - projects in progress & 5689 & 5175 & 5430 & 5956 & 5327 & 4808 \\ \hline Parks, resorts \& other property - land & 1181 & 1161 & 1158 & 1117 & 1126 & 1121 \\ \hline Parks, resorts \& other property, net & 34577 & 34579 & 34200 & 33583 & 32917 & 32681 \\ \hline Intangible assets, net & 13478 & 13887 & 14347 & 15334 & 15875 & 16574 \\ \hline Goodwill & 77881 & 77878 & 77867 & 77945 & 78019 & 78052 \\ \hline Other assets & 10004 & 9915 & 9363 & 8477 & 8510 & 8873 \\ \hline Total assets & 203783 & 204858 & 202124 & 204074 & 202453 & 203311 \\ \hline Accounts payable \& other accrued liabilities & 19115 & 18591 & 18149 & 20858 & 19669 & 18709 \\ \hline Current portion of borrowings & 2645 & 3452 & 3249 & 5580 & 5399 & 6783 \\ \hline Deferred revenue \& other current liabilities & 6474 & 6013 & 5672 & 4266 & 4533 & 4545 \\ \hline Total current liabilities & 28234 & 28056 & 27070 & 30704 & 29601 & 30037 \\ \hline Borrowings & 44544 & 45066 & 45128 & 46022 & 46624 & 47349 \\ \hline Deferred income taxes & 7304 & 8134 & 8236 & 8034 & 8407 & 8124 \\ \hline Other long-term liabilities & 12759 & 13232 & 12812 & 13456 & 13808 & 14208 \\ \hline Redeemable noncontrolling interests & 8886 & 8814 & 8743 & 9425 & 9354 & 9283 \\ \hline Common stock & 57136 & 56919 & 56579 & 56087 & 55823 & 55500 \\ \hline Retained earnings (accumulated deficit) & 45794 & 46236 & 44955 & 43462 & 42032 & 41547 \\ \hline Market value adjustments for hedges & 11 & 1 & 83 & 396 & - & -60 \\ \hline Market value adjustments & - & - & - & - & -32 & - \\ \hline Unrecognized pension \& postretirement medical expense & -2811 & -2812 & -2868 & -4979 & -5098 & -5217 \\ \hline Foreign currency translation \& other accumulated comprehens & -1613 & -1578 & -1693 & -1559 & -1182 & -999 \\ \hline Accumulated other comprehensive income (loss) & -4413 & -4389 & -4478 & -6142 & -6312 & -6276 \\ \hline Treasury stock, at cost & 907 & 907 & 907 & 907 & 907 & 907 \\ \hline Total Disney (Walt) Co. shareholders' equity & 97610 & 97859 & 96149 & 92500 & 90636 & 89864 \\ \hline Noncontrolling interests & 4446 & 3697 & 3986 & 3933 & 4023 & 4446 \\ \hline Total equity & 102056 & 101556 & 100135 & 96433 & 94659 & 94310 \\ \hline \end{tabular}