$3.$ Which fields are required to calculate net present value $($NPV$)$ in Excel?

Rate of return and cash flows for each year

Average cash flow and future value

Future value and rate of return

Cash flows for each year and average cash flow

$4.$ Which Excel function is used to calculate the amount of each annuity payment?

FV

NPV

PMT

PV

$5.$ Which fields are required to calculate the rate of return $($RATE$)$ for a present value calculation in Excel?

Nper, PMT$,$ and NPV

Nper, PMT$,$ and PV

Type, PMT$,$ and FV