An investment has an installed cost of $$638,400.$ The cash flows over the four$-$year life of the investment are projected to be $$236,800,$$$257,380,$$$225,320,$ and $$167,410.$ If the discount rate is zero, what is the NPV$?$ If the discount rate is infinite, what is the NPV$?$ At what discount rate is the NPV just equal to zero?

Year $0$

Year $1$

Year $2$

Year $3$

Year $4$

Discount rate

$$(638,400)$

$$236,800$

$$257,380$

$$225,320$

$$167,410$

Complete the following analysis. Do not hard code values in your calculations. You must use the built$-$in Excel functions to answer this question.

NPV at zero percent

NPV at an infinite interest rate

Zero NPV discount rate