{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["SWR-Cover","SWR-Form A","SWR-Form B","SWR-Form C","SWR-Form D","SWR-Form E","SWR-Form F","SWR-Form G","SWR-Form H","SWR-Form I"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":16,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"SWR-Cover","index":0,"n_rows":35,"n_cols":2,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,1,34,9],[33,1,33,9],[3,1,3,9],[1,1,1,9],[6,1,6,9],[7,1,7,9],[2,1,2,9],[4,1,4,9],[31,1,31,9]]}
[]
[null,"Public Utilities Commission of Nevada"]
[null,"Simplified Rate Change Application"]
[null,"For an Increase in WASTE WATER Rates"]
[null,"Class A or B Waste Water Utility"]
[]
[]
[null,"(Please enter legal name of utility above)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Using Simplified Procedures Pursuant to NRS 704.095 and NAC 704.570 to 704.628"]
[]
[null,"Public Utilities Commission of Nevada"]
[null,"Class A or B Waste Water Utility"]

{"sheet":"SWR-Form A","index":1,"n_rows":105,"n_cols":9,"rows_kept":105,"cut":false,"hidden":false,"merged":[[110,1,110,8],[108,1,108,8],[107,1,107,8],[105,1,105,8],[106,1,106,8],[109,1,109,8],[66,1,66,4],[64,1,64,4],[36,6,36,9],[0,0,0,9],[2,0,2,9],[43,1,43,4],[40,1,40,4],[41,1,41,4],[30,1,30,4],[32,1,32,4],[34,1,34,4],[7,0,7,9],[10,1,10,4],[42,1,42,4],[1,0,1,9],[12,1,12,4],[18,1,18,2],[20,1,20,2],[16,1,16,4],[20,6,20,7],[99,1,99,2],[88,6,88,7],[82,1,82,4],[84,1,84,4],[68,6,68,7],[76,1,76,2],[72,1,72,4],[74,1,74,4],[68,1,68,2],[62,1,62,4],[32,6,32,9],[34,6,34,9],[101,6,101,7],[101,1,101,2],[95,1,95,4],[97,1,97,4],[78,1,78,2],[78,6,78,7],[88,1,88,2],[86,1,86,2],[46,1,46,2],[24,1,24,4],[26,1,26,2],[58,6,58,7],[58,1,58,2],[30,6,30,9],[56,1,56,2],[36,1,36,4],[52,1,52,4],[54,1,54,4]]}
["Public Utilities Commission of Nevada"]
["Class A or B Waste Water Utility"]
[{"$f":"IF(B11=0,\"\",B11)","v":""}]
[null,null,null,null,null,"Test Year Ending: "]
[null,null,null,null,null,"Certification Period Ending:"]
[]
[]
["COMPANY INFORMATION"]
["                                                                                                                                          "]
["1)","Applicant:"]
[]
["                                                                                                                                          ","(Legal Name)",null,null,null,null,"(CPC No.)"]
[]
[null,"(Utility Name - If different from above.)"]
["                                                                                                                                          "]
["2)","Business Address:"]
[]
["                                                                                                                                          ","(Physical Address)"]
[]
["                                                                                                                                          ","(City or Town)",null,null,null,null,"(State)",null,"(Zip Code)"]
[]
["                                                                                                                                          ","(Business Phone)",null,null,null,null,"(Emergency Phone)"]
[]
["3)","Mailing Address:"]
[]
["                                                                                                                                          ","(Address)"]
[]
["                                                                                                                                          ","(City or Town)",null,null,null,null,"(State)",null,"(Zip Code)"]
["                                                                                                                                          "]
["4)","Corporate Information:"]
[]
[null,"(President)",null,null,null,null,"(State of Incorporation)"]
[]
[null,"(Vice President)",null,null,null,null,"(Year of Incorporation)"]
[]
[null,"(Secretary)",null,null,null,null,"(Other)"]
[]
[null,"(Treasurer)",null,null,null,null,"(Other)"]
["                                                                                                                                          "]
["5)","List shareholders holding 2% or more of outstanding stock:      %  "]
[]
[]
[]
[]
[]
["6)","Type of federal income tax return filed:"]
[]
[]
[]
[]
[]
["7)","President and General/Operations Manager:"]
[]
[null,"(Name)"]
[]
[null,"(Address)"]
[]
[null,"(City or Town)",null,null,null,null,"(State)",null,"(Zip Code)"]
[]
[null,"(Business Phone)",null,null,null,null,"(Emergency Phone)"]
[]
["8)","Customer Service (Complaints, Billings, etc.):"]
[]
[null,"(Name)"]
[]
[null,"(Address)"]
[]
[null,"(City or Town)",null,null,null,null,"(State)",null,"(Zip Code)"]
[]
[null,"(Business Phone)",null,null,null,null,"(Emergency Phone)"]
[]
["9)","Operations/Engineering:"]
[]
[null,"(Name)"]
[]
[null,"(Address)"]
[]
[null,"(City or Town)",null,null,null,null,"(State)",null,"(Zip Code)"]
[]
[null,"(Business Phone)",null,null,null,null,"(Emergency Phone)"]
[]
["10)","Emergency Service:"]
[]
[null,"(Name)"]
[]
[null,"(Address)"]
[]
[null,"(City or Town)",null,null,null,null,"(State)",null,"(Zip Code)"]
[]
[null,"(Business Phone)",null,null,null,null,"(Emergency Phone)"]
[]
[]
[]
[]
["11)","Accounting/Rate Application:"]
[]
[null,"(Name)"]
[]
[null,"(Address)"]
[]
[null,"(City or Town)",null,null,null,null,"(State)",null,"(Zip Code)"]
[]
[null,"(Business Phone)",null,null,null,null,"(Emergency Phone)"]
["                                                                                                                                          "]
["12)","Reasons for rate increase:"]

{"sheet":"SWR-Form B","index":2,"n_rows":48,"n_cols":11,"rows_kept":48,"cut":false,"hidden":false,"merged":[[7,0,7,10],[0,0,0,10],[2,0,2,10],[1,0,1,10]]}
["Public Utilities Commission of Nevada"]
["Class A or B Waste Water Utility"]
[{"$f":"IF('SWR-Cover'!B7=0,\"\",'SWR-Cover'!B7)","v":""}]
[null,null,null,null,"Test Year Ending:",null,{"$f":"IF('SWR-Form A'!G4=0,\"\",'SWR-Form A'!G4)","v":""}]
[null,null,null,null,"Certification Period Ending:",null,{"$f":"IF('SWR-Form A'!G5=0,\"\",'SWR-Form A'!G5)","v":""}]
[]
[]
["TARIFF RATE SCHEDULES -EXISTING AND PROPOSED WASTE WATER RATES"]
[null,null,null,null,null,null,"Existing",null,"Proposed",null,"Proposed"]
["Line",null,null,null,null,null,"Tariff",null,"Increase",null,"Tariff"]
["No.",null,"Type",null,"Size",null,"Rate (1)",null,"(% Calculated)",null,"Rate (2)"]
[null,null,"(a)",null,"(b)",null,"(c)",null,"(d)",null,"(e)"]
[]
[1,"Flat Rates (monthly): *"]
[{"$f":"+A14+1","v":2},null,"Residential",null,"All",null,null,null,{"$f":"IF(G15=0,\"\",(K15-G15)/G15)","v":""}]
[{"$f":"+A15+1","v":3},null,"Commercial",null,"All",null,null,null,{"$f":"IF(G16=0,\"\",(K16-G16)/G16)","v":""}]
[4,null,"Industrial",null,"All",null,null,null,""]
[5,null,"Public Authorities",null,"All",null,null,null,{"$f":"IF(G18=0,\"\",(K18-G18)/G18)","v":""}]
[6,null,"Multiple Family Dwellings",null,"All",null,null,null,{"$f":"IF(G19=0,\"\",(K19-G19)/G19)","v":""}]
[7,null,"Other",null,"All",null,null,null,""]
[8,null,null,null,null,null,null,null,""]
[9,null,null,null,null,null,null,null,""]
[10,null,null,null,null,null,null,null,""]
[11]
[12,"Measured  Rates (monthly): *"]
[13,null,"Residential",null,"All",null,null,null,""]
[14,null,"Commercial",null,"All",null,null,null,""]
[15,null,"Industrial",null,"All",null,null,null,""]
[16,null,"Public Authorities",null,"All",null,null,null,""]
[17,null,"Multiple Family Dwellings",null,"All",null,null,null,""]
[18,null,null,null,null,null,null,null,""]
[19,null,null,null,null,null,null,null,""]
[20,null,null,null,null,null,null,null,""]
[21]
[22,"Other Waste Water Revenues *"]
[23,null,"Public Authorities - Special Cont.",null,"All",null,null,null,""]
[24,null,"Other Systems",null,"All",null,null,null,""]
[25,null,"Interdepartmental Revenues",null,"All",null,null,null,""]
[26,null,null,null,null,null,null,null,""]
[27,null,null,null,null,null,null,null,""]
[28,null,null,null,null,null,null,null,""]
[29]
[30,"Notes:"]
[31,"(1)","Rates currently in effect.",null,null,null,null,null,""]
[32,"(2)","Rates the Utility is proposing if granted by the PUCN in this Simplified Rate Change Application."]
[33,"*","Insert additional rows and explanations as necessary. Please contact PUCN Staff at the number"]
[34,null,"listed in the Instructions section of this application for assistance"]
[null,null,null,null,null,null,null,null,""]

{"sheet":"SWR-Form C","index":3,"n_rows":70,"n_cols":17,"rows_kept":70,"cut":false,"hidden":false,"merged":[[2,0,2,13],[0,0,0,13],[1,0,1,13],[9,1,9,2]]}
["Public Utilities Commission of Nevada"]
["Class A or B Waste Water Utility"]
[{"$f":"IF('SWR-Cover'!B7=0,\"\",'SWR-Cover'!B7)","v":""}]
[null,null,null,null,null,"Test Year Ending:",null,{"$f":"IF('SWR-Form A'!G4=0,\"\",'SWR-Form A'!G4)","v":""}]
[null,null,null,null,null,"Certification Period Ending:",null,{"$f":"IF('SWR-Form A'!G5=0,\"\",'SWR-Form A'!G5)","v":""}]
[]
["INCOME STATEMENT"]
[null,null,null,"NARUC",null,"Recorded",null,"Adjustments",null,"Adjusted",null,"Additional",null,"Total"]
["Line",null,null,"Account",null,"Test Year",null,"to Test Year",null,"Test Year",null,"Revenue",null,"Revenue"]
["No.","Description",null,"Numbers",null,"Balance",null,"Balances ",null,"Balance",null,"Required ",null,"Requirement"]
[null,null,"(a)","(b)",null,"(c)",null,"(d)",null,"(e)",null,"(f)",null,"(g)"]
[]
[1,"Operating Revenue: (From Form F)"]
[{"$f":"+A13+1","v":2},null,"Flat Rate - Residential",521.1,null,{"$f":"'SWR-Form F'!F16","v":0},null,null,null,{"$f":"+F14+H14","v":0},null,null,null,{"$f":"J14+L14","v":0}]
[{"$f":"+A14+1","v":3},null,"Flat Rate - Commercial",521.20000000000005,null,{"$f":"'SWR-Form F'!F17","v":0},null,null,null,{"$f":"+F15+H15","v":0},null,null,null,{"$f":"J15+L15","v":0}]
[4,null,"Flat Rate - Industrial",521.29999999999995,null,{"$f":"'SWR-Form F'!F18","v":0},null,null,null,0,null,null,null,0]
[5,null,"Flat Rate - Public Authority",521.4,null,{"$f":"'SWR-Form F'!F19","v":0},null,null,null,0,null,null,null,0]
[6,null,"Flat Rate - Multi Family Dwellings",521.5,null,{"$f":"'SWR-Form F'!F20","v":0},null,null,null,0,null,null,null,0]
[7,null,"Flat Rate - Other",521.6,null,{"$f":"SUM('SWR-Form F'!F21:F23)","v":0},null,null,null,0,null,null,null,0]
[8,null,"Measured - Residential",522.1,null,{"$f":"'SWR-Form F'!F27","v":0},null,null,null,0,null,null,null,0]
[9,null,"Measured - Commercial",522.20000000000005,null,{"$f":"'SWR-Form F'!F28","v":0},null,null,null,0,null,null,null,0]
[10,null,"Measured - Industrial",522.29999999999995,null,{"$f":"'SWR-Form F'!F29","v":0},null,null,null,0,null,null,null,0]
[11,null,"Measured - Public Authority",522.4,null,{"$f":"'SWR-Form F'!F30","v":0},null,null,null,0,null,null,null,0]
[12,null,"Measured - Multi. Family Dwellings",522.5,null,{"$f":"'SWR-Form F'!F31","v":0},null,null,null,0,null,null,null,0]
[13,null,"Public Authorities - Special Cont.",523,null,{"$f":"'SWR-Form F'!F37","v":0},null,null,null,{"$f":"+F25+H25","v":0},null,null,null,0]
[14,null,"Other Systems",524,null,{"$f":"'SWR-Form F'!F38+SUM('SWR-Form F'!F32:F33)+SUM('SWR-Form F'!F40:F41)","v":0},null,null,null,{"$f":"+F26+H26","v":0},null,null,null,0]
[15,null,"Interdepartmental Revenues",525,null,{"$f":"'SWR-Form F'!F39","v":0},null,null,null,{"$f":"+F27+H27","v":0},null,null,null,0]
[16,null,"Total Operating Revenue",null,null,{"$f":"SUM(F14:F27)","v":0},null,{"$f":"SUM(H14:H27)","v":0},null,{"$f":"SUM(J14:J27)","v":0},null,{"$f":"SUM(L14:L27)","v":0},null,{"$f":"SUM(N14:N27)","v":0}]
[17,"Operating Expenses:"]
[18,null,"Salaries & Wages - Employees",701,null,null,null,null,null,{"$f":"+F30+H30","v":0},null,null,null,{"$f":"+J30+L30","v":0}]
[19,null,"Salaries & Wages - Officers, Dir.",703,null,null,null,null,null,{"$f":"+F31+H31","v":0},null,null,null,{"$f":"+J31+L31","v":0}]
[20,null,"Employee Pensions & Benefits",704,null,null,null,null,null,0,null,null,null,{"$f":"+J32+L32","v":0}]
[21,null,"Purchased Waste Water Treatment",710,null,null,null,null,null,0,null,null,null,0]
[22,null,"Sludge Removal",711,null,null,null,null,null,0,null,null,null,0]
[23,null,"Purchased Power",715,null,null,null,null,null,0,null,null,null,0]
[24,null,"Fuel for Power Production",716,null,null,null,null,null,0,null,null,null,0]
[25,null,"Chemicals",718,null,null,null,null,null,0,null,null,null,0]
[26,null,"Materials & Supplies",720,null,null,null,null,null,0,null,null,null,0]
[27,null,"Contractual Services - ENG.",731,null,null,null,null,null,0,null,null,null,0]
[28,null,"Contractual Services - ACC.",732,null,null,null,null,null,0,null,null,null,0]
[29,null,"Contractual Services - LEGAL",733,null,null,null,null,null,0,null,null,null,0]
[30,null,"Contractual Services - MGT. FEES",734,null,null,null,null,null,0,null,null,null,0]
[31,null,"Contractual Services - OTHER",735,null,null,null,null,null,0,null,null,null,0]
[]
[{"$f":"+A43+1","v":32},null,"Rental of Building / Real Property",741,null,null,null,null,null,0,null,null,null,0]
[33,null,"Rental of Equipment",742,null,null,null,null,null,0,null,null,null,0]
[34,null,"Transportation",750,null,null,null,null,null,0,null,null,null,0]
[35,null,"Insurance Exp. - Vehicle",756,null,null,null,null,null,0,null,null,null,0]
[36,null,"Insurance Exp. - Liability",757,null,null,null,null,null,0,null,null,null,0]
[37,null,"Insurance Exp. - Workman's Comp.",758,null,null,null,null,null,0,null,null,null,0]
[38,null,"Insurance Exp. - Other",759,null,null,null,null,null,0,null,null,null,0]
[39,null,"Advertising ",760,null,null,null,null,null,0,null,null,null,0]
[40,null,"Regulatory Commission - Rate Case",766,null,null,null,null,null,0,null,null,null,0]
[41,null,"Regulatory Commission - Other",767,null,null,null,null,null,0,null,null,null,0]
[42,null,"Bad Debt ",770,null,null,null,null,null,0,null,null,null,0]
[43,null,"Miscellaneous ",775,null,null,null,null,null,0,null,null,null,0]
[44,null,"Depreciation ",403,null,null,null,null,null,0,null,null,null,0]
[45,null,"Amortization",407,null,null,null,null,null,0,null,null,null,0]
[46,null,"Taxes Other Than Income",408,null,null,null,null,null,0,null,null,null,0]
[47,null,"Income Taxes",409,null,null,null,null,null,0,null,null,null,0,"**","Adjustments  in Col (f)"]
[48,null,"Total Operating Expenses",null,null,{"$f":"SUM(F30:F60)","v":0},null,{"$f":"SUM(H30:H60)","v":0},null,{"$f":"SUM(J30:J60)","v":0},null,{"$f":"SUM(L30:L60)","v":0},null,{"$f":"SUM(N30:N60)","v":0},null,"need to be",{"$f":"(+N62-J62)-(L28-L61)","v":0}]
[49,null,"Net Operating Income",null,null,{"$f":"+F28-F61","v":0},null,{"$f":"+H28-H61","v":0},null,{"$f":"+J28-J61","v":0},null,{"$f":"IF(ROUND(L28-L61,0)=ROUND(N62-J62,0),N62-J62,\"   Error\")","v":0},null,{"$f":"ROUND(N65*N66,0)","v":0},null,"in the Revenue section"]
[50,null,null,null,null,null,null,null,null,null,null,"*",null,"**",null,"to make sheet balance."]
[51,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check total",{"$f":"+N28-N61","v":0}]
[52,null,"Rate Base [Form D, Line 20]",null,null,{"$f":"+'SWR-Form D'!F35","v":0},null,{"$f":"+'SWR-Form D'!H35","v":0},null,{"$f":"+F65+H65","v":0},null,null,null,{"$f":"+J65+L65","v":0}]
[53,null,"Rate of Return",null,null,{"$f":"IF(F65=0,\"\",F62/F65)","v":""},null,null,null,{"$f":"IF(J65=0,\"\",(J62/J65))","v":""},null,null,null,{"$f":"+'SWR-Form E'!L36","v":0}]
[54,null,null,null,null,null,null,null,null,null,null,null,null,"[Form E, Line 24]"]
[55,"Notes:"]
[56,"*","Total of column MUST equal this figure."]
[57,"**","Allowed Net Income (Rate of Return times Rate Base)"]

{"sheet":"SWR-Form D","index":4,"n_rows":78,"n_cols":10,"rows_kept":78,"cut":false,"hidden":false,"merged":[[2,0,2,9],[0,0,0,9],[1,0,1,9]]}
["Public Utilities Commission of Nevada"]
["Class A or B Waste Water Utility"]
[{"$f":"IF('SWR-Cover'!B7=0,\"\",'SWR-Cover'!B7)","v":""}]
[null,null,null,"Test Year Ending:",null,{"$f":"IF('SWR-Form A'!G4=0,\"\",'SWR-Form A'!G4)","v":""}]
[null,null,null,"Certification Period Ending:",null,{"$f":"IF('SWR-Form A'!G5=0,\"\",'SWR-Form A'!G5)","v":""}]
[]
["RATE BASE"]
[null,null,null,"NARUC",null,"Recorded",null,"Adjustments",null,"Adjusted"]
["Line",null,null,"Account",null,"Test Year",null,"to Test Year",null,"Test Year"]
["No.",null,"Description","Numbers",null,"Balance",null,"Balances",null,"Balance"]
[null,null,"(a)","(b)",null,"(c)",null,"(d)",null,"(e)"]
[]
[1,"Plant in Service:"]
[{"$f":"+A13+1","v":2},null,"Utility Plant in Service [Line 53 (c)] ",101,null,{"$f":"+F73","v":0},null,null,null,{"$f":"SUM(+F14+H14)","v":0}]
[{"$f":"+A14+1","v":3},null,"Accum. Depreciation  [Line 53 (d)]",108,null,{"$f":"-H73","v":0},null,null,null,{"$f":"SUM(+F15+H15)","v":0}]
[4,null,"Net Utility Plant in Service",null,null,{"$f":"SUM(F14:F15)","v":0},null,{"$f":"SUM(H14:H15)","v":0},null,{"$f":"SUM(J14:J15)","v":0}]
[5,null,"Add: (1)"]
[6,null,"Materials & Supplies",151,null,null,null,null,null,{"$f":"+F18+H18","v":0}]
[7,null,"Prepayments",162,null,null,null,null,null,0]
[8,null,"Misc. Deferred Debits",186,null,null,null,null,null,0]
[9,null,"Accum. Deferred Income Taxes",190,null,null,null,null,null,0]
[10,null,"Cash Working Capital",null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,0]
[13,null,"Sub-Total",null,null,{"$f":"SUM(F18:F24)","v":0},null,{"$f":"SUM(H18:H24)","v":0},null,{"$f":"SUM(J18:J24)","v":0}]
[14,null,"Less: (1)"]
[15,null,"Taxes Other Than Income",236.11,null,null,null,null,null,{"$f":"+F27+H27","v":0}]
[16,null,"Advances for Construction",252,null,null,null,null,null,0]
[17,null,"Contribution in Aid of Construction (2)",271,null,{"$f":"J73","v":0},null,null,null,0]
[18,null,"Less:  Accum. Amortization of CIAC (3)",272,null,null,null,null,null,0]
[19,null,"Accum. Deferred Income Taxes",281,null,null,null,null,null,0]
[20,null,null,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,null,null,0]
[22,null,"Sub-Total",null,null,{"$f":"SUM(F27:F33)","v":0},{"$f":"SUM(G27:G33)","v":0},{"$f":"SUM(H27:H33)","v":0},{"$f":"SUM(I27:I33)","v":0},{"$f":"SUM(J27:J33)","v":0}]
[23,null,"Net Rate Base",null,null,{"$f":"+F16+F25-F34","v":0},null,{"$f":"+H16+H25-H34","v":0},null,{"$f":"+J16+J25-J34","v":0}]
[24]
[25,"Note(s):"]
[26,"(1)","Insert additional rows and explanations necessary. Please contact PUCN Staff at"]
[27,null,"the number listed in the Instructions section of this application for assistance"]
[28,"(2)","From Contribution in Aid of Construction (CIAC) detail on [Form D, Line 54 (e)]."]
[29,"(3)","Enter CIAC accumulated amortization as a negative number"]
[]
[]
[null,null,null,"NARUC",null,"Acct. 101",null,"Acct. 108",null,"Acc. 271"]
["Line",null,null,"Account",null,"Plant in ",null,"Accumulated ",null,"CIAC (2)"]
["No.",null,"Description","Numbers",null,"Service",null,"Depreciation"]
[null,null,"(a)","(b)",null,"(c)",null,"(d)",null,"(e)"]
[]
[{"$f":"A41+1","v":30},"WASTE WATER Utility Plant (1)"]
[{"$f":"A49+1","v":31},null,"Organization",351]
[{"$f":"A50+1","v":32},null,"Franchises",352]
[{"$f":"A51+1","v":33},null,"Land & Land Rights",353]
[34,null,"Structures & Improvements",354]
[35,null,"Power Generation Equipment",355]
[36,null,"Collection - Force ",360]
[37,null,"Collection - Gravity ",361]
[38,null,"Special Collecting Structures",362]
[39,null,"Services to Customers",363]
[40,null,"Flow Measuring Devices",364]
[41,null,"Flow Measuring Installations",365]
[42,null,"Receiving Wells",370]
[43,null,"Treatment & Disposal Equipment",380]
[44,null,"Plant Sewers",381]
[45,null,"Outfall Sewer Lines",382]
[46,null,"Other Plant & Misc. Equipment",389]
[47,null,"Office Furniture & Equipment",390]
[48,null,"Transportation Equipment",391]
[49,null,"Tools, Shop & Garage Equipment",393]
[50,null,"Power Operated Equipment",395]
[51,null,"Other Tangible Plant",398]
[52]
[53]
[54,null,"Total Utility Plant",null,null,{"$f":"SUM(F50:F72)","v":0},null,{"$f":"SUM(H50:H72)","v":0},null,{"$f":"SUM(J50:J72)","v":0}]
[55,null,null,null,null,"to Line 2 (c)",null,"to Line 3 (c)",null,"to Line 17 (c)"]
[56,"Note(s):"]
[57,"(1)","Insert additional rows and explanations as necessary. Please contact PUCN Staff at"]
[58,null,"the number listed in the Instructions section of this application for assistance."]
[59,"(2)","CIAC = Contribution in Aid of Construction (gross, prior to amortization)"]

{"sheet":"SWR-Form E","index":5,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,0,2,11],[0,0,0,11],[1,0,1,11]]}
["Public Utilities Commission of Nevada"]
["Class A or B Waste Water Utility"]
[{"$f":"IF('SWR-Cover'!B7=0,\"\",'SWR-Cover'!B7)","v":""}]
[null,null,null,"Test Year Ending:",null,{"$f":"IF('SWR-Form A'!G4=0,\"\",'SWR-Form A'!G4)","v":""}]
[null,null,null,"Certification Period Ending:",null,{"$f":"IF('SWR-Form A'!G5=0,\"\",'SWR-Form A'!G5)","v":""}]
[]
["WEIGHTED COST OF CAPITAL"]
[null,null,null,"NARUC",null,"Recorded",null,null,null,"Interest",null,"Weighted"]
["Line",null,null,"Account",null,"Test Year",null,"Weight",null,"Rate",null,"Cost"]
["No.",null,"Description","Numbers",null,"Balance",null,"(% of Total)",null,"( % )",null,"( % )"]
[null,null,"(a)","(b)",null,"(c)",null,"(d)",null,"(e)",null,"(f)"]
[]
[1,null,"DEBT: *"]
[{"$f":"+A13+1","v":2},null,"Long Term Debt",224,null,null,null,{"$f":"IF(F14=0,\"\",F14/$F$36)","v":""},null,null,null,{"$f":"IF(F14=0,\" \",ROUND(+H14*J14,4))","v":" "}]
[{"$f":"+A14+1","v":3},null,null,null,null,null,null,{"$f":"IF(F15=0,\"\",F15/$F36)","v":""},null,null,null,{"$f":"IF(F15=0,\" \",ROUND(+H15*J15,4))","v":" "}]
[4,null,null,null,null,null,null,{"$f":"IF(F16=0,\"\",F16/$F36)","v":""},null,null,null," "]
[5,null,null,null,null,null,null,{"$f":"IF(F17=0,\"\",F17/$F36)","v":""},null,null,null," "]
[6,null,null,null,null,null,null,{"$f":"IF(F18=0,\"\",F18/$F36)","v":""},null,null,null," "]
[7,null,"Notes Payable",232,null,null,null,{"$f":"IF(F19=0,\"\",F19/$F36)","v":""},null,null,null," "]
[8,null,null,null,null,null,null,{"$f":"IF(F20=0,\"\",F20/$F36)","v":""},null,null,null," "]
[9,null,null,null,null,null,null,{"$f":"IF(F21=0,\"\",F21/$F36)","v":""},null,null,null," "]
[10,null,null,null,null,null,null,{"$f":"IF(F22=0,\"\",F22/$F36)","v":""},null,null,null," "]
[11,null,null,null,null,null,null,{"$f":"IF(F23=0,\"\",F23/$F36)","v":""},null,null,null," "]
[12,null,"Customer Deposits",235,null,null,null,{"$f":"IF(F24=0,\"\",F24/$F36)","v":""},null,null,null," "]
[13,null,"Total Debt",null,null,{"$f":"SUM(F14:F24)","v":0},null,{"$f":"SUM(H14:H24)","v":0},null,null,null,{"$f":"SUM(L14:L24)","v":0}]
[14,null,"EQUITY: *"]
[15,null,"Common Stock",201,null,null,null,{"$f":"IF(F27=0,\" \",+F27/$F$36)","v":" "}]
[16,null,"Preferred Stock",204,null,null,null,{"$f":"IF(F28=0,\" \",+F28/$F$36)","v":" "}]
[17,null,"Other Paid in Capital",211,null,null,null," "]
[18,null,"Retained Earnings (corporations only)",215,null,null,null," "]
[19,null,"Proprietary Capital (non-corporations)",218,null,null,null," "]
[20,null,null,null,null,null,null," "]
[21,null,null,null,null,null,null," "]
[22,null,null,null,null,null,null," "]
[23,null,"Total Equity",null,null,{"$f":"SUM(F27:F34)","v":0},null,{"$f":"SUM(H27:H34)","v":0},null,null,null,{"$f":"ROUND(+H35*J35,4)","v":0}]
[24,null,"Total Weighted Cost of Capital",null,null,{"$f":"+F25+F35","v":0},null,{"$f":"+H25+H35","v":0},null,null,null,{"$f":"ROUND(L25+L35,4)","v":0}]
[25,null,null,null,null,null,null,null,null,null,null,"[Form C, Line 53 (g)]"]
[26,"Notes:"]
[27,"*","Insert additional rows as necessary. For assistance, please contact PUCN Staff at the number listed"]
[28,null,"in the Instructions section of this application."]

{"sheet":"SWR-Form F","index":6,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[[2,0,2,9],[0,0,0,9],[1,0,1,9]]}
["Public Utilities Commission of Nevada"]
["Class A or B Waste Water Utility"]
[{"$f":"IF('SWR-Cover'!B7=0,\"\",'SWR-Cover'!B7)","v":""}]
[null,null,null,"Test Year Ending:",null,{"$f":"IF('SWR-Form A'!G4=0,\"\",'SWR-Form A'!G4)","v":""}]
[null,null,null,"Certification Period Ending:",null,{"$f":"IF('SWR-Form A'!G5=0,\"\",'SWR-Form A'!G5)","v":""}]
[]
[]
["STATEMENT OF SERVICES"]
[null,null,null,"NARUC",null,null,null,"No. of ",null,"No. of "]
["Line",null,null,"Account",null,"Revenues",null,"Customers",null,"Gallons"]
["No.",null,"Description","Numbers",null,null,null,"(End of Year)",null,"(in 000's)"]
[null,null,"(a)","(b)",null,"(b)",null,"(c)",null,"(b)"]
[]
[1,null,"WASTE WATER REVENUES"]
[{"$f":"1+A14","v":2},null,"Flat Rate *",null,null,"[To Form C]"]
[{"$f":"1+A15","v":3},null,"Residential",521.1]
[4,null,"Commercial",521.20000000000005]
[5,null,"Industrial",521.29999999999995]
[6,null,"Public Authorities",521.4]
[7,null,"Multiple Family Dwellings",521.5]
[8,null,"Other",521.6]
[9]
[10]
[11,null,"Subtotal - Unmetered",null,null,{"$f":"SUM(F16:F23)","v":0},null,{"$f":"SUM(H16:H23)","v":0},null,{"$f":"SUM(J16:J23)","v":0}]
[12]
[13,null,"Measured Rate *"]
[14,null,"Residential",522.1]
[15,null,"Commercial",522.20000000000005]
[16,null,"Industrial",522.29999999999995]
[17,null,"Public Authorities",522.4]
[18,null,"Multiple Family Dwellings",522.5]
[19]
[20]
[21,null,"Subtotal - Metered",null,null,{"$f":"SUM(F27:F33)","v":0},null,{"$f":"SUM(H27:H33)","v":0},null,{"$f":"SUM(J27:J33)","v":0}]
[22]
[23,null,"OTHER WASTE WATER REVENUES *"]
[24,null,"Public Authorities - Special Cont.",523]
[25,null,"Other Systems",524]
[26,null,"Interdepartmental Revenues",525]
[27]
[28]
[29,null,"Subtotal",null,null,{"$f":"SUM(F37:F41)","v":0},{"$f":"SUM(G37:G41)","v":0},{"$f":"SUM(H37:H41)","v":0},null,{"$f":"SUM(J37:J41)","v":0}]
[30,null,"TOTALS",null,null,{"$f":"+F24+F34+F42","v":0},{"$f":"+G24+G34+G42","v":0},{"$f":"+H24+H34+H42","v":0},null,{"$f":"+J24+J34+J42","v":0}]
[31,"Notes:"]
[32,"*","Insert additional rows as necessary. For assistance, please contact PUCN Staff at"]
[33,null,"the number listed in the Instructions section of this application."]

{"sheet":"SWR-Form G","index":7,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"CUSTOMER NOTICE"]
[]
[]
[null,"Notice is hereby given to customers of ",null,{"$f":"IF('SWR-Cover'!B7=0,\"\",'SWR-Cover'!B7)","v":""}]
[null,"of the Utility's request for approval from the Public Utilities Commission of Nevada"]
[null,"(\"Commission\") to increase  WASTE WATER rates.  Tabulated below are the principle rates"]
[null,"presently in effect compared to the requested new rates. "]
[]
[null,"The present rates have been in effect since       ",null,null,"."]
[null,"The requested new rates would increase revenues to the Utility                    ",null,null,null,{"$f":"IF('SWR-Form C'!N28=0,\"\",((('SWR-Form C'!N28-'SWR-Form C'!J28))/'SWR-Form C'!J28))","v":""},"over the"]
[null,"present rates. (Applicant may wish to add any explanation for the requested increase.)"]
[]
[null,null,null,"Existing",null,"Proposed",null,"% Inc./Dec."]
[null,null,null,null,null,null,null,{"$f":"IF(D15=0,\"\",((F15-D15)/D15))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(D16=0,\"\",((F16-D16)/D16))","v":""}]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[]
[]
[null,"No public utility shall raise any rates or alter any charge, classification, contract or rules so as to"]
[null,"result in any increase in a rate except upon a showing before the Commission that such increase"]
[null,"is justified.  Customers may wish to bring to the Commission's attention any problem concerning"]
[null,"service, billing procedures or other factors concerning the adequacy of service provided."]
[]
[null,"In order to protect the public's interest, the Commission's Staff will investigate consumer"]
[null,"complaints.  Customers wishing to communicate directly with the Commission should write no"]
[null,"later than 20 days from the date of the postmark on the envelope in which this notice is sent or"]
[null,"from the date upon which it is distributed if not mailed.  "]
[]
[null,"Written comments should be directed the Commission Secretary at:"]
[]
[null,"Public Utilities Commission of Nevada"]
[null,"1150 E. William Street"]
[null,"Carson City, NV 89701"]
[]
[null,"Customers wishing to phone the Commission with their concerns may call the Commission's"]
[null,"Consumer Division in Carson City at (775) 684-6100 or the Las Vegas office at (702) 486-2600."]
[]
[]
[null,"Sincerely,"]
[]
[null,"(Company officer and title)"]

{"sheet":"SWR-Form H","index":8,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,1,1,11],[17,11,17,12],[24,8,24,11],[27,8,27,11],[35,3,35,7],[21,2,21,10],[18,2,18,11],[7,4,7,7],[9,4,9,7],[33,3,33,4],[33,6,33,7],[16,3,16,6],[17,6,17,9]]}
[]
[null,"VERIFICATION"]
[]
[]
[]
[]
[]
[null,null,"State of "]
[]
[null,null,"County of"]
[]
[]
[]
[]
[]
[]
[null,null,"I, ",null,null,null,null,"being first duly sworn, under penalty of perjury"]
[null,null,"depose and say:  That I am the ",null,null,null,null,null,null,null,"(title) for",{"$f":"'SWR-Form G'!D5","v":""}]
[null,null,{"$f":"CONCATENATE('SWR-Cover'!B7,\"; that I have read the foregoing application and know\")","v":"; that I have read the foregoing application and know"}]
[null,null,"the contents thereof; that the same is true of my own knowledge, except to those matters therein"]
[null,null,"stated on information and belief, and as to those matters I believe them to be true."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"(Signature)"]
[]
[]
[null,null,null,null,null,null,null,null,"(Title)"]
[]
[]
[null,null,"SUBSCRIBED and SWORN to by me"]
[]
[null,null,"this ",null,null,"  ,day of "]
[]
[]
[null,null,null,"Notary Public"]

{"sheet":"SWR-Form I","index":9,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,1,0,8],[11,3,11,5],[7,1,7,2],[9,1,9,2],[1,1,1,8],[2,1,2,8],[3,1,3,8],[7,3,7,5],[9,3,9,5],[29,6,29,8],[39,2,39,3],[41,1,41,5],[33,6,33,8],[35,6,35,8]]}
[]
[null,"AFFIDAVIT OF PROOF OF SERVICE"]
[null,"AND"]
[null,"POSTING OF APPLICATION"]
[]
[]
[]
[null,"State of",null,null,null,null,")"]
[]
[null,"County of ",null,null,null,null,")"]
[]
[null,null,"I, ",null,null,null,",being duly sworn, under penalty of "]
[null,null,null,"perjury depose and say the following:"]
[]
[null,"1)","Upon the filing of this application for an increase in rates with the Public Utility Commission of"]
[null,null,"Nevada (\"Commission\"), the Utility has made available a complete copy in such form and place as"]
[null,null,"is readily accessible and available for inspection by its customers;"]
[]
[null,"2)","Upon the filing of this application for an increase in rates with the Commission, the Utility has"]
[null,null,"served a copy of the application on each county, municipality and general improvement district"]
[null,null,"whose citizens would be affected by the proposed change in rates.  A copy has also been served"]
[null,null,"upon the Nevada Attorney General Bureau of Consumer Protection - Utility Consumer's Advocate;"]
[]
[null,"3)","Within 10 days of filing this application for an increase in rates with the Commission, the Utility has"]
[null,null,"made available in plain type and posted at its place of business a notice stating that the application"]
[null,null,"has been filed with the Commission.  Said notice describes the purpose of the application and"]
[null,null,"indicates that the complete application is available for public inspection on the premise."]
[]
[null,"4)","Within 30 days after filing this application with the Commission, I or my representative under my"]
[null,null,"direction, has notified each and every customer of",null,null,null,{"$f":"IF('SWR-Cover'!B7=0,\"\",'SWR-Cover'!B7)","v":""}]
[null,null,"by U.S. Mail at their address on file, of the filing of this application to seek an increase in rates."]
[]
[]
[]
[null,null,null,null,null,null,"(Name)"]
[]
[null,null,null,null,null,null,"(Title)"]
[]
[null,"SUBSCRIBED and SWORN to before me"]
[null,"this",null,null,"day of "]
[]
[]
[null,"Notary Public"]