Provide ratios using fully calculated ratios in Excel.www.morningstar.com can be used to gather the information off of the balance sheet and income statement for HASBRO INC; symbol for this company is HAS. 5 years are needed.

Also provide analysis discussion of the ratio trends.

Ratio categories are to include:

Short term solvency AKA Liquidity

Long Term Solvency AKA Financial Leverage

Asset Management AKA Turnover

Profitability

Market Value

EXCEL must be used for all formulas and calculations of the ratios

There should be a ratio completed for each of the 5 years, for each of the ratios stated above. The analysis should describe what is going on for each ratio for each year.