Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Compute VAT; formula, Access/VBA library

Posted on 1997-06-11
9
Medium Priority
?
1,859 Views
Last Modified: 2008-02-26
Does anyone know VAT formula or can tell me where i can find Access/VBA library for  VAT formula. In Europe and Canada, they use VATand can be up to 10 VATs.
Let say, given: qty=1, Price=$100.00, Amount= qty * Price = 1 * 100.00, where:      " * "  means multiplication.
 Compute each tax and Total  VAT if:
 Sales tax=3.00%, Province tax=3.00%, County tax=1.5%, City tax=1.5%, Government tax=2.00%.

Thanks in advance to all..
0
Comment
Question by:pisoft
9 Comments
 

Author Comment

by:pisoft
ID: 1602823
Edited text of question
0
 

Author Comment

by:pisoft
ID: 1602824
Adjusted points to 100
0
 
LVL 3

Expert Comment

by:Bogey
ID: 1602825
The calculation is simply the PRICE times the product of each tax.

In you example:

PRICE * (1.03 x 1.03 x 1.015 x 1.015 x 1.02) = TOTAL

If you prefer just the actual TAX amount, TAX = TOTAL - PRICE




0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 

Author Comment

by:pisoft
ID: 1602826
Bogey, Quebec does not compute it that way as well as other European countries. You computed it just like US SAles tax.
0
 
LVL 13

Expert Comment

by:akb
ID: 1602827
VAT = Price * 0.11482501655 or 11.482501655% (I think).
Actually I wouldn't have a clue but this numer seems to make sence!
0
 
LVL 2

Expert Comment

by:Philippe
ID: 1602828

Pisoft,

Unless your question is not well formulated, the answer is easy.

To calculate the total tax add up all taxes and multiply the result by the original price:

Let's suppose you have the tax in percent as in
T1 = 15 (15% state tax), T2 = 12 (12% county tax), T3 = 5 (5% bozo tax)

total = price * (T1+T2+T3+100)/100

Each single tax is

Tax1 = price * (T1+100)/100, Tax2 = price * (T2+100)/100, etc.

Hope this helps,

 Philippe

0
 
LVL 2

Expert Comment

by:Philippe
ID: 1602829

Pisoft,

could you comment on why you rejected the answer. It is not easy for us to help us if you don't give us more detailed information.

 cheers,

  Philippe

0
 

Author Comment

by:pisoft
ID: 1602830
I am looking for a Quebec and German VAT type of formula. The formula that I see are all standard sales tax formula as in the United States taxation. In the US, we have Tax Codes and we just add them. Not in Quebec, Not in Germany.
0
 

Accepted Solution

by:
mdl052397 earned 200 total points
ID: 1602831
Dear Pisoft,

As my main occupation is adminstrative s/w for Belgium and France, I know fairly well the VAT system. In Belgium you have the following VAT rates : 6%, 12%, 18%, 21% (applied for most products) and 33%

VAT is calculated on the net price, so after all other reductions were deducted.

ex:        base price                           1000,-
             sales reduction 10%            -100,-
             net price                               900,-
             VAT 21%                              189,-
             amount to pay                     1089,-

I never heard of libraries specifically treating this stuf, and I don't think they exist, as the calculation is fairly easy. Or I didn't understand your question well.

kind regards,

mdl
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
I came across an unsolved Outlook issue and here is my solution.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question