Hasbro Mattel 2019 Comparative Financial Analysis Preliminary Work Access the 2019 Hasbro Annual Report and calculate each of the ratios listed on the Study Guide for this topic Note base the Price Earnings ratio on current (2020) data at the time you complete the assignment not as of 12 31 2019 and indicate your source Note you will not need to calculate Earnings Per Share since this number is provided on the Income Statement (but doinclude EPS in your analysis) Your ratio calculations will not be submitted with this assignment Access the 2019 annual report for Hasbros major competitor, Mattel, Inc and repeat the steps above Assignment Submissions Provide a three column computer generated table summarizing your ratios for both Hasbro and Mattel Set this up with the headings Ratios, Hasbro and Mattel (from left to right, respectively) at the top of three columns and the list of ratios down the left column (in the same order as presented in the Study Guide) Provide a written analysis that compares the performance of Hasbro to Mattel for 2019 This should include a well reasoned analysis of each category of ratio (not necessarily each ratio separately) that can be supported by the data you have available Do not suggest conclusions that cannot be supported by the available data You may, however, raise questions that merit further examination You should identify the basic purpose for each category of ratio and your analysis should demonstrate an understanding of the purpose of the ratio and an understanding of the linkages that exist between the ratios and other financial concepts such as cash flow, risk and leverage Using data from the 2019 Hasbro Annual Report ( Item 6 Selected Financial Data page 33 of the Form 10 K), prepare a line chart with Excel that shows the trend of Net Revenues against the trend of reported Net Earnings ( attributable to Hasbro, Inc ) from 2015 through 2019 The chart should have a vertical scale on the left side for Net Revenues and a separate vertical scale (aka secondary axis) on the right side for Net Earnings The x axis and y axis of the chart should be properly labeled, there should be a legend for the two lines, and the chart should have an appropriate title (Hint you will need to enter five years of data (including the years) for Net Revenue and Net Earnings in your Excel spreadsheet and then use the Excel Chart Wizard to help you construct your chart )

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 01, 2024

Hasbro Mattel 2019 Comparative Financial Analysis Preliminary Work Access the 2019 Hasbro Annual Report and calculate each of the ratios listed on the Study Guide

Hasbro Mattel 2019 Comparative Financial Analysis

Preliminary Work

Access the 2019 Hasbro Annual Report and calculate each of the ratios listed on the Study Guide for this topic.
- Note: base the Price/Earnings ratio on current (2020) data at the time you complete the assignment not as of 12-31-2019 and indicate your source.
- Note: you will not need to calculate Earnings Per Share since this number is provided on the Income Statement (but doinclude EPS in your analysis).
- Your ratio calculations will not be submitted with this assignment.
Access the 2019 annual report for Hasbros major competitor, Mattel, Inc. and repeat the steps above.

Assignment Submissions

Provide a three-column computer-generated table summarizing your ratios for both Hasbro and Mattel. Set this up with the headings Ratios, Hasbro and Mattel (from left to right, respectively) at the top of three columns and the list of ratios down the left column (in the same order as presented in the Study Guide).
Provide a written analysis that compares the performance of Hasbro to Mattel for 2019. This should include a well-reasoned analysis of each category of ratio (not necessarily each ratio separately) that can be supported by the data you have available. Do not suggest conclusions that cannot be supported by the available data. You may, however, raise questions that merit further examination. You should identify the basic purpose for each category of ratio and your analysis should demonstrate an understanding of the purpose of the ratio and an understanding of the linkages that exist between the ratios and other financial concepts such as cash flow, risk and leverage.
Using data from the 2019 Hasbro Annual Report (Item 6. Selected Financial Data - page 33 of the Form 10-K), prepare a line chart with Excel that shows the trend of Net Revenues against the trend of reported Net Earnings (attributable to Hasbro, Inc.) from 2015 through 2019.

The chart should have a vertical scale on the left side for Net Revenues and a separate vertical scale (aka secondary axis) on the right side for Net Earnings.
The x-axis and y-axis of the chart should be properly labeled, there should be a legend for the two lines, and the chart should have an appropriate title.

(Hint: you will need to enter five years of data (including the years) for Net Revenue and Net Earnings in your Excel spreadsheet; and then use the Excel Chart Wizard to help you construct your chart.)