Details of this Paper

Assignment: You are the assistant to the CEO of...




Assignment: You are the assistant to the CEO of a major company. Your CEO keeps an eye on the competition, and asks you to do the following. Using ratio analysis, compare two major competitors in the same industry. Instructions: ? The two companies that I chose Apple and Microsoft ? Select the 10 most important financial ratios for your two companies and calculate each for the last 2 fiscal years using Excel. Please see attached assignment format Excel you should use this format to provide the answers. 1. Create a single Excel file for your entire assignment. 2. You may obtain financial information and the companies' latest annual reports on the web directly from MSN Money or Yahoo Finance. For additional information, look for the SEC Form10-K link from one of the MSN Money or Yahoo Finance financial sites. 3. You should calculate, and comment upon, all 10 financial ratios for the last 2 fiscal years. 4. All calculations should be shown, and all answers should be thoroughly explained. 5. It is useful to compare financial ratios for a company with financial ratios of its industry. Industry financial ratios can be found on, Yahoo Finance and MSN Money 6. Whenever you use balance sheet items to calculate ratios, for each year be sure to average the beginning-of-year and end-of-year amounts to get the average for that year. 7. What can you tell from your analysis? What are the strengths and weaknesses of each company? Which is the stronger competitor? Give your reasons. You already have information about this company from your previous answers. Can you please complete the assignment by the due date? Thanks!!! Please use attached file to provide answers,Thanks a lot!!!,Great! Thanks,Dear Tutor, The assignment that you did is not corrected. When I submited the assignment I also attached the excel format template for you to use. The question for this assignment asked to compare Microsoft and Apple companies. Please read the instruction 1 through 7 again and open the attached file that I attached earlier. Thanks,,Please show the formula in excell worksheet when you calculate each companies ratio.Please refer to the template that I attached early!! Thanks,,Dear Tutor, I gave you enough time to complete the assignment for tomorrow noon but you said you asnwered the questions. But its incomplete. To me you didnt follow the assignment instruction throughly. IT'S asking you to compare the ratio between Microsoft and Apple comanies. Please re-do the assignment. Please read the instruction again 1 through 7 pluse the excel attachment that I sent you. you need to follow the excel and calculate the ratiosand show the formulas in excel worksheet how you get the answeres. All you did was copy and paste income sttement worksheet and Balanance worksheet for both companies from yahoo finance and placed it into excel file. This is not how you supoosed to complete the assignment. I didnt accept the answers that you provided because its incomplete. It's not fair to charge me for incomplete assignment. You need to read the instrucation throughly. Thanks,,Thanks a lot for understanding..please let me know when you are going be done..,Thanks a lot!!! This is correct!!,Dear Tutor, Thanks for your help and great support!!! You did provide a great service and I really apprciate it. Regards,,Dear Tutor, I have one question, Im reviewing your answers but I didn't understand how you got industry average for Microsoft & Apple bc you didn't provide a formula for yout answers. Can you please provide a formula how you calculated the answer.. Please provide me explanation thx.. Thanks,,Hi Tutor, Thanks,but can you please provide me your answer soon? Thanks, Hirut,Okay, Thanks,,Dear Tutor, Thanks for clarifying!!!! Regards,


Paper#2428 | Written in 18-Jul-2015

Price : $25