MHB Percentage problem - which is probably really simple

  • Thread starter Thread starter tubbyfej
  • Start date Start date
AI Thread Summary
The discussion revolves around the confusion between two methods of calculating net figures from a gross total when VAT is involved. Dividing the gross amount by 1.2 effectively calculates the net amount by accounting for the VAT included in the gross figure, resulting in a net value of £91.96. In contrast, calculating 20% of the gross and subtracting it leads to an incorrect net value of £88.28, as this method does not account for the fact that the VAT is already included in the gross total. The discrepancy arises because dividing by 1.2 gives 83.33% of the gross, not 80%, which is why the two methods yield different results. Understanding when to use each method is crucial, particularly in financial contexts involving VAT calculations.
tubbyfej
Messages
2
Reaction score
0
Hi,

I just need to say in advance that I know my problem is probably quite simple but for some reason I have completely confused myself with this and now I need someone to explain the logic behind it as it's driving me insane and I can't continue on with my work until I have the answer:

I'm trying to calculate the balance on an account - I work in accounts - and I am inputting the VAT value - which is 20% of the gross figure.

Gross total: £110.35
VAT: 18.35
Net: 91.96 (round to 2.dp)

The percentage problem:

To calculate the net figure I need to remove 20% of VAT from the gross total.

Usually I would divide by 1.2:

110.35 / 1.2 = 91.958333 which rounded up = 91.96

The confusion:

As I understand it when I divide the gross figure by whole number of 1 with decimal of 0.20 (1.2) this removes 20% from the figure of 110.35

What I don’t understand is when I try to remove 20% by multiplying 110.35 by 0.2 and the subtracting this from gross figure I get a completely different Net value.

i.e.

I Calculate 20% of 110.35

20/100 x 110.35 = 22.07 Then subtract this from 110:35

110.35 - 22.07 = 88.28

Why does dividing by 1.2 give a completely different answer to simply working out the percentage of the gross number and subtracting that from it.

From my understanding on both occasions I am removing 20% of the number.

But the methods give completely different answers.

Sorry if this is long winded but any help would be much appreciated

Thanks

Fi
 
Mathematics news on Phys.org
tubbyfej said:
Hi,

I just need to say in advance that I know my problem is probably quite simple but for some reason I have completely confused myself with this and now I need someone to explain the logic behind it as it's driving me insane and I can't continue on with my work until I have the answer:

I'm trying to calculate the balance on an account - I work in accounts - and I am inputting the VAT value - which is 20% of the gross figure.

Gross total: £110.35
VAT: 18.35
Net: 91.96 (round to 2.dp)

The percentage problem:

To calculate the net figure I need to remove 20% of VAT from the gross total.

Usually I would divide by 1.2:

110.35 / 1.2 = 91.958333 which rounded up = 91.96

The confusion:

As I understand it when I divide the gross figure by whole number of 1 with decimal of 0.20 (1.2) this removes 20% from the figure of 110.35

What I don’t understand is when I try to remove 20% by multiplying 110.35 by 0.2 and the subtracting this from gross figure I get a completely different Net value.

i.e.

I Calculate 20% of 110.35

20/100 x 110.35 = 22.07 Then subtract this from 110:35

110.35 - 22.07 = 88.28

Why does dividing by 1.2 give a completely different answer to simply working out the percentage of the gross number and subtracting that from it.

From my understanding on both occasions I am removing 20% of the number.

But the methods give completely different answers.

Sorry if this is long winded but any help would be much appreciated

Thanks

Fi

subtraction 20% is same as finding 80% of the same or multiplying by .80

deviding by 1.2 is not same as \finding 80% you get 100/1.2 = 83.3 %

hence there is discripency
 
Hi kaliprasad,

Thanks for the response! But I am still confused!

When excluding VAT i.e reducing by 20% - it is common practice to divide by 1.2 - please see UK Government website:

https://www.gov.uk/vat-businesses/inclusive-exclusive-prices

If this method actually give 83.3% of the gross figure and not the 80% as you would expect, then why is it used?

I should also mention that I am using VAT as an example but I have seen this approach of reducing a number by a percentage by dividing it using the (1.xx) approach.

I am confused as to when it appropriate to use which method.

Method A:
Calculate the percentage of the number - then subtract from the number - (this seems the most logical to me)

Method B:
Divide (or multiply) the number by 1.xx to Reduce (or add on) the percentage amount.

You've explained why there is a discrepancy but I just want to know why the two different methods are used for effectively adding or subtracting a percentage.

And how do you know when to apply which method?

Thanks
 
Suppose ,instead of the usual x,y coordinate system with an I basis vector along the x -axis and a corresponding j basis vector along the y-axis we instead have a different pair of basis vectors ,call them e and f along their respective axes. I have seen that this is an important subject in maths My question is what physical applications does such a model apply to? I am asking here because I have devoted quite a lot of time in the past to understanding convectors and the dual...
Fermat's Last Theorem has long been one of the most famous mathematical problems, and is now one of the most famous theorems. It simply states that the equation $$ a^n+b^n=c^n $$ has no solutions with positive integers if ##n>2.## It was named after Pierre de Fermat (1607-1665). The problem itself stems from the book Arithmetica by Diophantus of Alexandria. It gained popularity because Fermat noted in his copy "Cubum autem in duos cubos, aut quadratoquadratum in duos quadratoquadratos, et...
Insights auto threads is broken atm, so I'm manually creating these for new Insight articles. In Dirac’s Principles of Quantum Mechanics published in 1930 he introduced a “convenient notation” he referred to as a “delta function” which he treated as a continuum analog to the discrete Kronecker delta. The Kronecker delta is simply the indexed components of the identity operator in matrix algebra Source: https://www.physicsforums.com/insights/what-exactly-is-diracs-delta-function/ by...
Back
Top