How to calculate the discount rate in excel
The discount formula can be written as P=F*(P/F,i%,n), where (P/F,i%,n) is the symbol used to define the discount factor. To convert the future value to the Select a blank cell, for instance, the Cell C2, type this formula =(B2-A2)/ABS(A2) ( the Cell A2 indicates the original price, B2 stands the sales price, you can change A guide to the NPV formula in Excel when performing financial analysis. F = Future payment (cash flow), r = Discount rate, n = the number of periods in the future.