HomeMy WebLinkAbout20050211Exhibit 3 Sch 3 Individual OPEX.xlsFUTA Tax P 4 of 4
SUTA Tax P. 3 of 4
FICA Tax P. 2 of 4
Property Tax P. 1 of 4
UNITED WATER IDAHO
Calculation of Real and Personal
Property Taxes
Line
No.
Description
Amount
1.
2.
To adjust the amount of Property Tax expense
Details
3.
4.
5.
6.
7.
8.
Test Year Expense
9.
Adjustment
J. Healy
Schedule 3
Details of Adjustments to
Payroll Taxes
At Present Rates
To adjust Employer FICA Tax Liability
FICA
Medicare
Combined
No Limit
Wages in Excess of FICA base
Taxable Wages
FICA Tax Rates
Pro Forma FICA Tax
10.
Idaho Taxable Base
Idaho U C Tax Rate
Employees covered by U.C. Tax
Taxable Base
Tax Rate
Pro Forma Idaho Unemployment Tax
Exhibit No. 3
Page 4 of 4
Page 3 of 4
Page 2 of 4
Page 1 of 4
July 31, 2004
Adjustment No. 40
Adjust Property Tax Expense
based 6-year average increase applied to tax expense
Estimated Property Tax Bill for 2004 for utility property in Ada
& Canyon County
Average annual expense increase over past six years experience
Estimated 2005 Property Tax Expense
Pro Forma Level of Property Tax Expense
FICA Base for 2005
FICA Rate for 2005
Pro Forma Payroll at 2005 Rates
Adjustment No. 41
To adjust State Unemployment Insurance Tax
(91 @ $29,500 less under limit wages $22,177
plus temps $52,837)
Adjustment No. 42
Adjustment No. 43
To adjust Federal Unemployment Insurance Tax
Federal Taxable Base
Federal Tax Rate
Employees covered by Federal Unemployment Tax
(91 @ $7,000 plus temps $50,061)
Pro Forma Federal Unemployment Tax
$383.49
$7,000.00
8.00E-03
$687,061.00
91.00
7000.00
50061.00
$687,061.00
8.00E-03
$5,496.49
$5,113.00
$383.49
$469.32
$29,500.00
2.00E-03
$2,715,160.00
91.00
29500.00
52837.00
22177.00
$2,715,160.00
2.00E-03
$5,430.32
$4,961.00
4734.00
227.00
$469.32
$29,424.90
$90,000.00
0.06
0.01
$4,539,028.00
$4,539,028.00
$95,012.00
0.00
$4,444,016.00
$4,539,028.00
0.06
0.01
$275,528.99
$65,815.91
$341,344.90
$311,920.00
$29,424.90
$42,245.47
$1,504,445.00
0.04
$1,570,941.47
1.04
$1,528,696.00
$42,245.47