I really only need help with question number 6 but I'm including all of my other work for reference.

Question #6 needs to be done using the DATA TABLE in the What if Analysis. Please show how to do this.

Task 1_Project Evaluation Question 1 Unit sales Variable cost/unit Fixed costs 2.000 7,000 900,000 2,100 6,650 900,000 Worst Case 1.900 7,350 900,000 Sales Variable cost Fixed cost Depreciation EBIT Taxes (21%) Net income 20,000,000 14,000,000 900,000 3.100,000 2,000,000 420,000 1,580,000 21,000,000 13,300,000 855,000 3.100.000 3.745,000 786,450 2,958,550 19,000,000 14,700,000 945.000 3.100.000 255,000 153550 201.450 OCF 4,680,000 6.058.550 3,301,450 NPV $16,870 352.63 $21,839 216.86 TL 5 11.900,988,39 Question 2 Accounting break-even 1,333,33Q - (FCD)/(P-v) Goal Seek: NI = 0, change Unit sales Question 3 Cash break-even (ignoring taxes) 300.000 - FC/(P-V) Goal Seek: OCF = 0, change Unit sales 36 Question 4 OCF at financial-break even Financial break-even 4,299,851 PMT(Required return. Project literalvestment 1.733.280 - (OCF.FC)/(P-V) Goal Seek NPV change Unit sales Question 5 Degree of operating leverage 114 1-(FC/OCA Question 6 Question 6 Draw graph of "Sensitivity of NPV to changes in unit price" OCF 4,299,851 Original Unit Price 10,000 Unit Price NPV $16,870,352.63 9,000 9,250 9,500 9,750 10,000 10,250 10,500 10,750 11,000 11,250 11,500 * Need to do using the Table function in What if Analysis. Task 1: Project Evaluation You are considering a new product launch. The project will cost $15,500,000, have a five- year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 2,000 units per year; price per unit will be $10,000, variable cost per unit will be $7,000, and fixed costs will be $900,000 per year. The required return on the project is 12 percent, and the relevant tax rate is 21 percent. Based on your experience, you think the unit sales, variable cost, and fixed cost projections given here are probably accurate to within + 5 percent. Questions: 1. What are the upper and lower bounds for these projections? What are NPVs for the base- case, the best case and worst-case scenarios? (20 Points) 2. What is the accounting break-even level of output for this project? (5 Points) 3. What is the cash break-even level of output for this project (ignoring taxes)? (5 Points) 4. What is the financial break-even level of output for this project? (5 Points) 5. What is the degree of operating leverage under each scenario? (5 Points) 6. Draw the chart showing the sensitivity of the base-case NPV to changes in unit price. (10 Points)