Complete excel sheet with formulas for Total cash flow, NPV$,$ and IRR. then Critical Value What is the NPV and IRR for this project? Shall the project be accepted? Why? $(2$ points$)$

$NPV=$

IRR $=$

Type your answer here:

$3.$ please identify top $3$ value drivers using break$-$even senstivity analysis $(3$ points$)$

$4.$ Using the following table and Excel scenario manager function to conduct a scenario analysis. In this analysis, please cover worst, expected, and best scenario. Please make sure to change the cell references in the scenario summary table to proper variable names so your results are understandable. $(3$ points$)$

$\backslash$table$[[,,,],[$Variable$,$Expected Value,Minimum,Maximum$],[$NWC $(\%),15\%,12\%,17\%],[$Variable Cost,$210,200,230],[$Unit Price,$345,320,355],[$Tax Rate,$35\%,30\%,40\%],[$Discount Rate,$18\%,15\%,20\%]]$

Please note: minimum doesn't mean worst scenario, and maximum doesn't mean best scenario either.

Please complete the cash flow estimation table. What are the projected cash flows for each year? $(5$ points$)$Please complete the cash flow estimation table. What are the projected cash flows for each year? $(5$ points$)$