Arial

$12$

A

B I

$U_{?}$

$\%$

$$

AlignmenNumber Conditiona Format Cell

Formattingas Table Styles

Font

Styles

B

C

D

E

F

G

H

$J$

What is the NPV of the following cash flows at a discount rate of zero percent? What if the discount rate is $10$ percent? If it is $20$ percent? If it is $30$ percent?

$\backslash$table$[[$Year $0,$$ $(13,900),],[$Year $1,$$ $6,400,],[$Year $2,$$ $8,700,],[$Year $3,$$ $5,900,],[$Discount rate,,$0\%],[$Discount rate,,$10\%],[$Discount rate,,$20\%],[$Discount rate,,$30\%]]$

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

NPV at $0$ percent

NPV at $10$ percent

NPV at $20$ percent

Sheet$1$

$100\%$

DY

Hint

Prev

$3$ of $17$

Next