Question: how to do a npv calculation in excel?
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 “)”.