A Company is considering two mutually exclusive projects whose expected net cash flows are in the table below. The company's WACC is $15\%.$

What is the NPV for Project Y$?$

What is the NPV for Project Z$?$

What is the IRR for Project Y$?$

What is the IRR for Project Z$?$

Which Project, if any, should you choose? Time Project Y Project Z

$0$ $$(420\mathrm{.}00)$ $$(950\mathrm{.}00)$

$1$ $$(572\mathrm{.}00)$ $$270\mathrm{.}00$

$2$ $$(189\mathrm{.}00)$ $$270\mathrm{.}00$

$3$ $$(130\mathrm{.}00)$ $$270\mathrm{.}00$

$4$ $$1,300\mathrm{.}00$ $$270\mathrm{.}00$

$5$ $$720\mathrm{.}00$ $$270\mathrm{.}00$

$6$ $$980\mathrm{.}00$ $$270\mathrm{.}00$

$7$ $$(225\mathrm{.}00)$ $$270\mathrm{.}00$

Please show in excel I think im getting the wrong values