| 12 Months |
|
|
|
|
|
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
2004 |
|
|
| to end
Dec |
|
|
|
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
|
|
| ASSUMPTIONS No. 7 -
INPUT & OUTPUT TAXES |
|
|
|
|
|
| Set
all values in this report to zero if input/output taxes are not relevant or
significant, e.g. for a business based in USA. |
|
|
|
| Change
description of input/output tax (e.g. "Sales tax", "VAT",
"GST" etc.) via menu option for *Setup | Enter Basic Model Info ... |
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Average
Sales Tax rates on sales (%): |
|
->> |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
5.0 |
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 |
1.3 |
1.4 |
1.4 |
1.5 |
1.5 |
1.6 |
|
|
| |
|
|
|
|
|
| Calculate
Sales Tax on an invoice (enter 0) |
|
|
|
|
| or cash-received (enter 1) basis ? |
|
->> |
|
|
<< Enter 0 or 1 |
|
|
|
| |
|
|
Enter "1" for
each payment month, otherwise leave blank |
|
|
|
|
|
|
|
| Mark
months when Sales Tax paid to State |
->> |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Average
Sales Tax rate for purchases of |
|
Set assumption cells below to zero
if input taxes are not relevant |
|
|
|
|
|
|
|
|
|
|
|
|
| materials/packaging & goods (%) |
|
->> |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
20.0 |
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Percent
of all other non-payroll expenses |
|
Set assumption cells below to zero
if input taxes are not relevant |
|
|
|
|
|
|
|
|
|
|
|
|
| (operating exs etc) subject to Sales Tax (%) |
->> |
90.0 |
90.0 |
90.0 |
90.0 |
90.0 |
90.0 |
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, lease repayments |
|
Set assumption cells below to zero
if input taxes are not relevant |
|
|
|
|
|
|
|
|
|
|
|
|
| and interest subject to Sales Tax (%) |
|
->> |
80.0 |
80.0 |
80.0 |
80.0 |
80.0 |
80.0 |
80.0 |
80.0 |
80.0 |
80.0 |
80.0 |
80.0 |
|
|
| Average
Sales Tax rate for these items (%) |
->> |
|
|
|
|
| Sales
Tax on capex & leases less disposals($000) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Supplementary Data &
Calculations: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|