The discount rate is the rate for one period, assumed to be annual.
NPV in Excel is a bit tricky, because of how the function is implemented.
NPV Function
The Excel NPV function is a financial function that calculates the net present value (NPV) of an investment using a discount rate and a series of future cash flows.
