please type
lanitgmzlian71
JWI531AssignmentWorkbook12022.xlsxAssignment 1
| SAMPLE Salesforce.com | ||||||
| Risk Ranking (pg. 26) | Risk Name (10-K Annual Report, Other) | Description of the risk | Risk Profile (Pg. 28) | Severity Scoring (pg 28) | Mitigation Planning (Pg 30) | |
| 1 - highest severity/frequency (on the list on my table) | License Renewals | Forecasts of revenue are based on customers renewing their software license contracts. If price increases, customer service drops, or competition increases, then renewals and revenue will decrease. | Financial Risk. Could also be partly operational, strategic, industry, or brand | 3 - concerning to stakeholders | Take internal actions to mitigate the risk. This risk cannot be accepted or transferred. Internal actions include enuring that our pricing reflects market competition and customer expectations, that our products are meeting requirements, that our customer service is providing the highest level support, that we identify clients that are at risk of not renewing and actions are taken. | |
| INTEL | ||||||
| Risk Ranking (pg. 26) | Risk Name (10-K Annual Report, Other) | Description of the risk | Risk Profile (Pg. 28) | Severity Scoring (pg 28) | Mitigation Planning (Pg 30) | |
| 3-Normal Activity | Intel face significant competition | The industry in which we operate is highly competitive and subject to rapid technological and market developments, changes in industry standards, changes in customer needs, and frequent product introductions and improvements. If we do not anticipate and respond to these developments, our competitive position may weaken, and our products or technologies might be uncompetitive or become obsolete | Industry Risk. Includes factors that can alter the competitive profile of the industry , such as changes in the entire size of the market that the industry serves, the rate at which the industry is consolidating , and the ability of new competitors to enter the market. | 5- Potentially business threatening | Transfer the risk. I believe that this risk would be acceptable because it will cover the lost profits from business interuptions. | |
| 3- Normal Activity | Investments in new businesses, products, and technologies are inherently risky and may not succeed | An economic downturn or increased uncertainty may also lead to increased credit and collectibility risks, higher borrowing costs or limits on our access to capital markets, reduced liquidity, adverse impacts on our suppliers, failures of counterparties and other financial institutions, and declines in the value of our financial instruments | Financial Includes the risks of customer nonpayment , foreign exchange rate variability and capital availability concerns. | 4- Major Disruption | Transfer the risk. I believe that this risk would be acceptable because it will cover the lost profits from business interuptions. | |
| 2- Modest Activity | Global or regional conditions may harm our financial results | Adverse changes in global or regional economic conditions, including recession or slowing growth, changes or uncertainty in fiscal or monetary policy, higher interest rates, tighter credit, inflation, lower capital expenditures by businesses including on IT infrastructure, increases in unemployment, and lower consumer confidence and spending, could significantly harm demand for our products and make it more challenging to forecast our operating results and make business decisions, including regarding prioritization of investments in our business. A | Environmental . Includes -Fines and remediation costs related to pollutions, as well as damage to the environment. Catastrophic . Primarily includes natural disasters , such as hurricanes, earthquakes , tornadoes, and floods. | 5- Potentially business threatening | Transfer the risk. I believe that this risk would be acceptable because it will cover the lost profits from business interuptions. | |
| AMD | ||||||
| Risk Ranking (pg. 26) | Risk Name (10-K Annual Report, Other) | Description of the risk | Risk Profile (Pg. 28) | Severity Scoring (pg 28) | Mitigation Planning (Pg 30) | |
| 5-Normal Activity | The loss of a significant customer may have a material adverse effect on us | If one of our key customers decides to stop buying our products, or if one of these customers materially reduces or reorganizes its operations or its demand for our products, our business would be materially adversely affected. | Brand-Includes issues that can cause the perception of a company's brand to decline , such as a product recall, marketing flop, bad publicity, negative product reviews, and public squabbles with business partners. | 5-Potentially Business Threatening | To accept the Risk- The likely payout from a risk may be so small that the company can easily bear the risk of loss. | |
| 4- High Activity | Global economic and market uncertainty may adversely impact our business and operating results | Uncertain global economic conditions have in the past and may in the future adversely impact our business, including, without limitation, a slowdown in the Chinese economy, one of the largest global markets for desktop and notebook PCs | Environmental- Includes fines and remediation costs related to pollution, as well as damage to the environment. | 4- Major Disruption | To accept the risk- Since global economic conditions happen quarterly the risk may be so small that the risk is low | |
| 4- High Activity | Our operating results are subject to quarterly and seasonal sales patterns. | The products that we sell are complex and may be subject to security vulnerabilities that could result in, among other things, the loss, corruption, theft or misuse of confidential data or system performance issues. | Information technology- Includes factors that do not allow an organization to have responsive IT systems, such as being tied to legacy software and having a significant amount of systems. | 2-Material Impact | Transfer the risk to Cyber Risk Insurance - Also known as network security liablity insurance, which is considered by CFO and also covers asset information. | |
&"Calibri Bold,Bold"&14&K000000&A
&"Calibri,Regular"&K000000&D &"Calibri,Regular"&K000000&F &"Calibri,Regular"&K000000&P
Instructions 1. The purpose of this template is to gather data that will be analyzed and discussed in the Assignment Part B submission. Insert the name of the company in the "Company 1 or Company 2" headings so we know which company is being reviewed. 2. The template uses the terminology in the CFO Guidebook chapter on Risks. 3. Risks of the company are disclosed in the annual 10-K report section Item 1A Risk Factors. Use the risks in the 10-K as your basis for your template. You can also get additional risks from the Morningstar Analyst Report, or from news articles about the company. Try to narrow down the laundry list of risks to a few unique (only applies to one company but not the other) and major risks. 4. There is no "magic" number of risks to be included in your template. Try to aim for 3-5 risks per company to compare and analyze. More is not better - quality over quantity. 5. You can delete extra rows, or add rows. You can also change the font size and the column widths. Keep the headings standard. While not a requirement, if you believe an additional column is required to better describe/classify your risks, then add it. 6. While not a requirement, you can copy/paste the Excel completed table as a picture to your Word document if it makes it easier to reference in your analysis and recommendations.
Assignment 2
| Company 1 INSERT COMPANY NAME HERE | Company 2 INSERT COMPANY NAME HERE | |||||||
| Morningstar Analyst Report | 2018 | 2017 | 2016 | 2018 | 2017 | 2016 | ||
| Valuation | ||||||||
| Price/Sales | ||||||||
| Price/Earnings | ||||||||
| Price/Book | ||||||||
| Earnings Yield % | ||||||||
| Growth | ||||||||
| Revenue % | ||||||||
| Operating income % | ||||||||
| Net Income % | ||||||||
| Financial Health | ||||||||
| Quick Ratio | ||||||||
| interest Coverage | ||||||||
| Debt/Equity | ||||||||
| Profitability | ||||||||
| ROA | ||||||||
| ROE | ||||||||
| ROIC | ||||||||
| Net margin % |
&"Calibri Bold,Bold"&14&K000000&A
&"Calibri,Regular"&K000000&D &"Calibri,Regular"&K000000&F &"Calibri,Regular"&K000000&P
Instructions 1. The purpose of this template is to gather data that will be analyzed and discussed in the Assignment Part B submission. Insert the name of the company in the "Company 1 or Company 2" headings so we know which company is being reviewed. 2. The template uses the ratio terminology in the CFO Guidebook. We have also provided you with a Course Ratio Checklist you can use to understand what the ratios mean and how they are calculated. Please use Current Year ratios as the base ratios. For example, the most recent full year. 3. Ratios for the companies are included in the Morningstar analyst report provided in the course. Some ratios are also provided in the 10-K Annual Report, from online sources, or can be calculated - but for this exercise you can use the Morningstar analyst report as you primary source. 4. Do not delete ratios from the table. There is no requirement to add extra ratios, unless your believe there are othe ratios that best helps you describe the performance impacting the valuation of the companies. More is not necessarily better - we are looking for quality over quantity. 5. The ratios in this execrcise are based on historical performance. When comparing the ratios of the two companies side-by-side, you will notice differences. One company may seem to have performed better - we are looking for your insight for that difference in performance. 6. You can also change the font size and the column widths. Keep the headings standard. While not a requirement, if you believe an additional column is required to better describe/classify your risks, then add it. 7. While not a requirement, you can copy/paste the Excel completed table as a picture in your Word document if it makes it easier to reference in your analysis and recommendations.
Assignment 3
| Company 1 INSERT COMPANY NAME HERE | Company 2 INSERT COMPANY NAME HERE | |||||||
| Morningstar Analyst Report Data | 2018 | 2017 | 2016 | 2018 | 2017 | 2016 | ||
| Income Statement | ||||||||
| Revenue (Bil) | ||||||||
| Operating Income (Bil) | ||||||||
| Net Income (Bil) | ||||||||
| Operating Performance | ||||||||
| Gross Margin % | ||||||||
| Operating Margin % | ||||||||
| Net Margin % | ||||||||
| Days Sales Outstanding | ||||||||
| Days Inventory | ||||||||
| Days Payables | ||||||||
| Receivables Turnover | ||||||||
| Inventory Turnover | ||||||||
| Fixed Asset Turnover | ||||||||
| Total Asset Turnover |
&"Calibri Bold,Bold"&14&K000000&A
&"Calibri,Regular"&K000000&D &"Calibri,Regular"&K000000&F &"Calibri,Regular"&K000000&P
Instructions 1. The purpose of this template is to gather data that will be analyzed and discussed in the Assignment Part B submission. Insert the name of the company in the "Company 1 or Company 2" headings so we know which company is being reviewed. 2. You will be reviewing the financial data from various years looking for trends. 3. The template uses the ratio terminology in the CFO Guidebook. We have also provided you with a Course Ratio Checklist you can use to understand what the ratios mean and how they are calculated. 4. Ratios for the companies are included in the Morningstar analyst report provided in the course. Some ratios are also provided in the 10-K Annual Report, from online sources, or can be calculated - but for this exercise you can use the Morningstar analyst report as you primary source. 5. Do not delete ratios from the table. There is no requirement to add extra ratios, unless your believe there are othe ratios that best helps you describe the performance impacting the forecast of the companies. More is not necessarily better - we are looking for quality over quantity. 6. When comparing the forecasts of the two companies side-by-side, you will notice differences. One company may seem to have better trends - we are looking for your insight of the difference in performance. 7. You can also change the font size and the column width. Keep the headings standard. 8. While not a requirement, you can copy/paste the Excel completed table as a picture in your Word document if it makes it easier to reference in your analysis and recommendations.
