Question: how npv is calculated in excel sheet?
Answer: =NPV(discount rate, series of cash flow)
Step 1: Set a discount rate in a cell.
Step 2: Establish a series of cash flows (must be in consecutive cells).
Step 3: Type “=NPV(“ and select the discount rate “,” then select the cash flow cells and “)”.