You can go to www.palisade.com and install the software in your laptop. They offer 15 days free trial. Or you can use the software We provided you but don't forget to connect to the VPN. First, when you open this spreadsheet, save it under your Last Name-Question.xls then start solving the problem ICG is thinking of launching a new product. The objective in ICG is to examine the robustness of decisions based on Net Present Value calculations, when some of the inputs change. The management team is trying to decide whether or not to launch a new product which is expected to have a market for the next five years. The following information about the product has been gathered: The expected market size is 8,000,000 units in the first year with 2% growth per year thereafter. 0) 1) A 15% market share is anticipated in the first year, growing linearly by 0.3% per year afterwards. In the first year, the price is likely to be $7 growing by 6% annually thereafter. ii) iv) The expected variable cost per unit is $5 increasing by 3% per year. Fixed costs are expected to start at $2,000,000 and to grow annually at 3% as well. An initial investment of $2,500,000 is planned. The discount rate of 15% is considered for projects of this kind. v) Armed with these assessed distributions, Choose the following Simulation Settings: Iterations: 5,000 Simulations: 1 Sampling Type: Hypercube Simulation not Running, Distributions return=Static Values then When RiskStatic is not defined use Expected Values Generator: Marsenne Twister Initial seed: 1 All use same seed Collect distribution samples: All Smart sensitivity analysis: Enabled First when you open this spreadsheet, save it under your Last Name-Question8.xls then start solving the problem 1. In this workbook please generate and attach the following @Risk Excel Reports: Quick Report, Input and Output Results Summary, Detailed Stats, Scenario and Sensitivity sheets 2. Show the Cumulative Ascending Cumulative - Line. What is the probability that the project will make its hurdle rate? 3. Show the Output Histogram for NPV and IRR What is the probability of IRR being less than 15%. 4. What are the key drivers of the project's success and what is their interpretation (Screenshots)? What @Risk function did you use to find the key drivers? 5. Show the sensitivity analysis screenshot and interpret the Rsquared. 6. Would you lunch this product or not? Why? 4 8,490 5 8,659 7,0 ICG SPREADSHEET FOR FIVE YEARS (cashflow in thousands) 1 2 3 MARKET SIZE 8,000 8,160 8,323 PRICE VARIABLE COST 5.0 SALES (MS) 1,200 NET REVENUE 2,400 FIXED COSTS -2,000 CASHFLOW -2,500.00 400 RESULTS NPV IRR ASSUMPTIONS Discount Rate Prod Cost Price Market Share MS Incr MktGrowth 15% 5 7 15% 0.3% 102.0% BaseCase Pessimistic Most Likely MS Incr -0.2% 0.3% MktGrowth 90.0% 102.0% NPV IRR Optimistic 0.8% 108.0% You can go to www.palisade.com and install the software in your laptop. They offer 15 days free trial. Or you can use the software We provided you but don't forget to connect to the VPN. First, when you open this spreadsheet, save it under your Last Name-Question.xls then start solving the problem ICG is thinking of launching a new product. The objective in ICG is to examine the robustness of decisions based on Net Present Value calculations, when some of the inputs change. The management team is trying to decide whether or not to launch a new product which is expected to have a market for the next five years. The following information about the product has been gathered: The expected market size is 8,000,000 units in the first year with 2% growth per year thereafter. 0) 1) A 15% market share is anticipated in the first year, growing linearly by 0.3% per year afterwards. In the first year, the price is likely to be $7 growing by 6% annually thereafter. ii) iv) The expected variable cost per unit is $5 increasing by 3% per year. Fixed costs are expected to start at $2,000,000 and to grow annually at 3% as well. An initial investment of $2,500,000 is planned. The discount rate of 15% is considered for projects of this kind. v) Armed with these assessed distributions, Choose the following Simulation Settings: Iterations: 5,000 Simulations: 1 Sampling Type: Hypercube Simulation not Running, Distributions return=Static Values then When RiskStatic is not defined use Expected Values Generator: Marsenne Twister Initial seed: 1 All use same seed Collect distribution samples: All Smart sensitivity analysis: Enabled First when you open this spreadsheet, save it under your Last Name-Question8.xls then start solving the problem 1. In this workbook please generate and attach the following @Risk Excel Reports: Quick Report, Input and Output Results Summary, Detailed Stats, Scenario and Sensitivity sheets 2. Show the Cumulative Ascending Cumulative - Line. What is the probability that the project will make its hurdle rate? 3. Show the Output Histogram for NPV and IRR What is the probability of IRR being less than 15%. 4. What are the key drivers of the project's success and what is their interpretation (Screenshots)? What @Risk function did you use to find the key drivers? 5. Show the sensitivity analysis screenshot and interpret the Rsquared. 6. Would you lunch this product or not? Why? 4 8,490 5 8,659 7,0 ICG SPREADSHEET FOR FIVE YEARS (cashflow in thousands) 1 2 3 MARKET SIZE 8,000 8,160 8,323 PRICE VARIABLE COST 5.0 SALES (MS) 1,200 NET REVENUE 2,400 FIXED COSTS -2,000 CASHFLOW -2,500.00 400 RESULTS NPV IRR ASSUMPTIONS Discount Rate Prod Cost Price Market Share MS Incr MktGrowth 15% 5 7 15% 0.3% 102.0% BaseCase Pessimistic Most Likely MS Incr -0.2% 0.3% MktGrowth 90.0% 102.0% NPV IRR Optimistic 0.8% 108.0%