Multiply the original price by20 802016. Now that we have the discount amount and the Original price we can just feed the values into out formula to calculate the percentage discount. The percentage discount on the bottle of wine is 20.
Youre still paying 60 of the original 80.
Example 2 Let us take an example where the discount factor is to be calculated from year 1 to year 5 with a discount rate of 10. The result is 14099 12 16919. In the example the active cell contains this formula. Double check your answer with the original question.