Develop a spreadsheet model, and use it to find the project's NPV$,$ IRR, and payback. Round your answer for the NPV to the nearest dollar and for the IRR and payback to two decimal places.

NPV$$$fill in the blank $2$IRRfill in the blank $3\%$Regular payback periodfill in the blank $4$years

Now conduct a sensitivity analysis to determine the sensitivity of NPV to changes in the sales price, variable costs per unit, and number of units sold. Set these variables' values at $10\%$ and $20\%$ above and below their base$-$case values. Round your answers to the nearest dollar. Use a minus sign to enter a negative value, if any.

$\%$ Deviation fromNPV with Variables at Different Deviations from BaseBase CaseSales PriceVariable Cost per UnitNumber of Units Sold$-20\%$$$$fill in the blank $5$$$$fill in the blank $6$$$$fill in the blank $7-10\%$$$$fill in the blank $8$$$$fill in the blank $9$$$$fill in the blank $100\%$$$$fill in the blank $11$$$$fill in the blank $12$$$$fill in the blank $1310\%$$$$fill in the blank $14$$$$fill in the blank $15$$$$fill in the blank $1620\%$$$$fill in the blank $17$$$$fill in the blank $18$$$$fill in the blank $19$

Choose the correct graph.

A$.$

B$.$

C$.$

D$.$

The correct graph is

graph Agraph Bgraph Cgraph D

$.$

Now conduct a scenario analysis. Assume that there is a $20\%$ probability that best$-$case conditions, with each of the variables discussed in Part b being $20\%$ better than its base$-$case value, will occur. There is a $20\%$ probability of worst$-$case conditions, with the variables $20\%$ worse than base, and a $60\%$ probability of base$-$case conditions. Round your answers for the NPV and standard deviation to the nearest dollar and for the coefficient of variation to two decimal places. Use a minus sign to enter a negative value, if any.

ScenarioNPVBest Case$$$fill in the blank $21$Base Case$$$fill in the blank $22$Worst Case$$$fill in the blank $23$Expected NPV$$$fill in the blank $24$Standard Deviation$$$fill in the blank $25$Coefficient of Variationfill in the blank $26$

If the project appears to be more or less risky than an average project, find its risk$-$adjusted NPV$,$ IRR, and payback. Round your answer for the NPV to the nearest dollar and for the IRR and payback to two decimal places. Use a minus sign to enter a negative value, if any.

Risk$-$adjusted NPV$$$fill in the blank $27$Risk$-$adjusted IRRfill in the blank $28\%$Risk$-$adjusted regular payback periodfill in the blank $29$years