Answer the follwing question: Net Present Value:

Initial investment

$=$

$$$

$($

$3$

$0$

$,$

$0$

$0$

$0$

$)$

Annual income:

Year

$1$

$$$

$6$

$,$

$0$

$0$

$0$

$$x

$0$

$.$

$9$

$5$

$2$

$4$

$=$

$$$

$5$

$,$

$7$

$1$

$4$

$.$

$4$

$0$

Year

$2$

$$$

$9$

$,$

$2$

$0$

$0$

x

$0$

$.$

$9$

$0$

$7$

$0$

$=$

$8$

$,$

$3$

$4$

$4$

$.$

$4$

$0$

Year

$3$

$$$

$5$

$,$

$9$

$0$

$0$

$$x

$0$

$.$

$8$

$6$

$3$

$8$

$=$

$5$

$,$

$0$

$9$

$6$

$.$

$4$

$2$

Year

$4$

$$$

$7$

$,$

$3$

$0$

$0$

$$x

$0$

$.$

$8$

$2$

$2$

$7$

$=$

$6$

$,$

$0$

$0$

$5$

$.$

$7$

$1$

Year

$5$

$$$

$9$

$,$

$2$

$0$

$0$

$$x

$0$

$.$

$7$

$8$

$3$

$5$

$=$

$7$

$,$

$2$

$0$

$8$

$.$

$2$

$0$

Year

$5$

$$$

$3$

$,$

$0$

$0$

$0$

$$x

$0$

$.$

$7$

$8$

$3$

$5$

$=$

$2$

$,$

$3$

$5$

$0$

$.$

$5$

$0$

Total $

$3$

$4$

$,$

$7$

$1$

$9$

$.$

$6$

$3$

Net Present Value: $

$4$

$,$

$7$

$1$

$9$

$.$

$6$

$3$

$$ How would you get this number on excel using

$=$

PV FUNCTION and then adding the initial investment to get NPV

$?$ Required rate of return $=5\%$