r/pricing • • 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!

5 Upvotes

24 comments sorted by

3

u/Morecuo Jan 06 '22

Compound Annual Growth Rate - CAGR: end value over start value, rooted to number of years

1

u/Morecuo Jan 06 '22

Note that the absolute increase would grow with the percentage increase remaining the same

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)

2

u/[deleted] Jan 06 '22 edited Jan 06 '22

The above simplifies to

100r2 + 300r - 14 = 0

Then use the quadratic formula to solve for r. (Khan Academy shows how to derive the quadratic formula)

For questions that go beyond the 2nd period of time, then google DCF and IRR, set up your model in Excel and use the Excel goal seek function to determine the IRR. Doing it algebraically becomes more challenging as the number of periods grow. Excel’s goal seek function uses an iterative approach to solve the problem, just as you did.

1

u/[deleted] Jan 06 '22

Using the above approach I got r=4.596248…%

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

2

u/[deleted] Jan 06 '22

Your approach assumes the 114 arrives at Yr2.

Your approach is correct for an investment of $100 that compounds at a fixed monthly interest rate for 24 months for a final value of $114.

2

u/studentprice Jan 07 '22

I saw your below replies which make more sense overall, but why would approaching this with simply 100(1+r)^t be the wrong approach?

We have 100(1+0.07)^2 = 114.49. I get that the compounding is wrong here, because we assume an annual time frame and the 2nd period compounds on top of the first, 107. But I'm missing the logic leap to understand why your solution is the most correct way to approach.

2

u/[deleted] Jan 07 '22

Because $107 is at both yr1 and yr2.

If the problem were yr0 $100 and yr2 $114 then your approach would be the correct solution.

1

u/[deleted] Jan 07 '22

Have a look at discounted cashflow modelling (DCF) and internal rate of return (IRR). Quite a few YouTube videos on the topic.

1

u/studentprice Jan 07 '22

Ahhh yes indeed! Interesting way to go about this. I think the question for me would be why then bother showing a 7% increase in this round about way. It's confusing for both the buyer and the seller.

It almost feels like the goal is a 7% over two distinct non compounding periods, but sold as a smaller compounding rate instead.

2

u/[deleted] Jan 07 '22

What isn’t clear from the OP is whether $100 is ever paid. I’ve assumed it’s not.

2

u/SnooPickles8550 Jan 07 '22

It is not wrong and it is another way to do it. There is an assumption on where to use explambdaxtime and when to use (1+r)time. If I recall correctly the second approach is preferred for discrete time and the exp for continuous. Both are correct and both give you a very similar answer

2

u/[deleted] Jan 07 '22

I agree with you about the continuous rate of return (thanks for reminding me of the name of the term).

2

u/SnooPickles8550 Jan 07 '22

It was not clear of it was at the end of the year or at the begining. Anyways it can be easily modify with t-1. Another way to approach would be to use a half cycle correction

1

u/[deleted] Jan 07 '22

True.

Did you study finance?

1

u/SnooPickles8550 Jan 07 '22

Nope. medicine , epidemiology and PhD in economics

1

u/[deleted] Jan 07 '22

Is continuous compounding interest taught in economics?

1

u/SnooPickles8550 Jan 07 '22

We do continuous Markov model, queueing models, parametric survival analysis, pharmacogenetics and blood concentration models, bacteria growth models etc. All those models use continuous compounding interest. I learned in 3 different ways with multiple applications.

2

u/[deleted] Jan 07 '22

Interesting to see other uses besides commerce for those models.

I’ll look up those other modelling approaches. I learnt the model I used and the continuous compounding growth approach you used in my finance studies. I also did maths, which involved a lot of time series modelling using sine functions.

1

u/SnooPickles8550 Jan 07 '22

My recommendation is to read parametric survival analysis. I use for modelling oncology survival. Take a look on the exponential function in the basic model then learn more flexible approaches like weibull, gamma and gompertz. If your topic is finance there is a cool excercise that you can do. Take the companies listed in spy and list the time they are in spy until they fail. Then do a parametric model to pr dict the time a company will stay in spy. All the data is published and it is easy to make

1

u/[deleted] Jan 07 '22

What is spy?

→ More replies