Using the Project Two Financial Formulas Spreadsheet spreadsheet and the balance sheet, income statement, and cash flow

[answerhappygod]

Using The Project Two Financial Formulas Spreadsheet Spreadsheet And The Balance Sheet Income Statement And Cash Flow 1 (110.02 KiB) Viewed 24 times

Using the Project Two Financial Formulas Spreadsheet spreadsheet and the balance sheet, income statement, and cash flow statement from Mergent Online for your chosen company, calculate the financial ratios for the most recent fiscal quarter. Then, compare those ratios with the same ratios for the same fiscal quarter from one year prior in Mergent Online, and analyze your results. Specifically, you must address the following rubric criteria: • Financial Calculations: Calculate accurate financial ratios to assess the business's current financial health. Specifically, calculate the following ratios: o Working capital • Current ratio o Debt ratio o Earnings per share • Price/earnings ratio • Total asset turnover ratio • Financial leverage Net profit margin o Return on assets • Return on equity • Fiscal Quarter Comparison: Using Mergent Online, summarize the differences between the results from your financial calculations of the most recent fiscal quarter and the results of the same financial calculations of the same fiscal quarter from a year before for your chosen business. • For example, if the most recent fiscal quarter available is the 3rd quarter in 2020, then you will compare those results to the same financial calculations from the 3rd quarter in 2019. ● Comparison Analysis: Explain what the results of your calculations and your comparison indicate about the business's current financial health, providing examples to support your explanation. You might consider the following questions: • Do the results indicate the business is financially healthy or financially unhealthy? Which results indicate this?
Business Summary Walt Disney is an entertainment company. Co.'s segments are: Disney Media and Entertainment Distribution (DMED) and Disney Parks, Experiences and Products (DPEP). DMED segment encompasses film and episodic television (TV) content production and distribution activities through its business lines: linear networks, such as domestic and international branded television channels; Direct-to- Consumer, such as subscription services that provide video streaming and digital content distribution services; and Content Sales/Licensing, such as TV/subscription video-on-demand, theatrical and home entertainment distribution. DPEP segment consist of theme parks and resorts and consumer products operations. Pricing Summary Time Period 1 week Disney (Walt) Co. (The) Price 111.5- 111.0- 110.5- 110.0- 109.5- 109.0- 108.5+ 05/29/2022 05/31/2022 Time 52 Week Range 185.91 Yesterday 110.87 8,819,792.00 Share price (minor) 05/27/2022 101.59 Close Volume 06/02/2022 5 Days 109.32 N/A 30 Days 116.19 11,479,729.00 Key Executives Susan Arnold Chairman Robert Chapek Chief Executive Officer Christine McCarthy Senior Executive Vice President, Chief Financial Officer Jolene Negre Associate General Counsel, Assistant Secretary Mary Barra Director Key Financials (In USD as of 04/02/2022) Income Statement Revenue 76,624m Net Income 2,651m EPS from Continuing Operations 1.48 EPS - Net Income - Diluted 1.46 Revenue per Share 42.05 Balance Sheet Total Assets 202,453m 111,817m Total Liabilities Shareholders' Equity 90,636m 113.67 Total Assets per Share Net Assets per Share Cash Flows 50.89 5,654m -3,868m Cash from Operations Cash from Investing Cash from Financing Capital Expenditures Cash Flow per Share -4,241m 4,108m 3.09 Age 67 Age 62 Age 66 Age 60 Salary 2,500,000 Salary 1,903,754
52 Week Range 101.59 Close Volume 52 Week High/Low: 185.91 101.59 % Price Change (100 Days): -23.99 200-Day Moving Avg. : 137.72 Company News Corporate Events 185.91 Yesterday 110.87 8,819,792.00 5 Days 109.32 N/A Disney (DIS) to Premiere Pinocchio Live-Action on Disney Plus Zack's Commentary Wed, 01 Jun 2022 1:38:15 PM EDT Walt Disney DIS recently announced that it would stream the live-action remake of the 1940 animated classic movie Pinocchio', exclusively on Disney Plus, on Sep 8. Disney also released the teaser trailer and the key art for the musical starring Tom Hanks as Geppetto, Cynthia Erivo as The Blue Fairy and Luke Evans as the Coachman. Directed by Robert Zemmenicks, the remake also stars Benjamin... The Walt Disney Company (DIS) Is a Trending Stock: Facts to Know Before Betting on It Zack's Commentary Mon, 30 May 2022 10:35:38 AM EDT Walt Disney (DIS) has been one of the most searched-for stocks on Zacks.com lately. So, you might want to look at some of the facts that could shape the stock's performance in the near term. Shares of this entertainment company have returned -2.1% over the past month versus the Zacks S&P 500 composite's -0.5% change. The Zacks Media Conglomerates industry, to which Disney belongs, has lost 2%... Top Research Reports for Johnson & Johnson, Walt Disney & NextEra Energy Zack's Commentary Wed, 25 May 2022 4:54:15 PM EDT 30 Days 116.19 11,479,729.00 Cash from Operations Cash from Investing Cash from Financing Capital Expenditures Cash Flow per Share 5,654m -3,868m -4,241m 4,108m 3.09
CURRENT RATIO (Current Assets / Current Liabilities) Current Assets Current Liabilities #DIV/0! WORKING CAPITAL (Current Assets - Current Liabilities) Current Assets Current Liabilities DEBT RATIO (Total Liabilities/Total Assets) Total Liabilities Total Assets #DIV/0! EARNINGS PER SHARE (Net Income / Weighted Average Common Shares Outstanding) Net Income Shares Outstanding #DIV/0! PRICE EARNINGS RATIO (Share Price (end of quarter / EPS) Stock Price un DATIO TOTAL ASSET TURNOVER RATIO (Total Revenue / Tota FINANCIAL LEVERAGE (Total Assets / Shareholder's I NET PROFIT MARGIN (Net Income / Total Revenu RETURN ON ASSETS (Net Income / Total Assets RETURN ON EQUITY (Net Income - Preferred Dividends/Share NI - Pref. Div. Total Revenue Total Assets Total Assets Shareholder's Equity Net Income Total Revenue Net Income Total Assets