If you were writing a report about increases in price how would you show the increase?

Like This assuming old is 6 pounds and new is 10 pounds
(10-6)/6 = 66.66%

or

10/6 = 166.66%

I can't believe I don't know but my mind is tired after a whole day since 05H00 of spread sheet work and I have managed to totally confuse myself!

First method looks the correct way to me.

Checked by 6.00 x 1.6666 = 9.99 or 6 + 66.66% = 9.99 (Windows calculator)

[Edited on 13/8/18 by nick205]

method 1 to show % increase.

Actually it should be old price plus the increase equals new. Being the increase a percentage of the old price, we have that
increase = old*x
being x the increase in percentage of the old value.

So...
old + old*x = new
I find it easier to do like
old * (1 + x) = new
6 * (1+x) = 10
1+x = 10/6
1+x = 1,666
x = 1,666 - 1
x = 0,666
So, 66%

Can also be done
old + old*x = new
old*x = new-old
6*x = 10-6
6*x = 4
x = 4/6
x = 0,666
So, 66%

Just checked with the accountant wife and she says 66%.

Eg if it's 100 pounds this week and next week it's 102 pounds you'd say it was a 2% increase not 102%.

^^^^^^^ holy crap, is that meant to simply things?..

Google explains it perfectly.

work out the difference (increase) between the two numbers, I. e. old price subtracted from new..

Then: divide the increase by the original number and multiply the answer by 100. If your answer is a negative number then this is a percentage decrease.

quote:

---

Originally posted by Ivan
If you were writing a report about increases in price how would you show the increase?

Like This assuming old is 6 pounds and new is 10 pounds
(10-6)/6 = 66.66%

or

10/6 = 166.66%

I can't believe I don't know but my mind is tired after a whole day since 05H00 of spread sheet work and I have managed to totally confuse myself!

---