project 2 - Prepare a four-column worksheet in Excel,...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Tootsie Roll Industries The Hershey Company Ratios Ratio Receivable Turnover Ratio Average Collection Period Assets Turnover Ratio Debt to Total Assets Ratio 3,623,593/4,247,113=0.85 Times Interest Earned Ratio 458,827/118,585=3.87 The ratios are calculated using the following Receivable turnover ratio = Sales/Average receivables Average collection period = Ending receivables/(Sales/365) Assets Turnover Ratio = Sales/Average assets Return on Assets = Net Income/Average assets Debt to Total Assets = Total Liabilities/Total Assets Times interest earned = EBIT/Interest All figures taken for 2007 years from 10-K Prepare a four-column worksheet in Excel, column 1 to write the ratio names, column 2 show the calculation of each ratio for The Hershey Company, and column 4 to include about each company under study. Calculate each of the following six ratios. 497,717/ ((32,371+35,075)/2)=14.76 4,946,716/ ((487,285+522,673)/2)=9.80 32,371/(497,717/365)=23.74 days 487,285/ (4,946,716/365)=35.95 days
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/28/2011 for the course GM 591 taught by Professor Jimlot during the Spring '09 term at Keller Graduate School of Management.

Page1 / 2

project 2 - Prepare a four-column worksheet in Excel,...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online