Ws236-11

Transcript

CLASS "A" OR "B" OJrJICJAL coPY c....w.. .hblie Seniee Do Not ReJHft •~ tlds Office WATER AND/OR WASTEWATER UTILITIES i"' (Gross Revenue of More Than $200,000 Each) ('") 0 ANNUAL REPORT OF WS236-11-AR WATER MANAGEMENT SERVICES, INC Exact Legal Name of Respondent 3!l2W Certificate Number(s) Submitted To The STATE OF FLORIDA FOR THE YEAR ENDED DECEMBER 31, 2011 Form PSC/ECR 003-W (Rev. 12/99) ., :Dot ::::0 n:::r r:::r F"'l- 0 ~~ 0 ::z: ;oU> :z w :n m 0 m ., < m 0 .r,... IJ N C) . -. l -n (J) GENERAL INSTRUCTIONS 1. Prepare this report in conformity with the 1996 National Association of Regulatory Utility Commissioners Uniform System of Accounts for Water and/or Wastewater Utilities (USOA). 2. Interpret all accounting words and phrases in accordance with the USOA. 3. Complete each question fully and accurately, even if it has been answered in a previous annual report. Enter the word "None" where it truly and completely states the fact. 4. For any question, section, or page which is not applicable to the respondent, enter the words "Not Applicable." Do not omit any pages. 5. Where dates are called for, the month and day should be stated as well as the year. 6. All schedules requiring dollar entries should be rounded to the nearest dollar unless otherwise specifically indicated. 7. Comple~ 8. If there is not enough room on any schedule, an additional page or pages may be added, provided the format of the added schedule matches the f~rmat of the schedule with not enough room. Such a schedule should reference the appropriate schedules, state the name of the utility, and state the year of the report. 9. If it is necessary or desirable to insert additional statements for the purpose of further explanation of schedules, such statement should be made at the bottom of the page or an additional page inserted. Any additional pages should state the name of the utility, the year of the report, and reference the appropriate schedule. 10. For water and wastewater utilities with more than one rate group and/or system, water and wastewater pages should be completed for each rate group and/or system group. These pages should be grouped together and tabbed by rate group and/or system. 11. All other water and wastewater operations not regulated by the Commission and other regulated industries should be reported as "Other than Reporting Systems." 12. Financial information for multiple systems charging rates which are covered under the same tariff should be reported as one system. However, the engineering data must be reported by individual system. 13. For water and wastewater utilities with more than one system, one (1) copy ofworkpapers showing the consolidation of systems for the operating sections, should be filed with the annual report. 14. The report should be filled out in quadruplicate and the original and two copies returned by March 31, of the year following the date of the report. The report should be returned to: this report by means which result in a permanent record, such as by computer or typewriter. Florida Public Service Commission Division of Economic Regulation 2540 Shumard Oak Boulevard Tallahassee, Florida 32399-0850 The fourth copy should be retained by the utility. TABLE OF CONTENTS PAGE SCHEDULE SCHEDULE PAGE EXECUTIVE SUMMARY E-1 E-2 E-3 E-4 E-5 E-6 Certification General Information Directory of Personnel Who Contact the FPSC Company Profile Parent I Affiliate Organization Chart Compensation of Officers & Directors Business Contracts with Officers, Directors and Affiliates Affiliation of Officers and Directors Businesses which are a Byproduct, Coproduct or Joint Product Result of Providing Service Business Transactions with Related Parties. Part I and II E-7 E-8 E-9 E-10 FINANCIAL SECTION Comparative Balance Sheet Assets and Other Debits Comparative Balance Sheet Equity Capital and Liabilities Comparative Operating Statement Year End Rate Base Year End Capital Structure Capital Structure Adjustments Utility Plant Utility Plant Acquisition Adjustments Accumulated Depreciation Accumulated Amortization Regulatory Commission Expense Amortization of Rate Case Expense Nonutility Property Special Deposits Investments and Special Funds Accounts and Notes Receivable - Net Accounts Receivable from Associated Companies Notes Receivable from Associated Companies Miscellaneous Current & Accrued Assets Unamortized Debt Discount I Expense I Premium Extraordinary Property Losses Miscellaneous Deferred Debits Capital Stock Bonds Statement of Retained Earnings Advances from Associated Companies Other Long Term Debt Notes Payable Accounts Payable to Associated Companies Accrued Interest and Expense Miscellaneous Current & Accrued Liabilities Advances for Construction Other Deferred Credits Contributions In Aid of Construction Accumulated Amortization of CIAC Reconciliation of Reported Net Income with Taxable Income for Federal Income Taxes F-1 F-2 F-3 F-4 F-5 F-6 F-7 F-7 F-8 F-8 F-9 F-9 F-9 F-10 F-11 F-12 F-12 F-12 .,._, ii F-13 F-13 F-14 F-15 F-15 F-16 F-17 F-17 F-18 F-18 F-19 F-20 F-20 F-21 F-22 F-22 F-23 TABLE OF CONTENTS PAGE SCHEDULE SCHEDULE PAGE WATER OPERATION SECTION Water Listing of System Groups Year End Water Rate Base Water Operating Statement Water Utility Plant Accounts Basis for Water Depreciation Charges Analysis of Entries in Water Depreciation Reserve Contributions In Aid of Construction CIAC Additions I Amortization Water Operating Revenue Water Utility Expense Accounts Pumping and Purchased Water Statistics, Source Supply Water Treatment Plant Information Calculation ofERCs Other Water System Information W-1 W-2 W-3 W-4 W-5 W-6 W-7 W-8 W-9 W-10 W-11 W-12 W-13 W-14 WASTEWATER OPERATION SECTION Wastewater Listing of System Groups Year End Wastewater Rate Base Wastewater Operating Statement Wastewater Utility Plant Accounts Basis for Wastewater Depreciation Charges Analysis of Entries in Wastewater Depreciation Reserve S-1 S-2 S-3 S-4 S-5 Contributions In Aid of Construction CIAC Additions I Amortization Wastewater Operating Revenue Wastewater Utility Expense Accounts Calculation ofERCs Wastewater Treatment Plant Information Other Wastewater System Information S-6 iii S-7 S-8 S-9 S-10 S-11 S-12 S-13 EXECUTIVE SUMMARY YEAR OF REPORT WATER MANAGEMENT SERVICES. INC UTILITY NAME: December 31, 2011 CERTIFICATION OF ANNUAL REPORT I HEREBY CERTIFY, to the best of my knowledge and belief: I I I I YES NO X YES 2. The utility is in substantial compliance with all applicable rules and orders of the Florida Public Service Commission, except order No. PSC-11-00 10-SC-WU, which is on appeal. 3. There have been no communications from regulatol)' agencies concerning noncompliance with, or deficiencies in, financial reporting practices that could have a material effect on the the fmancial statement of the utility. 4. The annual report fairly represents the fmancial condition and results of operations of the respondent for the period presented and other information and statements presented in the the report as to the business affairs of the respondent are true, correct and complete for the period for which it represents. NO X YES The utility is in substantial compliance with the Uniform System of Accounts prescribed by the Florida Public Service Commission. NO X YES 1. NO X Items Certified * NOTICE: 1. 2. 3. 4. X X X X 1. 2. 3. 4. X X X X Each of the four items must be certified YES or NO. Each item need not be certified by both officers. The items being certified by the officer should be indicated in the appropriate area to the left of the signature. Section 837.06, Florida Statutes, provides that any person who knowingly makes a false statement in writing with the intent to mislead a public servant in the performance of his duty shall be guilty of a misdemeanor of the second degree. E-1 YEAR OF REPORT December 31, 2011 ANNUAL REPORT OF County: WATER MANAGEMENT SERVICES, INC (Exact Name of Utility) ---------------Franklin List below the exact mailing address of the utility for which normal correspondence should be sent: 250 John Knox Road, # 4 Tallahassee, FL 32303 Telephone: (850)668-0440 E Mail Address: [email protected]; [email protected] WEB Site: www.wmsistgeorge.com WM1736 Sunshine State One-Call of Florida, Inc. Member Number Name and address of person to whom correspondence concerning this report should be addressed: Gene D. Brown 250 John Knox Road, # 4 Tallahassee, FL 32303 Telephone: (850)668-0440 List below the address of where the utility's books and records are located: 250 John Knox Road,# 4 Tallahassee, FL 32303 Telephone: (850)668-0440 List below any groups auditing or reviewing the records and operations: . . :C;..;o;.;;n;.;;ta;;..;c;.;;t..::in;::fl..::o;::rm;::a::.:t::.:io;.;;n;;..s;::h;.;;o.. .;.wn;..::.. o;::n;;;..,;;;;E.. .:-3;__ _ _ _ _ _ _ _ _ _ __ Barbara S. Withers, CPA Jeanne Allen, CPA Contact information shown on E-3 _;;_;~~~;::..::;::..::~~~~~~--------------­ Contact information shown on E-3 Les Thomas, P.E. Date of original organization of the utility: 03/03/78 Check the appropriate business entity of the utility as filed with the Internal Revenue Service Individual Partnership I I Sub S Corporation I 1120 Corporation I I X I List below every corporation or person owning or holding directly or indirectly 5% or more of the voting securities of the utility: Percent Ownership 85% 10% 5% Name 1. 2. 3. 4. 5. . St. George Island Utility Co., Ltd. Brown Management Group, Inc T.E. Bronson 6. 7. 8. 9. 10. E-2 UTILITY NAME: YEAR OF REPORT December 31, 2011 WATER MANAGEMENT SERYICES, INC DIRECTORY OF PERSONNEL WHO CONTACT THE FLORIDA PUBLIC SERVICE COMMISSION NAME OF COMPANY REPRESENTATIVE TITLE OR POSITION ORGANIZATIONAL UNIT TITLE (1) (2) (3) Gene D. Brown President Sandra M. Chase VP & Secretary Brenda Molsbee Certified Operator Operations Manager General Business Hank Garrett Certified Operator Operations Manager General Business Maggie McCall Moody General Manager USUAL PURPOSE FOR CONTACT WITHFPSC Assistant General Manager General Business/Legal General Business Attorney Regulatory Matters Attorney Regulatory Matters CPA Accounting and Tax CPA Accounting and Tax Engineer Engineering 2940 Kerry Forest Parkway Ste 103 Tallahassee, FL 32309 (850)656-7753, (850)675-3869 (Fax) Martin S. Friedman 766 North Sun Drive Ste. 4030 Lake Mary, FL 32746 (407)830-6331, (407)830-8522 (Fax) Barbara S. Withers 411 Live Oak Plantation Rd. Tallahassee, FL 32312 (850)893-4080 Jeanne Allen 2075 Centre Pointe Blvd Ste. 200 Tallahassee, FL 32308 (850)878-6189 Les Thomas, P.E. 3640 Pointview Circle Gainesville, GA 30506 (678)677-6420 ( 1) Also list appropriate legal counsel, accountants and others who may not be on general payroll. (2) Provide individual telephone numbers if the person is not normally reached at the company. (3) Name of company employed by, if not on general payroll. E-3 UTILITY NAME: WATER MANAGEMENT SERVICES, INC YEAR OF REPORT December 31,2011 COMPANY PROFILE Provide a briefmmative company profile which covers the following areas: A. B. C. D. E. F. Brief company history. Public services rendered. Major goals and objectives. Major operating divisions and functions. Current and projected growth patterns. Major transactions having a material effect on operations. St. George Island Utility Company, Ltd. was certificated on March 31, 1978 to provide water serviee to St. George Island, which is a barrier island located in the Gulf of Mexico in Franklin County, Florida. The Company has 4 wells on the mainland, and water is piped to the island through a 12" supply main attached to the bride to the ishmd. The Company has a treatment system, a ground storage tank and an elevated storage tank on the island. Although the Company is not required to provide fire protection, the Company does provide limited fire protection through 140 hydrants on the island. The island population fluctuates widely because it a vacation/resort area. Accordingly, there are peak demands during summer and other holiday periods, with lower demand the remainder of the year. The utility has suficient capacity to meet all current demands. Construction of the system commenced in 1974, and many components of the system are near the end of their useful lives. Accordingly, the Company has designed and is plarming to construct substantial improvements to the plant to prevent a deterioration of its reliability. These inClude a new 600,000 gallon ground storage tank, new pumping and control facilities, new electrical facilities, new chlorination facilities, a partial new supply main and a new fifth well. These improvements are being made so that the utility can meet its primary goal and objective, which is to provide safe and reliable water service to its customers on St. George Island. The utility has an adminstration and accounting office in Tallahassee, Florida, as well as an opeations office on St. George Island. The Tallahassee office has four full-time employees who handle all adminstrative, legal and accounting functions. The St. George Island office also has four full time employees, including two certified operators and two field technicians, who are responsible for the day to day operations of the utility. The utility has been losing substantial sums of money during the past several years due to a general downturn in the economy and a proliferation of shallow wells on St. George Island, and has experienced an increasf: in operating costs. To overcome this problem, the utility filed an application with the Florida Public Service Commission on November 7, 2011 (Docket No. 110200-WU), which has an official filing date of February 17, 2012. That case is proceeding under the Commission's P AA process. E-4 ~~~~~~--------·--- YEAR OF REPORT UTILITY NAME: WATER MANAGEMENT SERVICES, INC December 31, 2011 PARENT I AFFILIATE ORGANIZATION CHART Current as of 12/31/11 ----------------~~~------------------ Complete below an organizational chart that shows all parents, subsidiaries and affiliates of the utility. The chart must also show the relationship between the utility and affiliates listed on E-7, E-lO(a) and E-10(b). St. George Island Utility Company, Ltd. Stockholder Gene D. Brown Legal Counsel Brown Management Group, Inc Subsidiary E-5 UTILITY NAME: YEAR OF REPORT December 3I, 20 II WATER MANAGEMENT SERVJCES, INC COMPENSATION OF OFFICERS For each officer, list the time spent on respondent as an officer compared to time spent on total business activities and the compensation received as an officer from the respondent. %OF TIME SPENT AS OFFICER OF OFFICERS' TITLE THE UTILITY COMPENSATION NAME (d) (a) (b) (c) Gene D. Brown Sandra Chase President 95% Vice President IOO% $ II0,300 70,300 COMPENSATION OF DIRECTORS For each director, list the number of directors' meetings attended by each director and the compensation received as a director from the respondent. NUMBER OF DIRECTORS' MEETINGS DIRECTORS' NAME TITLE ATTENDED COMPENSATION (a) (b) (c) (d) Gene D. Brown I President E-6 $ 0 UTILITY NAME: YEAR OF REPORT December 3I, 20 II WATER MANAGEMENT SERVICES, INC BUSINESS CONTRACTS WITH OFFICERS, DIRECTORS AND AFFILIATES List all contracts, agreements, or other business arrangements* entered into during the calendar year (other than compensation related to position with Respondents) between the Respondent and officer and director listed on page E-6. In addition, provide the same information with respect to professional services for each firm, partnership, or organization with which the officer or director is affiliated. NAME OF OFFICER, DIRECTOR OR AFFILIATE IDENTIFICATION OF SERVICE OR PRODUCT AMOUNT (a) (b) (c) Brown Management Group, Inc Office Rental $ 18,000 NAME AND ADDRESS OF AFFILIATED ENTITY (d) BMG, Inc. 250 John Knox Rd. # 4 Tallahassee, FL 32303 * Business Agreement, for this schedule, shall mean any oral or written business deal which binds the concerned parties for products or services during the reporting year or future years. Although the Respondent and/or other companies will benefit from the arrangement, the officer or director is, however, acting on his behalf or for the benefit of other companies or persons. E-7 YI<:AR OF REPORT UTILITY NAME: December 31, 2011 WATER MANAGEMENT SERVICES, INC AFFILIATION OF OFFICERS AND DIRECTORS For each of the officials listed on page E-6, list the principal occupation or business affiliations or connections with any other business or financial organizations, firms, or partnerships. For purposes of this part, an official will be considered to have an affiliation with any business or financial organization, firm or partnership in which he is an officer, director, trustee, partner, or a person exercising similar functions. PRINCIPAL NAME AND ADDRESS OCCUPATION OR BUSINESS AFFILIATION OR OF AFFILIATION OR NAME AFFILIATION CONNECTION (a) (b) CONNECTION (c) Gene D. Brown Gene D. Brown Officer/Director Legal Services (d) G(:ne D. Brown Office/Director of President of Corporate St. Georl!e lsi. Utility General Partner General Partners of Co, Ltd. General Partner Gene. D. Brown Gene D. Brown Officer/Director of President of Corporate General Partner General Partners Officer/Director President Leisure Properties, Ltd. St. George's Plantation, Inc. Gene D. Brown Officer/Director President Le:isure Development Services, Inc. Gene D. Brown Officer/Director President Brown Management Group, Inc. All above located at 250 John Knox Rd, # 4 Tallahassee, FL 32303 E-8 UTILITY NAME: YEAR OF REPORT December 31, 2011 WATER MANAGEMENT SERVICES, INC BUSINESSES WHICH ARE A BY-PRODUCT, CO PRODUCT OR JOINT-PRODUCT RESULT OF PROVIDING WATER OR WASTEWATER SERVICE Complete the following for any business which is conducted as a byproduct, co product, or joint product as a result of providing water and I or wastewater service. This would include any business which requires the use of utility land and facilities. Examples of these types of businesses would be orange groves, nurseries, tree farms, fertilizer manufacturing, etc. This would not include any business for which the assets are properly included in Account 121 - Nonutility Property along with the associated revenue and expenses segregated out as nonutility also. EXYEl'I~E~ REVENUES ASSETS I ' BUSINESS OR SERVICE CONDUCTED BOOK COST OF ASSETS (b) (a) Not Apj>licable ACCOUNT NUMBER (c) $ REVENUES 'GENERATED (d) $ E-9 EXPENSES INCURRED (f) ACCOUNT NUMBER (e) $ - - ACCOUNT NUMBER (g) UTILITY NAME: YEAR OF REPORT December 31, 2011 WATER MANAGEMENT SERVICES, INC BUSINESS TRANSACTIONS WITH RELATED PARTIES List each contract, agreement, or other business transaction exceeding a cumulative amount of $500 in any on year, entered into between the Respondent and a business or financial organization, firm, or partnership named on pages E-2 and E-6, identifying the parties, amounts, dates and product, and asset, or service involved. Part I. Specific Instructions: Services and Products Received or Provided 1. 2. Enter in this part all transactions involving services and products received or provided. Below are some types of transactions to include: -management, legal and accounting services -computer services -engineering & construction services -repairing and servicing of equipment NAME OF COMPANY OR RELATED PARTY (a) DESCRIPTION SERVICE AND/OR NAME OF PRODUCT (b) -material and supplies furnished -leasing of structures, land, and equipment -rental transactions -sale, purchase or transfer of various products CONTRACTOR ANNUAL CHARGES (P)urchased AGREEMENT EFFECTIVE DATES (S)old AMOUNT (c) (d) (e) $ Brown Management Group, Inc. Office Rental Jan, 2010 p 18,000 Gene D. Brown Legal Services Jan, 2010 p 9,750 E-lO(a) UTILITY NAME: YEAR OF REPORT December 31, 2011 WATER MANAGEMENT SERVICES. INC BUSINESS TRANSACTIONS WITH RELATED PARTIES (Cont'd) Part IT. Specific Instructions: Sale, Purchase and Transfer of Assets 1. Enter in this part all transactions relating to the purchase, sale, or transfer of assets. 2 Below are examples of some types of transactions to include: -purchase, sale or transfer of equipment -purchase, sale or transfer ofland and structures -purchase, sale or transfer of securities -noncash transfers of assets -noncash dividends other than stock dividends -write-off of bad debts or loans 3. The columnar instructions follow: (a) (b) (c) (d) (e) (f) Enter name of related party or company. Describe briefly the type of assets purchased, sold or transferred. Enter the total received or paid. Indicate purchase with "P" and sale with "S". Enter the net book value for each item reported. Enter the net profit or loss for each item reported. (column (c)- column (d)) Enter the fair market value for each item reported. In space below or in a supplemental schedule, describe the basis used to calculate fair market value. NAME OF COMPANY OR RELATED PARTY DESCRIPTION OF ITEMS SALE OR PURCHASE PRICE (a) (b) (c) $ 17,741 17,741 (S) Assumption ofWMSI loan by SMC 13,393 !13,393l (S) Sandra M. Chase (SMC) GAINOR LOSS FAIR MARKET VALUE (e) (f) $ $ Non cash transfer of2007 Chevy Tahoe to SMC Sandra M. Chase (SMC) - ------------- $ 1,215,075(P) Acquisition of 100% stock ownership ofBMG -- NET BOOK VALUE (d) 1,215,075 Brown Management Group, Inc (BMG) ' 1,191,227 0 ~17,741) 17,913 13,393 !13.393l ---- E-10(b) I UTILITY NAME: YEAR OF REPORT December 31, 2011 WATER MANAGEMENT SERVICES, INC COMPARATIVE BALANCE SHEET ASSETS AND OTHER DEBITS ACCT. NO. (a) REF. PAGE (c) ACCOUNT NAME (b) UTILITY PLANT F-7 F-8 Utility Plant Less: Accumulated Depreciation and Amortization 101-106 108-110 Net Plant 114-115 116. I I Utility Plant Acquisition adjustment (Net) Other Utility Plant Adjustments 123 124 125 126-127 OTHER PROPERTY AND INVESTMENTS Nonutility Property Less: Accumulated Depreciation and Amortization Net Nonutility Property Investment in Associated Companies Utility Investments Other Investments Special Funds F-9 145 146 151-153 161 162 171 172. 173. 174 $ 8,964,372 3,413,348 $ 9,035,663 3,634,516 $ 5,551,025 $ 5,401,147 0 $ 5,551,025 $ 5,401,147 $ 1,136,818 0 $ 1,141,166 $ 1,136,818 1,175,075 $ 1,141,166 1,215,075 0 0 0 $ 2,311,893 $ 2,356,241 F-10 F-10 F-10 F-10 Total Other Property & Investments 131 132 133 134 135 141-144 CURRENT AND ACCRUED ASSETS Cash S_£ecial Deposits Other Special Deposits Working Funds Temporary Cash Investments Accounts and Notes Receivable, Less Accumulated Provision for Uncollectible Accounts Accounts Receivable from Associated Companies Notes Receivable from Associated Companies Material and Supplies Stores Expense Prepayments Accrued Interest and Dividends Receivable Rents Receivable Accrued Utility Revenues Miscellaneous Current and Accrued Assets $ F-9 F-9 • Not Applicable for Class B Utilities F-1(a) (17,751) 18,204 $ (18,585) 0 0 0 0 F-11 F-12 F-12 124,413 97,252 0 0 32,543 31,726 F-12 0 $ Total Current and Accrued Assets CURRENT YEAR (e) F-7 Total Net Utility Plant 121 122 PREVIOUS YEAR (d) 157,409 $ 110,393 UTILITY NAME: YEAR OF REPORT December 31,2011 WATER MANAGEMENT SERVICES, INC COMPARATIVE BALANCE SHEET ASSETS AND OTHER DEBITS ACCT. NO. (a) 181 182 183 184 185 * 186 187 * 190 F-13 F-13 $ TOTAL ASSETS AND OTHER DEBITS CURRENT YEAR (e) 283,467 - $ $ 373,961 - $ 418,776 $ 8,394,288 - $ 8,286,557 F-14 Total Deferred Debits * PREVIOUS YEAR (d) REF. PAGE (c) ACCOUNT NAME (b) DEFERRED DEBITS Unamortized Debt Discount & Expense Extraordinary Property Losses Preliminary Survey & Investigation Charges Clearing Accounts Temporary Facilities Miscellaneous Deferred Debits Research & Development Expenditures Accumulated Deferred Income Taxes 90,494 Not Applicable for Class B Utilities NOTESTOTHEBALANCESHEET The space below is provided for important notes regarding the balance sheet F-1(b) 77,126 0 36,125 305,525 YEAR OF REPORT UTILITY NAME: WATER MANAGEMENT SERVICES, INC December 31,2011 COMPARATIVE BALANCE SHEET EQUITY CAPITAL AND LIABILITIES ACCT. NO. (a) 201 204 202,205 * 203,206 * 207 * 209 * 210 * 211 212 213 214-215 216 218 221 222 * 223 224 ACCOUNT NAME (b) EQUITY CAPITAL Common Stock Issued Preferred Stock Issued Capital Stock Subscribed Capital Stock Liability for Conversion Premium on Capital Stock Reduction in Par or Stated Value of Capital Stock Gain on Resale or Cancellation of Reacquired Capital Stock Other Paid - In Capital Discount On Capital Stock Capital Stock Expense Retained Earnings Reacquired Capital Stock Proprietary Capital (Proprietorship and Partnership Only) F-15 F-15 $ $ Total Equity Capital LONG TERM DEBT Bonds Reacquired Bonds Advances from Associated Companies Other Long Term Debt 10,000 CURRENT YEAR (e) - $ - F-16 (488,548) (1 ,858,400) (2,162,911) (2,336,948) $ F-2(a) 5,236,908 $ 471,631 2,859,129 0 F-18 F-18 F-18 5,265,026 636,849 2,934,296 3,621 0 110,433 88,741 33,159 136,174 61,269 34,874 W/S-3 F-19 687 F-20 $ * Not Applicable for Class B Utilities 0 5,265,026 5,236,908 $ Total Current & Accrued Liabilities (2,641,459) 0 F-17 F-17 CURRENT AND ACCRUED LIABILITIES Accounts Payable Notes Payable Accounts Payable to Associated Companies Notes Payable to Associated Companies Customer Deposits Accrued Taxes Accrued Interest Accrued Dividends Matured Long Term Debt Matured Interest Miscellaneous Current & Accrued Liabilities 10,000 0 (488,548) F-15 Total Long Term Debt 231 232 233 234 . 235 236 237 238 239 240 241 PREVIOUS YEAR (d) REF. PAGE (c) 3,563,075 $ 3,807,788 YEAR OF llEPORT tJTIWY NAME: WATEJtMANAG£MENT SERVICES. INC COMPARATIVE BALANCE SHEET EQUITY CAPITAL AND LJAlULITIES ACCOllNT NAME PAGE PREVIOUS YEAlt (b) {_c} _hll REF. ACCT. NO. (a\ 251 2S2 253 255 DEFEJUt!ID CREDITS Unamortize4 Premium On Debt F-13 (e) s $ 0 10,430 1),000 F~JO .A4VIll'lces For Cons'L'rUCtlon Other Deterred Crediis CURRENT YEAR 0 F-21 Accumulated Deferred Investment Tax Credits Total Deferred Credits $ 11~030 $ 1~4JO OPBRATINO RESERVES 261 262 263 265 271 272 ProoertY lnsll1'311CC Reserve r~& ... Reserve Per:~:iioll!! and Benefits Reserve Miscelbleous " Reserves $ Total Operating Reserves $ 0 ~ 0 $ 3,388,622 $ 3.410,303 $ 0 CONTRIBUTIONS lN AID OF CONSTRUCTION ConttttbUtions in Aid of Construction Accnmnlatcd Amortl2arion of Comribinions in Aid of Construction F-:2.2 _(1,468.402) F-22 ToraiNet CIAC $ t9?...oao (1.565.530) $ 118441773 ACCUMULA1'ED DEFERRED INCOME TAXES .281 .Acc\Dnlllated Oefez:red Income Taxes Accelen$cd Deoreciatiou 282 Aecumulare4 Deferred Income Tmres l..tberalimi Deoreciation 283 AcclumJbted Deferred Income Taxes - Other $ TotalAccmnulatcd Deterred hwome Tax TOTAL EQtJJTY CAPITAL AND l..IA.BlllTIES ' ~d F-2(b) $ $ 0 s 0 $ 813941286 s ~~557 YEAR OF REPORT UTILITY NAME: WATER MANAGEMENT SERVICES, INC December 31, 2011 COMPARATIVE OPERATING STATEMENT ACCT. NO. (a) 400 469,530 ACCOUNT NAME REF. PAGE PREVIOUS YEAR (b) (c) (d) UTILITY OPERATING INCOME Operating Revenues Less: Guaranteed Revenue and AFPI F-3(b) F-3(b) Net Operating Revenues 401 403 $ 1,291,958 246 $ 1,384,769 123 $ 1,291,712 $ 1,384,646 F-3(b) $ 1,115,100 $ 1,026,060 D~reciation F-3(b) F-22 $ 294,090 94,695 $ 268,884 97,128 $ 199,395 $ 171,756 Expense: Amortization of CIAC Net Depreciation Expense 469,530 413 414 420 (e) Operating Expenses Less: 406 407 408 409 410.1 410.11 411.1 412.1 412.11 CURRENT YEAR* Amortization of Utility Plant Acquisition Adjustment Amortization Expense (Other than CIAC) Taxes Other Than Income Current Income Taxes Deferred Federal Income Taxes Deferred State Income Taxes Provision for Deferred Income Taxes - Credit Investment Tax Credits Deferred to Future Periods Investment Tax Credits Restored to Operating Income F-3(b) F-3(b) W/S-3 W/S-3 W/S-3 W/S-3 W/S-3 W/S-3 W/S-3 Utility Operating Expenses $ Net Utility Operating Income $ Add Back: Guaranteed Revenue and AFPI Income From Utility Plant Leased to Others Gains (losses) From Disposition of Utility Property Allowance for Funds Used During Construction F-3(b) Total Utility Operating Income [Enter here and on Page F-3(c)] 0 14,298 113,594 0 0 0 0 0 0 14,616 107,672 1,436,783 (145,071) $ 1,325,707 $ 58,939 246 123 0 541 0 1,500 $ (143,325) $ * F-3(a) -------------------- 59,603 For each account, Column e should agree with Columns f, g andh on F-3(b) I YEAR OF REPORT UTILITY NAME: WATER MANAGEMENT SERYICES, INC COMPARATIVE OPERATING STATEMENT (Cont'd) WATER SCHEDULE W-3 (f) OTHER THAN REPORTING SYSTEMS (h) WASTEWATER SCHEDULE S-3 * (g) * $ 1,384,769 123 $ 0 0 $ $ 1,384,646 $ 0 $ $ 1,026,060 $ 0 $ 268,884 97,128 $ 171,756 0 0 0 $ 0 14,298 113,594 0 0 0 0 0 0 0 $ 0 0 0 0 0 0 0 0 0 0 $ 1,325,707 $ 0 $ 0 $ 58,939 $ 0 $ 0 $ 0 123 0 541 0 $ 59,603 0 0 0 0 $ 0 *Total of Schedules W-3 I S-3 for all rate groups. F-3(b) I YEAR OF REPORT UTILITY NAME: WATER MANAGEMENT SERVICES, INC December 31, 2011 COMPARATIVE OPERATING STATEMENT (Cont'd) ACCT. NO. (a) REF. PAGE (c) ACCOUNT NAME (b) $ Total Utility Operating Income [from page F-3(a)] 415 416 419 421 426 OTHER INCOME AND DEDUCTIONS Revenues-Merchandising, Jobbing, and Contract Deductions Costs & Expenses of Merchandising Jobbing, and Contract Work Interest and Dividend Income Nonutility Income Miscellaneous Nonutility Expenses $ $ TAXES APPLICABLE TO OTHER INCOME Taxes Other Than Income Income Taxes Provision for Deferred Income Taxes Provision for Deferred Income Taxes - Credit Investment Tax Credits- Net Investment Tax Credits Restored to Operating Income INTEREST EXPENSE Interest Expense Amortization of Debt Discount & Expense Amortization of Premium on Debt EXTRAORDINARY ITEMS Extraordinary Income Extraordinary Deductions Income Taxes, Extraordinary Items (7,431) $ F-19 F-13 F-13 781 Explain Extraordinary Income: F-3(c) $ (48,315) $ 0 $ 0 $ 294,845 58,436 $ 314,745 52,627 0 $ 353,281 $ 367,372 $ $ NET INCOME (49,096) $ $ Total Extraordinary Items 59,603 $ (10,819) Total Interest Expense 433 434 409.3 (143,325) 3,387 Total Taxes Applicable To Other Income ·427 428 429 CURRENT YEAR (e) $ Total Other Income and Deductions 408.2 409.2 410.2 411.2 412.2 412.3 PREVIOUS YEAR (d) $ 0 (504,038) $ $ 0 (356,084) UTILITY NAME: YEAR OF REPORT December 31,2011 WATER MANAGEMENT SERVICES, INC SCHEDULE OF YEAR END_ RATE BASE ACCT. NO. (a) REF. PAGE (c) ACCOUNT NAME (b) Utility Plant In Service Less: Nonused and Useful Plant (1) Accumulated Depreciation Accumulated Amortization Contributions in Aid of Construction Advances for Construction 101 108 110 271 252 $ F-7 F-22 0 0 0 $ 0 F-7 3,545,944 - F-7 ~ ' NET UTILITY OPERATING INCOME $ 0 0 0 0 0 0 0 $ 3,545,944 $ 0 $ 58,939 $ 0 ACHIEVED RATE OF RETURN (Operating Income I Rate Base) 1.66% NOTES: (1) Estimate based on the methodology used in the last rate proceeding. (2) Include only those Acquisition Adjustments that have been approved by the Commission. (3) Calculation consistent with last rate proceeding. In absence of a rate proceeding,_ Class A utilities will use the Balance Sheet Method and Class B Utilities will use the One-eighth Operating and Maintenance Expense Method. F-4 0 1,565,530 $ Plus or Minus: Acquisition Adjustments (2) Accumulated Amortization of Acquisition Adjustments (2) Working Capital Allowance (3) Other (Specify): Negative WCAP set to 0 RATE BASE 1,980,414 0 .- Subtotal 114 115 $ 3,634,516 0 3,410,303 10,430 $ Add: Accumulated Amortization of Contributions in Aid of Construction WASTEWATER UTILITY (e) 9,035,663 F-8 F-8 F-22 F-20 Subtotal 272 WATER UTILITY (d) 0.00% UTILITY NAME: YEAR OF REPORT December 31, 2011 WATER MANAGEMENT SERVICES, INC SCHEDULE OF CURRENT COST OF CAPITAL CONSISTENT WITH THE METHODOLOGY USED IN THE LAST RATE I,ROCEEDING (1) {_ DOLLAR AMOUNT(2) (b) CLASS OF CAPITAL (a) Common Equity Preferred Stock Long Term Debt Customer Deposits Tax Credits- Zero Cost Tax Credits- Weighted Cost Deferred Income Taxes Other (Explain) Total (1) $ PERCENTAGE OF CAPITAL (c) 0 0 3,443,741 102,203 0 0 0 0 0 0.00% 0.00% 97.12% 2.88% 0.00% 0.00% 0.00% 0.00% 0.00% 3,545,944 $ ACTUAL COST RATES (3) (d) 11.16% 3.5.3% 6.00% 100.00% If the utility's capital structure is not used, explain which capital structtrr.e is used. NOTE: Debt cost calculated based on effective interest costs applied to 13 mos average balances. (2) Should equal amounts on Schedule F-6, Column (g). (3) Mid-point of the last authorized Return On Equity or current leverage formula if none has been established. Must be calculated using the same methodology used in the last rate proceeding using current annual report year end amounts and cost rates. APPROVED RETURN ON EQUITY Current Commission Return on Equity: 11.16% Commission order approving Return on Equity: PSC-11-0287-PAA-WS APPROVED AFUDC RATE COMPLETION ONLY REQUIRED IF AFUDC WAS CHARGED DURING YEAR Current Commission Approved AFUDC rate: Commission order approving AFUDC rate: If any utility capitalized any charge in lieu of AFUDC (such as interest only), state the basis of the charge, an explanation as to why AFUDC was not charged and the percentage capitalized. F-5 WEIGHTED COST (ex d) (e) 0.00% 0.00% 3.43% 0.17% 0.00% 0.00% 0.00% 0.00% 0.00% 3.60% UTILITY NAME: YEAR OF REPORT December 31,2011 WATER MANAGEMENT SERVICES, INC SCHEDULE OF CAPITAL STRUCTURE ADJUSTMENTS CONSISTENT WITH THE METHODOLOGY USED IN THE LAST RATE PROCEEDING CLASS OF CAPITAL (a) Common Equity Preferred Stock Long Term Debt Customer Deposits Tax Credits - Zero Cost Tax Credits- Weighted Cost Deferred Inc. Taxes Other (Explain) $ Total $ PER BOOK BALANCE NON-UTILITY ADJUSTMENTS (b) (c) ~2,641,460) $ NONJURISDICTIONAL ADJUSTMENTS (d)_ $ $ OTHER(l) ADJUSTMENTS SPECIFIC OTHER(l) ADJUSTMENTS PRO RATA CAPITAL STRUCTURE (e) (f) (g) (2,641 ,460~ $ 4,673,221 8,116,962 102,203 5,577,705 $ $ 0 $ 0 (1) Explain below all adjustments made in Columns (e) and (f): Column (b) - 13 month average balances of debt and customer deposits Column (e)- Equity is negative, set to zero Column (f)- Hold customer deposits constant and reconcile to rate base as shown on Schedule F-4 F-6 $ (2,641 ,460) $ 4,673,221 $ 0 0 3,443,741 102,203 0 0 0 0 0 3,545,944 UTILITY NAME: YEAR OF REPORT December 31, 2011 WATER MANAGEMENT SERVICES, INC UTILITY PLANT ACCOUNTS 101 - 106 ACCT. NO. DESCRIPTION WATER (a) (b) (c) 101 102 103 104 105 106 Plant Accounts: Utility Plant In Service Utility Plant Leased to Other Property Held for Future Use Utility Plant Purchased or Sold Construction Work in Progress Completed Construction Not Classified Total Utility Plant $ 8,912,382 WASTEWATER OTHER THAN REPORTING SYSTEMS TOTAL (d) (e) (f) $ 0 $ $ 8,912,382 0 0 0 123,281 123,281 0 $ 9,035,663 $ 0 0 $ $ 9,035,663 UTILITY PLANT ACQUISITION ADJUSTMENTS ACCOUNTS 114 AND 115 Report each acquisition adjustment and related accumulated amortization separately. For any acquisition adjustments approved by the Commission, include the Order Number. OTHER THAN REPORTING DESCRIPTION WATER WASTEWATER SYSTEMS ACCT. NO. (b) (a) 114 (c) (d) TOTAL (f) (e) Acquisition Adjustment $ $ $ 0 0 0 0 $ 0 $ 0 0 0 0 0 $ 0 0 $ 0 $ N/A Total Plant Acquisition Adjustments 115 $ 0 $ 0 $ 0 Accumulated Amortization $ $ $ N/A Total Accumulated Amortization $ 0 $ 0 Net Acquisition Adjustments $ 0 $ 0 F-7 $ $ YEAR OF REPORT December 31, 2011 WATER MANAGEMENT SERVICES, INC UTILITY NAME: ACCUMULATED DEPRECIATION (ACCT. 108) AND AMORTIZATION (ACCT. 110) WATER ·(b) DESCRIPTION (a) ACCUMULATED DEPRECIATION Account 108 Balance first of year Credit during year: Accruals charged to: Account 108.1 (1) Account 108.2 (2) Account 108.3 (2) Other Accounts (specify): Total Debits WASTEWATER (c) TOTAL (e) (d) $ 3,413,348 $ $ $ $ 268,884 $ $ $ 268,884 0 0 0 0 0 (610) 0 210 $ 268,483 (610) Salvage Other Credits (Specify}: PSC Adj - 201 0 Depree Total Credits Debits during year: Book cost of plant retired Cost of Removal Other Debits (specify}: PSC Adj - 2009 Retire PSC Adj - 20 10 Depree OTHER THAN REPORTING SYSTEMS 210 $ 268,483 $ 0 $ 0 5,446 3,413,348 5,446 0 29,197 12,672 29,197 12,672 $ 47,315 $ 0 $ 0 $ 47,315 Balance end of year $ 3,634,516 $ 0 $ 0 $ 3,634,516 ACCUMULATED AMORTIZATION Acco..nt 110 Balan'ce first ofyear Credit during year: Accruals charged to: $ 99,878 $ $ $ 99,878 $ $ $ 0 0 0 14,298 $ 14,298 $ Account 110.2 (3) Other Accounts (specify): 110.10 Loss on Disposal of Bridge/Main Total credits Debits during year: Book cost of plant retired Other debits {specify): Total Debits Balance end of year (1) (2) (3) 14,298 $ 14,298 $ 0 $ 0 0 0 0 $ 0 $ 0 $ 0 $ 0 $ 114,176 $ 0 $ 0 $ 114,176 Account 108 for Class B utilities. Not applicable for Class B utilities. Account 110 for Class B utilities. F-8 UTILITY NAME: YEAR OF REPORT December 31,2011 WATER MANAGEMENT SERVICES, INC REGULATORY COMMISSION EXPENSE AMORTIZATION OF RATE CASE EXPENSE (ACCOUNTS 666 AND 766) CHARGED OFF DURING YEAR EXPENSE INCURRED DURING YEAR (b) DESCRIPTION OF CASE (DOCKET NO.) (a) Docket No. 100104-WU Total $ 3,176 $ 3,176 ACCT. AMOUNT (e) (d) 666.80 $ 57,295 $ 57,295 NONUTILITY PROPERTY (ACCOUNT 121) Report separately each item of property with a book cost of$25,000 or more included in Account 121. Other Items may be grouped by classes of property. BEGINNING ENDING YEAR DESCRIPTION YEAR ADDITIONS REDUCTIONS BALANCE .(a) (b) (d) (e) (c) Disallow'Cd Investment in Plant Non-Utility Land Total Nonutility Property $ $ 811,018 325,800 1,136,818 4,348 $ $ 815,366 325,800 0 0 $ 1,141,166 " $ 4,348 $ 0 SPECIAL DEPOSITS (ACCOUNTS 132 AND 133) Report hereunder all special deposits carried in Accounts 132 and 133. DESCRIPTION OF SPECIAL DEPOSITS YEAREND BOOK COST (a) (b) SPECIAL DEPOSITS (Account 132): N/A - $ 0 -· - $ Total Special Deposits OTHER SPECIAL DEPOSITS (Account 133): N/A - 0 $ - $ Total Other Special Deposits F-9 0 UTILITY NAME: YEAR OF REPORT December 31,2011 WAIER MANAGEMENT SERVICES, INC INVESTMENTS AND SPECIAL FUNDS ACCOUNTS 123 - 127 Report hereunder all investments and special funds carried in Accounts 123 through 127. FACE OR YEAREND DESCRIPTION OF SECURITY OR SPECIAL FUND PAR VALUE BOOK COST (a) (b) (c) INVESTMENT IN ASSOCIATED COMPANIES (Account 123): Brown Management Group, Inc $ $ 1,215,075 $ 1,215,075 Total Investment in Associated Companies UTILITY INVESTMENTS (Account 124): N/A $ Total Utility Investment $ $ OTHER INVESTMENTS (Account 125): N/A $ $ Total Other Investment $ SPECIAL FUNDS (Class A Utilities: Accounts 126 and 127; Class B Utilities: Account 127): N/A $ Total Special Funds $ F-10 0 0 0 YEAR OF REPORT UTILITY NAME: De~ember 31, 20 11 WATER MANAGEMENT SERVICES, INC ACCOUNTSANDNOTESRECENABLE-NET ACCOUNTS 141 - 144 Report hereunder all accounts and notes receivable included in Accounts 141, 142, and 144. Amounts included in Amounts included in Accounts 142 and 144 should be listed individually. DESCRIPTION TOTAL (b) (a) CUSTOMER ACCOUNTS RECEIVABLE (Account 141): Water $ 124,675 Wastewater Other Total Customer Accounts Receivable OTHER ACCOUNTS RECEIVABLE (Account 142): $ $ 124,675 $ 1,002 $ 0 $ 125,677 $ 28,425 $ 97,252 1,002 Total Other Accounts Receivable NOTES RECEIVABLE (Account 144 ): $ Total Notes Receivable Total Accounts and-Notes Receivable ACCUMULATED PROVISION FOR UNCOLLECTIBLE ACCOUNTS (Account 143) Balance first of year Add: Provision for uncollectibles for current year Collection of accounts previously written off Utility Accounts Others $ $ Total Additions Deduct accounts written off during year: Utility Accounts Others 28,240 2,087 (1,902) $ 185 $ 0 \ Total accounts written off Balance end of year TOTAL ACCOUNTS AND NOTES RECEIVABLE -NET F-11 UTILITY NAME: YEAR OF REPORT December 31, 2011 WATER MANAGEMENT SERVICES, INC ACCOUNTS RECEIVABLE FROM; ASSOCIATED COMPANIES ACCOUNT 145 Report each account receivable from associated companies separately. DESCRIPTION (a) TOTAL (b) N/A $ Total $ 0 NOTES RECEIVABLE FROM ASSOCIATED COMPANIES ACCOUNT 146 Report each note receivable from associated companies separately INTEREST DESCRIPTION RATE (a) (b) N/A TOTAL (c) % $ % % % % % % $ Total 0 MISCELLANEOUS CURRENT AND ACCRUED ASSETS ACCOUNT 174 BALANCE END OF YEAR (b) DESCRIPTION - Provide itemized listing (a) $ N/A Total Miscellaneous Current and Accrued Liabilities F-12 $ 0 I YEAR OF REPORT UTILITY NAME: WATER MANAGEMENT SERVICES, INC UNAMORTIZED DEBT DISCOUNT AND EXPENSE AND PREMIUM ON DEBT ACCOUNTS 181 AND 251 Report the net discount and expense or premium separately for each security issut:. AMOUNT WRITTEN OFF DURING YEAR DESCRIPTION (a) YEAREND BALANCE (c) (b) '~ UNAMORTIZED DEBT DISCOUNT AND EXPENSE (Account 181): $ DEP - SRF Loan Centennial- Ref. Loan $5871 relates to Loan Fees.and $39,258 relates to Life Ins FMB - Backhoe Loan FMB -Lot Loan FCCU-GMC Loan Envision CU - Chev Loan 7,347 45,129 111 2 21 18 $ 77,048 0 18 17 43 0 Total Unamortized Debt Discount and Expense $ 52,627 $ 77,126 UNAMORTIZED PREMIUM ON DEBT (Account 251): N/A $ $ -· $ Total Unamortized Premium on Debt 0 $ 0 EXTRAORDINARY PROPERTY LOSSES ACCOUNT182 Report each item separately. DESCRIPTION (a) TOTAL (b) . $ N/A $ Total Extraordinary Property Losses ., F-13 0 I I YEAR OF REPORT UTILITY NAME: WATER MANAGEMENT SERVICES, INC MISCELLANEOUS DEFERRED DEBITS ACCOUNT186 AMOUNT WRITTEN OFF DURING YEAR (b) DESCRIPTION - Provide itemized listing (a) YEAREND BALANCE (c) DEFERRED RATE CASE EXPENSE (Class A Utilities: Account 186.1) 186.05 Deferred Rate Case Appeal 186.06 Deferred Rate Case- 2010 TY 186.07 Deferred Rate Case- 2009 TY $ 0 0 57,295 $ 37,101 60,575 132,967 Total Deferred Rate Case Expense $ 57,295 $ 230,643 186.20 Deferred Loss on Bridge Supply Main $ 14,298 $ 24,532 Total Other Deferred Debits $ 14,298 $ 24,532 $ 0 $ 50,351 $ 0 $ 50,351 $ 71,593 $ 305,525 OTHER DEFERRED DEBITS (Class A Utilities: Account 186.2): REGULATORY ASSETS (Class A Utilities: Account. 186.3): 186.30 Deferred Wastewater Certificate Application ' Total Regulatory Assets TOTAL MISCELLANEOUS DEFERRED DEBITS F-14 I UTILITY NAME: YEAR OF REPORT December 31, 2011 WATER MANAGEMENT SERVICES, INC CAPITAL STOCK ACCOUNTS 201 AND 204* DESCRIPTION (a) RATE (b) COMMON STOCK Par or stated value per share Shares authorized Shares issued and outstanding Total par value of stock issued Dividends declared per share for year ~lo $ ~Ia $ $ ~Ia PREFERRED STOCK Par or stated value per share Shares authorized Shares issued and outstanding Total]!_ar value of stock issued Dividends declared per share for year * TOTAL (c) 0. 10 100,000 100,000 10,000 0 % $ % $ % $ Account 204 not applicable for Class B utilities. BONDS ACCOUNT221 DESCRIPTION OF OBLIGATION (INCLUDING DATE OF ISSUE AND DATE OF MATURITY) (a) INTEREST ANNUAL FIXED OR RATE VARIABLE* (b) N/A (c) % % % % % % % % % $ 0 $ Total * PRINCIPAL AMOUNT PER BALANCE SHEET (d) For variable rate obligations, provide the basis for the rate. (i.e.. prime+ 2%, etc.) F-15 0 UTILITY NAME: WATER MANAGEMENT SERVICES, INC YEAR OF REPORT December 31, 2011 STATEMENT OF RETAINED EARNINGS 1. 2. ACCT. NO. (a) 215 439 Dividends should be shown for each class and series of capital stock. Show amounts as dividends per share. Show separately the state and federal income tax effect of items shown in Account No 439 DESCRIPTION (b) Unappropriated Retained Earnings: Balance Beginning ofYear Changes to Account: Adjustments to Retained Earnings (requires Commission approval prior to use): Credit! PSC Adj - 2009 Capitalized from Repairs PSC Adj - 2009 Depree on retired equip. PSC Adj - 20 10 Capitalized from repairs PSC Adj - 20 10 Depree on retired equip Total Credits: PSC Adj Debits: PSC Adj PSC Adj PSC Adj - 2009 Retired Equip - 2009 Depec on Capitalized from Repairs - 20 10 Depree on Capitalized from Repairs - 20 10 Depree on Capitalized from Repairs Total Debits: AMOUNTS (c) $ (1,858,400) $ 51,751 2,246 8,405 2,246 $ $ 64,648 8,984 1,294 2,588 210 $ 13,075 (356,084) 435 436 Balance Transferred from Income Appropriations of Retained Earnings: $ $ 0 437 Total Appropriations of Retained Earnings Dividends Declared: Preferred Stock Dividends Declared 438 Common Stock Dividends Declared $ 0 Total Dividends Declared $ 215 Year end Balance 214 Appropriated Retained Earnings (state balance and . purpose of each appropriated amount at year end): 214 $ Total Appropriated Retained Earnings $ Total Retained Earnings Notes to Statement of Retained Earnings: F-16 (2,162,911) 0 (2,162,911) YEAR OF REPORT UTILITY NAME: WATER MANAGEMENT SERVICES, INC December 31,2011 ADVANCES FROM ASSOCIATED COMPANIES ACCOUNT 223 Report each advance separately. DESCRIPTION TOTAL (a) (b) N/A $ Total $ 0 OTHER LONG-TERM DEBT ACCOUNT224 DESCRIPTION OF OBLIGATION (INCLUDING DATE OF ISSUE AND DATE OF MATURITY) (a) 224.25 FMB - Lots 224.32 DEP 224.33 FCCU - GMC 224.37 FMB - Backhoe INTEREST FIXED OR ANNUAL VARIABLE* RATE (b) (c) 7.50 2.99 6.00 6.85 % % % % % % % % % % % % % % % % Total * For variable rate obligations, provide the basis for the rate. (i.e .. prime+ 2%, etc.) F-17 Fixed Fixed Fixed Fixed PRINCIPAL AMOUNT PER BALANCE SHEET (d) $ 295,502 4,960,017 5,606 3,901 $ 5,265,026 UTILITY NAME: YEAR OF REPORT December 31,2011 WATER MANAGEMENT SERVICES, INC NOTES PAYABLE ACCOUNTS 232 AND 234 DESCRIPTION OF OBLIGATION (INCLUDING DATE OF ISSUE AND DATE OF MATURITY) (a) N_OTES 232.20 232.25 232.32 232.33 232.37 INTEREST ANNUAL FIXED OR VARIABLE* RATE (c) (b) PAYABLE ( Account 232): Centennial Bank FMB Lots DEP FCCU FMB 4.25 7.50 2.99 6.00 6 .85 % % % % % % % % Prime+l Fixed Fixed Fixed Fixed Total Account 232 NOTES PAY ABLE TO ASSOC. COMPANIES (Account 234): N/A ' PRINCIPAL AMOUNT PER BALANCE SHEET % % % % % % % % (d) $ 2,743,016 20,093 151,572 4,459 15,156 $ 2,934,296 $ $ Total Account 234 0 * For variable rate obligations, provide the basis for the rate. (i.e .. prime+ 2%, etc.) ACCOUNTS PAYABLE TO ASSOCIATED COMPANIES ACCOUNT 233 Report each account payable separately. DESCRIPTION TOTAL (b) (a) Brown Management Group $ 3,621 Total $ 3,621 F-18 YEAR OF REPORT UTILITY NAME: December 31, 2011 WATER MANAGEMENT SERVICES, INC ACCRUED INTEREST AND EXPENSE ACCOUNTS 237 AND 427 DESCRIPTION OF DEBIT (a) ACCOUNT NO. 237.1 -Accrued Interest on Long Term Debt FMB237.5 FCCU 237.33 Envision 237.34 FMB 237.41 D.E.P Centennial Bank INTEREST ACCRUED DURING YEAR ACCT. AMOUNT DEBIT (d) (c) BALANCE BEGINNING OF YEAR (b) $ 1,709 73 28 94 18,274 14,695 21,026 718 $ 1,261 150,322 118,496 21,254 741 28 1,266 149,489 120,759 $ 1,482 50 89 19,106 12,432 291,823 $ 293,538 $ $ 4,230 14,996 3,696 $ 4,230 14,996 3,696 $ 0 $ 22,922 $ 22,922 $ 0 34,874 $ 314,745 $ 316,461 $ 33,159 $ 3i4,745 34,874 $ 0 0 Total Account 237.2 $ Total Account 237 (1) $ ACCOUNT NO. 237.2- Accrued Interest on Other Liabilities Customer De_Eosits Vendors Affiliates $ BALANCE END OF YEAR (t) $ $ Total Account 237.1 427.32 437.30 437.30 437.30 427.31 427.31 INTEREST PAID DURING YEAR (e) INTEREST EXPENSED: . Total accrual Account 237 Less Ca_Eitalized Interest Portion of AFUDC: 427 427 .50 427. 10 237 (i) Must agree to F-2 (a), Beginning and Ending Balance of Accrued Interest. (2) Must agree to F-3 (c), Current Year Interest Expense $ Net Interest Expensed to Account No. 427 (2) F-19 31't;745 33,159 UTILITY NAME: YEAR OF REPORT December 31,2011 WATER MANAGEMENT SERVICES, INC .MISCELLANEOUS CURRENT AND ACCRUED LIABILITIES ACCOUNT241 BALANCE END OF YEAR (b) DESCRIPTION - Provide itemized listing (a) Pa~ro11 Deduction- 401K Plan Total Miscellaneous Current and Accrued Liabilities $ 687 $ 687 ADVANCES FOR CONSTRUCTION ACCOUNT252 NAME OF PAYOR* (a) D.E.P.- East End Connections Total BALANCE BEGINNING OF YEAR ACCT. DEBIT (b) (c) DEBITS AMOUNT (d) $ 11,030 $ (600) $ $ 11,030 $ (600) $ * Report advances separately by reporting group, designating water or wastewater in column (a). F-20 CREDITS BALANCE END OF YEAR (e) (f) 0 $ 10,430 0 0 0 0 0 0 0 0 $ 10,430 UTILITY NAME: YEAR OF REPORT December 31, 2011 WATER MANAGEMENT SERVICES, INC OTHER DEFERRED CREDITS ACCOUNT253 AMOUNT WRITTEN OFF DURING YEAR (b) DESCRIPTION - Provide itemized listing (a) YEAREND BALANCE (c) REGULATORY LIABILITIES (Class A Utilities: Account 253.1): N/A $ $ Total Regulatory Liabilities $ $ $ $ $ $ $ $ OTHER DEFERRED LIABILITIES (Class A Utilities: Account 253.2): N/A - Total Other Deferred Liabilities TOTAL OTHER DEFERRED CREDITS F-21 UTILITY NAME: YEAR OF REPORT December 31,2011 WATER MANAGEMENT SERVICES, INC CONTRIBUTIONS IN AID OF CONSTRUCTION ACCOUNT271 WATER (W-7) (b) DESCRIPTION (a) WASTEWATER (S-7) (c) W&WWOTHER THAN SYSTEM REPORTING (d) TOTAL (e) $ 3,388,622 $ 0 $ $ 3,388,622 Add credits during year: $ 21,681 $ 0 $ $ 21,681 Less debit charged during the year $ 0 $ 0 $ $ 0 Total Contribution In Aid of Construction $ 3,410,303 $ 0 $ $ 3,410,303 Balance first of year ~ 0 ACCUMULATED AMORTIZATION OF CONTRIBUTIONS IN AID OF CONSTRUCTION ACCOUNT272 WATER (W-8(a)) (b) DESCRIPTION (a) WASTEWATER (S-8(a)) W&WWOTHER THAN SYSTEM REPORTING TOTAL (c) (d) (e) Balance first of year $ 1,468,402 $ 0 $ $ 1,468,402 Debits during the year: $ 97,128 $ 0 $ $ 97,128 Credits during the year $ 0 $ 0 $ $ 0 Total Accumulated Amortization of Contributions In Aid of Construction $ 1,565,530 $ 0 $ $ 1,565,530 F-22 0 YEAR OF REPORT WATER MANAGEMENT SERVICES, INC UTILITY NAME: December 31, 2011 RECONCILIATION OF REPORTED NET INCOME WITH TAXABLE INCOME FOR FEDERAL INCOME TAXES (UTILITY OPERATIONS) 1. The reconciliation should include the same detail as furnished on Schedule M-1 of the federal tax return for the year. The reconciliation shall be submitted even though there is no taxable income for the year. Descriptions should clearly indicate the nature of each reconciling amount and show the computations of all tax accruals. 2. If the utility is a member of a group which files a consolidated federal tax return, reconcile reported net income with taxable net income as if a separate return were to be filed, indicating intercompany amounts to be eliminated in such consolidated return. State names of group members, tax assigned to each group member, and basis of allocation, assignments or sharing of the consolidated tax among the group members. DESCRIPTION (a) AMOUNT (c) REF. NO. (b) F-3(c) Net income for the year Reconciling items for the year: Taxable income not reported on books: Net Additions to CIAC Deductions recorded on books not deducted for return: Life Insurance, Key Man Penalties/Fines $ (356,084) F-22 (75,447) W-10 12,015 15,344 F-3 (6) Income recorded on books not included in return: Deduction on return not charged against book income: Federal tax net income Computation of tax: $ No Tax Due because ofNet Operating Loss Carry forwards from prior years. F-23 -----------~---~- (404,172) WATER OPERATION SECTION YEAR OF REPORT UTILITY NAME: WATER MANAGEMENT SERVICES, INC December 31, 2011 WATER LISTING OF SYSTEM GROUPS List below the name of each reporting system and its certificate number. Those systems which have been consolidated under the same tariff should be assigned a group number. Each individual system which has not been consolidated should be assigned its own group number. The water financial schedules (W-2 through W -1 0) should be filed for the group in total. The water engineering schedules (W-11 through W-14) must be filed for each system in the group. All of the following water pages (W-2 through W-14) should be completed for each group and arranged by group number. CERTIFICATE: NUMBER SYSTEM NAME I COUNTY Water Management Services, Inc./ Franklin There is only one reporting system. W-1 302-W GROUP NUMBER N/A YEAR OF REPORT UTILITY NAME: WATER MANAGEMENT SERVICES, INC SYSTEM NAME I COUNTY: Franklin December 31, 2011 SCHEDULE OF YEAR END WATER RATE BASE ACCT. NO. (a) 101 108 110 271 252 REFERENCE PAGE (c) ACCOUNT NAME (b) W-4(b) Utility Plant In Service Less: Nonused and Useful Plant (1) Accumulated Depreciation Accumulated Amortization Contributions in Aid of Construction Advances for Construction $ Add: Accumulated Amortization of Contributions in Aid of Construction W-8(a) Subtotal 9,035,663 3,634,516 0 3,410,303 10,430 W-6(b) F-8 W-7 F-20 Subtotal 272 WATER UTILITY (d) $ 1,980,414 $ 1,565,530 $ 3,545,944 ' 114 115 Plus or Minus: Acquisition Adjustments (2) Accumulated Amortization of Acquisition Adjustments (2) Working Capital Allowance (3) Other (Specify): Negative WCAP set to 0 F-7 F-7 WATER RATE BASE W-3 WATER OPERATING INCOME ACHIEVED RATE OF RETURN (Water Operating Income I Water Rate Base) NOTES: (1) Estimate based on the methodology used in the last rate proceeding. (2) Include only those Acquisition Adjustments that have been approved by the Commission. . (3) Calculation consistent with last rate proceeding. In absence of a rate proceeding, Class A utilities will use the Balance Sheet Method and Class B Utilities will use the One-eighth Operating and Maintenance Expense Method. W-2 GROUP 0 0 $ 3,545,944 $ 58,938 1.66% YEAR OF REPORT UTILITY NAME: WATER MANAGEMENT SERVICES, INC SYSTEM NAME I COUNTY: Franklin December 31, 2011 WATER OPERATING STATEMENT ACCT. NO. (a) 400 469 REFERENCE PAGE (c) ACCOUNT NAME (b) UTILITY OPERATING INCOME Operating Revenues Less: Guaranteed Revenue and AFPI W-9 W-9 Net Operating Revenues 401 Operating Expenses W-10(a) 403 Depreciation Expense Less: Amortization of CIAC W-6(a) W-8(a) 406 407 Net Depreciation Expense Amortization of Utility Plant Acquisition Adjustment Amortization Expense (Other than CIAC) CURRENT YEAR (d) $ 1,384,769 123 $ 1,384,646 $ 1,026,060 268,884 97,128 $ F-7 F-8 171,756 0 14,298 408.10 408.11 408.12 408.13 Taxes Other Than Income Utility Regulatory Assessment Fee Property Taxes Payroll Taxes Other Taxes and Licenses 408 409.1 410.10 410.11 411.10 412.10 412.11 Total Taxes Other Than Income Income Taxes Deferred Federal Income Taxes Deferred State Income Taxes Provision for Deferred Income Taxes- Credit Investment Tax Credits Deferred to Future Periods Investment Tax Credits Restored to Operating Income $ 113,594 Utility Operating Expenses $ 1,325,707 Utility Operating Income $ 58,939 $ 123 469 413 414 420 62,315 13,561 33,993 3,725 Add Back: Guaranteed Revenue (and AFPI) Income From Utility Plant Leased to Others Gains (losses) From Disposition of Utility Property Allowance for Funds Used During Construction W-9 541 $ Total Utility Operating Income W-3 GROUP 59,603 YEAR OF REPORT UTILITY NAME: WATER MANAGEMENT SERVICES, INC SYSTEM NAME I COUNTY: Franklin December 31, 2011 WATER UTILITY PLANT ACCOUNTS ACCT. NO. (a_l 301 302 303 304 305 306 307 308 309 310 311 320 330 331 333 334 335 336 339 340 341 342 343 344 345 346 347 348 ACCOUNT NAME (b) Organization Franchises Land and Land Rights Structures and Im_provements Collecting and Impounding Reservoirs Lake, River and Other Intakes Wells and Springs Infiltration Galleries and Tunnels Supply Mains Power Generation Equipment Pumping Equipment Water Treatment Equipment Distribution Reservoirs and Standpipes Transmission and Distribution Mains Services Meters and Meter Installations Hydrants Backflow Prevention Devices Other Plant Miscellaneous Equipment Office Furniture and E_quipment Transportation Equipment Stores Equipment Tools, Shop and Garage Equipment Laboratory Equipment Power Operated Equipment Communication Equipment Miscellaneous Equipment Other Tangible Plant TOTAL WATER PLANT NOTE: PREVIOUS YEAR jc) $ ADDITIONS (tll_ 0 $ RETIREMENTS CURRENT YEAR (e) (f) $ $ 87,594 356,329 405,021 3,984,508 113,061 224,689 78,043 362,073 2,425,852 239,451 213,366 169,516 60,156 2,485 38,180 1,319 3,916 3,552 13,678 5,086 0 81,550 60,725 382 0 36,743 139 30,413 64,551 $ 8,903,072 $ 84,308 Any adjustments made to reclassify property from one account to another must be footnoted. W-4(a) GROUP $ 74,998 $ 0 0 87,594 356,329 0 0 405,021 0 3,984,508 113,061 246,665 79,209 362,073 2,425,852 243,367 211,832 183,194 0 0 81,932 30,312 0 36,882 0 64,551 0 0 0 8,912,382 ! ! UTILITY NAME: WATER MANAGEMENT SERVICES, INC SYSTEM NAME I COUNTY: Franklin YEAR OF REPORT December 31,2011 WATER UTILITY PLANT MATRIX .5 .1 ACCT. NO. CURRENT YEAR (c) ACCOUNT NAME SOURCE OF SUPPLY AND PUMPING PLANT INTANGIBLE PLANT TRANSMISSION AND DISTRIBUTION PLANT WATER TREATMENT PLANT GENERAL PLANT 0 0 87,594 356,329 -0 0 405,021 0 3,984,508 113,061 246,665 79,209 362,073 2,425,852 243,367 211,832 183,194 0 0 81,932 30,312 0 36.882 0 64,551 0 36,882 --- 64,551 0 0 TOTAL WATER PLANT $ 8,912,382 I$ 0 W-4(b) GROUP $ 4,820,373 $ 219,164 $ 3,446,469 $ 426,376 YEAR OF REPORT UTILITY NAME: WATER MANAGEMENT SERVICES, INC SYSTEM NAME I COUNTY: Franklin December 31, 2011 BASIS FOR WATER DEPRECIATION CHARGES ACCT. NO. ACCOUNT NAME (a) (b) 304 305 306 307 308 309 310 311 320 330 331 333 334 335 336 339 340 341 342 343 344 345 346 347 348 Structures and Improvements Collecting and Impounding Reservoirs Lake, River and Other Intakes Wells and Springs Infiltration Galleries and Tunnels Supply Mains Power Generation Equipment Pumping Equipment Water Treatment Equipment Distribution Reservoirs and Standpipes Transmission and Distribution Mains Services Meters and Meter Installations Hydrants Backflow Prevention Devices Other Plant Miscellaneous Equipment Office Furniture and Equipment Transportation Eguii>_ment Stores Equipment Tools, Shop and Garage Equipment Laboratory Equipment Power Qp_erated Equipment Communication Equipment Miscellaneous Equipment Other Tangible Plant AVERAGE SERVICE LIFE IN YEARS (c) 33 AVERAGE NET SALVAGE IN DEPRECIATION RATE APPLIED IN PERCENT (100%- d) I c (e) 3.03% PER~ENT (d) 30 3.33% 35 20 20 22 37 43 40 20 45 2.86% 5.00% 5.00% 4.55% 2.70% 2.33% 2.50% 5.00% 2.22% 25 15 6 16 4.00% 6.67% 16.67% 6.25% 12 8.33% 15 6.67% Water Plant Composite Depreciation Rate* * If depreciation rates prescribed by this Commission are on a total composite basis, entries should be made on this line only. W-5 GROUP ,, ____ , ____________________ YEAR OF REPORT UTILITY NAME: WATER MANAGEMENT SERVICES, INC SYSTEM NAME I COUNTY : Franklin December 31 , 2011 ANALYSIS OF ENTRIES IN WATER ACCUMULATED DEPRECIATION ACCT. NO. ACCOUNT NAME BALANCE AT BEGINNING OF YEAR (a) (b) ~ 304 305 306 307 308 309 310 311 320 330 331 333 334 335 336 339 340 341 342 343 344 345 346 347 348 Structures and Improvements Collecting and Impounding Reservoirs Lake, River and Other Intakes Wells and Springs Infiltration Galleries and Tunnels Supply Mains . Power Generation Equipment Pumping Equipment Water Treatment Equipment Distribution Reservoirs and Standpipes Transmission and Distribution Mains Services Meters and Meter Installations Hydrants Backflow Prevention Devices Other Plant Miscellaneous Equipment Office Furniture and Equipment Transportation Equipment Stores Equipment Tools, Shop and Garage Equipment Laboratory Equipment Power Operated Equipment Communication Equipment Miscellaneous Equipment Other Tangible Plant TOTAL WATER ACCUMULATED DEPRECIATION * Specify nature of transaction Use ()to denote reversal entries. $ 116,500 ACCRUALS _{__es Transmission and Distribution Mains Services Meters and Meter Installations Hydrants Backflow Prevention Devices Other Plant Miscellaneous Equipment Office Furniture and Equipment Transportation Equipment Stores Equipment Tools, Shop and Garage Equipment Laboratorv Equipment Power Operated Equipment Communication Equipment Miscellaneous Equipment Other Tangible Plant TOTAL WATER ACCUMULATED DEPRECIATION COST OF REMOVAL AND OTHER CHARGES SALVAGE AND INSURANCE (h) (g) $ $ 360 5,086 12,672 $ 5446 $ W-6(b) GROUP 0 $ 12 672 BALANCE AT END OF YEAR (g-b+i) (j) (i) $ $ TOTAL CHARGES $ 0 0 0 0 0 0 0 0 360 0 0 0 5,086 0 0 0 0 12,672 0 0 0 0 0 0 0 $ 18 118 $ (c+f-j) (k) 126,142 0 0 214,954 0 1,119,870 87,116 148,340 44,721 262,298 1,102,867 157,935 159,313 78,712 0 0 50,798 17,682 0 21,014 0 42,756 0 0 326342516 I _I ! I UTILITY NAME: WATER MANAGEMENT SERVICES, INC SYSTEM NAME I COUNTY: Franklin YEAR OF REPORT December 31,2011 CONTRIBUTIONS IN AID OF CONSTRUCTION ACCOUNT271 DESCRIPTION (a) REFERENCE (b) Balance first of year Add credits during year: Contributions received from Capacity, Main Extension and Customer Connection Charges Contributions received from Developer or Contractor Agreements in cash or property W-8(a) WATER (c) $ 3,388,622 $ 21,681 0 W-8(b) Total Credits $ Less debits charged during the year (All debits charged during the year must be explained below) $ Total Contributions In Aid of Construction $ If any prepaid CIAC has been collected, provide a supporting schedule showing how the amount is detennined. \,- Explain all debits charged to Account 271 during the year below: W-7 GROUP 21,681 3,410,303 UTILITY NAME: WATER MANAGEMENT SERVICES, INC SYSTEM NAME I COUNTY: Franklin YEAR OF REPORT December 31,2011 WATERCIAC SCHEDULE "A" ADDITIONS TO CONTRIBUTIONS IN AID OF CONSTRUCTION RECEIVED FROM CAPACITY, MAIN EXTENSION AND CUSTOMER CONNECTION CHARGES RECEIVED DURING THE YEAR NUMBER OF CHARGE PER DESCRIPTION OF CHARGE CONNECTIONS CONNECTION AMOUNT (a) (b) (c) (d) Plant CaEacity Plant Capacity- Various Plant Capacity- Various Plant Capacity- Various Plant Capacity - Various Plant Capacity- Various Plant Capacity- Various Plant Capacity- Various Plant CaEacity- Various Meter Installation Main Extension Main Extension- Various Main Extension- Various Main Extension - Various Main Extension- Various Main Extension- Various Main Extension- Various 7 1 1 1 I 1 1 1 1 9 7 1 1 1 1 1 1 $ 845 800 1,449 604 1,207 1,207 587 443 362 250 525 900 375 750 750 182 225 Total Credits ACCUMULATED AMORTIZATION OF WATER CONTRIBUTIONS IN AID OF CONSTRUCTION DESCRIPTION WATER (b_l (a) Balance first of year $ 1,468,402 Debits during the year: Accruals charged to Account 272 Other debits (specify) : $ 97,128 Total debits $ 97,128 Credits during the year (specify): $ Total credits $ 0 Balance end of year $ 12565 2530 W-8(a) GROUP $ 5,915 800 1,449 604 1,207 1,207 587 443 362 2,250 3,675 900 375 750 750 182 225 $ 21,681 UTILITY NAME: WATER MANAGEMENT SERVICES, INC SYSTEM NAME I COUNTY : Franklin YEAR OF REPORT December 31,2011 WATER CIAC SCHEDULE "B" ADDITIONS TO CONTRIBUTIONS IN AID OF CONSTRUCTION RECEIVED FROM ALL DEVELOPERS OR CONTRACTORS AGREEMENTS WHICH CASH OR PROPERTY WAS RECEIVED DURING THE YEAR INDICATE CASH OR PROPERTY (b) DESCRIPTION (a) AMOUNT (c) None $ " $ Total Credits W-8(b) GROUP 0 YEAR OF REPORT UTILITY NAME: WATER MANAGEMENT SERVICES, INC SYSTEM NAME I COUNTY : Franklin December 31, 2011 WATER OPERATING REVENUE ACCT. NO. DESCRIPTION (a) (b) 460 461.1 461.2 461.3 461.4 461.5 BEGINNING YEAR NO. CUSTOMERS* (c) YEAREND NUMBER OF CUSTOMERS 0 0 1,687 86 1,698 88 1,112,839 165,066 2 33 2 31 43,779 57,542 1,808 1,819 $ 1,379,225 0 0 $ 0 1,808 1,819 $ 1,379,225 $ 123 Water Sales: Unmetered Water Revenue Metered Water Revenue: Sales to Residential Customers Sales to Commercial Customers Sales to Industrial Customers Sales to Public Authorities Sales Multiple Family Dwellings Total Metered Sales 462.1 462.2 Other Sales To Public Authorities Sales To Irrigation Customers Sales For Resale Interdepartmental Sales Total Water Sales 469 470 471 472 473 474 * $ Fire Protection Revenue: Public Fire Protection Private Fire Protection Total Fire Protection Revenue 464 465 466 467 AMOUNT (e) (d) Other Water Revenues: Guaranteed Revenues (Including Allowance for Funds Prudently Invested or AFPI) Forfeited Discounts Miscellaneous Service Revenues Rents From Water Property Interdepartmental Rents Other Water Revenues 5,421 Total Other Water Revenues $ 5,544 Total Water Operating Revenues $ 1,384,769 Customer is defined by Rule 25-30.210(1), Florida Administrative Code. W-9 GROUP YEAR OF REPORT UTILITY NAME: WATER MANAGEMENT SERVICES, INC SYSTEM NAME I COUNTY: Franklin December 31, 2011 WATER UTILITY EXPENSE ACCOUNT MATRIX ACCT. NO. (a) 601 603 604 610 615 616 618 620 631 632 633 634 635 636 641 642 650 656 657 658 659 660 666 667 668 ,670 675 CURRENT YEAR (c) ACCOUNT NAME (b) Salaries and Wages - Employees Salaries and Wages - Officers, Directors and Majority Stockholders Em loyee Pensions and Benefits Purchased Water Purchased Power · Fuel for Power Production Chemicals Materials and Supplies Contractual Services-Engineeririg Contractual Services - Accounting Contractual Services - Legal Contractual Services- Mgt. Fees Contractual Services - Testing Contractual Services - Other Rental of Building/Real Property Rental of Equipment Trans ortation Expenses Insurance - Vehicle Insurance - General Liability Insurance- Workman's Comp. Insurance - Other Advertising Expense Regulatory Commission Expenses -Amortization of Rate Case Expense . Regulatory Commission Exp.-Other Water Resource Conservation Exp. Bad Debt Expense Miscellaneous Expenses Total Water Utility Expenses $ (d) 322,216 $ W-10(a) GROUP 22,225 I) 18,767 5,802 I) 0 915 0 0 0 0 0 0 0 12,886 5,362 1,163 3,516 731 0 91:5 9,057 I) I) I) 3,13:5 I) I) I) 5,362 1,163 3,516 73l 57,295 0 0 185 77,384 1,026,060 $ 27,006 8,732 3,576 104,785 107,671 0 65,810 5,802 12,562 15,475 27,170 11,181 9,775 0 6,270 63,649 19,891 33,616 41,734 6,981 26,001 5,176 5,162 270 $ .2 SOURCE OF SUPPLY AND EXPENSESMAINTENANCE (e) .1 SOURCE OF SUPPLY AND EXPENSESOPERATIONS I) tttt~~ttittr~~~~~~~trt~ftJt~~ 9,694 $ 99,178 $ 68,800 YEAR OF REPORT UTILITY NAME: WATER MANAGEMENT SERYICES, INC SYSTEM NAME I COUNTY: Franklin December 31, 2011 WATER UTILITY EXPENSE ACCOUNT MATRIX .4 WATER TREATMENT EXPENSES MAINTENANCE (g) .3 WATER TREATMENT EXPENSES OPERATIONS (f) - $ 33,610 - $ 22,226 .5 TRANSMISSION & DISTRIBUTION EXPENSES OPERATIONS (h) .6 .7 .8 TRANSMISSION & DISTRIBUTION EXPENSES MAINTENANCE (i) CUSTOMER ACCOUNTS EXPENSE (j) ADMIN. & GENERAL EXPENSES (k) $ $ 8,732 3,576 8,732 3,576 ~t~~t~~~~l~~l(~~{{~~1~tt~ff~~~~f~1~~ 154 0 0 915 9,056 0 0 0 0 0 0 0 5,362 1,163 3,516 731 ~I~~~~nu~~~~;~~l~r~~~tr~~u~~tll~~~~t~~~~~ 44,776 0 12,562 915 9,057 0 0 0 3,135 0 0 0 915 0 0 0 0 0 30,496 0 0 5,362 1,163 3,516 731 9,694 $ 138,550 9,694 $ 86,410 28,324 72,943 $ $ $ W-lO(b) GROUP 0 917 0 0 0 0 0 30,495 0 20,580 5,359 1,166 3,516 731 0 {~~~~ttJtt~tt~~ttilttttf 0 0 1~~rft~it~ti~~t~~~~~~~~;rmmt~ftf 4,159 0 0 0 0 0 0 0 150 0 0 0 0 0 9,691 0 f~~tff~@Itt~tttt~~i~~~[~~~~~tt~~ 185 6,122 120,016 $ 10,616 153,570 52,392 86,217 :~~fi~~~~~Utt~;~;~~i~~~~~I;~~~~~~tttttii 2,1 13 0 0 9,694 $ 35,254 :mt~~~u~~~tt~I~t~~~~~~~~t1ft~tti~~~ 5,824 0 11,181 9,775 0 0 2,658 19,891 0 9,565 0 4,905 790 0 270 57,295 0 13,101 $ 429,548 UTILITY NAME: WATER MANAGEMENT SERVICES, INC SYSTEM NAME I COUNTY: Franklin YEAR OF REPORT December 31, 2011 PUMPING AND PURCHASED WATER STATISTICS MONTH (a) January February March April May June July August September October November December WATER PURCHASED FOR RESALE ( Omit OOO's ) (b) Total for Year 0 0 0 0 0 0 0 0 0 0 0 0 0 FINISHED WATER PUMPED FROM WELLS ( Omit OOO's ) (c) 9,625 8,635 12,529 14,165 17,912 23,193 25,163 20,378 18,977 16,572 13,252 11,355 191,756 WATER USED FOR LINE FLUSHING, FIGHTING FIRES, ETC. (d) 1,740 1,438 1,887 1,273 1,927 1,484 1,649 1,344 1,296 1,714 ·1,962 1,389 TOTAL WATER PUMPED AND PURCHASED ( Omit OOO's ) [ (b)+(c)-(d)] (e) 7,885 7,197 10,642 12,892 15,985 21,709 23,514 19,034 17,681 14,858 11,290 9,966 19,103 172,653 WATER SOLD TO CUSTOMERS ( Omit OOO's ) (f) 7,306 6,701 8,653 14,286 13,317 20,252 24,708 16,594 16,895 11,492 8,787 10,779 159,770 If water is purchased for resale, indicate the following: Vendor N/A Point of delivery If water is sold to other water utilities for redistribution, list names of such utilities below: N/A SOURCE OF SUPPLY List for each source of supply: Well No. I (1975) Well No.2 (1985) Well No.3 (1993) Well No.4 (2000) CAPACITY OF WELL 360,000 gpd 360,000 gpd 720,000 gpd 720,000 gpd GALLONS PER DAY FROM SOURCE 360,000 360,000 720,000 720,000 2,160,000 W-11 GROUP SYSTEM _ _ _ _ __ TYPE OF SOURCE Floridan Aquifer Floridan Aquifer Floridan Aquifer Floridan Aquifer YEAR OF REPORT UTILITY NAME: WATER MANAGEMENT SERVICES, INC SYSTEM NAME I COUNTY: Franklin December 31, 2011 WATER TREATMENT PLANT INFORMATION Provide a separate sheet for each water treatment facility Permitted Capacity of Plant (GPD): 1,240,000 Location of measurement of capacity (i.e. Wellhead, Storage Tank): Storage Tank Type of treatment (reverse osmosis, (sedimentation, chemical, aerated, etc.): Aeration and Chlorination, Ground & Elevated Storage Tanks LIME TREATMENT Unit rating (i.e., GPM, pounds per gallon): Not Applicable Manufacturer: Not Applicable Pressure (in square feet): Not Applicable Manufacturer: Not Applicable Gravity (in GPM/square feet): Not Applicable Manufacturer: Not Applicable FILTRATION Type and size of area: W-12 GROUP SYSTEM _ _ _ _ __ YEAR OF REPORT UTILITY NAME: WATER MANAGEMENT SERVICES, INC SYSTEM NAME I COUNTY: Franklin December 31, 2011 CALCULATION OF THE WATER SYSTEM METER EQUIVALENTS METER SIZE (a) All Residential 5/8" 3/4" 1" 1 1/2" 2" 3" 3" 3" 4" 4" 6" 6" 8" 8" 10" 10" 12" TYPE OF METER (b) EQUIVALENT FACTOR (c) Displacement Displacement Displacement Displacement or Turbine Displacement, Compound or Turbine Displacement Compound Turbine Displacement or Compound Turbine Displacement or Compound Turbine Compound Turbine Compound Turbine Turbine 1.0 1.0 1.5 2.5 5.0 8.0 15.0 16.0 17.5 25.0 30.0 50.0 62.5 80.0 90.0 115.0 145.0 215.0 TOTAL NUMBER OF METER EQUIVALENTS (c x d) (e) NUMBER OF METERS (d) 1,698 68 4 30 10 5 1,698 68 6 75 50 40 2 32 1 25 1 63 Total Water System Meter Equivalents 2,057 CALCULATION OF THE WATER SYSTEM EQUIVALENT RESIDENTIAL CONNECTIONS Provide a calculation used to determine the value of one water equivalent residential connection (ERC). Use one of the following methods: (a) If actual flow data are available from the preceding 12 months, divide the total annual single family residence (SFR) gallons sold by the average number of single family residence customers for the same period and divide the result by 365 days. (b) If no historical flow data are available, use: ERC = ( Total SFR gallons sold (Omit 000) I 365 days I 350 gallons per day) ERC Calculation: 159,770,000 total gallonsl365/350 GPD/ERC = 1251 ERCs W-13 GROUP SYSTEM _ _ _ _ __ YEAR OF REPORT UTILITY NAME: WATER MANAGEMENT SERVICES. INC SYSTEM NAME I COUNTY: Franklin OTHER WATER SYSTEM INFORMATION Furnish information below for each system A separate page should be supplied where necessary. 1. Present ERCs *the system can efficiently serve. 2125 2. Maximum number ofERCs *which can be served. 2125 3. Present system connection capacity (in ERCs *) using existing lines. 2125 4. Future connection capacity (in ERCs *)upon service area buildout.. 3389 5. Estimated annual increase inERCs *. 56 6. Is the utility required to have fire flow capacity? If so, how much capacity is required? No N/A 7. Attach a description of the fire fighting facilities. Ground storage, pumping, looped mains, 140 fire hydrants, high pressure pumps, looped water lines, cut-off valves. 8. Describe any plans and estimated completion dates for any enlargements or improvements of this system: New 600,000 gallon ground storage tank, new 12" supply main, new electrical equipment, pumping equipment, _ _ _ _ _ _ chlorine facilities and generator, new 5th well with related piping and appertanances. _ _ _ _ _ _ Est. completion dat..;;.e_-...:.7.:..;/1:.:../.:..14..:..__ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ __ 9. When did the company last file a capacity analysis report with the DEP? 24-Sep-99 10. If the present system does not meet the requirements ofDEP rules: Not Applicable a. Attach a description of the plant upgrade necessary to meet the DEP rules. b. Have these plans been approved by DEP? c. When will construction begin? d. Attach plans for fimding the required upgrading. e. Is this system under any Consent Order with DEP? 11. Department of Environmental Protection ID # 1190789 12. Water Management District Conswnptive Use Permit# a. Is the system in compliance with the requirements of the CUP? b. If not, what are the utility's plans to gain compliance? * AnERC is determined based on the calculation on the bottomofPage W-13. W-14 GROUP SYSTEM _ _ _ _ __ 830074 Yes Not applicable