Grossed-up Tax

chesney-lowe

New Member
Joined
Aug 24, 2003
Messages
1
Hello,
I need a formula to Gross up the value of Gift Vouchers to keep the Inland Revenue happy. It is for people on 40% tax or 22% tax.

I have a formula but do not know how to translate it into Excel.
The formula is:
Grossed-up Tax Value = Voucher value*100/60 (40%)
Voucher value*100/78 (22%)

Tax VoucherValue Grossed-up Value

40 £50 formula ?

Thanking you in anticipation,
E Chesney-Lowe
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
What do you want , add the gross up value of people on 40% tax and 22% tax or choose one of the formula based on what criteria?
 
Upvote 0
Hi

If A1 = Voucher value

B1 = A1*(100/60) for 40%

C1 = A1*(100/78) for 22%

Hope this helps

Cricketer
 
Upvote 0
Since you did not give the criteria on who will be tax at 40% and 22%, then cricketer formula will do or a simple
For 40% tax
=a1/.60

For 22% tax
=a1/.78
 
Upvote 0
Hi Chesney-Lowe:

Welcome to MrExcel Board!

Unless I am missing something here, my understanding is that the VoucherPrice is before taxes price, and the GrossedUpVoucherPrice is the AfterTaxes Price. If this is the case, then you may find the following of some interest ...
y030824h1.xls
ABCD
1(Purchase)Tax(AfterTaxes)formula
2NetPriceRateGrossPrice
35040%70=$A3*(1+$B3)
410040%140=$A4*(1+$B4)
55022%61=$A5*(1+$B5)
610022%122=$A6*(1+$B6)
Sheet5


If I have misunderstood the question -- my apologies!
 
Upvote 0
& just as another alternative...

go to insert | name | define. define 'high_rate' as

=0.4

and low_rate as

=0.22

...& use them in formulas of the form:

=amount*(1+high_rate)

or whatever. advantage of this approach is that, when rates change, you only have to update the named formula to apply the rate change globally. Admittedly, if you put the rates in a single cell, you'd only have to change the value in the cell to get the same effect, but this way the formulas are a little more transparent.
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,148
Members
448,552
Latest member
WORKINGWITHNOLEADER

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top