Question: Using an Excel spreadsheet, you will create a three-year ratio trend analysis from the financial statements data for Hershey corporation. Your spreadsheet must include actual

Using an Excel spreadsheet, you will create a three-year ratio trend analysis from the financial statements data for Hershey corporation. Your spreadsheet must include actual formulas that calculate the ratios. The trend will consist of the following ratios:

Current Ratio and the Quick Ratio from the “I. Short term solvency, or liquidity, ratios” category
Return on Assets Ratio and the Return on Equity Ratio from the “IV. Profitability ratios” category
Price Earnings Ratio and the Price Sales Ratio from the “V. Market value ratios” category.

Then provide a one-page (minimum) discussion about what each trend indicates for your assigned corporation. Is the trend good or bad, and why?

2) find the industry ratios for your corporation (you will also find the earnings growth rate here). Note that the ratios provided in investing.com for your selected corporation may not match your part (1) calculations exactly.

Compare your calculated ratios for your assigned corporation to the industry ratios. Then provide a one-page (minimum) discussion that details whether your assigned corporation is performing better or worse than the industry based on the definitions of the six ratios. Are your calculated trends from part (1) moving closer to or farther away from the industry averages? Is this good or bad?

Step by Step Solution

★★★★★

3.51 Rating (178 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Liquidity Current ratio 2022 102 2021 119 2020 101 Quick ratio 2022 1248 2021 3274 2020 1409 Profitability Return on asset 2022 1891 2021 1249 2020 1085 Return on equity 2022 175 2021 406 2020 217 Mar... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

The following data are adapted from the financial statements of Bettys Shops, Inc.: Total current assets . . . . . . . . . . . . $ 1,200,000 Accumulated depreciation . . . . . . . $ 2,400,000 Total...

Following are data from the financial statements for Drury Lane Company: Instructions: 1. Compute the following for 2010 and 2011. (a) Return on sales (b) Return on assets (c) Return on equity (d)...

Following are data from the financial statements for Shang Hi Company: Instructions: 1. Compute the following for 2007 and 2008. (a) Return on sales (b) Return on assets (c) Return on equity (d) Cash...

Obtain the 2002, 2003, 2004, 2005, and 2006 income statements for Wendy's International, Inc. The 20042006 statements are included in Wendy's 2006 annual report and Form 10-Ks. The 2002 and 2003...

You are a loan officer for Great Plains Bank of Davenport. David Miller, president of D. Miller Corporation, has just left your office. He is interested in an 8-year loan to expand the company??s...

Multiple-Choice questions: a. A companys current ratio is 2.2 to 1 and quick (acid-test) ratio is 1.0 to 1 at the beginning of the year. At the end of the year, the company has a current ratio of 2.5...

In an examination of Arenes Corporation as of December 31, 2012, you have learned that the following situations exist. No entries have been made in the accounting records for these items. 1. The...

Preparing pro forma financial statements (requires Appendix 6.1) Problem 27 presents financial statements for Target Corporation for its fiscal years ending January 31, 2006, 2007, and 2008, as well...

Ratio analysis Required Use the financial statements for Thorn Company from Problem 9-22 to calculate the following ratios for 2008 and 2007. a. Working capital b. Current ratio c. Quick ratio d....

Confirm that you can find the most recent financial statements for Starbucks Corporation (SBUX) using the following sources: a. From the companys Web page (www.starbucks.com). b. From the SEC Web...

We are evaluating a project that costs $ 5 0 0 , 0 0 0 , has a life of 8 years, and has no salvage value. Assume that depreciation is straight - line to zero over the life of the project. Sales are...

If your team gets together as a group to inform management that they need to be able to control the thermostat in the office to have a comfortable work environment, or else they will not be able to...

How are digital technologies changing family life? 2.) How are digital technologies changing the following social institutions: politics, education, the economy, and religion to make them better and...

Research and find any organization's Mission Statement. 1. Copy and paste the Mission Statement 2. What about the Mission Statement captured your attention? 3. Do you think the company is following...

a ) Write a few statements included in the code of ethics of your field that are related to the ethical problems in the collapse of the Surfside Condo.

Mulalo is the PR manager of Power Chain Stores. Which one of the following options is not related to Mulalo's PR activities? a. The planning and execution of the company's PR strategy should be...

can you answer all these questions please? please dont skip any question LATITUDE 3 Alt Chapter 5 Activity-Amortization Use a real estate company's search engine to identify a home you may be in near...

Recall that Chapter 8 described the binary search algorithm for finding a particular entry in an ordered list. The idea behind binary search is to begin looking in the exact center of the list. If...

On December 31, 2020, Dow Steel Corporation had 600,000 shares of common stock and 300,000 shares of 8%, noncumulative, nonconvertible preferred stock issued and outstanding. Dow issued a 4% common...

Excalibur Corporation sells video games for personal computers. The unadjusted trial balance as of December 31, 2021, appears below. December 31 is the company?s reporting year-end. The company uses...

How does the Model Business Corporation Act affect the way corporations operate?

Airfare prices were collected for a round trip from Los Angeles (LAX) to Salt Lake City (SLC). Airfare prices were also collected for a round trip from Los Angeles (LAX) to Barcelona, Spain (BCN)....

Nike ONE Black is one of the golf balls Nike, Inc., produces. It must meet the specifications of the United States Golf Association (USGA). The USGA mandates that the diameter of the ball shall not...

A recent article in The Washington Post Weekly Edition indicated that about 80% of the estimated $200 billion of federal housing subsidies consists of tax breaks (mainly deductions for mortgage...