20250304Exhibits 1-4.pdf

This document was exported from Numbers. Each table was converted to an Excel worksheet.All other objects
on each Numbers sheet were placed on separate worksheets. Please be aware that formula calculations may
differ in Excel.
Numbers Sheet Name Numbers Table Name Excel Worksheet Name
Table 1 Exhibit 1. Schedule A
Table 1 Exhibit 1, Schedule
Table 1 Exhibit 1, Schedule B
Table 1 Exhibit 1, Schedule C
Table 1 Exhibit 2, Schedule A
Table 1 Exhibit 2, Schedule B
Table 1 Exhibit 2, Schedule C
Table 1 Exhibit 3
Table 1 Exhibit 4
1

RATE BASE(SCHEDULE"A"ACCOUNT 101 PLANT IN SERVICE)
Company Name: TIC Utilities LLC(The Idaho Club)
Idaho PUC Case Number: 554
Test Year ended: 2024
(A) (B) (C)
Plant in Service(Annual Report, pg. 5) Known Pro Forma
ACCT# DESCRIPTION Actual Changes* (A+ B)
1 301 Organization
2 302 Franchises and Consents
3 303 Land &Land Rights
4 304 Structures and Improvements 208,501.67 208,501.67
5 305 Collecting&Impounding Reservoirs
6 306 Lake, River&Other Intakes
7 307 Wells 123,779.56 123,779.56
8 308 Infiltration Galleries&Tunnels
9 309 Supply Mains
10 310 Power Generation Equipment
11 311 Power Pumping Equipment 193,056.01 193,056.01
12 320 Purification Systems 430,732.76 430,732.76
13 330 Distribution Reservoirs&Standpipes
14 331 Trans. &Distrib. Mains&Accessories
15 333 Services(IDEQ Facilities Plan) 40,000.00 40,000.00
16 334 Meters and Meter Installations 43,615.55 43,615.55
17 335 Hydrants
18 336 Backflow Prevention Devices
19 339 Other Plant&Misc. Equipment 12,366.20 12,366.20
20 340 Office Furniture and Equipment
21 341 Transportation Equipment
22 342 Stores Equipment
23 343 Tools, Shop and Garage Equipment
24 344 Laboratory Equipment
25 345 Power Operated Equipment
26 346 Communications Equipment
27 347 Miscellaneous Equipment
28 348 Other Tangible Property
29 TOTAL PLANT IN SERVICE 968,436.20 83,615.55 1,052,051.75
(Add lines 1 -28)
*Attach detailed explanations and calculations showing
the development of each"Known Change"to the test
year data.
Exhibit No. 1
Schedule A
1

RATE BASE(SCHEDULE"B"ACCUMULATED DEPRECIATION)
Company Name: TIC Utilities LLC(The Idaho Club)
Idaho PUC Case Number: 554
Test Year ended: 2024
Accumulated Depreciation (Annual Report, pg.6) (A) (B) (C)
Known Pro Forma
ACCT# DESCRIPTION Actual Changes* (A+B)
1 304 Structures and Improvements
2 305 Collecting&Impounding Reservoirs
3 306 Lake, River&Other Intakes
4 307 Wells
5 308 Infiltration Galleries&Tunnels
6 309 Supply Mains
7 310 Power Generation Equipment
8 311 Power Pumping Equipment
9 320 Purification Systems
10 330 Distribution Reservoirs&Standpipes
11 331 Trans.&Distrib. Mains&Accessories
12 333 Services
13 334 Meters and Meter Installations
14 335 Hydrants
15 336 Backflow Prevention Devices
16 339 Other Plant&Misc. Equipment
17 340 Office Furniture and Equipment
18 341 Transportation Equipment
19 342 Stores Equipment
20 343 Tools, Shop and Garage Equipment
21 344 Laboratory Equipment
22 345 Power Operated Equipment
23 346 Communications Equipment
24 347 Miscellaneous Equipment
25 348 Other Tangible Property
26 TOTALS(Add Lines 1 -25) 218,727.57 46,783.00 265,510.57
*Attach detailed explanations and
calculations showing the development
of each"Known Change"to the test
year data.
Exhibit No. 1
Schedule B
1

RATE BASE(SCHEDULE"C"SUMMARY)
Company Name: TIC Utilities LLC(The Idaho Club)
Idaho PUC Case Number: 554
Test Year ended: 2024
(A) (B) (C)
Test Year Known Pro Forma
Actual Changes* (A+ B)
1 Total Plant in Service(Ex 1, Sch A, line 29) 968,436.20 83,615.55 1,052,051.75
2 Accumulated Depreciation (Ex 1, Sch B, line 26) 265,510.57 265,510.57
3 Net Plant in Service(Line 1 less line 2) 702,925.63 83,615.55 786,541.18
4 Add Utility Plant Acquisition Adjustment**
(Annual Report page 7, line 5)
5 Add Materials&Supplies Inventories
(Annual Report page 7, line 22)
6 Less Accum Amortization Util Plant Acq Adj**
(Annual Report page 7, line 12)
7 Less Customer Advances for Construction
(Annual Report page 8, line 22)
8 Less Contributions in Aid of Construction
(Annual Report page 8, line 27)
9 Add Working Capital (1/8 Operating Expenses)
(Exhibit No. 2, Sch B, line 22/8)
10 Add Deferred Charges(If any, attach detail)
(Annual Report page 7, lines 29&30)
ADJUSTMENT FOR NON-DEVELOPER PROPERTIES 76.97% 605,400.75
11 TOTAL RATE BASE 702,925.63 605,400.75
*Attach detailed explanations and calculations
showing the development of each"Known Change"
to the test year data.
**Only if Commission approved.
Exhibit No. 1
Schedule C
1

OPERATING RESULTS(SCHEDULE"A"REVENUES)
Company Name: TIC Utilities LLC(The Idaho Club)
Idaho PUC Case Number: 554
Test Year ended: 2024
(A) (B) (C)
Test Year Known Pro Forma
(See Annual Report page 3) Actual Changes* (A+ B)
Water Revenues:
1 Unmetered 127,583.50 127,583.50
2 Metered-Residential
3 Metered-Commercial&Industrial
4 Fire Protection Revenue
5 Other Water Sales Revenue
6 Irrigation Sales Revenue
7 Sales for Resale
8 Total Water Revenue(Add lines 1 -7)
9 DEQ Fees billed separately to customers
10 Hook-up or Connection Fees collected 455.50 455.50
11 Commission-approved Surcharges collected
12 TOTAL REVENUE(Add lines 8- 11) 128,039.00 128,039.00
*Attach detailed explanations and calculations
showing the development of each"Known Change"
to the test year data.
Exhibit No. 2
Schedule A
1

OPERATING RESULTS (SCHEDULE"B" EXPENSES)
Company Name: TIC Utilities LLC (The Idaho Club)
Idaho PUC Case Number: 554
Test Year ended: 2024
(A) (B) (C)
Test Year Known Pro Forma
(See Annual Report page 3) Actual Changes" (A+ B)
1 Labor-Operation &Maintenance 23,818.44 23,818.44
2 Labor-Customer Accounts
3 Labor-Administrative&General 4,825.76 4,825.76
4 Salaries-Officers& Directors 48,000.00 48,000.00
5 Employee Pensions&Benefits
6 Purchased Water
7 Purchased Power& Fuel for Power 22,671.25 22,671.25
8 Chemicals
9 Materials&Supplies-Operation & Maintenance 111,178.52 111,178.52
10 Materials&Supplies-Admin &General 1,063.72 1,063.72
11 Contract Services-Professional 16,881.69 16,881.69
12 Contract Services-Water Testing
13 Rentals-Property&Equipment
14 Transportation Expense
15 Insurance 2,511.95 2,511.95
16 Advertising
17 Rate Case Expense(Amortization)
18 Regulatory Comm. Exp. (Other Except Taxes)
19 Bad Debt Expense
20 Miscellaneous Expenses/Property Taxes 1,085.00 1,900.00 2,985.00
21 TOTAL OPERATING EXPENSES 184,036.33 49,900.00 233,936.33
"Attach detailed explanations and calculations
showing the development of each "Known
Change"to the test year data.
Exhibit No. 2
Schedule B
1

OPERATING RESULTS(SCHEDULE"C" INCOME STATEMENT)
Company Name: TIC Utilities LLC(The Idaho Club)
Idaho PUC Case Number: 554
Test Year ended: 2024
(A) (B) (C)
Test Year Known Pro Forma
Actual Changes* (A+B)
1 Revenue(From Ex.2,Sch A) 128,039.00 128,039.00
2 Operating Expenses(From page 3, line 33) 184,036.33 49,900.00 233,936.33
3 Depreciation Expense 46,783.00 46,783.00
4 Amortization, Utility Plant Acquisition Adj.
5 Amortization Exp.-Other
6 Regulatory Fees(PUC)
7 Property Taxes
8 Payroll Taxes
9A Other Taxes(list) DEQ Fees
9B
9C
9D
10 Federal Income Taxes
11 State Income Taxes
12 Provision for Deferred Income Tax-Federal
13 Provision for Deferred Income Tax-State
14 Provision for Deferred Utility Income Tax Credits
15 Investment Tax Credits-Utility
16 Total Expenses from Operations before interest(Add lines 2 230,819.33 49,900.00 280,719.33
17 Income from Utility Plant Leases to Others
18 Gains(Losses)from Disposition of Utility Plant
19 Net Operating Income(Add lines 1, 17&18 less line 16) -102,780.33 -49,900.00 -152,680.33
201 Revenues, Merchandizing,Jobbing&Contract Work
21 Expenses, Merchandizing,Jobbing&Contracts
22 Interest&Dividend Income
23 Allowance for funds used during construction
24 Miscellaneous Non-Utility Income
25 Miscellaneous Non-Utility Expense
26 Other Taxes, Non-Utility Operations
27 Income Taxes, Non-Utility Operations
28 Net Non-Utility Income(Add lines 20,22,23,&24
less lines 21,25,26&27)
29 Gross Income(Add lines 19&28) -102,780.33 -49,900.00 -152,680.33
30 Interest Exp. On Long-Term Debt
31 Other Interest Charges
32 NET INCOME(Line 29 less lines 30&31) -102,780.33 -49,900.00 -152,680.33
*Attach detailed explanations and calculations
showing the development of each"Known Change"
to the test year data.
Exhibit No.2
Schedule C
1

COST OF CAPITAL AND RATE OF RETURN
Company Name: TIC Utilities LLC(The Idaho Club)
Idaho PUC Case Number: 554
Test Year ended: 2024
(A) (B) (C) (D)
Amount %of Total Cost Weighted
Outstanding Outstanding of Cost
(Column A/ Capital (Column B X
Total Line 6) Column C)
1 Common Equity(Proprietor Capital Paid In) 785,771.80
21 Retained Earnings 31,885.95
3 Total Common Equity(Proprietor Capital)Line 1 + Line 2 817,657.75 100% 12% 12%
4
5 Long-Term Debt
6 Total Capital 817,657.75
7 Weighted Cost of Capital (Rate of Return Required) 12%
(Line 3+5)
Exhibit No. 3
1

REVENUE REQUIREMENT
Company Name: TIC Utilities LLC(The Idaho Club)
Idaho PUC Case Number: 544
Test Year ended: 2024
(A) (B) (C)
Test Year Known Pro Forma
Actual Changes (A+B)*ADJ
1 Rate Base(Ex. 1, Sch C, line 11)(NOTE 1) 702,925.63 83,615.55 605,400.75
2 Required Rate of Return (Ex. 3, line 7) 12% 12%
3 Income Required (Line 1 x Line 2) 84,351.08 72,648.09
4 Income Realized (Ex.2, Sch C, line 29) -102,780.33 -49,900.00 -152,680.33
5 Income Deficiency(Line 3 less Line 4) 187,131.41 225,328.42
6 Revenue to Overcome Losses 152,680.33
7 Regulatory Fees Gross up 504.54
8 Revenue Needed to Overcome Loss 153,184.87
9 Net Operating Income Required 72,648.09
10 Gross Up Factor 11.346594
11 Revenue Requirement for Net Income 97,827.50
12 Revenues at Existing Rates 0.00
13 Total Revenue Requirement 251,012.37
14 Percent Increase Required
Net to Gross Multiplier
15 Total Gross Revenues 11.000000
16 Less Regulatory Fees(percentage) 0.001982
17 State Income Tax Rate 5.80% 0.058000
18 Total Expenses 0.059982
19 Federal Income Tax Base 0.940018
20 Federal Income Tax Rate 21% 0.197404
21 Net Operating Revenue 0.74261422 0.742614
22 Net Income to Gross Revenue Multiplier 1.34659419799 1.346594
NOTE 1: ADJUSTMENT FOR NON-DEVELOPER PROPERTIES=76.97%
Exhibit No.4
1