Perform a sensitivity analysis for the effects of key variables (e.g., sales growth rate, cost of capital, unit costs, sales price) on the estimated NPV or IRR in order to demonstrate the sensitivity of the model. The Scenario analysis of several variables simultaneously is encouraged (but not required).

 

Key Indicators USD (mil) Quarter Ending 31-Dec-2019 Quarter Ending Yr Ago 13.60% 13.10% 35.42% Annual Year End 30-Jun-2019 Total Revenue Research and Development Operating Income Net Income Rasie EPS Caplal Fxpandturos Cash trom Operating Activities Free Cash Flow 1 Year Growth 3 Year Growth 36.906.0 4.600.0 13891.0 11649.0 15F 5 Year Growth 125,843.0 18,876.0 42,959 0 30,240 0 511 -13,9250 52,1850 38,260.0 286,556.0 184,226.0 66,062.0 144000 1,643.0 14.03% 11.34% 14.80s 22 54% 138 80% 137 87% 19.71% 18.02% 18.63% 12.00% 16.40% 24 08% 25 30 18. 60% 16 11% 7.70% 820% 9.03% 12 19% 13 95 3835% 40 37 437% 3545F 10 680.0 71350F 282.794.0 172.685.0 63.301.0 20.00% 20 48% 37 40% 925N 357 9.93 Total Assets 15.25% 721N Total Liabities 10.70% 13.9% 14.8eN 18.00% 8.09 -0.71 36.92% 10.70% Total Long-Term Debt Employees Total Common Shares Outstanding Market Cap 4.60% -7.72% 9.12% 0.44% 17.40% 25.42% 7611.0 1,200 254,7 0.94% 238% -1.49% 24.47% 53.81% 1.026,511.1 36.49% - Perform a sensitivity analysis for the effects of key variables (e.g., sales growth rate, cost of capital, unit costs, sales price) on the estimated NPV or IRR in order to demonstrate the sensitivity of the model. The Scenario analysis of several variables simultaneously is encouraged (but not required). A document Sensitivity Analysis in Excel is provided in this learning module. It introduces the Data Table method that you can use for performing sensitivity analysis in Excel. WACC is 6.54%