Anyone good at % calculations please?

[LastTimeLosingIt]

Hi,

I cannot work out how to work this out - but know that some clever Mumsnetters will be able to help.

Say I've been quoted £5,000 for something, knowing that I have a 63.5% discount to get to that price. How much was the item originally please?

And then next year, my discount will only be 50%. How much will my quote be next year please assuming no inflationary increases?

And then the year after, my discount will only be 25%. How much will it be then?

If anyone can tell me what formula I need to type into an excel spreadsheet so I can apply this across different quotes, I'd be extra grateful.

Thanks in advance

divide 5000 by 63.5 then x by 100

£7874

Divide by 63.5 then multiply by a hundred to get the non discounted price.

Then half that to see how much you'll pay with a 50 percent discount

And multiply the non discounted price by 0.75 to see how much you'll pay with a 25 percent discount

100 - 63.50 = 36.50

5000 / 36.50 = 13,698.63 was the orig price

£5000 / 0.635 = £13,699 full price
with a discount next year of 50% = £13,699x 0.5 = £6,849
with a discount year after of 25% = £13,699x (1-0.25) = £10,274

hth!

My calculator says £8,175

How can £5,000 be 36.5% of £7,874?

If you're paying 5000 with 63.5% off then 5000 is 36.5% of the full price, making the full price 5000/36.5 x 100 = 13698.63.
Full price with 50% discount will be 6849.32.
Full price with 20% discount will be
10543.97.

FudgeSundae has given you the answer OP, but I wonder about the basic maths understanding of some of these answers! If £5,000 is with a 63.5% discount, that means £5,000 is less than half price. The full price has to be more than double £5,000. So even if you don’t know how to work out %, any answer that’s less than £10,000 is clearly wrong.

Thanks everyone!

A lot of folk are wrongly doing the calculation as if she's paying 63.5% currently, however she clearly stated a current 63.5% discount (going down to 50%) and so the 5000 payment is actually 36.5% total cost.

I'm not sure about a formula as such, but this is broadly what you need to do to compare different quotes:

Year 1 - quote x 0.365
Year 2 - quote x 0.5
Year 3 - quote x 0.75

This is why estimation is a topic in GCSE Maths.

Sorry last line is 25% discount, not 20% (typo).

These are the numbers I got.
Assuming this year you're paying 36.5%, next year 50%, following year 75% assuming base amount remains unchanged.

It's a topic in the Scottish system too, throughout secondary.

Yes this is correct for the full price.

In effect, you are being charged 36.5% of the original price. Therefore 1% is 5000 / 36.5 so 136.98. So full price is 136.98 x 100.

And therefore 50% discount makes that years total £6,849; 25% off the year after makes is £10,274

Ignore my last line. Somehow I typed a completely wrong random number.....the other calculation is correct.

That's a great discount BTW, what's it for? 😁

This answer explains it well.

I think the formula you need is
(5000 / (100 - 63.5)) x 100

Or
(Discounted price in £ / (100 - discount %)) x 100

and for Excel =(5000/(100-63.5))*100

I think, I rarely need to use formulae

You are adding 63.5% to the 5000 rather than calculating the original - 63.5% to be 5000

Makes sense