Free Excel Student Template
Dear Student,
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.
INSTRUCTIONS FOR TEMPLATE
1
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.
INSTRUCTIONS FOR EXTERNAL AUDIT
<ONLY ENTER DATA IN THE LIGHT GREEN BOXES>
1.
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.
2.
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
3.
After entering in the weights, then enter in a corresponding rating in the “Enter Rating Below” column. The coding scheme is provided below.
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 Weight Below
Enter Rating Below
Enter Ten Opportunities Below
1.
International Labor
0.06
2
2.
Strong Economy
0.04
3
3.
Acquisition
0.03
1
EFE Matrix
4.
Reduced Foreign Manufacturing
0.02
4
5.
Electric Vehicles
0.05
3
6.
Autonomous Vehicles
0.05
3
7.
Domestic Investments
0.04
4
8.
Flex Fuels
0.02
2
9.
Government Investment
0.01
2
10.
Strong Reputation
0.03
2
Enter Ten Threats Below
Enter Weight Below
Enter Rating Below
1.
Ride Sharing
0.06
1
2.
Poor Economy
0.04
3
3.
Strong Competition
0.30
2
4.
Poor Reputation
0.05
2
5.
Leadership
0.03
3
6.
Technology Changes
0.04
3
7.
Carbon Footprint
0.03
1
8.
Foreign Financial Markets
0.02
2
9.
Changing Market Share
0.03
1
10.
Product Development
0.05
3
1.00
Instructions for Competitive Profile Matrix (CPM)
<ONLY ENTER DATA IN THE LIGHT GREEN BOXES>
1.
To perform the CPM, enter in twelve critical success factors. You may use some of the ones listed below if you like but try to use ones that are more pertinent to your company. For example, if your case is Delta Airlines, having a) on time arrival b) extra fees c) frequent flyer points, etc may be better choices than the canned ones below. For purposes of this Template, it is vital you have twelve factors no more, no less.
2.
After entering in twelve critical success factors, enter in the weight you want to assign each one. Be sure to check the bottom of the “Enter Weight Below” column, to make sure your sum weight is equal to 1.00
3.
After entering in your weights, type the name of your company and two other competitors in the corresponding boxes.
4.
After entering in the weights and identifying your company and two rival firms, then enter in a corresponding rating in the “Enter Rating Below” column for each organization. DO NOT ASSIGN THE COMPANIES THE SAME RATING, TAKE A STAND, MAKE A CHOICE. The coding scheme is provided below.
Enter Rating Below
Enter Rating Below
Enter Rating Below
CPM Matrix
Enter Weight Below
General Motors
Ford
Fiat/Chrysler
Advertising
0.07
1
3
4
Added Product Features
0.05
4
2
1
Customer Service
0.08
3
3
4
Store Locations
0.03
3
4
3
Variety of Products
0.07
3
2
4
Skilled Workforce
0.13
4
4
1
Brand Recognition
0.09
4
3
4
Customer Loyalty
0.07
2
3
2
Market Share
0.12
4
3
1
Product Quality
0.17
4
3
3
Global Expansion
0.06
2
2
3
Price Competitiveness
0.06
3
2
3
1.00
1 = “major weaknesses”
2 = “minor weaknesses”
3 = “minor strength”
4 = “major strength”
INSTRUCTIONS FOR INTERNAL AUDIT
<ONLY ENTER DATA IN THE LIGHT GREEN BOXES>
1.
To perform an Internal Audit, enter in ten strengths and ten weaknesses For purposes of this Template, it is vital you have ten of each, no more, no less.
2.
After entering in ten strengths and ten weaknesses scroll down the page and enter in the weight you want to assign each one. Be sure to check the bottom of the “Enter Weight Below” column, to make sure your sum weight is equal to 1.00
3.
After entering in the weights, then enter in a corresponding rating in the “Enter Rating Below” column. The coding scheme is provided below. Reminder weaknesses must be 1 or 2 and strengths must be 3 or 4
1 = “major weaknesses”
2 = “minor weaknesses”
3 = “minor strength”
4 = “major strength”
Enter Weight Below
Enter Rating Below
Enter Ten Strengths Below
1.
2.
3.
4.
5.
6.
7.
8.
IFE Matrix
9.
10.
Enter Ten Weaknesses Below
Enter Weight Below
Enter Rating Below
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
0.00
INSTRUCTIONS FOR COMPANY WORTH
<ONLY ENTER DATA IN THE LIGHT GREEN BOXES>
1.
To perform the company worth, enter in corresponding financial information you are prompted for in the boxes to the right and press enter. Everything is calculated automatically and posted into the matrix.
2.
Hints are provided below on where to find any particular information. If you wish to enter data for a competitor or a company you plan to acquire, scroll over. If acquiring a competitor, this value would constitute a large portion of your “amount needed” in the EPS/EBIT Analysis.
Top competitor or who you wish to acquire.
Stockholders’ Equity
Net Income
Stockholders’ Equity
Net Income
Stockholders’ Equity – Can be found near bottom of Balance Sheet. It might be called total equity.
Net Income – Can be found on the Income Statement. It might be called net earnings or net profits.
Share Price – Can be found on Yahoo Finance.
EPS – Can be found on Yahoo Finance.
Shares Outstanding – www.money.msn.com.
Company Worth
Share Price
EPS
Share Price
EPS
Shares Outstanding
Shares Outstanding
INSTRUCTIONS FOR SWOT
1
Click on the SWOT Hyperlink to the right and add your SO,WO,ST, and WT Strategies.
Click Here to View SWOT
INSTRUCTIONS FOR BCG and IE Matrix
<ONLY ENTER DATA IN THE LIGHT GREEN BOXES>
1.
The Template allows for a two, three, or a four division company. (If the company has more than 4 divisions, combine the divisions with the least amount of revenue and mention the adjustment to the class during your presentation.) <You will have to read the Annual Report to find this information> It is quite okay to do a BCG/IE for BOTH geographic and by product revenues/profits. To develop BCG and IE matrices, Step 1: enter in the corresponding profits you are prompted for in the boxes (for the corresponding divisions) below. Also, change the division name to match your case (The 2 division example is for domestic and international.) Pie slices are automatically calculated and labeled. In the example profits were 500 million and 800 million. Do not put a M or B to signal million or billion. If you can not find profit information, estimate this and explain to the class during your presentation. At a bare minimum, have the appropriately sized circles (even if you do not use pie slices). However, an educated profit estimation is more prudent if divisional profits are not reported.
BCG Matrix
2.
After finishing Step 1, click on the BCG hyperlink to the right (Step 2, once there click on the pie slices. Here you can adjust the size of the circles (which represent revenues). Move the “pies” into the quadrant you desire. Don’t worry about the “light green warning” when adjusting the pies.
classassignmenthelp.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we\’ll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Why Hire classassignmenthelp.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
The purpose of this assignment is to demonstrate your knowledge of mental and emotional wellness and how to support these skills in children as an early childhood educator. Understanding Learning as the Core Business of School 1. What would/does making learning the core business of school? look like in your school or district? What would need
All Rights Reserved Terms and Conditions
College pals.com Privacy Policy 2010-2018