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

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

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

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 2

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

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

View Full Document
Ask a homework question - tutors are online