Purchase Solution

Financial ratios to industry averages in an Excel Spreadsheet

Not what you're looking for?

Ask Custom Question

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

Attachments
Purchase this Solution
Solution Summary

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

Solution Preview

Please refer to the attached Excel file for formulas.

FINANCIAL RATIOS AND ANALYSIS

Industry Average: Company Company Formula

Operating ...

Solution provided by:
Elisa Valdez, PhD
Education
  • Bachelor of Science in Business Administration, University of the Philippines
  • Master in Business Administration, Saint Mary's University
  • Doctor of Philosophy in Education, University of the Philippines
  • Doctor in Business Adminstration (IP), Polytechnic University of the Philippines
Recent Feedback
  • "Excellent information thanks for the input"
  • "Thank you"
  • "Very thorough and informative. Thank you."
  • "Good response. Very detailed"
  • "This solution is excellent. Thank you"
Purchase this Solution
Free BrainMass Quizzes
Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Motivation

This tests some key elements of major motivation theories.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Operations Management

This quiz tests a student's knowledge about Operations Management

View More Free Quizzes
Related BrainMass Solutions

  • Key financial ratios: Corporate Finance

    the industry, and submit your Excel spreadsheet and explanation slides.

  • Intel's Financial Statement Analysis

    (b) I used industry averages or Texas Instrument ratios when an industry average was not available.

  • Leslie Fay Fraud; Auditing Case Study

    Name four (4) Balance Sheet and/or Income Statement accounts which are materially different (above or below) the industry averages. 8. Which two ratios should you consider when comparing them to the industry averages? 9.

  • Industry Averages for Commonly Used Ratios

    Place the industry averages, Disney ratios, and peer ratios on an excel spreadsheet. Identify and evaluate trends in all of the below ratios for the industry that Disney entertainment company is a part of.

  • Financial Ratio Calculation

    I listed the formula at the top of the spreadsheet, then used Excel to calculate them. Compare the company calculation values to the industry averages. o IC#1 - Operating margin is below industry average.

  • Financial Overview

    Perform a complete analysis of the company's financial statements-horizontal, vertical (percentage of sales abd common-size), and changes in ratios-for the last two years. Compare all ratios to industry averages.

  • Financial Accounting Ratios

    for Nederland and compare the firm's ratios with the industry averages below.

  • Brick Brewing Co. and Fort Garry Brewing Company Ltd.

    I have attached the excel spreadsheet, and the info is located on the bottom of the ratio sheet. I would like to seperate the analysis by; Profitibility, Activity (Efficiency), Liquidity, and Solvency- as in the excel spreadsheet.

  • Reeds Clothier

    Calculate a few ratios and compare Reed's results with industry averages. (Some industry averages are shown in Exhibit 4.) What do these ratios indicate?

View More Related Solutions