Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A common tax scenario
Message
From
23/05/2012 13:23:33
Al Doman (Online)
M3 Enterprises Inc.
North Vancouver, British Columbia, Canada
 
 
To
23/05/2012 09:07:06
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:
01544161
Views:
31
>>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 )
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform