Explore BrainMass
Share

Explore BrainMass

    Financial ratios to industry averages in an Excel Spreadsheet

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

    1) Examine the company's financial statements, Compare key financial ratios of the company to industry averages, and submit your Excel spreadsheet

    2)The CEO believes that the company should be outperforming industry averages in many of the key metrics. Please provide an analysis and explanation of their meaning and significance in a separate document in at least 150 words.

    The key financial ratios are listed as follows. Analyze the ratios for the company as you view information from key company reports and provide your analysis and explanation on a separate document.

    Key Financial Ratios
    operating margin
    total asset turnover
    current ratio
    interest coverage ratio
    price to earnings ratio
    earnings per share
    return on equity

    Company's financial statement is attached.
    Please include references except from Wikipedia

    © BrainMass Inc. brainmass.com October 10, 2019, 3:54 am ad1c9bdddf
    https://brainmass.com/business/business-management/financial-ratios-industry-averages-excel-spreadsheet-441097

    Attachments

    Solution Preview

    Please refer to the attached Excel file for formulas.

    FINANCIAL RATIOS AND ANALYSIS

    Industry Average: Company Company Formula

    Operating ...

    Solution Summary

    Financial ratios to industry averages in an Excel Spreadsheets are examined.

    $2.19