Which formula below calculates the correct net present value using a valuation date of January $1,2024?$

$1$

B

C

D

E

F

G

H

$1$

$2$

$\%4$

$4$

$$

$5$

:$\text{'}$ icas

Cashflows

$300,000$

Discount Rate

$10\mathrm{.}00\%$

$=xNPV(C6,D3$:$H3,D5$:$H5)$

$=C5+NPV(C6,D5$:$H5)$

$=D5+NPV(C6,E5$:$H5)$

$=xNPV(C6,C5$:$H5,C3$:$H3)$

MacBook Air