Business Finance - Accounting Assignment 1: Enterprise Risk Management and Moat Strength
Master Tab
| Instructions | Below you will see three tabs or workbooks in this Excel spreadsheet. You are required to complete the Assignment #1 in Week 3, Assignment #2 tab in Week 6, and Assignment #3 tab in Week 9. Please read the instructions in the course and the instructions located inside each MS Excel workbook. | |
| Week 3 / Assignment #1 | To be completed in Week 3. Use the CFO Guidebook as a reference and to fill out the Assignment #1 information. The collected information should inform the second part of the assignment, which is the paper. Please watch/attend the Success Video Session, use the MS Word Template, Grammarly, and a Communications Coach, as needed. Use all of the documents provided by your professor located in MyProfessor (click AskTheProfessor). Reach out early to your professor with questions. | |
| Week 6 / Assignment #2 | To be completed in Week 6. Use the CFO Guidebook as a reference. The collected information should inform the second part of the assignment, which is the paper. Please watch/attend the Success Video Session, use the MS Word Template, Grammarly, and a Communications Coach, as needed. Use all of the documents provided by your professor located in MyProfessor (click AskTheProfessor). Reach out early to your professor with questions. | |
| Week 9 / Assignment #3 | To be completed in Week 9. Use the CFO Guidebook as a reference. The collected information should inform the second part of the assignment, which is the paper. Please watch/attend the Success Video Session, use the MS Word Template, Grammarly, and a Communications Coach, as needed. Use all of the documents provided by your professor located in MyProfessor (click AskTheProfessor). Reach out early to your professor with questions. | |
Assignment 1
| SAMPLE COMPANY | |||||
| Risk Ranking (pg. 31) | Risk Name (10-K Annual Report, Other) | Description of the risk | Risk Profile (Pg. 33) | Mitigation Plan (Pg 35) | |
| 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. | |
| Insert Company Here | |||||
| Risk Ranking (pg. 31) | Risk Name (10-K Annual Report, Other) | Description of the risk | Risk Profile (Pg. 33) | Mitigation Plan (Pg 35) | |
| Inset Company Here | |||||
| Risk Ranking (pg. 31) | Risk Name (10-K Annual Report, Other) | Description of the risk | Risk Profile (Pg. 33) | Mitigation Plan (Pg 35) | |
&"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. 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 | COMPANY 2 NAME HERE | |||||||
| Use the most recent three years | Use the most recent three years | |||||||
| Morningstar Analyst Report | 20XX | 20XX | 20XX | 20XX | 20XX | 20XX | ||
| 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 | ||||||||
&"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. 8. In the Optional section, consider adding, if applicable, data from the latest quarter, TTM, industry average, or something similiar.
Assignment 3
| COMPANY 1 NAME HERE | COMPANY 2 NAME HERE | |||||||
| Use the most recent three years | Use the most recent three years | |||||||
| Morningstar Analyst Report Data | 20XX | 20XX | 20XX | 20XX | 20XX | 20XX | ||
| Income Statement | ||||||||
| Revenue (Bil) | ||||||||
| Operating Income (Bil) | ||||||||
| Net Income (Bil) | ||||||||
| Operating Efficiency & Cash Flow | ||||||||
| Cash Conversion Cycle | ||||||||
| Gross Margin % | ||||||||
| Operating Margin % | ||||||||
| Net Margin % | ||||||||
| EBITDA Margin % | ||||||||
| Tax Rate % | ||||||||
| Free Cash Flow/Sales % | ||||||||
| Free Cash Flow/Net Income | ||||||||
| Free Cash Flow/Share | ||||||||
| Enterprise Value (Bil) | ||||||||
&"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. 9. In the Optional section, consider adding, if applicable, data from the latest quarter, TTM, industry average, or something similiar.