It Mgmt Wgu Fnt1 Task 1 Essay

898 Words Apr 4th, 2014 4 Pages
SUBDOMAIN 319.1 - ACCOUNTING & FINANCE
SUBDOMAIN 319.2 - INFORMATION TOOLS
Competency 319.1.2: Ratios - The graduate determines the financial condition of a firm using financial ratios and other financial data.
Competency 319.2.1: Technology Tools - The graduate uses information technology tools for specified business purposes.
Objectives:
319.1.2-04: Determine a firm’s financial condition by calculating and benchmarking specified ratios against other companies in the industry.
319.2.1-01: Use the Internet to gather information on a specified business topic.
319.2.1-02: Produce business letters or memorandums using a word processing application.
319.2.1-03: Develop a spreadsheet report that solves a business problem.
…show more content…
The industry ratios included on the template were generated from statements submitted by stores with annual sales between $10 million and $24 million.
As you develop your response, you should consider Company G trends by comparing Year 12 ratios to the same ratios for Year 11, consider what is depicted by the horizontal analysis, and benchmark Company G’s performance and condition by comparing Year 12 ratios with the same ratios for the home center industry.
Task:
A. Calculate each of the thirteen indicated ratios for Year 11 indicated in the attached “Statement Analysis Template.” Complete the attached spreadsheet with this information.
B. Complete a horizontal analysis of the income statements using the attached spreadsheet with this information.
Note: Round the percentages to the nearest hundredth of a percent, i.e. 6.84%. Answers like 6.80% or rounded up to 7% are not acceptable.
C. Complete a horizontal analysis of the balance sheets using the attached spreadsheet with this information.
Note: Round the percentages to the nearest hundredth of a percent, i.e. 6.84%. Answers like 6.80% or rounded up to 7% are not acceptable.
D. Write a business memorandum to the CEO of Company G (suggested length of 2–3

Related Documents