Ws949-14

Transcript

'OILA'JU. CO.f P:llt• . . ...., Cmwlr 1'14 ... . . ,... . . . . . ,.. '~ tldt ~- CLASS "A" OR "B" WATER and/or WASTEWATER UTILITIES (Gross Revenue of More Than $200,000 Each) ANNUAL REPORT OF WS949-14-AR Aquarina Utilities, Inc. Exact Legal Name of Respondent 517-W /450-S Certificate Numbers Submitted To The STATE OF FLORIDA ' 'j ·-l' ::-·~~ -"!"_, ::;. \> -~·::: ....:::~- cr.'· PUBLIC SERVICE COMMISSION FOR THE YEAR ENDED DECEMBER 31, 2014 Form PSCIWAW 3 (Rev 12/99) CERTIFIED PUBUC ACCOUNTANTS, P.A. INDEPENDENT ACCOUNTANTS' COMPILATION REPORT Officers and Directors Aquarina Utilities, Inc. Jensen Beach, FL 34958 We have compiled the balance sheet of Aquarina Utilities, Inc., as of December 31, 2014 and 2013, and the related statements of income and retaining earnings for the year ended December 31, 2014 included in the accompanying prescribed form. We have not audited or reviewed the financial statements in the accompanying prescribed form and, accordingly, do not express an opinion or provide any assurance about whether the financial statements are in accordance with the form prescribed by the Florida Public Service Commission. Management is responsible for the preparation and fair presentation of the financial statements included in the form prescribed by the Florida Public Service Commission and for designing, implementing, and maintaining internal control relevant to the preparation and fair presentation of the financial statements. Our responsibility is to conduct the compilation in accordance with Statements on Standards for Accounting and Review Services issued by the American Institute of Certified Public Accountants. The objective of a compilation is to assist management in presenting financial information in the form of financial statements without undertaking to obtain or provide any assurance that there are no material modifications that should be made to the financial statements. These financial statements included in the accompanying prescribed form are presented in accordance with the requirements of the Florida Public Service Commission and are not intended to be a presentation in accordance with accounting principles generally accepted in the United States of America. The report is intended solely for information and use of the Florida Public Service Commission and is not intended to be and should not be used by anyone other than this specified party. CJN&WCPAs March 13, 2015 2560 Gu(f-to-Bay Bouleuard • Suite 200 • ClearuJater, FL 33765-4432 • 0./flce: (727)791-4020 • Fax: (727)797-3602 • www.cjnw.net Reconciliation ofRevenue to Regulatory Assessment Fee Revenue Water Operations Class A & B Company: Aquarina Utilities, Inc. For the Year Ended December 31, 2014 (a) (b) Gross Water Revenues per Sch. F-3 Accounts Gross Revenue: Unmetered Water Revenues (460) $ Total Metered Sales ((461.1 - 461.5) (c) Gross Water Revenues per RAFReturn (d) Difference (b)- (c) - - $ - 149,296 149,294 2 Total Fire Protection Revenue (462.1- 462.2) - - - Other Sales to Public Authorities (464) - - - 97,530 97,530 - Sales to Irrigation Customers ( 465) Sales for Resale (466) - - - Interdepartmental Sales (467) - - - Total Other Water Revenues (469- 474) Total Water Operating Revenue 22,579 $ LESS: Expense for Purchased Water from FPSC-Regulated Utility Net Water Operating Revenues 269,405 18,908 $ $ 269,405 265,732 3,671 $ $ 265,732 3,673 $ Explanations: Amended RAF to be filed. Instructions: For the current year, reconcile the gross water revenues reported on Schedule F-3 with the gross water revenues reported on the company's regulatory assessment fee return. Explain any differences reported in column (d). 3,673 Reconciliation ofRevenue to Regulatory Assessment Fee Revenue Wastewater Operations C/assA &B Company: Aquarina Utilities, Inc. For the Year Ended December 31, 2014 (a) (b) Gross Wastewater Revenues per Sch. F-3 Accounts Gross Revenue: Total Flat-Rate revenues (521.1 - 521.6) $ Total Measured Revenues (522.1 - 522.5) 8,959 (c) Gross Wastewater Revenues per RAFReturn $ 138,329 8,959 (d) Difference (b)- (c) $ - - 138,329 Revenues from Public Authorities (523) - - - Revenues from Other Systems (524) - - - Interdepartmental Revenues (525) - - - Total Other Wastewater Revenues (530- 536) 14,448 Total Wastewater Operating Revenue $ LESS: Expense for Purchased Wastewater from FPSC-Regulated Utility Net Wastewater Operating Revenues - - Reclaimed Water Sales (540.1- 544) 161,736 $ 161,736 161,736 $ $ 161,736 - - $ - 14,448 $ Explanations: Instructions: For the current year, reconcile the gross water revenues reported on Schedule F-3 with the gross water revenues reported on the company's regulatory assessment fee return. Explain any differences reported in column (d). - General Instructions 1. Prepare this report in conformity with the 1984 National Association of Regulatory Utility Commissioners Uniform System of Accounts for Water and/or Wastewater Utilities (USOA). 2. Interpret all accounting words and phrases in accordance with the USOA. 3. Complete each question fully and accurately, even if it has been answered in a previous annual report. Enter the word "None" where it truly and completely states the fact. 4. For any question, section, or page which is not applicable to the respondent enter the words "Not Applicable". Do not omit any pages. 5. Where dates are called for, the month and day should be stated as well as the year. 6. All schedules should be rounded to the nearest dollar unless otherwise specifically indicated. 7. Complete this report by means which will create a permanent record, such as by typewriter. 8. If there is not enough room on any schedule, an additional page or pages may be added provided the format of the added schedule matches the format of the schedule of the page with not enough room. Such a schedule should reference the appropriate schedules, state the name of the utility, and state the year of the report. 9. If it is necessary or desirable to insert additional statements for the purpose of further explanation of schedules, such statement should be made at the bottom of the page or an additional page inserted. Any additional pages should state the name of the utility, the year of the report, and reference the appropriate schedule. 10. Water and wastewater system pages should be grouped together by system and all pages in the water and wastewater sections should be numbered consecutively at the bottom of the page where noted. For example, if the water system pages total 50 pages, they should be grouped by system and numbered from 1 to 50. 11. Financial information for multiple systems charging rates which are covered under the same tariff should be reported as one system. However, the engineering data must be reported by individual system. 12. For water and wastewater utilities with more than one system, one (1) copy ofworkpapers showing the consolidation of systems for the operating sections, should be filed with the annual report. 13. The report should be filled out in quadruplicate and the original and two copies returned by March 31 of the year following the date of the report. The report should be returned to: Florida Public Service Commission Division of Water and Wastewater 2540 Shumard Oak Boulevard Tallahassee, Florida 32399-0873 The fourth copy should be retained by the utility i. TABLE OF CONTENTS SCHEDULE PAGE SCHEDULE PAGE EXECUTIVE SUMMARY Certification General Information Directory of Personnel Who Contact the FPSC Company Profile Parent I Affiliate Organization Chart Compensation of Officers & Directors E-1 E-2 E-3 E-4 E-5 E-6 Business Contracts With Officers, Directors and Affiliates Affiliation of Officers and Directors Businesses Which Are A Byproduct, Coproduct or Joint Product of Providing Service Business Transactions With Related Parties - Part I and II E-7 E-8 E-9 E-10 FINANCIAL SECTION Comparative Balance Sheet Assets and Other Debits Comparative Balance Sheet Equity Capital and Liabilities Comparative Operating Statement Schedule of Year End Rate Base Schedule of Year End Capital Structure Capital Structure Adjustments Utility Plant Utility Plant Acquisition Adjustments Accumulated Depreciation Accumulated Amortization Regulatory Commission Expense Amortization of Rate Case Expense Nonutility Property Special Deposits Investments and Special Funds Accounts and Notes Receivable - Net Accounts Receivable From Associated Companies Notes Receivable From Associated Companies Miscellaneous Current and Accrued Assets Unamortized Debt Discount I Expense I Premium Extraordinary Property Losses Miscellaneous Deferred Debits Capital Stock Bonds Statement of Retained Earnings Advances From Associated Companies Long Term Debt Notes Payable Accounts Payable to Associated Companies Accrued Interest and Expense Misc. Current and Accrued Liabilities Advances for Construction Other Deferred Credits Contributions In Aid Of Construction Accum. Amortization of C.I.A. C. Reconciliation of Reported Net Income with Taxable Income For Federal Income Taxes F-1 F-2 F-3 F-4 F-5 F-6 F-7 F-7 F-8 F-8 F-9 F-9 F-10 F-11 F-12 F-12 F-12 ii. F-13 F-13 F-14 F-15 F-15 F-16 F-17 F-17 F-18 F-18 F-19 F-20 F-21 F-21 F-22 F-23 F-23 TABLE OF CONTENTS SCHEDULE PAGE SCHEDULE PAGE WATER OPERATION SECTION Listing of Water System Groups Schedule of Year End Water Rate Base Water Operating Statement Water Utility Plant Accounts Basis for Water Depreciation Charges Analysis of Entries in Water Depreciation Reserve Contributions in Aid of Construction W-1 W-2 W-3 W-4 W-5 CIAC Additions I Amortization Water Operating Revenue Water Utility Expense Accounts Pumping and Purchased Water, Source Supply Water Treatment Plant Information Calculation of ERC's Other Water System Information W-6 W-7 W-8 W-9 W-10 W-11 W-12 W-13 W-14 WASTEWATER OPERATION SECTION Listing of Wastewater System Groups Schedule of Year End Wastewater Rate Base Wastewater Operating Statement Wastewater Utility Plant Accounts Analysis of Entries in Wastewater Depreciation Reserve Basis for Wastewater Depreciation Charges S-1 S-2 S-3 S-4 Contributions in Aid of Construction CIAC Additions I Amortization Wastewater Operating Revenue Wastewater Utility Expense Accounts Calculation of ERC's Wastewater Treatment Plant Information Other Wastewater System Information S-5 S-6 iii. S-7 S-8 S-9 S-10 S-11 S-12 S-13 EXECUTIVE SUMMARY CERTIFICATION OF ANNUAL REPORl YEAR OF REPORT December 31,2014 Aquarina Utilities, Inc. UTILITY NAME: I HEREBY CERTIFY, to the best of my knowledge and belief: YES ( X ) NO ( ) 1. The utility is in substantial compliance with the Uniform System of Accounts prescribed by the Florida Public Service Commission. YES ( X ) NO ( ) 2. The utility is in substantial compliance with all applicable rules and orders of the Florida Public Service Commission. ) 3. There have been no communications from regulatory agencies concerning noncompliance with, or deficiencies in, financial reporting practices that could have a material effect on the financial statement of the utility. ) 4. The annual report fairly represents the financial condition and results of operations of the respondent for the period presented and other information and statements presented in the report as to the business affairs of the respondent are true, correct and complete for the period for which it represents. YES ( X ) ( YES ( X ) ( NO NO Items Certified 2. 1. 3. 4. * 1. X * 2. 3. X X 4. X * Each of the four items must be certified YES or NO. Each item need not be certified by both officers. The items being certified by the officer should be indicated in the appropriate area to the left of the signature. NOTICE: Section 837.06, Florida Statutes, provides that any person who knowingly makes a false statement in writing with the intent to mislead a public servant in the performance of his duty shall be guilty of a misdemeanor of the second degree. E-1 YEAR OF REPORT December 31, 2014 ANNUAL REPORT OF Aquarina Utilities, Inc. (Exact Name of Utili~) Coun~: --------B•r•e•va•r•d________ List below the exact mailing address of the utili~ for which normal correspondence should be sent: P.O. Box308 Jensen Beach, FL 34958 Telephone: 772 ) e-Mail Address: 405-8090 [email protected] WEBSite: N/A Sunshine State One-Call of Florida, Inc. Member Number HQ2118 Name and address of person to whom correspondence concerning this report should be addressed: Anthony Q. DeSantis, CPA 2560 Gulf-to-Bay Boulevard, Suite 200 Clearwater, FL 33765-4432 Telephone: ( 727 ) 791-4020 List below the address of where the utili~'s books and records are located: 1726 NE Darlich Ave 235 Aquarina Blvd Jensen Beach, FL 34957 Melbourne Beach, FL 32951 405-8090 ( 772 ) Telephone: List below any groups auditing or reviewing the records and operations: Date of original organization of the utili~: 02/18/2011 Check the appropriate business enti~ of the utili~ as filed with the Internal Revenue Service: Individual Sub S Corporation Partnership D D CJ 1120 Corporation OJ List below every corporation or person owning or holding directly or indirectly 5 percent or more of the voting securities of the utili~: Percent Ownership 100 Name 1. Reginald Burge 2. 3. 4. % % % % % % % % % % 5. 6. 7. 8. 9. 10. E-2 UTILITY NAME: YEAR OF REPORT December 31, 2014 Aquarina Utilities, Inc. NAME OF COMPANY REPRESENTATIVE (1) DIRECTORY OF PERSONNEL WHO CONTACT THE FLORIDA PUBLIC SERVICE COMMISSION TITLE OR ORGANIZATIONAL POSITION UNIT TITLE (2) (3) USUAL PURPOSE FOR CONTACT WITH FPSC Martin Friedman (850) 877-6555 Attorney Sundstrom, Friedman & Fumero, LLP Legal matters Anthony Q De Santis (727) 791-4020 CPA CJN&W, CPAs Accounting and rate matters (1) Also list appropriate legal counsel, accountants and others who may not be on general payroll. (2) Provide individual telephone numbers if the person is not normally reached at the company. (3) Name of company employed by if not on general payroll. E-3 YEAR OF REPORT December 31, 2014 UTILITY NAME: Aquarina Utilities, Inc. COMPANY PROFILE Provide a brief narrative company profile which covers the following areas: A. B. C. D. E. F. Brief company history. Public services rendered. Major goals and objectives. Major operating divisions and functions. Current and projected growth patterns. Major transactions having a material effect on operations. (A) Aquarina Utilities, Inc. purchased the water and wastewater company that services the Aquarina devlopment of Melbourne Beach and its associated communities on February 18th, 2011 from Compass Bank, which held the property and assets formerly owned by Service Management Systems Inc. in foreclosure. (B) The Company provides water and sewer services only. (C) The Utility's goals continue to be the improvement of facilities and service and earn a fair rate of return on its investment in plant in service. (D) Water and sewer services only. (E) The Utility is currently looking to expand it's customer base on the island, to bringing consistent Service to neighorhoods currently struggling with water quality issues (F) None E-4 UTILITY NAME: YEAR OF REPORT December 31, 2014 Aquarina Utilities, Inc. PARENT I AFFILIATE ORGANIZATION CHARl Current as of 12/31/14 Complete below an organizational chart that shows all parents and subsidiaries of the utility. The chart must also show the relationship between the utility and the affiliates listed on E-7, E-10(a) and E-10(b). I Holly Bu+e I I I I I I Aquarina WaterWorks I Reginald Burge I I I l---- -- -- - :100% I ---{iO% I 1-Qe!!'!t!Q~~P~!L I Aquarina Utilities E-5 I I !Keith Burge -- --- -, I I I I I I I Gold Coast Utility Corp I UTILITY NAME: YEAR OF REPORT December31, 2014 Aquarina Utilities, Inc. COMPENSATION OF OFFICERS For each officer, list the time spent on respondent as an officer compared to time spent on total business activities and the compensation received as an officer from the respondent. NAME (a) TITLE (b) Kevin R. Burge Reginald J. Burge President Treasurer I Secretary %OF TIME SPENT AS OFFICER OF UTILITY (c) 100 50 OFFICERS COMPENSATION (d)(1) % % % % % % % % % - $ $ $ $ $ $ $ $ $ - (1) Compensation per contract for d1rect labor COMPENSATION OF DIRECTORS For each director, list the number of director meetings attended by each director and the compensation received as an director from the respondent. NUMBER OF DIRECTORS DIRECTORS MEETINGS COMPENSATION TITLE ATTENDED NAME (c) (d) (a) (b) $ $ $ $ $ $ $ $ $ None E-6 None YEAR OF REPORT December 31, 2014 UTILITY NAME: Aquarina Utilities, Inc. BUSINESS CONTRACTS WITH OFFICERS, DIRECTORS AND AFFILIATES List all contracts, agreements, and other business arrangements* entered into during the calendar year (other than compensation related to position with Respondents) between the Respondent and officer and director listed on Page E-6. In addition, provide the same information with respect to professional services for each firm, partnership, or organization with which the officer or director is affiliated. NAME OF OFFICER, DIRECTOR OR AFFILIATE (a) Aquarina Waterworks, Inc. * IDENTIFICATION OF SERVICE OR PRODUCT (b) Equipment Rental Operations Mowing Lab Testing Prep of DMR & MOR Customer Correspondence Billing Regulatory & Legal Correspondence AMOUNT (c) $ NAME AND ADDRESS OF AFFILIATED ENTITY (d) Holly & Kevin Burge 1726 NE Darlich Ave Jensen Beach, FL 34957 Per Contract Business Agreement, for this schedule, shall mean any oral or written business deal which binds the concerned parties for products or services during the reporting year or future years. Although the Respondent and/or other companies will benefit from the arrangement, the officer or director is, however, acting on his behalf or for the benefit of other companies or persons. E-7 YEAR OF REPORT December 31, 2014 UTILITY NAME: Aquarina Utilities, Inc. AFFILIATION OF OFFICERS AND DIRECTORS For each of the officials listed on page E-6, list the principal occupation or business affiliation and all affiliations or connections with any other business or financial organizations, firms, or partnerships. For purposes of this part, an official will be considered to have an affiliation with any business or financial organization, firm or partnership in which he is an officer, director, trustee, partner, or a person exercising similar functions. NAME (a) PRINCIPAL OCCUPATION OR BUSINESS AFFILIATION (b) AFFILIATION OR CONNECTION (c) NAME AND ADDRESS OF AFFILIATION OR CONNECTION (d) Kevin R. Burge Officer Officer Gold Coast Utility Corp 2517 Elm Circle Lake Wales, FL 33898 Reginald Burge Officer Officer Gold Coast Utility Corp 2517 Elm Circle Lake Wales, FL 33898 E-8 YEAR OF REPORT December 31, 2014 UTILITY NAME: Aquarina Utilities, Inc. BUSINESSES WHICH ARE A BYPRODUCT, COPRODUCT OR JOINT PRODUCT RESULT OF PROVIDING WATER OR SEWER SERVICE Complete the following for any business which is conducted as a byproduct, coproduct or joint product as a result of providing water and/or sewer service. This would include any business which requires the use of utility land and facilities. Examples of these types of businesses would be orange groves, nurseries, tree farms, fertilizer manufacturing, etc. This would not include any business for which the assets are properly included in Account 121 - Nonutility Property along with the associated revenues and expenses segregated out as nonutility also. ASSETS BOOK COST OF ACCT. ASSETS NO. (b) (c) BUSINESS OR SERVICE CONDUCTED (a) REVENUES REVENUES GENERATED (d) ACCT. NO. (e) EXPENSES EXPENSES INCURRED (f) None $ $ E-9 $ ACCT. NO. (g) YEAR OF REPORT December 31,2014 UTILITY NAME: Aquarina Utilities, Inc. BUSINESS TRANSACTIONS WITH RELATED PARTIES List each contract, agreement, or other business transaction exceeding a cumulative amount of $500 in any one year, entered into between the Respondent and a business or financial organization, firm, or partnership named on pages E-2 and E-6 identifying the parties, amounts, dates and product, asset, or service involved. Part I. Specific Instructions: Services and Products Received or Provided 1. Enter in this part all transactions involving services and products received or provided. 2. Below are some types of transactions to include: - management, legal and accounting - material and supplies furnished services -leasing of structures, land and - computer services equipment - engineering & construction services - rental transactions - repairing and servicing of equipment - sale, purchase or transfer of various products NAME OF COMPANY OR RELATED PARTY (a) Aquarina Waterworks, Inc. DESCRIPTION SERVICE AND/OR NAME OF PRODUCT (b) CONTRACTOR AGREEMENT EFFECTIVE DATES (c) Ongoing Contract Employee Agreement E-10(a) ANNUAL CHARGES (P)urchased or (S)old AMOUNT (d) (e) p $ 184,269 UTILITY NAME: YEAR OF REPORT December 31, 2014 Aquarina Utilities, Inc. BUSINESS TRANSACTIONS WITH RELATED PARTIES Part II. Specific Instructions: Sale, Purchase and Transfer of Assets 1 . Enter in this part all transactions relating to the purchase, sale or transfer of assets. 3. The columnar instructions follow: (a) Enter name of related party or company. (b) Describe briefly the type of assets purchased, sold or transferred. (c) Enter the total received or paid. Indicate purchase with "P" and sale with "S". (d) Enter the net book value for each item reported. (e) Enter the net profit or loss for each item (column (c) -column (d)). (f) Enter the fair market value for each item reported. In space below or in a supplemental schedule, describe the basis used to calculate fair market value. 2. Below are examples of some types of transactions to include: - purchase, sale or transfer of equipment. - purchase, sale or transfer of land and structures. - purchase, sale or transfer of securities. - noncash transfers of assets. - noncash dividends other than stock dividends. - writeoff of bad debts or loans. NAME OF COMPANY OR RELATED PARTY (a) None SALE OR PURCHASE PRICE (c) DESCRIPTION OF ITEMS (b) $ E-10(b) NET BOOK VALUE (d) $ GAIN OR LOSS (e) $ FAIR MARKET VALUE (f) $ FINANCIAL SECTION YEAR OF REPORT December 31,2014 UTILITY NAME: Aquarina Utilities, Inc. COMPARATIVE BALANCE SHEET -ASSETS AND OTHER DEBITS ACCT. NO. (a) REF. PAGE (c) (d) ACCOUNT NAME (b) UTILITY PLANT F-7 F-8 101-106 Utility Plant 108-110 Less: Accumulated Depreciation and Amortization Net Plant 114-115IUtility Plant Acquisition Adjustments (Net) 116* IOther Plant Adjustments (specify) I $ CURRENT YEAR 4,207,750 $ (3,458,520) PREVIOUS YEAR (e) 4,207,093 (3,388,979) 749,230 818,114 749,230 818,114 13,428 6,207 F-7 I Total Net Utility Plant OTHER PROPERTY AND INVESTMENTS 121 122 123 124 Nonutility Property Less: Accumulated Depreciation and Amortization Net Nonutility Property Investment in Associated Companies F-9 F-10 F-10 Utility Investments F-10 Other Investments 125 126-127 Special Funds F-10 Total Other Property and Investments CURRENT AND ACCRUED ASSETS 131 Cash 132 Special Deposits F-9 133 Other Special Deposits F-9 134 135 Working Funds Temporary Cash Investments 141-144 Accounts and Notes Receivable, Less Accumulated Provision for Uncollectable Accounts 145 146 151-153 161 162 171 172* 173* 174 Accounts Receivable from Associated Companies Notes Receivable from Associated Companies F-11 F-12 - 26,472 22,975 F-12 Materials and Supplies Stores Expense Prepayments Accrued Interest and Dividends Receivable Rents Receivable Accrued Utility Revenues Misc. Current and Accrued Assets - F-12 39,900 Total Current and Accrued Assets ... * Not Applicable for Class B Utll1t1es F-1(a) 29,182 YEAR OF REPORT December 31, 2014 UTILITY NAME: Aquarina Utilities, Inc. COMPARATIVE BALANCE SHEET- ASSETS AND OTHER DEBITS ACCT. NO. (a) REF. PAGE (c) ACCOUNT NAME (b) 181 DEFERRED DEBITS Unamortized Debt Discount & Expense F-13 182 Extraordinary Property Losses F-13 183 Preliminary Survey and Investigation Charges 184 Clearing Accounts 185* Temporary Facilities 186 187* Misc. Deferred Debits Research & Development Expenditures 190 Accumulated Deferred Income Taxes CURRENT YEAR PREVIOUS YEAR (e) (d) - F-14 Total Deferred Debits $ TOTAL ASSETS AND OTHER DEBITS 789,130 * Not Applicable for Class B Utilities NOTES TO THE BALANCE SHEET The space below is provided for important notes regarding the balance sheet. F-1(b) $ 847,296 YEAR OF REPORT December 31, 2014 UTILITY NAME: Aquarina Utilities, Inc. COMPARATIVE BALANCE SHEET- EQUITY CAPITAL AND LIABILITIES ACCT. NO. (a) REF. PAGE (c) ACCOUNT NAME lb) 201 EQUITY CAPITAL Common Stock Issued F-15 204 Preferred Stock Issued F-15 CURRENT YEAR (d) $ PREVIOUS YEAR (e) 1,000 $ 1,000 202,205* Capital Stock Subscribed 203,206* Capital Stock Liability for Conversion 207* Premium on Capital Stock Reduction in Par or Stated Value of Capital Stock 209* 210* Gain on Resale or Cancellation of Reacquired 211 Other Paid-in Capital 212 Discount on Capital Stock 213 Capital Stock Expense Capital Stock 214-215 Retained Earnings (Deficit) (Members Equity) 216 Reacquired Capital Stock 218 Proprietary Capital F-16 227,878 227,878 (744,258) (661 ,254) (515,380) (432,376) (Proprietorship and Partnership Only) Total Equity Capital (Deficit) LONG TERM DEBT F-15 222* Bonds Reacquire Bonds 223 Advances from Associated Companies F-17 425,517 312,656 224 Other Long Term Debt F-17 435,156 517,099 860,673 829,755 28,047 66,548 221 Total Long Term Debt CURRENT AND ACCRUED LIABILITIES 231 Accounts Payable 232 Notes Payable 233 Accounts Payable to Associated Co. F-18 234 F-18 235 Notes Payable to Associated Co. Customer Deposits 236 Accrued Taxes 237 238 239 240 241 Accrued Interest Accrued Dividends Matured Long Term Debt - F-18 F-19 Matured Interest Miscellaneous Current and Accrued Liabilities 193 130 25,550 24,680 20,068 F-20 Total Current and Accrued Liabilities 73,858 ... * Not Applicable for Class B Utlllt1es F-2(a) 91,358 YEAR OF REPORT December 31, 2014 UTILITY NAME: Aquarina Utilities, Inc. COMPARATIVE BALANCE SHEET- EQUITY CAPITAL AND LIABILITIES ACCT. NO. (a) REF. PAGE (c) ACCOUNT NAME (b) 251 DEFERRED CREDITS Unamortized Premium on Debt 252 Advances for Construction 253 255 Other Deferred Credits Accumulated Deferred Investment Tax Credits CURRENT YEAR (d) PREVIOUS YEAR (e) F-13 F-20 F-21 Total Deferred Credits OPERATING RESERVES 261 Property Insurance Reserve 262 Injuries and Damages Reserve Pensions and Benefits Reserve Miscellaneous Operating Reserves 263 265 Total Operating Reserves CONTRIBUTIONS IN AID OF CONSTRUCTION 271 Contributions in Aid of Construction F-22 1,087,387 1,046,384 272 Accumulated Amortization of Contributions in Aid of Construction F-22 (717,408) (687,825) 369,979 358,559 Total Net C.I.A.C. ACCUMULATED DEFERRED INCOME TAXES 281 282 283 Accumulated Deferred Income TaxesAccelerated Depreciation Accumulated Deferred Income Taxes Liberalized Depreciation Accumulated Deferred Income Taxes- Other Total Accum. Deferred Income Taxes TOTAL EQUITY CAPITAL AND LIABILITIES F-2(b) $ 789,130 $ 847,296 YEAR OF REPORT December31, 2014 UTILITY NAME: Aquarina Utilities, Inc. COMPARATIVE OPERATING STATEMENT ACCT. NO. (a) 400 469.530 REF. PAGE (d) ACCOUNT NAME (b) UTILITY OPERATING INCOME Operating Revenues Less: Guaranteed Revenue and AFPI F-3(b) F-3(b) Net Operating Revenues PREVIOUS YEAR (c) $ 426,688 CURRENT YEAR* (e) $ 431 '141 426,688 431 '141 401 Operating Expenses F-3(b) 378,123 370,686 403 Depreciation Expense Less: Amortization of CIAC F-3(b) 54,671 {25,845) {29,583) 28,826 39,956 51,409 6,366 55,903 4,326 464,724 470,871 F-22 Net Depreciation Expense 406 Amortization of Utility Plant Acquisition Adjustment F-3(b) 407 Amortization Expense (Other than CIAC) Taxes Other Than Income Current Income Taxes Deferred Federal Income Taxes F-3(b) W/S-3 W/S-3 W/S-3 Deferred State Income Taxes Provision for Deferred Income Taxes - Credit Investment Tax Credits Deferred to Future Periods W/S-3 W/S-3 W/S-3 W/S-3 408 409 410.10 410.11 411.10 412.10 412.11 Investment Tax Credits Restored to Operating Income Utility Operating Expenses Net Utility Operating Income 469/530 Add Back: Guaranteed Revenue and AFPI 413 Income From Utility Plant Leased to Others Gains (Losses) From Disposition of Utility Property 414 420 69,539 {38,036) {39,730) {38,036) {39,730) F-3(b) Allowance for Funds Used During Construction Total Utility Operating Income [Enter here and on Page F-3(c)] * For each account, column e should agree with columns f, g + h on F-3(b) F-3(a) COMPARATIVE OPERATING STATEMENT (Cont'd) WATER SCHEDULE W-3* (f) $ SEWER SCHEDULE S-3* (g) 269,405 $ OTHER THAN REPORTING SYSTEMS (h) 161,736 N/A - 269,405 161,736 244,327 126,359 44,740 {13,992) {15,591) 30,748 9,208 36,496 2,884 19,407 314,455 156,416 - 24,799 - 1,442 {45,050) 5,320 {45,050) 5,320 N/A * Total of Schedules W-3/S-3 for all rate groups F-3(b) YEAR OF REPORT December 31, 2014 UTILITY NAME: Aquarina Utilities, Inc. COMPARATIVE OPERATING STATEMENT (Cont'd) ACCT. NO. (a) REF. PAGE (d) ACCOUNT NAME (b) Total Utility Operating Income [from Page F-3(a)] 415 416 419 421 426 PREVIOUS YEAR (c) $ CURRENT YEAR (e) {38,036) $ {39,730) OTHER INCOME AND DEDUCTIONS Revenues From Merchandising, Jobbing and Contract Deductions Costs and Expenses of Merchandising, Jobbing and Contract Work Interest and Dividend Income Miscellaneous Nonutility Revenue Miscellaneous Nonutility Expenses 179 193 (150) Total Other Income and Deductions 408.20 409.20 TAXES APPLICABLE TO OTHER INCOME Taxes Other Than Income Income Taxes 410.20 411.20 412.20 412.30 Provision for Deferred Income Taxes Provision for Deferred Income Taxes - Credit Investment Tax Credits- Net Investment Tax Credits Restored to Operating Income 29 193 30,283 43,467 30,283 43,467 {68,290) {83,004) Total Taxes Applicable to Other Income 427 428 429 INTEREST EXPENSE Interest Expense Amortization of Debt Discount & Expense Amortization of Premium on Debt F-19 F-13 F-13 Total Interest Expense 433 434 409.30 EXTRAORDINARY ITEMS Extraordinary Income Extraordinary Deductions Income Taxes, Extraordinary Items Total Extraordinary Items NET INCOME Explain Extraordmary Income: F-3(c) YEAR OF REPORT December 31, 2014 UTILITY NAME: Aquarina Utilities, Inc. SCHEDULE OF YEAR END RATE BASE ACCT. NO. (a) 101 REF. PAGE (c) ACCOUNT NAME (b) F-7 Utility Plant In Service Less: WATER UTILITY (d) $ WASTEWATER UTILITY (e) $ 2,026,403 2,181,347 Nonused and Useful Plant (1) 108.1 Accumulated Depreciation F-8 110.1 Accumulated Amortization F-8 271 Contributions in Aid of Construction F-22 252 Advances for Construction F-20 (1 ,567,537) (1 ,890,983) (484,012) (603,375) (25,146) (313,011) 363,056 354,352 337,910 41,341 30,541 15,795 - - Subtotal Add: 272 Accumulated Amortization of Contributions F-22 in Aid of Construction Subtotal Plus or Minus: 114 Acquisition Adjustments (2) 115 Accumulated Amortization of F-7 F-7 Acquisition Adjustments (2) Working Capital Allowance (3) Other (Specify): Completed construction not classified RATE BASE $ NET UTILITY OPERATING INCOME $ ACHIEVED RATE OF RETURN (Operating Income I Rate Base) NOTES: (1) (2) (3) 368,451 ~45,050) -- $ 57,136 $ 5,320 % Estimated if not known. Include only those Acquisition Adjustments that have been approved by the Commission. Calculation consistent with last rate proceeding. In absence of a rate proceeding, Class A utilities will use the Balance Sheet Method and Class B Utilities will use the One-eighth Operating and Maintenance Method. F-4 9.31 % YEAR OF REPORT December 31,2014 UTILITY NAME: Aquarina Utilities, Inc. SCHEDULE OF CURRENT COST OF CAPITAL CONSISTENT WITH THE METHODOLOGY USED IN THE LAST RATE PROCEEDING (1) CLASS OF CAPITAL (a) (c) - $ Common Equity Preferred Stock PERCENTAGE OF CAPITAL DOLLAR AMOUNT (2) (b) % % 99.98 % 0.02 % % % % % % 860,673 Long Term Debt Customer Deposits 193 Tax Credits- Zero Cost Tax Credits - Weighted Cost Deferred Income Taxes Other (Explain) Total (1) $ 860,866 ACTUAL COST RATES (3) (d) WEIGHTED COST [ex d) (e) 9.94 % - % 5.13 % 2.00 % -% - % - % -% - % % % 5.1294 % 0.0004 % % % % % % 100.00 % 5.13 % If the Utility's capital structure is not used, explain which capital structure is used. (2) Should equal amounts on Schedule F-6, Column (g). (3) Mid-point of the last authorized Return On Equity or current leverage formula if none has been established. Must be calculated using the same methodology used in the last rate proceeding using current annual report year end amounts and cost rates APPROVED RETURN ON EQUITY ---9.94 Current Commission Return on Equity: Commission order approving Return on Equity: % Order No. PSC-03-1342-PAA-WS APPROVED AFUDC RATE COMPLETION ONLY REQUIRED IF AFUDC WAS CHARGED DURING THE YEAR ---- Current Commission approved AFUDC rate: None % Commission order approving AFUDC rate: If any utility capitalized any charge in lieu of AFUDC (such as interest only}, state the basis of the charge, an explanation as to why AFUDC was not charged and the percentage capitalized. F-5 YEAR OF REPORT UTILITY NAME: Aquarina Utilities, Inc. December31, 2014 SCHEDULE "B" SCHEDULE OF CAPITAL STRUCTURE ADJUSTMENTS PER BOOK BALANCE (b) CLASS OF CAPITAL (a) NON-UTILITY ADJUSTMENTS (c) OTHER(1) ADJUSTMENTS SPECIFIC (e) NON-JURIS. ADJUSTMENTS (d) . . CAPITAL STRUCTURE USED FOR AFUDC CALCULATION (g) OTHER(1) ADJUSTMENTS PRO RATA (f) . Preferred Stock . . . Long Term Debt 860,673 860 673 193 193 . . Common Equity $ Customer Deposits (515,380) $ $ $ 515,380 $ $ Tax Credits· Zero Cost Tax Credits - Weighted Cost Deferred Income Taxes Other (Explain): Notes Payab&e - Assoc Co Total $ 345,486 $ . . $ 1) Explain below all adjustments made in Columns (e) and (f) e) Remove negative equity F-6 $ 515,380 $ . $ 860,866 YEAR OF REPORT December 31,2014 UTILITY NAME: Aquarina Utilities, Inc. UTILITY PLANT ACCOUNTS 101 - 106 ACCT. NO. (a) 101 DESCRIPTION (b) Plant Accounts Utility Plant In Service 102 Utility Plant Leased to WATER (c) OTHER THAN REPORTING SYSTEMS (e) SEWER (d) TOTAL (f) $ 2,026,403 $ 2,181,347 N/A $ 4,207,750 $ 2,026,403 $ 2,181,347 N/A $ 4,207,750 Others 103 Property Held for Future Use 104 Utility Plant Purchased or 105 Construction Work in Sold Progress 106 Completed Construction Not Classified Total Utility Plant UTILITY PLANT ACQUISITION ADJUSTMENTS ACCOUNTS 114 AND 115 Report each acquisition adjustment and related accumulated amortization separately. For any acquisition adjustment approved by the Commission, include the Order Number. OTHER THAN REPORTING ACCT. WATER SEWER SYSTEMS TOTAL NO. DESCRIPTION (d) (e) (a) (b) (c) (f) 114 Acquisition Adjustment N/A $ - $ - $ - $ - Total Plant Acquisition Adjustment 115 - $ Accumulated Amortization $ N/A - - $ $ - $ - $ - $ - $ - Total Accumulated Amortization $ - $ - $ - $ - Total Acquisition Adjustments $ - $ - $ - $ - F-7 UTILITY NAME: YEAR OF REPORT December 31, 2014 Aquarina Utilities, Inc. ACCUMULATED DEPRECIATION (ACCT. 108) AND AMORTIZATION (ACCT.110' ' OTHER THAN REPORTING DESCRIPTION WATER SEWER SYSTEMS (d) (a) (b) (c) ACCUMULATED DEPRECIATION Account 108 Balance first of year N/A $ 1,522.798 $ 1,866,181 $ Credits during year: Accruals charged: 44,740 24 799 to Account 108.1 (1) TOTAL (e) 3,388,979 69 539 to Account 108.2 (2) to Account 108.3 (2) Other Accounts (Specify) Rounding - 3 3 44,740 24,802 69,542 (1 - (1 Salvage Other Credits (specify) : Total credits Debits during year: Rounding Cost of removal Other debits (specify) (1) Total debits $ Balance end of year ACCUMULATED AMORTIZATION Account 110 Balance first of year N/A 1,567,537 (1) $ 1,890,983 N/A $ 3,458,520 N/A N/A N/A N/A N/A N/A N/A N/A Credits during year: Accruals charged: to Account 110.2 (2) Other Accounts (specify): Total credits Debits during year: Book cost of plant retired Other debits (specify) Total debits Balance end of year (1) (2) (3) ... Account 108 for Class B ut1ht1es. Not applicable for Class B utilities. Account 110 for Class B utilities. F-8 UTILITY NAME: YEAR OF REPORT December 31, 2014 Aquarina Utilities, Inc. REGULA TORY COMMISSION EXPENSE AMORTIZATION OF RATE CASE EXPENSE (ACCTS. 666 AND 766) CHARGED OFF EXPENSE DURING YEAR INCURRED AMOUNT ACCT. DURING YEAR DESCRIPTION OF CASE (DOCKET NO.) (d) (c) (b) (a) None $ Total - - - $ - $ - $ NONUTILITY PROPERTY (ACCOUNT 121) Report separately each item of property with a book cost of $25,000 or more included in Account 121. Other items may be grouped by classes of property BEGINNING ENDING YEAR DESCRIPTION YEAR ADDITIONS REDUCTIONS BALANCE (a) (b) (d) (c) (e) $ None - $ - $ - $ - - $ - $ - - Total Nonutility Property $ - $ SPECIAL DEPOSITS (ACCOUNTS 132 AND 133) Report hereunder all special deposits carried in Accounts 132 and 133 YEAREND BOOK COST (b) DESCRIPTION OF SPECIAL DEPOSITS (a) SPECIAL DEPOSITS (Account 132): None $ - Total Special Deposits $ - OTHER SPECIAL DEPOSITS (Account 133): None $ - Total Other Special Deposits $ - F-9 UTILITY NAME: YEAR OF REPORT Decernber31,2014 Aquarina Utilities, Inc. INVESTMENTS AND SPECIAL FUNDS ACCOUNTS 123-127 Report hereunder all investments and special funds carried in Accounts 123 through 127 FACE OR YEAREND BOOK COST PAR VALUE DESCRIPTION OF SECURITY OR SPECIAL FUND (b) (c) (a) INVESTMENT IN ASSOCIATED COMPANIES (Account 123): N/A $ - $ - - $ Total Investment In Associated Companies UTILITY INVESTMENTS (Account 124): N/A $ - Total Utility Investments $ - - $ OTHER INVESTMENTS (Account 125): N/A $ - $ - - $ Total Other Investments SPECIAL FUNDS (Class A Utilities: Accounts 126 & 127; Class 8 Utilities: Account 127)) N/A $ $ Total Special Funds F-10 - - YEAR OF REPORT December 31, 2014 UTILITY NAME: Aquarina Utilities, Inc. ACCOUNTS AND NOTES RECEIVABLE- NET ACCOUNTS 141 - 144 Report hereunder all accounts and notes receivable included in Accounts 141 , 142 and 144. Amounts included in Accounts 142 and 144 should be listed individually TOTAL DESCRIPTION (b) (a) CUSTOMER ACCOUNTS RECEIVABLE (Account 141): 26,472 $ Combined Water & Wastewater Wastewater Other $ Total Customer Accounts Receivable OTHER ACCOUNTS RECEIVABLE (Acct. 142): $ - $ - 26,472 Total Other Accounts Receivable NOTES RECEIVABLE (Acct. 144): Total Notes Receivable Total Accounts and Notes Receivable ACCUMULATED PROVISION FOR UNCOLLECTABLE ACCOUNTS (Account 143): Balance First of Year Add: Provision for uncollectables for current year 26,472 $ - Others Total Additions Deduct accounts written off during year: Utility accounts Others - Total accounts written off - Balance end of year $ Total Accounts and Notes Receivable - Net F-11 26,472 UTILITY NAME: YEAR OF REPORT December 31, 2014 Aquarina Utilities, Inc. ACCOUNTS RECEIVABLE FROM ASSOCIATED COMPANIES ACCOUNT 145 Report each account receivable from associated companies separately DESCRIPTION (a) None Total TOTAL (b) $ - $ - NOTES RECEIVABLE FROM ASSOCIATED COMPANIES ACCOUNT 146 Report each note receivable from associated companies separately INTEREST DESCRIPTION RATE (a) (b) None Total TOTAL (c) $ - $ - MISCELLANEOUS CURRENT AND ACCRUED ASSETS ACCOUNT 174 DESCRIPTION - Provide itemized listing (a) None Total F-12 TOTAL (c) $ - $ - YEAR OF REPORT December 31, 2014 UTILITY NAME: Aquarina Utilities, Inc. UNAMORTIZED DEBT DISCOUNT AND EXPENSE AND PREMIUM ON DEBT Report the net discount and expense or premium separately for each security issue. AMOUNT WRITTEN OFF YEAR END DESCRIPTION DURING YEAR BALANCE (a) (c) (b) UNAMORTIZED DEBT DISCOUNT AND EXPENSE (Account 181): N/A $ - $ - $ - $ - $ - $ - Total Unamortized Debt Discount and Expense UNAMORTIZED PREMIUM ON DEBT (Account 251): N/A Total Unamortized Premium on Debt EXTRAORDINARY PROPERTY LOSSES ACCOUNT 182 Report each item separately. DESCRIPTION (a) EXTRAORDINARY PROPERTY LOSSES (Acct. 182): N/A Total Extraordinary Property Losses F-13 TOTAL (b) $ - $ - YEAR OF REPORT December31, 2014 UTILITY NAME: Aquarina Utilities, Inc. MISCELLANEOUS DEFERRED DEBITS ACCOUNT 186 DESCRIPTION - Provide itemized listing (a) DEFERRED RATE CASE EXPENSE (Class A Utilities: Account 186.1): None Total Deferred Rate Case Expense OTHER DEFERRED DEBITS (Class A Utilities: Account 186.2): None AMOUNT WRITTEN OFF DURING YEAR (b) YEAR END BALANCE (c) $ - $ - $ - $ - - $ Total Other Deferred Debits NONE REGUlATORY ASSETS (Class A Utilities: Account 186.3): None Total Regulatory Assets TOTAL MISCELlANEOUS DEFERRED DEBITS F-14 - $ NONE $ - $ - $ - $ - NONE NONE YEAR OF REPORT December 31, 2014 UTILITY NAME: Aquarina Utilities, Inc. CAPITAL STOCK ACCOUNTS 201 AND 204* DESCRIPTION (a) RATE (b) TOTAL (d) COMMON STOCK Par or stated value per share $ 1.00 $ - $ 1 1,000 1,000 1,000 Shares authorized Shares issued and outstanding Total par value of stock issued $ Dividends declared per share for year None PREFERRED STOCK Par or stated value per share $ None - $ - $ - Shares authorized Shares issued and outstanding Total par value of stock issued $ Dividends declared per share for year None None * Account 204 not applicable for Class B utilities BONDS ACCOUNT 221 DESCRIPTION OF OBLIGATION (INCLUDING DATE OF ISSUE AND DATE OF MATURITYJ (a) INTEREST ANNUAL FIXED OR RATE VARIABLE* (b) (c) % N/A PRINCIPAL AMOUNT PER BALANCE SHEET (d) $ - $ - % % % % % % % % % % % % Total * For variable rate obligations, provide the basis for the rate. (I.e .. Prime + 2%, etc) F-15 YEAR OF REPORT December 31, 2014 UTILITY NAME: Aquarina Utilities, Inc. STATEMENT OF RETAINED EARNINGS (Members Equity] 1. Dividends should be shown for each class and series of capital stock. Show amounts as dividends per share. 2 Show separately the state and federal income tax effect of items shown in Account No 439 ACCT. DESCRIPTION NO. AMOUNTS (b) (a) {c) Unappropriated Retained Earnings: 215 (661 ,254) Balance beginning of year (Deficit) $ Changes to account: Adjustments to Retained Earnings (requires Commission approval prior to use): 439 Credits: Total Credits Debits: - Total Debits 435 436 Balance transferred from Income Appropriations of Retained Earnings: 437 Total appropriations of Retained Earnings Dividends declared: Preferred stock dividends declared 438 (83,004) Common stock dividends declared Total Dividends Declared {744,258) Year end Balance 214 214 Appropriated Retained Earnings (state balance and purpose of each appropriated amount at year end): Total Appropriated Retained Earnings $ Total Retained Earnings (Deficit) Notes to Statement of Retained Earnings: F-16 ~744,258) YEAR OF REPORT December 31, 2014 UTILITY NAME: Aquarina Utilities, Inc. ADVANCES FROM ASSOCIATED COMPANIES ACCOUNT223 Repa rt each a dvance separately. DESCRIPTION (a) TOTAL (b) Aquarina Waterworks 56,486 346,841 Holly & Keven Burge 22,190 Reginald Burge $ Total 425,517 OTHER LONG TERM DEBT ACCOUNT224 DESCRIPTION OF OBLIGATION (INCLUDING DATE OF ISSUE AND DATE OF MATURITY) (a) INTEREST ANNUAL FIXED OR RATE VARIABLE* (b) (c) DEP State of Florida Revolving Fund $ % Issued 6-15-2000 and maturity 12-15-2019 3.12 % PRINCIPAL AMOUNT PER BALANCE SHEET (d) % Reginald Burge (Secure Note) 6.00 % Oculina Bank (Issued 2/2011 - Matures 2/2017) 338,125 Fixed % Ally Bank - GMC Sierra 0.90 % Issued 5/9/2013 and maturity 6/23/19 52,465 Fixed 44,566 Fixed % % % % % % % $ Total * For variable rate obligations, provide the basis for the rate. (I.e .. Prime+ 2%, etc) F-17 435,156 YEAR OF REPORT Decernber31,2014 UTILITY NAME: Aquarina Utilities, Inc. NOTES PAYABLE (ACCTS. 232 AND 234) DESCRIPTION OF OBLIGATION (INCLUDING DATE OF ISSUE AND DATE OF MATURITY) (a) NOTES PAYABLE (Account 232): N/A INTEREST ANNUAL FIXED OR RATE VARIABLE* (b) (c) PRINCIPAL AMOUNT PER BALANCE SHEET (d) % % % % % % Total Account 232 - $ NOTES PAYABLE TO ASSOC. COMPANIES (Account 234): "A "A "A N/A - $ Oft Oft Oft Total Account 234 * For variable rate obligations, provide the basis for the rate. (i.e .. Prime +2%, etc) ACCOUNTS PAYABLE TO ASSOCIATED COMPANIES ACCOUNT233 Report each account payable separately DESCRIPTION (a) N/A TOTAL (b) $ Total F-18 - YEAR OF REPORT December 31, 2014 UTILITY NAME: Aquarina Utilities, Inc. ACCRUED INTEREST AND EXPENSE ACCOUNTS 237 AND 427 INTEREST ACCRUED DURING YEAR BALANCE BEGINNING ACCT. OF YEAR DEBIT AMOUNT DESCRIPTION OF DEBT (b) (c) (d) (a) ACCOUNT NO. 237.1 -Accrued Interest on Long Term Debt Ally Bank $ Oculina Bank - 427.0 $ 449 $ 449 427.0 $ $ 22,950 $ $ 22,950 427.0 Other Interest - Total Account No. 237.1 INTEREST PAID DURING YEAR (e) - 23,399 BALANCE END OF YEAR (f) $ - - - 23,399 ACCOUNT NO. 237.2- Accrued Interest in Other Liabilities Kevin & Holly Burge - 427.0 $ 18,616 18,616 $ 1,452 1,452 20,068 20,068 - Total Account 237.2 Total Account 237 (1) 427.0 - Reginald Burge $ - INTEREST EXPENSED: Total accrual Account 237 Less Capitalized Interest Portion of AFUDC: None 237 Net Interest Expensed to Account No. 427 (2) $ 43,467 $ 43,467 $ 43,467 (1) Must Agree to F-2(a), Beginning and Ending Balance of Accrued Interest (2) Must agree to F-3(c), Current Year Interest Expense F-19 $ 23,399 $ 20,068 YEAR OF REPORT December 31, 2014 UTILITY NAME: Aquarina Utilities, Inc. MISCELLANEOUS CURRENT AND ACCRUED LIABILITIES ACCOUNT241 BALANCE END OF YEAR (b) DESCRIPTION (a) None Total Miscellaneous Current and Accrued Liabilities NAME OF PAYOR* (a) ADVANCES FOR CONSTRUCTION ACCOUNT252 BALANCE BEGINNING ACCT. DEBIT AMOUNT OF YEAR (d) (b) (c) $ None $ - $ - BALANCE END OF YEAR (f) CREDITS (e) - $ - $ - Total * $ - $ - $ - Report advances separately by reporting group, designating water or wastewater in column (a) F-20 $ - YEAR OF REPORT December 31, 2014 UTILITY NAME: Aquarina Utilities, Inc. OTHER DEFERRED CREDITS ACCOUNT253 AMOUNT DESCRIPTION - Provide itemized listing (a) WRITTEN OFF YEAREND DURING YEAR (b) BALANCE (c) REGULATORY LIABILITIES (Class A Utilities: Account 253.1) N/A Total Regulatory Liabilities $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - OTHER DEFERRED LIABILITIES (Class A Utilities: Account 253.2) N/A Total Deferred Liabilities TOTAL OTHER DEFERRED CREDITS F-21 YEAR OF REPORT December 31, 2014 UTILITY NAME: Aquarina Utilities, Inc. CONTRIBUTIONS IN AID OF CONSTRUCTION ACCOUNT 271 W&WWOTHER THAN SYSTEM REPORTING WATER SEWER (d) (b) (c) DESCRIPTION (a) Balance first of year $ 455,074 $ 591,310 28,938 Add credits during year: TOTAL (e) $ N/A 12,065 1,046,384 41,003 - Less debits charged during Total Contributions In Aid of Construction $ 484,012 $ 603,375 - $ $ 1,087,387 ACCUMULATED AMORTIZATION OF CONTRIBUTIONS IN AID OF CONSTRUCTIO!Io ACCOUNT 272 W&WWOTHER THAN SYSTEM WATER SEWER DESCRIPTION REPORTING TOTAL (a) (b) (c) (d) (e) Balance First of year ______ $ Debits during year: Rounding Credits during year (specify): Total Accumulated Amortization of Contributions In Aid of Construction $ 349,063 $ 338,762 13,992 1 15,591 (1) - - 363,056 $ 354,352 F-22 N/A $ 687,825 29,583 $ 717,408 YEAR OF REPORT December 31,2014 UTILITY NAME: Aquarina Utilities, Inc. RECONCILIATION OF REPORTED NET INCOME WITH TAXABLE INCOME FOR FEDERAL INCOME TAXES (UTILITY OPERATIONS) 1. The reconciliation should include the same detail as furnished on schedule M-1 of the federal income tax return for the year. The reconciliation shall be submitted even though there is no taxable income for the year. Descriptions should clearly indicate the nature of each reconciling amount and show the computation of all tax accruals. 2. If the utility is a member of a group which files a consolidated federal tax return, reconcile reported net income with taxable net income as if a separate return were to be filed, indicating intercompany amounts to be eliminated in such consolidated return. State names of group members, tax assigned to each group member, and basis of allocation, assignment, or sharing of the consolidated tax among group members. AMOUNT REFERENCE DESCRIPTION (c) (b) (a) F-3 (c) Net income for the year (loss) $ {83,004) Reconciling items for the year: Taxable income not reported on the books: Deductions recorded on books not deducted for return: - Income recorded on books not included in return: Deduction on return not charged against book income: $ Federal tax net income (loss) Computation of tax: The Utility is a partnership, therefore this schedule is not applicable F-23 {83,004) WATER OPERATION SECTION UTILITY NAME: Aguarina Utilities, Inc. WATER LISTING OF SYSTEM GROUPS List below the name of each reporting system and its certificate number. Those systems which have been consolidated under the same tariff should be assigned the a group number. Each individual system which as not been consolidated should be assigned its own group number. The water financial schedules (W-1 through W-1 0) should be filed for the group in total. The water engineering schedules (W-11 through W-14) must be filed for each system in the group. All of the following water pages (W-2 through W-14) should be completed for each group and arranged by group number. CERTIFICATE GROUP NUMBER NUMBER SYSTEM NAME I COUNTY Aquarina Utilities Inc. I Brevard 517-W W-1 YEAR OF REPORT December 31, 2014 UTILITY NAME: Aquarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. I Brevard SCHEDULE OF YEAR END WATER RATE BASE ACCT. NO. (a) Utility Plant In Service Less: Nonused and Useful Plant (1) W-4(b) 108.1 Accumulated Depreciation W-6{b} 110.1 271 Accumulated Amortization Contributions in Aid of Construction Advances for Construction 101 252 WATER UTILITY (d) REF. PAGE (c) ACCOUNT NAME (b) $ 2,026,403 {1 ,567,537) W-7 F-20 {484,012) Subtotal {25,146) Add: 272 Accumulated Amortization of Contributions in Aid of Construction W-8(a) 363,056 337,910 Subtotal 114 Plus or Minus: Acquisition Adjustments (2) F-7 115 Accumulated Amortization of Acquisition Adjustments (2) F-7 Working Capital Allowance (3) Other (Specify): Completed Construction not Classified 30,541 - WATER RATE BASE W-3 UTILITY OPERATING INCOME $ 368,451 $ ~45,050~ ~HIEVED RATE OF RETURN (Water Operating Income/Water Rate Base NOTES: (1) (2) (3) -- Class A calculate consistent with last rate proceeding. Class B estimated if not known. Include only those Acquisition Adjustments that have been approved by the Commission. Calculation consistent with last rate proceeding. In absence of a rate proceeding, Class A utilities will use the Balance Sheet Method and Class B Utilities will use the One-eighth Operating and Maintenance Expense Method. W-2 GROUP1 % UTILITY NAME: Aguarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. I Brevard YEAR OF REPORT December 31, 2014 WATER OPERATING STATEMENT ACCT. NO. (a) 400 ACCOUNT NAME (b) UTILITY OPERATING INCOME Operating Revenues 469 Less: Guaranteed Revenue and AFPI REF. PAGE (c) WATER UTILITY (d) W-9 269,405 W-9 Net Operating Revenues 269,405 401 Operating Expenses W-10(a) 244,327 403 Depreciation Expense W-6{a} W-8(a) (13,992) Less: Amortization of CIAC 44,740 Net Depreciation Expense 406 407 30,748 Amortization of Utility Plant Acquisition Adjustment Amortization Expense (Other than CIAC) 408.10 408.11 Taxes Other Than Income Utility Regulatory Assessment Fee Property Taxes 408.12 408.13 Payroll Taxes Other Taxes & Licenses 12,160 8,150 16,186 408 409.1 Total Taxes Other Than Income Income Taxes 410.10 410.11 Deferred Federal Income Taxes Deferred State Income Taxes 411.10 Provision for Deferred Income Taxes- Credit 412.10 Investment Tax Credits Deferred to Future Periods Investment Tax Credits Restored to Operating Income 412.11 469 413 414 420 F-7 F-8 36,496 2,884 Utility Operating Expenses 314,455 Utility Operating Income (Loss) {45,050) Add Back: Guaranteed Revenue (and AFPI) - W-9 Income From Utility Plant Leased to Others Gains (Losses) From Disposition of Utility Property Allowance for Funds Used During Construction Total Utility Operating Income (Loss) $ W-3 GROUP1 ~45,050) UTIUlY NAME: Aguarina Utilities, Inc. SYSTEM NAME / COUNlY: Aquarina Utilities, Inc. I Brevard YEAR OF REPORT December 31, 2014 WATER UTIUlY PLANT ACCOUNTS ACCT. NO. ACCOUNT NAME (a) 301 302 303 304 305 306 307 308 309 310 311 320 330 331 333 334 335 336 339 340 341 342 343 344 345 346 347 348 (b) Or anization Franchises Land and Land Rights Structure and Improvements Collectina and Imooundina Reservoirs Lake River and Other Intakes Wells and Sorinas Infiltration Galleries and Tunnels Supply Mains Power Generation Eauipment Pumpin!t Eauipment Water Treatment l;quipment Distribution Reservoirs and Standnes [ransmission and Distribution Mains Services Meters and Meter Installations Hydrants Backflow Prevention Devices Other Plant I Miscellaneous Eauipment Office Furniture and Equipment ransoortation Eauioment Stores Eauioment ools Shoo and Garaae Eauioment Laboratorv Eauioment Power Ooerated Eauioment Communication Eauioment Miscellaneous Eouioment Other Tangible Plant $ TOTAL WATER PLANT $ PREVIOUS YEAR ADDMONS (c) (d) _ffi 1050 $ 62 080 18 735 CURRENT YEAR (f) RETIREMENTS - $ 1050 62 080 19 392 657 231937 231 937 25,200 25,200 151 375 372 462 622 473 305 369 124 348 64 944 10 050 4408 1262 151 375 372462 624473 305 369 124 348 64944 10 050 4408 1262 - 30 053 30 053 2 025 746 NOTE: Any adjustments made to reclassify property from one account to another must be footnoted. W-4(a) GROUP1 $ 657 $ - $ 2 026 403 YEAR OF REPORT December 31, 2014 UTILITY NAME: Aguarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. I Brevard ACCT. NO. (a) 301 302 303 304 305 306 307 308 309 310 311 320 330 331 333 334 335 336 339 340 341 342 343 344 345 346 347 348 ACCOUNT NAME CURRENT YEAR (b) (c) I$ Oraanization Franchises Land and Land Rights Structure and Im_movements Collecting and Imoounding Reservoirs Lake River and Other Intakes Wells and Sorinas Infiltration Galleries and Tunnels Supply Mail Aquarina Utilities, Inc. I E Power Generation Eauioment Pumoina Eauioment Water Treatment Eauioment Distribution Reservoirs and Standoioes Transmission and Distribution Mains Services Meters and Meter Installations Hydrants Backflaw Prevention Devices Other Plant Miscellaneous Eauioment Office Furniture and Eauioment ransoortation Eauioment Stores Eauioment ools Shoo and Garaae Eauioment Laboratorv Eauioment Power Qllgr'ated f:!l!JjQ_ment Communication l:~uiQITlent Miscellaneous Eauipment Other Tangible Plant TOTAL WATER PLANT '$ WATER UTILITY PLANT MATRIX .1 .2 SOURCE OF SUPPLY INTANGIBLE AND PUMPING PLANT PLANT (d) 1050 ,$ 62080 19 392 .3 (e) WATER TREATMENT PLANT .4 TRANSMISSION AND DISTRIBUTION PLANT (f) (g) .5 GENERAL PLANT (h) 1050 _j_ 62 080 19 392 231937 231937 25,200 25,200 151 375 372 462 622 473 305 369 124 348 151 375 $ - $ - $ 372 462 622 473 305 369 124 348 64944 64944 10 050 4408 1262 10 050 4408 1 262 30 053 2 026 403 '$ - 30 053 1050 '$ W-4(b) GROUPl 489 984 $ 372.462 $ 1132.854 $ 30 053 YEAR OF REPORT December 31, 2014 UTILITY NAME: Aguarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc./ Brevard BASIS FOR WATER DEPRECIATION CHARGES ACCT. NO. (a) 301 302 304 305 306 307 308 309 310 311 320 330 331 333 334 335 336 339 340 341 342 343 344 345 346 347 348 ACCOUNT NAME (b) AVERAGE SERVICE LIFE IN YEARS (c) 40 Organization Franchises Structure and Improvements 33 Collecting and Impounding Reservoirs Lake, River and Other Intakes Wells and Springs AVERAGE NET SALVAGE IN PERCENT (d) % % % % Miscellaneous Equipment Other Tangible Plant % % % % % % % % % % % % % % % % % % % % % % % Water Plant Composite Depreciation Rate * % 30 Infiltration Galleries and Tunnels 32 17 20 22 37 43 40 20 45 15 25 15 6 Supply Mains Power Generation Equipment Pumping Equipment Water Treatment Equipment Distribution Reservoirs and Standpipes Transmission and Distribution Mains Services Meters and Meter Installations Hydrants Backflow Prevention Devices Other Plant I Miscellaneous Equipment Office Furniture and Equipment Transportation Equipment Stores Equipment Tools, Shop and Garage Equipment 15 Laboratory Equipment Power Operated Equipment Communication Equipment 12 * If depreciation rates prescribed by this Commission are on a total composite basis, entries should be made on this line only. W-5 GROUP 1 DEPRECIATION RATE APPLIED IN PERCENT (100%- d) I c (e) 2.50 % % 3.03 % % % 3.33 % % % % % % % % % % % % % % % % 6.67 % % 8.33 % % % % 3.13 5.88 5.00 4.55 2.70 2.33 2.50 5.00 2.22 6.67 4.00 6.67 16.67 % UTILITY NAME: Aguarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. I Brevard YEAR OF REPORT December 31, 2014 ANALYSIS OF ENTRIES IN WATER ACCUMULATED DEPRECIATION ACCT. NO. ACCOUNT NAME BALANCE AT BEGINNING OF YEAR (a) (b) (c) 301 302 304 305 306 307 308 309 310 311 320 330 331 333 334 335 336 339 340 341 342 343 344 345 346 347 348 Organization Franchises Structure and Improvements Collecting and ImPOunding Reservoirs Lake River and Other Intakes Wells and Springs Infiltration Galleries and Tunnels Suoolv Mains Power Generation Eauioment Pumoina Eouioment Water Treatment Eauioment Distribution Reservoirs and Standoioes ransmission and Distribution Services Meters and Meter Installations Hydrants Backflow Prevention Devices Other Plant 1 Miscellaneous Eauioment OffiCe Furniture and Eouipment ransoortation Eauioment Stores Eauioment ools Shoo and Garaae Eouioment Laboratorv Eouioment Power Ooerated Eauioment Communication Eauioment Miscellaneous Eg_ujpment Other Tangible Plant ifOTAL WATER ACCUMULATED DEPRECIATION ACCRUALS (d) 1050 $_ $ 577 - 577 - 231937 16 776 789 789 74 463 372 462 558 081 132 521 81993 27 327 4426 147 1 261 7 569 7 569 16 807 7115 3108 3 247 223 294 16 807 7115 3108 3 247 223 294 5 010 5 010 - - 2 505 0 ~ _{f) - $ 17 849 TOTAL CREDITS (d +e) OTHER CREDITS* (e) (1) 1,522?98 Specify nature of transaction. Use ( ) to denote reversal entries. Note (1): Reclass entry W-6(a} GROUP 1 1 1 ~ 44,739 $ 1 ! 44,740 YEAR OF REPORT UTILITY NAME: Aguarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. I Brevard December 31, 2014 ANALYSIS OF ENTRIES IN WATER ACCUMULATED DEPRECIATION (CONT'D) ACCT. NO. (a) 301 302 304 305 306 307 308 309 310 311 320 330 331 333 334 335 336 339 340 341 342 343 344 345 346 347 348 PLANT RETIRED ACCOUNT NAME (b) O_rg_anization Franchises Structure and Improvements Collecting and Imoounding Reservoirs Lake River and Other Intakes Wells and Springs Infiltration Galleries and Tunnels SUPPiv Mains Power Generation EQuipment Pumoina EQuioment Water Treatment Eouioment Distribution Reservoirs and Standoioes ransmission and Distribution Services Meters and Meter Installations Hydrants Backflow Prevention Devices Other Plant I Miscellaneous_EQuipment OffiCe Furniture and EQuipment ranSPOrtation EQuipment Stores EQuipment ools Shoo and Garaae Eouioment Laboratorv EQuioment Power O!lerated EQuioment Communication EQuioment Miscellaneous Eouioment Other Tangible Plant !rOTAL WATER ACCUMULATED DEPREClATION (g) $ COST OF REMOVAL AND OTHER CHARGES SALVAGE AND INSURANCE (h) - $ (j) (i) - $ BALANCE AT END OF YEAR (c+f-k) (k) TOTAL CHARGES (g-h+i+j) - $ - $ 1050 18 426 231937 17 565 82 032 372 462 574 888 139 636 85 101 30 574 4649 441 1261 7 515 $ - $ W-6(b) GROUP1 - $ - $ - ~ 1,567,537 UTILITY NAME: Aquarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. I Brevard YEAR OF REPORT December 31, 2014 CONTRIBUTIONS IN AID OF CONSTRUCTION ACCOUNT 271 DESCRIPTION (a) WATER (c) REFERENCE (b) $ Balance First of Year Add credits during year: Contributions Received From Capacity, Capacity, Main Extension and Customer Connection Charges Contributions received from Developer or Contractor Agreements in cash or property W-8(a) 455,074 28,938 W-8(b) 28,938 Total Credits Less debits charged during the year (All debits charged during the year must be explained below) $ Total Contributions In Aid of Construction 484,012 If any prepaid CIAC has been collected, provide a supporting schedule showing how the amount is determined. Explain all Debits charged to Account 271 during the year below: W-7 GROUP1 UTILITY NAME: Aguarina Utilities, Inc. Aquarina Utilities, Inc. I Brevard SYSTEM NAME I COUNTY: YEAR OF REPORT December 31, 2014 WATER CIAC SCHEDULE "A" ADDITIONS TO CONTRIBUTIONS IN AID OF CONSTRUCTION RECEIVED FROM CAPACITY, MAIN EXTENSION AND CUSTOMER CONNECTION CHARGES RECEIVED DURING THE YEAR NUMBER OF CHARGE PER DESCRIPTION OF CHARGE CONNECTIONS CONNECTION AMOUNT (a) (b) (c) (d) Main Line Extensions Main Line Extensions 9 10 Main Line Extensions 18 1 50 43 900 43 19 780 14,820 300 2,250 675 Connection Fees Capacity Fees $ 550 500 Connection Fees 20 15 Connection Fees Connection Fees 10 27 225 25 Total Credits $ 5,000 $ ACCUMULATED AMORTIZATION OF CONTRIBUTIONS IN AID OF CONSTRUCTION ACCOUNT272 DESCRIPTION WATER (a) (b) Balance first of year $ Debits during year: Accruals charged to Account 349,063 13,992 Other Debits (specify): Rounding 1 Total debits 13,993 Credits during year (specify): - Total credits $ Balance end of year W-S(a) GROUP 1 363,056 4,950 28,938 UTILITY NAME: Aquarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. I Brevard YEAR OF REPORT December 31, 2014 WATER CIAC SCHEDULE "B" ADDITIONS TO CONTRIBUTION IN AID OF CONSTRUCTION RECEIVED FROM ALL DEVELOPERS OR CONTRACTORS AGREEMENTS FROM WHICH CASH OR PROPERTY WAS RECEIVED DURING THE YEAR INDICATE "CASH" OR "PROPERTY" DESCRIPTION WATER (a) (b) (c) N/A Total Credits N/A W-8(b) GROUP1 YEAR OF REPORT December 31, 2014 UTILITY NAME: Aguarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. I Brevard WATER OPERATING REVENUE ACCT. NO. (a) 460 BEGINNING YEAR NO. CUSTOMERS* (c) DESCRIPTION (b) Metered Water Revenue: Metered Sales to Residential Customers Metered Sales to Commercial Customers 461.3 Metered Sales to Industrial Customers 461.4 461.5 Metered Sales to Public Authorities Metered Sales to Multiple Family_ Dwellings 254 6 265 11 $ 107,731 3,468 - Total Metered Sales 462.2 AMOUNTS (e) Water Sales: Unmetered Water Revenue 461.1 461.2 462.1 YEAREND NUMBER CUSTOMERS (d) 6 6 38,097 266 282 149,296 98 111 97,530 364 393 246,826 Fire Protection Revenue: Public Fire Protection Private Fire Protection Total Fire Protection Revenue 464 Other Sales to Public Authorities 465 466 467 Sales to Irrigation Customers Sales for Resale Interdepartmental Sales Total Water Sales 469 470 471 Other Water Revenues: Guaranteed Revenues 472 473 Forfeited Discounts Miscellaneous Service Revenues Rents From Water Property Interdepartmental Rents 474 Other Water Revenues 22,579 Total Other Water Revenues $ 22,579 Total Water Operating Revenues $ 269,405 * Customer is defined by Rule 25-30.210(1), Florida Administrative Code W-9 GROUP 1 YEAR OF REPORT December 31,2014 UTILITY NAME: Aguarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. I Brevard WATER UTILITY EXPENSE ACCOUNTS ACCT. NO. (a) CURRENT YEAR ACCOUNT NAME (b) 601 Salaries and Wages - Employees 603 Salaries and Wages - Officers, Directors and Majority Stockholders 604 Employee Pensions and Benefits 610 Purchased Water 615 Purchased Power 616 Fuel for Power Production 618 Chemicals 620 Materials and Supplies 631 Contractual Services - Engineering 632 Contractual Services - Accounting 633 Contractual Services - Legal 634 Contractual Services - Mgt. Fees 635 Contractual Services- Testing 636 Contractual Services - Other 641 Rental of Building/Real Property (c) $ 122,846 35,330 824 1,612 1,612 11,297 2,824 669 335 9,278 1,325 12,648 656 657 Insurance- Vehicle Advertising Expense Regulatory Commission Expenses Amortization of Rate Case Expense 667 Regulatory Commission Exp.-Other 670 Bad Debt Expense 675 Miscellaneous Expenses Total Water Utility Expenses 2,824 1,325 3,456 5,248 Insurance - General Liability 666 15,356 666 15,700 660 $ 3,860 Rental of Equipment 659 .2 SOURCE OF SUPPLY AND EXPENSESMAINTENANCE (e) 7,614 Transportation Expense Insurance - Workmens Comp. 15,356 824 650 Insurance - Other $ 35,330 642 658 .1 SOURCE OF SUPPLY AND EXPENSESOPERATIONS (d) 4,754 8,525 $ W-10(a) GROUP1 244,327 $ 59,737 $ 19,505 YEAR OF REPORT December 31, 2014 UTILITY NAME: Aguarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. I Brevard WATER EXPENSE ACCOUNT MATRIX .5 .3 .4 WATER TREATMENT EXPENSESOPERATIONS (f) WATER TREATMENT EXPENSESMAINTENANCE (g) $ 15,356 $ 15,356 .6 TRANSMISSION TRANSMISSION & DISTRIBUTION & DISTRIBUTION EXPENSESEXPENSESOPERATIONS MAINTENANCE (h) (i) $ 15,356 $ 15,356 $ .7 .8 CUSTOMER ACCOUNTS EXPENSE ij) ADMIN.& GENERAL EXPENSES (k) 15,356 . .:.,15::. .,.;:;.;35;.;:,6 .;::,$_ _ _ 2,824 2,824 7,614 3,860 335 1,325 2,651 1,325 1,325 666 15,700 12,648 3,456 5,248 $ 21,971 $ 16,681 $ 38,662 $ W-10(b) GROUP1 16,681 $ 15,356 ~$_ _ _..;;.55;;.:.•.;..;73;;.;;.3 YEAR OF REPORT December 31, 2014 UTILITY NAME: Aguarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. I Brevard PUMPING AND PURCHASED WATER STATISTICS MONTH (a) WATER PURCHASED FOR RESALE (Omit OOO's) (b) FINISHED WATER PUMPED FROM WELLS (Omit OOO's) (c) TOTAL WATER PUMPED AND PURCHASED (Omit OOO's) [(b)+(c)-(d)] (e) WATER USED FOR LINE FLUSHING, FIGHTING FIRES, ETC. (d) March April 10,163 9,728 - May 14,445 June 9,346 January February 7,754 WATER SOLD TO CUSTOMERS (Omit OOO's) (f) 9,346 9,438 7,682 7,754 9,728 10,084 9,768 - 14,445 14,524 12,811 - 12,811 12,824 July August 10,736 11,118 - 10,736 10,834 September October November 11,687 8,628 16,319 December 9,503 Total for year N/A 132,238 10,163 - 11,118 11,238 11,687 11,656 8,628 8,568 16,474 16,319 9,503 N/A 132,238 9,371 132,461 {1) irrigation flow meter was not accurate and a replacement has been purchased. If water is purchased for resale, indicate the following: Vendor N/A Point of delivery_ If Water is sold to other water utilities for redistribution, list names of such utilities below: N/A List for each source of supply: Potable Well #1 Potable Well #2 (Irrigation only) CAPACITY OF WELL GALLONS PER DAY FROM SOURCE TYPE OF SOURCE 1.0 mgd 1.0 mgd .38 mgd .. 032 mgd Aguifer Aquifer W-11 GROUP 1 SYSTEM Aquarina Utilities, Inc. YEAR OF REPORT December 31, 2014 UTILITY NAME: Aquarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. I Brevard WATER TREATMENT PLANT INFORMATION Provide a separate sheet for each water treatment facility .21 mgd Permitted Capacity of Plant (GPO): Location of measurement of capacity (i.e. Wellhead, Storage Tank): Distribution Point Type of treatment (reverse osmosis, sedimentation, chemical, aerated, etc): Reverse Osmosis & Disinfection LIME TREATMENT Unit rating (i.e., GPM, pounds per gallon): N/A Manufacturer N/A FILTRATION Type and size of area: Pressure (in square feet): Gravity (in GPM/square feet): (R/0) 5 mm prefilters (polypropyline) & filmtec or hydranautic membranes Manufacturer 7,920 lb/ft2 - Manufacturer W-12 GROUP 1 SYSTEM Aquarina Utilities, Inc. Siemens - YEAR OF REPORT December 31, 2014 UTILITY NAME: Aquarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. I Brevard CALCULATION OF THE WATER SYSTEMS EQUIVALENT RESIDENTIAL UNITS EQUIVALENT FACTOR (c) TYPE OF METER (b) METER SIZE (a) All Residential 518" 1.0 265 265 96 96 Dis~lacement 1.0 314" Dis~lacement 1.5 1" Dis~lacement 2.5 1 112" Dis~lacement 2" Dis~lacement, Com~ound 3" 3" 3" Dis~lacement or Turbine or Turbine Com~ound or Com~ound Turbine 4" 4" 6" 27 216 2 35 2 60 1 90 Dis~lacement Dis~lacement 50.0 8" Com~ound 8" 10" 10" Turbine 30.0 62.5 80.0 90.0 Com~ound Turbine Turbine 12" - 8.0 15.0 25.0 or Com~ound Turbine 6" 5.0 16.0 17.5 Turbine TOTAL NUMBER OF METER EQUIVALENTS (c x d) (e) NUMBER OF METERS (d) 115.0 145.0 215.0 Total Water System Meter Equivalents 762 CALCULATION OF THE WATER SYSTEM EQUIVALENT RESIDENTIAL CONNECTIONS Provide a calculation used to determine the value of one water equivalent residential connection (ERC). Use one of the following methods: (a) If actual flow data are available from the preceding 12 months, divide the total annual single family residence (SFR) gallons sold by the average number of single family residence customers for the same period and divide the result by 365 days. (b) If no historical flow data are available, use: ERC = ( Total SFR gallons sold (Omit 000) 1365 days I 350 gallons per day ) ERC Calculation: ERC 132,461 gallons, divided by 350 gallons per day _ ___,3=6=5 days = 1,036.9 ERC's W-13 GROUP1 SYSTEM Aquarina Utilities, Inc. YEAR OF REPORT December 31, 2014 UTILITY NAME: Aquarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. I Brevard OTHER WATER SYSTEM INFORMATION Furnish information below for each system. A separate page should be supplied where necessary. 1. Present ERC's * that system can efficiently serve. 762 2. Maximum number of ERC's *which can be served. 600 3. Present system connection capacity (in ERC's *) using existing lines. 264 4. Future system connection capacity (in ERC's *) upon service area buildout. 550 5. Estimated annual increase in ERC's * . 1 6. Is the utility required to have fire flow capacity? If so, how much capacity is required? 7. Attach a description of the fire fighting facilities. No N/A Designated pump and capacity, 38 hydrants 8. Describe any plans and estimated completion dates for any enlargements or improvements of this system. N/A 9. When did the company last file a capacity analysis report with the DEP? Unknown 10. If the present system does not meet the requirements of DEP rules: a. Attach a description of the plant upgrade necessary to meet the DEP rules. b. Have these plans been approved by DEP? c. When will construction be N/A N/A N/A d. Attach plans for funding the required upgrading. e. Is this system under any Consent Order of the DEP? 11. Department of Environmental Protection ID # No 3054060 12. Water Management District Consumptive Use Permit# 1719 a. Is the system in compliance with the requirements of the CUP? Yes b. If not, what are the utility's plans to gain compliance? N/A * An ERC is determined based on the calculation on the bottom of Page W-13 W-14 GROUP 1 SYSTEM Aquarina Utilities, Inc. WASTEWATER OPERATION SECTION UTILITY NAME: Aguarina Utilities, Inc. WASTEWATER LISTING OF SYSTEM GROUPS List below the name of each reporting system and its certificate number. Those systems which have been consolidated under the same tariff should be assigned the a group number. Each individual system which as not been consolidated should be assigned its own group number. The wastewater financial schedules (S-1 through S-10) should be filed for the group in total. The wastewater engineering schedules (S-11 through S-14) must be filed for each system in the group. All of the following wastewater pages (S-2 through S-12) should be completed for each group and arranged by group number. GROUP CERTIFICATE NUMBER NUMBER SYSTEM NAME I COUNTY Aquarina Utilities Inc I Brevard 450-S S-1 YEAR OF REPORT December 31, 2014 UTILITY NAME: Aquarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. / Brevard SCHEDULE OF YEAR END WASTEWATER RATE BASE ACCT. NO. (a) 101 S-4(a) Utility Plant In Service Less: 108.1 Non used and Useful Plant (1) Accumulated Depreciation 110.1 Accumulated Amortization WASTEWATER UTILITY (d) REF. PAGE (c) ACCOUNT NAME (b) {1 ,890,983) S-6{b1 271 Contributions in Aid of Construction S-7 252 Advances for Construction F-20 2,181,347 $ {603,375) Subtotal 272 {313,011) Add: Accumulated Amortization of Contributions in Aid of Construction S-8(a) 354,352 Subtotal 41,341 Plus or Minus: 114 115 Acquisition Adjustments (2) Accumulated Amortization of Acquisition Adjustments (2) Working Capital Allowance (3) Other (Specify): Completed Construction not Classified F-7 F-7 15,795 - WASTEWATER RATE BASE UTILITY OPERATING INCOME S-3 $ 57,136 $ 5,320 ACHIEVED RATE OF RETURN (Wastewater Operating Income/Wastewater Rate Base) NOTES: (1) Class A calculate consistent with last rate proceeding. Class B estimated if not known. (2) Include only those Acquisition Adjustments that have been approved by the Commission. (3) Calculation consistent with last rate proceeding. In absence of a rate proceeding, Class A utilities will use the Balance Sheet Method and Class B Utilities will use the One-eighth Operating and Maintenance Expense Method. S-2 GROUP 1 9.31 % UTILITY NAME: Aguarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. I YEAR OF REPORT December 31, 2014 Brevard WASTEWATER OPERATING STATEMENl ACCT. NO. (a) 400 530 ACCOUNT NAME (b) UTILITY OPERATING INCOME Operating Revenues Less: Guaranteed Revenue and AFPI WASTEWATER UTILITY (d) REF. PAGE (c) S-9 $ 161,736 S-9 161,736 Net Operating Revenues S-10(a) 126,359 401 Operating Expenses 403 Depreciation Expense S-6{a~ 24,799 Less: Amortization of CIAC S-8(a) (15,591) 9,208 Net Depreciation Expense 406 407 Amortization of Utility Plant Acquisition Adjustment Amortization Expense (Other than CIAC) (Loss on olant abandonment) F-7 F-8 408.10 Taxes Other Than Income Utility Regulatory Assessment Fee 7,239 408.11 Property Taxes 4,075 408.12 Payroll Taxes 8,093 408.13 Other Taxes & Licenses 408 409.1 Total Taxes Other Than Income Income Taxes 410.10 410.11 Deferred Federal Income Taxes 19,407 1,442 Deferred State Income Taxes 411.10 412.10 Provision for Deferred Income Taxes- Credit 412.11 Investment Tax Credits Restored to Operating Income Investment Tax Credits Deferred to Future Periods Utility Operating Expenses 156,416 Utility Operating Income 530 413 414 420 5,320 Add Back: Guaranteed Revenue (and AFPI) Income From Utility Plant Leased to Others Gains (Losses) From Disposition of Utility Property Allowance for Funds Used During Construction $ Total Utility Operating Income S-3 GROUP1 5,320 YEAR OF REPORT UTILITY NAME: Aguarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. / Brevard December 31, 2014 WASTEWATER UTILITY PLANT ACCOUNTS ACCT. NO. Cal 351 352 353 354 355 360 361 362 363 364 365 366 367 370 371 374 375 380 381 382 389 390 391 392 393 394 395 396 397 398 PREVIOUS YEAR (c) ACCOUNT NAME (b) Oroanization Franchises Land and Land RiQhts Structure and Iml>fl)Vements Power Generation Eauiornent Collection Sewers - Force Collection Sewers - Gravitv ISoecial Callectina Structures Services to Customers Flow Measurina Devices Flow Measuring Installations Reuse Services Reuse Meters and Meter Installations Receivimt Wells Pumoina Eouioment Reuse Distribution Reservoirs Reuse Transmission and Distribution Svstem Treatment & DisPQSal Equipment Plant Sewers Outfall Sewer Unes Other Plant Miscellaneous Equipment Office Furniture & Eauioment TransPDI'tation Equipment Stores Eouioment Tools Shoo and Garaae Eauioment Laboratory Equipment Power Qllerated E uipment Communication Eauioment Miscellaneous EquiPment Other Tangible Plant Total Wastewater Plant $ CURRENT ADDmONS (d) 1050 $ y~~R RETIREMENTS (e) - $ - $ 1050 33 680 21228 33 680 21228 161 358 328 394 161358 328 394 170 960 0 0 170 960 50 256 50 256 1224 902 1224 902 144 908 909 10 200 30 053 144 908 909 10 200 30 053 3 449 ~ 2,181,347 NOTE. Any adjustments made to reclassify property from one ao:ount to another must be footnoted. 5-4(a} GROUPl 3 449 $ - $ - ~ 2,181,347 YEAR OF REPORT IITILITY NAME: Aguarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. / Brevard December 31, 2014 WASTEWATER UTILITY PLANT MATRIX .2 .1 ACCT. NO. Cal 351 352 353 354 355 360 361 362 363 364 365 366 367 370 371 374 375 380 381 382 389 390 391 392 393 394 395 396 397 398 .4 .5 .6 RECLAIMED WASTEWATER TREATMENT RECLAIMED WASTEWATER DISTRIBIITION p'c:~T p~r INTANGIBLE COLLECTION SYSTEM PUMPING TREATMENT AND DISPOSAL p~~T p~~T {h P~~T p~~T ACCOUNT NAME (bl $ Oraanization Franchises Land and Land Riahts Structure and Imorovements Power Generation EQuipment Collection Sewers - Force Collection Sewers - Gravity lsoecial Collectin Structures Services to Customers Flow Measuring Devices Flow Measurina Installations Reuse Services Reuse Meters and Meter Installations Receivina Wells PumPina EQuipment Reuse Distribution Reservoirs Reuse Transmission and Distribution Svstem Treatment & Disoosal Eauioment Plant Sewers Outfall Sewer Unes Other Plant Miscellaneous Eauiom OffiCe Furniture & Eauipment Transoortation E uioment Stores Eauipment ools !i_hop and Garage Eauipment L.aboratorv Eauioment Power Operated Eauipment Communication Eauipment Miscellaneous Eauioment Other Tangible Plant 1050 ~ 1,050 Total Wastewater Plant .3 Is - $ - $ 33 680 21228 Is .7 GENERAL PLANT Cml is - $ - 161358 328 394 170 960 50 256 1 224 902 144 908 909 10 200 30 053 3 449 ~ 660,712 ~ 50,256 NOTE. Arr( adJustments made to reclasstfy property from one account to another must be footnoted. 5-4( b) GROUP1 ~ 1,425,627 $ - Is - ~ 43,702 UTILITY NAME: Aguarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. I YEAR OF REPORT December 31, 2014 Brevard BASIS FOR WASTEWATER DEPRECIATION CHARGES ACCT. NO. (a) 351 352 354 355 360 361 362 363 364 365 366 367 370 371 374 375 380 381 382 389 390 391 392 393 394 395 396 397 398 ACCOUNT NAME (b) AVERAGE SERVICE LIFE IN YEARS (c) 40 Organization Franchises Structure and Improvements 32 20 30 45 30 38 5 Power Generation Equipment Collection Sewers - Force Collection Sewers - Gravity Special Collecting Structures Services to Customers Flow Measuring Devices Flow Measuring Installations AVERAGE NET SALVAGE IN PERCENT (d) % o/o % % o/o % % % % DEPRECIATION RATE APPLIED IN PERCENT (100%- d) I c (e) 2.50 % 3.13 5.00 3.33 2.22 3.33 2.63 20.00 % % Reuse Services Reuse Meters and Meter Installations Receiving Wells Pumping Equipment 25 18 Reuse Distribution Reservoirs Reuse Transmission and Distribution System 18 Treatment & Disposal Equipment Plant Sewers 18 18 15 6 Outfall Sewer Lines Other Plant I Miscellaneous Equipment Office Furniture & Equipment Transportation Equipment Stores Equipment Tools, Shop and Garage Equipment 15 15 12 Laboratory Equipment Power Operated Equipment Communication Equipment Miscellaneous Equipment Other Tangible Plant 15 Wastewater Plant Composite Depreciation Rate * % o/o % 4.00 % 5.56 % % % % % % 5.56 % % % % % % % 5.56 5.56 6.67 16.67 % % % % % % % % 6.67 % 6.67 % 8.33 % % o/o % % 6.67 % % * If depreciation rates prescribed by this Commission are on a total composite basis, entries S-5 GROUP 1 % % % should be made on this line only. o/o % % % % % % % o/o % % YEAR OF REPORT UTILITY NAME: AgUarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. / Brevard December 31, 2014 ANALYSIS OF ENTRIES IN SEWER ACCUMULATED DEPRECIATION ACCT. NO. (a) 351 352 354 355 360 361 362 363 364 365 366 367 370 371 374 375 380 381 382 389 390 391 392 393 394 395 396 397 398 ACCOUNT NAME (b) Organization Franchises Structure and Improvements Power Generation Equipment Collection Sewers- Force Collection Sewers - Gravity Special Collecting Structures Services to Customers Flow Measuring Devices Flow Measurina Installations Reuse Services Reuse Meters and Meter Installations Receiving Wells Pumping Equipment Reuse Distribution Reservoirs Reuse Transmission and Distribution System reatment & DISOOSal EOulDinent Plant Sewers Outfall Sewer Lines Other Plant I Miscellaneaus EaulDment Office Furniture & EQuipment Transpartation Equipment Stores Eauipment Tools, Shop and Garage Eauipment Laboratorv Eauioment Power Operated Eauipment Communication Equipment Miscellaneous Eauipment Other Tangible Plant !Total Depreciable Wastewater Plant in Service . BALANCE AT BEGINNING OF YEAR ACCRUALS (d) (c) $ 1,050 $ TOTAL CREDITS (d +e) OTHER CREDITS * (1) (e) - $ (f) - $ 21,146 82 82 156,911 148,348 4,447 7,291 4,447 7,291 119,137 4,497 4,497 38,576 2 794 2,794 1,224,902 - 144,908 909 4,340 2,505 681 5,010 681 5,010 {3 SpeCify nature of transaction. Use ( ) to denote reversal entries. Note: (1) Rounding S-6(a) GROUPl 118661181 (3 - 3,449 ~ - ~ 241802 ~ (3) ! 241799 UTILITY NAM Aquarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina utilities, Inc. / Brevard YEAR OF REPORT December 31, 2014 ANALYSIS OF ENTRIES IN SEWER ACCUMULATED DEPRECIATION (CONT'D) COST OF SALVAGE REMOVAL PLANT AND AND OTHER ACCOUNT NAME RmRED INSURANCE CHARGES (b) (g) (h) (i) ACCT. NO. (a) 351 Oroanization 352 Franchises 354 Structure and Improvements 355 Power Generation Equipment 360 Collection Sewers - Force 361 Collection Sewers - Gravity 362 Special Collecting Structures 363 Services to Customers 364 Flow Measuri11g Devices 365 Flow Measuring Installations 366 Reuse Services 367 Reuse Meters and Meter Installations 370 Receiving Wells 371 Pumping Equipment 374 Reuse Distribution Reservoirs 375 Reuse Transmission and Distribution System 380 [reatment & DisllQ_sal E~ipment 381 Plant Sewers 382 Outfall Sewer Lines 389 Other Plant I Miscellaneous Equipment 390 Office Furniture & Equipment 391 [fransp<>_rtation Equij:>ment 392 Stores Equipment 393 rTools, Shop and Garage Equipment 394 Laboratory Equipment 395 Power Operated Equipment 396 Communication Equipment 397 Miscellaneous Equij)_ment 398 Other Tangible Plant Total Depreciable Wastewater Plant in Service $ - $ - $ BALANCE AT END OF YEAR TOTAL CHARGES (g-h+i) (C+f-k) (k) (j) - $ - $ 1,050 21,228 161,358 155,639 123,634 41,370 1,224,902 144,908 909 5,021 7,515 3,449 $ - $ S-6(b) GROUP1 - $ - $ - ~ 1,890,983 UTILITY NAME: Aquarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. / Brevard YEAR OF REPORT December 31, 2014 CONTRIBUTIONS IN AID OF CONSTRUCTION ACCOUNT 271 DESCRIPTION (a) REFERENCE (b) Balance First of Year WASTEWATER (b) $ Add credits during year: Contributions Received From Capacity, Capacity, Main Extension and Customer Connection Charges Contributions received from Developer or Contractor Agreements in cash or property S-8(a) 591,310 12,065 S-8{b) Total Credits 12,065 Less debits charged during the year (All debits charged during the year must be explained below) Total Contributions In Aid of Construction $ 603,375 If any prepaid CIAC has been collected, provide a supporting schedule showing how the amount is determined. Explain all Debits charged to Account 271 during the year below: S-7 GROUP1 UTILITY NAME: Aquarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. / Brevard YEAR OF REPORT December 31, 2014 WASTEWATER CIAC SCHEDULE "A" ADDITIONS TO CONTRIBUTIONS IN AID OF CONSTRUCTION RECEIVED FROM CAPACITY, MAIN EXTENSION AND CUSTOMER CONNECTION CHARGES RECEIVED DURING THE YEAR CHARGE PER NUMBER OF DESCRIPTION OF CHARGE CONNECTIONS AMOUNT CONNECTION (a) (b) (c) (d) Main Line Extensions 19 $ 635 $ 12,065 - Total Credits $ ACCUMULATED AMORTIZATION OF CONTRIBUTIONS IN AID OF CONSTRUCTIOI\ ACCOUNT272 DESCRIPTION WASTEWATER (b) (a) $ Balance first of year 338,762 Debits during year: Accruals charged to Account 15,591 Other Debits (specify): Total debits 15,591 Credits during year (specify): Rounding 1 Total credits 1 $ Balance end of year S-8(a) GROUP 1 354,352 12,065 UTILITY NAME: Aquarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. / Brevard YEAR OF REPORT December 31,2014 WASTEWATER CIAC SCHEDULE "B" ADDITIONS TO CONTRIBUTION IN AID OF CONSTRUCTION RECEIVED FROM ALL DEVELOPERS OR CONTRACTORS AGREEMENTS FROM WHICH CASH OR PROPERTY WAS RECEIVED DURING THE YEA!' INDICATE "CASH" OR DESCRIPTION "PROPERTY" WASTEWATER (a) (b) (c) None Total Credits S-8(b) GROUP1 $ - $ - UTILITY NAME: Aquarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. / Brevard YEAR OF REPORT December 31,2014 WASTEWATER OPERATING REVENUE ACCT. NO. (a) DESCRIPTION (b) BEGINNING YEAR NO. CUSTOMERS* (c) YEAREND NUMBER CUSTOMERS (d) 20 11 20 11 254 6 254 8 AMOUNTS (e) WASTEWATER SALES Flat Rate Revenues: 521.1 521.2 521.3 521.4 521.5 521.6 521 Residential Revenues $ 8,959 Commercial Revenues Industrial Revenues Revenues From Public Authorities Multiple Family Dwelling Revenues Other Revenues Total Flat Rate Revenues 8,959 Measured Revenues: 522.1 522.2 522.3 Residential Revenues Commercial Revenues 522.4 522.5 Revenues From Public Authorities - Multiple Family Dwelling Revenues (Units) 6 522 Total Measured Revenues 523 524 Revenues From Public Authorities 525 Interdepartmental Revenues Industrial Revenues $ 34,930 6 286 279 286 279 100,893 2,506 138,329 Revenues From Other Systems Total Wastewater Sales $ 147,288 $ - OTHER WASTEWATER REVENUES 530 531 532 534 535 536 Guaranteed Revenues Sale Of Sludge Forfeited Discounts Rents From Wastewater Property Interdepartmental Rents Other Wastewater Revenues 14,448 (Including Allowance for Funds Prudently Invested or AFPI) Total Other Wastewater Revenues . . * Customer IS defined by Rule 25-30.210(1), Flonda Adm1mstrat1ve Code . S-9(a) GROUP1 $ 14,448 UTILITY NAME: Aguarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. / Brevard YEAR OF REPORT December 31, 2014 WASTEWATER OPERATING REVENUE ACCT. NO. (a) BEGINNING YEAR NO. CUSTOMERS* (c) DESCRIPTION (b) YEAREND NUMBER CUSTOMERS (d) AMOUNTS (e) RECLAIMED WATER SALES 540.1 540.2 540.3 540.4 540.5 540 Flat Rate Reuse Revenues: Residential Reuse Revenues $ - $ 161,736 Commercial Reuse Revenues Industrial Reuse Revenues Reuse Revenues From Public Authorities Other Reuse Revenues Total Flat Rate Reuse Revenues Measured Reuse Revenues: 541.1 541.2 541.3 541.4 541 544 Residential Reuse Revenues Commercial Reuse Revenues Industrial Reuse Revenues Reuse Revenues From Public Authorities Total Measured Reuse Revenues Reuse Revenues From Other Systems Total Reclaimed Water Sales ' Total Wastewater Operating Revenues . . * Customer IS defined by Rule 25-30.210(1), Flonda Adm1n1strat1ve Code . S-9(b) GROUP1 UTILITY NAME: Aquarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. / Brevard WASTEWATER UTILITY EXPENSE ACCOUNTS ACCT. NO. (a) 701 703 704 710 711 715 716 718 720 731 732 733 734 735 736 741 742 750 756 757 758 759 760 766 767 770 775 ACCOUNT NAME (b) Salaries and Wages - Employees Salaries and Wages - Officers, Directors and Majority Stockholders Employee Pensions and Benefits Purchased Sewage Treatment Sludge Removal Expense Purchased Power Fuel for Power Production Chemicals Materials and Supplies Contractual Services - Engineering Contractual Services -Accounting Contractual Services - Legal Contractual Services - Mgt. Fees Contractual Services - Testing Contractual Services - Other Rental of Building/Real Property Rental of Equipment Transportation Expense Insurance - Vehicle Insurance - General Liability Insurance - Wor!(mens Comp. Insurance - Other Advertising Expense Regulatory Commission Expenses Amortization of Rate Case Expense Regulatory Commission Exp.-Other Bad Debt Expense Miscellaneous Expenses Total Wastewater Utility Expenses CURRENT YEAR (c) $ 61,423 .1 .2 .3 .4 .5 .6 COLLECTION EXPENSESOPERATIONS (d) SOURCE OF SUPPLY AND EXPENSESMAINTENANCE (e) PUMPING EXPENSESOPERATIONS (f) PUMPING EXPENSESMAINTENANCE (g) TREATMENT& DISPOSAL EXPENSESOPERATIONS (h) TREATMENT& DISPOSAL EXPENSESMAINTENANCE (i) $ 17,665 412 1,289 6,023 6,142 $ 6,142 $ 6,142 $ 6,142 $ 6,142 1,004 1,004 1,004 1,004 17,665 412 1,289 1,004 392 196 392 196 3,107 392 $ 6,142 1,004 196 3,807 1,930 3,107 2,154 333 7,800 6,520 1,728 2,624 7,800 2,377 7,167 $ 126,359 1,303 $ 8,841 652 $ S-10(a) GROUP 1 7,993 $ 652 1,303 8,841 $ 7,993 1,303 $ 39,114 652 $ 7,993 UTILITY NAME: Aquarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. / Brevard ACCT. NO. ACCOUNT NAME (a) (b) 701 Salaries and Wages - Employees 703 Salaries and Wages - Officers, Directors and Majority Stockholders 704 Employee Pensions and Benefits 710 Purchased Sewage Treatment 711 Sludge Removal Expense Purchased Power 715 716 Fuel for Power Production 718 Chemicals 720 Materials and Supplies 731 Contractual Services - Engineering Contractual Services - Accounting 732 733 Contractual Services - Legal Contractual Services - Mgt. Fees 734 Contractual Services - Testing 735 Contractual Services - Other 736 741 Rental of Building/Real Property 742 Rental of Equipment Transportation Expense 750 756 Insurance - Vehicle Insurance - General Liability 757 Insurance- Workmens Comp. 758 Insurance - Other 759 760 Advertising Expense Regulatory Commission Expenses 766 Amortization of Rate Case Expense Regulatory Commission Exp.-Other 767 Bad Debt Expense 770 Miscellaneous Expenses 775 Total Wastewater Utility Expenses YEAR OF REPORT December 31, 2014 WASTEWATER UTILITY EXPENSE ACCOUNTS .7 .a .9 RECLAIMED WATER CUSTOMER ADMIN.& TREATMENT ACCOUNTS GENERAL EXPENSES· EXPENSE EXPENSES OPERATIONS (k) (I) Ul . $ 12,285 $ 12,285 $ .10 RECLAIMED WATER TREATMENT EXPENSES· MAINTENANCE (m) .11 RECLAIMED WATER DISTRIBUTION EXPENSES· OPERATIONS (n) .12 RECLAIMED WATER DISTRIBUTION EXPENSES· MAINTENANCE (o) $ . $ . $ . $ . 3,807 1,930 196 167 196 167 6,520 1,728 2,624 2,377 652 $ 13,298 652 $ 32,284 S-10(b) GROUP 1 $ . $ . UTILITY NAME: Aquarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. / Brevard YEAR OF REPORT December 31, 2014 CALCULATION OF THE WASTEWATER SYSTEMS EQUIVALENT RESIDENTIAL UNITS METER SIZE (a) TYPE OF METER (b) EQUIVALENT FACTOR (c) All Residential TOTAL NUMBER OF METER EQUIVALENTS (c x d) (e) NUMBER OF METERS (d) 1.0 265 8 518" 314" DisQiacement 1.5 1" DisQiacement 2.5 1 112" DisQiacement or Turbine 5.0 - 2" DisQiacement, ComQound or Turbine 8.0 6 3" DisQiacement 15.0 3" 16.0 17.5 DisQiacement 1.0 3" ComQound Turbine 4" DisQiacement or ComQound 25.0 4" Turbine 30.0 6" DisQiacement or ComQound 50.0 6" Turbine 62.5 8" ComQound 80.0 8" 10" Turbine 90.0 ComQound 115.0 Turbine 145.0 215.0 10" 12" Turbine 265 8 48 321 Total Wastewater System Meter Equivalents CALCULATION OF THE WASTEWATER SYSTEM EQUIVALENT RESIDENTIAL CONNECTION~ Provide a calculation used to determine the value of one wastewater equivalent residential connection (ERC). Use one of the following methods: (a) If actual flow data are available from the preceding 12 months, divide the total annual single family residence (SFR) gallons sold by the average number of single family residence customers for the same period and divide the result by 365 days. (b) If no historical flow data are available, use: ERC = ( Total SFR gallons sold (Omit 000) I 365 days 1280 gallons per day ) For wastewater only utilities: Subtract all general use and other non-residential customer gallons from the total gallons treated. Divide the remainder (SFR customers) by 365 days to reveal single family residence customer gallons pe NOTE: Total gallons treated includes both treated and purchased treatment ERC Calculation: 11,907,000 I 365 days ) I 280 gpd (total gallons treated) S-11 GROUP1 SYSTEM Aquarina Utilities, Inc. = 117 UTILITY NAME: Aquarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. / Brevard WASTEWATER TREATMENT PLANT INFORMATION Provide a separate sheet for each wastewater treatment facility Permitted Capacity Basis of Permit Capacity (1) .99 mgd AADF Schreiber Manufacturer Activated Sludge Type (2) Hydraulic Capacity .99 mgd Average Daily Flow .398 mgd Total Gallons of Wastewater Treated Method of Effluent Disposal 11,907,000 Drain Field (1) Basis of permitted capacity as stated on the Florida DEP WWTP Operating Permit (i.e. average annual daily flow, etc) S-12 GROUP 1 SYSTEM Aquarina Utilities, Inc. YEAR OF REPORT December 31, 2014 UTILITY NAME: Aguarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. / Brevard YEAR OF REPORT December 31, 201 OTHER WASTEWATER SYSTEM INFORMATION Furnish information below for each system. A separate page should be supplied where necessary. 1. Present ERC's * that system can efficiently serve. 321 2. Maximum number of ERC's * which can be served. 354 3. Present system connection capacity (in ERC's *) using existing lines. 354 4. Future system connection capacity (in ERC's *) upon service area buildout. 5. Estimated annual increase in ERC's * . 550 1 6. Describe any plans and estimated completion dates for any enlargements or improvements of this system. None 7. If the utility uses reuse as a means of effluent disposal, attach a list of the reuse end users and the amount of reuse provided to each, if known. N/A Unknown 8. If the utility does not engage in reuse, has a reuse feasibility study been completed? If so, when? Unknown - system designed and permitted for reuse at flows > .1 mgd 9. Has the utility been required by the DEP or water management district to implement reuse? Begin reuse operations at flows > .1 mgd If so, what are the utility's plans to comply with the DEP? 10. When did the company last file a capacity analysis report with the DEP? 11. If the present system does not meet the requirements of DEP rules: a. Attach a description of the plant upgrade necessary to meet the DEP rules. N/A b. Have these plans been approved by DEP? N/A c. When will construction begin? N/A d. Attach plans for funding the required upgrading. N/A e. Is this system under any Consent Order of the DEP? 11. Department of Environmental Protection ID # No FLA 01 0352-005-DW3P * An ERC is determined based on the calculation on the bottom of Page S-11 S-13 GROUP1 SYSTEM Aquarina Utilities, Inc. 9/2012 UTILITY NAME: Aguarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. / Brevard WASTEWATER TREATMENT PLANT INFORMATION Provide a separate sheet for each wastewater treatment facility Permitted Capacity Basis of Permit Capacity (1) .99 mgd AADF Schreiber Manufacturer Activated Sludge Type (2) Hydraulic Capacity .99 mgd Average Daily Flow .398 mgd Total Gallons of Wastewater Treated Method of Effluent Disposal 11,907,000 Drain Field (1) Basis of permitted capacity as stated on the Florida DEP WWTP Operating Permit (i.e. average annual daily flow, etc) S-12 GROUP1 SYSTEM Aquarina Utilities, Inc. YEAR OF REPORT December 31, 2014 UTILITY NAME: Aquarina Utilities, Inc. SYSTEM NAME I COUNTY: Aquarina Utilities, Inc. / Brevard YEAR OF REPOR December 31, 201 OTHER WASTEWATER SYSTEM INFORMATION Furnish information below for each system. A separate page should be supplied where necessary. 1. Present ERC's * that system can efficiently serve. 321 2. Maximum number of ERC's *which can be served. 354 3. Present system connection capacity (in ERC's *) using existing lines. 354 4. Future system connection capacity (in ERC's *) upon service area buildout. 5. Estimated annual increase in ERC's * . 550 1 6. Describe any plans and estimated completion dates for any enlargements or improvements of this system. None 7. If the utility uses reuse as a means of effluent disposal, attach a list of the reuse end users and the amount of reuse N/A provided to each, if known. Unknown 8. If the utility does not engage in reuse, has a reuse feasibility study been completed? If so, when? Unknown- system designed and permitted for reuse at flows >.1 mgd 9. Has the utility been required by the DEP or water management district to implement reuse? Begin reuse operations at flows > .1 mgd If so, what are the utility's plans to comply with the DEP? 10. When did the company last file a capacity analysis report with the DEP? 11. If the present system does not meet the requirements of DEP rules: a. Attach a description of the plant upgrade necessary to meet the DEP rules. N/A b. Have these plans been approved by DEP? N/A c. When will construction begin? N/A d. Attach plans for funding the required upgrading. N/A e. Is this system under any Consent Order of the DEP? 11. Department of Environmental Protection ID # No FLA 01 0352-005-DW3P * An ERC is determined based on the calculation on the bottom of Page S-11 S-13 GROUP1 SYSTEM Aquarina Utilities, Inc. 9/2012