Business Finance - Accounting Assignment 2: Performance Management and Valuation
Kenzie10
AssignmentWorkbookTemplateExcel.xlsxMaster 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. | |
| NVIDIA | |||||
| Risk Ranking (pg. 31) | Risk Name (10-K Annual Report, Other) | Description of the risk | Risk Profile (Pg. 33) | Mitigation Plan (Pg 35) | |
| 1 | Market Demand Volatility | NVIDIA is heavily dependent on demand for its GPUs in sectors like gaming, data centers, and AI. A sudden decline in demand due to macroeconomic conditions, or shifts in consumer preferences, could negatively impact revenue. | Market Risk | Diversify product offerings across different sectors (e.g., AI, automotive) and build strategic partnerships with industries that have stable growth to mitigate demand fluctuations. | |
| 2 | Supply Chain Disruptions | NVIDIA is vulnerable to disruptions in its supply chain, particularly with the availability of semiconductors and raw materials for manufacturing. Supply chain shortages could delay production and increase costs. | Operational Risk | Increase collaboration with suppliers to ensure long-term agreements, invest in alternative suppliers, and improve internal inventory management to mitigate supply chain risks. | |
| 3 | Competition in AI and GPU Markets | NVIDIA faces fierce competition from AMD, Intel, and emerging players in the GPU and AI markets. This competition could affect market share and reduce pricing power. | Market Risk | Focus on innovation in AI and deep learning technologies to differentiate its products. Invest in research and development (R&D) to maintain a technological edge. | |
| 4 | Regulatory and Geopolitical Risks | NVIDIA operates globally, making it susceptible to trade restrictions, tariffs, and changes in government policies, especially in key markets like China. These risks could impact its international operations. | Strategic Risk | Strengthen compliance programs and monitor global trade policies closely. Engage with regulators and policymakers to anticipate changes and reduce potential trade barriers. | |
| 5 | Cybersecurity Threats | As a leading technology company, NVIDIA is a potential target for cyberattacks, which could compromise sensitive data, disrupt operations, or damage its brand reputation. | Operational Risk | Implement advanced cybersecurity measures, conduct regular security audits, and ensure that employees are trained to recognize potential threats. Establish a rapid incident response system to mitigate the impact of any security breaches. | |
| Intel | |||||
| Risk Ranking (pg. 31) | Risk Name (10-K Annual Report, Other) | Description of the risk | Risk Profile (Pg. 33) | Mitigation Plan (Pg 35) | |
| 1 | Manufacturing Delays | Intel faces significant challenges in transitioning to newer manufacturing technologies, such as 7nm and 5nm processes. These delays may result in a technological gap compared to competitors like AMD. | Operational Risk | Invest in R&D and infrastructure to accelerate the adoption of new process technologies. Consider forming strategic partnerships with external manufacturers or third-party fabs to mitigate delays. | |
| 2 | Market Share Loss to AMD | Intel is facing increased competition from AMD in the CPU market. AMD’s product line offers comparable or superior performance in some segments, resulting in market share loss for Intel. | Market Risk | Enhance product innovation, diversify product offerings, and focus on competitive pricing strategies. Strengthen marketing efforts to reinforce Intel's brand and value proposition. | |
| 3 | Supply Chain Vulnerabilities | Intel's dependence on a few suppliers for raw materials and components makes it vulnerable to supply chain disruptions, especially during global shortages. | Financial Risk | Diversify supply chain sources and implement strategic inventory management to mitigate potential disruptions. Increase collaboration with suppliers to secure long-term contracts and ensure stable supply chains. | |
| 4 | Regulatory Risks | Intel is subject to regulatory scrutiny in multiple countries, especially regarding anti-competition laws and trade restrictions (e.g., tariffs on semiconductor imports). | Strategic Risk | Develop comprehensive compliance strategies and engage in ongoing dialogue with regulators. Proactively address potential regulatory challenges to avoid penalties and disruptions to operations. | |
&"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.
