Excel spreadsheet and 2 page paper
Assignment 1
SAMPLE COMPANY | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Risk Ranking (pg. 26) |
Risk Name (10-K Annual Report, Other) |
Description of the risk | Risk Profile (Pg. 28) |
Mitigation Plan (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 | 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. | |||||||||||||||||||||||||||||||||||||||||||||||||
COMPANY 1 NAME HERE | |||||||||||||||||||||||||||||||||||||||||||||||||||||
COMPANY 2 NAME HERE | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Risk Profile (Pg. 28) |
&”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
, 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. Pick the risks.
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 NAME HERE | |||||||
2017 | 2018 | ||||||
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 2 NAME HERE | ||
Morningstar Analyst Report Data | Forecast (optional) | |
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.