{"text_format":"1","workbook":"xlsx","n_sheets":31,"sheets":["Cover","General Instructions","Detailed Instructions","Pg1 Gen Info","Pg2 Stock, Sec Hldrs&Voting Pwr","Pg3 Chgs During Year","Pg4_BS-Assets","Pg5_BS-Eq & Liab","Pg6_Sch of Uncollectibles","Pg7_Payroll Info","Pg8_Contract Svcs","Pg9_CIAC","Pg10_Debt","Pg11_M&S","PgW-1_Op Rev&Exp","PgW-2_Op Rev&Exp","PgW-3_Op Rev&Exp","PgW-4_Pump&Purch Wtr","PgW-5_Wtr Plant","PgW-6_Depr Res-Wtr Plant","PgW-7_Pumps&Wells","PgW-8_Meters&Storage","PgW-9_Mains","PgS-1_Op Rev&Exp","PgS-2_Op Rev&Exp","PgS-3_Op Rev&Exp","PgS-4_Swr Plant","PgS-5_Depr Res-Swr Plant","PgS-6_Gen Info","Sheet1","Verification"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":95,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":81,"n_cols":7,"rows_kept":81,"cut":false,"hidden":false,"merged":[[3,0,3,9],[0,0,0,9],[1,0,2,9],[4,0,4,9],[30,6,30,8],[13,4,13,6],[5,0,5,9],[7,0,7,9],[9,0,9,9],[11,0,11,9],[8,0,8,9],[14,6,14,7],[25,0,25,4],[14,0,14,5],[26,2,27,9],[17,0,17,8]]}
["Algonquin Water Resources of Missouri- dba Resort Utilities"]
["Company Full Certificated Name (Do not abbreviate and include any Commission approved AKA/DBA/Fictitious Name, if applicable.)"]
[]
["Algonquin Water Resources of Missouri- dba Resort Utilities"]
[]
["WATER and/or SEWER ANNUAL REPORT"]
[]
["SMALL COMPANY"]
["(Fewer than 8,000 customers)"]
["TO THE"]
[]
["MISSOURI PUBLIC SERVICE COMMISSION"]
[]
[null,null,null,null,"    For the Calendar Year of "]
["January 1 - December 31,",null,null,null,null,null,2011]
[]
[]
["Please select how the company is certificated with the Commission under the Company Name as shown above (check all that apply):"]
[null,"X","Water Service Provider "]
[]
[null,"X","Sewer Service Provider"]
[" "]
["Please choose one of the following filing options: "]
[]
[null,"X","Public Submission (NOT Highly Confidential)"]
[]
[null,null,"Non-Public Submission (Highly Confidential / Filed Under Seal)\nFor this filing to be considered Highly Confidential, additional submission of materials is required pursuant to Commission rule 4 CSR 240-3.335 and/or 4 CSR 240-3.640, Section 392.210, RSMo., and/or Section 393.140, RSMo."]
[]
[]
[]
["Excel Revised 02/03/2011"]
[null,null,null,null,null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Public"]
[null,null,null,null,null,null,"Highly Confidential"]

{"sheet":"General Instructions","index":1,"n_rows":74,"n_cols":3,"rows_kept":74,"cut":false,"hidden":false,"merged":[[0,0,1,10],[2,0,2,10],[3,0,3,10],[4,0,4,10],[5,0,5,10],[6,0,6,10],[7,0,7,10],[8,0,8,10],[9,0,9,10],[10,0,10,10],[11,0,11,10],[12,0,12,10],[13,0,13,10],[14,0,14,10],[15,0,15,10],[16,0,16,10],[17,0,17,10],[18,0,18,10],[19,0,19,10],[20,0,20,10],[21,0,21,10],[22,0,22,10],[23,0,23,10],[24,0,24,10],[25,0,25,10],[27,1,27,10],[28,1,28,10],[29,2,29,10],[30,2,30,10],[31,0,31,10],[32,0,32,10],[33,0,33,10],[36,2,36,10],[37,2,37,10],[38,0,38,10],[39,0,39,10],[40,0,40,10],[41,0,41,10],[42,0,42,10],[43,0,43,10],[44,0,44,10],[45,0,45,10],[46,0,46,10],[47,0,47,10],[48,0,48,10],[49,0,49,10],[50,0,50,10],[51,0,51,10],[52,0,52,10],[52,11,52,21],[52,88,52,98],[52,99,52,109],[52,110,52,120],[52,121,52,131],[52,22,52,32],[52,33,52,43],[52,44,52,54],[52,55,52,65],[52,66,52,76],[52,242,52,252],[52,253,52,255],[53,0,53,10],[54,0,54,10],[55,0,55,10],[52,187,52,197],[52,198,52,208],[52,209,52,219],[52,220,52,230],[52,231,52,241],[52,132,52,142],[52,143,52,153],[52,154,52,164],[52,165,52,175],[52,176,52,186],[52,77,52,87],[56,0,56,10],[57,0,57,10],[58,0,58,10],[59,0,59,10],[60,0,60,10],[61,0,61,10],[62,0,62,10],[63,0,63,10],[65,0,65,10],[64,0,64,10],[66,0,66,10],[67,0,67,10],[68,0,68,10],[69,0,69,10],[70,0,70,10],[71,0,71,10],[72,0,72,10],[73,0,73,10],[79,0,79,1],[74,2,74,10],[75,2,75,10],[76,2,76,10],[77,2,77,10]]}
["Missouri Public Service Commission 2009 Annual Report Instructions"]
[]
["General Form Information"]
["This report is due to the Missouri Public Service Commission on or before April 15th and is required to be filed on a calendar year basis pursuant to the Commission rules (4 CSR 240-3.335 and/or 4 CSR 240-3.640).  Failure to file this report by the deadline of April 15, 2010, could result in penalties up to $100 for every day the report is late pursuant to Section 392.210, RSMo."]
["•   If the document has been prepared by a third-party preparer, it is the responsibility of the \n    company personnel attesting to the accuracy of the document to review the document before \n    submission to the Missouri Public Service Commission."]
["•  After the annual report is complete, save the file to your computer.  You may submit it\n   electronically through the Commission's Electronic Filing and Information System (EFIS), as a   \n   non-case related submission (see Electronic Filing Instructions on Instructions Pages 4 - 5 \n   for details) or print the form, keep a copy for your records, and prepare for mailing."]
["•  You shall use the form provided by the Commission.   You may use one of the three versions \n    provided:  1) the Adobe Fillable document, 2) the Excel version, or 3) the Adobe document \n    that shall be printed and completed by hand. "]
["•  The Excel form is \"read only\". You must save or copy the file to your computer's hard drive to \n    input information into the annual report form."]
["•  If additional space is needed for entering information on a page, please insert a worksheet or\n   page and copy the formats or lines into the new sheet to accommodate the necessary\n   information.  "]
["•  If you are submitting an annual report extension request, it must be on company letterhead or\n   on the form provided and signed by an officer of the company.  A contact email address is also\n   required for approval or rejection of the request. "]
["Questions about the annual report form or its contents may be submitted to: Joan Wandel at \n(573) 751-4785 or by e-mail at  joan.wandel@psc.mo.gov.  "]
[]
["Treatment of Highly Confidential Information (Submission Under Seal)."]
["Utilities may request classification of selected portions of their annual report as non-public \n(highly confidential / filed under seal) pursuant to the Commission rules at 4 CSR 240-3.335 and/or \n4 CSR 240-3.640. \n         \nPlease note that all information classified as non-public will still remain subject to potential disclosure as provided under the Missouri open records act (Chapter 610 RSMo) and Section 386.480, RSMo."]
["In order to include Highly Confidential information in the annual report, the submitter must: "]
["Provide two versions of the annual report;\n1) a Public version with the Highly Confidential information redacted (removed), and\n2) a fully completed version to be kept as Highly Confidential with restricted access.\n\nBelow are the procedures outlining the requirements for each type of submission: "]
["(A) Public version"]
["1. Cover – Check the “Public Submission” box and denote “Public” in the lower right corner.\n2. Completion – All pages should be completed excluding the non-public information.\n3. Page Designation – Each page that has had Highly Confidential information removed must\n    have the “Public” designation in the lower right corner.\n4. Format – where Highly Confidential information has been removed, two (2) asterisks shall\n    be placed before and after the information, e.g. **highly confidential information removed**.   \n    The field must be left blank to insure the information remains on the same line and page \n    as in the Highly Confidential version."]
["(Treatment of Highly Confidential Information [Submission Under Seal] continued on the next page.)"]
["-Instructions Page I-"]
["Treatment of Highly Confidential Information (Submission Under Seal)  -  continued"]
["(B) Highly Confidential version"]
["1. Cover – Check the “Non-Public Submission” box and denote “Highly Confidential” in the lower\n    right corner. \n2. Completion – All pages should be completed including the Highly Confidential information\n3. Page Designation – Each page that contains Highly Confidential information must have a\n    “Highly Confidential” designation in the lower right corner.\n4. Format – Highly Confidential information shall be designated by two (2) asterisks before\n    and after the information, e.g. **your highly confidential information here**. "]
["(C) Additional documents required with both submissions: "]
["1. A cover letter stating the utility is designating some or all of the information in its annual\n    report as confidential and requesting non-public treatment under seal. The name, phone\n    number and e-mail address (if available) of the person responsible for addressing\n    questions regarding the confidential portions of the annual report must be included.\n2. A notarized affidavit that clearly identifies the specific types of information to be kept\n    under seal. Justification of why the specific information should be a closed record and a\n    statement attesting that none of the information is available to the public in any format."]
["Detailed Form Information"]
["Page","Definitions and/or Instructions"]
["Cover","Company Name:  This shall reflect the certificated name of the company that the Commission approved in a case; when this field is filled in, it will automatically populate\nthe company name at the top of each of the following sheets.\nThe company name listed on the cover shall include any Commission approved fictitious name or d/b/a name (ABC Company d/b/a XYC LLC).\nYear:  When the reporting period year is entered, it will automatically populate at the top of all subsequent pages. \n\n"]
[null,"First check box (certification/registration type):  \nCheck the box if the company listed on the Company Name line has been approved as competitively classified by the Commission.  \n\nSecond set of check boxes (security level/filing options):  \nCheck the first box (Public Submission) if this is the public version of the annual report.  \n\nCheck the bottom box (Non-Public Submission) only if the annual report contains proprietary or highly confidential information in the report.  The annual report submission will be considered deficient unless this submission is accompanied by the required documentation.  Please see Treatment of Highly Confidential Information in the above section for details.         \n"]
["Verification Page",null,"The verification page must be completed in full, including notary seals, if or where applicable. \n\nThis page must accompany all versions of this report including any original or revised,  highly confidential, proprietary and public versions. "]
[null,null,"The State Of and County Of fields shall be filled  with the location where the notary operates and where this document was notarized. \nLegal Name of Affiant: Any representative of the company authorized to attest to the accuracy of the annual report. \nOfficial Title of the Affiant: Title of the representative named on the line just above this one. \n\n"]
["(Verification Page instructions continued on the next page. )"]
["-Instructions Page II-"]
["Detailed Form Information (continued)"]
["Page","Definitions and/or Instructions"]
["Verification Page (continued) "]
[null,null,"Exact Legal Title or Name of the Respondent: Company Name as certificated/registered with the Commission, as listed on the cover and the top of the verification sheet. \n\nSignature of Affiant: Signature of authorized company representative named above on the verification page.   \n\nThe remaining fields are for completion by the notary including the date, month and year of the notarization, the notary's commission expiration date, notary signature,  and placement of the notary stamps or seals, where applicable. "]
[null,null,"When submitting the annual report form electronically, complete the verification page in full.  Electronic signatures are acceptable pursuant to Sections 432.200 through \n432.295 RSMo.  \n\nThe original document shall be notarized and kept for your records.  On the electronic version, type the electronic signatures ( /s/ John Doe)  and dates that are reflected on the original document."]
["Options for Submitting the Annual Report to the Missouri Public Service Commission "]
["The annual report may be submitted to the Missouri Public Service Commission by either of the following methods:  "]
["1. Electronically through the Electronic Filing and Information System (EFIS).\nThis system accepts submissions 24 hours a day and saves on postage/shipping expenses.  \nPlease see Instructions Page 4 - 5 for detailed instructions to use this system.  If you have questions while using EFIS, staff is available Monday - Friday from 8:00 a.m. - 5:00 p.m. \n(excluding State holidays) to assist you at (573) 751-7496. \nNOTE:  E-mails and faxes are NOT acceptable methods of filing the annual report electronically."]
["or"]
["2. Mail to the following address: \nMissouri Public Service Commission \nAttention: Data Center \n     \nFor package delivery: \n200 Madison Street, Suite 100 \nJefferson City, MO 65101 \n\nFor U.S. Mail: \nP.O. Box 360 \nJefferson City, MO 65102-0360 "]
["-Instructions Page III-"]
["Electronic Filing of Annual Report Information"]
[]
["If you submit your information electronically, please do not send in a paper copy."]
["In order to file in the Electronic Filing and Information System (EFIS):"]
["• You must have a user ID and password,\n• The company you are filing on behalf of must be registered in EFIS.\n   (All certificated companies are already registered in EFIS.  Please do not create a company\n   registration), \n• The person making the filing must be registered as a contact for the company/firm they are\n   making the filing on behalf of, and\n• You need to have the information you want to submit saved electronically."]
["If you are unsure if you have a user ID, if your company is registered, or if you are registered as a contact for the company, please contact the Data Center at  datacenter-psc@psc.mo.gov or \n(573) 751-7496 before completing new registration information.\n"]
["To access EFIS, go to the PSC website at http://www.psc.mo.gov.  Click the ‘EFIS / Case Filings’ link from the menu on the left-hand side.  Scroll down to the ‘Main Menu Section of EFIS’ and click on the ‘EFIS’ link. This will take you to the EFIS Welcome Screen."]
["• Click the orange ‘Logon’ button on the left-hand side.\n• Enter your User ID and Password.\n   NOTE: Passwords are case sensitive."]
["Submission of Annual Report "]
["• Click on the ‘Filing/Submission’ menu option.\n• Click on the ‘Non-Case Related Submission’ link."]
["Complete the Non-Case Related Submission screen with the following information: "]
["• Type of Utility – Select the utility type as which the company is certificated/registered.\n  Separate submissions are required if a company has multiple certifications/registrations\n  (Example:  Water and Sewer; or CLEC and IXC).\n• Company – Select certificated company name. \n  Choose d/b/a name, if applicable.  This name should match the name at the top of the \n  annual report's cover page.\n• Type of Submission – Select ‘Annual Report (Mo PSC)’.\n• Total Missouri Jurisdictional Revenue – Enter the amount from the annual report form found\n   on Page 1, Item No. 16 (Water) or Item No. 19 (Sewer).\n• Report for Calendar Year - Type in 2009.\n• Applicable Case No. – Leave blank.\n• Date Filed – Will already be filled in.\n• Click on the ‘Continue’ button.\n  This will take you to the Filing/Submission Attachment screen.\n• Click on ‘Browse’ – Select the file that contains the completed annual report.\n• Choose the security level for your document:  Public, Highly Confidential, or Proprietary.\n• Click the ‘Attach’ button.\n  On screen instructions are provided for attaching more than one document.  \n  Confirm that the correct document is attached before proceeding.  \n• Click the ‘Done with Attach’ button.\n  This will return you to the original submission screen.\n• Scroll down and click on the ‘Submit’ button."]
["This will complete your submission and assign a non-case related tracking number (BMAR-2009-xxxx).  Please retain this number for your records. \n"]
["-Instructions Page IV-"]
["Electronic Filing of Annual Report Information (continued)"]
["Submission of Additional Information"]
["If you are asked to provide additional information or need to file amended information, file it as a \n‘Non-Case Related Supplemental Submission’ using the tracking number from your original annual report submission."]
["Instructions for this type of submission can be found by clicking on the blue ‘Help’ button on the left-hand side of any EFIS screen.  Scroll down to ‘Filing / Submission – Non-case Related’.  Then choose 'Make a subsequent filing to a non-case related submission'."]
["Request for Extension\n(30 days or Less)"]
["If you will not be able to file your annual report by the April 15th deadline, you must request an extension on or before April 15th."]
["All annual report extension requests must be on company letterhead and signed by an officer of the company or on the form provided on the PSC website (www.psc.mo.gov/forms) and signed electronically by a company representative.  A contact e-mail address is required for approval or rejection of the request"]
["Follow the instructions for filing an annual report with these modifications."]
["• Type of Submission - Select Annual Report (MO PSC) Extension Request.\n• Comments - Type in 2008 Annual Report Extension Request.\n• Under “Browse”, attach your documentation for requesting an extension."]
["Once your submission is complete, you will be assigned a non-case related tracking number (BARE-2010-xxxx).  Please retain this number for your records. "]
["Additional instructions can be found under the blue ‘Help’ button in EFIS on how to:"]
["• Access EFIS.\n• Log on to EFIS. \n• Obtain a user ID and password.\n• Reset my password. \n• File an annual report, statement of revenue, or other non-case related submission. \n• Make a subsequent filing to a non-case related submission. "]
[]
[]
[]
["-Instructions Page V-"]

{"sheet":"Detailed Instructions","index":2,"n_rows":101,"n_cols":1,"rows_kept":101,"cut":false,"hidden":false,"merged":[[49,0,50,0]]}
["DETAILED FORM INSTRUCTIONS"]
["     This form should be used by companies that have fewer than 8,000 customers.  "]
["     In examining the report form you will note there are various references requiring water information and sewer information on the same page."]
[]
["     If you have water operations only, you should complete all information for water utilities.  Any requested information for sewer data should be clearly marked by you as Not Applicable (e.g., N.A.)."]
[]
["     If you have sewer operations only, you should complete all information requested for sewer utilities.  Any requested information for water data should be clearly marked by you as Not Applicable (e.g., N.A.). "]
[]
["     If you are a joint utility in that you have both water and sewer operations, you shall fill out all parts of all pages completely to the best of your ability and belief utilizing the available information.  You will note that all pages on Lines 1 and 2 require the year of the report and the company name.  This must be completed on all pages."]
[" "]
["   If this document has been prepared by a third-party preparer, it is the responsibility of the company personnel attesting to the accuracy of document to review the document before submission to the Missouri Public Service Commission."]
[]
["INSTRUCTIONS for PAGE 1"]
["     On Line 2, provide the full company name as it appears on your certificate of convenience and necessity."]
["     On Lines 3, provide the company street address.  On Line 4, provide the mailing address if different than Line 3. "]
["     On Line 5, provide the company phone number and the e-mail address of the regulatory contact.  If an e-mail address is not available please designate with \"n/a\"."]
["     On Lines 6 through 15, provide names, addresses, phone numbers and e-mail addresses of any persons who can be contacted concerning information contained in this report."]
["     On Lines 13 through 17, provide names, addresses, phone numbers and e-mail addresses of any persons who can be contacted concerning plant operations."]
["      On Lines 16 through 21, please enter the Company Revenues indicated.  If using the Excel version, the Missouri Jurisdictional Revenues will automatically fill from pages W-2 and S-2.  "]
[]
[" INSTRUCTIONS for PAGE 2"]
["     On Line 2, provide the full company name as it appears on your certificate of convenience and necessity."]
["     On Lines 3 through 7, provide for each class and/or series of common and/or preferred stock the total number of shares authorized by charter, the par or stated value per share and the total number of shares issued."]
["     On Lines 8 through 15, provide the names, addresses and number of votes resulting from stock ownership as of December 31.  If any such holder held the stock in trust, state the nature of the trust and the beneficial owner. "]
["     On Line 16, provide total number of votes held by the names provided in lines 8 through 15."]
["     On Line 17,  provide the total number of votes of all securities with voting rights."]
["     On Lines 18 - 23, provide the title and names of the officers of the company at the end of the reporting year."]
["      On Line 21 and 22, check all boxes for which the company is current.  "]
["      On Line 23, provide the case number and effective date of the last approved rate request case with the Commission. "]
["      On Lines 27 and 28, check all boxes for which the company has filed and is current on the appropriate paperwork and payments. "]
["      On Line 29, provide the most recent rate increase request case number and effective date of approval. "]
["-Instructions Page VI-"]
["INSTRUCTIONS for PAGE 3"]
["     On Line 2, provide the full company name as it appears on your certificate of convenience and necessity."]
["     Describe all transactions occurring during the year that will have a major effect on operations.  "]
["These transactions may be rate changes, the replacement of major equipment or any other abnormal cash expenditure amounting to $250 or more.  Please note that if the expenditure is of a normal and recurring nature (i.e., monthly electric bills), it should not be classified as an abnormal item."]
[]
["INSTRUCTIONS for PAGE 4"]
["     The dollar amount for Lines 3, 4, 6, 10, 11 and 13 should be brought forward from the appropriate page and line as indicated."]
["     Construction Work in Progress:  Shall include the total amount of work for utility plant in process of construction but not ready for service at the end of the year. "]
["     Plant Held for Future Use:  Shall include the original cost of property owned and held for future use under a definite plan for use."]
["     Plant Acquisition Adjustment:  Shall include the purchase price of any plant purchased less the original cost, estimated if not known, less any depreciation reserve."]
[]
["INSTRUCTIONS for PAGE 5"]
["     The dollar amount for Lines 11, 12, 16 and 17 should be brought forward from the appropriate page and line as indicated."]
["     Customer Deposits:  Shall include all deposits with the utility by customers as security for payment of bills."]
["     Advances for Construction:  Shall include advances by any applicant for construction that is to be refunded either in part or completely."]
["     Contributions in Aid of Construction (CIAC):  Shall include any donation or contribution in cash or services, or property from any company, individual, agency or others for construction purposes.  CIAC shall include connection fees for new service. All supporting entries shall be kept so that the utility can furnish information regarding the purpose of each donation, and the amount of the donation.  (NOTE:  There shall not be any advances for construction that are to be repaid in part or completely included in this account except if not returned by the time specified in the utilities tariff.)"]
[]
["NOTE:  TOTAL ASSETS FROM PAGE 4 MUST BALANCE WITH TOTAL EQUITY AND LIABILITIES FROM PAGE 5"]
[]
[]
["INSTRUCTIONS for PAGE 6"]
["     On Page 6, provide information for all customer sales determined to be uncollectible.  You should identify the customer, the methods used to attempt collection, the amount and why it is uncollectible (i.e., customer filed bankruptcy, left town, etc.).  This uncollectible amount is an expense to be recorded on the Income Statement (Page W-1 and/ or S-1)."]
[]
["INSTRUCTIONS for PAGE 7"]
["     On Page 7, provide information regarding payroll.  Provide names, titles and salaries of all officers and employees.  Provide total compensation paid to each during the year including bonuses and other allowances. Identify the total compensation as chargeable to water expense, sewer expense or construction.  Also, identify any employee who did not receive any compensation during the year."]
[]
["INSTRUCTIONS for PAGE 8"]
["     On Page 8, provide information regarding professional services the utility company received.  Report all information concerning rate, management, construction, engineering, research, financial, valuation, legal, accounting, purchasing, advertising, labor relations, public relations, or other similar professional services rendered the respondent under written or verbal arrangements, for which total payments during the year to any corporation, partnership, individual (other than for services as an employee), or organization of any kind whatsoever."]
["-Instructions Page VII-"]
[]
["INSTRUCTIONS for PAGE 9"]
["     On Page 9, provide information regarding contributions in aid of construction and the amortization of contributions in aid of construction.  This account shall include donations or contributions in cash, services, or property for construction purposes, including connection fees for new service.  The records supporting the entries to this account shall be so kept that the utility can furnish information as to the purpose of each donation, the conditions, if any, upon which it was made, the amount of each donation, and the amount applicable to each utility department.  The credits (deductions) to this account shall not be transferred to any other account without the approval of the Commission."]
["   Lines 3 and 4 require input from last year's annual report page 9."]
["   Line 4 is the recording of new contributions for this year. "]
["   Line 11 depends on the method your company uses for CIAC amortization.  If your company uses the \"distributed\" method as described below, no retirement entries for CIAC should appear in line 11, (leave them blank)."]
["     For retirement purposes, Contributions in Aid of Construction (CIAC) are amortized at the same rate as the depreciation rates set for the plant equipment.  There are two methods as follows: "]
["     1. Attached Method: This method is the keeping of continuous property records such that the contributions are kept “attached” to the original equipment contributed. CIAC is amortized and retired at the same depreciation rate and retirement dates as the equipment which it is “attached” to.   For this method complete the table with Line 18 through Line 24.  "]
["    2. Distributed Method: Most small companies use this method. This method results in no CIAC retirement entries on line 11. The “distributed” method is to treat each contribution as a dollar amount that is equally distributed to all plant in service.  Under this method, the annual CIAC amortization is a portion of the total plant depreciation expense.  The ratio used to calculate this portion is the end of year CIAC balance divided by the end of year total plant in service. The CIAC amortization is simply the total plant depreciation expense multiplied by the ratio of CIAC to Total Plant.  The annual amortization is added to the sum of all prior accumulated amortization until the total equals the original amount of all contributions. At this point the process is stopped and both the total CIAC and the accumulated amortization are reset to zero.  For this method, complete the table containing Line 25 through Line 27. "]
[]
["     INSTRUCTIONS for PAGE 10"]
["     On Page 10, provide all required information concerning interest expense, notes payable, bonds, bank loans and other financial debts that existed during the year.  For each debt on which interest was paid during the year provide the name and address of the lender, the date of maturity, the loan balance, the interest rate on the loan, and the amount of interest paid.  The amount of interest paid should be assigned to water utility expense and/or sewer utility expense based upon which utility was responsible for the loan."]
[]
["INSTRUCTIONS for PAGE 11"]
["     On Page 11, provide descriptions, quantities and dollar costs of materials and supplies in inventory.  These items may be pipe, wire, gasoline, diesel, etc.  You should identify the cost and assign the cost to either water or sewer."]
[]
["INSTRUCTIONS for PAGES W-1, W-2, W-3 and/or S-1, S-2, S-3"]
["     On Pages W-1, W-2, W-3 and/or S-1, S-2, S-3, provide information regarding all billed revenues, expenses, customer numbers and gallon sales."]
[]
["INSTRUCTIONS for PAGE W-4"]
["     On Page W-4, provide information regarding quantities of water from each source of supply that entered the system.  On Line 21, provide data regarding the maximum and minimum quantities of water supplied in any one day.  On Line 22, provide the range of pressures that exist at the highest point of the system.  On Lines 23 thru 26, provide information regarding any sale of water for resale.  "]
["-Instructions Page VIII-"]
["INSTRUCTIONS for PAGES W-5, W-6 and/or S-4, S-5"]
["     On Pages W-5, W-6 and/or S-4, S-5, provide information regarding water and/or sewer utility plant-in-service, depreciation expense and depreciation reserve.  The account numbers shown in column (b) are defined in the Uniform System Of Accounts (USOA). The definitions describe what type of plant equipment is included in each account number.   For each company, a USOA CLASS, a set of account numbers, and a set of depreciation rates are assigned by the PSC.  These assignments for use by your company should be specified in a Depreciation Rate Schedule included as part of your company's last certificate or rate case final order.  If you do not have this schedule, call the PSC and ask to speak to someone in the Engineering and Management Services Department"]
["      Columns (c), (d), (e) and (f) require original installed cost of plant and equipment placed in service.  If a replacement of plant occurs, such as a pump change-out or trading in a truck, then column (d) should show the full installed cost of the new item.  In retirement column (e), record the original installed cost (from Plant Property Records), of the item which was replaced (removed).   These entries should be supported by books and records, which identify the property and its location.   The Balance at End of Year, column (f) equals columns (c) plus (d) minus (e). "]
["       Depreciation expense column (h) is computed using the Balance at End of Year column (f), --- or mid-year or mid-month convention used by your company.  Record in column (g) the depreciation rate used, (from you company's PSC Depreciation Rate Schedule).  Column (i) is the carry forward of depreciation reserve from last years annual report.  Book Cost of Plant Retired column (j) should be the same as Retirements During the Year column (e).  Column (k) should reflect cost incurred to remove the plant which was retired.  Column (l) should reflect any money received from the sale or trade-in of the equipment removed or replaced.                           Reserve balance at End of Year column (n) equals (h) plus (i) minus (j) minus (k) plus (l) plus (m).                             "]
["                             ***SAVE A COPY FOR NEXT YEARS BEGINNING BALANCES****"]
[]
["INSTRUCTIONS for PAGE W-7"]
["     On Page W-7, provide historical and statistical information regarding water pumps and wells."]
[]
["INSTRUCTIONS for PAGE W-8"]
["     On Page W-8, provide historical and statistical information regarding water meters, meter settings and storage facilities."]
[]
["INSTRUCTIONS for PAGE W-9"]
["     On Page W-9, provide historical information regarding the feet of water mains and number of service lines by size and type."]
[]
["INSTRUCTIONS for PAGE S-6"]
["On Page S-6, provide historical and statistical information regarding sewer treatment facilities, lift stations and feet of collecting sewers by size and type."]
["-Instructions Page IX-"]

{"sheet":"Pg1 Gen Info","index":3,"n_rows":82,"n_cols":16,"rows_kept":82,"cut":false,"hidden":false,"merged":[[27,8,27,14],[37,8,37,14],[36,1,36,5],[36,8,36,14],[32,1,32,5],[32,8,32,14],[31,1,31,5],[31,8,31,14],[27,1,27,5],[33,1,33,3],[29,1,29,5],[29,8,29,14],[30,1,30,5],[30,8,30,14],[16,8,16,14],[22,8,22,14],[24,8,24,14],[15,8,15,14],[20,8,20,10],[4,4,4,14],[9,1,10,3],[9,4,10,8],[9,9,10,9],[10,10,10,14],[24,1,24,5],[17,1,17,5],[38,1,38,5],[38,8,38,14],[37,1,37,5],[23,8,23,14],[19,1,19,3],[20,1,20,3],[19,8,19,10],[22,1,22,5],[21,1,21,5],[23,1,23,5],[21,8,21,14],[33,8,33,10],[28,1,28,5],[28,8,28,14],[16,1,16,5],[18,1,18,5],[0,1,0,13],[17,8,17,14],[18,8,18,14],[13,1,13,5],[13,8,13,14],[15,1,15,5],[14,1,14,5],[1,1,2,3],[2,4,2,14],[6,4,6,14],[8,4,8,14],[14,8,14,14],[11,1,12,14],[7,1,8,3],[40,1,40,2],[34,1,34,3],[34,8,34,10],[35,1,35,5],[35,8,35,14],[47,13,47,14],[48,13,48,14],[41,1,41,6],[41,13,41,14],[41,9,41,10],[42,13,42,14],[43,1,43,6],[43,13,43,14],[42,1,42,6],[42,9,42,10],[43,9,43,10],[52,13,52,15],[53,13,53,15],[54,10,54,16],[44,1,44,6],[44,9,44,10],[44,13,44,14],[50,1,50,6],[47,1,47,6],[47,9,47,10],[48,9,48,10],[48,1,48,6],[49,1,49,6],[49,9,49,10],[50,9,50,10],[50,13,50,14],[49,13,49,14]]}
[1,"For the calendar year of January 1 - December 31,",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]
[null,"Company Name:",null,null,{"$f":"IF(Cover!$B$1>0,Cover!$B$1,\" \")","v":" "}]
[2,null,null,null,{"$f":"IF(Cover!A1>0, Cover!A1, \" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[]
[null,"Parent Company Name: "]
[null,"(if applicable)"]
[3,"Company Street Address:",null,null,"12725 W. Indian School Rd., Suite D101 Avondale, AZ"]
[null,"Company Mailing Address: "]
[4,null,null,null,"12725 W. Indian School Rd., Suite D101 Avondale, AZ"]
[null,"Company Phone Number:",null,null,"623-935-9367",null,null,null,null,"Company \nE-mail Address: "]
[5]
[null,"Name, address, phone number and e-mail of person(s) to contact concerning information contained in this report:"]
[]
[6,"Shawn Bundy"]
[null,"Name",null,null,null,null,null,null,"Name"]
[{"$f":"SUM(A14+1)","v":7},"12725 W. Indian School Rd., Suite D101 Avondale, AZ"]
[null,"Mailing Address",null,null,null,null,null,null,"Mailing Address"]
["7a","12725 W. Indian School Rd., Suite D101 Avondale, AZ."]
[null,"Street Address",null,null,null,null,null,null,"Street Address"]
[8]
[null,"City",null,null,"State","Zip",null,null,"City",null,null,null,null,"State","Zip"]
[9,"623-298-3744"]
[null,"Telephone Number",null,null,null,null,null,null,"Telephone Number"]
[10,"Shawn.Bundy@libertywater.com"]
[null,"E-mail Address",null,null,null,null,null,null,"E-mail Address"]
[]
[null,"Name, address, phone number and e-mail address of person(s) to contact concerning plant operations:"]
[11]
[null,"Name",null,null,null,null,null,null,"Name"]
[12]
[null,"Mailing Address",null,null,null,null,null,null,"Mailing Address"]
["12a"]
[null,"Street Address",null,null,null,null,null,null,"Street Address"]
[13]
[null,"City",null,null,"State","Zip",null,null,"City",null,null,null,null,"State","Zip"]
[14]
[null,"Telephone Number",null,null,null,null,null,null,"Telephone Number"]
[15]
[null,"E-mail Address",null,null,null,null,null,null,"E-mail Address"]
[" ","Please provide the total company and gross intrastate operating revenues (i.e. Missouri Jurisdictional) Revenues"]
[null,"for the Calendar Year:",null,{"$f":"IF(Cover!G15>0, Cover!G15,\" \")","v":2011}]
[null,"Water Revenues",null,null,null,null,null,null,"**","MO Jurisdictional",null,"**","**","Total Company",null,"**"]
[16,"Operating Revenues from Tariffed Services",null,null,null,null,null,null,null,540804.81999999995,null,null,null,{"$f":"+J43","v":540804.81999999995}]
[17,"Other Revenues",null,null,null,null,null,null,null,47.99,null,null,null,{"$f":"+J44","v":47.99}]
[18,"TOTAL REVENUES",null,null,null,null,null,null,null,{"$f":"SUM('PgW-2_Op Rev&Exp'!L59:M60)","v":541074.81999999995},null,null,null,{"$f":"SUM(N43:O44)","v":540852.80999999994}]
[null,"MO Jurisdictional should match Statement of Revenue (MoPSC Assessment)."]
[]
[null,"Sewer Revenues",null,null,null,null,null,null,"**","MO Jurisdictional",null,"**","**","Total Company",null,"**"]
[19,"Operating Revenues from Tariffed Services",null,null,null,null,null,null,null,223665.92000000001,null,null,null,{"$f":"+J49","v":223665.92000000001}]
[20,"Other Revenues",null,null,null,null,null,null,null,{"$f":"SUM('PgS-2_Op Rev&Exp'!L51:M52)","v":0},null,null,null,{"$f":"+J50","v":0}]
[21,"TOTAL REVENUES",null,null,null,null,null,null,null,223665.92000000001,null,null,null,{"$f":"SUM(N49:O50)","v":223665.92000000001}]
[null,"MO Jurisdictional should match Statement of Revenue (MoPSC Assessment)."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(To be used when filing under seal.)"]
[null,null,null,null,null,null,null,null,null,null,"Indicates link to another worksheet within workbook"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Public"]
[null,null,null,null,null,null,"Highly Confidential"]

{"sheet":"Pg2 Stock, Sec Hldrs&Voting Pwr","index":4,"n_rows":82,"n_cols":13,"rows_kept":82,"cut":false,"hidden":false,"merged":[[2,1,2,3],[3,1,3,12],[5,11,5,12],[43,8,43,11],[42,2,42,6],[43,2,43,6],[5,1,8,5],[9,1,9,5],[9,6,9,8],[9,9,9,10],[5,9,5,10],[7,9,7,10],[6,9,6,10],[9,11,9,12],[8,6,8,8],[8,9,8,10],[0,1,0,11],[2,4,2,12],[1,1,1,12],[14,1,14,5],[10,6,10,8],[11,6,11,8],[12,6,12,8],[13,6,13,8],[14,6,14,8],[10,1,10,5],[12,1,12,5],[13,1,13,5],[6,6,6,8],[6,11,6,12],[8,11,8,12],[5,6,5,8],[16,1,16,12],[4,1,4,12],[10,9,10,10],[10,11,10,12],[11,9,11,10],[11,11,11,12],[11,1,11,5],[12,11,12,12],[13,9,13,10],[13,11,13,12],[12,9,12,10],[7,11,7,12],[7,6,7,8],[36,1,36,12],[14,9,14,10],[14,11,14,12],[15,1,15,12],[30,11,30,12],[28,11,28,12],[25,1,25,10],[25,11,25,12],[26,1,26,10],[26,11,26,12],[28,1,28,10],[31,11,32,12],[33,11,34,12],[31,1,32,10],[33,1,34,10],[29,1,29,10],[29,11,29,12],[30,1,30,10],[24,1,24,10],[24,11,24,12],[20,1,21,10],[27,1,27,10],[27,11,27,12],[20,11,21,12],[22,1,22,10],[22,11,22,12],[17,1,17,12],[18,1,18,12],[23,1,23,10],[23,11,23,12],[19,1,19,12],[52,2,52,4],[52,7,52,9],[40,2,40,6],[41,2,41,6],[41,8,41,11],[54,10,54,12],[55,10,55,12],[39,8,39,11],[40,8,40,11],[42,8,42,11],[37,2,37,6],[38,2,38,6],[39,2,39,6],[37,8,37,11],[38,8,38,11]]}
[1,"For the calendar year of January 1 - December 31,",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]
[]
[2,"Company Name:",null,null,{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[]
[null,"CAPITAL STOCK (COMMON AND DEFERRED)"]
[null,"Class and Series of Stock"]
[null,null,null,null,null,null,"Number of",null,null,"Par or",null,"Number of "]
[null,null,null,null,null,null,"Shares ",null,null,"Stated Value",null,"Shares"]
[null,null,null,null,null,null,"Authorized",null,null,"Per Share",null,"Issued"]
[null,"(a)",null,null,null,null,"(b)",null,null,"(c)",null,"(d)"]
[3]
[4]
[5]
[6]
[7]
[]
[null,"SECURITY HOLDERS AND VOTING POWERS"]
[null,"Report below the NAMES and ADDRESS of the ten stockholders who, at the end of the year, had the greatest voting powers in the respondent.  "]
[null,"AND STATE THE NUMBER OF VOTES each would have had a right to cast on that date.  If any such holder held in trust, give the nature of the "]
[null,"trust and the beneficial owner.  Show also total votes of ALL securities with voting powers."]
[null,"Names and Addresses",null,null,null,null,null,null,null,null,null,"Number of Votes"]
[]
[null,"(a)",null,null,null,null,null,null,null,null,null,"(b)"]
[8,"Liberty Water Co."]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[null,"Total Number of Votes Held by Above"]
[16]
[null,"Total Number of Votes of all Securities with Voting Powers"]
[17]
[]
[null,"Identify the principal or general officers of the company at the end of the year.  Please include an additional sheet, if enough space is not provided on this page, to completely provide the requested information."]
[null,null,"Title of General Officer",null,null,null,null,null,"Name of Person Holding Office"]
[18,null,"Director",null,null,null,null,null,"Ian Robertson"]
[19,null,"Director",null,null,null,null,null,"Greg Sorensen"]
[20,null,"CFO",null,null,null,null,null,"David Bronicheski"]
[21,null,"Vice President",null,null,null,null,null,"Christopher Jarratt"]
[22]
[23]
[]
[null,"Please check all of the following for which the company has filed / is current: "]
[]
[27,null,null,"Secretary of State Requirements",null,null,null,"X","Federal Tax Return"]
[]
[28,null,null,"Department of Natural Resources Permits",null,null,null,"X","State Tax Return"]
[]
[null,"Please list your most recent rate increase request Case No. and effective date. "]
[29,"Case No.: ","YW-2007-0650",null,null,null,"Effective Date: ","2007-04-02"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Public"]
[null,null,null,null,null,null,"Highly Confidential"]

{"sheet":"Pg3 Chgs During Year","index":5,"n_rows":61,"n_cols":11,"rows_kept":61,"cut":false,"hidden":false,"merged":[[51,1,52,10],[45,1,46,10],[41,1,42,10],[43,1,44,10],[47,1,48,10],[49,1,50,10],[59,1,60,10],[11,1,12,10],[13,1,14,10],[15,1,16,10],[17,1,18,10],[19,1,20,10],[21,1,22,10],[33,1,34,10],[23,1,24,10],[25,1,26,10],[27,1,28,10],[29,1,30,10],[31,1,32,10],[53,1,54,10],[55,1,56,10],[57,1,58,10],[39,1,40,10],[0,1,0,9],[7,1,8,10],[9,1,10,10],[1,1,2,2],[1,3,2,10],[3,1,4,10],[5,1,6,10],[35,1,36,10],[37,1,38,10]]}
[1,"For the calendar year of January 1 - December 31,",null,null,null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]
[null,"Company Name:",null,{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[2]
[null,"Describe MAJOR transactions occurring during the year which will have a major effect on operations, such as rate changes, "]
[]
[null,"replacement of equipment and other abnormal cash expenditures of $250 or more."]
[]
[]
[3]
[]
[4]
[]
[5]
[]
[6]
[]
[7]
[]
[8]
[]
[9]
[]
[10]
[]
[11]
[]
[12]
[]
[13]
[]
[14]
[]
[15]
[]
[16]
[]
[17]
[]
[18]
[]
[19]
[]
[20]
[]
[21]
[]
[22]
[]
[23]
[]
[24]
[]
[25]
[]
[27]
[]
[28]
[]
[29]
[]
[30]

{"sheet":"Pg4_BS-Assets","index":6,"n_rows":82,"n_cols":11,"rows_kept":82,"cut":false,"hidden":false,"merged":[[0,1,0,8],[1,1,1,9],[8,1,8,9],[9,1,9,9],[3,1,3,9],[4,1,4,9],[5,1,5,9],[2,1,2,2],[2,3,2,9],[7,1,7,9],[6,1,6,9],[34,8,35,9],[63,6,63,10],[57,8,57,9],[14,8,14,9],[36,8,37,9],[15,8,15,9],[58,1,58,9],[40,8,41,9],[62,6,62,9],[53,1,53,9],[54,1,54,9],[52,8,52,9],[51,1,51,6],[18,8,19,9],[20,8,21,9],[22,8,23,9],[11,1,11,9],[10,1,10,9],[13,8,13,9],[12,8,12,9],[50,8,51,9],[48,8,49,9],[30,8,31,9],[32,8,33,9],[24,8,25,9],[16,8,17,9],[38,8,39,9],[42,8,43,9],[26,8,27,9],[44,8,45,9],[46,8,47,9],[28,8,29,9]]}
[1,"For the calendar year of January 1 - December 31,",null,null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]
[]
[2,"Company Name:",null,{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[]
[]
[null,"NOTE: Please do not type over formulas.  Totals will calculate automatically in this spreadsheet."]
[]
[]
[null,"BALANCE SHEET"]
[null,"WATER AND SEWER OPERATIONS"]
[null,"ASSETS"]
[]
[]
[null,"Account Description",null,null,null,null,null,null,"Amount"]
[null,"(a)",null,null,null,null,null,null,"(b)"]
[null,null,null,null,null,null,null,"**",null,null,"**"]
[null,null,null,null,null,null,null,null,{"$f":"'PgW-5_Wtr Plant'!$M$64","v":7101502.1299999999}]
[3,"Water Plant In Service (From Pg. W-5)"]
[null,null,null,null,null,null,null,null,{"$f":"'PgW-6_Depr Res-Wtr Plant'!$K$65","v":2884783.14}]
[4,"    LESS:","Water Depreciation Reserve (From Pg. W-6)"]
[null,null,null,null,null,null,null,null,{"$f":"I17-I19","v":4216718.99}]
[5,"Net Water Plant in Service (i.e., Water Plant In Service MINUS Water Depreciation Reserve)"]
[null,null,null,null,null,null,null,null,{"$f":"'Pg11_M&S'!$G$58","v":0}]
[6,"Water Materials and Supplies (From Pg. 11)"]
[null,null,null,null,null,null,null,null,-9047]
[7,"Water Construction Work in Progress"]
[]
[8,"Water Plant Held for Future Use *"]
[null,null,null,null,null,null,null,null,-3218660.89]
[9,"Water Plant Acquisition Adjustment"]
[null,null,null,null,null,null,null,null,{"$f":"'PgS-4_Swr Plant'!M53","v":2113580.0000000005}]
[10,"Sewer Plant in Service (From Pg. S-4)"]
[null,null,null,null,null,null,null,null,{"$f":"SUM('PgS-5_Depr Res-Swr Plant'!K54:L54)","v":1081197.6600000001}]
[11,"    LESS:","Sewer Depreciation Reserve (From Pg. S-5)"]
[null,null,null,null,null,null,null,null,{"$f":"I31-I33","v":1032382.3400000003}]
[12,"Net Sewer Plant in Service (i.e., Sewer Plant in Service MINUS Sewer Depreciation Reserve)"]
[null,null,null,null,null,null,null,null,{"$f":"'Pg11_M&S'!$J$58","v":0}]
[13,"Sewer Materials and Supplies (From Pg. 11)"]
[null,null,null,null,null,null,null,null,26014]
[14,"Sewer Construction Work in Progress"]
[]
[15,"Sewer Plant Held for Future Use *"]
[null,null,null,null,null,null,null,null,{"$f":"-446657-166790","v":-613447}]
[16,"Sewer Plant Acquisition Adjustment"]
[]
[17,"Other Plant *"]
[null,null,null,null,null,null,null,null,108089.07]
[18,"Cash"]
[null,null,null,null,null,null,null,null,168754.25]
[19,"Other Assets (Accounts Receivable, etc.)  *"]
[null,null,null,null,null,null,null,null,{"$f":"I21+I23+I25+I27+I29+I35+I37+I39+I41+I43+I45+I47+I49","v":1710803.7600000005}]
[20,"Total Assets**"]
[]
[]
[null,"* Please attach a detailed explanation for these items."]
[]
[null,"** Total Assets should balance with Total Equity and Liabilities on Page 5 (see instructions)."]
[null,"     Difference between Equity & Liabilities and Assets (from Pg 5)",null,null,null,null,null,null,{"$f":"SUM(I51)-SUM('Pg5_BS-Eq & Liab'!J53:K54)","v":-2004204.2899999998}]
[]
[null,null,null,null,null,null,"Indicates link to another worksheet within workbook"]
[]
[null,null,null,null,null,null,"Indicate formula cells"]
[]
[null,null,null,null,null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Public"]
[null,null,null,null,null,null,"Highly Confidential"]

{"sheet":"Pg5_BS-Eq & Liab","index":7,"n_rows":81,"n_cols":12,"rows_kept":81,"cut":false,"hidden":false,"merged":[[56,1,56,10],[59,9,59,10],[44,9,45,10],[44,1,45,7],[48,1,49,7],[50,1,51,7],[55,1,55,10],[46,1,47,7],[54,1,54,7],[54,9,54,10],[52,1,53,7],[52,9,53,10],[46,9,47,10],[48,9,49,10],[50,9,51,10],[40,9,41,10],[24,1,25,7],[26,1,27,7],[28,1,29,7],[30,1,31,7],[34,9,35,10],[28,9,29,10],[42,2,43,7],[36,1,37,7],[38,1,39,7],[40,1,41,7],[22,1,23,7],[22,9,23,10],[18,9,19,10],[20,9,21,10],[34,1,35,7],[24,9,25,10],[32,2,33,7],[26,9,27,10],[4,1,4,10],[14,1,15,7],[14,9,15,10],[16,1,17,7],[10,9,10,10],[12,1,12,7],[12,9,12,10],[6,1,6,10],[5,1,5,10],[9,1,9,10],[16,9,17,10],[0,1,0,9],[1,1,1,10],[2,1,2,2],[2,3,2,10],[3,1,3,10],[64,7,64,10],[65,7,65,11],[7,1,7,10],[8,1,8,10],[32,9,33,10],[11,9,11,10],[13,9,13,10],[11,1,11,7],[13,1,13,7],[10,1,10,7],[18,1,19,7],[42,9,43,10],[36,9,37,10],[38,9,39,10],[20,1,21,7],[30,9,31,10]]}
[1,"For the calendar year of January 1 - December 31,",null,null,null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]
[]
[2,"Company Name:",null,{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[]
[null,"NOTE: Please do not type over formulas.  Totals will calculate automatically in this spreadsheet."]
[]
[null,"BALANCE SHEET"]
[null,"WATER AND SEWER OPERATIONS"]
[null,"EQUITY AND LIABILITIES"]
[]
[]
[null,"Account Description",null,null,null,null,null,null,null,"Amount"]
[null,"(a)",null,null,null,null,null,null,null,"(b)"]
[null,null,null,null,null,null,null,null,"**",null,null,"**"]
[null,"Capital Stock",null,null,null,null,null,null,null,3434329]
[3]
[null,"Retained Earnings",null,null,null,null,null,null,null,-219994.58]
[4]
[null,"Long-Term Debt to Affiliates (owners, other owner controlled companies, etc.)"]
[5]
[null,"Short-Term Debt to Affiliates (owners, other owner controlled companies, etc.)",null,null,null,null,null,null,null,310686.49]
[6]
[null,"Long-Term Debt (banks, etc.)"]
[7]
[null,"Short-Term Debt (banks, etc.)"]
[8]
[null,"Water Customer Deposits",null,null,null,null,null,null,null,9500]
[9]
[null,"Water Advances for Construction"]
[10]
[null,"Water CIAC (From Pg. 9)",null,null,null,null,null,null,null,{"$f":"Pg9_CIAC!$H$39","v":0}]
[11]
[null,null,"Water Amortization of CIAC (From Pg. 9)",null,null,null,null,null,null,{"$f":"Pg9_CIAC!$H$53","v":0}]
[12,"    LESS:"]
[null,"Net Water CIAC (i.e., Water CIAC MINUS Water Amortization of CIAC)",null,null,null,null,null,null,null,{"$f":"J31-J33","v":0}]
[13]
[null,"Sewer Customer Deposits"]
[14]
[null,"Sewer Advances for Construction"]
[15]
[null,"Sewer CIAC (From Pg. 9)",null,null,null,null,null,null,null,{"$f":"Pg9_CIAC!$J$39","v":0}]
[16]
[null,null,"Sewer Amortization of CIAC (From Pg. 9)",null,null,null,null,null,null,{"$f":"Pg9_CIAC!$J$53","v":0}]
[17,"    LESS:"]
[null,"Net Sewer CIAC (i.e., Sewer CIAC MINUS Sewer Amortization of CIAC)",null,null,null,null,null,null,null,{"$f":"J41-J43","v":0}]
[18]
[null,"Deferred Taxes - ITC"]
[19]
[null,"Deferred Taxes - Other *"]
[20]
[null,"Other Liabilities (Accounts Payable, etc.) *",null,null,null,null,null,null,null,180487.14]
[21]
[null,"          Total Equity and Liabilities**",null,null,null,null,null,null,null,{"$f":"J15+J17+J19+J21+J23+J25+J27+J29+J35+J37+J39+J45+J47+J49+J51","v":3715008.0500000003}]
[22]
[]
[]
[null,"* Please attach a detailed explanation for these items."]
[]
[null,"** Total Equity and Liabilities should balance with Total  Assets on Page 4 (see instructions)."]
[null,"    Difference between Equity & Liabilities and Assets (from Pg 4)",null,null,null,null,null,null,null,{"$f":"SUM(J53)-SUM('Pg4_BS-Assets'!I51:J52)","v":2004204.2899999998}]
[]
[null,null,null,null,null,null,"Indicates link to another worksheet within workbook"]
[]
[null,null,null,null,null,null,"Indicate formula cells"]
[]
[null,null,null,null,null,null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Public"]
[null,null,null,null,null,null,null,"Highly Confidential"]

{"sheet":"Pg6_Sch of Uncollectibles","index":8,"n_rows":90,"n_cols":13,"rows_kept":90,"cut":false,"hidden":false,"merged":[[57,1,58,1],[57,2,58,6],[57,8,58,9],[57,10,58,11],[63,1,64,1],[63,2,64,6],[63,8,64,9],[63,10,64,11],[61,1,62,1],[61,2,62,6],[61,8,62,9],[61,10,62,11],[59,1,60,1],[59,2,60,6],[59,8,60,9],[59,10,60,11],[55,1,56,1],[55,2,56,6],[55,8,56,9],[55,10,56,11],[53,1,54,1],[53,2,54,6],[53,8,54,9],[53,10,54,11],[51,1,52,1],[51,2,52,6],[51,8,52,9],[51,10,52,11],[15,1,16,1],[15,2,16,6],[15,8,16,9],[41,8,42,9],[41,10,42,11],[49,1,50,1],[49,2,50,6],[49,8,50,9],[49,10,50,11],[47,1,48,1],[47,2,48,6],[47,8,48,9],[47,10,48,11],[45,1,46,1],[45,2,46,6],[45,8,46,9],[45,10,46,11],[43,1,44,1],[39,1,40,1],[39,2,40,6],[39,8,40,9],[37,1,38,1],[37,2,38,6],[37,8,38,9],[13,10,14,11],[11,1,12,1],[11,2,12,6],[11,8,12,9],[11,10,12,11],[33,1,34,1],[33,2,34,6],[33,8,34,9],[33,10,34,11],[17,1,18,1],[17,2,18,6],[17,8,18,9],[17,10,18,11],[19,1,20,1],[19,2,20,6],[19,8,20,9],[19,10,20,11],[21,1,22,1],[21,2,22,6],[21,8,22,9],[25,1,26,1],[41,1,42,1],[41,2,42,6],[72,8,72,11],[4,1,4,11],[6,8,6,11],[6,2,6,6],[27,1,28,1],[27,2,28,6],[27,8,28,9],[29,1,30,1],[13,1,14,1],[13,2,14,6],[13,8,14,9],[69,8,69,9],[25,2,26,6],[25,8,26,9],[35,1,36,1],[35,2,36,6],[35,8,36,9],[31,8,32,9],[65,8,66,9],[31,1,32,1],[31,2,32,6],[67,8,68,9],[0,1,0,10],[1,1,1,11],[2,1,2,2],[2,3,2,11],[3,1,3,11],[5,1,5,11],[71,1,71,11],[70,8,70,9],[70,10,70,11],[69,10,69,11],[35,10,36,11],[31,10,32,11],[23,1,24,1],[23,2,24,6],[23,8,24,9],[25,10,26,11],[27,10,28,11],[29,10,30,11],[67,1,68,1],[69,1,70,1],[65,1,66,1],[65,2,66,6],[29,2,30,6],[29,8,30,9],[73,8,73,11],[7,8,7,9],[67,2,68,6],[69,2,70,6],[7,2,7,6],[9,10,9,11],[10,10,10,11],[8,10,8,11],[23,10,24,11],[8,8,8,9],[9,8,9,9],[10,8,10,9],[8,2,8,6],[9,2,9,6],[10,2,10,6],[65,10,66,11],[21,10,22,11],[67,10,68,11],[15,10,16,11],[39,10,40,11],[37,10,38,11],[43,2,44,6],[43,8,44,9],[43,10,44,11]]}
[1,"For the calendar year of January 1 - December 31,",null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]
[]
[2,"Company Name:",null,{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[]
[null,"SCHEDULE OF UNCOLLECTIBLE ACCOUNTS"]
[]
[null,null,null,null,null,null,null,null,"Amount Written Off"]
[null,null,"Describe customer account and methods used to attempt"]
[null,"Account","collection.  Also, state why account is deemed uncollectible",null,null,null,null,null,"Water",null,"Sewer"]
[null,"No.","(bankruptcy, etc.)",null,null,null,null,null,"Utility",null,"Utility"]
[null,"(a)","(b)",null,null,null,null,"**","(c)",null,"(d)",null,"**"]
[]
[3]
[]
[4]
[]
[5]
[]
[6]
[]
[7]
[]
[8]
[]
[9]
[]
[10]
[]
[11]
[]
[12]
[]
[13]
[]
[14]
[]
[15]
[]
[16]
[]
[17]
[]
[18]
[]
[19]
[]
[20]
[]
[21]
[]
[22]
[]
[23]
[]
[24]
[]
[25]
[]
[26]
[]
[27]
[]
[28]
[]
[29]
[]
[30]
[null,null,"Total ",null,null,null,null,null,{"$f":"SUM(I12:J67)","v":0},null,{"$f":"SUM(K12:L67)","v":0}]
[31]
[null,null,null,null,null,null,null,null,"(Total to Pg. W-1)",null,"(Total to Pg. S-1)"]
[]
[]
[null,null,null,"Indicate formula cells"]
[null,null,null,null,null,null,null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Public"]
[null,null,null,null,null,null,null,null,"Highly Confidential"]

{"sheet":"Pg7_Payroll Info","index":9,"n_rows":51,"n_cols":18,"rows_kept":51,"cut":false,"hidden":false,"merged":[[47,17,50,17],[9,15,50,15],[1,15,7,15],[1,17,46,17],[33,10,34,11],[1,2,1,13],[29,2,30,5],[29,6,30,7],[29,8,30,9],[29,10,30,11],[4,2,4,13],[27,8,28,9],[27,10,28,11],[35,2,36,5],[35,6,36,7],[33,12,34,13],[25,12,26,13],[23,2,24,5],[23,6,24,7],[19,8,20,9],[43,12,44,13],[45,2,46,5],[35,10,36,11],[35,12,36,13],[43,2,44,5],[43,6,44,7],[43,8,44,9],[45,8,46,9],[43,10,44,11],[39,12,40,13],[0,2,0,13],[33,2,34,5],[33,6,34,7],[31,2,32,5],[31,6,32,7],[31,8,32,9],[31,10,32,11],[31,12,32,13],[33,8,34,9],[27,12,28,13],[41,2,42,5],[41,6,42,7],[41,8,42,9],[41,10,42,11],[41,12,42,13],[39,2,40,5],[39,6,40,7],[39,8,40,9],[49,2,49,13],[47,8,48,9],[50,10,50,11],[45,10,46,11],[45,12,46,13],[47,12,48,13],[47,2,48,5],[47,6,48,7],[47,10,48,11],[45,6,46,7],[39,10,40,11],[37,2,38,5],[37,6,38,7],[37,8,38,9],[37,10,38,11],[37,12,38,13],[27,2,28,5],[27,6,28,7],[35,8,36,9],[29,12,30,13],[23,8,24,9],[23,10,24,11],[25,2,26,5],[25,6,26,7],[25,8,26,9],[25,10,26,11],[15,8,16,9],[23,12,24,13],[19,12,20,13],[21,2,22,5],[21,6,22,7],[21,8,22,9],[21,10,22,11],[21,12,22,13],[19,2,20,5],[19,6,20,7],[19,10,20,11],[15,12,16,13],[17,2,18,5],[17,6,18,7],[17,8,18,9],[17,10,18,11],[17,12,18,13],[15,2,16,5],[15,6,16,7],[6,2,6,5],[7,2,7,5],[13,6,14,7],[13,8,14,9],[9,12,9,13],[13,12,14,13],[11,10,11,11],[12,10,12,11],[10,2,10,5],[11,2,11,5],[12,2,12,5],[10,6,10,7],[11,6,11,7],[12,6,12,7],[12,12,12,13],[12,8,12,9],[13,10,14,11],[2,2,2,13],[3,2,3,13],[8,6,8,7],[8,8,8,9],[8,10,8,11],[8,12,8,13],[11,12,11,13],[47,0,50,0],[9,8,9,9],[10,8,10,9],[6,6,6,13],[8,2,8,5],[9,2,9,5],[9,10,9,11],[10,10,10,11],[9,6,9,7],[10,12,10,13],[50,2,50,9],[11,8,11,9],[15,10,16,11],[13,2,14,5],[5,6,5,13],[7,6,7,13],[5,2,5,5]]}
[null,null,"PAYROLL INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,2,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Company Name:",null,"For the calendar year of January 1 - December 31,"]
[null,null,"INSTRUCTIONS:  Please provide names, titles and salaries for all officers and employees.  Show total compensation paid to each during the year.  Include all amounts including"]
[null,null,"bonuses and other allowances.  Enter \"0\" or none where applicable.  Provide explanations where necessary.  Use additional sheets if necessary."]
[null,null," "]
[]
[null,null,null,null,null,null,"Payroll Charged To:"]
[]
[]
[null,null,null,null,null,null,"Total Utility",null,"Water",null,"Sewer",null,"Capitalized",null,null,{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[null,null,"Name and Title",null,null,null,"Compensation",null,"Expense",null,"Expense",null,"Payroll"]
[null,null,"(a)",null,null,null,"(b)",null,"(c)",null,"(d)",null,"(e)"]
[]
[]
[null,3]
[]
[null,4]
[]
[null,5]
[]
[null,6]
[]
[null,7]
[]
[null,8]
[]
[null,9]
[]
[null,10]
[]
[null,11]
[]
[null,12]
[]
[null,13]
[]
[null,14]
[]
[null,15]
[]
[null,16]
[]
[null,17]
[]
[null,18]
[null,null,"Total",null,null,null,{"$f":"SUM(G14:H45)","v":0},null,{"$f":"SUM(I14:J45)","v":0},null,{"$f":"SUM(K14:L45)","v":0},null,{"$f":"SUM(M14:N45)","v":0}]
[null,19]
["Page 7",null,null,null,null,null,null,null,"(Total to Page W-1)",null,"(Total to Page S-1)",null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Indicate formula cells"]

{"sheet":"Pg8_Contract Svcs","index":10,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[15,2,15,5],[20,2,21,5],[16,8,17,9],[24,6,25,7],[24,8,25,9],[16,2,17,5],[18,2,19,5],[48,2,49,5],[42,2,43,5],[34,2,35,5],[36,2,37,5],[38,2,39,5],[44,2,45,5],[46,2,47,5],[40,2,41,5],[48,8,49,9],[1,17,49,17],[9,15,53,15],[22,2,23,5],[22,6,23,7],[22,8,23,9],[22,10,23,11],[22,12,23,13],[52,2,52,13],[24,2,25,5],[50,12,51,13],[28,12,29,13],[50,2,51,5],[26,12,27,13],[34,12,35,13],[40,12,41,13],[26,10,27,11],[28,8,29,9],[30,8,31,9],[38,10,39,11],[50,8,51,9],[20,12,21,13],[50,10,51,11],[16,12,17,13],[18,10,19,11],[40,10,41,11],[28,10,29,11],[30,10,31,11],[44,12,45,13],[46,12,47,13],[11,2,11,5],[38,12,39,13],[36,6,37,7],[36,8,37,9],[36,10,37,11],[36,12,37,13],[38,6,39,7],[38,8,39,9],[16,10,17,11],[18,6,19,7],[20,10,21,11],[30,2,31,5],[30,6,31,7],[14,2,14,5],[16,6,17,7],[32,2,33,5],[18,8,19,9],[20,8,21,9],[26,8,27,9],[0,2,0,13],[24,10,25,11],[24,12,25,13],[28,2,29,5],[26,2,27,5],[6,6,6,13],[8,6,8,13],[13,6,13,7],[13,8,13,9],[13,10,13,11],[13,12,13,13],[10,6,10,9],[10,10,10,13],[12,8,12,9],[6,2,6,5],[7,2,7,5],[8,2,8,5],[9,2,9,5],[10,2,10,5],[12,2,12,5],[13,2,13,5],[14,6,14,7],[28,6,29,7],[20,6,21,7],[49,0,53,0],[1,15,7,15],[2,2,2,13],[3,2,3,13],[4,2,4,13],[11,10,11,13],[32,8,33,9],[34,8,35,9],[44,8,45,9],[40,8,41,9],[11,6,11,9],[15,10,15,11],[14,12,14,13],[14,8,14,9],[14,10,14,11],[42,8,43,9],[30,12,31,13],[32,12,33,13],[48,10,49,11],[48,12,49,13],[42,10,43,11],[42,12,43,13],[46,10,47,11],[46,8,47,9],[32,10,33,11],[12,10,12,11],[12,12,12,13],[50,17,53,17],[7,6,7,13],[15,6,15,7],[15,8,15,9],[9,6,9,9],[9,10,9,13],[15,12,15,13],[53,10,53,11],[50,6,51,7],[32,6,33,7],[34,6,35,7],[48,6,49,7],[40,6,41,7],[42,6,43,7],[34,10,35,11],[44,10,45,11],[44,6,45,7],[46,6,47,7],[12,6,12,7],[26,6,27,7],[18,12,19,13]]}
[null,null,"PAYMENTS FOR SERVICES RENDERED BY OTHER THAN EMPLOYEES",null,null,null,null,null,null,null,null,null,null,null,null,2,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Company Name:",null,"For the calendar year of January 1 - December 31,"]
[null,null,"INSTRUCTIONS:  Report below all information concerning rate, management, construction, engineering, research, financial, valuation, legal, accounting, purchasing, advertising, labor "]
[null,null,"relations, public relations, or other similar professional services rendered the respondent under written or verbal arrangements, for which total payments during the year to any "]
[null,null,"corporation, partnership, individual (other than for services as an employee) or organization of any kind whatsoever.  Use additional sheets if necessary."]
[]
[]
[null,null,null,null,null,null,"Amount of Payments:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[null,null,null,null,null,null,"Water",null,null,null,"Sewer"]
[]
[]
[null,null,"Name of Recipient and Description of Service",null,null,null,"Expensed",null,"Capitalized",null,"Expensed",null,"Capitalized"]
[null,null,"(a)",null,null,null,"(b)",null,"(c)",null,"(d)",null,"(e)"]
[]
[]
[null,3]
[]
[null,4]
[]
[null,5]
[]
[null,6]
[]
[null,7]
[]
[null,8]
[]
[null,9]
[]
[null,10]
[]
[null,11]
[]
[null,12]
[]
[null,13]
[]
[null,14]
[]
[null,15]
[]
[null,16]
[]
[null,17]
[]
[null,18]
[null,null,"Total",null,null,null,{"$f":"SUM(G17:H48)","v":0},null,{"$f":"SUM(I17:J48)","v":0},null,{"$f":"SUM(K17:L48)","v":0},null,{"$f":"SUM(M17:N48)","v":0}]
["Page 8",19]
[null,null,null,null,null,null,"(Total to Page W-1)",null,null,null,"(Total to Page S-1)",null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Indicate formula cells"]

{"sheet":"Pg9_CIAC","index":11,"n_rows":66,"n_cols":11,"rows_kept":66,"cut":false,"hidden":false,"merged":[[62,7,62,8],[62,9,62,10],[63,1,63,6],[63,7,63,8],[63,9,63,10],[60,7,60,8],[60,9,60,10],[61,7,61,8],[61,9,61,10],[58,1,58,6],[58,7,58,8],[58,9,58,10],[59,7,59,8],[59,9,59,10],[48,7,48,8],[48,9,48,10],[49,7,49,8],[50,7,50,8],[50,9,50,10],[53,1,53,6],[55,1,55,10],[54,1,54,10],[56,1,56,6],[56,7,56,8],[56,9,56,10],[52,9,52,10],[53,7,53,8],[53,9,53,10],[49,9,49,10],[38,9,39,10],[46,1,46,6],[42,1,42,10],[45,1,45,6],[43,1,43,10],[44,1,44,10],[46,7,46,8],[45,9,45,10],[45,7,45,8],[40,9,41,10],[38,1,39,6],[38,7,39,8],[47,9,47,10],[47,7,47,8],[57,1,57,6],[57,7,57,8],[57,9,57,10],[40,1,40,6],[41,1,41,6],[47,1,47,6],[48,1,48,6],[51,7,51,8],[52,7,52,8],[51,9,51,10],[40,7,41,8],[32,1,33,6],[32,7,33,8],[36,7,37,8],[32,9,33,10],[36,9,37,10],[34,1,35,6],[34,7,35,8],[34,9,35,10],[36,1,37,6],[30,7,31,8],[28,1,29,6],[28,7,29,8],[28,9,29,10],[30,1,31,6],[30,9,31,10],[24,7,25,8],[24,9,25,10],[24,1,25,6],[26,1,27,1],[26,2,27,6],[26,7,27,8],[26,9,27,10],[18,1,19,6],[20,1,21,6],[22,1,23,6],[4,1,4,10],[5,1,5,10],[6,1,6,10],[7,1,7,10],[8,1,8,10],[9,1,9,10],[11,7,11,8],[12,1,13,6],[14,2,15,6],[22,9,23,10],[16,9,17,10],[18,9,19,10],[20,9,21,10],[18,7,19,8],[20,7,21,8],[22,7,23,8],[16,1,17,6],[3,1,3,10],[11,1,11,6],[10,1,10,10],[0,1,0,9],[1,1,1,10],[2,1,2,2],[2,3,2,10],[16,7,17,8],[14,9,15,10],[12,7,13,8],[14,7,15,8],[12,9,13,10],[11,9,11,10]]}
[1,"For the calendar year of January 1 - December 31,",null,null,null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]
[]
[2,"Company Name:",null,{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[]
[null,"CONTRIBUTIONS IN AID OF CONSTRUCTION"]
[]
[null,"INSTRUCTIONS:  This account shall include donations or contributions in cash, services, or property for construction purposes.  The records supporting the entries to this "]
[null,"account shall be so kept that the utility can furnish information as to the purpose of each donation, the conditions, if any, upon which it was made, the amount of each donation, "]
[null,"and the amount applicable to each utility department.  The credits (deductions) to this account shall not be transferred to any other account without the approval of the "]
[null,"Commission."]
[]
[null,"(a)",null,null,null,null,null,"Water\n(b)",null,"Sewer\n(c)"]
[null,"Balance at Beginning of Year"]
[3]
[null,null,"Additions During the Year (Please provide a detailed explanation.)"]
[4,"PLUS:  "]
[]
[5]
[]
[6]
[]
[7]
[]
[8]
[null,"Total Additions",null,null,null,null,null,{"$f":"SUM(H15:I24)","v":0},null,{"$f":"SUM(J15:K24)","v":0}]
[10]
[null,"LESS: "," Deductions During the Year (Please provide a detailed explanation.)"]
[11]
[]
[12]
[]
[13]
[null,"Retire and cap off service connection, but no connection fee money returned  = no entry here"]
[14]
[]
[15]
[null,"Total Deductions",null,null,null,null,null,{"$f":"SUM(H27:I36)","v":0},null,{"$f":"SUM(J27:K36)","v":0}]
[16]
[null,"Balance at End of Year",null,null,null,null,null,{"$f":"H13+H25-H37","v":0},null,{"$f":"J13+J25-J37","v":0}]
[17]
[null,null,null,null,null,null,null,"(Total to Pg. 5)",null,"(Total to Pg. 5)"]
[]
[]
[null,"AMORTIZATION OF CONTRIBUTIONS IN AID OF CONSTRUCTION"]
[null,"(Please identify as Account Number 271A)"]
[null,"(a)",null,null,null,null,null,"Water\n(b)",null,"Sewer\n(c)"]
[18,"Balance at First of Year (Total of Amortization not Total of CIAC line 3)"]
[19,"Total Contributions in Aid at End of Year (see above)",null,null,null,null,null,{"$f":"SUM(H39)","v":0},null,{"$f":"SUM(J39)","v":0}]
[20,"Total Plant in Service at End of Year (From Page W-5 or S-4)",null,null,null,null,null,{"$f":"'PgW-5_Wtr Plant'!$M$64","v":7101502.1299999999},null,{"$f":"SUM('PgS-4_Swr Plant'!M53:N53)","v":2113580.0000000005}]
[21,"Percentage Contributions to Plant",null,null,null,null,null,{"$f":"IF(H49=0, \"0.00%\", H47/H49)","v":0},null,{"$f":"IF(J49=0, \"0.00%\",J47/J49)","v":0}]
[22,"Total Depreciation Expense (From Page W-6 or S-5)",null,null,null,null,null,{"$f":"'PgW-6_Depr Res-Wtr Plant'!$E$65","v":1173911.1599999999},null,{"$f":"'PgS-5_Depr Res-Swr Plant'!$E$54","v":217474.98}]
[23,"Total Amortization of Contributions",null,null,null,null,null,{"$f":"H50*H51","v":0},null,{"$f":"J50*J51","v":0}]
[24,"Balance at End of Year",null,null,null,null,null,{"$f":"H47+H52","v":0},null,{"$f":"J47+J52","v":0}]
[null,null,null,null,null,null,null,"(Total to Pg. 5)",null,"(Total to Pg. 5)"]
[null,"OR"]
[null,"ACTUAL CONTRIBUTIONS IN AID OF CONSTRUCTION"]
[null,"(a)",null,null,null,null,null,"Water\n(b)",null,"Sewer\n(c)"]
[19,"Total Contributions in Aid at End of Year (see above)"]
[20,"Total Plant in Service at End of Year (From Page W-5 or S-4)"]
[21,"Percentage Contributions to Plant"]
[22,"Total Depreciation Expense (From Page W-6 or S-5)"]
[23,"Total Amortization of Contributions"]
[24,"Balance at End of Year"]
[null,null,null,null,null,null,null,"(Total to Pg. 5)",null,"(Total to Pg. 5)"]
[null,null,null,null,null,null,null,"Indicates link to another worksheet within workbook"]
[null,null,null,null,null,null,null,"Indicate formula cells"]

{"sheet":"Pg10_Debt","index":12,"n_rows":54,"n_cols":21,"rows_kept":54,"cut":false,"hidden":false,"merged":[[49,20,51,20],[23,20,48,20],[54,2,54,14],[53,2,53,12],[40,12,41,12],[46,12,47,12],[44,12,45,12],[48,2,49,4],[48,7,49,7],[48,8,49,9],[40,10,41,10],[48,15,49,16],[42,12,43,12],[48,13,49,14],[48,12,49,12],[48,10,49,10],[42,10,43,10],[26,15,27,16],[44,2,45,4],[42,2,43,4],[42,8,43,9],[40,2,41,4],[40,7,41,7],[42,7,43,7],[55,2,55,14],[56,2,56,14],[50,15,51,16],[50,13,51,14],[50,12,51,12],[50,10,51,10],[50,8,51,9],[50,7,51,7],[50,2,51,4],[53,13,53,14],[46,13,47,14],[46,15,47,16],[44,13,45,14],[42,13,43,14],[42,15,43,16],[40,13,41,14],[44,15,45,16],[32,13,33,14],[14,13,15,14],[14,15,15,16],[0,2,0,16],[1,2,1,16],[3,2,3,16],[38,2,39,4],[38,7,39,7],[38,8,39,9],[38,10,39,10],[34,15,35,16],[36,15,37,16],[32,15,33,16],[24,7,25,7],[24,8,25,9],[24,10,25,10],[24,12,25,12],[26,7,27,7],[26,8,27,9],[26,10,27,10],[20,13,21,14],[20,15,21,16],[22,15,23,16],[18,12,19,12],[24,13,25,14],[22,7,23,7],[22,8,23,9],[40,8,41,9],[38,12,39,12],[38,13,39,14],[38,15,39,16],[40,15,41,16],[28,15,29,16],[30,2,31,4],[28,2,29,4],[28,7,29,7],[28,8,29,9],[28,10,29,10],[30,15,31,16],[30,12,31,12],[32,2,33,4],[32,7,33,7],[36,2,37,4],[36,7,37,7],[34,2,35,4],[32,10,33,10],[30,10,31,10],[46,7,47,7],[46,8,47,9],[46,10,47,10],[44,7,45,7],[44,8,45,9],[44,10,45,10],[32,12,33,12],[26,13,27,14],[26,12,27,12],[36,12,37,12],[36,13,37,14],[28,12,29,12],[28,13,29,14],[30,13,31,14],[34,12,35,12],[34,13,35,14],[36,8,37,9],[36,10,37,10],[34,8,35,9],[34,10,35,10],[34,7,35,7],[30,8,31,9],[32,8,33,9],[30,7,31,7],[22,10,23,10],[22,12,23,12],[22,13,23,14],[24,15,25,16],[20,7,21,7],[20,8,21,9],[20,10,21,10],[18,7,19,7],[18,8,19,9],[18,10,19,10],[18,13,19,14],[18,15,19,16],[20,12,21,12],[16,7,17,7],[16,8,17,9],[16,10,17,10],[16,12,17,12],[16,13,17,14],[16,15,17,16],[14,7,15,7],[14,8,15,9],[14,10,15,10],[14,12,15,12],[7,15,7,16],[10,13,10,14],[10,15,10,16],[9,8,9,9],[9,13,9,14],[9,15,9,16],[10,8,10,9],[4,11,11,11],[8,13,8,14],[7,13,7,14],[7,8,7,9],[11,8,11,9],[5,13,5,16],[1,18,6,18],[5,8,5,9],[8,8,8,9],[5,2,5,4],[4,13,4,16],[4,2,4,4],[4,8,4,9],[6,13,6,16],[2,2,2,16],[7,18,51,18],[22,2,23,4],[26,2,27,4],[24,2,25,4],[12,10,13,10],[12,12,13,12],[12,2,13,4],[12,7,13,7],[12,8,13,9],[12,13,13,14],[12,15,13,16],[6,8,6,9],[11,13,11,14],[8,15,8,16],[11,15,11,16],[49,0,53,0],[6,2,6,4],[7,2,7,4],[46,2,47,4],[14,2,15,4],[20,2,21,4],[18,2,19,4],[4,5,11,5],[4,6,11,6],[10,2,10,4],[8,2,8,4],[11,2,11,4],[9,2,9,4],[16,2,17,4]]}
[null,null,"INTEREST EXPENSE, NOTES PAYABLE, BONDS, BANK LOANS AND OTHER DEBTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Company Name:"]
[null,null,"INSTRUCTIONS:  Please report information for each separate item of debt.  Show principal amount to which each interest rate applies.  Include all items on which interest was paid during the year.  Use additional sheets if necessary."]
[]
[null,null,null,null,null,"Origination\n Date\n(b)","Frequency of Payments\n(Semi-Monthly, \nMonthly, Quarterly, \nAnnually,, etc.)\n( c )",null,null,null,null,"Is Interest Rate Fixed or Variable?\n(g)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Interest Charged To:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[null,null,"Description of Obligation ",null,null,null,null,"Date of","Loan",null,"Interest",null,null,"Water",null,"Sewer"]
[null,null,"(Include Name and Address of Each Lender)",null,null,null,null,"Maturity","Amount",null,"Rate",null,"Paid","Utility",null,"Utility"]
[null,null,"(a)",null,null,null,null,"(d)","(e)",null,"(f)",null,"(h)","(i) ",null,"(j)"]
[]
[]
[null,3]
[]
[null,4]
[]
[null,5]
[]
[null,6]
[]
[null,7]
[]
[null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For the calendar year of January 1 - December 31,"]
[]
[null,9]
[]
[null,10]
[]
[null,11]
[]
[null,12]
[]
[null,13]
[]
[null,14]
[]
[null,15]
[]
[null,16]
[]
[null,17]
[]
[null,18]
[]
[null,19]
[]
[null,20]
[null,null,"Total",null,null,null,null,null,{"$f":"SUM(I13:J48)","v":0},null,null,null,{"$f":"SUM(M13:M48)","v":0},{"$f":"SUM(N13:O48)","v":0},null,{"$f":"SUM(P13:Q48)","v":0}]
["Page 10",18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!G14>0,Cover!G14,\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(Total to Pg. W-1)",null,"(Total to Pg. S-1)"]
[]
[]
[null,null,"19.  If the answer to column (g) is variable, please explain the method used for the interest rate calculation below with corresponding line number from above. ",null,null,null,null,null,null,null,null,null,null,null,null,"Indicate formula cells"]

{"sheet":"Pg11_M&S","index":13,"n_rows":63,"n_cols":11,"rows_kept":63,"cut":false,"hidden":false,"merged":[[57,1,58,4],[59,1,60,4],[59,5,60,5],[59,8,60,8],[55,1,56,4],[55,5,56,5],[55,6,56,7],[55,8,56,8],[51,1,52,4],[31,9,32,10],[45,9,46,10],[43,9,44,10],[37,9,38,10],[39,9,40,10],[33,9,34,10],[35,9,36,10],[43,5,44,5],[43,6,44,7],[43,8,44,8],[35,5,36,5],[35,6,36,7],[35,8,36,8],[41,5,42,5],[41,6,42,7],[41,8,42,8],[39,5,40,5],[39,6,40,7],[39,8,40,8],[62,7,62,8],[61,1,61,10],[4,1,4,10],[41,9,42,10],[59,6,60,7],[57,6,58,7],[59,9,60,10],[57,9,58,10],[57,8,58,8],[43,1,44,4],[57,5,58,5],[53,9,54,10],[55,9,56,10],[53,1,54,4],[53,5,54,5],[53,6,54,7],[53,8,54,8],[49,9,50,10],[11,1,11,4],[29,9,30,10],[6,5,6,7],[7,8,7,10],[7,5,7,7],[8,5,8,7],[51,9,52,10],[49,1,50,4],[49,5,50,5],[49,6,50,7],[49,8,50,8],[51,5,52,5],[51,6,52,7],[51,8,52,8],[37,1,38,4],[37,5,38,5],[37,6,38,7],[37,8,38,8],[47,6,48,7],[47,8,48,8],[45,1,46,4],[45,5,46,5],[45,6,46,7],[45,8,46,8],[47,9,48,10],[47,1,48,4],[47,5,48,5],[41,1,42,4],[39,1,40,4],[33,1,34,4],[33,5,34,5],[33,6,34,7],[33,8,34,8],[35,1,36,4],[29,1,30,4],[29,5,30,5],[29,6,30,7],[29,8,30,8],[31,1,32,4],[31,5,32,5],[31,6,32,7],[31,8,32,8],[25,9,26,10],[27,9,28,10],[25,1,26,4],[25,5,26,5],[25,6,26,7],[25,8,26,8],[27,1,28,4],[27,5,28,5],[27,6,28,7],[27,8,28,8],[21,9,22,10],[23,9,24,10],[21,1,22,4],[21,5,22,5],[21,6,22,7],[21,8,22,8],[23,1,24,4],[23,5,24,5],[23,6,24,7],[23,8,24,8],[19,9,20,10],[19,1,20,4],[19,5,20,5],[19,6,20,7],[19,8,20,8],[17,9,18,10],[15,8,16,8],[17,1,18,4],[17,5,18,5],[17,6,18,7],[17,8,18,8],[13,9,14,10],[15,9,16,10],[13,8,14,8],[15,1,16,4],[15,5,16,5],[15,6,16,7],[13,1,14,4],[13,5,14,5],[13,6,14,7],[3,1,3,10],[0,1,0,9],[1,1,1,10],[2,1,2,2],[2,3,2,10],[9,9,9,10],[12,9,12,10],[10,6,10,7],[11,9,11,10],[12,6,12,7],[9,6,9,7],[11,6,11,7],[10,9,10,10],[6,8,6,10],[8,8,8,10],[5,1,5,10],[12,1,12,4],[6,1,6,4],[7,1,7,4],[8,1,8,4],[10,1,10,4],[9,1,9,4]]}
[1,"For the calendar year of January 1 - December 31,",null,null,null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]
[]
[2,"Company Name:",null,{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[]
[null,"SCHEDULE OF MATERIALS AND SUPPLIES AVAILABLE AT THE END OF THE YEAR"]
[]
[]
[null,null,null,null,null,"Water",null,null,"Sewer"]
[]
[null,"Description of Items"]
[null,"(Pipe, Meters, Fittings, Valves, Gas, etc.)",null,null,null,"Quantity","Amount",null,"Quantity","Amount"]
[null,"(a)",null,null,null,"(b)","(c)",null,"(d)","(e)"]
[]
[]
[3]
[]
[4]
[]
[5]
[]
[6]
[]
[7]
[]
[8]
[]
[9]
[]
[10]
[]
[11]
[]
[12]
[]
[13]
[]
[14]
[]
[15]
[]
[16]
[]
[17]
[]
[18]
[]
[19]
[]
[20]
[]
[21]
[]
[22]
[]
[23]
[]
[24]
[null,"Total",null,null,null,{"$f":"SUM(F14:F57)","v":0},{"$f":"SUM(G14:H57)","v":0},null,{"$f":"SUM(I14:I57)","v":0},{"$f":"SUM(J14:K57)","v":0}]
[25]
[null,null,null,null,null,null,"(Total to Pg. 4)",null,null,"(Total to Pg. 4)"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Indicate formula cells"]

{"sheet":"PgW-1_Op Rev&Exp","index":14,"n_rows":60,"n_cols":11,"rows_kept":60,"cut":false,"hidden":false,"merged":[[51,1,52,8],[51,9,52,10],[13,9,14,10],[12,9,12,10],[47,1,48,8],[47,9,48,10],[49,1,50,8],[49,9,50,10],[43,1,44,8],[45,1,46,8],[45,9,46,10],[39,1,40,8],[39,9,40,10],[41,1,42,8],[41,9,42,10],[43,9,44,10],[23,1,24,8],[17,1,18,8],[21,1,22,8],[25,1,26,8],[29,1,30,8],[27,1,28,8],[56,1,56,10],[54,1,54,10],[55,1,55,10],[10,1,11,8],[10,9,11,10],[12,1,13,8],[15,1,16,8],[15,9,16,10],[33,1,34,8],[14,1,14,8],[53,1,53,8],[53,9,53,10],[33,9,34,10],[29,9,30,10],[31,9,32,10],[31,1,32,8],[35,1,36,8],[35,9,36,10],[37,1,38,8],[37,9,38,10],[25,9,26,10],[27,9,28,10],[21,9,22,10],[23,9,24,10],[19,9,20,10],[9,9,9,10],[17,9,18,10],[7,9,7,10],[8,9,8,10],[4,1,4,10],[19,1,20,8],[9,1,9,8],[8,1,8,8],[7,1,7,8],[6,1,6,8],[5,1,5,10],[6,9,6,10],[0,1,0,9],[1,1,1,10],[2,1,2,2],[2,3,2,10],[3,1,3,10]]}
[1,"For the calendar year of January 1 - December 31,",null,null,null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]
[]
[2,"Company Name:",null,{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[]
[null,"WATER OPERATING REVENUES, EXPENSES AND STATISTICS"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Amount"]
[null,"(a)",null,null,null,null,null,null,null,"(b)"]
[]
[null,"Total Operating Revenues (From Page W-2)",null,null,null,null,null,null,null,{"$f":"'PgW-2_Op Rev&Exp'!L59","v":541074.81999999995}]
[3]
[null,"Operating Expenses"]
[null,null,null,null,null,null,null,null,null,{"$f":"'Pg7_Payroll Info'!I46","v":0}]
[4,"Salaries & Wages (From Page 7)"]
[null,"Employee Pensions and Benefits"]
[5]
[null,"Purchased Water"]
[6]
[null,"Plant Operations Expenses (From Page W-3)",null,null,null,null,null,null,null,{"$f":"'PgW-3_Op Rev&Exp'!$J$27","v":590124.82000000007}]
[7]
[null,"Billing Expenses"]
[8]
[null,"Supplies and Expenses"]
[9]
[null,"Transportation Expenses"]
[10]
[null,"Rent Expense *"]
[11]
[null,"Insurance Expense"]
[12]
[null,"Outside Services Employed (i.e.., Legal, Accounting, etc.) (From Page 8)",null,null,null,null,null,null,null,{"$f":"'Pg8_Contract Svcs'!G49","v":0}]
[13]
[null,"Regulatory Commission Expenses"]
[14]
[null,"Uncollectible Expenses (From Page 6)",null,null,null,null,null,null,null,{"$f":"'Pg6_Sch of Uncollectibles'!$I$68","v":0}]
[15]
[null,"Depreciation Expense (From Page W-6)",null,null,null,null,null,null,null,{"$f":"'PgW-6_Depr Res-Wtr Plant'!$E$65","v":1173911.1599999999}]
[16]
[null,"Amortization of Contributions in Aid of Construction (Page 9)",null,null,null,null,null,null,null,{"$f":"-Pg9_CIAC!$H$52","v":0}]
[17]
[null,"Amortization Expense"]
[18]
[null,"Tax Expenses (From Page W-3)",null,null,null,null,null,null,null,{"$f":"'PgW-3_Op Rev&Exp'!$J$45","v":14984.04}]
[19]
[null,"Interest Expense (From Page 10)",null,null,null,null,null,null,null,{"$f":"Pg10_Debt!$N$49","v":0}]
[20]
[null,"Other Expenses *"]
[21]
[null,"Total Operating Expenses",null,null,null,null,null,null,null,{"$f":"SUM(J14:J49)","v":1779020.02}]
[22]
[null,"Net Income (Loss)",null,null,null,null,null,null,null,{"$f":"J11-J50","v":-1237945.2000000002}]
[23]
[]
[]
[null,"*  Please attach a detailed explanation for these items."]
[]
[null,null,null,null,null,null,null,"Indicates link to another worksheet within workbook"]
[]
[null,null,null,null,null,null,null,"Indicate formula cells"]

{"sheet":"PgW-2_Op Rev&Exp","index":15,"n_rows":66,"n_cols":13,"rows_kept":66,"cut":false,"hidden":false,"merged":[[16,9,17,10],[16,11,17,12],[18,1,19,4],[46,1,47,10],[16,1,16,4],[17,1,17,4],[16,5,17,6],[16,7,17,8],[20,11,21,12],[20,5,21,6],[18,11,19,12],[20,1,21,4],[22,1,23,4],[20,7,21,8],[20,9,21,10],[26,5,27,6],[18,5,19,6],[18,7,19,8],[18,9,19,10],[24,5,25,6],[24,7,25,8],[24,9,25,10],[26,9,27,10],[28,7,29,8],[28,9,29,10],[28,11,29,12],[36,7,37,8],[36,9,37,10],[36,11,37,12],[34,7,35,8],[34,9,35,10],[24,1,25,4],[26,1,27,4],[28,1,29,4],[36,1,37,4],[34,11,35,12],[30,9,31,10],[30,11,31,12],[32,9,33,10],[32,11,33,12],[24,11,25,12],[42,11,43,12],[42,7,43,8],[42,9,43,10],[40,7,41,8],[40,9,41,10],[40,11,41,12],[38,7,39,8],[38,9,39,10],[38,11,39,12],[65,9,65,10],[44,11,45,12],[46,11,47,12],[45,1,45,10],[48,11,49,12],[50,11,51,12],[58,1,59,10],[58,11,59,12],[64,1,64,12],[48,1,49,10],[62,1,62,12],[63,1,63,12],[60,1,61,10],[60,11,61,12],[54,11,55,12],[56,11,57,12],[54,1,55,10],[56,1,57,10],[50,1,51,10],[52,1,53,10],[52,11,53,12],[44,1,44,4],[44,5,44,10],[38,1,39,4],[40,1,41,4],[42,5,43,6],[42,1,43,4],[40,5,41,6],[38,5,39,6],[36,5,37,6],[34,5,35,6],[14,7,14,8],[14,1,14,4],[32,5,33,6],[32,7,33,8],[30,5,31,6],[30,7,31,8],[26,7,27,8],[15,7,15,8],[30,1,30,4],[31,1,31,4],[32,1,33,4],[34,1,35,4],[22,5,23,6],[22,7,23,8],[15,5,15,6],[14,9,14,10],[14,11,14,12],[15,9,15,10],[15,11,15,12],[9,5,9,8],[7,1,7,4],[11,1,11,4],[15,1,15,4],[7,11,7,12],[7,9,7,10],[11,9,11,10],[8,1,8,4],[9,1,9,4],[8,5,8,8],[3,1,3,12],[8,9,8,10],[9,9,9,10],[12,9,12,10],[13,9,13,10],[8,11,8,12],[9,11,9,12],[12,11,12,12],[13,11,13,12],[7,5,7,8],[10,9,10,10],[0,1,0,11],[13,1,13,4],[6,1,6,12],[4,1,4,12],[5,1,5,12],[22,9,23,10],[22,11,23,12],[26,11,27,12],[28,5,29,6],[10,1,10,4],[10,11,10,12],[10,5,10,8],[11,7,11,8],[11,5,11,6],[12,1,12,4],[11,11,11,12],[14,5,14,6],[1,1,1,12],[2,1,2,2],[2,3,2,12],[12,7,12,8],[13,7,13,8],[12,5,12,6],[13,5,13,6]]}
[1,"For the calendar year of January 1 - December 31,",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]
[]
[2,"Company Name:",null,{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[]
[null,"WATER OPERATING REVENUES, EXPENSES AND STATISTICS (Continued)"]
[null,"(Please indicate if metered amounts are in cubic feet measurements.)"]
[]
[]
[null,null,null,null,null,"No. of"]
[null,null,null,null,null,"Customers"]
[null,null,null,null,null,null,null,null,null,"Gallons"]
[null,null,null,null,null,null,null,null,null,"Sold"]
[null,null,null,null,null,"Beginning",null,"End",null,"000's",null,"Revenue"]
[null,null,null,null,null,"of Year",null,"of Year",null,"Omitted",null,"Amount"]
[null,"(a)",null,null,null,"(b)",null,"(c)",null,"(d)",null,"(e)"]
[]
[null,"Unmetered Sales of Water",null,null,null,null,null,null,null,"XXXX"]
[3,"Residential - Single Family"]
[null,"Residential - Apartments",null,null,null,null,null,null,null,"XXXX"]
[4]
[null,"Residential - Mobile Homes",null,null,null,null,null,null,null,"XXXX"]
[5]
[null,"Commercial",null,null,null,null,null,null,null,"XXXX"]
[6]
[null,"Other Sales to Public Authorities",null,null,null,null,null,null,null,"XXXX"]
[7]
[null,"Other *",null,null,null,null,null,null,null,"XXXX"]
[8]
[null,"Total Unmetered Sales",null,null,null,{"$f":"SUM(F17:G28)","v":0},null,{"$f":"SUM(H17:I28)","v":0},null,{"$f":"SUM(K18:K28)","v":0},null,{"$f":"SUM(L17:M28)","v":0}]
[9]
[null,"Metered Sales of Water",null,null,null,653,null,1334]
[10,"5/8\" Meter"]
[null,"3/4\" Meter",null,null,null,0]
[11]
[null,"1\" Meter",null,null,null,21,null,21]
[12]
[null,"1 1/2\" Meter",null,null,null,0]
[13]
[null,"2\" Meter",null,null,null,81,null,81]
[14]
[null,"Other *",null,null,null,12,null,12,null,null,null,541074.81999999995]
[15]
[null,"Total Metered Sales",null,null,null,{"$f":"SUM(F31:G42)","v":767},null,{"$f":"SUM(H31:I42)","v":1448},null,{"$f":"SUM(J31:K42)","v":0},null,{"$f":"SUM(L31:M42)","v":541074.81999999995}]
[16]
[null,"Other Operating Revenues"]
[17,"Late Payment Fees"]
[null,"Inspection Fees"]
[18]
[null,"Reconnect Fees"]
[19]
[null,"Rent Income"]
[20]
[null,"Income from Merchandising, Jobbing & Contract Work *"]
[21]
[null,"Other Revenue *"]
[22]
[null,"Total Other Operating Revenues",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L45:M56)","v":0}]
[23]
[null,"Total Operating Revenues",null,null,null,null,null,null,null,null,null,{"$f":"L29+L43+L57","v":541074.81999999995}]
[24]
[null,null,null,null,null,null,null,null,null,null,null,"(Total to Pg. W-1)"]
[]
[]
[null,"*  Please attach a detailed explanation for these items."]
[null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,"Indicate formula cells"]

{"sheet":"PgW-3_Op Rev&Exp","index":16,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[[50,1,50,10],[31,1,31,8],[30,1,30,8],[5,1,5,10],[46,9,47,10],[46,1,47,8],[49,1,49,10],[48,1,48,10],[12,9,13,10],[14,1,15,8],[14,9,15,10],[16,1,17,8],[16,9,17,10],[26,1,27,8],[26,9,27,10],[18,9,19,10],[51,7,51,8],[44,9,45,10],[28,9,29,10],[28,1,29,8],[30,9,31,10],[38,1,39,8],[38,9,39,10],[40,1,41,8],[40,9,41,10],[42,9,43,10],[42,1,43,8],[34,9,35,10],[36,9,37,10],[32,1,33,8],[32,9,33,10],[36,1,37,8],[18,1,19,8],[34,1,35,8],[11,1,11,8],[10,9,11,10],[44,1,45,8],[20,1,21,8],[20,9,21,10],[22,1,23,8],[22,9,23,10],[12,1,13,8],[24,1,25,8],[24,9,25,10],[10,1,10,8],[9,9,9,10],[8,1,8,8],[9,1,9,8],[0,1,0,9],[1,1,1,10],[2,1,2,2],[2,3,2,10],[8,9,8,10],[3,1,3,10],[4,1,4,10],[6,9,6,10],[7,9,7,10],[6,1,6,8],[7,1,7,8]]}
[1,"For the calendar year of January 1 - December 31,",null,null,null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]
[]
[2,"Company Name:",null,{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[]
[null,"WATER OPERATING REVENUES, EXPENSES AND STATISTICS (Continued)"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Amount"]
[null,"(a)",null,null,null,null,null,null,null,"(b)"]
[]
[null,"Plant Operations Expenses"]
[3,"Repairs of Water Plant - Pump Repair"]
[null,"Repairs of Water Plant - Well Repair"]
[4]
[null,"Repairs of Water Plant - Water Line Repair"]
[5]
[null,"Repairs of Water Plant - Equipment Repair"]
[6]
[null,"Repairs of Water Plant - Other *",null,null,null,null,null,null,null,461014.93]
[7]
[null,"Fuel or Power Purchases for Pumping (i.e., Electric Bills, etc.)",null,null,null,null,null,null,null,125408.46]
[8]
[null,"Chemicals",null,null,null,null,null,null,null,2743.18]
[9]
[null,"Water Testing Expenses",null,null,null,null,null,null,null,958.25]
[10]
[null,"Total Plant Operations Expenses",null,null,null,null,null,null,null,{"$f":"SUM(J11:K26)","v":590124.82000000007}]
[11]
[null,null,null,null,null,null,null,null,null,"(Total to Page W-1)"]
[]
[null,"Tax Expenses",null,null,null,null,null,null,null,14984.04]
[12,"Tax Expense - Property Taxes"]
[null,"Tax Expense - Payroll Taxes"]
[13]
[null,"Tax Expense - Franchise Taxes"]
[14]
[null,"Tax Expense - Other Taxes *"]
[15]
[null,"Tax Expense - Federal Income Taxes"]
[16]
[null,"Tax Expense - State Income Taxes"]
[17]
[null,"Tax Expense - Investment Tax Credits"]
[18]
[null,"Total Tax Expenses",null,null,null,null,null,null,null,{"$f":"SUM(J31:K44)","v":14984.04}]
[19]
[null,null,null,null,null,null,null,null,null,"(Total to Page W-1)"]
[]
[]
[null,"*  Please attach a detailed explanation for these items."]
[]
[null,null,null,null,null,null,null,null,null,"Indicate formula cells"]

{"sheet":"PgW-4_Pump&Purch Wtr","index":17,"n_rows":60,"n_cols":18,"rows_kept":60,"cut":false,"hidden":false,"merged":[[1,15,7,15],[56,17,59,17],[9,15,59,15],[1,17,55,17],[27,12,28,13],[29,12,30,13],[23,12,24,13],[25,12,26,13],[48,12,49,13],[47,2,47,13],[43,12,43,13],[43,4,43,5],[44,2,44,13],[46,2,46,13],[43,6,43,8],[45,5,45,7],[45,8,45,13],[33,2,34,3],[35,2,36,3],[37,2,38,3],[33,10,34,11],[33,12,34,13],[56,4,57,9],[58,2,58,13],[52,10,53,11],[54,10,55,11],[56,10,57,11],[54,12,55,13],[56,12,57,13],[56,2,57,3],[50,12,51,13],[52,12,53,13],[50,2,51,3],[52,2,53,3],[54,2,55,3],[48,10,49,11],[48,4,49,9],[48,2,49,3],[50,4,51,9],[50,10,51,11],[52,4,53,9],[54,4,55,9],[0,2,0,13],[42,2,42,13],[41,2,41,3],[41,4,41,5],[41,6,41,7],[41,8,41,9],[39,2,40,3],[39,4,40,5],[41,10,41,11],[41,12,41,13],[39,6,40,7],[39,8,40,9],[37,12,38,13],[37,4,38,5],[37,6,38,7],[37,8,38,9],[37,10,38,11],[39,10,40,11],[39,12,40,13],[23,2,24,3],[25,2,26,3],[27,2,28,3],[29,2,30,3],[31,2,32,3],[35,6,36,7],[35,8,36,9],[35,10,36,11],[35,12,36,13],[29,4,30,5],[29,6,30,7],[29,8,30,9],[29,10,30,11],[27,4,28,5],[27,6,28,7],[27,8,28,9],[27,10,28,11],[31,12,32,13],[25,4,26,5],[25,6,26,7],[25,8,26,9],[25,10,26,11],[23,4,24,5],[23,6,24,7],[23,8,24,9],[23,10,24,11],[21,8,22,9],[21,2,22,3],[21,4,22,5],[21,6,22,7],[19,10,20,11],[21,10,22,11],[21,12,22,13],[19,2,20,3],[19,4,20,5],[19,6,20,7],[19,8,20,9],[17,8,18,9],[17,6,18,7],[17,4,18,5],[17,2,18,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[11,2,11,3],[9,2,9,3],[10,2,10,3],[13,6,13,7],[11,4,11,5],[12,4,12,5],[13,4,13,5],[12,2,12,3],[13,2,13,3],[6,4,6,11],[7,4,7,11],[8,4,8,11],[9,4,9,11],[54,0,59,0],[1,2,1,13],[3,12,3,13],[6,12,6,13],[7,12,7,13],[3,4,3,11],[11,10,11,11],[12,10,12,11],[13,10,13,11],[13,8,13,9],[59,10,59,11],[31,4,32,5],[33,4,34,5],[35,4,36,5],[43,10,43,11],[31,6,32,7],[31,8,32,9],[31,10,32,11],[10,4,10,11],[6,2,6,3],[7,2,7,3],[8,2,8,3],[12,12,12,13],[8,12,8,13],[33,6,34,7],[33,8,34,9],[4,12,4,13],[5,12,5,13],[10,12,10,13],[13,12,13,13],[4,4,4,11],[5,4,5,11],[12,8,12,9],[11,8,11,9],[11,6,11,7],[12,6,12,7],[9,12,9,13],[11,12,11,13],[14,2,14,13],[15,10,16,11],[15,12,16,13],[17,12,18,13],[17,10,18,11],[15,2,16,3],[15,4,16,5],[15,6,16,7],[15,8,16,9],[19,12,20,13]]}
[null,null,"PUMPING AND PURCHASED WATER STATISTICS",null,null,null,null,null,null,null,null,null,null,null,null,2,null,1]
[null,null,"(Omit 000's in reporting number of gallons or cubic feet of water.  Use additional sheets if necessary.)",null,null,null,null,null,null,null,null,null,null,null,null,"  Company Name:",null,"For the calendar year of January 1 - December 31,"]
[]
[]
[null,null,null,null,"Source of Supply"]
[null,null,null,null,"(Please describe source below.)"]
[null,3]
[null,4]
[null,5,null,null,null,null,null,null,null,null,null,null,"Total of all"]
[null,6,null,null,null,null,null,null,null,null,null,null,"Methods",null,null,{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[null,7,"Gallons Pumped Into System",null,null,null,null,null,null,null,null,null,"(a+b+c+d=e)"]
[]
[null,null,null,null,"(a)",null,"(b)",null,"(c)",null,"(d)",null,"(e)"]
[]
[null,null,"(Please indicate whether measurement is gallons or cubic feet.)"]
[null,null,"January",null,6794000,null,null,null,null,null,null,null,{"$f":"SUM(E16:L17)","v":6794000}]
[null,8]
[null,null,"February",null,7147000,null,null,null,null,null,null,null,{"$f":"SUM(E18:L19)","v":7147000}]
[null,9]
[null,null,"March",null,8318000,null,null,null,null,null,null,null,{"$f":"SUM(E20:L21)","v":8318000}]
[null,10]
[null,null,"April",null,8204000,null,null,null,null,null,null,null,{"$f":"SUM(E22:L23)","v":8204000}]
[null,11]
[null,null,"May",null,8940000,null,null,null,null,null,null,null,{"$f":"SUM(E24:L25)","v":8940000}]
[null,12]
[null,null,"June",null,11824000,null,null,null,null,null,null,null,{"$f":"SUM(E26:L27)","v":11824000}]
[null,13]
[null,null,"July",null,17318000,null,null,null,null,null,null,null,{"$f":"SUM(E28:L29)","v":17318000}]
[null,14]
[null,null,"August",null,18382000,null,null,null,null,null,null,null,{"$f":"SUM(E30:L31)","v":18382000}]
[null,15]
[null,null,"September",null,9725000,null,null,null,null,null,null,null,{"$f":"SUM(E32:L33)","v":9725000}]
[null,16]
[null,null,"October",null,8649000,null,null,null,null,null,null,null,{"$f":"SUM(E34:L35)","v":8649000}]
[null,17]
[null,null,"November",null,8350000,null,null,null,null,null,null,null,{"$f":"SUM(E36:L37)","v":8350000}]
[null,18]
[null,null,"December",null,8390000,null,null,null,null,null,null,null,{"$f":"SUM(E38:L39)","v":8390000}]
[null,19]
[null,null,"Total for Year",null,{"$f":"SUM(E16:F39)","v":122041000},null,{"$f":"SUM(G16:H39)","v":0},null,{"$f":"SUM(I16:J39)","v":0},null,{"$f":"SUM(K16:L39)","v":0},null,{"$f":"SUM(M16:N39)","v":122041000}]
[null,20]
[]
[]
[null,21,"Maximum Quantity Supplied to the System in Any One Day:",null,null,null,null,null,null,"Minimum:"]
[]
[null,22,"Range of Pressure in the Mains as Measured at the Highest Point on System:"]
[]
[null,null,"If Water is Sold to Other Utilities for Resale, List Names, Addresses, Phone Numbers and Quantities Below:"]
[null,null,"Name of Reseller",null,"Address",null,null,null,null,null,"Phone Number",null,"Quantity"]
[]
[]
[null,23]
[]
[null,24]
["Page W-4"]
[null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]
[null,26]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Indicate formula cells"]

{"sheet":"PgW-5_Wtr Plant","index":18,"n_rows":71,"n_cols":14,"rows_kept":71,"cut":false,"hidden":false,"merged":[[2,1,2,2],[7,8,7,9],[8,8,8,9],[4,1,4,13],[5,1,5,13],[6,1,6,3],[7,1,7,3],[8,1,8,3],[6,12,6,13],[7,6,7,7],[8,6,8,7],[6,10,6,11],[7,12,7,13],[8,12,8,13],[7,4,7,5],[8,4,8,5],[9,12,9,13],[9,10,9,11],[7,10,7,11],[8,10,8,11],[9,8,9,9],[6,6,6,7],[27,1,27,3],[28,1,28,3],[13,6,13,7],[10,6,10,7],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[6,8,6,9],[15,6,15,7],[16,6,16,7],[17,6,17,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[21,4,21,5],[17,1,17,3],[18,1,18,3],[19,1,19,3],[9,1,9,3],[10,1,10,3],[9,6,9,7],[14,6,14,7],[11,1,11,3],[12,1,12,3],[11,6,11,7],[12,6,12,7],[14,1,14,3],[9,4,9,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[28,4,28,5],[29,4,29,5],[23,4,23,5],[24,4,24,5],[25,4,25,5],[26,4,26,5],[27,4,27,5],[22,4,22,5],[40,6,40,7],[23,6,23,7],[58,6,58,7],[52,6,52,7],[54,6,54,7],[56,6,56,7],[57,6,57,7],[24,6,24,7],[36,6,36,7],[28,6,28,7],[37,6,37,7],[38,6,38,7],[50,6,50,7],[41,6,41,7],[48,6,48,7],[45,6,45,7],[42,6,42,7],[43,6,43,7],[44,6,44,7],[29,6,29,7],[30,6,30,7],[31,6,31,7],[32,6,32,7],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[39,6,39,7],[34,6,34,7],[35,6,35,7],[21,8,21,9],[22,8,22,9],[23,8,23,9],[28,8,28,9],[29,8,29,9],[30,8,30,9],[31,8,31,9],[35,8,35,9],[36,8,36,9],[37,8,37,9],[38,8,38,9],[39,8,39,9],[25,6,25,7],[26,6,26,7],[27,6,27,7],[33,6,33,7],[22,6,22,7],[49,8,49,9],[50,8,50,9],[42,8,42,9],[43,8,43,9],[44,8,44,9],[46,8,46,9],[23,10,23,11],[47,8,47,9],[48,8,48,9],[45,8,45,9],[34,8,34,9],[24,8,24,9],[25,8,25,9],[26,8,26,9],[24,10,24,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[28,10,28,11],[29,10,29,11],[27,8,27,9],[30,10,30,11],[31,10,31,11],[32,10,32,11],[62,8,62,9],[10,10,10,11],[11,10,11,11],[12,10,12,11],[13,10,13,11],[14,10,14,11],[17,10,17,11],[18,10,18,11],[19,10,19,11],[20,10,20,11],[21,10,21,11],[22,10,22,11],[61,8,61,9],[60,8,60,9],[51,8,51,9],[52,8,52,9],[54,8,54,9],[56,8,56,9],[55,8,55,9],[57,8,57,9],[58,8,58,9],[59,8,59,9],[32,8,32,9],[33,8,33,9],[33,10,33,11],[30,4,30,5],[31,4,31,5],[32,4,32,5],[33,4,33,5],[41,10,41,11],[42,10,42,11],[34,10,34,11],[35,10,35,11],[36,10,36,11],[40,8,40,9],[41,8,41,9],[42,4,42,5],[41,4,41,5],[39,4,39,5],[40,4,40,5],[38,4,38,5],[36,4,36,5],[37,4,37,5],[34,4,34,5],[37,10,37,11],[38,10,38,11],[35,4,35,5],[50,10,50,11],[51,10,51,11],[55,10,55,11],[52,10,52,11],[54,10,54,11],[46,10,46,11],[47,10,47,11],[32,1,32,3],[0,1,0,12],[2,3,2,13],[1,1,1,13],[3,1,3,13],[10,12,10,13],[13,1,13,3],[15,1,15,3],[16,1,16,3],[11,12,11,13],[12,12,12,13],[13,12,13,13],[16,10,16,11],[14,8,14,9],[15,8,15,9],[15,10,15,11],[16,8,16,9],[37,1,37,3],[38,1,38,3],[39,1,39,3],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[35,1,35,3],[36,1,36,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[34,1,34,3],[33,1,33,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[40,1,40,3],[41,1,41,3],[42,1,42,3],[43,1,43,3],[17,12,17,13],[14,12,14,13],[15,12,15,13],[16,12,16,13],[18,12,18,13],[19,12,19,13],[20,12,20,13],[21,12,21,13],[22,12,22,13],[23,12,23,13],[24,12,24,13],[25,12,25,13],[26,12,26,13],[31,12,31,13],[32,12,32,13],[27,12,27,13],[28,12,28,13],[29,12,29,13],[30,12,30,13],[35,12,35,13],[48,10,48,11],[49,10,49,11],[43,10,43,11],[44,10,44,11],[39,10,39,11],[40,10,40,11],[39,12,39,13],[48,12,48,13],[49,12,49,13],[33,12,33,13],[34,12,34,13],[40,12,40,13],[41,12,41,13],[42,12,42,13],[43,12,43,13],[44,12,44,13],[46,12,46,13],[47,12,47,13],[36,12,36,13],[37,12,37,13],[38,12,38,13],[51,12,51,13],[52,12,52,13],[63,10,63,11],[54,12,54,13],[56,12,56,13],[57,12,57,13],[58,12,58,13],[55,12,55,13],[59,12,59,13],[60,10,60,11],[61,10,61,11],[62,10,62,11],[56,10,56,11],[57,10,57,11],[58,10,58,11],[59,10,59,11],[43,4,43,5],[44,4,44,5],[44,1,44,3],[46,1,46,3],[47,1,47,3],[69,1,69,13],[45,1,45,3],[50,1,50,3],[49,1,49,3],[48,1,48,3],[51,6,51,7],[46,6,46,7],[47,6,47,7],[49,6,49,7],[45,10,45,11],[45,12,45,13],[45,4,45,5],[46,4,46,5],[47,4,47,5],[48,4,48,5],[64,10,64,11],[64,8,64,9],[65,1,65,13],[50,12,50,13],[81,1,81,13],[67,1,67,13],[68,1,68,13],[70,10,70,11],[53,12,53,13],[53,10,53,11],[61,6,61,7],[66,1,66,13],[63,6,63,7],[53,6,53,7],[53,8,53,9],[64,6,64,7],[62,6,62,7],[59,6,59,7],[60,6,60,7],[55,1,55,3],[55,6,55,7],[63,8,63,9],[64,1,64,3],[60,12,60,13],[61,12,61,13],[62,12,62,13],[63,12,63,13],[64,12,64,13]]}
[1,"For the calendar year of January 1 - December 31,",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]
[]
[2,"Company Name:",null,{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[]
[null,"WATER UTILITY PLANT IN SERVICE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Balance at"]
[null,null,null,null,"Acct.",null,"Balance at",null,"Additions During",null,"Retirements",null,"End of Year"]
[null,"Account Description",null,null,"No.",null,"Beginning of Year",null,"the Year",null,"During the Year",null,"(c+d-e)"]
[null,"(a)",null,null,"(b)",null,"(c)",null,"(d)",null,"(e)",null,"(f)"]
[null,"Intangible Plant",null,null,"Class B, C or D"]
[3,"Organization",null,null,301,null,null,null,47758,null,null,null,{"$f":"SUM(G12)+SUM(I12)-SUM(K12)","v":47758}]
[4,"Franchise and Consents",null,null,302,null,null,null,null,null,null,null,{"$f":"SUM(G13)+SUM(I13)-SUM(K13)","v":0}]
[5,"Miscellaneous Intangible Plant",null,null,303,null,null,null," ",null,null,null,{"$f":"SUM(G14)+SUM(I14)-SUM(K14)","v":0}]
[null,"Source of Supply Plant",null,null,null,null," ",null," "]
[6,"Land and Land Rights",null,null,310,null," ",null," ",null,null,null,{"$f":"SUM(G16)+SUM(I16)-SUM(K16)","v":0}]
[7,"Structures and Improvements",null,null,311,null,427618.49,null,39007.4,null,null,null,466625.89]
[8,"Collecting and Impounding Reservoirs",null,null,312,null," ",null," ",null,null,null,0]
[9,"Lake, River, and Other Intakes",null,null,313,null," ",null," ",null,null,null,0]
[10,"Wells and Springs",null,null,314,null,25389.09,null,3452.12,null,null,null,28841.21]
[11,"Infiltration Galleries and Tunnels",null,null,315,null," ",null," ",null,null,null,0]
[12,"Supply Mains",null,null,316,null,5536.89,null,5536.89,null,null,null,11073.78]
[13,"Other Water Source Plant *",null,null,317,null," ",null," ",null,null,null,0]
[null,"Pumping Plant",null,null,null,null," ",null," "]
[14,"Land and Land Rights",null,null,320,null," ",null," ",null,null,null,{"$f":"SUM(G25)+SUM(I25)-SUM(K25)","v":0}]
[15,"Structures and Improvements",null,null,321,null," ",null," ",null,null,null,0]
[16,"Boiler Plant Equipment",null,null,322,null," ",null," ",null,null,null,0]
[17,"Other Power Production Equipment *",null,null,323,null," ",null," ",null,null,null,0]
[18,"Submersible Electric Pumping",null,null,325.10000000000002,null,528714.92000000004,null,23056.71,null,null,null,551771.63]
[19,"High Service or Booster Pumps",null,null,325.2,null," ",null," ",null,null,null,0]
[20,"Diesel Pumping Equipment",null,null,326,null," ",null," ",null,null,null,0]
[21,"Hydraulic Pumping Equipment",null,null,327,null," ",null," ",null,null,null,0]
[22,"Other Pumping Equipment *",null,null,328,null," ",null," ",null,null,null,0]
[null,"Water Treatment Plant",null,null,null,null," ",null," "]
[23,"Land and Land Rights",null,null,330,null," ",null," ",null,null,null,{"$f":"SUM(G35)+SUM(I35)-SUM(K35)","v":0}]
[24,"Structures and Improvements",null,null,331,null," ",null," ",null,null,null,{"$f":"SUM(G36)+SUM(I36)-SUM(K36)","v":0}]
[25,"Water Treatment Equipment",null,null,332,null,843031.23,null,111.18,null,null,null,{"$f":"SUM(G37)+SUM(I37)-SUM(K37)","v":843142.41}]
[null,"Transmission and Distribution Plant",null,null,null,null," ",null," "]
[26,"Land and Land Rights",null,null,340,null," ",null," ",null,null,null,{"$f":"SUM(G39)+SUM(I39)-SUM(K39)","v":0}]
[27,"Structures and Improvements",null,null,341,null," ",null," ",null,null,null,0]
[28,"Distribution Reservoirs and Standpipes",null,null,342,null,385472.22,null,null,null,null,null,385472.22]
[29,"Transmission and Distribution Mains",null,null,343,null,2267104.0299999998,null,1919804.56,null,null,null,4186908.59]
[30,"Fire Mains",null,null,344,null," ",null,null,null,null,null,0]
[31,"Services",null,null,345,null,120872.11,null,749.89,null,null,null,121622]
[32,"Meters",null,null,346,null,211581.43,null,4614.4399999999996,null,null,null,216195.87]
[33,"Meter Installations",null,null,347,null," ",null,null,null,null,null,{"$f":"SUM(G46)+SUM(I46)-SUM(K46)","v":0}]
[34,"Hydrants",null,null,348,null,67975.41,null,67975.41,null,null,null,135950.82]
[35,"Other Transmission and Distribution Plant",null,null,349,null," ",null," ",null,null,null,0]
[null,"   General Plant",null,null,null,null," ",null," "]
[null,"Note:  USOA CLASS  B and C are the same",null,null,"B &C  ","D"," ",null," "]
[36,"Land and Land Rights                                                     ",null,null,389,370," ",null," ",null,null,null,{"$f":"SUM(G51)+SUM(I51)-SUM(K51)","v":0}]
[37,"Structures and Improvements                                    ",null,null,390,371," ",null," ",null,null,null,0]
[38,"Office Furniture and Equipment                                  ",null,null,391,372,65982.52,null,6034.52,null,null,null,72017.040000000008]
[39,"Office Computer and Electronic Equipment   ",null,null,391.1,372.1,null,null,null,null,null,null,{"$f":"SUM(G54)+SUM(I54)-SUM(K54)","v":0}]
[40,"Transportation Equipment                                           ",null,null,392,373,null,null," ",null,null,null,0]
[41,"Other General Equipment",null,null,"none  ",379,null,null,null,null,null,null,{"$f":"SUM(G56)+SUM(I56)-SUM(K56)","v":0}]
[42,"Stores Equipment                                                             ",null,null,393,"none  ",null,null," ",null,null,null,0]
[43,"Tools, Shop and Garage Equipment                         ",null,null,394,"none  ",15338.28,null,5051.1899999999996,null,null,null,20389.47]
[44,"Laboratory Equipment                                                    ",null,null,395,"none  ",null,null," ",null,null,null,0]
[45,"Power-operated Equipment                                         ",null,null,396,"none  ",null,null," ",null,null,null,0]
[46,"Communication Equipment                                         ",null,null,397,"none  ",5706.86,null,5706.86,null,null,null,11413.72]
[47,"Miscellaneous Equipment                                           ",null,null,398,"none  ",1159.74,null,1159.74,null,null,null,2319.48]
[48,"Other Tangible Property *                                            ",null,null,399,"none  ",null,null,null,null,null,null,{"$f":"SUM(G63)+SUM(I63)-SUM(K63)","v":0}]
[49,"Total Water Utility Plant In Service",null,null,null,null,{"$f":"SUM(G11:H63)","v":4971483.22},null,{"$f":"SUM(I11:J63)","v":2130018.91},null,{"$f":"SUM(K11:L63)","v":0},null,{"$f":"SUM(M11:N63)","v":7101502.1299999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,"(Total to Pages 4 and 9)"]
[]
[null,"*  Please attach a detailed explanation for these items."]
[]
[null,"NOTE:  All entries should be supported by records that identify the property being added or retired, its location, and its original cost in as much detail as reasonably possible.  If adjustments are included in Columns \"d\" and/or \"e\", use additional sheets."]
[]
[null,null,null,null,null,null,null,null,null,null,"             -",null,"Indicate formula cells"]

{"sheet":"PgW-6_Depr Res-Wtr Plant","index":19,"n_rows":71,"n_cols":12,"rows_kept":71,"cut":false,"hidden":false,"merged":[[14,10,14,11],[5,10,5,11],[11,10,11,11],[9,10,9,11],[10,10,10,11],[6,10,6,11],[7,10,7,11],[0,3,0,10],[1,4,1,11],[4,3,4,11],[2,3,2,11],[3,1,3,11],[5,1,10,2],[8,10,8,11],[5,6,5,8],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[22,10,22,11],[23,10,23,11],[15,10,15,11],[16,10,16,11],[17,10,17,11],[18,10,18,11],[19,10,19,11],[20,10,20,11],[21,10,21,11],[24,10,24,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[28,10,28,11],[29,10,29,11],[30,10,30,11],[31,10,31,11],[39,10,39,11],[40,10,40,11],[41,10,41,11],[32,10,32,11],[33,10,33,11],[34,10,34,11],[35,10,35,11],[36,10,36,11],[37,10,37,11],[38,10,38,11],[42,10,42,11],[49,10,49,11],[50,10,50,11],[43,10,43,11],[44,10,44,11],[45,10,45,11],[46,10,46,11],[47,10,47,11],[48,10,48,11],[59,10,59,11],[63,10,63,11],[64,10,64,11],[65,10,65,11],[60,10,60,11],[61,10,61,11],[62,10,62,11],[55,10,55,11],[56,10,56,11],[57,10,57,11],[58,10,58,11],[66,1,66,11],[67,1,67,11],[68,1,68,11],[69,1,69,11],[51,10,51,11],[52,10,52,11],[53,10,53,11],[54,10,54,11],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[42,1,42,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2]]}
[1,null,null,"For the calendar year of January 1 - December 31,",null,null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]
[2,null,null,"Company Name:",{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[]
[null,"DEPRECIATION RESERVE - WATER UTILITY PLANT"]
[]
[null,"Acct.\nNo. \n(b)",null,null,null,null,"Retirement of Property",null,null,null,"Reserve"]
[null,null,null,null,"Annual","Reserve",null,null,null,null,"Balance"]
[null,null,null,"Annual","Depreciation","Balance at","Book Cost",null,null,null,"at END"]
[null,null,null,"Depreciation","Expense","Beginning","of Plant","Cost of","Salvage","Other","of Year"]
[null,null,null,"Rate %","(f*g)","of Year","Retired","Removal","Credit","Charges","(h+i-j-k+l+m)"]
[null,null,null,"(g)***","(h)","(i)","(j)","(k) *","(l) *","(m)**","(n)"]
[null,{"$f":"'PgW-5_Wtr Plant'!E11","v":"Class B, C or D"}]
[3,{"$f":"'PgW-5_Wtr Plant'!E12","v":301},null,null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K12:L12)","v":0},null,null,null,{"$f":"E13+F13-(G13+H13-I13)+J13","v":0}]
[4,{"$f":"'PgW-5_Wtr Plant'!E13","v":302},null,null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K13:L13)","v":0},null,null,null,{"$f":"E14+F14-(G14+H14-I14)+J14","v":0}]
[5,{"$f":"'PgW-5_Wtr Plant'!E14","v":303},null,null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K14:L14)","v":0},null,null,null,{"$f":"E15+F15-(G15+H15-I15)+J15","v":0}]
[]
[6,{"$f":"'PgW-5_Wtr Plant'!E16","v":310},null,null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K16:L16)","v":0},null,null,null,{"$f":"E17+F17-(G17+H17-I17)+J17","v":0}]
[7,{"$f":"'PgW-5_Wtr Plant'!E17","v":311},null,2.5000000000000001E-2,null,369775.05,{"$f":"SUM('PgW-5_Wtr Plant'!K17:L17)","v":0},null,null,null,369775.05]
[8,{"$f":"'PgW-5_Wtr Plant'!E18","v":312},null,null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K18:L18)","v":0},null,null,null,0]
[9,{"$f":"'PgW-5_Wtr Plant'!E19","v":313},null,null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K19:L19)","v":0},null,null,null,0]
[10,{"$f":"'PgW-5_Wtr Plant'!E20","v":314},null,0.02,2971.38,2394.56,{"$f":"SUM('PgW-5_Wtr Plant'!K20:L20)","v":0},null,null,null,5365.9400000000005]
[11,{"$f":"'PgW-5_Wtr Plant'!E21","v":315},null,null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K21:L21)","v":0},null,null,null,0]
[12,{"$f":"'PgW-5_Wtr Plant'!E22","v":316},null,0.02,null,1090,{"$f":"SUM('PgW-5_Wtr Plant'!K22:L22)","v":0},null,null,null,1090]
[13,{"$f":"'PgW-5_Wtr Plant'!E23","v":317},null,null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K23:L23)","v":0},null,null,null,0]
[]
[14,{"$f":"'PgW-5_Wtr Plant'!E25","v":320},null,null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K25:L25)","v":0},null,null,null,{"$f":"E26+F26-(G26+H26-I26)+J26","v":0}]
[15,{"$f":"'PgW-5_Wtr Plant'!E26","v":321},null,null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K26:L26)","v":0},null,null,null,0]
[16,{"$f":"'PgW-5_Wtr Plant'!E27","v":322},null,null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K27:L27)","v":0},null,null,null,0]
[17,{"$f":"'PgW-5_Wtr Plant'!E28","v":323},null,null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K28:L28)","v":0},null,null,null,0]
[18,{"$f":"'PgW-5_Wtr Plant'!E29","v":325.10000000000002},null,0.1,null,246376.14,{"$f":"SUM('PgW-5_Wtr Plant'!K29:L29)","v":0},null,null,null,246376.14]
[19,{"$f":"'PgW-5_Wtr Plant'!E30","v":325.2},null,null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K30:L30)","v":0},null,null,null,0]
[20,{"$f":"'PgW-5_Wtr Plant'!E31","v":326},null,null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K31:L31)","v":0},null,null,null,0]
[21,{"$f":"'PgW-5_Wtr Plant'!E32","v":327},null,null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K32:L32)","v":0},null,null,null,0]
[22,{"$f":"'PgW-5_Wtr Plant'!E33","v":328},null,null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K33:L33)","v":0},null,null,null,0]
[]
[23,{"$f":"'PgW-5_Wtr Plant'!E35","v":330},null,null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K35:L35)","v":0},null,null,null,{"$f":"E36+F36-(G36+H36-I36)+J36","v":0}]
[24,{"$f":"'PgW-5_Wtr Plant'!E36","v":331},null,null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K36:L36)","v":0},null,null,null,{"$f":"E37+F37-(G37+H37-I37)+J37","v":0}]
[25,{"$f":"'PgW-5_Wtr Plant'!E37","v":332},null,2.9000000000000001E-2,185.88,336319.81,{"$f":"SUM('PgW-5_Wtr Plant'!K37:L37)","v":0},null,null,null,{"$f":"E38+F38-(G38+H38-I38)+J38","v":336505.69}]
[]
[26,{"$f":"'PgW-5_Wtr Plant'!E39","v":340},null,null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K39:L39)","v":0},null,null,null,{"$f":"E40+F40-(G40+H40-I40)+J40","v":0}]
[27,{"$f":"'PgW-5_Wtr Plant'!E40","v":341},null,null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K40:L40)","v":0},null,null,null,0]
[28,{"$f":"'PgW-5_Wtr Plant'!E41","v":342},null,2.5000000000000001E-2,null,127574.12,{"$f":"SUM('PgW-5_Wtr Plant'!K41:L41)","v":0},null,null,null,127574.12]
[29,{"$f":"'PgW-5_Wtr Plant'!E42","v":343},null,0.02,1164375.43,512938.58,{"$f":"SUM('PgW-5_Wtr Plant'!K42:L42)","v":0},null,null,null,1677314.01]
[30,{"$f":"'PgW-5_Wtr Plant'!E43","v":344},null,null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K43:L43)","v":0},null,null,null,0]
[31,{"$f":"'PgW-5_Wtr Plant'!E44","v":345},null,2.5000000000000001E-2,674.24,21748.05,{"$f":"SUM('PgW-5_Wtr Plant'!K44:L44)","v":0},null,null,null,22422.29]
[32,{"$f":"'PgW-5_Wtr Plant'!E45","v":346},null,null,1964.67,61211.13,{"$f":"SUM('PgW-5_Wtr Plant'!K45:L45)","v":0},null,null,null,63175.799999999996]
[33,{"$f":"'PgW-5_Wtr Plant'!E46","v":347},null,null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K46:L46)","v":0},null,null,null,0]
[34,{"$f":"'PgW-5_Wtr Plant'!E47","v":348},null,0.02,1962.59,5399.95,{"$f":"SUM('PgW-5_Wtr Plant'!K47:L47)","v":0},null,null,null,{"$f":"E48+F48-(G48+H48-I48)+J48","v":7362.54}]
[35,{"$f":"'PgW-5_Wtr Plant'!E48","v":349},null,null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K48:L48)","v":0},null,null,null,{"$f":"E49+F49-(G49+H49-I49)+J49","v":0}]
[]
[null,{"$f":"'PgW-5_Wtr Plant'!E50","v":"B &C  "},{"$f":"'PgW-5_Wtr Plant'!F50","v":"D"}]
[36,{"$f":"'PgW-5_Wtr Plant'!E51","v":389},{"$f":"'PgW-5_Wtr Plant'!F51","v":370},null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K51:L51)","v":0},null,null,null,{"$f":"E52+F52-(G52+H52-I52)+J52","v":0}]
[37,{"$f":"'PgW-5_Wtr Plant'!E52","v":390},{"$f":"'PgW-5_Wtr Plant'!F52","v":371},null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K52:L52)","v":0},null,null,null,0]
[38,{"$f":"'PgW-5_Wtr Plant'!E53","v":391},{"$f":"'PgW-5_Wtr Plant'!F53","v":372},0.05,1073.48,19990.79,{"$f":"SUM('PgW-5_Wtr Plant'!K53:L53)","v":0},null,null,null,21064.27]
[39,{"$f":"'PgW-5_Wtr Plant'!E54","v":391.1},{"$f":"'PgW-5_Wtr Plant'!F54","v":372.1},null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K54:L54)","v":0},null,null,null,0]
[40,{"$f":"'PgW-5_Wtr Plant'!E55","v":392},{"$f":"'PgW-5_Wtr Plant'!F55","v":373},null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K55:L55)","v":0},null,null,null,0]
[41,{"$f":"'PgW-5_Wtr Plant'!E56","v":"none  "},{"$f":"'PgW-5_Wtr Plant'!F56","v":379},null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K56:L56)","v":0},null,null,null,0]
[42,{"$f":"'PgW-5_Wtr Plant'!E57","v":393},{"$f":"'PgW-5_Wtr Plant'!F57","v":"none  "},null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K57:L57)","v":0},null,null,null,0]
[43,{"$f":"'PgW-5_Wtr Plant'!E58","v":394},{"$f":"'PgW-5_Wtr Plant'!F58","v":"none  "},0.05,703.49,2133.3200000000002,{"$f":"SUM('PgW-5_Wtr Plant'!K58:L58)","v":0},null,null,null,2836.8100000000004]
[44,{"$f":"'PgW-5_Wtr Plant'!E59","v":395},{"$f":"'PgW-5_Wtr Plant'!F59","v":"none  "},null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K59:L59)","v":0},null,null,null,0]
[45,{"$f":"'PgW-5_Wtr Plant'!E60","v":396},{"$f":"'PgW-5_Wtr Plant'!F60","v":"none  "},null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K60:L60)","v":0},null,null,null,{"$f":"E61+F61-(G61+H61-I61)+J61","v":0}]
[46,{"$f":"'PgW-5_Wtr Plant'!E61","v":397},{"$f":"'PgW-5_Wtr Plant'!F61","v":"none  "},6.7000000000000004E-2,null,3580.65,{"$f":"SUM('PgW-5_Wtr Plant'!K61:L61)","v":0},null,null,null,{"$f":"E62+F62-(G62+H62-I62)+J62","v":3580.65}]
[47,{"$f":"'PgW-5_Wtr Plant'!E62","v":398},{"$f":"'PgW-5_Wtr Plant'!F62","v":"none  "},null,null,339.83,{"$f":"SUM('PgW-5_Wtr Plant'!K62:L62)","v":0},null,null,null,{"$f":"E63+F63-(G63+H63-I63)+J63","v":339.83}]
[48,{"$f":"'PgW-5_Wtr Plant'!E63","v":399},{"$f":"'PgW-5_Wtr Plant'!F63","v":"none  "},null,null,null,{"$f":"SUM('PgW-5_Wtr Plant'!K63:L63)","v":0},null,null,null,0]
[49,null,null,"Total",{"$f":"SUM(E13:E64)","v":1173911.1599999999},1710871.9800000002,0,0,0,0,{"$f":"SUM(K13:L64)","v":2884783.14}]
[null,null,null,null,"(Total to Pg. 9 & Pg. W-1)",null,null,null,null,null,"(Total to Pg. 4)"]
[null,"NOTE:  Amounts included in Column \"j\" should be the same as in Column \"e\" on the preceding page.  Also, Annual Depreciation Expense is equal to Column \"f\" from preceding page multiplied by Column \"g\" found on this page."]
["*","All entries included in Columns \"k\" and \"l\" should be supported by records that identify the property retired and the cost of removal or salvage is as much detail as reasonably possible."]
["**","Report the details for these entries.  Use additional sheets if necessary."]
["***","Annual Depreciation Expense must be calculated separately.  This total should be calculated based upon actual in-service and retirement date(s) of new equipment and retirements during the period."]
[null,null,null,null,null,null,null,null,null,"             -","Indicate formula cells"]

{"sheet":"PgW-7_Pumps&Wells","index":20,"n_rows":56,"n_cols":11,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,2,0,6],[27,2,27,6],[54,0,58,0],[6,2,7,2],[16,2,17,2],[18,2,19,2],[20,2,21,2],[22,2,23,2],[24,2,25,2],[6,3,7,3],[24,3,25,3],[24,4,25,4],[24,5,25,5],[18,3,19,3],[18,4,19,4],[18,5,19,5],[20,3,21,3],[20,4,21,4],[1,2,1,6],[26,2,26,6],[8,5,9,5],[8,6,9,6],[10,5,11,5],[10,6,11,6],[8,2,9,2],[8,3,9,3],[8,4,9,4],[10,2,11,2],[10,3,11,3],[10,4,11,4],[22,5,23,5],[16,3,17,3],[16,4,17,4],[16,5,17,5],[12,5,13,5],[24,6,25,6],[34,3,35,3],[14,3,15,3],[14,4,15,4],[14,5,15,5],[32,2,33,2],[32,3,33,3],[12,3,13,3],[34,2,35,2],[32,4,33,4],[55,10,58,10],[9,8,58,8],[1,10,54,10],[48,4,49,4],[50,4,51,4],[40,4,41,4],[50,2,51,2],[46,3,47,3],[48,3,49,3],[50,3,51,3],[12,2,13,2],[14,2,15,2],[46,6,47,6],[48,6,49,6],[50,6,51,6],[46,5,47,5],[14,6,15,6],[22,3,23,3],[22,4,23,4],[48,5,49,5],[12,6,13,6],[28,2,28,6],[22,6,23,6],[50,5,51,5],[42,2,43,2],[36,4,37,4],[36,5,37,5],[36,6,37,6],[46,4,47,4],[42,4,43,4],[44,2,45,2],[46,2,47,2],[48,2,49,2],[42,3,43,3],[44,3,45,3],[36,3,37,3],[38,3,39,3],[40,3,41,3],[36,2,37,2],[38,2,39,2],[40,2,41,2],[1,8,7,8],[42,5,43,5],[42,6,43,6],[44,4,45,4],[44,5,45,5],[44,6,45,6],[12,4,13,4],[6,6,7,6],[16,6,17,6],[38,4,39,4],[38,5,39,5],[38,6,39,6],[40,5,41,5],[40,6,41,6],[18,6,19,6],[6,4,7,4],[6,5,7,5],[32,5,33,5],[32,6,33,6],[34,4,35,4],[34,5,35,5],[34,6,35,6],[20,5,21,5],[20,6,21,6]]}
[null,null,"PUMPS",null,null,null,null,null,2,null,1]
[null,null,null,null,null,null,null,null,"  Company Name:",null,"For the calendar year of January 1 - December 31,"]
[]
[null,null,null,null,null,"Date of Last","Date of Last"]
[null,null,"Manufacturer and Type (i.e., High Service, Well, Standby, etc.)","Capacity","Date Installed","Motor Replacement","Pump Replacement"]
[]
[null,null,"Peerless Well Pump","350 GPM"]
[null,3]
[null,null,"Peerless Well Pump","670 GPM"]
[null,4,null,null,null,null,null,null,{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[null,null,"Peerless Well Pump","260 GPM"]
[null,5]
[null,null,"Peerless Well Pump","300 GPM"]
[null,6]
[null,null,"Peerless Well Pump","365 GPM"]
[null,7]
[null,null,"3 - High Service Pumps at TCR 15HP","350 GPM Each"]
[null,8]
[null,null,"High Service Pump at TCR 30 HP","850 GPM"]
[null,9]
[null,null,"3 - High Service Pumps at HHR 60HP","? GPM Each"]
[null,10]
[null,null,"3 - High Service Pumps at HHR 100HP","? GPM Each"]
[null,11]
[null,null,"2 - High Service Pumps at OMR 40HP","490 GPM Each"]
[null,12]
[]
[null,null,"WELLS"]
[]
[]
[null,13,null,"Number:","Number:","Number:","Number:"]
[]
[null,null,"Description (i.e., Deep, Artisian, Spring, etc.)","Deep OMR","Deep HHR","Deep HHR","Deep TCR"]
[null,14]
[null,null,"Year Constructed"]
[null,15]
[null,null,"Type of Construction"]
[null,16]
[null,null,"Type of Casing","Steel","Steel","Steel","Steel"]
[null,17]
[null,null,"Depth and Diameter of Well","1915'                  10\"","1140'              12\"","1023'         8\"","800'             12\""]
[null,18]
[null,null,"Yield of Well in Gallons per day",504000,964800,640800,432000]
[null,19]
[null,null,"Chemicals (i.e., Provide Type, Cost and Quantities of Each):","Chlorine Gas","Chlorine Gas","Chlorine Gas","Chlorine Gas"]
[null,20]
[null,null,"     Type -"]
[null,21]
[null,null,"     Cost -",".75 Per #",".75 Per #",".75 Per #",".75 Per #"]
[null,22]
[null,null,"     Quantity -","250 #'s","175 #s","275 #'s","200 #s"]
[null,23]
[]
[]
["Page W-7"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]

{"sheet":"PgW-8_Meters&Storage","index":21,"n_rows":54,"n_cols":13,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,2,0,8],[34,2,34,8],[36,2,36,5],[1,2,1,8],[8,3,9,3],[8,4,9,4],[8,5,9,5],[10,8,11,8],[35,2,35,8],[8,2,9,2],[12,6,13,6],[8,8,9,8],[10,3,11,3],[10,4,11,4],[10,5,11,5],[10,6,11,6],[10,7,11,7],[8,6,9,6],[8,7,9,7],[12,7,13,7],[12,8,13,8],[14,3,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,6],[14,7,15,7],[14,8,15,8],[12,3,13,3],[12,4,13,4],[12,5,13,5],[18,7,19,7],[18,8,19,8],[16,3,17,3],[16,4,17,4],[16,5,17,5],[16,6,17,6],[16,7,17,7],[16,8,17,8],[20,7,21,7],[20,8,21,8],[18,3,19,3],[18,4,19,4],[20,3,21,3],[20,4,21,4],[20,5,21,5],[20,6,21,6],[18,5,19,5],[18,6,19,6],[24,5,25,5],[24,6,25,6],[24,7,25,7],[22,3,23,3],[22,4,23,4],[22,5,23,5],[22,6,23,6],[24,3,25,3],[30,5,31,5],[30,6,31,6],[22,7,23,7],[16,2,17,2],[18,2,19,2],[20,2,21,2],[30,3,31,3],[30,4,31,4],[22,2,23,2],[24,2,25,2],[30,2,31,2],[28,2,29,2],[28,3,29,3],[28,4,29,4],[26,2,27,2],[26,3,27,3],[45,0,53,0],[42,2,43,5],[48,2,49,5],[50,2,51,5],[9,10,53,10],[52,2,52,8],[37,2,37,5],[38,2,38,5],[46,2,47,5],[42,6,43,6],[41,2,41,5],[39,2,39,5],[46,6,47,6],[40,2,40,5],[28,6,29,6],[28,7,29,7],[50,8,51,8],[46,7,47,7],[46,8,47,8],[22,8,23,8],[24,8,25,8],[30,7,31,7],[30,8,31,8],[26,5,27,5],[1,10,7,10],[42,8,43,8],[26,7,27,7],[26,8,27,8],[28,8,29,8],[26,4,27,4],[24,4,25,4],[50,12,53,12],[44,2,45,5],[44,6,45,6],[44,7,45,7],[44,8,45,8],[48,7,49,7],[48,8,49,8],[1,12,49,12],[48,6,49,6],[50,6,51,6],[42,7,43,7],[50,7,51,7],[26,6,27,6],[28,5,29,5],[10,2,11,2],[12,2,13,2],[14,2,15,2]]}
[null,null,"METERS AND METER SETTINGS",null,null,null,null,null,null,null,2,null,1]
[null,null,null,null,null,null,null,null,null,null,"  Company Name:",null,"For the calendar year of January 1 - December 31,"]
[]
[null,null,null,null,null,null,null,null,"Total No. Owned"]
[null,null,null,null,"Total at","Total No. of","Total No. Removed","Total at","by Customers at"]
[null,null,"Customer Class","Meter Size","Beginning of Year","Additions","or Disconnected","End of Year","End of Year"]
[null,null,"(a)","(b)","(c)","(d)","(e)","(f)","(g)"]
[]
[null,null,"Residential:"]
[null,3,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[]
[null,4]
[]
[null,5]
[]
[null,6]
[null,null,"Other Customers:"]
[null,7]
[]
[null,8]
[]
[null,9]
[null,null,"Total in Use by Customers","XXXXXX",{"$f":"SUM(E9:E22)","v":0},{"$f":"SUM(F9:F22)","v":0},{"$f":"SUM(G9:G22)","v":0},{"$f":"SUM(H9:H22)","v":0},{"$f":"SUM(I9:I22)","v":0}]
[null,10]
[null,null,"Not in Use (i.e., Inventory)",null,null,null,null,null,"XXXXXX"]
[null,11]
[null,null,null,null,null,null,null,null,"XXXXXX"]
[null,12]
[null,null,null,null,null,null,null,null,"XXXXXX"]
[null,13]
[null,null,"Total Meters","XXXXXX",{"$f":"SUM(E23:E30)","v":0},{"$f":"SUM(F23:F30)","v":0},{"$f":"SUM(G23:G30)","v":0},{"$f":"SUM(H23:H30)","v":0},{"$f":"I23","v":0}]
[null,14]
[]
[]
[null,null,"STORAGE FACILITIES"]
[]
[]
[null,null,null,null,null,null,null,"Last Date Painted"]
[null,null,null,null,null,null,"Construction","if Applicable"]
[null,null,"Type of Storage (i.e., Pneumatic, Ground, Standpipes, Elevated Tanks, etc.)",null,null,null,"Material","(indicate interior or exterior)","Capacity"]
[null,null,"(a)",null,null,null,"(b)","(c)","(d)"]
[]
[]
[null,15]
[]
["Page W-8",16]
[]
[null,17]
[]
[null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]
[null,19]
[]
[null,null,null,null,null,null,null,null,"Indicate formula cells"]

{"sheet":"PgW-9_Mains","index":22,"n_rows":60,"n_cols":12,"rows_kept":60,"cut":false,"hidden":false,"merged":[[55,2,56,2],[13,2,14,2],[15,2,16,2],[27,3,27,6],[13,5,14,5],[13,6,14,6],[17,5,18,5],[17,6,18,6],[28,3,28,6],[29,3,29,6],[15,6,16,6],[37,2,38,2],[39,2,40,2],[41,2,42,2],[41,5,42,5],[41,6,42,6],[39,5,40,5],[39,6,40,6],[43,2,44,2],[45,2,46,2],[47,2,48,2],[51,2,52,2],[53,2,54,2],[37,4,38,4],[35,2,36,2],[35,5,36,5],[35,6,36,6],[0,2,0,7],[25,2,25,7],[17,2,18,2],[21,2,22,2],[9,3,10,3],[9,4,10,4],[13,3,14,3],[13,4,14,4],[17,3,18,3],[17,4,18,4],[9,2,10,2],[11,2,12,2],[9,5,10,5],[9,6,10,6],[9,7,10,7],[11,3,12,3],[11,4,12,4],[11,5,12,5],[11,6,12,6],[11,7,12,7],[13,7,14,7],[35,7,36,7],[15,7,16,7],[17,7,18,7],[21,3,22,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[21,7,22,7],[19,6,20,6],[15,3,16,3],[15,4,16,4],[15,5,16,5],[43,4,44,4],[47,4,48,4],[53,4,54,4],[51,4,52,4],[39,7,40,7],[41,4,42,4],[43,3,44,3],[45,3,46,3],[45,4,46,4],[45,5,46,5],[45,6,46,6],[45,7,46,7],[43,7,44,7],[54,0,59,0],[19,7,20,7],[19,2,20,2],[19,3,20,3],[19,4,20,4],[19,5,20,5],[24,2,24,7],[55,6,56,6],[55,7,56,7],[58,2,58,7],[55,3,56,3],[55,4,56,4],[55,5,56,5],[37,5,38,5],[37,6,38,6],[37,7,38,7],[49,6,50,6],[49,7,50,7],[41,7,42,7],[43,5,44,5],[43,6,44,6],[49,2,50,2],[49,3,50,3],[49,4,50,4],[56,11,59,11],[1,11,55,11],[9,9,59,9],[1,9,7,9],[51,7,52,7],[53,7,54,7],[47,7,48,7],[53,5,54,5],[53,6,54,6],[47,5,48,5],[51,5,52,5],[51,6,52,6],[47,6,48,6],[49,5,50,5],[1,2,1,7],[35,3,36,3],[37,3,38,3],[39,3,40,3],[41,3,42,3],[47,3,48,3],[51,3,52,3],[53,3,54,3],[35,4,36,4],[39,4,40,4]]}
[null,null,"MAINS (measurement in feet)",null,null,null,null,null,null,2,null,1]
[null,null,null,null,null,null,null,null,null,"  Company Name:",null,"For the calendar year of January 1 - December 31,"]
[]
[]
[null,null,null,null,null,null,"Total Removed"]
[null,null,"Kind of Pipe","Diameter of","Total at","Total Additions","or Abandoned ","Total at"]
[null,null,"(i.e., case iron, galvanized, iron, plastic, etc.)","Pipe","Beginning of Year","During the Year","During the Year","End of Year"]
[null,null,"(a)","(b)","(c)","(d)","(e)","(f)"]
[]
[null,null,"PVC","10\"",2030,null,null,{"$f":"E10+F10-G10","v":2030},null,{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[]
[null,null,"PVC","8\"",19878,null,null,{"$f":"E12+F12-G12","v":19878}]
[]
[null,null,"PVC","6\"",23974,null,null,{"$f":"E14+F14-G14","v":23974}]
[]
[null,null,"PVC","4\"",11065,null,null,{"$f":"E16+F16-G16","v":11065}]
[]
[null,null,"PVC","2\"",17998,null,null,{"$f":"E18+F18-G18","v":17998}]
[]
[null,null,"PVC","3/4\"",1060,null,null,{"$f":"E20+F20-G20","v":1060}]
[]
[null,null,"Total Mains",null,{"$f":"SUM(E10:E21)","v":76005},{"$f":"SUM(F10:F21)","v":0},{"$f":"SUM(G10:G21)","v":0},{"$f":"SUM(H10:H21)","v":76005}]
[]
[]
[]
[null,null,"SERVICES AVAILABLE FOR USE (from Main to Property Line)"]
[]
[]
[null,null,null,"Owned by Utility"]
[]
[null,null,null,null,null,null,null,"Total No. Owned"]
[null,null,"Size and Description by Type of Material ","Total No. at","Total No.","Total No. Retired","Total No. at","by Customers"]
[null,null,"(i.e., iron, copper, plastic, etc.)","Beginning of Year","of Additions","or Abandoned","End of Year","at End of Year"]
[null,null,"(a)","(b)","(c)","(d)","(e)","(f)"]
[]
[null,null,"In Use:"]
[]
[null,null,"2\" PVC",351,null,null,{"$f":"D38+E38-F38","v":351}]
[]
[null,null,null,null,null,null,{"$f":"D40+E40-F40","v":0}]
[]
[null,null,null,null,null,null,{"$f":"D42+E42-F42","v":0}]
[]
[null,null,null,null,null,null,{"$f":"D44+E44-F44","v":0}]
[]
[null,null,"For Future Use:"]
[]
[null,null,null,null,null,null,{"$f":"D48+E48-F48","v":0}]
[]
[null,null,null,null,null,null,{"$f":"D50+E50-F50","v":0}]
[]
[null,null,null,null,null,null,{"$f":"D52+E52-F52","v":0}]
[]
[null,null,null,null,null,null,{"$f":"D54+E54-F54","v":0}]
["Page W-9"]
[null,null,"Total of All Services",{"$f":"SUM(D37:D55)","v":351},{"$f":"SUM(E37:E55)","v":0},{"$f":"SUM(F37:F55)","v":0},{"$f":"SUM(G37:G55)","v":351},{"$f":"SUM(H37:H55)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]
[]
[]
[null,null,null,null,null,null,null,"Indicate formula cells"]

{"sheet":"PgS-1_Op Rev&Exp","index":23,"n_rows":60,"n_cols":11,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,1,0,9],[1,1,1,10],[2,1,2,2],[2,3,2,10],[3,1,3,10],[4,1,4,10],[5,1,5,10],[6,1,6,8],[6,9,6,10],[7,1,7,8],[7,9,7,10],[8,1,8,8],[8,9,8,10],[9,1,9,8],[9,9,9,10],[10,1,11,8],[10,9,11,10],[15,1,16,8],[17,1,18,8],[12,1,13,8],[14,1,14,8],[15,9,16,10],[17,9,18,10],[12,9,12,10],[23,1,24,8],[25,1,26,8],[19,1,20,8],[21,1,22,8],[31,1,32,8],[33,1,34,8],[27,1,28,8],[29,1,30,8],[56,1,56,10],[51,1,52,8],[51,9,52,10],[53,1,53,8],[53,9,53,10],[39,9,40,10],[43,1,44,8],[45,1,46,8],[39,1,40,8],[41,1,42,8],[35,1,36,8],[37,1,38,8],[54,1,54,10],[55,1,55,10],[47,1,48,8],[47,9,48,10],[49,1,50,8],[49,9,50,10],[27,9,28,10],[45,9,46,10],[33,9,34,10],[41,9,42,10],[29,9,30,10],[31,9,32,10],[35,9,36,10],[37,9,38,10],[43,9,44,10],[21,9,22,10],[13,9,14,10],[19,9,20,10],[23,9,24,10],[25,9,26,10]]}
[1,"For the calendar year of January 1 - December 31,",null,null,null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]
[]
[2,"Company Name:",null,{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[]
[null,"SEWER OPERATING REVENUES, EXPENSES AND STATISTICS"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Amount"]
[null,"(a)",null,null,null,null,null,null,null,"(b)"]
[]
[null,"Total Operating Revenues (From Page S-2)",null,null,null,null,null,null,null,{"$f":"'PgS-2_Op Rev&Exp'!$L$53","v":223665.82}]
[3]
[null,"Operating Expenses"]
[null,null,null,null,null,null,null,null,null,{"$f":"'Pg7_Payroll Info'!$K$46","v":0}]
[4,"Salaries & Wages (From Page 7)"]
[null,"Employee Pensions and Benefits"]
[5]
[null,"Purchased Water"]
[6]
[null,"Plant Operations Expenses (From Page S-3)",null,null,null,null,null,null,null,{"$f":"'PgS-3_Op Rev&Exp'!J31","v":321489.76}]
[7]
[null,"Billing Expenses"]
[8]
[null,"Supplies and Expenses"]
[9]
[null,"Transportation Expenses"]
[10]
[null,"Rent Expense *"]
[11]
[null,"Insurance Expense"]
[12]
[null,"Outside Services Employed (i.e., Legal, Accounting, etc.) (From Page 8)",null,null,null,null,null,null,null,{"$f":"'Pg8_Contract Svcs'!$K$49","v":0}]
[13]
[null,"Regulatory Commission Expenses"]
[14]
[null,"Uncollectible Expenses (From Page 6)",null,null,null,null,null,null,null,{"$f":"'Pg6_Sch of Uncollectibles'!$K$68","v":0}]
[15]
[null,"Depreciation Expense (From Page S-5)",null,null,null,null,null,null,null,{"$f":"'PgS-5_Depr Res-Swr Plant'!E54","v":217474.98}]
[16]
[null,"Amortization of Contributions in Aid of Construction (Page 9)",null,null,null,null,null,null,null,{"$f":"-Pg9_CIAC!$J$52","v":0}]
[17]
[null,"Amortization Expense"]
[18]
[null,"Tax Expenses (From Page S-3)",null,null,null,null,null,null,null,{"$f":"'PgS-3_Op Rev&Exp'!J49","v":5115.24}]
[19]
[null,"Interest Expense (From Page 10)",null,null,null,null,null,null,null,{"$f":"Pg10_Debt!$P$49","v":0}]
[20]
[null,"Other Expenses *"]
[21]
[null,"Total Operating Expenses",null,null,null,null,null,null,null,{"$f":"SUM(J14:J49)","v":544079.98}]
[22]
[null,"Net Income (Loss)",null,null,null,null,null,null,null,{"$f":"J11-J50","v":-320414.15999999997}]
[23]
[]
[]
[null,"*  Please attach a detailed explanation for these items."]
[]
[null,null,null,null,null,null,null,"Indicates link to another worksheet within workbook"]
[]
[null,null,null,null,null,null,null,"Indicate formula cells"]

{"sheet":"PgS-2_Op Rev&Exp","index":24,"n_rows":60,"n_cols":13,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,1,0,11],[1,1,1,12],[2,1,2,2],[2,3,2,12],[3,1,3,12],[4,1,4,12],[5,1,5,12],[6,1,6,12],[7,1,7,4],[7,5,7,8],[7,9,7,10],[7,11,7,12],[8,1,8,4],[8,5,8,8],[8,9,8,10],[8,11,8,12],[9,1,9,4],[9,5,9,8],[9,9,9,10],[9,11,9,12],[10,9,10,10],[10,11,10,12],[11,1,11,4],[11,9,11,10],[12,1,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[10,1,10,4],[10,5,10,8],[11,5,11,6],[11,7,11,8],[12,11,12,12],[13,1,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[14,11,14,12],[15,1,15,4],[15,5,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,12],[14,1,14,4],[14,5,14,6],[14,7,14,8],[14,9,14,10],[24,9,25,10],[24,11,25,12],[16,1,16,4],[17,1,17,4],[16,5,17,6],[16,7,17,8],[16,9,17,10],[16,11,17,12],[18,5,19,6],[18,7,19,8],[18,9,19,10],[18,11,19,12],[26,5,27,6],[26,7,27,8],[26,9,27,10],[26,11,27,12],[28,5,29,6],[28,7,29,8],[28,9,29,10],[28,11,29,12],[18,1,19,4],[20,1,21,4],[22,1,23,4],[24,1,25,4],[26,1,27,4],[28,1,29,4],[20,5,21,6],[20,7,21,8],[20,9,21,10],[20,11,21,12],[22,5,23,6],[22,7,23,8],[22,9,23,10],[22,11,23,12],[24,5,25,6],[24,7,25,8],[34,1,35,4],[36,1,37,4],[32,5,33,6],[34,5,35,6],[36,5,37,6],[32,7,33,8],[34,7,35,8],[36,7,37,8],[32,9,33,10],[34,9,35,10],[36,9,37,10],[11,11,11,12],[56,1,56,12],[57,1,57,12],[44,11,45,12],[38,5,38,10],[39,5,39,10],[40,1,41,10],[42,1,43,10],[44,1,45,10],[40,11,41,12],[42,11,43,12],[39,1,39,4],[32,11,33,12],[34,11,35,12],[36,11,37,12],[38,1,38,4],[38,11,39,12],[30,1,30,4],[31,1,31,4],[30,5,31,6],[30,7,31,8],[30,9,31,10],[30,11,31,12],[32,1,33,4],[58,1,58,12],[52,1,53,10],[54,11,55,12],[54,1,55,10],[46,11,47,12],[48,11,49,12],[50,11,51,12],[52,11,53,12],[48,1,49,10],[50,1,51,10],[46,1,47,10]]}
[1,"For the calendar year of January 1 - December 31,",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]
[]
[2,"Company Name:",null,{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[]
[null,"SEWER OPERATING REVENUES, EXPENSES AND STATISTICS (Continued)"]
[null,"(Please indicate if metered amounts are in cubic feet measurements.)"]
[]
[]
[null,null,null,null,null,"No. of"]
[null,null,null,null,null,"Customers"]
[null,null,null,null,null,null,null,null,null,"Gallons"]
[null,null,null,null,null,null,null,null,null,"Sold"]
[null,null,null,null,null,"Beginning",null,"End",null,"000's",null,"Revenue"]
[null,null,null,null,null,"of Year",null,"of Year",null,"Omitted",null,"Amount"]
[null,"(a)",null,null,null,"(b)",null,"(c)",null,"(d)",null,"(e)"]
[]
[null,"Flat Rate Sales",null,null,null,252,null,434,null,"XXXX",null,190529.43]
[3,"Residential - Single Family"]
[null,"Residential - Apartments",null,null,null,null,null,null,null,"XXXX"]
[4]
[null,"Residential - Mobile Homes",null,null,null,null,null,null,null,"XXXX"]
[5]
[null,"Commercial",null,null,null,11,null,11,null,"XXXX",null,33136.39]
[6]
[null,"Other Sales to Public Authorities",null,null,null,null,null,null,null,"XXXX"]
[7]
[null,"Other *",null,null,null,null,null,null,null,"XXXX"]
[8]
[null,"Total Unmetered Sales",null,null,null,{"$f":"SUM(F17:G28)","v":263},null,{"$f":"SUM(H17:I28)","v":445},null,"XXXX",null,{"$f":"SUM(L17:M28)","v":223665.82}]
[9]
[null,"Metered Sales of Water"]
[10,"Commercial"]
[null,"Other Sales to Public Authorities"]
[11]
[null,"Other *"]
[12]
[null,"Total Metered Sales",null,null,null,{"$f":"SUM(F31:G36)","v":0},null,{"$f":"SUM(H31:I36)","v":0},null,{"$f":"SUM(J31:K36)","v":0},null,{"$f":"SUM(L31:M36)","v":0}]
[13]
[null,"Other Operating Revenues"]
[14,"Late Payment Fees"]
[null,"Inspection Fees"]
[15]
[null,"Reconnect Fees"]
[16]
[null,"Rent Income"]
[17]
[null,"Income from Merchandising, Jobbing & Contract Work *"]
[18]
[null,"Other Revenue *"]
[19]
[null,"Total Other Operating Revenues",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L39:M50)","v":0}]
[20]
[null,"Total Operating Revenues",null,null,null,null,null,null,null,null,null,{"$f":"L29+L37+L51","v":223665.82}]
[21]
[null,null,null,null,null,null,null,null,null,null,null,"(Total to Pg. S-1)"]
[]
[]
[null,"*  Please attach a detailed explanation for these items."]
[null,"   "]
[null,null,null,null,null,null,null,null,null,null,null,"Indicate formula cells"]

{"sheet":"PgS-3_Op Rev&Exp","index":25,"n_rows":56,"n_cols":11,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,1,0,9],[1,1,1,10],[2,1,2,2],[2,3,2,10],[3,1,3,10],[4,1,4,10],[5,1,5,10],[6,1,6,8],[6,9,6,10],[7,1,7,8],[7,9,7,10],[8,1,8,8],[8,9,8,10],[9,1,9,8],[9,9,9,10],[10,1,10,8],[12,9,13,10],[10,9,11,10],[11,1,11,8],[12,1,13,8],[14,1,15,8],[14,9,15,10],[16,1,17,8],[16,9,17,10],[18,1,19,8],[18,9,19,10],[20,1,21,8],[20,9,21,10],[22,1,23,8],[22,9,23,10],[24,1,25,8],[24,9,25,10],[26,1,27,8],[26,9,27,10],[30,1,31,8],[30,9,31,10],[28,1,29,8],[28,9,29,10],[32,1,33,8],[32,9,33,10],[34,1,34,8],[34,9,35,10],[35,1,35,8],[36,1,37,8],[36,9,37,10],[38,1,39,8],[38,9,39,10],[40,1,41,8],[40,9,41,10],[42,1,43,8],[42,9,43,10],[44,1,45,8],[44,9,45,10],[46,1,47,8],[46,9,47,10],[48,1,49,8],[48,9,49,10],[55,7,55,8],[50,1,51,8],[50,9,51,10],[52,1,52,10],[53,1,53,10],[54,1,54,10]]}
[1,"For the calendar year of January 1 - December 31,",null,null,null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]
[]
[2,"Company Name:",null,{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[]
[null,"SEWER OPERATING REVENUES, EXPENSES AND STATISTICS (Continued)"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Amount"]
[null,"(a)",null,null,null,null,null,null,null,"(b)"]
[]
[null,"Plant Operations Expenses"]
[3,"Contracted Maintenance Expenses"]
[null,"Repairs of Sewer Plant - Pump Repair"]
[4]
[null,"Repairs of Sewer Plant - Treatment Repair"]
[5]
[null,"Repairs of Sewer Plant - Collecting Sewers and Manhole Repair"]
[6]
[null,"Repairs of Sewer Plant - Equipment Repair"]
[7]
[null,"Repairs of Sewer Plant - Other *",null,null,null,null,null,null,null,284852.14]
[8]
[null,"Utility Bills",null,null,null,null,null,null,null,19659]
[9]
[null,"Chemicals",null,null,null,null,null,null,null,7069.32]
[10]
[null,"Sludge Hauling Expenses",null,null,null,null,null,null,null,8406.2999999999993]
[11]
[null,"Effluent Testing Expenses",null,null,null,null,null,null,null,1503]
[12]
[null,"Total Plant Operations Expenses",null,null,null,null,null,null,null,{"$f":"SUM(J11:K30)","v":321489.76}]
[13]
[null,null,null,null,null,null,null,null,null,"(Total to Page S-1)"]
[]
[null,"Tax Expenses",null,null,null,null,null,null,null,5115.24]
[14,"Tax Expense - Property Taxes"]
[null,"Tax Expense - Payroll Taxes"]
[15]
[null,"Tax Expense - Franchise Taxes"]
[16]
[null,"Tax Expense - Other Taxes *"]
[17]
[null,"Tax Expense - Federal Income Taxes"]
[18]
[null,"Tax Expense - State Income Taxes"]
[19]
[null,"Tax Expense - Investment Tax Credits"]
[20]
[null,"Total Tax Expenses",null,null,null,null,null,null,null,{"$f":"SUM(J35:K48)","v":5115.24}]
[21]
[null,null,null,null,null,null,null,null,null,"(Total to Page S-1)"]
[]
[]
[null,"*  Please attach a detailed explanation for these items."]
[]
[null,null,null,null,null,null,null,null,null,"Indicate formula cells"]

{"sheet":"PgS-4_Swr Plant","index":26,"n_rows":69,"n_cols":14,"rows_kept":69,"cut":false,"hidden":false,"merged":[[5,12,5,13],[6,8,6,9],[6,10,6,11],[51,12,51,13],[0,1,0,12],[1,1,1,2],[1,3,1,13],[5,10,5,11],[2,1,2,13],[3,1,3,13],[4,1,4,13],[7,6,7,7],[7,8,7,9],[6,12,6,13],[5,1,5,3],[5,6,5,7],[5,8,5,9],[6,4,6,5],[5,4,5,5],[6,1,6,3],[6,6,6,7],[12,8,12,9],[12,10,12,11],[9,10,9,11],[7,12,7,13],[8,1,8,3],[8,6,8,7],[8,8,8,9],[8,10,8,11],[7,1,7,3],[11,12,11,13],[10,6,10,7],[10,8,10,9],[10,10,10,11],[10,1,10,3],[9,1,9,3],[9,6,9,7],[9,8,9,9],[7,10,7,11],[21,12,21,13],[14,6,14,7],[14,8,14,9],[14,10,14,11],[14,12,14,13],[15,12,15,13],[16,6,16,7],[16,8,16,9],[16,10,16,11],[16,12,16,13],[15,6,15,7],[15,8,15,9],[15,10,15,11],[17,10,17,11],[21,6,21,7],[21,8,21,9],[21,10,21,11],[17,6,17,7],[17,8,17,9],[18,10,18,11],[19,10,19,11],[23,6,23,7],[23,8,23,9],[23,10,23,11],[22,6,22,7],[22,8,22,9],[22,10,22,11],[29,12,29,13],[29,6,29,7],[29,8,29,9],[29,10,29,11],[22,12,22,13],[23,12,23,13],[36,1,36,3],[24,6,24,7],[24,8,24,9],[26,10,26,11],[27,10,27,11],[28,10,28,11],[28,12,28,13],[25,6,25,7],[25,8,25,9],[25,10,25,11],[25,12,25,13],[27,8,27,9],[28,6,28,7],[28,8,28,9],[26,8,26,9],[26,12,26,13],[27,12,27,13],[24,12,24,13],[26,6,26,7],[24,10,24,11],[38,12,38,13],[34,6,34,7],[34,8,34,9],[34,10,34,11],[34,12,34,13],[36,6,36,7],[36,10,36,11],[36,12,36,13],[30,12,30,13],[33,6,33,7],[33,8,33,9],[33,10,33,11],[33,12,33,13],[30,6,30,7],[30,8,30,9],[31,8,31,9],[32,8,32,9],[38,8,38,9],[37,10,37,11],[38,10,38,11],[37,8,37,9],[35,10,35,11],[35,8,35,9],[30,10,30,11],[43,10,43,11],[45,10,45,11],[46,10,46,11],[39,6,39,7],[39,8,39,9],[39,10,39,11],[41,6,41,7],[41,8,41,9],[40,8,40,9],[46,6,46,7],[38,1,38,3],[39,1,39,3],[42,1,42,3],[41,1,41,3],[43,6,43,7],[43,1,43,3],[37,6,37,7],[38,6,38,7],[40,6,40,7],[52,1,52,3],[53,1,53,3],[50,6,50,7],[50,8,50,9],[50,10,50,11],[44,10,44,11],[53,6,53,7],[53,8,53,9],[53,10,53,11],[52,6,52,7],[52,8,52,9],[47,6,47,7],[52,10,52,11],[49,10,49,11],[48,8,48,9],[49,8,49,9],[44,6,44,7],[47,1,47,3],[48,1,48,3],[49,1,49,3],[45,6,45,7],[48,6,48,7],[49,6,49,7],[68,10,68,11],[56,1,56,13],[32,1,32,3],[40,1,40,3],[57,1,57,13],[58,1,67,13],[46,8,46,9],[47,8,47,9],[54,1,54,13],[55,1,55,13],[34,1,34,3],[32,6,32,7],[36,8,36,9],[44,12,44,13],[50,12,50,13],[52,12,52,13],[53,12,53,13],[44,8,44,9],[50,1,50,3],[44,1,44,3],[42,6,42,7],[42,8,42,9],[45,1,45,3],[46,1,46,3],[16,1,16,3],[20,1,20,3],[21,1,21,3],[19,1,19,3],[22,1,22,3],[43,8,43,9],[45,8,45,9],[35,6,35,7],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[17,1,17,3],[25,1,25,3],[24,1,24,3],[23,1,23,3],[30,1,30,3],[27,1,27,3],[18,1,18,3],[26,1,26,3],[15,1,15,3],[29,1,29,3],[28,1,28,3],[33,1,33,3],[12,12,12,13],[20,6,20,7],[13,6,13,7],[13,8,13,9],[13,10,13,11],[13,12,13,13],[20,8,20,9],[12,6,12,7],[7,4,7,5],[10,12,10,13],[11,6,11,7],[11,8,11,9],[11,10,11,11],[9,12,9,13],[8,12,8,13],[18,12,18,13],[19,12,19,13],[20,12,20,13],[17,12,17,13],[18,6,18,7],[19,6,19,7],[18,8,18,9],[19,8,19,9],[20,10,20,11],[48,12,48,13],[49,12,49,13],[45,12,45,13],[46,12,46,13],[47,12,47,13],[48,10,48,11],[47,10,47,11],[31,1,31,3],[43,12,43,13],[31,10,31,11],[32,10,32,11],[40,10,40,11],[35,12,35,13],[42,12,42,13],[39,12,39,13],[41,10,41,11],[31,12,31,13],[32,12,32,13],[40,12,40,13],[41,12,41,13],[42,10,42,11],[37,12,37,13],[31,6,31,7],[37,1,37,3]]}
[1,"For the calendar year of January 1 - December 31,",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]
[{"$f":"A1+1","v":2},"Company Name:",null,{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[]
[null,"SEWER UTILITY PLANT IN SERVICE"]
[]
[null,null,null,null,"Acct.",null,null,null,null,null,null,null,"Balance at"]
[null,null,null,null,"No.",null,"Balance at",null,"Additions During",null,"Retirements",null,"End of Year"]
[null,"Account Description",null,null,"(b)",null,"Beginning of Year",null,"the Year",null,"During the Year",null,"(c+d-e)"]
[null,"(a)",null,null,"CLASS","CLASS","(c)",null,"(d)",null,"(e)",null,"(f)"]
[null,null,null,null," B","C & D"]
[null,"Intangible Plant"]
[{"$f":"A2+1","v":3},"Organization",null,null,301,301,26563.35,null,21194.720000000001,null,null,null,{"$f":"SUM(G12)+SUM(I12)-SUM(K12)","v":47758.07}]
[{"$f":"A12+1","v":4},"Franchise and Consents",null,null,302,302,null,null,null,null,null,null,{"$f":"SUM(G13)+SUM(I13)-SUM(K13)","v":0}]
[{"$f":"A13+1","v":5},"Miscellaneous Intangible Plant",null,null,303,303," ",null," ",null," ",null,{"$f":"SUM(G14)+SUM(I14)-SUM(K14)","v":0}]
[null,"Land and Structures",null,null,null,null," ",null," ",null," "]
[{"$f":"A14+1","v":6},"Land and Land Rights",null,null,"none",310," ",null," ",null," ",null,{"$f":"SUM(G16)+SUM(I16)-SUM(K16)","v":0}]
[{"$f":"A16+1","v":7},"Structures and Improvements",null,null,"none",311," ",null," ",null," ",null,{"$f":"SUM(G17)+SUM(I17)-SUM(K17)","v":0}]
[null,"Collection Plant",null,null,null,null," ",null," ",null," "]
[{"$f":"A17+1","v":8},"Land and Land Rights",null,null,350,"none"," ",null,null,null,null,null,{"$f":"SUM(G19)+SUM(I19)-SUM(K19)","v":0}]
[{"$f":"A19+1","v":9},"Structures and Improvements",null,null,351,"none",382356.67,null,6289.99,null,null,null,388646.66]
[10,"Collection Sewer - Force",null,null,352.1,352.1,8303.58,null,null,null,null,null,8303.58]
[11,"Collection Sewer - Gravity",null,null,352.2,352.2,571128.42000000004,null,30463.63,null,null,null,601592.05000000005]
[12,"Other Collection Plant Facilities *",null,null,353,353,9891.7199999999993,null,null,null,null,null,9891.7199999999993]
[13,"Services to Customers",null,null,354,354,2909.09,null,null,null,null,null,2909.09]
[14,"Flow Measuring Devices",null,null,355,355,-652.45000000000005,null,null,null," ",null,-652.45000000000005]
[null,"Pumping Plant",null,null,null,null," ",null," ",null," "]
[{"$f":"A25+1","v":15},"Land and Land Rights",null,null,360,"none"," ",null,null,null,null,null,{"$f":"SUM(G27)+SUM(I27)-SUM(K27)","v":0}]
[{"$f":"A27+1","v":16},"Structures and Improvements",null,null,361,"none",null,null,null,null,null,null,{"$f":"SUM(G28)+SUM(I28)-SUM(K28)","v":0}]
[{"$f":"A28+1","v":17},"Receiving Wells and Pump Pits",null,null,362,362,90677.1,null,null,null," ",null,{"$f":"SUM(G29)+SUM(I29)-SUM(K29)","v":90677.1}]
[{"$f":"A29+1","v":18},"Pumping Equipment",null,null,363,363,58127.46,null,531.34,null," ",null,{"$f":"SUM(G30)+SUM(I30)-SUM(K30)","v":58658.799999999996}]
[null,"Treatment and Disposal",null,null,null,null," ",null," ",null," "]
[{"$f":"A30+1","v":19},"Land and Land Rights",null,null,370,"none"," ",null,null,null,null,null,{"$f":"SUM(G32)+SUM(I32)-SUM(K32)","v":0}]
[{"$f":"A32+1","v":20},"Structures and Improvements",null,null,371,"none"," ",null,null,null,null,null,0]
[{"$f":"A33+1","v":21},"Oxidation Lagoon",null,null,"none",372,854231.29,null,23899.84,null," ",null,878131.13]
[22,"Treatment and Disposal Equipment",null,null,372,373,10340,null,null,null," ",null,10340]
[23,"Sewer Collection (Septic) Tanks",null,null,372.1,373.1,null,null,null,null,null,null,{"$f":"SUM(G36)+SUM(I36)-SUM(K36)","v":0}]
[24,"Plant Sewer",null,null,373,374," ",null," ",null," ",null,0]
[25,"Outfall Sewer Lines",null,null,374,375," ",null," ",null," ",null,0]
[26,"Other Treatment and Disposal Plant Equipment *",null,null,375,376," ",null," ",null," ",null,0]
[null,"General Plant",null,null,null,null," ",null," ",null," "]
[{"$f":"A39+1","v":27},"Land and Land Rights",null,null,389,"none"," ",null," ",null,null,null,{"$f":"SUM(G41)+SUM(I41)-SUM(K41)","v":0}]
[{"$f":"A41+1","v":28},"Structures and Improvements",null,null,390,"none"," ",null," ",null,null,null,0]
[{"$f":"A42+1","v":29},"Office Furniture and Equipment",null,null,391,391,5920.65,null," ",null," ",null,5920.65]
[30,"Computer and Electronic Office Equipment",null,null,391.1,391.1,null,null,null,null,null,null,0]
[31,"Transportation Equipment",null,null,392,392,null,null,null,null,null,null,0]
[32,"Other General Equipment *",null,null,"none",393," ",null," ",null,null,null,0]
[33,"Stores Equipment",null,null,393,"None"," ",null," ",null,null,null,0]
[34,"Tools Shop and Garage Equipment",null,null,394,"None",3035.66,null,422.92,null,null,null,3458.58]
[35,"Laboratory Equipment",null,null,395,"None"," ",null," ",null,null,null,0]
[36,"Power Operated Equipment",null,null,396,"None"," ",null," ",null,null,null,0]
[37,"Communications Equipment",null,null,397,"None",7843.24,null,101.78,null,null,null,7945.0199999999995]
[38,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G52)+SUM(I52)-SUM(K52)","v":0}]
[39,"                    Total Sewer Utility Plant In Service",null,null,null,null,{"$f":"SUM(G12:H51)","v":2030675.7799999998},null,{"$f":"SUM(I12:J51)","v":82904.219999999987},null,{"$f":"SUM(K12:L51)","v":0},null,{"$f":"SUM(M12:N51)","v":2113580.0000000005}]
[null,null,null,null,null,null,null,null,null,null,null,null,"(Total to Pages 4 and 9)"]
[null,"*  Please attach a detailed explanation for these items."]
[]
[null,"NOTE:  All entries should be supported by records that identify the property being added or retired, its location, and its original cost in as much detail as reasonably possible.  If adjustments are included in Columns \"d\" and/or \"e\", please explain below.  Use additional sheets if necessary."]
[]
[null,"Explanation:\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"             -",null,"Indicate formula cells"]

{"sheet":"PgS-5_Depr Res-Swr Plant","index":27,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":false,"merged":[[47,10,47,11],[13,10,13,11],[14,10,14,11],[16,10,16,11],[17,10,17,11],[19,10,19,11],[20,10,20,11],[18,10,18,11],[21,10,21,11],[22,10,22,11],[23,10,23,11],[29,10,29,11],[25,10,25,11],[24,10,24,11],[26,10,26,11],[27,10,27,11],[0,3,0,10],[12,10,12,11],[11,10,11,11],[6,6,10,6],[6,7,10,7],[6,8,10,8],[1,4,1,11],[5,3,10,3],[5,4,10,4],[2,3,2,11],[3,1,3,11],[28,10,28,11],[30,10,30,11],[34,10,34,11],[35,10,35,11],[37,10,37,11],[33,10,33,11],[31,10,31,11],[32,10,32,11],[36,10,36,11],[52,10,52,11],[54,10,54,11],[53,10,53,11],[38,10,38,11],[39,10,39,11],[43,10,43,11],[44,10,44,11],[42,10,42,11],[41,10,41,11],[40,10,40,11],[48,10,48,11],[51,10,51,11],[49,10,49,11],[50,10,50,11],[45,10,45,11],[46,10,46,11],[15,10,15,11],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[5,9,10,9],[5,10,10,11],[5,5,10,5],[5,6,5,8]]}
[{"$f":"'PgS-4_Swr Plant'!A1","v":1},null,null,"For the calendar year of January 1 - December 31,",null,null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]
[{"$f":"'PgS-4_Swr Plant'!A2","v":2},null,null,"Company Name:",{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[]
[null,"DEPRECIATION RESERVE - SEWER UTILITY PLANT"]
[]
[null,null,null,"Annual\nDepreciation\nRate % \n(g)","\nAnnual \nDepreciation \nExpense \n(f*g) \n   (h)***","Reserve\nBalance \nat Beginning \nof Year\n(i)","Retirement of Property",null,null,"Other\nCharges\n  (m)**","Reserve\nBalance\nat End of Year\n(h+i-j-k+l+m)\n(n)"]
[null,"Acct.",null,null,null,null,"Book Cost\nof Plant\nRetired\n(j)","Cost of \nRemoval\n(k)*","Salvage\nCredit \n (l)*"]
[null,"No."]
[null,"(b)",null,null,null,null,null,"Cost of","Salvage"]
[null,"CLASS","CLASS",null,null,null,null,"Removal","Credit"]
[null," B","C & D",null,null,null,null,"(K) *","(L) *"]
[]
[{"$f":"'PgS-4_Swr Plant'!A12","v":3},{"$f":"'PgS-4_Swr Plant'!E12","v":301},{"$f":"'PgS-4_Swr Plant'!F12","v":301},null,null,null,{"$f":"SUM('PgS-4_Swr Plant'!K12:L12)","v":0},null,null,null,{"$f":"E13+F13-(G13+H13-I13)+J13","v":0}]
[{"$f":"'PgS-4_Swr Plant'!A13","v":4},{"$f":"'PgS-4_Swr Plant'!E13","v":302},{"$f":"'PgS-4_Swr Plant'!F13","v":302},null,null,null,{"$f":"SUM('PgS-4_Swr Plant'!K13:L13)","v":0},null,null,null,{"$f":"E14+F14-(G14+H14-I14)+J14","v":0}]
[{"$f":"'PgS-4_Swr Plant'!A14","v":5},{"$f":"'PgS-4_Swr Plant'!E14","v":303},{"$f":"'PgS-4_Swr Plant'!F14","v":303},null,null,null,{"$f":"SUM('PgS-4_Swr Plant'!K14:L14)","v":0},null,null,null,{"$f":"E15+F15-(G15+H15-I15)+J15","v":0}]
[]
[{"$f":"'PgS-4_Swr Plant'!A16","v":6},{"$f":"'PgS-4_Swr Plant'!E16","v":"none"},{"$f":"'PgS-4_Swr Plant'!F16","v":310},null,null,null,{"$f":"SUM('PgS-4_Swr Plant'!K16:L16)","v":0},null,null,null,{"$f":"E17+F17-(G17+H17-I17)+J17","v":0}]
[{"$f":"'PgS-4_Swr Plant'!A17","v":7},{"$f":"'PgS-4_Swr Plant'!E17","v":"none"},{"$f":"'PgS-4_Swr Plant'!F17","v":311},null,null,null,{"$f":"SUM('PgS-4_Swr Plant'!K17:L17)","v":0},null,null,null,{"$f":"E18+F18-(G18+H18-I18)+J18","v":0}]
[]
[{"$f":"'PgS-4_Swr Plant'!A19","v":8},{"$f":"'PgS-4_Swr Plant'!E19","v":350},{"$f":"'PgS-4_Swr Plant'!F19","v":"none"},null,null,null,{"$f":"SUM('PgS-4_Swr Plant'!K19:L19)","v":0},null,null,null,{"$f":"E20+F20-(G20+H20-I20)+J20","v":0}]
[{"$f":"'PgS-4_Swr Plant'!A20","v":9},{"$f":"'PgS-4_Swr Plant'!E20","v":351},{"$f":"'PgS-4_Swr Plant'!F20","v":"none"},2.5000000000000001E-2,null,59566.66,{"$f":"SUM('PgS-4_Swr Plant'!K20:L20)","v":0},null,null,null,59566.66]
[{"$f":"'PgS-4_Swr Plant'!A21","v":10},{"$f":"'PgS-4_Swr Plant'!E21","v":352.1},{"$f":"'PgS-4_Swr Plant'!F21","v":352.1},0.02,166.07,675.68,{"$f":"SUM('PgS-4_Swr Plant'!K21:L21)","v":0},null,null,null,841.75]
[{"$f":"'PgS-4_Swr Plant'!A22","v":11},{"$f":"'PgS-4_Swr Plant'!E22","v":352.2},{"$f":"'PgS-4_Swr Plant'!F22","v":352.2},0.02,46056.69,110808.38,{"$f":"SUM('PgS-4_Swr Plant'!K22:L22)","v":0},null,null,null,156865.07]
[{"$f":"'PgS-4_Swr Plant'!A23","v":12},{"$f":"'PgS-4_Swr Plant'!E23","v":353},{"$f":"'PgS-4_Swr Plant'!F23","v":353},0.02,null,2187.59,{"$f":"SUM('PgS-4_Swr Plant'!K23:L23)","v":0},null,null,null,2187.59]
[{"$f":"'PgS-4_Swr Plant'!A24","v":13},{"$f":"'PgS-4_Swr Plant'!E24","v":354},{"$f":"'PgS-4_Swr Plant'!F24","v":354},3.3000000000000002E-2,null,424.04,{"$f":"SUM('PgS-4_Swr Plant'!K24:L24)","v":0},null,null,null,424.04]
[{"$f":"'PgS-4_Swr Plant'!A25","v":14},{"$f":"'PgS-4_Swr Plant'!E25","v":355},{"$f":"'PgS-4_Swr Plant'!F25","v":355},null,null,null,{"$f":"SUM('PgS-4_Swr Plant'!K25:L25)","v":0},null,null,null,0]
[]
[{"$f":"'PgS-4_Swr Plant'!A27","v":15},{"$f":"'PgS-4_Swr Plant'!E27","v":360},{"$f":"'PgS-4_Swr Plant'!F27","v":"none"},null,null,null,{"$f":"SUM('PgS-4_Swr Plant'!K27:L27)","v":0},null,null,null,{"$f":"E28+F28-(G28+H28-I28)+J28","v":0}]
[{"$f":"'PgS-4_Swr Plant'!A28","v":16},{"$f":"'PgS-4_Swr Plant'!E28","v":361},{"$f":"'PgS-4_Swr Plant'!F28","v":"none"},null,null,null,{"$f":"SUM('PgS-4_Swr Plant'!K28:L28)","v":0},null,null,null,{"$f":"E29+F29-(G29+H29-I29)+J29","v":0}]
[{"$f":"'PgS-4_Swr Plant'!A29","v":17},{"$f":"'PgS-4_Swr Plant'!E29","v":362},{"$f":"'PgS-4_Swr Plant'!F29","v":362},0.04,null,39765.800000000003,{"$f":"SUM('PgS-4_Swr Plant'!K29:L29)","v":0},null,null,null,{"$f":"E30+F30-(G30+H30-I30)+J30","v":39765.800000000003}]
[{"$f":"'PgS-4_Swr Plant'!A30","v":18},{"$f":"'PgS-4_Swr Plant'!E30","v":363},{"$f":"'PgS-4_Swr Plant'!F30","v":363},0.1,1871.41,11945.43,{"$f":"SUM('PgS-4_Swr Plant'!K30:L30)","v":0},null,null,null,{"$f":"E31+F31-(G31+H31-I31)+J31","v":13816.84}]
[]
[{"$f":"'PgS-4_Swr Plant'!A32","v":19},{"$f":"'PgS-4_Swr Plant'!E32","v":370},{"$f":"'PgS-4_Swr Plant'!F32","v":"none"},null,null,null,{"$f":"SUM('PgS-4_Swr Plant'!K32:L32)","v":0},null,null,null,{"$f":"E33+F33-(G33+H33-I33)+J33","v":0}]
[{"$f":"'PgS-4_Swr Plant'!A33","v":20},{"$f":"'PgS-4_Swr Plant'!E33","v":371},{"$f":"'PgS-4_Swr Plant'!F33","v":"none"},null,null,null,{"$f":"SUM('PgS-4_Swr Plant'!K33:L33)","v":0},null,null,null,0]
[{"$f":"'PgS-4_Swr Plant'!A34","v":21},{"$f":"'PgS-4_Swr Plant'!E34","v":"none"},{"$f":"'PgS-4_Swr Plant'!F34","v":372},0.05,168793.37,633193.21,{"$f":"SUM('PgS-4_Swr Plant'!K34:L34)","v":0},null,null,null,801986.58]
[{"$f":"'PgS-4_Swr Plant'!A35","v":22},{"$f":"'PgS-4_Swr Plant'!E35","v":372},{"$f":"'PgS-4_Swr Plant'!F35","v":373},2.5000000000000001E-2,0,1832.12,{"$f":"SUM('PgS-4_Swr Plant'!K35:L35)","v":0},null,null,null,1832.12]
[{"$f":"'PgS-4_Swr Plant'!A36","v":23},{"$f":"'PgS-4_Swr Plant'!E36","v":372.1},{"$f":"'PgS-4_Swr Plant'!F36","v":373.1},null,null,null,{"$f":"SUM('PgS-4_Swr Plant'!K36:L36)","v":0},null,null,null,{"$f":"E37+F37-(G37+H37-I37)+J37","v":0}]
[{"$f":"'PgS-4_Swr Plant'!A37","v":24},{"$f":"'PgS-4_Swr Plant'!E37","v":373},{"$f":"'PgS-4_Swr Plant'!F37","v":374},null,null,null,{"$f":"SUM('PgS-4_Swr Plant'!K37:L37)","v":0},null,null,null,0]
[{"$f":"'PgS-4_Swr Plant'!A38","v":25},{"$f":"'PgS-4_Swr Plant'!E38","v":374},{"$f":"'PgS-4_Swr Plant'!F38","v":375},null,null,null,{"$f":"SUM('PgS-4_Swr Plant'!K38:L38)","v":0},null,null,null,0]
[{"$f":"'PgS-4_Swr Plant'!A39","v":26},{"$f":"'PgS-4_Swr Plant'!E39","v":375},{"$f":"'PgS-4_Swr Plant'!F39","v":376},null,null,null,{"$f":"SUM('PgS-4_Swr Plant'!K39:L39)","v":0},null,null,null,0]
[]
[{"$f":"'PgS-4_Swr Plant'!A41","v":27},{"$f":"'PgS-4_Swr Plant'!E41","v":389},{"$f":"'PgS-4_Swr Plant'!F41","v":"none"},null,null,null,{"$f":"SUM('PgS-4_Swr Plant'!K41:L41)","v":0},null,null,null,{"$f":"E42+F42-(G42+H42-I42)+J42","v":0}]
[{"$f":"'PgS-4_Swr Plant'!A42","v":28},{"$f":"'PgS-4_Swr Plant'!E42","v":390},{"$f":"'PgS-4_Swr Plant'!F42","v":"none"},null,null,null,{"$f":"SUM('PgS-4_Swr Plant'!K42:L42)","v":0},null,null,null,0]
[{"$f":"'PgS-4_Swr Plant'!A43","v":29},{"$f":"'PgS-4_Swr Plant'!E43","v":391},{"$f":"'PgS-4_Swr Plant'!F43","v":391},0.05,0,3060.75,{"$f":"SUM('PgS-4_Swr Plant'!K43:L43)","v":0},null,null,null,3060.75]
[{"$f":"'PgS-4_Swr Plant'!A44","v":30},{"$f":"'PgS-4_Swr Plant'!E44","v":391.1},{"$f":"'PgS-4_Swr Plant'!F44","v":391.1},null,null,null,{"$f":"SUM('PgS-4_Swr Plant'!K44:L44)","v":0},null,null,null,0]
[{"$f":"'PgS-4_Swr Plant'!A45","v":31},{"$f":"'PgS-4_Swr Plant'!E45","v":392},{"$f":"'PgS-4_Swr Plant'!F45","v":392},null,null,null,{"$f":"SUM('PgS-4_Swr Plant'!K45:L45)","v":0},null,null,null,0]
[{"$f":"'PgS-4_Swr Plant'!A46","v":32},{"$f":"'PgS-4_Swr Plant'!E46","v":"none"},{"$f":"'PgS-4_Swr Plant'!F46","v":393},null,null,null,{"$f":"SUM('PgS-4_Swr Plant'!K46:L46)","v":0},null,null,null,0]
[{"$f":"'PgS-4_Swr Plant'!A47","v":33},{"$f":"'PgS-4_Swr Plant'!E47","v":393},{"$f":"'PgS-4_Swr Plant'!F47","v":"None"},null,null,null,{"$f":"SUM('PgS-4_Swr Plant'!K47:L47)","v":0},null,null,null,0]
[{"$f":"'PgS-4_Swr Plant'!A48","v":34},{"$f":"'PgS-4_Swr Plant'!E48","v":394},{"$f":"'PgS-4_Swr Plant'!F48","v":"None"},0.05,587.44000000000005,151.78,{"$f":"SUM('PgS-4_Swr Plant'!K48:L48)","v":0},null,null,null,739.22]
[{"$f":"'PgS-4_Swr Plant'!A49","v":35},{"$f":"'PgS-4_Swr Plant'!E49","v":395},{"$f":"'PgS-4_Swr Plant'!F49","v":"None"},null,null,null,{"$f":"SUM('PgS-4_Swr Plant'!K49:L49)","v":0},null,null,null,0]
[{"$f":"'PgS-4_Swr Plant'!A50","v":36},{"$f":"'PgS-4_Swr Plant'!E50","v":396},{"$f":"'PgS-4_Swr Plant'!F50","v":"None"},null,null,null,{"$f":"SUM('PgS-4_Swr Plant'!K50:L50)","v":0},null,null,null,0]
[{"$f":"'PgS-4_Swr Plant'!A51","v":37},{"$f":"'PgS-4_Swr Plant'!E51","v":397},{"$f":"'PgS-4_Swr Plant'!F51","v":"None"},6.7000000000000004E-2,null,111.24,{"$f":"SUM('PgS-4_Swr Plant'!K51:L51)","v":0},null,null,null,111.24]
[{"$f":"'PgS-4_Swr Plant'!A52","v":38},{"$f":"IF('PgS-4_Swr Plant'!E52>0, 'PgS-4_Swr Plant'!E52, \"\")","v":""},{"$f":"IF('PgS-4_Swr Plant'!F52>0, 'PgS-4_Swr Plant'!F52, \"\")","v":""},null,null,null,{"$f":"SUM('PgS-4_Swr Plant'!K52:L52)","v":0},null,null,null,0]
[{"$f":"'PgS-4_Swr Plant'!A53","v":39},null,null,"Total",{"$f":"SUM(E13:E53)","v":217474.98},863722.68,0,0,0,0,{"$f":"SUM(K13:L53)","v":1081197.6600000001}]
[null,null,null,null,"(Total to Pg. 9 & Pg. S-1)",null,null,null,null,null,"(Total to Pg. 4)"]
[null,null,null,null,null,null,null,null,"             -","Indicate formula cells"]

{"sheet":"PgS-6_Gen Info","index":28,"n_rows":100,"n_cols":13,"rows_kept":100,"cut":false,"hidden":false,"merged":[[21,7,21,8],[21,1,21,6],[1,1,1,12],[2,4,2,12],[0,1,0,11],[19,7,19,10],[7,1,13,12],[17,1,17,6],[19,1,19,6],[4,1,4,12],[5,1,5,12],[3,1,3,12],[2,1,2,3],[6,1,6,12],[14,1,14,12],[15,1,15,6],[74,1,74,4],[75,1,75,4],[70,1,70,12],[72,11,72,12],[75,9,75,10],[73,11,73,12],[74,11,74,12],[75,11,75,12],[76,11,76,12],[76,9,76,10],[72,7,72,8],[73,7,73,8],[74,7,74,8],[75,7,75,8],[23,7,23,12],[26,1,32,12],[35,1,41,12],[44,1,50,12],[71,2,71,4],[71,5,71,6],[62,1,68,12],[72,1,72,4],[73,1,73,4],[23,1,23,6],[25,1,25,12],[34,1,34,12],[78,6,79,6],[76,1,76,4],[77,1,77,4],[80,6,81,6],[82,6,83,6],[84,6,85,6],[86,6,87,6],[84,1,85,4],[78,1,79,4],[80,1,81,4],[82,1,83,4],[78,5,79,5],[80,5,81,5],[82,5,83,5],[86,1,87,4],[78,9,79,10],[78,11,79,12],[77,11,77,12],[72,9,72,10],[73,9,73,10],[74,9,74,10],[80,9,81,10],[80,11,81,12],[78,7,79,8],[80,7,81,8],[76,7,76,8],[77,7,77,8],[77,9,77,10],[82,11,83,12],[84,9,85,10],[84,11,85,12],[86,9,87,10],[89,1,89,12],[94,5,95,9],[93,5,93,9],[93,1,93,4],[94,10,95,10],[90,2,90,4],[90,5,90,6],[86,11,87,12],[86,7,87,8],[84,5,85,5],[86,5,87,5],[96,10,97,10],[98,10,99,10],[94,11,95,11],[94,12,95,12],[96,11,97,11],[96,12,97,12],[98,11,99,11],[98,12,99,12],[43,1,43,12],[52,1,52,12],[61,1,61,12],[53,1,59,12],[96,5,97,9],[98,5,99,9],[91,1,91,4],[92,1,92,4],[94,1,95,4],[96,1,97,4],[98,1,99,4],[92,5,92,9],[91,5,91,9],[82,7,83,8],[84,7,85,8],[82,9,83,10]]}
[1,"For the calendar year of January 1 - December 31,",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!G15>0,Cover!G15,\" \")","v":2011}]
[]
[2,"Company Name:",null,null,{"$f":"IF(Cover!$A$1>0,Cover!$A$1,\" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[]
[null,"GENERAL INFORMATION"]
[]
[3,"Treatment Facilities - Please describe process."]
[null,"OMR (#4 Constructed in Place) - EXTENDED AERATION/CHLORINATION/SLUDGE HOLDING TANK.  TCR (Package Unit) - PRIMARY SCREENING/FLOW EQUALIZATION/EXTENDED AERATION/AERATED SLUDGE HOLDING "]
[]
[]
[]
[]
[]
[]
[]
[4,"Was your treatment plant constructed in place or purchased as a package unit?",null,null,null,null,null,null,"Yes",null,"No"]
[]
[5,"Were your lift stations constructed in place or purchased as package units?",null,null,null,null,null,null,"Yes",null,"No"]
[]
[6,"What is the designated capacity of your treatment facilities?",null,null,null,null,null,"OMR .09 MGD / TCR .05 MGD"]
[]
[7,"What percent of designed capacity is currently being utilized?",null,null,null,null,null,"17% / 76%"]
[]
[8,"What is the name of the current operator?",null,null,null,null,null,"Roger Mullis / Stan Gilliam"]
[]
[9,"Please describe the treatment process for liquid waste."]
[null,"OMR (#4 Constructed in Place) - EXTENDED AERATION/CHLORINATION/SLUDGE HOLDING TANK.  TCR (Package Unit) - PRIMARY SCREENING/FLOW EQUALIZATION/EXTENDED AERATION/AERATED SLUDGE HOLDING "]
[]
[]
[]
[]
[]
[]
[]
[10,"Please describe the treatment process for waste solids."]
[null,"Sludge is retained in the Sludge Holding Tank and then hauled by a contract hauler"]
[]
[]
[]
[]
[]
[]
[]
[11,"Where is the point of discharge for liquid waste?"]
[]
[]
[]
[]
[]
[]
[]
[]
[12,"What is the ultimate disposal of waste solids and how obtained?"]
[null,"OMR -LAND APPLICATION AND TCR IS HAULED TO ANOTHER TREATMENT FACILITY BY CONTRACT HAULER"]
[]
[]
[]
[]
[]
[]
[]
[13,"List any equipment failures occurring during the year.  Please state when failure occurred and briefly describe the failure and corrective measures taken."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"COLLECTING SEWERS (measurement in feet)"]
[]
[]
[null,null,null,null,null,null,null,"Total No. of",null,"Total No. Removed"]
[null,"Kind of Pipe",null,null,null,"Diameter","Total No. at","Additions",null,"or Abandoned",null,"Total No. at"]
[null,"(i.e., Cast Iron, VCP, PVC, etc.)",null,null,null,"of Pipe","Beginning of Year","During the Year",null,"During the Year",null,"End of the Year"]
[null,"(a)",null,null,null,"(b)","(c)","(d)",null,"(e)",null,"(f)"]
[]
[null,"Force:"]
[14]
[null,"PVC",null,null,null,"6\",8\",10",13434]
[15]
[null,"Gravity:"]
[16]
[]
[17]
[]
[18]
[]
[null,"LIFT STATIONS"]
[]
[]
[null,"Pumps:  Name, Size, Type",null,null,null,"Location",null,null,null,null,"H.P.","GPM","TDH"]
[]
[null,"see next Page"]
[19]
[]
[20]
[]
[21]

{"sheet":"Sheet1","index":29,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,5,15,9],[16,1,16,4],[16,5,16,9],[17,1,17,4],[17,5,17,9],[6,5,6,9],[7,1,7,4],[7,5,7,9],[18,1,18,4],[18,5,18,9],[10,1,10,4],[10,5,10,9],[11,1,11,4],[11,5,11,9],[12,1,12,4],[12,5,12,9],[13,1,13,4],[13,5,13,9],[14,1,14,4],[14,5,14,9],[15,1,15,4],[8,1,8,4],[8,5,8,9],[9,1,9,4],[9,5,9,9],[0,1,0,12],[1,2,1,4],[1,5,1,6],[2,1,2,4],[2,5,2,9],[3,1,3,4],[3,5,3,9],[4,1,4,4],[4,5,4,9],[5,1,5,4],[5,5,5,9],[6,1,6,4]]}
[null,"LIFT STATIONS"]
[]
[]
[null,"Pumps:  Name, Size, Type",null,null,null,"Location",null,null,null,null,"H.P.","GPM","TDH"]
[]
[null,"Hydromatic 2.0 HP 1 1/4 Submersible",null,null,null,"#1 - NW Corner Bldg B - Streamside",null,null,null,null,2,30]
[19,"Hydromatic 2.0 HP 1 1/4 Submersible",null,null,null,"#2 - NE Corner Bldg E - Watersbluff",null,null,null,null,2,30]
[null,"Hydromatic 5.0 HP 1 1/4 Submersible",null,null,null,"#3 - Behind laundry - Campground",null,null,null,null,5,400]
[null,"Hydromatic 5.0 HP 1 1/4 Submersible",null,null,null,"#4 - Behind Timeshare - Unit #117",null,null,null,null,2,30]
[null,"Hydromatic 5.0 HP 1 1/4 Submersible",null,null,null,"#5 - Below Timeshare - Unit #45",null,null,null,null,5,400]
[20,"Pump#1 Electric - Submersible  Year installed 1998",null,null,null,"#1 - S of Entrance @ Member Registration E of Hwy 67",null,null,null,null,5,140]
[null,"Pump#2 Electric - Submersible  Year installed 1998",null,null,null,null,null,null,null,null,5,140]
[null,"Pump#1 Ebara - 230 V 60 Hz 3 phase power (1999)",null,null,null,"#2 - W of 1st Timeshare BLdg ",null,null,null,null,4.7,125,"42'"]
[null,"Pump#2 Ebara - 230 V 60 Hz 3 phase power (1999)",null,null,null,null,null,null,null,null,4.7,125]
[null,"Pump #1 Peabody Barnes Submersible 230V 3phase 2003",null,null,null,"#3 - WWTP, North of Lake",null,null,null,null,3]
[null,"Pump #2 Peabody Barnes Submersible 230V 3phase 2003",null,null,null,null,null,null,null,null,3]
[null,"Pump#1 Electric - Submersible",null,null,null,"#4 - S end of Lake @ A-Frames"]
[null,"Pump#2 Electric - Submersible"]
[21]

{"sheet":"Verification","index":30,"n_rows":36,"n_cols":16,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,1,0,13],[1,2,1,4],[1,5,1,15],[2,7,2,14],[5,3,5,13],[7,2,7,14],[8,3,8,13],[10,4,10,8],[12,2,12,3],[12,4,12,8],[13,4,13,9],[13,11,13,13],[14,4,14,9],[15,4,15,13],[16,4,16,13],[17,4,17,13],[18,4,18,13],[19,4,19,13],[20,4,20,13],[22,2,22,13],[23,4,23,5],[23,9,23,11],[24,4,24,5],[24,9,24,11],[31,7,31,13],[32,8,32,12],[33,3,33,7],[35,0,35,15],[25,7,25,13],[26,7,26,13],[29,4,29,5],[30,3,30,5],[30,6,30,11],[29,8,29,9]]}
[]
[null,null,"Annual Report of",null,null,{"$f":"IF(Cover!A1>0, Cover!A1, \" \")","v":"Algonquin Water Resources of Missouri- dba Resort Utilities"}]
[null,null,null,null,null,null,null,"for the calendar year of January 1 - December 31,",null,null,null,null,null,null,null,{"$f":"Cover!G15","v":2011}]
[]
[]
[null,null,null,"VERIFICATION"]
[]
[null,null,"The foregoing report must be verified by the oath of the President, Treasurer, General Manager or Receiver of the company. The oath required may be taken before any person authorized to administer an oath (Notary Public) by the laws of the State in which the same is taken."]
[null,null,null,"OATH"]
[]
[null,null,"State Of",null,null,null,null,null,null,"}"]
[null,null,null,null,null,null,null,null,null,"}","ss:"]
[null,null,"County Of",null,null,null,null,null,null,"}"]
[null,null,null,null,null,null,null,null,null,null,null,"makes oath and says that"]
[null,null,null,null,"Name of Affiant (Company Official/Representative)"]
[null,null,"s/he is"]
[null,null,null,null,"Official Title of the Affiant (Company Official/Representative)"]
[null,null,"of"]
[null,null,null,null,"Exact Legal Title or Name of the Respondent (Certificated Company Name)"]
[null,null,"and is located at",null,null,null,null,null,null,null,null,null,null,null,", "]
[null,null,null,null,"Address and Telephone Number of the Affiant (Company Official/Representative)"]
[]
[null,null,"that s/he has examined the foregoing report; that to the best of his or her knowledge, information, and belief, all statements of fact contained in the said report are true and the said report is a correct statement of the business and affairs of the above-named respondent."]
[null,null,null,"from","January 1",null,", ",{"$f":"Cover!G15","v":2011},", to and including","December 31",null,null,", ",{"$f":"Cover!G15","v":2011}]
[null,null,null,null,"Month/Day",null,null,"Year",null,"Month/Day",null,null,null,"Year"]
[]
[null,null,null,null,null,null,null,"Signature of Affiant (Company Official/Representative)"]
[]
[null,null,null,"         Subscribed and sworn to before me, a Notary Public, in and for the State  and County above named, "]
[null,null,null,"this     ",null,null,null,"day of",null,null,", ",null,"."]
[null,null,null,"        My Commission expires",null,null,null,null,null,null,null,null,","]
[]
[null,null,null,null,null,null,null,null,"Signature of Notary Public"]
[null,null,null,"Missouri Revised Statutes § 392.210 or §393.140"]
[]
["(See Instructions Pages 9 for more information to complete this page. )"]