How to calculate NPV in Excel? Im still learning this so say for this example how would i go about it: Say I have an initial cost of 20,000 and cash flow of 30,000 per year for 5 years with an interest rate of 0.5%… How do I calculate the NPV in excel? submitted by /u/Loud_Marsupial_4667