{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["WTR-Cover","WTR-Form A","WTR-Form B","WTR-Form C","WTR-Form D","WTR-Form E","WTR-Form F","WTR-Form G","WTR-Form H","WTR-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":"WTR-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 WATER Rates"]
[null,"Class C 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 C Water Utility"]

{"sheet":"WTR-Form A","index":1,"n_rows":105,"n_cols":9,"rows_kept":105,"cut":false,"hidden":false,"merged":[[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],[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],[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],[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],[110,1,110,8],[108,1,108,8],[107,1,107,8],[105,1,105,8],[106,1,106,8],[109,1,109,8]]}
["Public Utilities Commission of Nevada"]
["Class C 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":"WTR-Form B","index":2,"n_rows":125,"n_cols":11,"rows_kept":125,"cut":false,"hidden":false,"merged":[[41,3,41,8],[85,3,85,8],[122,3,122,8],[6,0,6,10],[0,0,0,10],[2,0,2,10],[1,0,1,10]]}
["Public Utilities Commission of Nevada"]
["Class C Water Utility"]
[{"$f":"IF('WTR-Cover'!B7=0,\"\",'WTR-Cover'!B7)","v":""}]
[null,null,null,null,"Test Year Ending:",null,{"$f":"IF('WTR-Form A'!G4=0,\"\",'WTR-Form A'!G4)","v":""}]
[null,null,null,null,"Certification Period Ending:",null,{"$f":"IF('WTR-Form A'!G5=0,\"\",'WTR-Form A'!G5)","v":""}]
[]
["TARIFF RATE SCHEDULES -EXISTING AND PROPOSED 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,"Unmetered Rates (monthly): *"]
[{"$f":"+A13+1","v":2},null,"Residential",null,"All",null,null,null,{"$f":"IF(G14=0,\"\",(K14-G14)/G14)","v":""}]
[{"$f":"+A14+1","v":3},null,"Commercial",null,"All",null,null,null,""]
[{"$f":"+A15+1","v":4},null,"Irrigation",null,"All",null,null,null,""]
[{"$f":"+A16+1","v":5},null,"Public Authorities",null,"All",null,null,null,""]
[{"$f":"+A17+1","v":6},null,null,null,null,null,null,null,""]
[{"$f":"+A18+1","v":7},null,null,null,null,null,null,null,""]
[8,null,null,null,null,null,null,null,""]
[9]
[10,"Metered Rates (monthly): *"]
[11,null,"Residential",null,null,null,null,null,{"$f":"IF(G23=0,\"\",(K23-G23)/G23)","v":""}]
[12,null,"Basic/Fixed Service Charge",null,"1/2\"",null,null,null,""]
[13,null,"     \"        \"",null,"5/8\"",null,null,null,""]
[14,null,"     \"        \"",null,"3/4\"",null,null,null,""]
[15,null,"     \"        \"",null,"1\"",null,null,null,""]
[16,null,"     \"        \"",null,"1 ½\"",null,null,null,""]
[17,null,null,null,null,null,null,null,""]
[18,null,"Commodity Rate (3)",null,"1/2\"",null,null,null,{"$f":"IF(G30=0,\"\",(K30-G30)/G30)","v":""}]
[19,null,"     \"        \"",null,"5/8\"",null,null,null,{"$f":"IF(G31=0,\"\",(K31-G31)/G31)","v":""}]
[20,null,"     \"        \"",null,"3/4\"",null,null,null,""]
[21,null,"     \"        \"",null,"1\"",null,null,null,{"$f":"IF(G33=0,\"\",(K33-G33)/G33)","v":""}]
[22,null,"     \"        \"",null,"1 ½\"",null,null,null,{"$f":"IF(G34=0,\"\",(K34-G34)/G34)","v":""}]
[23,null,null,null,null,null,null,null,{"$f":"IF(G35=0,\"\",(K35-G35)/G35)","v":""}]
[24,null,null,null,null,null,null,null,""]
[25,null,null,null,null,null,null,null,""]
[26]
[27,"Notes:"]
[28,"(1)","Rates currently in effect."]
[29,"(2)","Rates the Utility is proposing if granted by the PUCN in this Simplified Rate Change Application."]
[30,"(3)","Specify the unit of measure :"]
[31,"*","Insert additional rows and explanations as necessary. Please contact PUCN Staff at the number"]
[32,null,"listed in the Instructions section of this application for assistance."]
[]
[]
[{"$f":"A44+1","v":33},"Commercial/Industrial/"]
[34,"Public Authority:  *",null,null,null,null,null,null,{"$f":"IF(G48=0,\"\",(K48-G48)/G48)","v":""}]
[35,null,"Basic/Fixed Service Charge",null,"1/2\"",null,null,null,""]
[36,null,"     \"        \"",null,"5/8\"",null,null,null,""]
[37,null,"     \"        \"",null,"3/4\"",null,null,null,""]
[38,null,"     \"        \"",null,"1\"",null,null,null,""]
[39,null,"     \"        \"",null,"1 ½\"",null,null,null,""]
[40,null,"     \"        \"",null,"2\"",null,null,null,""]
[41,null,"     \"        \"",null,"3\"",null,null,null,""]
[42,null,"     \"        \"",null,"4\"",null,null,null,""]
[43,null,"     \"        \"",null,"6\"",null,null,null,""]
[44,null,null,null,null,null,null,null,""]
[45,null,"Commodity Rate (3)",null,"1/2\"",null,null,null,""]
[46,null,"     \"        \"",null,"5/8\"",null,null,null,""]
[47,null,"     \"        \"",null,"3/4\"",null,null,null,""]
[48,null,"     \"        \"",null,"1\"",null,null,null,""]
[49,null,"     \"        \"",null,"1 ½\"",null,null,null,""]
[50,null,"     \"        \"",null,"2\"",null,null,null,""]
[51,null,"     \"        \"",null,"3\"",null,null,null,""]
[52,null,"     \"        \"",null,"4\"",null,null,null,""]
[53,null,"     \"        \"",null,"6\"",null,null,null,""]
[54,null,null,null,null,null,null,null,{"$f":"IF(G68=0,\"\",(K68-G68)/G68)","v":""}]
[55,null,null,null,null,null,null,null,{"$f":"IF(G69=0,\"\",(K69-G69)/G69)","v":""}]
[56,null,null,null,null,null,null,null,""]
[57]
[58,"Irrigation: *",null,null,null,null,null,null,{"$f":"IF(G72=0,\"\",(K72-G72)/G72)","v":""}]
[59,null,"Basic/Fixed Service Charge",null,"1/2\"",null,null,null,""]
[60,null,"     \"        \"",null,"5/8\"",null,null,null,""]
[61,null,"     \"        \"",null,"3/4\"",null,null,null,""]
[62,null,"     \"        \"",null,"1\"",null,null,null,""]
[63,null,"     \"        \"",null,"1 ½\"",null,null,null,""]
[64,null,"     \"        \"",null,"2\"",null,null,null,""]
[65,null,"     \"        \"",null,"3\"",null,null,null,""]
[66,null,"     \"        \"",null,"4\"",null,null,null,""]
[67,null,"     \"        \"",null,"6\"",null,null,null,""]
[68]
[{"$f":"+A82+1","v":69},"Notes:"]
[70,"(1)","Rates currently in effect.",null,null,null,null,null,{"$f":"IF(G84=0,\"\",(K84-G84)/G84)","v":""}]
[71,"(2)","Rates the Utility is proposing if granted by the PUCN in this Simplified Rate Change Application."]
[72,"(3)","Specify the unit of measure :",{"$f":"IF(D42=0,\"\",D42)","v":""}]
[73,"*","Insert additional rows and explanations as necessary. Please contact PUCN Staff at the number"]
[74,null,"listed in the Instructions section of this application for assistance"]
[null,null,null,null,null,null,null,null,{"$f":"IF(G89=0,\"\",(K89-G89)/G89)","v":""}]
[null,null,null,null,null,null,null,null,""]
[{"$f":"A88+1","v":75},"Irrigation: *",null,null,null,null,null,null,""]
[{"$f":"A91+1","v":76},null,"Commodity Rate (3)",null,"1/2\"",null,null,null,""]
[{"$f":"A92+1","v":77},null,"     \"        \"",null,"5/8\"",null,null,null,""]
[{"$f":"A93+1","v":78},null,"     \"        \"",null,"3/4\"",null,null,null,""]
[79,null,"     \"        \"",null,"1\"",null,null,null,""]
[80,null,"     \"        \"",null,"1 ½\"",null,null,null,""]
[81,null,"     \"        \"",null,"2\"",null,null,null,""]
[82,null,"     \"        \"",null,"3\"",null,null,null,""]
[83,null,"     \"        \"",null,"4\"",null,null,null,""]
[84,null,"     \"        \"",null,"6\"",null,null,null,""]
[85,null,null,null,null,null,null,null,""]
[{"$f":"A101+1","v":86},null,null,null,null,null,null,null,""]
[87,null,null,null,null,null,null,null,""]
[88]
[89,"Public/Private Fire Protection: *"]
[90,null,"Flat Rate",null,null,null,null,null,{"$f":"IF(G106=0,\"\",(K106-G106)/G106)","v":""}]
[91,null,"Metered:"]
[92,null,null,null,"inch",null,null,null,""]
[93,null,null,null,"inch",null,null,null,{"$f":"IF(G109=0,\"\",(K109-G109)/G109)","v":""}]
[94,null,null,null,"inch",null,null,null,""]
[95]
[96,"Miscellaneous Rates: *"]
[97,null,"Returned Check Fee",null,null,null,null,null,""]
[98,null,"Application Fee",null,null,null,null,null,""]
[99,null,"Service Reconnect Fee",null,null,null,null,null,""]
[100,null,null,null,null,null,null,null,""]
[101,null,null,null,null,null,null,null,""]
[102,null,null,null,null,null,null,null,""]
[103]
[104,"Notes:"]
[105,"(1)","Rates currently in effect."]
[106,"(2)","Rates the Utility is proposing if granted by the PUCN in this Simplified Rate Change Application."]
[107,"(3)","Specify the unit of measure :",{"$f":"IF(D42=0,\"\",D42)","v":""}]
[108,"*","Insert additional rows and explanations as necessary. Please contact PUCN Staff at the number"]
[109,null,"listed in the Instructions section of this application for assistance"]

{"sheet":"WTR-Form C","index":3,"n_rows":63,"n_cols":17,"rows_kept":63,"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 C Water Utility"]
[{"$f":"IF('WTR-Cover'!B7=0,\"\",'WTR-Cover'!B7)","v":""}]
[null,null,null,null,null,"Test Year Ending:",null,{"$f":"IF('WTR-Form A'!G4=0,\"\",'WTR-Form A'!G4)","v":""}]
[null,null,null,null,null,"Certification Period Ending:",null,{"$f":"IF('WTR-Form A'!G5=0,\"\",'WTR-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 Revenues: ",null,null,null,"From Form F"]
[{"$f":"+A13+1","v":2},null,"Unmetered - Residential",460.1,null,{"$f":"'WTR-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,"Unmetered - Commercial",460.2,null,{"$f":"'WTR-Form F'!F17","v":0},null,null,null,{"$f":"+F15+H15","v":0},null,null,null,{"$f":"J15+L15","v":0}]
[4,null,"Unmetered - Industrial",460.3,null,{"$f":"'WTR-Form F'!F18","v":0},null,null,null,0,null,null,null,0]
[5,null,"Unmetered - Public Authority",460.4,null,{"$f":"'WTR-Form F'!F19","v":0},null,null,null,0,null,null,null,0]
[6,null,"Unmetered - Multi Family Dwellings",460.5,null,{"$f":"'WTR-Form F'!F20","v":0},null,null,null,0,null,null,null,0]
[7,null,"Unmetered - Other",460.6,null,{"$f":"SUM('WTR-Form F'!F21:F22)","v":0},null,null,null,0,null,null,null,0]
[8,null,"Metered - Residential",461.1,null,{"$f":"'WTR-Form F'!F26","v":0},null,null,null,0,null,null,null,0]
[9,null,"Metered - Commercial",461.2,null,{"$f":"'WTR-Form F'!F27","v":0},null,null,null,0,null,null,null,0]
[10,null,"Metered - Industrial",461.3,null,{"$f":"'WTR-Form F'!F28","v":0},null,null,null,0,null,null,null,0]
[11,null,"Metered - Public Authority",461.4,null,{"$f":"'WTR-Form F'!F29","v":0},null,null,null,0,null,null,null,0]
[12,null,"Metered - Multi. Family Dwellings",461.5,null,{"$f":"'WTR-Form F'!F30","v":0},null,null,null,0,null,null,null,0]
[13,null,"Fire Protection ",462,null,{"$f":"'WTR-Form F'!F36","v":0},null,null,null,{"$f":"+F25+H25","v":0},null,null,null,0]
[14,null,"Irrigation ",465,null,{"$f":"'WTR-Form F'!F37","v":0},null,null,null,{"$f":"+F26+H26","v":0},null,null,null,0]
[15,null,"Sales for Resale",466,null,{"$f":"'WTR-Form F'!F38","v":0},null,null,null,{"$f":"+F27+H27","v":0},null,null,null,0]
[16,null,"Guaranteed ",469,null,{"$f":"'WTR-Form F'!F42","v":0},null,null,null,{"$f":"+F28+H28","v":0},null,null,null,{"$f":"J28+L28","v":0}]
[17,null,"Other Water ",474,null,{"$f":"'WTR-Form F'!F42+'WTR-Form F'!F43+'WTR-Form F'!F31+'WTR-Form F'!F32","v":0},null,null,null,{"$f":"+F29+H29","v":0},null,null,null,{"$f":"J29+L29","v":0}]
[18,null,"Total Operating Revenue",null,null,{"$f":"SUM(F14:F29)","v":0},null,{"$f":"SUM(H14:H29)","v":0},null,{"$f":"SUM(J14:J29)","v":0},null,{"$f":"SUM(L14:L29)","v":0},null,{"$f":"SUM(N14:N29)","v":0}]
[19,"Operating Expenses:"]
[20,null,"Salaries & Wages - Employees",601,null,null,null,null,null,{"$f":"+F32+H32","v":0},null,null,null,{"$f":"+J32+L32","v":0}]
[21,null,"Salaries & Wages - Officers, Dir.",603,null,null,null,null,null,{"$f":"+F33+H33","v":0},null,null,null,{"$f":"+J33+L33","v":0}]
[22,null,"Employee Pensions & Benefits",604,null,null,null,null,null,0,null,null,null,{"$f":"+J34+L34","v":0}]
[23,null,"Purchased Water",610,null,null,null,null,null,0,null,null,null,0]
[24,null,"Purchased Power",615,null,null,null,null,null,0,null,null,null,0]
[25,null,"Fuel for Power Production",616,null,null,null,null,null,0,null,null,null,0]
[26,null,"Chemicals",618,null,null,null,null,null,0,null,null,null,0]
[27,null,"Materials & Supplies",620,null,null,null,null,null,0,null,null,null,0]
[28,null,"Contractual Services - Billing",630,null,null,null,null,null,0,null,null,null,0]
[29,null,"Contractual Services - Professional",631,null,null,null,null,null,0,null,null,null,0]
[30,null,"Contractual Services - Testing",635,null,null,null,null,null,0,null,null,null,0]
[31,null,"Contractual Services - Other",636,null,null,null,null,null,0,null,null,null,0]
[32,null,"Rents",640,null,null,null,null,null,0,null,null,null,0]
[33,null,"Transportation",650,null,null,null,null,null,0,null,null,null,0]
[34,null,"Insurance ",655,null,null,null,null,null,0,null,null,null,0]
[35,null,"Regulatory Commission",665,null,null,null,null,null,0,null,null,null,0]
[36,null,"Bad Debt ",670,null,null,null,null,null,0,null,null,null,0]
[37,null,"Miscellaneous ",675,null,null,null,null,null,0,null,null,null,0]
[38,null,"Depreciation ",403,null,null,null,null,null,0,null,null,null,0]
[39,null,"Amortization",407,null,null,null,null,null,0,null,null,null,0]
[40,null,"Taxes Other Than Income",408,null,null,null,null,null,0,null,null,null,0]
[41,null,"Income Taxes",409,null,null,null,null,null,0,null,null,null,0,"**","Adjustments  in Col (f)"]
[42,null,"Total Operating Expenses",null,null,{"$f":"SUM(F32:F53)","v":0},null,{"$f":"SUM(H32:H53)","v":0},null,{"$f":"SUM(J32:J53)","v":0},null,{"$f":"SUM(L32:L53)","v":0},null,{"$f":"SUM(N32:N53)","v":0},null,"need to be",{"$f":"(+N55-J55)-(L30-L54)","v":0}]
[43,null,"Net Operating Income",null,null,{"$f":"+F30-F54","v":0},null,{"$f":"+H30-H54","v":0},null,{"$f":"+J30-J54","v":0},null,{"$f":"IF(ROUND(L30-L54,0)=ROUND(N55-J55,0),N55-J55,\"   Error\")","v":0},null,{"$f":"ROUND(N58*N59,0)","v":0},null,"in the Revenue section"]
[44,null,null,null,null,null,null,null,null,null,null,"*",null,"**",null,"to make sheet balance."]
[45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check total",{"$f":"+N30-N54","v":0}]
[46,null,"Rate Base [Form D, Line 20]",null,null,{"$f":"+'WTR-Form D'!F32","v":0},null,{"$f":"+'WTR-Form D'!H32","v":0},null,{"$f":"+F58+H58","v":0},null,0,null,{"$f":"+J58+L58","v":0}]
[47,null,"Rate of Return",null,null,{"$f":"IF(F55=0,\"\",F55/F58)","v":""},null,null,null,{"$f":"IF(J58=0,\"\",(J55/J58))","v":""},null,null,null,{"$f":"+'WTR-Form E'!L36","v":0}]
[48,null,null,null,null,null,null,null,null,null,null,null,null,"[Form E, Line 24]"]
[49,"Notes:"]
[50,"*","Total of column MUST equal this figure."]
[51,"**","Allowed Net Income (Rate of Return times Rate Base)"]

{"sheet":"WTR-Form D","index":4,"n_rows":73,"n_cols":10,"rows_kept":73,"cut":false,"hidden":false,"merged":[[2,0,2,9],[0,0,0,9],[1,0,1,9]]}
["Public Utilities Commission of Nevada"]
["Class C Water Utility"]
[{"$f":"IF('WTR-Cover'!B7=0,\"\",'WTR-Cover'!B7)","v":""}]
[null,null,null,"Test Year Ending:",null,{"$f":"IF('WTR-Form A'!G4=0,\"\",'WTR-Form A'!G4)","v":""}]
[null,null,null,"Certification Period Ending:",null,{"$f":"IF('WTR-Form A'!G5=0,\"\",'WTR-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 49 (c)] ",101,null,{"$f":"+F68","v":0},null,null,null,{"$f":"SUM(+F14+H14)","v":0}]
[{"$f":"+A14+1","v":3},null,"Accum. Depreciation  [Line 49 (d)]",108,null,{"$f":"-H68","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,"Accum. Deferred Income Taxes",190,null,null,null,null,null,{"$f":"+F19+H19","v":0}]
[8,null,"Cash Working Capital",null,null,null,null,null,null,{"$f":"+F20+H20","v":0}]
[9,null,null,null,null,null,null,null,null,{"$f":"+F21+H21","v":0}]
[10,null,null,null,null,null,null,null,null,{"$f":"+F22+H22","v":0}]
[11,null,"Sub-Total",null,null,{"$f":"SUM(F18:F22)","v":0},null,{"$f":"SUM(H18:H22)","v":0},null,{"$f":"SUM(J18:J22)","v":0}]
[12,null,"Less: (1)"]
[13,null,"Advances for Construction",252,null,null,null,null,null,{"$f":"+F25+H25","v":0}]
[14,null,"Contribution in Aid of Construction (2)",271,null,{"$f":"J68","v":0},null,null,null,0]
[15,null,"Less:  Accum. Amortization of CIAC (3)",272,null,null,null,null,null,0]
[16,null,"Accum. Deferred Income Taxes",281,null,null,null,null,null,0]
[17,null,null,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,null,null,0]
[19,null,"Sub-Total",null,null,{"$f":"SUM(F25:F30)","v":0},{"$f":"SUM(G25:G30)","v":0},{"$f":"SUM(H25:H30)","v":0},{"$f":"SUM(I25:I30)","v":0},{"$f":"SUM(J25:J30)","v":0}]
[20,null,"Net Rate Base",null,null,{"$f":"+F16+F23-F31","v":0},null,{"$f":"+H16+H23-H31","v":0},null,{"$f":"+J16+J23-J31","v":0}]
[21]
[{"$f":"+A33+1","v":22},"Note(s):"]
[23,"(1)","Insert additional rows and explanations as necessary. Please contact PUCN Staff at"]
[24,null,"the number listed in the Instructions section of this application for assistance"]
[25,"(2)","From Contribution in Aid of Construction (CIAC) detail on [Form D, Line 48 (e)]."]
[26,"(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":"A38+1","v":27},"WATER Utility Plant (1)"]
[{"$f":"A46+1","v":28},null,"Organization",301]
[{"$f":"A47+1","v":29},null,"Land & Land Rights",303]
[{"$f":"A48+1","v":30},null,"Intake Lines",306]
[31,null,"Structures and Improvements",304]
[32,null,"Wells & Springs",307]
[33,null,"Power Generation Equipment",310]
[34,null,"Pumping Equipment",311]
[35,null,"Water Treatment Equipment",320]
[36,null,"Reservoirs & Standpipes",330]
[37,null,"Transmission & Distribution Mains",331]
[38,null,"Services",333]
[39,null,"Meters & Meter Installations",334]
[40,null,"Hydrants",335]
[41,null,"Backflow Prevention Devices",336]
[42,null,"Miscellaneous Equipment",339]
[43,null,"Office Furniture & Equipment",340]
[44,null,"Tools, Shop & Garage Equipment",343]
[45,null,"Power Operated Equipment",345]
[46,null,"Other Tangible Plant",348]
[47]
[48]
[49,null,"Total Utility Plant",null,null,{"$f":"SUM(F47:F67)","v":0},null,{"$f":"SUM(H47:H67)","v":0},null,{"$f":"SUM(J47:J67)","v":0}]
[50,"Note(s):",null,null,null,"to Line 2 (c)",null,"to Line 3 (c)",null,"to Line 14 (c)"]
[51]
[52,"(1)","Insert additional rows and explanations as necessary. Please contact PUCN Staff at"]
[53,null,"the number listed in the Instructions section of this application for assistance."]
[54,"(2)","CIAC = Contribution in Aid of Construction (gross, prior to amortization)"]

{"sheet":"WTR-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 C Water Utility"]
[{"$f":"IF('WTR-Cover'!B7=0,\"\",'WTR-Cover'!B7)","v":""}]
[null,null,null,"Test Year Ending:",null,{"$f":"IF('WTR-Form A'!G4=0,\"\",'WTR-Form A'!G4)","v":""}]
[null,null,null,"Certification Period Ending:",null,{"$f":"IF('WTR-Form A'!G5=0,\"\",'WTR-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 47 (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":"WTR-Form F","index":6,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[2,0,2,9],[0,0,0,9],[1,0,1,9]]}
["Public Utilities Commission of Nevada"]
["Class C Water Utility"]
[{"$f":"IF('WTR-Cover'!B7=0,\"\",'WTR-Cover'!B7)","v":""}]
[null,null,null,"Test Year Ending:",null,{"$f":"IF('WTR-Form A'!G4=0,\"\",'WTR-Form A'!G4)","v":""}]
[null,null,null,"Certification Period Ending:",null,{"$f":"IF('WTR-Form A'!G5=0,\"\",'WTR-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)",null,null,"(b)",null,"(c)",null,"(b)"]
[]
[1,null,"WATER SALES"]
[{"$f":"1+A14","v":2},null,"Unmetered (Flat Rate) *",null,null,"To Form C"]
[{"$f":"1+A15","v":3},null,"Residential",460.1]
[4,null,"Commercial",460.2,null,0,null,0,null,0]
[5,null,"Industrial",460.3,null,0,null,0,null,0]
[6,null,"Public Authorities",460.4,null,0,null,0,null,0]
[7,null,"Multiple Family Dwellings",460.5,null,0,null,0,null,0]
[8,null,null,460.6,null,0,null,0,null,0]
[9,null,null,null,null,0,null,0,null,0]
[10,null,"Subtotal - Unmetered",null,null,{"$f":"SUM(F16:F22)","v":0},null,{"$f":"SUM(H16:H22)","v":0},null,{"$f":"SUM(J16:J22)","v":0}]
[11]
[12,null,"Metered *"]
[13,null,"Residential",461.1,null,0,null,0,null,0]
[14,null,"Commercial",461.2,null,0,null,0,null,0]
[15,null,"Industrial",461.3,null,0,null,0,null,0]
[16,null,"Public Authorities",461.4,null,0,null,0,null,0]
[17,null,"Multiple Family Dwellings",461.5,null,0,null,0,null,0]
[18,null,null,null,null,0,null,0,null,0]
[19,null,null,null,null,0,null,0,null,0]
[20,null,"Subtotal - Metered",null,null,{"$f":"SUM(F26:F32)","v":0},null,{"$f":"SUM(H26:H32)","v":0},null,{"$f":"SUM(J26:J32)","v":0}]
[21]
[22,null,"OTHER WATER SALES *"]
[23,null,"Fire Protection",462,null,0,null,0,null,0]
[24,null,"Irrigation Customers",465,null,0,null,0,null,0]
[25,null,"Sales for Resale",466,null,0,null,0,null,0]
[{"$f":"1+A38","v":26},null,"Subtotal - Other Water Sales",null,null,{"$f":"SUM(F36:F38)","v":0},null,{"$f":"SUM(H36:H38)","v":0},null,{"$f":"SUM(J36:J38)","v":0}]
[27]
[28,null,"OTHER WATER REVENUES"]
[29,null,"Guaranteed Revenues",469,null,0,null,0,null,0]
[30,null,"Other Water Revenues",474,null,0,null,0,null,0]
[31,null,"Subtotal - Other Water Rev.",null,null,{"$f":"SUM(F42:F43)","v":0},null,{"$f":"SUM(H42:H43)","v":0},null,{"$f":"SUM(J42:J43)","v":0}]
[32,null,"TOTALS",null,null,{"$f":"+F23+F33+F39+F44","v":0},null,{"$f":"+H23+H33+H39+H44","v":0},null,{"$f":"+J23+J33+J39+J44","v":0}]
[33]
[34]
[35,"Notes:"]
[36,"*","Insert additional rows as necessary. For assistance, please contact PUCN Staff at"]
[37,null,"the number listed in the Instructions section of this application."]

{"sheet":"WTR-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('WTR-Cover'!B7=0,\"\",'WTR-Cover'!B7)","v":""}]
[null,"of the Utility's request for approval from the Public Utilities Commission of Nevada"]
[null,"(\"Commission\") to increase  WATER rates.  Tabulated below are the principle rates presently in"]
[null,"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('WTR-Form C'!N30=0,\"\",((('WTR-Form C'!N30-'WTR-Form C'!J30))/'WTR-Form C'!J30))","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":"WTR-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,6,33,7],[33,3,33,4],[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":"'WTR-Form G'!D5","v":""}]
[null,null,{"$f":"CONCATENATE('WTR-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":"WTR-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('WTR-Cover'!B7=0,\"\",'WTR-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"]