Enter the cash flows in a row or column
Put the discount rate in a separate cell
Use the formula `=NPV(rate, value1, [value2], …)`
Select the range of future cash flows as the values
Add the initial investment separately with `+` or `-`
Example: `=NPV(B1, B2:B6)+B2`
Ensure the rate and cash flow periods match
Use positive values for inflows and negative values for outflows