Quad Enterprises is considering a new three$-$year expansion project that requires an initial foced asset investment of $$2\mathrm{.}9$ million. The foxed asset will be depreciated straight$-$line to zero over its three$-$year tax life. The project is estimated to generate $$2\mathrm{.}190\mathrm{.}000$ in annual sales, with costs of $$$15,000.$ The project requires an initial investment in net working capital of $$300,000,$ and the fixed asset will have a market value of $$210,000$ at the end of the project. What is the project's Year $0$ net cash flow? Year $1?$ Year $2?$ Year $3?$ The tax rate is $21$ percent. If the required return is $12$ percent, what is the project's NPV$?$

$\backslash$table$[[$Asset investment,$$,2,900,000$

Ouad Enterprists is considering a new three$-$year expansion project that requires an initial foxed asset investment of $$2\mathrm{.}9$ milion. The freed asset will be depreciated straightine to zero over its three$-$year tax life. The project is estimated to generate $$2,190\mathrm{.}000$ in annual sales, with costs of $$815,000.$ The project requires an initial investment in net working capital of $$300,000,$ and the fured asset will have a market value of $$210,000$ at the end of the project. What is the projecf's Year $0$ net cash flow? Year $1?$ Year $2?$ Year $3?$ The tar rate is $21$ percent. If the required return is $12$ percent, what is the project's NPY$?$

$4$

$5$

$6$

$7$

$8$

$*$

$14$

$11$

$12$

$13$

$14$

$15$

$16$

Complete the following analysis. Do not hard code walues in your calculations. You must use the builitin Excel function to calculate the NPY$.$

$17$

$18$

$19$

$20$

$21$

$22$

$21$

Afiertare salvage value

Sell equipment

Taxes

Attertax cash flow

Sales

$3,2,190,000$

$$,2\mathrm{.}190\mathrm{.}000$

$5,2,190\mathrm{.}000$

Costs

$$

PLEASE HELP ME FIND THE SELL EQUIPMENT AND TAXES AND AFTER CASH FLOW AND CAPITAL SPENDING FOR YEAR $4$ the rest i got it just need those please provide the formulas please to input on excel