| 6 Months |
|
|
|
|
|
2005 |
2005 |
2005 |
2005 |
2005 |
2005 |
|
|
| to end Jul |
|
|
|
Feb |
Mar |
Apr |
May |
Jun |
Jul |
|
|
| MONTHLY
ASSUMPTIONS No. 8 - SALES & RELATED TAXES |
|
|
|
| Set
cells below to zero if sales taxes (or similar taxes) are not applicable |
|
|
|
|
| |
|
|
|
|
|
| Specify
descriptive term for sales or input/output tax: |
|
Sales tax |
Press F9 to update |
|
|
|
| e.g. enter "Sales Tax",
"GST" for Goods & Services Tax, "VAT" for Value Added
Tax etc. |
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
| Average
Sales tax rates on sales (%): |
|
|
->> |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
|
|
| |
|
|
|
|
|
|
|
|
|
| Total
Sales tax on sales ($000) |
|
1.1 |
1.1 |
1.2 |
1.2 |
1.3 |
1.3 |
|
|
| |
|
|
|
|
|
| Calculate
Sales tax on an invoice (enter 0) |
|
|
|
|
| or cash-received (enter 1) basis ? |
|
->> |
|
Enter 0 or 1 |
|
|
|
| |
|
Enter "1" for
each payment month |
|
|
|
|
|
| Mark
months when Sales tax paid to State |
|
|
->> |
1 |
1 |
1 |
1 |
1 |
1 |
|
|
| |
|
|
|
|
|
|
|
|
|
|
| Average
Sales tax rate for purchases of |
|
|
|
|
|
|
|
|
|
| materials/packaging & goods (%) |
|
|
->> |
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| Percent of all other
non-payroll expenses |
|
|
|
|
|
|
|
|
|
| (operating exs etc) subject to Sales tax
(%) |
|
->> |
90.0 |
90.0 |
90.0 |
90.0 |
90.0 |
90.0 |
|
|
| Average
Sales tax rate for non-payroll exs (%) |
|
->> |
|
|
|
|
| Total
Sales tax on non-payroll expenses ($000) |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
| Percent of capital expenditure
and |
|
|
|
|
|
|
|
|
|
| disposals subject to Sales tax (%) |
|
|
->> |
80.0 |
80.0 |
80.0 |
80.0 |
80.0 |
81.0 |
|
|
| Average
Sales tax rate for these items (%) |
|
|
->> |
|
|
|
|
| Sales
tax on capex less disposals($000) |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Supplementary Data &
Calculations: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|