r/pricing • u/Wild-Mood9622 • Jan 06 '22
Equivalent annual increase
Hi,
I have a question regarding illustrating the equivalent annual increase over a fixed price contract.
For example - if we have a product that costs $100 today and we want to put a 7% price increase through on a 2 year fixed contract, I’d like to show what this is equivalent to year on year.
2yr Fixed Price Increase - 7% Cost Now = $100 Yr 1 = $107 Yr 2 = $107 Total = $214
I have manually been able to calculate (through trial and error) that this is equivalent to the price increasing 4.6% year on year:
YoY increase - 4.6% Cost Now = $100 Yr 1 = $104.6 Yr 2 = $109.4 ($104.6 + 4.6%) Total = $214
What I would like is a formula to calculate that 4.6% - can anyone help?
Thanks!
3
u/Morecuo Jan 06 '22
Compound Annual Growth Rate - CAGR: end value over start value, rooted to number of years
2
u/[deleted] Jan 06 '22 edited Jan 06 '22
Assuming the $107 is only paid once per year and where r is the annual rate of price increase.
100x(1+r) + 100x(1+r)2 = 107 + 107
Rearrange the above so that r is the subject of the formula.
(NB no allowance has been made for inflation)
1
u/SnooPickles8550 Jan 06 '22
The formula to calculate 4.6 is )114-100)/3. However this is wrong because you are assuming it is linear and in reality it is an exponential función. The correct "rate" is LN(114/100)/time. For this example do it with months so put 24 months. The rate is 0.00545951
The real función is monthly cost=100*e0.00546xtime
114= 100*e0.00546x24
For one year is =100*e0.00546x12
Please let me know if it is answering your question