{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["A"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":16,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"A","index":0,"n_rows":83,"n_cols":34,"rows_kept":83,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["Utility Name",{"$nulls":14},"SCHEDULE 2",{"$nulls":4},"Utility Name",{"$nulls":12},"   SCHEDULE 1"]
["Docket No. ",{"$nulls":19},"Docket No. ",{"$nulls":10},"  "]
[{"$nulls":11}," ",{"$nulls":18}," "]
[]
[{"$nulls":8},""]
["Allowance for Funds Prudently Invested",{"$nulls":19},"Allowance for Funds Prudently Invested"]
["Calculation of Carrying Costs for Each ERC:",{"$nulls":19},"Calculation of Carrying Costs for Each ERC"]
[]
[]
["Cost of Quailfying Assets:",null,"$",0,null,null,null,"Annual Depreciation Expense:",{"$nulls":6},"$",0,{"$nulls":4},"Information Needed"]
["Divided By Future ERC:",null,null,0,null,null,null,"Future ERC's:",{"$nulls":7},0]
[null,null,null,"-",{"$nulls":11},"-",{"$nulls":4},"  1.",null,"Cost of Qualifying Assets",{"$nulls":7},"$",0]
["Cost/ERC:",null,"$",{"$error":"#N/A"},null,null,null,"Annual Depr. Cost per ERC:",{"$nulls":6},"$",{"$error":"#N/A"},{"$nulls":6},"a.)","Non used and useful Plant",{"$nulls":4},"$"]
["Multiply By Rate of Return:",null,null,0,{"$nulls":18},"b.)","Non used and useful Accumulated Depreciation",{"$nulls":4},"$"]
[null,null,null,"-",{"$nulls":18},"c.)","Non used and useful CIAC",{"$nulls":4},"$"]
["Annual Return Per ERC:",null,"$",{"$error":"#N/A"},null,null,null,"Annual Propery Tax Expense:",{"$nulls":6},"$",0,{"$nulls":6},"d.)","Non used and useful AA of CIAC",{"$nulls":4},"$"]
[{"$nulls":7},"Future ERC's:",{"$nulls":7},0]
["Annual Reduction in Return:",null,"$",{"$error":"#N/A"},{"$nulls":11},"-"]
["(Annual Depreciation Expense",{"$nulls":6},"Annual Prop. Tax per ERC:",{"$nulls":6},"$",{"$error":"#N/A"},{"$nulls":4},"  2.",null,"Capacity of Qualifying Assets",{"$nulls":9},"GPD"]
["per ERC Times Rate of Return)"]
[{"$nulls":20},"  3.",null,"Number of Future Customers",{"$nulls":9},"ERC"]
[]
["Federal Tax Rate:",null,null,0,null,null,null,"Weighted Cost of Equity:",{"$nulls":7},0,{"$nulls":4},"  4.",null,"Annual Net Depreciation Expense",{"$nulls":7},"$"]
["Effective State Tax Rate:",null,null,0,null,null,null,"Divided by Rate of Return:",{"$nulls":7},0]
[null,null,null,"-",{"$nulls":11},"-",{"$nulls":4},"  5.",null,"Rate of Return"]
["Total Tax Rate:",null,null,0,null,null,null,"% of Equity in Return:",{"$nulls":7},{"$error":"#N/A"}]
[{"$nulls":20},"  6.",null,"Weighted Cost of Equity"]
[]
["Effective Tax on Return:",null,null,{"$error":"#N/A"},null,null,null,"Other Costs:",{"$nulls":6},"$",0,{"$nulls":4},"  7.",null,"Federal Income Tax Rate"]
["(Equity % Times Tax Rate)",{"$nulls":6},"Future ERC's:",{"$nulls":7},0]
[{"$nulls":15},"-",{"$nulls":4},"  8.",null,"State Income Tax Rate"]
["Provision For Tax:",null,null,{"$error":"#N/A"},null,null,null,"Cost per ERC:",{"$nulls":6},"$",{"$error":"#N/A"}]
["(Tax on Return/(1-Total Tax Rate))",{"$nulls":19},"  9.",null,"Annual Property Tax",{"$nulls":7},"$"]
[]
[{"$nulls":20}," 10.",null,"Other Costs",{"$nulls":7},"$"]
[]
[{"$nulls":20}," 11.",null,"Depreciation Rate of Assets"]
[]
[{"$nulls":20}," 12.",null,"Test Year "]
[]
[]
[]
[]
[]
[]
["Utility Name",{"$nulls":14},"  SCHEDULE 3",{"$nulls":4},"Utility Name",{"$nulls":12},"SCHEDULE 4"]
["Docket No. ",{"$nulls":19},"Docket No. "]
[{"$nulls":11}," "]
[]
[{"$nulls":20},"Allowance for Funds Prudently Invested"]
["Allowance for Funds Prudently Invested",{"$nulls":19},"Calculation of Carrying Cost Per ERC Per Month:"]
["Calculation of Carrying Cost Per ERC Per Year:"]
[]
[]
[null,null,null,0,null,0,null,0,null,0,null,0,{"$nulls":11},0,null,0,null,0,null,0,null,0,null,0]
[null,null,null," ----",null," ----",null," ----",null," ----",null," ----",{"$nulls":11},"-----",null,"-----",null,"-----",null,"-----",null,"-----",null,"-----"]
["Unfunded Other Costs:",null,"$",{"$error":"#N/A"},"$",{"$error":"#N/A"},"$",{"$error":"#N/A"},"$",{"$error":"#N/A"},"$",{"$error":"#N/A"}]
["Unfunded Annual Depreciation:",null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$nulls":9},"January",null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
["Unfunded Property Tax:",null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$nulls":9},"February",null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,"-",null,"-",null,"-",null,"-",null,"-",{"$nulls":9},"March",null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
["Subtotal Unfunded Annual Expense:",null,"$",{"$error":"#N/A"},"$",{"$error":"#N/A"},"$",{"$error":"#N/A"},"$",{"$error":"#N/A"},"$",{"$error":"#N/A"},{"$nulls":9},"April",null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
["Unfunded Expenses Prior Year:",null,null,0,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$nulls":9},"May",null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,"-",null,"-",null,"-",null,"-",null,"-",{"$nulls":9},"June",null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
["Total Unfunded Expenses:",null,"$",{"$error":"#N/A"},"$",{"$error":"#N/A"},"$",{"$error":"#N/A"},"$",{"$error":"#N/A"},"$",{"$error":"#N/A"},{"$nulls":9},"July",null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[{"$nulls":21},"August",null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
["Return on Expenses Current Year:",null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$nulls":9},"September",null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
["Return on Expenses Prior Year:",null,null,0,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$nulls":9},"October",null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
["Return on Plant Current Year:",null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$nulls":9},"November",null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
["Earnings Prior Year:",null,null,0,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$nulls":9},"December",null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
["Compound Earnings from Prior Year:",null,null,0,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,"-",null,"-",null,"-",null,"-",null,"-"]
["Total Compounded Earnings:",null,"$",{"$error":"#N/A"},"$",{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
["Earnings Expansion Factor for Tax:",null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,"-",null,"-",null,"-",null,"-",null,"-"]
["Revenue Required to Fund Earnings:",null,"$",{"$error":"#N/A"},"$",{"$error":"#N/A"},"$",{"$error":"#N/A"},"$",{"$error":"#N/A"},"$",{"$error":"#N/A"}]
["Revenue Required to Fund Expenses:",null,null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,null,null,"-",null,"-",null,"-",null,"-",null,"-"]
[]
["Subtotal:",null,"$",{"$error":"#N/A"},"$",{"$error":"#N/A"},"$",{"$error":"#N/A"},"$",{"$error":"#N/A"},"$",{"$error":"#N/A"}]
["Divided by Factor for Regulatory Assessment Fee",null,null,0.955,null,0.955,null,0.955,null,0.955,null,0.955]
[null,null,null,"-",null,"-",null,"-",null,"-",null,"-"]
["ERC Carrying Cost for 1 Year:",null,"$",{"$error":"#N/A"},"$",{"$error":"#N/A"},"$",{"$error":"#N/A"},"$",{"$error":"#N/A"},"$",{"$error":"#N/A"}]