Discussion Board 3
Identifying and prioritizing factors to include in an IFE Matrix fosters communication among functional and divisional managers.
Construct an IFE Matrix for Coca-Cola
graded
Overview
This exercise will give you experience in developing an IFE Matrix and using Financial Ratios. Identifying and prioritizing factors to include in an IFE Matrix fosters communication among functional and divisional managers. Preparing an IFE Matrix allows managers to articulate their concerns and thoughts regarding the business condition of the firm. This results in an improved collective understanding of the business.
Challenge
Prepare IFE and Financial Ratios for the Coca-Cola Company. For the Financial Ratios make sure to use the Coca-Cola revenue statement and balance sheet. There are additional resources found in Table 4-8, find as many Coca-Cola financial ratios as possible. Record your sources.
What strategies do you think would allow Coca-Cola to capitalize on its major strengths?
What strategies would allow Coca-Cola to improve on its major weaknesses?
TABLE 4-8 Excellent Websites to Obtain Strategic Information (Including Financial Ratios) on Companies and Industries
- Online Free Resources. a. Form 10K or Annual Report b. http://finance.yahoo.com c. http://www.hoovers.com d. http://globaledge.msu.edu/industries/ e. www.morningstar.com
- Online Subscription Resources (Likely Subscribed to by Your University Library)
a. Mergent Online: http://www.mergentonline.com At this website, financial statements seem to be more complete than at other sites. You can also search for companies with the same SIC or NAICS code and then create a comparison financial ratio report. A number of different ratios can be used as comparison criteria to create a tailored report that can then be exported into a Microsoft Excel format. Alternatively, use the Competi-tors Tab in Mergent to build a list of companies and compare their ratios. Your college library likely subscribes to this service.
b. Factiva: http://new.dowjones.com/products/factiva/ At this website, first use the Companies & Markets tab to search for a company. Next, click “Reports” and choose the “Ratio Comparison Report” to get a company’s ratios compared to industry averages. Your college library likely subscribes to this service.
c. S&P NetAdvantage: http://www.standardandpoors.com/products-services/industry_surveys/en/us This website provides company and industry ratios and information in two sections of the da-tabase: (1) the Compustat Excel Analytics section of a particular company’s information page and (2) the S&P Industry Surveys.
d. Onesource: http://www.avention.com/OneSource This is a widely used source for financial ratio information. Search for a particular company and then click on the link for “Ratio Comparisons” on the left side of the company information page. The data in Onesource will compare your company against the industry, against the sec-tor, and against the stock market as a whole.
e. Yahoo Industry Center: http://biz.yahoo.com/ic/ This is an excellent free resource that allows a user to browse industries by performance rank-ings, including return on equity, price-earnings ratio, market cap, price change, profit margin, price-to-book value, long-term debt, and more.
- Hardcopy Reference Books for Financial Ratios in Most Libraries a. Robert Morris Associate’s Annual Statement Studies: An excellent source of financial ratio information.
b. Dun & Bradstreet’s Industry Norms & Key Business Ratios: An excellent source of financial ratio information.
Answer preview Identifying and prioritizing factors to include in an IFE Matrix fosters communication among functional and divisional managers.
928 words