19+ How To Calculate Discount In Excel Formula Background. The analysis what if in excel data table. Take a look at the previous screenshot.
How to calculate pv on a financial calculator. Here we discuss how to calculate the discount factor using practical examples along with downloadable excel templates. If you know the discounted price and the percentage discount, you can calculate the original price.
I got this question in excel, the discount is to be computed as follows:
As you will see in the example below, the value of equal cash flow payments present value = discounted back to the time of the investment. Take a look at the previous screenshot. This article has been a guide to discount factor formula. Your percentage values are now all ready!