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 13A 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.
Copy the summary of all the companies’ ratios into a table of ratios into a Word document as the first section of a financial analysis of your companies. The table is required in the paper so the reader can see all of the ratios with the analysis.
Develop a 700-word evaluation of the selected companies in which the team does the following:
Format the assignment consistent with APA guidelines.
The following files must be submitted:
-Each person needs to personally submit their completed individual ratio worksheet
-One person needs to submit the final ratio summary sheet for the project
-One person needs to submit the final paper
Click the Assignment Files tab to submit your assignment.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more