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!

Background image of page 01
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
Background image of page 02
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
Background image of page 1
Profitability Ratios Return On Equity ? 28.41 Return On Assets ? 15.7 Return On Capital ? 22.77 Efficiency Ratios Income/Employee ? 123,791 Revenue/Employee ? 470,524 Receivable Turnover ? 6.27 Inventory Turnover ? 12.75 Asset Turnover ? 0.56 8. Develop two of the five matrices for the company: SWOT Matrix, SPACE Matrix, IE Matrix, and Grand Strategy Matrix. Highlighting each of your strategies listed 9. Utilizing the strategies developed from your matrices, develop a QSPM AND explain your recommendations/findings for the company’s problem. Then, provide justifications of your recommendation [In your explanation, please demonstrate how this/those strategy(ies) will rectify the major problem that you identified and explain why should they use that/those strategy(ies)?] . APA and Specifics You should properly cite your work and use APA style citations. If you are not familiar with plagiarism or APA, make sure to watch the videos available on Blackboard under “course info”. Use headings, bold font, and white space where appropriate to make your brief easy to follow. Please use 12-point font and one-inch margins. Cover pages are necessary. Please proofread carefully.
Background image of page 2
Show entire document
Background image of page 1
Background image of page 2
Show entire document
Sign up to view the entire interaction

Top Answer

After working on your question, I... View the full answer

9218159.docx

Running head: BUSINESS ANALYSIS Business Analysis
Name
Institution 2
BUSINESS ANALYSIS
Business Analysis
Introduction
Microsoft is the world leading and largest software company with its...

Sign up to view the full answer

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
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online