Explore BrainMass
Share

Explore BrainMass

    Ratio analysis

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Prepare a four-column worksheet in Excel, column 1 to write the ratio names, column 2 to show the calculation of each ratio for Tootsie Roll Industries, column 3 to show the calculation of each ratio for The Hershey Company, and column 4 to include your DETAILED comments about each ratio and what the ratio tells you about each company under study. Calculate each of the following six ratios.

    Prepare a four-column worksheet in Excel, column 1 to write the ratio names, column 2 to show the calculation of each ratio for Tootsie Roll Industries, column 3 to show the calculation of each ratio for The Hershey Company, and column 4 to include your DETAILED comments about each ratio and what the ratio tells you about each company under study. Calculate each of the following six ratios. See Attachment

    For Year Ending December 31, 2007
    Tootsie Roll Industries & The Hershey Company Interpretation and comparison between the Ratios

    1.Receivable Turnover Ratio
    2.Average Collection Period
    3.Assets Turnover Ratio
    4.Return on Assets Ratio 
    5.Debt to Total Assets Ratio
    6.Times Interest Earned Ratio

    © BrainMass Inc. brainmass.com October 9, 2019, 11:56 pm ad1c9bdddf
    https://brainmass.com/economics/risk-analysis/ratio-analysis-273281

    Attachments

    Solution Summary

    The solution explains the calculation and analysis of ratios for Hershey and Tootsie

    $2.19