CALCULATE NET PRESENT VALUE USING EXCEL

i. Firstly, you have to insert the data in the column.

Figure 4 shows the data that have been insert in the column

 ii. Next, enter the formula "=NPV(B3,B3,B6)+B4" to account for that initial outlay.

Figure 5 shows formula that have benn type in the column

iii. Click enter, then the answer will come out.

Figure 6 shows the answer of the data