Assignment
Part I
Complete the following:
Each learning team member will select one of the following companies:
Apple, Microsoft, Oracle, Cisco.
Each team member should post an original message with the name of their company as the subject line in the week 3 team forum. There will be a different thread for each company. For the selected company, each team member will locate the company's most recent SEC Form 10K. Post the link to the Form 10K in a message in the company's message string in the team forum.
Using the financial statements from the Form 10k, in an Excel worksheet, each team member will calculate the following ratios for their company for the most current year reported (I have provided a template for the Excel worksheet):
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
Appendix Chapter 13 A starting on page 665 shows how to calculate all of these ratios for the Chicago Cereal Company. Each team member is required to post a message in the string for their company with their spreadsheet for their company as an attachment. I have provided an Excel template for each team member to summarize the needed financial statement information and to calculate the ratios for the current year for their company. Please follow the instrucitons in the Excel template carefully. If you do not completely understand the instructions, ask questions. You need to complete your ratio spreadsheet as required or you will lose significant points on this assignment.
In a new message thread, the team should create a summary Excel Spreadsheet for the purpose of comparing the ratios of all of the companies. I have provided an Excel template for this summary sheet.
Each team member is responsible for inputting their ratios into the summary spreadsheet. All team members must review all of the calculations for all of the companies. The team has final responsibility for the accuracy of the ratio calculations.
As a team, highlight the company that has the best number/performance for each of the ratios.
Attachment:- Ratio-Sheet.rar