Choose one of the following as the category of industry in which Holyard does business:

  • Manufacturing
  • Service
  • Transportation
  • Technology
  • Legal services
  • Automotive
  • Or one approved by your instructor

Use the information in the Holyard Industry Microsoft® Excel® sheet to evaluate how the various ratios and variances relate to the financial statement. Solve for (calculate) the unknown information required to complete the financial statements.

Reconstruct the Holyard Industry balance sheet and income statement using the information given in the spreadsheet. 

Measure the efficiency of the organization by comparing the ratios for the company with a major competitor and the industry. 

Write your response in a 700- to 1,050-word paper.