LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
viz
 
Posts: n/a
Default Quarterly tax percentages

Must be getting old - can't work this one out... :(

Want to calculate a weekly PAYG (pay as you go) tax, based on a variable
quarterly tax percentage...

1st Quarter PAYG tax percantage 12.74%
2nd Quarter PAYG tax percentage 13.12%
3rd Quarter PAYG tax percentage 13.12%
4th Quarter PAYG tax percentage 18.10%

Examples:

Pay Date Total Weekly Sales PAYG
30/11/2004 2,257.40 296.17
17/05/2005 2,574.58 466.00
07/06/2005 3,180.21 575.62

So when I enter the "Total Sales" figure, the formula matches the Pay Date
to the appropriate quarterly PAYG tax percentage, multiplies the Total Sales
by that percentage and puts it under PAYG.

I hope that this is clear enough - I used to be able to do this at the drop
of a hat, but now either the brain has slowed down or I have not had enough
practice (probably both!).

TIA

/viz

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating percentages in pivot tables on subtotals David Ruderman - Chapman University Excel Worksheet Functions 1 November 24th 05 04:54 PM
Calculating Percentages tifosi3 Excel Discussion (Misc queries) 7 July 11th 05 08:42 PM
quarterly reports David Excel Discussion (Misc queries) 1 February 11th 05 12:05 AM
quarterly reports David Excel Worksheet Functions 0 February 11th 05 12:01 AM
Calculating Percentages with Variables tssjhs Excel Worksheet Functions 1 January 28th 05 01:27 AM


All times are GMT +1. The time now is 06:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"