Loading...
HomeMy WebLinkAbout20220329Annual Report & Exhibits 1-4 - revised.xlsExhibit 4.1 Exhibit 4 Exhibit 3 Exhibit 2 Schedule C Exhibit 2 Schedule B Exhibit 2 Schedule A Exhibit 1 Schedule C Exhibit 1 Schedule B Exhibit 1 Schedule A Annual Report complete ACCT # DESCRIPTION Organization Franchises and Consents Land & Land Rights Structures and Improvements Collecting & Impounding Reservoirs Lake, River & Other Intakes Wells Infiltration Galleries & Tunnels Supply Mains Power Generation Equipment Power Pumping Equipment Purification Systems Distribution Reservoirs & Standpipes Trans. & Distrib. Mains & Accessories Services Meters and Meter Installations Hydrants Backflow Prevention Devices Other Plant & Misc. Equipment Office Furniture and Equipment Transportation Equipment Stores Equipment Tools, Shop and Garage Equipment Laboratory Equipment Power Operated Equipment Communications Equipment Miscellaneous Equipment Other Tangible Property TOTAL PLANT IN SERVICE (Add lines 1 - 28) RATE BASE (SCHEDULE "A" ACCOUNT 101 PLANT IN SERVICE ) Company Name: Idaho PUC Case Number: Test Year ended: Plant in Service (Annual Report, pg. 5) (A) Actual (B) Known Changes* (C) Pro Forma (A + B) the development of each "Known Change" to the test year data. Exhibit No. 1 Schedule A *Attach detailed explanations and calculations showing TOTALS (Add Lines 1 - 25) RATE BASE (SCHEDULE "B" ACCUMULATED DEPRECIATION) Accumulated Depreciation (Annual Report, pg. 6) *Attach detailed explanations and calculations showing the development of each "Known Change" to the test Schedule B Total Plant in Service (Ex 1, Sch A, line 29) Accumulated Depreciation (Ex 1, Sch B, line 26) Net Plant in Service (Line 1 less line 2) RATE BASE (SCHEDULE "C" SUMMARY) Test Year Add Utility Plant Acquisition Adjustment** (Annual Report page 7, line 5) Add Materials & Supplies Inventories (Annual Report page 7, line 22) Less Accum Amortization Util Plant Acq Adj** (Annual Report page 7, line 12) Less Customer Advances for Construction (Annual Report page 8, line 22) Less Contributions in Aid of Construction (Annual Report page 8, line 27) Add Working Capital (1/8 Operating Expenses) (Exhibit No. 2, Sch B, line 22/8) (Annual Report page 7, lines 29 & 30) TOTAL RATE BASE * Attach detailed explanations and calculations ** Only if Commission approved. Schedule C Add Deferred Charges (If any, attach detail) showing the development of each "Known Change" to the test year data. (See Annual Report page 3) Water Revenues: Unmetered Metered-Residential Metered-Commercial & Industrial Fire Protection Revenue Other Water Sales Revenue Irrigation Sales Revenue Sales for Resale Total Water Revenue (Add lines 1 - 7) DEQ Fees billed separately to customers Hook-up or Connection Fees collected Commission-approved Surcharges collected TOTAL REVENUE (Add lines 8 - 11) Exhibit No. 2 * Attach detailed explanations and calculations showing the development of each "Known Change" OPERATING RESULTS (SCHEDULE "A" REVENUES) OPERATING RESULTS (SCHEDULE "B" EXPENSES) Labor-Operation & Maintenance Labor-Customer Accounts Labor-Administrative & General Salaries-Officers & Directors Purchased Water Purchased Power & Fuel for Power Chemicals Materials & Supplies-Operation & Maintenance Materials & Supplies-Admin & General Contract Services-Professional Contract Services-Water Testing Rentals-Property & Equipment Transportation Expense Insurance Advertising Rate Case Expense (Amortization) Regulatory Comm. Exp. (Other Except Taxes) Bad Debt Expense Miscellaneous Expenses TOTAL OPERATING EXPENSES Employee Pensions & Benefits showing the development of each "Known Change" to the test year data. OPERATING RESULTS (SCHEDULE "C" INCOME STATEMENT) Operating Expenses (From page 3, line 33) Depreciation Expense Amortization, Utility Plant Acquisition Adj. Regulatory Fees (PUC) Property Taxes Payroll Taxes 9A 9B 9C 9D Other Taxes (list) DEQ Fees Federal Income Taxes State Income Taxes Provision for Deferred Income Tax-Federal Provision for Deferred Income Tax-State Provision for Deferred Utility Income Tax Credits Investment Tax Credits-Utility Amortization Exp.-Other Income from Utility Plant Leases to Others Gains (Losses) from Disposition of Utility Plant Revenues, Merchandizing, Jobbing & Contract Work Expenses, Merchandizing, Jobbing & Contracts Interest & Dividend Income Allowance for funds used during construction Miscellaneous Non-Utility Income Miscellaneous Non-Utility Expense Other Taxes, Non-Utility Operations Income Taxes, Non-Utility Operations Net Non-Utility Income (Add lines 20, 22, 23, & 24 less lines 21, 25, 26 & 27) Gross Income (Add lines 19 & 28) Interest Exp. On Long-Term Debt Other Interest Charges NET INCOME (Line 29 less lines 30 & 31) Net Operating Income (Add lines 1, 17 &18 less line 16) Revenue (From Ex. 2, Sch A) Total Expenses from Operations before interest (Add lines 2 - 15) COST OF CAPITAL AND RATE OF RETURN Amount % of Total Cost (D) Weighted Outstanding of (Column A/ Capital Common Equity (Proprietor Capital Paid In) Retained Earnings Long-Term Debt Total Capital Weighted Cost of Capital (Rate of Return Required) Exhibit No. 3 (Column B X Column C) Total Common Equity (Proprietor Capital) Line 1 + Line 2 Changes Rate Base (Ex. 1, Sch C, line 11) Required Rate of Return (Ex. 3, line 7) Income Required (Line 1 x Line 2) Income Deficiency (Line 3 less Line 4) Exhibit No. 4 Income Realized (Ex. 2, Sch C, line 29) Rate Base Required Rate of Return Return on Investment Net Operating Income Realized Net Operating Income Deficiency Net Operating Loss Debt Cost on Rate base Deficiency Not Subject to Gross-up Factor Deficiency Subject to Tax Gross-up Factor Gross-up Factor Grossed-up Deficiency Total Revenue Deficiency Rate Case Expense Three Year Amortization Test Year Revenues at Current Rates Total Gross Revenue Requirement Gross-up Factor Calculation Net Deficiency PUC Fees Bad Debts State Tax @ 8% Federal Taxable Federal Tax @ 15% Net After Tax Net to Gross Multiplier Contract Services-Other Revenue Requirement and Gross Up Factor ANNUAL REPORT FOR WATER UTILITIES TO THE IDAHO PUBLIC UTILITIES COMMISSION FOR THE YEAR ENDING COMPANY INFORMATION Give full name of utility Date of Organization Organized under the laws of the state of Address of Principal Office (number & street) P.O. Box (if applicable) City State Zip Code Organization (proprietor, partnership, corp.) Towns, Counties served Are there any affiliated companies? (yes or no) If yes, attach a list with names, addresses & descriptions. Explain any services provided to the utility. Contact Information Name Phone No. President (Owner) Vice President Secretary General Manager Complaints or Billing Engineering Emergency Service Accounting Were any water systems acquired during the year or any additions/deletions made to the service area during the year? Where are the Company's books and records kept? Street Address Zip NAME: COMPANY INFORMATION (Cont.) For the Year Ended Is the system operated or maintained under a service contract? If yes: With whom is the contract? When does the contract expire? What services and rates are included? Is water purchased for resale through the system? Name of Organization Name of owner or operator Mailing Address Gallons/CCF $Amount Water Purchased Has any system(s) been disapproved by the Idaho Department of Environmental Quality? If yes, attach full explanation Has the Idaho Department of Environmental Quality recommended any improvements? Number of Complaints received during year concerning: Quality of Service High Bills Disconnection Number of Customers involuntarily disconnected Date customers last received a copy of the Summary of Rules required by IDAPA 31.21.01.701? Attach a copy of the Summary Did significant additions or retirements from the Plant Accounts occur during the year? If yes, attach full explanation and an updated system map REVENUE & EXPENSE DETAIL SUB ACCT 400 REVENUES 460 Unmetered Water Revenue 461.1 Metered Sales - Residential 461.2 Metered Sales - Commercial, Industrial 462 Fire Protection Revenue Other Water Sales Revenue Irrigation Sales Revenue Sales for Resale Total Revenue (Add Lines 1 - 7) (also enter result on Page 4, line 1) Booked to Acct # * DEQ Fees Billed separately to customers ** Hookup or Connection Fees Collected ***Commission Approved Surcharges Collected 401 OPERATING EXPENSES 601.1-6 Labor - Operation & Maintenance 601.7 Labor - Customer Accounts Labor - Administrative & General Salaries, Officers & Directors 615-16 618 620.1-6 Materials & Supplies - Operation & Maint. 620.7-8 Materials & Supplies - Administrative & General 631-34 Contract Services - Professional 635 Contract Services - Water Testing 636 Contract Services - Other 641-42 Rentals - Property & Equipment 656-59 Regulatory Comm. Exp. (Other except taxes) Miscellaneous Total Operating Expenses (Add lines 12 - 32, also enter on Pg 4, line 2) INCOME STATEMENT Revenue (From Page 3, line 8) Operating Expenses (From Page 3, line 33) Amortization, Utility Plant Aquisition Adj. Amortization Exp. - Other 408.10 408.11 408.12 408.13 Other Taxes (list) DEQ Fees 409.10 409.11 410.10 Provision for Deferred Income Tax - Federal 410.11 Provision for Deferred Income Tax - State 411 412 Investment Tax Credits - Utility Total Expenses from operations before interest (add lines 2-15) Income From Utility Plant Leased to Others Gains (Losses) From Disposition of Utility Plant Net Operating Income (Add lines 1, 17 &18 less line 16) Revenues, Merchandizing Jobbing and Contract Work Expenses, Merchandizing, Jobbing & Contracts Allowance for Funds used During Construction 408.20 409-20 Net Non-Utility Income (Add lines 20,22,23 & 24 less lines 21,25,26, & 27) Gross Income (add lines 19 & 28) Interest Exp. on Long-Term Debt NET INCOME (Line 29 less lines 30 & 31), (Also Enter on Pg 9, Line 2) ACCOUNT 101 PLANT IN SERVICE DETAIL Balance Added Removed Beginning During End of of Year Year (Add lines 1 - 28) Enter beginning & end of year totals on Pg 7, Line 1 ACCUMULATED DEPRECIATION ACCOUNT 108.1 DETAIL Depreciation Increase Rate or % (Decrease) TOTALS (Add Lines 1 - 25) Enter beginning & end of year totals on Pg 7, Line 7 BALANCE SHEET ASSETS Utility Plant in Service (From Pg 5, Line 29) Utility Plant Leased to Others Plant Held for Future Use Construction Work in Progress Utility Plant Aquisition Adjustment Subtotal (Add Lines 1 - 5) Accumulated Depreciation (From Pg 6, Line 26) Accum. Depr. - Utility Plant Lease to Others Accum. Depr. - Property Held for Future Use Accum. Amort. - Utility Plant in Service Accum. Amort. - Utility Plant Lease to Others Accumulated Amortization - Aquisition Adj. Net Utility Plant (Line 6 less lines 7 - 12) Investment in Subsidiaries Other Investments Total Investments (Add lines 14 & 15) Cash Short Term Investments Accts/Notes Receivable - Customers Other Receivables Receivables from Associated Companies Materials & Supplies Inventory Prepaid Expenses Unbilled (Accrued) Utility Revenue Provision for Uncollectable Accounts Total Current (Add lines 17 - 24, less line 25) Unamortized Debt Discount & Expense Preliminary Survey & Investigation Charges Deferred Rate Case Expenses Other Deferred Charges Total Assets (Add lines 13, 16 & 26 - 30) LIABILITIES & CAPITAL 201-3 Common Stock 204-6 Preferred Stock 207-13 Miscellaneous Capital Accounts Appropriated Retained Earnings Unappropriated Retained Earnings Reacquired Capital Stock Proprietary Capital Total Equity Capital (Add Lines 1-5+7 less line 6) 221-2 Bonds Advances from Associated Companies Other Long - Term Debt Accounts Payable Notes Payable Accounts Payable - Associated Companies Customer Deposits (Refundable) 236.11 Accrued Other Taxes Payable 236.12 Accrued Income Taxes Payable Accrued Taxes - Non-Utility 237-40 Accrued Debt, Interest & Dividends Payable Misc. Current & Accrued Liabilities Unamortized Debt Premium Advances for Construction Other Deferred Liabilities Accumulated Investment Tax Credits - Utility Accum. Investment Tax Credits - Non-Utility 261-5 Operating Reserves Contributions in Aid of Construction Accum. Amort. of Contrib. in Aid of Const. ** 281-3 Accumulated Deferred Income Taxes Total Liabilities (Add lines 9 - 29) TOTAL LIABILITIES & CAPITAL ( Add lines 8 & 30) ** Only if Commission Approved STATEMENT OF RETAINED EARNINGS Retained Earnings Balance @ Beginning of Year Amount Added from Current Year Income (From Pg 4, Line 32) Other Credits to Account Dividends Paid or Appropriated Other Distributions of Retained Earnings Retained Earnings Balance @ End of Year CAPITAL STOCK DETAIL No. Shares Dividends Description (Class, Par Value etc.) Authorized Paid DETAIL OF LONG-TERM DEBT Interest Year-end Description Accrued Totals SYSTEM ENGINEERING DATA Provide an updated system map if significant changes have been made to the system during the year. Water Supply: Type of Water Treatment: Supply Rated (None, Chlorine Annual Source Capacity Fluoride Production (Well, Spring, Pump Designation or location (gpm) Filter etc.) (000's Gal.) Surface Wtr) TOTALS System Storage: Total Usable Reservoir Construction (Elevated (Wood, 000's Pressurized Steel Storage Designation or Location Gal. Boosted) Concrete) (Duplicate form and attach if necessary. Asterisk facilities added this year.) SYSTEM ENGINEERING DATA Continued Pump information for ALL system pumps, including wells and boosters. Discharge Energy used Horse power Pressure this Year Designation or Location & Type of Pump** (hp) (psi) (Kwh) ** Submit pump curves unless previously provided or unavailable. Asterisk facilities added this year. Attach additional sheets if inadequate space is available on this page. If Wells are metered: What was the total amount pumped this year? 000's gal. What was the total amount pumped during peak month? 000's gal. What was the total amount pumped on the peak day? gal. If customers are metered, what was the total amount sold in peak month? 000's gal. Was your system designed to supply fire flows? If Yes: What is current system rating? How many times were meters read this year? During which months? How many additional customers could be served with no system improvements except a service line and meter? How many of those potential additions are vacant lots? Are backbone plant additions anticipated during the coming year? If Yes, attach an explanation of projects and anticipated costs! In what year do you anticipate that the system capacity (supply, storage or distribution) will have to be expanded? FEET OF MAINS In Use Installed Abandoned In Use Pipe Size Of Year CUSTOMER STATISTICS Number of Customers Thousands of Gallons Sold This Last Metered: 2A Residential 2B Commercial 2C Industrial Flat Rate: 3A 3B 3C Private Fire Protection Public Fire Protection Street Sprinkling Municipal, Other Other Water Utilities TOTALS (Add lines 2 through 8) CERTIFICATE State of Idaho ) ) ss County of ) WE, the undersigned______________________________________________ and__________________________________________________________ of the_________________________________________________________ utility, on our oath do severally say that the foregoing report has been prepared under our direction, from the original books, papers and records of said utility; that we have carefully examined same, and declare the same to be a correct statement of the business and affairs of said utility for the period covered by the report in respect to each and every matter and thing therin set forth, to the best of our knowledge, information and belief. _________________________________ (Chief Officer) ___________________________________ (Officer in Charge of Accounts) Subscribed and Sworn to Before Me this______day of__________________, _______ ________________________________________ NOTARY PUBLIC My Commission Expires _________________________________ gdk/excel/jnelson/anulrpts/wtrannualrpt Test Yr ended: Idaho PUC Case No.: Percent Revenue Increase (Line 3 + 4) Total Line 5) Exhibit 5 INCOME DEFICIENCY Teton Water and Sewer Company, LLC Idaho 3940 Grand Street Driggs LLC Teton Jon Pinardi 208-354-0256 No Yes All Operations and Maintenance 475 & 476 Chlorine Well Well #1 Well #2 Water Tank Elevated Steel Well #1 - Goulds 7 CLC Well #2 - Goulds 5RWAL NA 4" 6" 8" 15" 16" Loan #3 2021 Teton Management Services, Inc Id. Dept Water Resources Well Loan #1 Well #3 - $250k Well #4 - $100k *New Wells in 2022 *New Well #3 Finish and Well #4 Begin - Anticipate 1 new home for 2 quarters - Anticipate 4 new hookups at $2,182 plus 4 at $2,953 * Estimated power increase, see spreadsheet for others Interest: Interest is only on Well Loan Teton Water and Sewer Company, LLC 0.00 2021 1.00 $883,841.50 2.00 0.07 3.00 $61,868.91 4.00 -72934.00 5.00 $134,802.90 6.00 $72,934.00 7.00 $61,868.91 8.00 9.00 $0.00 10.00 1.29 11.00 0.00 12.00 $134,802.90 13.00 4000.00 14.00 1333.33 3.00 15.00 $136,136.24 16.00 156783.00 17.00 $292,919.24 18.00 0.87 18.00 1.00 19.00 2.25E-03 20.00 5.00E-03 0.99 21.00 0.08 0.08 22.00 0.91 23.00 0.14 0.15 24.00 0.78 25.00 1.29 Teton Water and Sewer Company, LLC 0.00 2021 1.00 441217.25 442624.25 883841.50 2.00 0.07 0.07 3.00 30885.21 61868.91 4.00 -119112.00 46178.00 -72934.00 5.00 149997.21 134802.90 Teton Water and Sewer Company, LLC 0.00 2021 1.00 $0.00 2.00 $0.00 3.00 $0.00 0.00 0.12 0.00 4.00 $250,000.00 1.00 0.07 0.07 5.00 $250,000.00 5.00 6.00 0.07 Teton Water and Sewer Company, LLC 12:00:00 AM 2021 1.00 190151.00 -12828.00 177323.00 2.00 274098.00 -59006.00 215092.00 3.00 0.00 0.00 4.00 0.00 0.00 5.00 29933.00 29933.00 6.00 301.00 301.00 7.00 2983.00 2983.00 8.00 0.00 0.00 1168.00 1168.00 780.00 780.00 0.00 0.00 0.00 0.00 10.00 0.00 0.00 11.00 0.00 0.00 12.00 0.00 0.00 13.00 0.00 0.00 14.00 0.00 0.00 15.00 0.00 0.00 16.00 309263.00 -59006.00 250257.00 17.00 0.00 0.00 18.00 0.00 0.00 19.00 -119112.00 46178.00 -72934.00 20.00 0.00 0.00 21.00 0.00 0.00 22.00 0.00 0.00 23.00 0.00 0.00 24.00 0.00 0.00 25.00 0.00 0.00 26.00 0.00 0.00 27.00 0.00 0.00 28.00 0.00 0.00 0.00 29.00 -119112.00 46178.00 -72934.00 30.00 20737.00 -3237.00 17500.00 31.00 0.00 0.00 32.00 -139849.00 49415.00 -90434.00 Teton Water and Sewer Company, LLC 0.00 2021 1.00 0.00 0.00 2.00 0.00 0.00 3.00 0.00 0.00 4.00 0.00 0.00 5.00 0.00 0.00 6.00 0.00 0.00 7.00 11707.00 1000.00 12707.00 8.00 4415.00 0.00 4415.00 9.00 98040.00 -69074.00 28966.00 10.00 627.00 627.00 11.00 78020.00 0.00 78020.00 12.00 886.00 0.00 886.00 13.00 70677.00 9068.00 79745.00 14.00 0.00 0.00 15.00 53.00 53.00 16.00 2665.00 2665.00 17.00 0.00 0.00 18.00 0.00 0.00 19.00 0.00 0.00 20.00 0.00 0.00 21.00 7008.00 7008.00 22.00 274098.00 -59006.00 215092.00 Teton Water and Sewer Company, LLC 0.00 2021 1.00 0.00 0.00 2.00 148899.00 236.00 118.00 2.00 149135.00 3.00 7648.00 7648.00 4.00 0.00 0.00 5.00 0.00 0.00 6.00 0.00 0.00 7.00 0.00 0.00 8.00 156547.00 236.00 156783.00 9.00 0.00 0.00 10.00 33604.00 -13064.00 -12900.00 164.00 20540.00 11.00 0.00 0.00 12.00 190151.00 -12828.00 177323.00 Teton Water and Sewer Company, LLC 0.00 2021 1.00 301000.00 450000.00 751000.00 2.00 1000.00 0.00 1000.00 3.00 300000.00 450000.00 750000.00 4.00 3142.00 3142.00 5.00 0.00 0.00 6.00 0.00 0.00 7.00 0.00 0.00 8.00 0.00 0.00 9.00 34262.25 8.00 -7375.75 8.00 26886.50 8.00 10.00 103813.00 103813.00 11.00 441217.25 442624.25 883841.50 Teton Water and Sewer Company, LLC 0.00 2021 1.00 304.00 0.00 0.00 2.00 305.00 0.00 0.00 3.00 306.00 0.00 0.00 4.00 307.00 0.00 0.00 5.00 308.00 0.00 0.00 6.00 309.00 0.00 0.00 7.00 310.00 0.00 0.00 8.00 311.00 0.00 0.00 9.00 320.00 0.00 0.00 10.00 330.00 0.00 0.00 11.00 331.00 0.00 0.00 12.00 333.00 0.00 0.00 13.00 334.00 0.00 0.00 14.00 335.00 0.00 0.00 15.00 336.00 0.00 0.00 16.00 339.00 1000.00 1000.00 17.00 340.00 0.00 0.00 18.00 341.00 0.00 0.00 19.00 342.00 0.00 0.00 20.00 343.00 0.00 0.00 21.00 344.00 0.00 0.00 22.00 345.00 0.00 0.00 23.00 346.00 0.00 0.00 24.00 347.00 0.00 0.00 25.00 348.00 0.00 0.00 26.00 1000.00 0.00 1000.00 Teton Water and Sewer Company, LLC 2021 1.00 301.00 0.00 0.00 2.00 302.00 0.00 0.00 3.00 303.00 300000.00 300000.00 4.00 304.00 0.00 0.00 5.00 305.00 0.00 0.00 6.00 306.00 0.00 0.00 7.00 307.00 0.00 450000.00 450000.00 8.00 308.00 0.00 0.00 9.00 309.00 0.00 0.00 10.00 310.00 0.00 0.00 11.00 311.00 0.00 0.00 12.00 320.00 0.00 0.00 13.00 330.00 0.00 0.00 14.00 331.00 0.00 0.00 15.00 333.00 0.00 0.00 16.00 334.00 0.00 0.00 17.00 335.00 0.00 0.00 18.00 336.00 0.00 0.00 19.00 339.00 1000.00 1000.00 20.00 340.00 0.00 0.00 21.00 341.00 0.00 0.00 22.00 342.00 0.00 0.00 23.00 343.00 0.00 0.00 24.00 344.00 0.00 0.00 25.00 345.00 0.00 0.00 26.00 346.00 0.00 0.00 27.00 347.00 0.00 0.00 28.00 348.00 0.00 0.00 29.00 301000.00 450000.00 751000.00 of 1.00 2.00 ?4?/?12?/?2012 3.00 4.00 5.00 6.00 7.00 8.00 83422.00 9.00 10.00 11.00 12.00 13.00 14.00 83422.00 Teton Water and Sewer Company, LLC 2021 15.00 16.00 ?5?/?23?/?2022 17.00 18.00 19.00 20.00 21.00 0.00 22.00 0.00 23.00 ?4?/?1?/?2021 24.00 Teton Water and Sewer Company, LLC 2021 1.00 2.00 $148,899.00 3.00 $7,648.00 4.00 5.00 464.00 6.00 465.00 7.00 466.00 8.00 400.00 $156,547.00 9.00 10.00 $33,604.00 11.00 12.00 13.00 14.00 601.80 15.00 603.00 16.00 604.00 17.00 610.00 18.00 $11,707.00 19.00 $4,415.00 20.00 $98,040.00 21.00 $627.00 22.00 $78,020.00 23.00 $886.00 24.00 $70,677.00 25.00 26.00 650.00 $53.00 27.00 $2,665.00 28.00 660.00 29.00 666.00 30.00 667.00 31.00 670.00 32.00 675.00 $7,008.00 33.00 $274,098.00 Teton Water and Sewer Company, LLC 2021 1.00 $156,547.00 2.00 $274,098.00 3.00 403.00 $0.00 4.00 406.00 5.00 407.00 $29,933.00 6.00 $301.00 7.00 $2,983.00 8.00 $1,168.00 $780.00 10.00 11.00 12.00 13.00 14.00 15.00 16.00 $309,263.00 17.00 413.00 18.00 414.00 19.00 ($152,716.00) 20.00 415.00 21.00 416.00 22.00 419.00 23.00 420.00 24.00 421.00 25.00 426.00 26.00 27.00 28.00 $0.00 29.00 ($152,716.00) 30.00 427.30 $20,737.00 31.00 427.50 32.00 ($173,453.00) Teton Water and Sewer Company, LLC 2021 1.00 301.00 $0.00 2.00 302.00 $0.00 3.00 303.00 $300,000.00 $300,000.00 4.00 304.00 $0.00 5.00 305.00 $0.00 6.00 306.00 $0.00 7.00 307.00 $0.00 8.00 308.00 $0.00 9.00 309.00 $0.00 10.00 310.00 $0.00 11.00 311.00 $0.00 12.00 320.00 $0.00 13.00 330.00 $0.00 14.00 331.00 $0.00 15.00 333.00 $0.00 16.00 334.00 $0.00 17.00 335.00 $0.00 18.00 336.00 $0.00 19.00 339.00 $1,000.00 $1,000.00 20.00 340.00 $0.00 21.00 341.00 $0.00 22.00 342.00 $0.00 23.00 343.00 $0.00 24.00 344.00 $0.00 25.00 345.00 $0.00 26.00 346.00 $0.00 27.00 347.00 $0.00 28.00 348.00 $0.00 $0.00 29.00 $301,000.00 $0.00 $0.00 $301,000.00 Teton Water and Sewer Company, LLC 2021 1.00 304.00 $0.00 2.00 305.00 $0.00 3.00 306.00 $0.00 4.00 307.00 $0.00 5.00 308.00 $0.00 6.00 309.00 $0.00 7.00 310.00 $0.00 8.00 311.00 $0.00 9.00 320.00 $0.00 10.00 330.00 $0.00 11.00 331.00 $0.00 12.00 333.00 $0.00 13.00 334.00 $0.00 14.00 335.00 $0.00 15.00 336.00 $0.00 16.00 339.00 $1,000.00 $1,000.00 $0.00 17.00 340.00 $0.00 18.00 341.00 $0.00 19.00 342.00 $0.00 20.00 343.00 $0.00 21.00 344.00 $0.00 22.00 345.00 $0.00 23.00 346.00 $0.00 24.00 347.00 $0.00 25.00 348.00 $0.00 26.00 $1,000.00 $1,000.00 $0.00 Teton Water and Sewer Company, LLC 2021 1.00 101.00 $301,000.00 $301,000.00 $0.00 2.00 102.00 $0.00 3.00 103.00 $0.00 4.00 105.00 $0.00 5.00 114.00 $3,142.00 $3,142.00 $0.00 6.00 $304,142.00 $304,142.00 $0.00 7.00 108.10 $1,000.00 $1,000.00 $0.00 8.00 108.20 $0.00 9.00 108.30 $0.00 10.00 110.10 $3,142.00 $292,498.00 $289,356.00 11.00 110.20 $0.00 12.00 115.00 $0.00 13.00 $300,000.00 $10,644.00 ($289,356.00) 14.00 123.00 $0.00 15.00 125.00 $0.00 16.00 $0.00 $0.00 $0.00 17.00 131.00 $4,263.00 $8,101.00 $3,838.00 18.00 135.00 $0.00 19.00 141.00 ($2,490.00) $655.00 $3,145.00 20.00 142.00 $0.00 21.00 145.00 $0.00 22.00 151.00 $0.00 23.00 162.00 $0.00 24.00 173.00 $0.00 25.00 143.00 $0.00 26.00 $1,773.00 $8,756.00 $6,983.00 27.00 181.00 $0.00 28.00 183.00 $0.00 29.00 184.00 $0.00 30.00 186.00 $37,687.00 $103,813.00 $66,126.00 31.00 $339,460.00 $123,213.00 ($216,247.00) Teton Water and Sewer Company, LLC 2021 1.00 $0.00 2.00 $0.00 3.00 $0.00 4.00 214.00 $0.00 5.00 215.00 $0.00 6.00 216.00 $0.00 7.00 218.00 $0.00 8.00 $0.00 $0.00 $0.00 9.00 $0.00 10.00 223.00 $0.00 11.00 224.00 $300,000.00 $250,000.00 ($50,000.00) 12.00 231.00 $0.00 13.00 232.00 $0.00 $0.00 14.00 233.00 $0.00 15.00 235.00 $0.00 16.00 $0.00 17.00 $0.00 18.00 236.20 $0.00 19.00 $0.00 20.00 241.00 $0.00 21.00 251.00 $0.00 22.00 252.00 $0.00 23.00 253.00 $0.00 24.00 255.10 $0.00 25.00 255.20 $0.00 26.00 $4,667.00 $898.00 ($3,769.00) 27.00 271.00 $0.00 28.00 272.00 $0.00 29.00 $0.00 30.00 $304,667.00 $250,898.00 ($53,769.00) 31.00 $304,667.00 $250,898.00 ($53,769.00) Teton Water and Sewer Company, LLC 2021 1.00 $0.00 2.00 ($173,453.00) 3.00 4.00 $0.00 5.00 $173,453.00 6.00 $0.00 7.00 $0.00 8.00 0.05 $0.00 $12,570.00 0.07 $250,000.00 $8,167.00 $250,000.00 $20,737.00 $0.00 Teton Water and Sewer Company, LLC 2021 1.00 2.00 330.00 58861.00 70.00 12418.00 71279.00 3.00 500.00 440.00 Teton Water and Sewer Company, LLC 2021 4.00 40.00 330.00 98.00 7.50 70.00 62.00 5.00 71279.00 12057.00 436773.00 6.00 7.00 8.00 9.00 47.00 47.00 10.00 11.00 2022.00 Teton Water and Sewer Company, LLC 2021 1.00 150.00 150.00 400.00 400.00 50000.00 50000.00 5600.00 5600.00 1700.00 1700.00 2.00 3.00 302.00 297.00 4.00 4.00 4.00 5.00 6.00 7.00 8.00 306.00 301.00 0.00 0.00