View the step-by-step solution to:

# Free Excel Student Template Dear Student, By using this Template, you hereby agree to the Copyright terms and conditions. This Template should save...

Please answer all questions according to case analysis guidelines on Microsoft Word Document. Let me know if you have any questions. Thank You!

Free Excel Student Template Dear Student, INSTRUCTIONS FOR TEMPLATE 1 INSTRUCTIONS FOR EXTERNAL AUDIT <ONLY ENTER DATA IN THE LIGHT GREEN BOXES> 1. 2. 3. 1 = "company's response to the external factor is poor" 2 = "company's response to the external factor is average" 3 = "company's response to the external factor is above average" 4 = "company's response to the external factor is superior" Enter Ten Opportunities Below 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. Enter Ten Threats Below 1. 2. 3. 4. 5. 6. 7. 8. By using this Template, you hereby agree to the Copyright terms and conditions. This Template should save you considerable time and allow for your presentation to be more professional. Do not mistake this Template for doing all of the work. Your assignment is to analyze and present strategies for the next three years. You will still need to do the research and enter key internal and external information into the Template. The Template does not gather or prioritize information. It does however assimilate information you enter in a professional way and does many calculations for you once that critical information is entered. Best of luck, with your project. Please read all Template instructions below carefully before you start each new section of this Template. Only type in the green boxes unless otherwise noted. Please read the Read ME tab at the bottom of Excel before you start. To perform an External Audit, enter ten opportunities and ten threats. For purposes of this Template, it is vital you have ten of each, no more, no less. After entering ten opportunities and ten threats, enter the weight you want to assign to each factor. Be sure to check the bottom of the "Enter Weight Below" column, to make sure your entire column sums is equal to 1.00 After entering in the weights, then enter in a corresponding rating in the "Enter Rating Below" column. The coding scheme is provided below. Enter Weight Below Enter Rating Below EFE Matrix Enter Weight Below Enter Rating Below
Show entire document
Individual Case Analysis Guidelines Read the assigned case and prepare answers to ALL of the following: 1. What is the company’s major problem (e.g., what decision must be made? what choice must be faced?)? Justify why you believe this is the major problem (e.g., what are some of the symptoms that you believe attribute to the major problem) 2. What is the company’s current overall objective(s)? 3. What are the current strategies to help the organization achieve its current objective(s)? 4. Using the company’s mission statement, identify which components were utilized 5. Create your “improved” mission statement utilizing all components and identify each component in your “improved” mission statement 6. How attractive is the industry (e.g., size, growth rate, profitability, competitive intensity, Porter’s 5 forces) to companies currently in the industry? And to companies who would like to enter the industry? (FYI. When you finish answering this question, you should know: 1) if you are considering entering in this industry, do you want to enter in to this industry or 2) if you are currently in this industry, do you want to stay in this industry.) 7. Conduct a Situation/SWOT Analysis (internal and industry analyses) a. Conduct an industry analysis (external audit) i. What are the company’s external opportunities and threats? ii. Develop an External Factor Evaluation (EFE) Matrix, explain what the company needs to improve on externally, and justify why it needs to be improved iii. Identify the company’s major competitors, develop a Competitive Profile Matrix (CPM), explain what the company needs to improve on competitively, and justify why it needs to be improved b. Conduct internal analysis i. What are the company’s internal strengths and weaknesses? ii. Develop an Internal Factor Evaluation (IFE) Matrix, explain what the company needs to improve on internally, and justify why it needs to be improved c. Given the IFE, EFE, and CPM, is the company stronger internally, externally, competitively, or some/all? d. Conduct a financial ratio analysis on the company. Calculate the ratios shown in the table below and compare them with the industry. Based on your comparison, is Microsoft a healthy company performing well on financial ratios? Profit Margin Percent Microsoft Industry Gross Margin ? 75.58 Pre-Tax Margin ? 35.06 Net Profit Margin ? 28.28 Liquidity Ratios Debt/Equity Ratio ? 0.24 Current Ratio ? 2.77 Quick Ratio ? 2.58
Show entire document
Show entire document

Name
Institution 2
Introduction
Microsoft is the world leading and largest software company with its...

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents