Please check the attachments for the problems Review the rubric to make sure you understand the criteria for earning your grade.Download the Excel file, Assignment 2.4 Worksheet and Assignment 2.5 Wor

Please check the attachments for the problems

  1. Review the rubric to make sure you understand the criteria for earning your grade.
  2. Download the Excel file, Assignment 2.4 Worksheet and Assignment 2.5 Worksheet.
  1. Using the Assignment 2.4 Worksheet file, complete all seven of the following problems:
    1. Calculating Ratios: Problems 1 through 6.
    2. Standardized Financial Statements: Problem 7, preparing common-size balance sheets and common-base year balance sheets for Just Dew It Inc.
  2. When you have completed your assignment, save a copy for yourself and submit a copy to your instructor by the end of the workshop.

Using the Assignment 2.5 Worksheet file, complete the requirements of the Mini-case “Ratio Analysis at S&S Air, Inc.” 

  1. Question #1: Use an Excel spreadsheet to calculate each of the ratios listed in the table.  Be sure to show your work.
  2. Question #2:  Briefly comment in your Excel spreadsheet on the appropriateness of Boeing and the other competitors as an aspirant company for comparison.
  3. Question #3: In your Excel spreadsheet, compare each calculated ratio to the industry ratios given in the table.  Briefly explain whether the calculated ratio would be viewed positively or negatively relative to the industry and why.  Note it is not enough to simply say whether a particular ratio is higher or lower than the industry.  You need to interpret whether the ratio would be viewed favorably or unfavorably, demonstrating your understanding of each ratio.

Show more