Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A common tax scenario
Message
From
23/05/2012 14:07:50
 
 
To
23/05/2012 13:23:33
Al Doman (Online)
M3 Enterprises Inc.
North Vancouver, British Columbia, Canada
General information
Forum:
ASP.NET
Category:
Other
Environment versions
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01544104
Message ID:
01544176
Views:
39
>>>I see others have given the answer.
>>>
>>>I just wanted to point out that a government imposing a tax on another tax is one of the scummiest things it can do. But, your calculation example is correct: http://www.revenuquebec.ca/en/entreprise/taxes/tvq_tps/default.aspx
>>
>>Well, I am analyzing the replies to this thread and, so far, the closest one is from Andrew. But, it gives 500.03$ instead of 500.00$. I have been asking myself if this is possible. Because, of the problem of one tax over another. You pointed that out in your reply. I agree with that.
>
>Re: the calculation, I'd just back out the values in the reverse order they were originally calculated.
>
>If you start with total value $574.88 (actually $575.875), that is 1.095 * ( Price + FedTax ), so
>
>( Price + FedTax ) = 574.88 / 1.095, = 525.00
>
>Then, ( Price + FedTax ) = Price * 1.05, so
>
>Price = ( Price + FedTax ) / 1.05, = 525.00 / 1.05, = 500.00
>
>If you want to do it all in one step:
>
>T = total dollar value including all taxes
>P = provincial tax rate as a decimal e.g. 9.5% = 0.095
>F = federal tax rate as a decimal e.g. 5% = 0.05
>I = item price
>
>Then I = ( T / ( 1 + P ) ) / ( 1 + F )


You cannot do it in one step - even if you had the total value including all taxes, since each tax calculation is rounded to 2 decimals
Gregory
Previous
Reply
Map
View

Click here to load this message in the networking platform