# week 3 team assignment

COMPLETE THE INFORMATION ABOVE THE LINES ONLY NOT THE ENTIRE ASSIGNMENT… CHECK ATTACHMENTS

Jennifer: Conclusion, second two questions (250 words)

• is the company more or less efficient in managing inventory and accounts receivable?
• Does profitability improve or decline over the four year period?

Part 2

• Jennifer: Intro & Evaluate the financial opportunity presented by the companies. If the team was going to lend money to one of the companies reviewed, which one would it be? Defend the team’s decision by identifying and discussing specific ratios that would be important to a creditor. (150 words)

——————————————————————————————————————————-———————————————————————————————————————————————————————————————————————————–

this entire assignment is not to be completed

Financial Statement Analysis and Decision Making Activity

Part I

This assignment requires the calculation of four years of ratios for Microsoft. An Excel work book with Microsoft financial information is attached. A trend analysis of the Microsoft ratios is required.

A second sheet in the workbook contains ratios for Apple, Oracle and Cicso. A comparison of the Microsoft current year ratios to these three companies is required to provide answers for the three questions below.

Complete the following:

Using the Microsoft financial statement information provided with the student materials, for the four years in the spreadsheet calculate the following ratios:

1. Current ratio

2. Current cash debt coverage ratio

3. Receivables Turnover ratio (assume all sales are credit sales)

4. Inventory Turnover ratio

5. Debt to Total Assets ratio

6. Times Interest Earned ratio

7. Return on common stockholders’ equity ratio

8. Return on assets ratio

9. Profit margin ratio

10. Price-Earnings ratio

A good approach to this section is to have each team member calculate one of the years so teams can compared calculations for accuracy. Appendix Chapter 13A starting on page 665 shows how to calculate all the ratios for the Chicago Cereal Company.

For the first section of the team paper, in approximately 500 words discuss the trends of the Microsoft ratios:

• Is liquidity stronger or weaker over the four year period?
• Is the company more or less solvent over the four year period?
• Is the company more or less efficient in managing inventory and accounts receivable?
• Does profitability improve or decline over the four year period?

Part II

A â€œratio summary sheetâ€ is included with the student materials where the ratios for Oracle, Apple and Cisco are entered. Enter the most current year Microsoft ratios into the column provided.

Copy the summary of all the companies’ ratios into a table of ratios into a Word document as the beginning of the second section of the team paper. The table is required in the paper so the reader can see all the ratios with the analysis.

Develop a 700 word evaluation of the four companies in which the team does the following:

• Evaluate the financial opportunity presented by the companies. If the team was going to lend money to one of the companies reviewed, which one would it be? Defend the team’s decision by identifying and discussing specific ratios that would be important to a creditor.
• Evaluate the investment opportunity presented by the companies. If the team could invest \$100,000 in one of the companies, which would the team select? Provide the rationale by identifying and discussing specific ratios that would be important for an investor.
• Evaluate the employment opportunity presented by the companies. If the team members could work for any of the companies, which company would the team select based on the company’s financial position? Defend the team’s decision by discussing the ratios as it relates to the overall financial position of the companies.
• Overall, which if the companies has the strongest financial position? Which of the companies has the weakest financial position? Refer to the ratios to support the team’s conclusions.

Format the assignment consistent with APA guidelines.

The following files must be submitted:

-The completed Excel worksheet with Microsoft ratios and the ratio summary sheet where the ratios for all four companies are shown.

-The final paper

In Blackboard, only one submission can be made. The team leader for this week needs to saved the final versions of these files to their computer and then upload them for the final submission.

Resources:

Center for Writing Excellence

Reference and Citation Generator

Grammar and Writing Guides

Learning Team Toolkit