{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Population Estimates","DSWRESR","Revenues and Expenses","First Scenario","Summary with Elasticity","Second Scenario","Water Demand","Water vs. Impact Fee Revenues"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":87,"comments":1,"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":"Population Estimates","index":0,"n_rows":35,"n_cols":18,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,"GOPB Estimates",1990,2000,2010,2020,2030,2040,2050,2060]
[null,"2005 Estimate",48978,91090,168078,279864,415510,559670,709674,860378]
[null,"2012 Estimate",48978,91090,138748,196762,280558,371743,472567,581731,null,null,null,null,null,null,"low","high"]
[null,"# Households (est. 2012)",15481,30191,46545,70919,112378,151647,192884,237065,null,null,null,null,null,null,{"$f":"'First Scenario'!N14","v":99351824.642270356},{"$f":"'Second Scenario'!N14","v":130945384.2410354}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"per capita debt",{"$f":"Q4/(($E$3+$F$3)/2)","v":592.24359716414028},{"$f":"R4/(($E$3+$F$3)/2)","v":780.57514971855028}]
[]
[null,"To solve for geometric growth rates: x_2060 = x_2010 * Exp(r * (2060-2010)) and solve for r."]
[null,"But that is for continuous compounding.  For annual compounding:",null,null,null,null,null,null,{"$f":"J4-E4","v":190520},"change in households"]
[null,"     x_2060 = x_2010 * (1+r)^(2060-2010) and solve for r.",null,null,null,null,null,null,{"$f":"EXP(  LN(J4/E4) / (J1-E1)) - 1","v":3.3094116200343082E-2},"Annually Compounded Household Growth Rate, 2010--2060"]
[null,"     =>   Exp[  Ln(x_2060/x_2010) / (2060-2010)] - 1  =  r.",null,null,null,null,null,null,{"$f":"EXP(  LN(J3/E3) / (J1-E1)) - 1","v":2.9081828528086939E-2},"Annually Compounded Population Growth Rate, 2010--2060"]
[null,"Also, for annual compounding, x_t = x_0 * (1+r)^t implies that"]
[null,"    x_(t+1) - x_t = x_0 * (1+r)^t * r = x_t * r.",null,null,null,null,null,null,295,"gallons per capita per day 2011, p. ES-7 of 2011 DWRe Water Needs Assessment"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Source: GOPB 2012 Population Projections"]

{"sheet":"DSWRESR","index":1,"n_rows":38,"n_cols":17,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Data from the Draft Socioeconomics and Water Resource Economics Study Report",null,null,null,null,null,null,null,{"$f":"'First Scenario'!N11","v":0.04},"interest rate declared in the \"First Scenario\" (its N11)"]
[null,null,null,null,null,null,null,null,{"$f":"'Second Scenario'!N11","v":0.04},"interest rate declared in the \"Second Scenario\" (its N11)"]
[null,null,null,null,null,null,null,null,0.04,"interest rate used on this page for our calculations (not for the Draft Report calculations, which are B6, I6, B23, and I23)"]
[null,null,null,null,null,null,null,null,2.5000000000000001E-2,"FERC \"escalation rate\" (rate of benefit & cost increases) to be used in Scenario pages"]
[]
["Page 5-3, Table 5-1, No Pump Storage",null,null,null,null,null,null,"Page 5-4, Table 5-2, No Pump Storage"]
[null,4.1399999999999999E-2,"Discount Rate",null,null,null,null,null,0.03,"Discount Rate"]
[null,2.5000000000000001E-2,"Escalation Rate",null,null,null,null,null,2.5000000000000001E-2,"Escalation Rate",null,null,null,"For Washington County's share of these, see tab \"Revenues and Expenses\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Avg. of 2 cases","Avg. of 2 cases"]
[null,"PV, 2010$","Annual, 2026","PV, 2015$",null,null,null,null,"PV, 2010$","Annual, 2026","PV, 2015$",null,null,"Annual, 2026","PV, 2015$"]
["Benefits",null,null,null,null,null,null,"Benefits",null,null,null,null,null,null,null,"Benefits","disagreement (ratio)"]
["Power-Inline",45167000,{"$f":"(1+$B$8)^6 * (1+$B$7)^10 * (1 - (1+$B$8)/(1+$B$7)) * B12 / (1 - ((1+$B$8)/(1+$B$7))^41)","v":2587006.4347149506},null,"from equation 5",null,null,"Power-Inline",69561000,{"$f":"(1+$I$8)^6 * (1+$I$7)^10 * (1 - (1+$I$8)/(1+$I$7)) * I12 / (1 - ((1+$I$8)/(1+$I$7))^41)","v":2909678.0910802698},null,"from equation 5",null,{"$f":"AVERAGE(C12,J12)","v":2748342.2628976102},null,"Power-Inline",{"$f":"C12/J12","v":0.88910400179508464}]
["Power-Pump Stations",127587000,{"$f":"(1+$B$8)^6 * (1+$B$7)^10 * (1 - (1+$B$8)/(1+$B$7)) * B13 / (1 - ((1+$B$8)/(1+$B$7))^41)","v":7307733.3005507654},null,"from equation 5",null,null,"Power-Pump Stations",197255000,{"$f":"(1+$I$8)^6 * (1+$I$7)^10 * (1 - (1+$I$8)/(1+$I$7)) * I13 / (1 - ((1+$I$8)/(1+$I$7))^41)","v":8251010.6504512392},null,"from equation 5",null,{"$f":"AVERAGE(C13,J13)","v":7779371.9755010027},null,"Power-Pump Stations",{"$f":"C13/J13","v":0.88567735640374101}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N12:N13)","v":10527714.238398613},null,"sum"]
["Costs",null,null,null,null,null,null,"Costs",null,null,null,null,null,null,null,"Costs"]
["Capital Construction",1124717000,null,{"$f":"(1 -((1+B8)/(1+$I$3))^4)/(1- (1+B8)/(1+$I$3)   )*(1/(1+B8))*(1 - (1+B8)/(1+B7)   )/(1-((1+B8)/(1+B7))^4)*(1+B7)^6 *B16","v":1402458713.1882508},"from equation 6",null,null,"Capital Construction",1227349000,null,{"$f":"(1 -((1+I8)/(1+$I$3))^4)/(1- (1+I8)/(1+$I$3)   )*(1/(1+I8))*(1 - (1+I8)/(1+I7)   )/(1-((1+I8)/(1+I7))^4)*(1+I7)^6 *I16","v":1409367476.6932182},"from equation 6",null,null,{"$f":"AVERAGE(D16,K16)","v":1405913094.9407344},"Capital Construction",{"$f":"D16/K16","v":0.99509796868508882}]
["Operation, Maintenance & Replacement",72908000,{"$f":"(1+$B$8)^6 * (1+$B$7)^10 * (1 - (1+$B$8)/(1+$B$7)) * B17 / (1 - ((1+$B$8)/(1+$B$7))^41)","v":4175913.0591404703},null,"from equation 5",null,null,"Operation, Maintenance & Replacement",95113000,{"$f":"(1+$I$8)^6 * (1+$I$7)^10 * (1 - (1+$I$8)/(1+$I$7)) * I17 / (1 - ((1+$I$8)/(1+$I$7))^41)","v":3978496.7478460302},null,"from equation 5",null,4077204.9034932503,null,"Operation, Maintenance & Replacement",{"$f":"C17/J17","v":1.0496208301291994}]
["Power Opers.",284353000,{"$f":"(1+$B$8)^6 * (1+$B$7)^10 * (1 - (1+$B$8)/(1+$B$7)) * B18 / (1 - ((1+$B$8)/(1+$B$7))^41)","v":16286736.793023676},null,"from equation 5",null,null,"Power Opers.",435664000,{"$f":"(1+$I$8)^6 * (1+$I$7)^10 * (1 - (1+$I$8)/(1+$I$7)) * I18 / (1 - ((1+$I$8)/(1+$I$7))^41)","v":18223458.487836499},null,"from equation 5",null,17255097.640430085,null,"Power Opers.",{"$f":"C18/J18","v":0.89372370255045086}]
["Foregone Power",58401000,{"$f":"(1+$B$8)^6 * (1+$B$7)^10 * (1 - (1+$B$8)/(1+$B$7)) * B19 / (1 - ((1+$B$8)/(1+$B$7))^41)","v":3345003.2721630353},null,"from equation 5",null,null,"Foregone Power",88843000,{"$f":"(1+$I$8)^6 * (1+$I$7)^10 * (1 - (1+$I$8)/(1+$I$7)) * I19 / (1 - ((1+$I$8)/(1+$I$7))^41)","v":3716227.9243519278},null,"from equation 5",null,3530615.5982574816,null,"Foregone Power",0.90010713558328626]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N17:N19)","v":24862918.142180819},null,"sum"]
[]
[]
["Page 5-5, Table 5-3, Pump Storage Configuration",null,null,null,null,null,null,"Page 5-6, Table 5-4, Pump Storage Configuration"]
[null,4.1399999999999999E-2,"Discount Rate",null,null,null,null,null,0.03,"Discount Rate"]
[null,2.5000000000000001E-2,"Escalation Rate",null,null,null,null,null,2.5000000000000001E-2,"Escalation Rate"]
[]
[null,"PV, 2010$","Annual, 2026","PV, 2015$",null,null,null,null,"PV, 2010$","Annual, 2026","PV, 2015$"]
["Benefits",null,null,null,null,null,null,"Benefits",null,null,null,null,null,null,null,"Benefits"]
["Power-Inline",45167000,{"$f":"(1+$B$25)^6 * (1+$B$24)^10 * (1 - (1+$B$25)/(1+$B$24)) * B29 / (1 - ((1+$B$25)/(1+$B$24))^41)","v":2587006.4347149506},null,"from equation 5",null,null,"Power-Inline",69561000,{"$f":"(1+$I$25)^6 * (1+$I$24)^10 * (1 - (1+$I$25)/(1+$I$24)) * I29 / (1 - ((1+$I$25)/(1+$I$24))^41)","v":2909678.0910802698},null,"from equation 5",null,{"$f":"AVERAGE(C29,J29)","v":2748342.2628976102},null,"Power-Inline",{"$f":"C29/J29","v":0.88910400179508464}]
["Power-Pump Stations",1261042000,{"$f":"(1+$B$25)^6 * (1+$B$24)^10 * (1 - (1+$B$25)/(1+$B$24)) * B30 / (1 - ((1+$B$25)/(1+$B$24))^41)","v":72228037.470848426},null,"from equation 5",null,null,"Power-Pump Stations",1785425000,{"$f":"(1+$I$25)^6 * (1+$I$24)^10 * (1 - (1+$I$25)/(1+$I$24)) * I30 / (1 - ((1+$I$25)/(1+$I$24))^41)","v":74682825.229180008},null,"from equation 5",null,{"$f":"AVERAGE(C30,J30)","v":73455431.35001421},null,"Power-Pump Stations",0.96713049150459229]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N29:N30)","v":76203773.61291182},null,"sum"]
["Costs",null,null,null,null,null,null,"Costs",null,null,null,null,null,null,null,"Costs"]
["Capital Construction",1482378000,null,{"$f":"(1 -((1+B25)/(1+$I$3))^4)/(1- (1+B25)/(1+$I$3)   )*(1/(1+B25))*(1 - (1+B25)/(1+B24)   )/(1-((1+B25)/(1+B24))^4)*(1+B24)^6 *B33","v":1848441823.4440956},"from equation 6",null,null,"Capital Construction",1617637000,null,{"$f":"(1 -((1+I25)/(1+$I$3))^4)/(1- (1+I25)/(1+$I$3)   )*(1/(1+I25))*(1 - (1+I25)/(1+I24)   )/(1-((1+I25)/(1+I24))^4)*(1+I24)^6 *I33","v":1857536020.2318878},"from equation 6",null,null,{"$f":"AVERAGE(D33,K33)","v":1852988921.8379917},"Capital Construction",{"$f":"D33/K33","v":0.99510416127130774}]
["Operation, Maintenance & Replacement",96015000,5499400.5098668495,null,"from equation 5",null,null,"Operation, Maintenance & Replacement",125256000,{"$f":"(1+$I$25)^6 * (1+$I$24)^10 * (1 - (1+$I$25)/(1+$I$24)) * I34 / (1 - ((1+$I$25)/(1+$I$24))^41)","v":5239353.0710649686},null,"from equation 5",null,5369376.7904659091,null,"Operation, Maintenance & Replacement",{"$f":"C34/J34","v":1.0496335015553786}]
["Power Opers.",284353000,16286736.793023676,null,"from equation 5",null,null,"Power Opers.",435664000,{"$f":"(1+$I$25)^6 * (1+$I$24)^10 * (1 - (1+$I$25)/(1+$I$24)) * I35 / (1 - ((1+$I$25)/(1+$I$24))^41)","v":18223458.487836499},null,"from equation 5",null,17255097.640430085,null,"Power Opers.",0.89372370255045086]
["Power Pump Station Opers.",700345000,40113291.153285407,null,"from equation 5",null,null,"Power Pump Station Opers.",971635000,{"$f":"(1+$I$25)^6 * (1+$I$24)^10 * (1 - (1+$I$25)/(1+$I$24)) * I36 / (1 - ((1+$I$25)/(1+$I$24))^41)","v":40642674.37251877},null,"from equation 5",null,40377982.762902088,null,"Power Pump Station Opers.",0.98697469525796477]
["Foregone Power",58401000,{"$f":"(1+$B$25)^6 * (1+$B$24)^10 * (1 - (1+$B$25)/(1+$B$24)) * B37 / (1 - ((1+$B$25)/(1+$B$24))^41)","v":3345003.2721630353},null,"from equation 5",null,null,"Foregone Power",88843000,{"$f":"(1+$I$25)^6 * (1+$I$24)^10 * (1 - (1+$I$25)/(1+$I$24)) * I37 / (1 - ((1+$I$25)/(1+$I$24))^41)","v":3716227.9243519278},null,"from equation 5",null,3530615.5982574816,null,"Foregone Power",0.90010713558328626]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N34:N37)","v":66533072.792055562},null,"sum"]

{"sheet":"Revenues and Expenses","index":2,"n_rows":50,"n_cols":15,"rows_kept":50,"cut":false,"hidden":false,"merged":[[9,3,10,5],[13,3,14,5],[11,13,12,18],[24,5,27,7]]}
[null,"WCWCD Revenue Stream",null,null,null,null,null,null,"WCWCD Revenue Stream",null,"LPP Capital Costs"]
["Source: 2013 WCWCD Audited Financial Statement",null,null,null,null,null,null,"Source: 2013 WCWCD Audited Financial Statement"]
["Property Tax",9938660,null,"Total Service Area Property Valuation",null,10240302002,null,"Long Term Debt",null,null,"KCWCD",{"$f":"L5-L4","v":53200000}]
[null,null,null,"2013 Property Tax Collection Rate",null,{"$f":"B3/F3","v":9.7054364198037449E-4},null,"Notes Payable",1165000,null,"WCWCD",912500000,null,"Source: Facts: Lake Powell Pipeline Project - WCWCD (2012)"]
["Impact Fees",null,null,"Maximum Legal Property Tax Rate",null,1E-3,null,"GO Bonds",2680000,null,"Total",965700000,null,{"$f":"L4/L5","v":0.94491042766904831},"WCWCD share of capital costs"]
["Total",5919316,null,"Additional Revenue if use Max. Rate",null,{"$f":"(F5-F4)*F3","v":301642.00200000004},null,"Revenue Bonds",67291912]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I4:I6)","v":71136912},null,"FERC Low Cost Estimate for WCWCD (Baseline NED Assumptions)",{"$f":"N5*DSWRESR!O16","v":1328461943.8059647},null,"Source: 2012 Draft Study Report 10: Socioeconomics and Water Resource Economics - Page 5-3"]
["Cost per ERU",6102,null,null,null,null,null,"Total with interest",94317144,null,"FERC High Cost Estimate for WCWCD (Pump Storage Social Time Preference)",{"$f":"N5*DSWRESR!O33","v":1750908554.5999455},null,"Source: 2012 Draft Study Report 10: Socioeconomics and Water Resource Economics - Page 5-6"]
["Total New 2013 ERU's",{"$f":"B6/B8","v":970.06161914126517},null,null,null,null,null,"2013 Debt Payments",{"$f":"'First Scenario'!I24","v":7026322}]
[null,null,null,"Note: Equivalent Residential Unit (ERU) is the metric used to determine cost of impact fee per lot, equivalent to 1 ERU per 10,000 sq. ft. of irrigable land",null,null,null,"Operating Expenses",null,null,"LPP Operation and Power Costs"]
["Water Availability Surcharge",null,null,null,null,null,null,"General Government",4443620]
["Fee/ ERU",1.75,null,null,null,null,null,"Water and Power Utilities",8788016,null,null,null,null,"Note: Since WCWCD is responsible for 94.5% (N5) of capital costs, it was assumed they would be responsible for 94.5% of OM&R costs."]
["2013 Total",1248977,null,null,null,null,null,"Total Operating Expenses",{"$f":"SUM(I11:I12)","v":13231636}]
["Total ERU's",{"$f":"B13/B12","v":713701.14285714284},null,"Note: The Water Availability Surcharge is charged to all water bills as a monthly fee",null,null,null,null,null,null,"FERC Low Cost Estimate for WCWCD (Baseline NED Assumptions)",{"$f":"N5*DSWRESR!N20","v":23493230.614828616},null,"Source: 2012 Draft Study Report 10: Socioeconomics and Water Resource Economics - Page 5-3"]
[null,null,null,null,null,null,null,"Total Expenses",{"$f":"I13+I9","v":20257958},null,"FERC High Cost Estimate for WCWCD (Pump Storage Social Time Preference)",{"$f":"N5*DSWRESR!N38","v":62867794.266077146},null,"Source: 2012 Draft Study Report 10: Socioeconomics and Water Resource Economics - Page 5-6"]
["2013 ERU Growth",{"$f":"B9/B14","v":1.359198634960623E-3}]
[null,null,null,null,null,null,null,null,null,null,"LPP Annual Power Revenues"]
["Operating Revenues",null,null,null,null,null,null,null,null,null,"FERC Low Cost Estimate for WCWCD (Baseline NED Assumptions)",{"$f":"N5*DSWRESR!N14","v":9947746.9633827638}]
["Power sale revenue",926134,null,null,null,null,null,null,null,null,"FERC High Cost Estimate for WCWCD (Pump Storage Social Time Preference)",{"$f":"N5*DSWRESR!N31","v":72005740.314571843}]
["water sales revenue",7013377]
["Water Development and Connection Fees",1379171,null,{"$f":"B21+B19","v":2305305}]
["Total Operating Revenues",{"$f":"B19+B20+B21","v":9318682}]
[]
["Real Property"]
["Acres",1000,"Annual",1200,"Annual","According to page 7 of the 2013 WCWCDAFS the District has between 1000-1200 acres in real property that can be sold at market value for additional funds.  The District claims this property is valued between $50,000-$125,000 per acre."]
["Low Value",{"$f":"50000*B25","v":50000000},{"$f":"B26/50","v":1000000},{"$f":"50000*D25","v":60000000},{"$f":"D26/50","v":1200000}]
["High Value",{"$f":"125000*B25","v":125000000},{"$f":"B27/50","v":2500000},{"$f":"125000*D25","v":150000000},{"$f":"D27/50","v":3000000}]
["Average",{"$f":"(B27+B26)/2","v":87500000},1750000,{"$f":"(D27+D26)/2","v":105000000},2100000]
[]
[]
[null,null,null,null,null,"Assumed Price Elasticity of Demand",-0.5]
["Total Gross Revenues",{"$f":"E27+B22+B13+B6+B3","v":29425635},null,null,null,"app. GPCD w/ cons. in 2013",{"$f":"'Water Demand'!G5 + (('Water Demand'!G6-'Water Demand'!G5)/('Water Demand'!B6-'Water Demand'!B5))*(2013-'Water Demand'!B5)","v":287.8254}]
[null,null,null,null,null,"app. population in 2013",{"$f":"'Population Estimates'!E3*(1+'Population Estimates'!I10)^(2013-2010)","v":151208.58879260745}]
["Net Revenues",{"$f":"B32-I15","v":9167677},null,null,null,"app. consumption in 2013",{"$f":"G32*G33","v":43521672.552667759},"gallons per day"]
[null,null,null,null,null,"app. consumption in 2013",{"$f":"G34/1000","v":43521.672552667762},"thousand gallons per day"]
[null,null,null,null,null,"app. consumption in 2013",{"$f":"G35*365","v":15885410.481723733},"thousand gallons per year"]
[null,null,null,null,null,{"$f":"A20","v":"water sales revenue"},{"$f":"B20","v":7013377},"per year"]
[null,null,null,null,null,"implied 2013 wholesale price of water",{"$f":"G37/G36","v":0.44149800271569534},"per thousand gallons"]
[null,null,null,null,null,"implied 2013 wholesale price of water",{"$f":"G38/1000","v":4.4149800271569531E-4},"per gallon"]
[null,null,null,null,null,"implied 2013 wholesale price of water",{"$f":"G39*325853","v":143.86344867891745},"per acre-foot"]
[null,null,null,null,null,"2013 retail price of water, 15,000--20,000 gallons monthly usage",1,"per thousand gallons","https://web.archive.org/web/20140604140321/www.sgcity.org/departments/finance/utilities#tab-3"]
[null,null,null,null,null,"2013 difference between wholesale and retail price of water",{"$f":"G41-G38","v":0.55850199728430461},"per thousand gallons"]
[null,null,null,null,null,"2013 difference between wholesale and retail price of water",{"$f":"G42/1000","v":5.585019972843046E-4},"per gallon"]
[null,null,null,null,null,"2013 difference between wholesale and retail price of water",{"$f":"G43*325853","v":181.9895513210825},"per acre-foot"]
[null,null,null,null,null,"2013 ratio of retail to wholesale price of water",{"$f":"G41/G38","v":2.2650159091296151}]
[null,null,null,null,null,"app. consumption in 2013",{"$f":"G36*1000","v":15885410481.723734},"gallons per year"]
[null,null,null,null,null,"app. consumption in 2013",{"$f":"G46/325853","v":48750.235479568189},"acre-feet per year"]
[null,null,null,null,null,null,"If 2013 quantity (in acre-feet/yr) is equal to a constant times 2013 population times (2013 retail price)^(G31), what is the constant?"]
[null,null,null,null,null,null,{"$f":"G47/(G33*(G50^(G31)))","v":5.8198409964896438}]
[null,null,null,null,null,"2013 retail price of water, 15,000--20,000 gallons monthly usage",{"$f":"(G41/1000)*325853","v":325.85300000000001},"per acre-foot"]

{"sheet":"First Scenario","index":3,"n_rows":75,"n_cols":22,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Revenues and Expenses'!B3","v":9938660},"2013 Property Tax Collections",null,null,-0.5,"<-Never change this elasticity",null,null,"2013 water sales revenue",{"$f":"'Revenues and Expenses'!B20","v":7013377},null,null,null,"Scenario A","Scenario B","DSWRESR!i3 gives the FERC \"escalation rate\""]
[null,{"$f":"'Revenues and Expenses'!B20","v":7013377},"2013 water sales revenue Revenue",null,null," here; change it in 'Revenues and Expenses'G31",null,null,2013,"population",{"$f":"'Population Estimates'!$E$3*(1+'Population Estimates'!$I$10)^(I2-2010)","v":151208.58879260745},null,null,null,"FERC Low Cost","FERC High Cost Estimate"]
[null,{"$f":"'Revenues and Expenses'!B8","v":6102},"2013 Impact Fee per ERU",null,null,null,null,null,null,"2013 retail price of water, $/ac-ft",325.85300000000097,null,null,"Cost Estimate",{"$f":"'Revenues and Expenses'!L7","v":1328461943.8059647},{"$f":"'Revenues and Expenses'!$L$8","v":1750908554.5999455},null,null,"retail p, $/ac-ft"," = $/1000 gallons","whlsl p, $/ac-ft"," = $/1000 gallons"]
[null,{"$f":"'Population Estimates'!I9","v":3.3094116200343082E-2},"GOPB 50-Year Household Growth Rate Projection",null,null,null,{"$f":"EXP('Population Estimates'!I10*(A73-A24))","v":4.1578977495525988},"Factor by which # of people will grow, 2015--2064",null,null,null,null,null,"LPP O&M Costs (Column K)",{"$f":"'Revenues and Expenses'!$L$14","v":23493230.614828616},{"$f":"'Revenues and Expenses'!$L$15","v":62867794.266077146},null,null,{"$f":"K3","v":325.85300000000097},{"$f":"S4*'Revenues and Expenses'!$G$39/'Revenues and Expenses'!$G$40*1000","v":1.0000000000000031},{"$f":"S4-'Revenues and Expenses'!$G$44","v":143.86344867891847},{"$f":"U4*'Revenues and Expenses'!$G$39/'Revenues and Expenses'!$G$40*1000","v":0.44149800271569845}]
[null,{"$f":"1+B4","v":1.0330941162003431},"GOPB 50-Year Household Growth Rate Projection, plus one.",null,null,null,null,null,null,null,null,null,null,"LPP Power sale revenue (Column F)",{"$f":"'Revenues and Expenses'!$L$18","v":9947746.9633827638},{"$f":"'Revenues and Expenses'!$L$19","v":72005740.314571843},null,null,{"$f":"M10","v":1904.1786019837382},{"$f":"S5*'Revenues and Expenses'!$G$39/'Revenues and Expenses'!$G$40*1000","v":5.8436736871648822},{"$f":"S5-'Revenues and Expenses'!$G$44","v":1722.1890506626557},{"$f":"U5*'Revenues and Expenses'!$G$39/'Revenues and Expenses'!$G$40*1000","v":5.2851716898805776}]
[null,1.04,"<- enter 1 plus assumed interest rate on reserves (the interest rate on savings)",null,null,null,null,null,null,null,null,null,null,"A","<- enter A or B (capitalized) for which Scenario you want to analyze",null,null,null,{"$f":"K20","v":555.36976533324855},{"$f":"S6*'Revenues and Expenses'!$G$39/'Revenues and Expenses'!$G$40*1000","v":1.7043567661898114},{"$f":"S6-'Revenues and Expenses'!$G$44","v":373.38021401216605},{"$f":"U6*'Revenues and Expenses'!$G$39/'Revenues and Expenses'!$G$40*1000","v":1.1458547689055067}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N$6=\"A\", $O$3,$P$3)","v":1328461943.8059647},"Loan Amount"]
[null,{"$f":"G4^2","v":17.288113695734566},"If water price rises by a factor > this, (Q_2060 under new water price) < (Q_2010 under current water price).",null,null,null,null,null,null,null,null,"2013 water sales revenue",{"$f":"K1*B11","v":34730782.092977792},{"$f":"A73","v":2064},"year when all debt has to be paid back"]
[null,null,"Given unchanged impact fees: (see Column P)",null,null,null,null,null,null,null,2013,"population",{"$f":"'Population Estimates'!$E$3*(1+'Population Estimates'!$I$10)^(K9-2010)","v":151208.58879260745},{"$f":"A24","v":2015},"initial year of spreadsheet"]
[null,{"$f":"S75","v":3.9520768800789963},"The factor by which water sales revenue needs to increase to eliminate the debt by 2062, minus one",null,null,null,null,null,null,null,null,"2013 retail price of water, $/ac-ft",1904.1786019837382,10,"<- enter number of initial payment-free years (can be zero); water rates & impact fees don't change during this time"]
[null,{"$f":"B10+1","v":4.9520768800789963},"The factor by which water sales revenue needs to increase to eliminate the debt by 2062.",null,null,null,null,null,{"$f":"'Population Estimates'!I12*B13/G4","v":29.34980583997584},"gal/per person/day in 2064 w/ these water rate increases",null,null,null,0.04,"<- enter interest rate (the interest rate on debt)",null,null,null,null,null,"Total Expected Project Costs"]
[null,{"$f":"M10/K3","v":5.8436736871648645},"The factor by which retail water prices need to increase to eliminate the debt by 2062.",null,null,null,null,null,"whlsle p ratio->",{"$f":"(M10-'Revenues and Expenses'!G44)/(K3-'Revenues and Expenses'!G44)","v":11.970997960060878},null,null,null,{"$f":"N8-N9+1-N10","v":40},"years allowed for paying back the loan",null,null,null,null,null,"Cost w/ interest and O&M",{"$f":"K74+L74","v":3974072985.6908178}]
[null,{"$f":"M10^(F1)/K3^(F1)","v":0.41367285305708906},"The factor by which water demanded will change vs. the base case when water prices rise enough to eliminate debt by 2062",null,null,null,null,null,null,null,null,null,null,{"$f":"N7*(1+N11)^N10","v":1966448200.0502944},"Loan Amount after initial years of negative amortization",null,null,null,null,null,"minus power sale revenue",{"$f":"V12-G74","v":3974072985.6908178}]
[null,null,"Given unchanged water prices: (see Column R)",null,null,null,null,null,null,null,null,null,null,{"$f":"-PMT(N11,N12,N13)","v":99351824.642270356},"Annual Debt Service"]
[null,{"$f":"U75","v":3.1472867975120318},"The factor by which Impact Fees need to increase to eliminate the debt by 2062, minus one.",null,null,null,null,null,"If any of these ->",{"$f":"(K3 - 'Revenues and Expenses'!G44)*'Revenues and Expenses'!G49*K2* K3^F1-K1","v":3.8184225559234619E-8},{"$f":"(M10 - 'Revenues and Expenses'!G44)*'Revenues and Expenses'!G49*M9* M10^F1-M8","v":0},{"$f":"(K20 - 'Revenues and Expenses'!G44)*'Revenues and Expenses'!G49*K19* K20^F1-K18","v":2.0861625671386719E-7},"or","this ->",{"$f":"R73","v":8.9406967163085938E-7},"or this ->",{"$f":"T73","v":7.4505805969238281E-7},"is not zero,"]
[null,{"$f":"B15+1","v":4.1472867975120318},"The factor by which Impact Fees need to increase to eliminate the debt by 2062.",null,null,null,null,null,null,null,null,null,null,null,"click on this button ->",null,"to make them zero."]
[null,{"$f":"B3*B16","v":25306.744038418419},"2013 average Impact Fee per ERU, if Impact Fees increased as much as needed to eliminate the debt by 2062.",null,null,null,null,null,null,null,null,null,null,"(This will ensure that R75 and T75 change in order to make Q73, S73, and hence U73 equal to zero.)"]
[null,null,"Given Split Between Impact Fees and Water Rates: (see Column T)",null,null,null,null,null,null,"2013 water sales revenue",{"$f":"K1*B19","v":13942728.273244448},null,0.75,"<- enter Impact Fees' portion of Split financing"]
[null,{"$f":"B10*$M$19 + 1","v":1.9880192200197491},"The factor by which water sales revenue needs to increase to eliminate the debt by 2062.",null,null,null,null,null,2013,"population",{"$f":"'Population Estimates'!$E$3*(1+'Population Estimates'!$I$10)^(I19-2010)","v":151208.58879260745},null,{"$f":"1-M18","v":0.25},"Water Rates"]
[null,{"$f":"K20/K3","v":1.704356766189806},"The factor by which retail water prices need to increase to eliminate the debt by 2062.",null,null,null,null,null,null,"2013 retail price of water, $/ac-ft",555.36976533324855,"whlsle p ratio->",{"$f":"(K20-'Revenues and Expenses'!G44)/(K3-'Revenues and Expenses'!G44)","v":2.5953792811229932}]
[null,{"$f":"1+B15*$M$18","v":3.3604650981340241},"The factor by which Impact Fees need to increase to eliminate the debt by 2062.",null,null,null,null,null,null,{"$f":"K20^(F1)/K3^(F1)","v":0.76598408351305525},"The factor by which water demanded will change vs. 2013 if water prices behave this way."]
[null,{"$f":"B3*B21","v":20505.558028813815},"2013 average Impact Fee per ERU, if Impact Fees increased as much as needed to eliminate the debt by 2062.",null,null,null,null,null,null,{"$f":"'Population Estimates'!I12*J21/G4","v":54.346046547360572},"gal/per person/day in 2064 w/ these water rate increases"]
["Year","Property Taxes","water sales revenue","Power sale revenue and Surcharges","Impact Fees","Real Estate sale revenue","LPP Power sale revenue","TOTAL REVENUES ","Annual Debt Service on Existing Debt","Existing O&M Costs","Annual LPP Debt Service","LPP O&M Costs","Total Annual Debt Service","TOTAL EXPENSES","Net Annual Surplus (Deficit) ","Cumulative  Surplus (Deficit)  ","Repayment Option 1: Annual Surplus (Deficit) w/ Increased Water Rate sale revenue","Repayment Option 1: Cumulative Surplus (Deficit) w/  Increased Water Rate sale revenue","Repayment Option 2: Annual Surplus (Deficit) w/ Increased Impact Fees","Repayment Option 2: Cumulative Surplus (Deficit) w/  Increased Impact Fees","Repayment Option 3: Annual Surplus (Deficit) w/  50/50 Split Between Impact Fees and Water Rates","Repayment Option 3: Cumulative Surplus (Deficit) w/ Split Between Impact Fees and Water Rates"]
[2015,{"$f":"'Revenues and Expenses'!B3*B5","v":10267571.168915702},{"$f":"'Revenues and Expenses'!B20*$B$5^2","v":7485261.2212441899},{"$f":"('Revenues and Expenses'!B19+'Revenues and Expenses'!B21) * $B$5","v":2381597.0315472321},{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A24-$A$24)*$B$4","v":9399311.1264014002},{"$f":"'Revenues and Expenses'!$D$27/10","v":15000000},0,{"$f":"B24+C24+E24+D24+G24+F24","v":44533740.548108526},7026322,{"$f":"'Revenues and Expenses'!I13","v":13231636},{"$f":"IF(ROW()-24<$N$10,0,$N$14)","v":0},0,{"$f":"K24+I24","v":7026322},{"$f":"J24+M24+L24","v":20257958},{"$f":"H24-N24","v":24275782.548108526},{"$f":"O24","v":24275782.548108526},{"$f":"IF(ROW()-24<$N$10,O24,O24+$B$10*C24)","v":24275782.548108526},{"$f":"Q24","v":24275782.548108526},{"$f":"IF(ROW()-24<$N$10,O24,O24+$B$15*E24)","v":24275782.548108526},{"$f":"S24","v":24275782.548108526},{"$f":"IF(ROW()-24<$N$10,O24,O24 + $M$19*C24*$B$10 + $M$18*E24*$B$15)","v":24275782.548108526},{"$f":"U24","v":24275782.548108526}]
[{"$f":"A24+1","v":2016},{"$f":"B24*$B$5","v":10607367.36227509},{"$f":"C24*$B$5","v":7732979.3258899674},{"$f":"D24*$B$5","v":2460413.8804516485},{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A25-$A$24)*$B$4","v":9710373.0210217051},{"$f":"'Revenues and Expenses'!$D$27/10","v":15000000},0,{"$f":"B25+C25+E25+D25+G25+F25","v":45511133.589638412},7039458,{"$f":"J24*$B$5","v":13669525.299304644},0,0,{"$f":"K25+I25","v":7039458},{"$f":"J25+M25+L25","v":20708983.299304642},24802150.29033377,{"$f":"P24*$B$6+O25","v":50048964.140366636},{"$f":"IF(ROW()-24<$N$10,O25,O25+$B$10*C25)","v":24802150.29033377},{"$f":"R24*$B$6+Q25","v":50048964.140366636},{"$f":"IF(ROW()-24<$N$10,O25,O25+$B$15*E25)","v":24802150.29033377},{"$f":"T24*$B$6+S25","v":50048964.140366636},{"$f":"IF(ROW()-24<$N$10,O25,O25 + $M$19*C25*$B$10 + $M$18*E25*$B$15)","v":24802150.29033377},{"$f":"V24*$B$6+U25","v":50048964.140366636}]
[{"$f":"A25+1","v":2017},10958408.810341949,7988895.4422758203,2541839.1033122526,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A26-$A$24)*$B$4","v":10031729.234128073},{"$f":"'Revenues and Expenses'!$D$27/10","v":15000000},0,46520872.590058096,7048107,14121906.157963362,0,0,7048107,{"$f":"J26+M26+L26","v":21170013.157963362},25350859.432094734,77401782.138076037,25350859.432094734,77401782.138076037,25350859.432094734,77401782.138076037,25350859.432094734,77401782.138076037]
[2018,11321067.664882269,8253280.8763548872,2625959.021959844,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A27-$A$24)*$B$4","v":10363720.447092688},{"$f":"'Revenues and Expenses'!$D$27/10","v":15000000},0,47564028.010289684,7048318,14589258.161325341,0,0,7048318,21637576.161325343,25926451.848964341,106424305.27256343,25926451.848964341,106424305.27256343,25926451.848964341,106424305.27256343,25926451.848964341,106424305.27256343]
[2019,11695728.393695829,{"$f":"C27*$B$5","v":8526415.9127110448},{"$f":"D27*$B$5","v":2712862.8149699224},{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A28-$A$24)*$B$4","v":10706698.615836641},{"$f":"'Revenues and Expenses'!$D$27/10","v":15000000},0,48641705.737213433,7050648,15072076.766193045,0,0,7050648,{"$f":"J28+M28+L28","v":22122724.766193047},26518980.971020386,137200258.45448637,26518980.971020386,137200258.45448637,26518980.971020386,137200258.45448637,26518980.971020386,137200258.45448637]
[2020,12082788.188204451,8808590.1116987579,2802642.612204127,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A29-$A$24)*$B$4","v":11061027.343951194},{"$f":"'Revenues and Expenses'!$D$27/10","v":15000000},0,49755048.256058529,6451090,15570873.82607393,0,0,6451090,22021963.82607393,27733084.429984599,170421353.22265044,27733084.429984599,170421353.22265044,27733084.429984599,170421353.22265044,27733084.429984599,170421353.22265044]
[2021,12482657.384529021,9100102.6164165102,2895393.5924804434,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A30-$A$24)*$B$4","v":11427082.268167086},{"$f":"'Revenues and Expenses'!$D$27/10","v":15000000},0,50905235.86159306,6456332,16086178.133814901,0,0,6456332,22542510.133814901,28362725.727778159,205600933.07933462,28362725.727778159,205600933.07933462,28362725.727778159,205600933.07933462,28362725.727778159,205600933.07933462]
[2022,12895759.898501694,9401262.4698392451,2991214.0844757198,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A31-$A$24)*$B$4","v":11805251.456580687},{"$f":"'Revenues and Expenses'!$D$27/10","v":15000000},0,52093487.909397341,6138580,16618535.982194789,0,0,6138580,22757115.982194789,29336371.927202553,243161342.32971057,29336371.927202553,243161342.32971057,29336371.927202553,243161342.32971057,29336371.927202553,243161342.32971057]
[2023,13322533.675074434,9712388.9424460288,3090205.670967462,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A32-$A$24)*$B$4","v":12195935.820059035},{"$f":"'Revenues and Expenses'!$D$27/10","v":15000000},0,53321064.108546957,5095230,17168511.743069127,0,0,5095230,22263741.743069127,31057322.36547783,283945118.38837683,31057322.36547783,283945118.38837683,31057322.36547783,283945118.38837683,31057322.36547783,283945118.38837683]
[2024,13763431.152600331,10033811.870690266,3192473.2965254183,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A33-$A$24)*$B$4","v":12599549.537259996},{"$f":"'Revenues and Expenses'!$D$27/10","v":15000000},0,54589265.857076012,5101740,17736688.46568121,0,0,5101740,22838428.46568121,31750837.391394801,327053760.51530671,31750837.391394801,327053760.51530671,31750837.391394801,327053760.51530671,31750837.391394801,327053760.51530671]
[2025,14218919.742479909,10365872.00667127,3298125.378767123,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A34-$A$24)*$B$4","v":13016520.493718058},0,0,40899437.621636361,5109185,18323668.494773749,99351824.642270356,0,104461009.64227036,122784678.1370441,-81885240.515407741,258250670.42051125,-40918517.415984139,299217393.51993483,-40918517.415984102,299217393.51993489,-40918517.415984116,299217393.51993489]
[2026,14689482.324680891,10708921.379377933,3407273.9232953428,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A35-$A$24)*$B$4","v":13447290.73546131},0,{"$f":"IF($N$6=\"A\", $O$5,$P$5)","v":9947746.9633827638},52200715.326198243,5099965,18930074.109156359,99351824.642270356,{"$f":"IF($N$6=\"A\", $O$4,$P$4)","v":23493230.614828616},104451789.64227036,146875094.36625534,-94674379.040057093,173906318.1972746,-52351898.446033888,258834190.81469834,-52351898.44603385,258834190.81469846,-52351898.446033858,258834190.81469843]
[2027,15175617.759656766,11063323.667887405,3520034.6424392778,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A36-$A$24)*$B$4","v":13892316.937640462},0,{"$f":"G35*(1+DSWRESR!$I$3)","v":10345656.841918075},53996949.849541984,3178350,19556548.181405887,99351824.642270356,{"$f":"L35*(1+DSWRESR!$I$3)","v":24432959.83942176},102530174.64227036,146519682.66309801,-92522732.813556015,88339838.111609578,-48799627.128867447,220387931.31841886,-48799627.12886741,220387931.31841901,-48799627.128867418,220387931.31841895]
[2028,15677841.417206837,11429454.586914476,3636527.0779253966,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A37-$A$24)*$B$4","v":14352070.888666729},0,{"$f":"G36*(1+DSWRESR!$I$3)","v":10759483.115594799},55855377.086308233,3178995,20203754.859398942,99351824.642270356,{"$f":"L36*(1+DSWRESR!$I$3)","v":25410278.232998632},102530819.64227036,148144852.73466793,-92289475.648359686,-416044.01228572428,-47119392.423502147,182084056.14765349,-47119392.423502117,182084056.14765367,-47119392.423502117,182084056.14765361]
[2029,16196685.722838432,11807702.285120368,3756874.7276079538,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A38-$A$24)*$B$4","v":14827039.990371825},0,{"$f":"G37*(1+DSWRESR!$I$3)","v":11189862.44021859},57778165.166157164,3188875,20872380.270399138,99351824.642270356,{"$f":"L37*(1+DSWRESR!$I$3)","v":26426689.362318579},102540699.64227036,149839769.27498809,-92061604.108830929,-92494289.881608084,-45396656.900950789,143970761.49260885,-45396656.90095076,143970761.49260905,-45396656.900950767,143970761.49260899]
[2030,16732700.722210484,12198467.756603198,3881205.1763935438,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A39-$A$24)*$B$4","v":15317727.774720324},0,{"$f":"G38*(1+DSWRESR!$I$3)","v":11637456.937827334},59767558.367754884,1786290,21563133.248445477,99351824.642270356,{"$f":"L38*(1+DSWRESR!$I$3)","v":27483756.936811324},101138114.64227036,150185004.82752717,-90417446.459772289,-186611507.9366447,-42208164.066511691,107521427.88580152,-42208164.066511661,107521427.88580176,-42208164.066511668,107521427.8858017]
[2031,17286454.664256882,12602165.266006364,4009650.231498485,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A40-$A$24)*$B$4","v":15824654.437622139},0,{"$f":"G39*(1+DSWRESR!$I$3)","v":12102955.215340428},61825879.814724296,1610460,22276746.085813012,99351824.642270356,{"$f":"L39*(1+DSWRESR!$I$3)","v":28583107.214283779},100962284.64227036,151822137.94236714,-89996258.12764284,-284072226.38175333,-40191532.140924513,71630752.860309079,-40191532.140924498,71630752.860309333,-40191532.140924506,71630752.860309273]
[2032,17858534.603607763,13019222.787695505,4142346.0621824283,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A41-$A$24)*$B$4","v":16348357.390411083},0,{"$f":"G40*(1+DSWRESR!$I$3)","v":12587073.423954045},63955534.267850824,1610460,23013975.309342444,99351824.642270356,{"$f":"L40*(1+DSWRESR!$I$3)","v":29726431.502855133},100962284.64227036,153702691.45446792,-89747157.186617106,-385182272.62364054,-38294187.810768083,36201795.163953364,-38294187.810768053,36201795.163953662,-38294187.81076806,36201795.16395358]
[2033,18449547.022947405,13450082.459469654,4279433.3441063268,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A42-$A$24)*$B$4","v":16889391.829574082},0,{"$f":"G41*(1+DSWRESR!$I$3)","v":13090556.360912208},66159011.017009676,1610460,23775602.48246165,99351824.642270356,{"$f":"L41*(1+DSWRESR!$I$3)","v":30915488.762969341},100962284.64227036,155653375.88770133,-89494364.870691657,-490083928.39927781,-36338604.947465599,1311262.0230458975,-36338604.947465569,1311262.0230462402,-36338604.947465576,1311262.0230461508]
[2034,19060118.475968521,13895201.051287539,4421057.4084678041,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A43-$A$24)*$B$4","v":17448331.325335134},0,{"$f":"G42*(1+DSWRESR!$I$3)","v":13614178.615348697},68438886.876407698,1610460,24562435.033749402,99351824.642270356,{"$f":"L42*(1+DSWRESR!$I$3)","v":32152108.313488115},100962284.64227036,157676827.98950788,-89237941.113100186,-598925226.64834917,-34323038.294257335,-32959325.790289603,-34323038.294257306,-32959325.790289216,-34323038.29425732,-32959325.790289324]
[2035,19690896.251604531,14355050.449505979,4567368.3960720254,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A44-$A$24)*$B$4","v":18025768.429717857},0,{"$f":"G43*(1+DSWRESR!$I$3)","v":14158745.759962644},70797829.286863029,110460,25375307.112919681,99351824.642270356,{"$f":"L43*(1+DSWRESR!$I$3)","v":33438192.64602764},99462284.642270356,158275784.4012177,-87477955.11435467,-710360190.82863784,-30745692.120494485,-65023390.942395672,-30745692.12049447,-65023390.942395255,-30745692.12049447,-65023390.942395367]
[2036,20342549.060244031,14830118.157143718,4718521.4165014075,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A45-$A$24)*$B$4","v":18622315.304731414},0,{"$f":"G44*(1+DSWRESR!$I$3)","v":14725095.59036115},73238599.52898173,110460,26215080.475134037,99351824.642270356,{"$f":"L44*(1+DSWRESR!$I$3)","v":34775720.351868749},99462284.642270356,160453085.46927315,-87214485.94029142,-825989084.40207481,-28604718.842604004,-96229045.422695518,-28604718.842603989,-96229045.422695071,-28604718.842603996,-96229045.422695175]
[2037,21015767.742654927,15320907.81070105,4874676.7125529125,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A46-$A$24)*$B$4","v":19238604.371345628},0,{"$f":"G45*(1+DSWRESR!$I$3)","v":15314099.413975596},75764056.051230103,110460,27082645.39457947,99351824.642270356,{"$f":"L45*(1+DSWRESR!$I$3)","v":36166749.165943503},99462284.642270356,162711679.20279333,-86947623.151563227,-945976270.92972112,-26398217.611069895,-126476424.85067323,-26398217.611069873,-126476424.85067275,-26398217.61106988,-126476424.85067287]
[2038,21711266.002369773,15827939.714083135,5035999.8301172452,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A47-$A$24)*$B$4","v":19875288.979943369},0,{"$f":"G46*(1+DSWRESR!$I$3)","v":15926663.390534621},78377157.917048141,110460,27978921.608280368,99351824.642270356,{"$f":"L46*(1+DSWRESR!$I$3)","v":37613419.132581241},99462284.642270356,165054625.38313195,-86677467.46608381,-1070492789.2329937,-24124232.86277169,-155659714.70747185,-24124232.862771668,-155659714.70747134,-24124232.862771668,-155659714.70747146]
[2039,22429781.162308756,16351751.390193028,5202661.7936800532,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A48-$A$24)*$B$4","v":20533044.102961008},0,{"$f":"G47*(1+DSWRESR!$I$3)","v":16563729.926156007},81080968.375298858,110460,28904859.29114509,99351824.642270356,{"$f":"L47*(1+DSWRESR!$I$3)","v":39117955.897884496},99462284.642270356,167485099.83129993,-86404131.456001073,-1199716632.2583146,-21780752.838019617,-183666856.13379034,-21780752.838019617,-183666856.13378981,-21780752.838019617,-183666856.13378993]
[2040,23172074.94644247,16892898.150779199,5374839.2876311867,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A49-$A$24)*$B$4","v":21212567.050451171},0,{"$f":"G48*(1+DSWRESR!$I$3)","v":17226279.123202249},83878658.55850628,110460,29861440.063280813,99351824.642270356,{"$f":"L48*(1+DSWRESR!$I$3)","v":40682674.133799873},99462284.642270356,170006398.83935106,-86127740.280844778,-1333833037.8294919,-19365708.061621077,-210379238.44076303,-19365708.06162107,-210379238.44076249,-19365708.061621077,-210379238.44076261]
[2041,23938934.287323095,17451953.685141645,5552714.8435742222,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A50-$A$24)*$B$4","v":21914578.209326368},0,{"$f":"G49*(1+DSWRESR!$I$3)","v":17915330.288130339},86773511.313495681,110460,30849678.030644611,99351824.642270356,{"$f":"L49*(1+DSWRESR!$I$3)","v":42309981.099151872},99462284.642270356,172621943.77206683,-85848432.458571151,-1473034791.8012428,-16876969.787313417,-235671377.76570696,-16876969.787313417,-235671377.76570642,-16876969.787313417,-235671377.76570654]
[2042,24731172.160340142,18029510.66832073,5736477.0338348374,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A51-$A$24)*$B$4","v":22639821.807067323},0,{"$f":"G50*(1+DSWRESR!$I$3)","v":18631943.499655552},89768925.16921857,110460,31870620.860133935,99351824.642270356,{"$f":"L50*(1+DSWRESR!$I$3)","v":44002380.343117945},99462284.642270356,175335285.84552222,-85566360.676303655,-1617522544.1495962,{"$f":"IF(ROW()-24<$N$10,O51,O51+$B$10*C51)","v":-14312348.404895678},-259410581.28123093,-14312348.404895678,-259410581.28123039,-14312348.404895678,-259410581.28123051]
[2043,25549628.445585128,18626181.389413461,5926320.6713731671,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A52-$A$24)*$B$4","v":23389066.700705465},0,{"$f":"G51*(1+DSWRESR!$I$3)","v":19377221.239641774},92868418.446719006,110460,32925350.890256286,99351824.642270356,{"$f":"L51*(1+DSWRESR!$I$3)","v":45762475.556842662},99462284.642270356,178150111.0893693,-85281692.642650291,-1767505138.5582304,-11669591.809391677,-281456596.34187186,-11669591.809391692,-281456596.34187132,-11669591.809391685,-281456596.34187144]
[2044,26395170.818238914,19242598.400683377,6122447.016312086,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A53-$A$24)*$B$4","v":24163107.191916186},0,{"$f":"G52*(1+DSWRESR!$I$3)","v":20152310.089227445},96075633.516378015,110460,34014986.278555498,99351824.642270356,{"$f":"L52*(1+DSWRESR!$I$3)","v":47592974.579116367},99462284.642270356,181070245.49994221,-84994611.983564198,-1923199956.0841238,-8946383.7315783501,-301661243.9271251,-8946383.731578365,-301661243.92712456,-8946383.7315783575,-301661243.92712468]
[2045,27268695.668425616,19879415.188152127,6325063.9893003618,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A54-$A$24)*$B$4","v":24962763.869086802},0,{"$f":"G53*(1+DSWRESR!$I$3)","v":20958402.492796544},99394341.207761437,110460,35140682.187011085,99351824.642270356,{"$f":"L53*(1+DSWRESR!$I$3)","v":49496693.56228102},99462284.642270356,{"$f":"J54+M54+L54","v":184099660.39156246},-84705319.183801025,-2084833273.5112898,-6140342.0292137563,-319868035.71342385,-6140342.0292137712,-319868035.71342331,-6140342.0292137638,-319868035.71342349]
[2046,28171129.051508285,20537306.864383698,6534386.391936874,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A55-$A$24)*$B$4","v":25788884.477252088},0,{"$f":"G54*(1+DSWRESR!$I$3)","v":21796738.592508405},102828445.37758934,110460,36303632.006667353,99351824.642270356,{"$f":"L54*(1+DSWRESR!$I$3)","v":51476561.304772265},99462284.642270356,187242477.95370996,-84414032.576120615,-2252640637.0278625,-3249016.9383021444,-335911774.08026296,-3249016.9383021444,-335911774.08026242,-3249016.9383021519,-335911774.0802626]
[2047,29103427.669833761,21216970.884195715,6750636.1344895735,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A56-$A$24)*$B$4","v":26642344.816819493},0,{"$f":"G55*(1+DSWRESR!$I$3)","v":22668608.136208743},106381987.64154729,110460,37505068.622790501,{"$f":"IF(ROW()-24<$N$10,0,$N$14)","v":99351824.642270356},{"$f":"L55*(1+DSWRESR!$I$3)","v":53535623.756963156},99462284.642270356,{"$f":"J56+M56+L56","v":190502977.02202401},{"$f":"H56-N56","v":-84120989.380476713},-2426867251.8894539,-269889.28373761475,-349618134.32721108,-269889.28373761475,-349618134.32721055,-269889.2837376073,-349618134.32721072]
[2048,{"$f":"B56*$B$5","v":30066579.886967517},{"$f":"C56*$B$5","v":21919127.784056585},6974042.4711506059,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A57-$A$24)*$B$4","v":27524049.672036927},0,{"$f":"G56*(1+DSWRESR!$I$3)","v":23575352.461657092},110059152.27586873,110460,{"$f":"J56*$B$5","v":38746265.721894972},99351824.642270356,{"$f":"L56*(1+DSWRESR!$I$3)","v":55677048.707241684},99462284.642270356,193885599.07140702,-83826446.795538291,{"$f":"P56*$B$6+O57","v":-2607768388.7605705},2799631.3513288945,-360803228.34897065,2799631.3513288945,-360803228.34897006,2799631.3513288945,-360803228.34897023]
[2049,31061606.775493719,22644521.945952322,7204842.2430769922,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A58-$A$24)*$B$4","v":28434933.770187326},0,{"$f":"G57*(1+DSWRESR!$I$3)","v":24518366.560123377},113864271.29483372,110460,40028539.142024733,99351824.642270356,{"$f":"L57*(1+DSWRESR!$I$3)","v":57904130.655531354},99462284.642270356,197394954.43982643,-83530683.144992709,-2795609807.4559865,5962208.4980469048,-369273148.98488259,5962208.4980468899,-369273148.984882,5962208.4980468974,-369273148.98488218]
[2050,32089563.199491274,23393922.386532888,7443280.1294745225,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A59-$A$24)*$B$4","v":29375962.772526972},0,{"$f":"G58*(1+DSWRESR!$I$3)","v":25499101.222528312},117801829.71055397,110460,41353248.267720878,99351824.642270356,{"$f":"L58*(1+DSWRESR!$I$3)","v":60220295.88175261},99462284.642270356,201035828.79174384,-83233999.081189871,-2990668198.8354158,9220580.7169892043,-374823494.22728866,9220580.7169892043,-374823494.22728807,9220580.7169892043,-374823494.22728825]
[2051,33151538.932833493,24168123.572374616,7689608.9069910571,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A60-$A$24)*$B$4","v":30348134.298017923},0,{"$f":"G59*(1+DSWRESR!$I$3)","v":26519065.271429446},121876470.98164654,110460,42721797.471154466,99351824.642270356,{"$f":"L59*(1+DSWRESR!$I$3)","v":62629107.717022717},99462284.642270356,204813189.83044755,-82936718.848801017,-3193231645.6376338,12577563.556472898,-377238870.43990731,12577563.556472868,-377238870.43990672,12577563.556472883,-377238870.4399069]
[2052,34248659.814496882,24967946.262223031,7944089.7176942127,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A61-$A$24)*$B$4","v":31352478.980940148},0,{"$f":"G60*(1+DSWRESR!$I$3)","v":27579827.882286623},126093002.65764089,0,44135637.600952372,99351824.642270356,{"$f":"L60*(1+DSWRESR!$I$3)","v":65134272.025703631},99351824.642270356,208621734.26892635,-82528731.611285463,-3403489643.0744247,16146511.554700971,-376181913.70280266,16146511.554700941,-376181913.70280206,16146511.554700941,-376181913.7028023]
[2053,35382088.942103863,25794238.377108961,8206992.3459175359,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A62-$A$24)*$B$4","v":32390061.563504193},0,{"$f":"G61*(1+DSWRESR!$I$3)","v":28683020.997578088},130456402.22621264,0,45596267.520294525,99351824.642270356,{"$f":"L61*(1+DSWRESR!$I$3)","v":67739642.906731784},99351824.642270356,212687735.06929666,-82231332.843084022,-3621860561.6404858,19709480.286334679,-371519709.96458006,19709480.286334649,-371519709.96457952,19709480.286334656,-371519709.96457976]
[2054,36553027.904964723,26647875.899260353,8478595.5042686574,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A63-$A$24)*$B$4","v":33461982.024623066},0,{"$f":"G62*(1+DSWRESR!$I$3)","v":29830341.837481212},134971823.170598,0,47105235.695913084,99351824.642270356,{"$f":"L62*(1+DSWRESR!$I$3)","v":70449228.623001054},99351824.642270356,216906288.9611845,-81934465.790586501,-3848669449.8966918,23379988.454094633,-363000509.90906864,23379988.454094604,-363000509.90906811,23379988.454094604,-363000509.90906841]
[2055,37762718.057926007,27529763.800762799,8759187.1291026305,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A64-$A$24)*$B$4","v":34569376.746039733},0,{"$f":"G63*(1+DSWRESR!$I$3)","v":31023555.510980461},139644601.24481162,0,48664141.839678183,99351824.642270356,{"$f":"L63*(1+DSWRESR!$I$3)","v":73267197.767921105},99351824.642270356,221283164.24986964,-81638563.00505802,-4084254790.8976173,27161180.025972307,-350359350.27945912,27161180.025972277,-350359350.27945852,27161180.025972284,-350359350.27945882]
[2056,39012441.837375805,28440837.002953243,9049064.6857737023,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A65-$A$24)*$B$4","v":35713419.717046611},0,{"$f":"G64*(1+DSWRESR!$I$3)","v":32264497.731419679},144480260.97456905,0,50274638.604510471,99351824.642270356,{"$f":"L64*(1+DSWRESR!$I$3)","v":76197885.678637952},99351824.642270356,225824348.92541876,-81344087.950849712,-4328969070.4843721,31056286.41861701,-333317437.87202048,31056286.418616965,-333317437.87201995,31056286.41861698,-333317437.87202024]
[2057,40303524.120801046,29382061.367563993,9348535.4839891177,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A66-$A$24)*$B$4","v":36895323.77907417},0,{"$f":"G65*(1+DSWRESR!$I$3)","v":33555077.640676469},149484522.3921048,0,51938433.336418398,99351824.642270356,{"$f":"L65*(1+DSWRESR!$I$3)","v":79245801.105783477},99351824.642270356,230536059.08447224,-81051536.692367435,-4583179369.9961147,35068628.72744447,-311581506.65945685,35068628.727444425,-311581506.65945637,35068628.72744444,-311581506.65945661]
[2058,41637333.631338164,30354434.720667768,9657917.0035992842,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A67-$A$24)*$B$4","v":38116341.911468126},0,{"$f":"G66*(1+DSWRESR!$I$3)","v":34897280.746303529},154663308.01337686,0,53657289.884517603,99351824.642270356,{"$f":"L66*(1+DSWRESR!$I$3)","v":82415633.150014818},99351824.642270356,235424747.67680278,-80761439.663425922,-4847267984.4593849,39201620.003992304,-284843146.92184281,39201620.00399223,-284843146.92184246,39201620.00399226,-284843146.92184263]
[2059,43015284.38880612,31358987.910509277,9977537.231169669,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A68-$A$24)*$B$4","v":39377768.559818268},0,{"$f":"G67*(1+DSWRESR!$I$3)","v":36293171.976155668},160022750.066459,0,55433030.470951319,99351824.642270356,{"$f":"L67*(1+DSWRESR!$I$3)","v":85712258.476015419},99351824.642270356,240497113.58923709,-80474363.522778094,-5121633067.3605394,43458767.581022367,-252778105.21769416,43458767.581022307,-252778105.21769387,43458767.581022337,-252778105.21769404]
[2060,44438837.208760075,32396785.900344826,10307735.007691247,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A69-$A$24)*$B$4","v":40680941.008247107},0,{"$f":"G68*(1+DSWRESR!$I$3)","v":37744898.8552019},165569197.98024517,0,57267537.622694142,99351824.642270356,{"$f":"L68*(1+DSWRESR!$I$3)","v":89140748.815056041},99351824.642270356,245760111.08002055,-80190913.099775374,-5406689303.1547365,47843675.445846617,-215045553.98055533,47843675.445846543,-215045553.98055506,47843675.445846573,-215045553.98055524]
[2061,45909501.251154914,33468928.897448473,10648860.387798125,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A70-$A$24)*$B$4","v":42027240.797113329},0,{"$f":"G69*(1+DSWRESR!$I$3)","v":39254694.809409976},171309226.14292482,0,59162756.167287104,99351824.642270356,{"$f":"L69*(1+DSWRESR!$I$3)","v":92706378.767658278},99351824.642270356,251220959.57721573,-79911733.434290916,-5702868608.7152166,52360046.662322998,-171287329.47745454,52360046.662322909,-171287329.47745436,52360046.662322931,-171287329.47745451]
[2062,47428835.620260432,34576553.519481651,11001275.010873146,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A71-$A$24)*$B$4","v":43418095.187632799},0,{"$f":"G70*(1+DSWRESR!$I$3)","v":40824882.601786375},177249641.94003439,0,61120695.294619866,99351824.642270356,{"$f":"L70*(1+DSWRESR!$I$3)","v":96414633.918364614},99351824.642270356,256887153.85525483,-79637511.915220439,-6010620864.9790459,57011685.841937035,-121127136.8146157,57011685.841936946,-121127136.81461561,57011685.841936968,-121127136.81461573]
[2063,48998451.017524302,35720833.999462761,11365352.484434912,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A72-$A$24)*$B$4","v":44854978.674969874},0,{"$f":"G71*(1+DSWRESR!$I$3)","v":42457877.905857831},183397494.08224967,0,63143430.686945781,99351824.642270356,{"$f":"L71*(1+DSWRESR!$I$3)","v":100271219.2750992},99351824.642270356,262766474.60431534,-79368980.522065669,-6330414680.1002741,61802501.664350867,-64169720.622849464,61802501.664350748,-64169720.622849494,61802501.66435077,-64169720.622849591]
[2064,50620011.449135073,36902983.430614151,11741478.780212659,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A73-$A$24)*$B$4","v":46339414.551403239},0,{"$f":"G72*(1+DSWRESR!$I$3)","v":44156193.022092149},189760081.23345727,0,65233106.719387874,99351824.642270356,{"$f":"L72*(1+DSWRESR!$I$3)","v":104282068.04610318},99351824.642270356,268866999.40776139,-79106918.174304128,-6662738185.4785891,66736509.447764337,8.9406967163085938E-7,66736509.447764218,7.4505805969238281E-7,66736509.447764263,6.8545341491699219E-7]
[null,null,null,null,null,{"$f":"SUM(F24:F73)","v":150000000},null,null,null,null,{"$f":"SUM(K24:K73)","v":3974072985.6908178}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimated Factors to make Final-Year Debt (the blue cells) almost zero:",3.9520768800789963,0,3.1472867975120318]

{"sheet":"Summary with Elasticity","index":4,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,"Average Water Sales Rev:",null,1517116.02]
[null,null,null,null,null,null,null,null,"Average Impact Fee Rev:",null,420937.89997854002]
[null,null,null," With Current P. Tax Levy","With Max P. Tax Levy","With Max P. Tax and GR Nuke",null,null,"Average Impact Fee:",null,6438]
[null,null,"Average Property Tax Revenues",1591855.099666229,2635265.5750458199,2635265.5750458199]
[null,null,"Annual Impact Fee Revenues",420937.9,420937.9,420937.9]
[null,null,"Average Water Sales Revenues",1517116.02,1517116.02,1517116.02]
[null,null,"Green River Nuclear Plant Water Lease Revenue",100000,100000,1000000]
[null,null,"Average Total Revenues",{"$f":"3529909.02+D9","v":3629909.02},{"$f":"4573319.49093572+E9","v":4673319.4909357196},5573319.4909357224]
[]
[null,null,"Average Annual Debt Service",3251475.399999999,3251475.399999999,3251475.399999999]
[null,null,"Operating Expenses",2463533,2463533,2463533]
[null,null,"Average Total Expenses",5715008,5715008,5715008]
[]
[null,null,"Average Annual Deficit",{"$f":"D14-D10","v":2085098.98},{"$f":"E14-E10","v":1041688.5090642804},{"$f":"F14-F10","v":141688.50906427763}]
[]
[null,null,"Required Increase in Impact Fees",{"$f":"D16/$K$4","v":4.9534598336388838},{"$f":"E16/$K$4","v":2.4746845297545961},{"$f":"F16/$K$4","v":0.33660192886290613}]
[null,null,"New Average Impact Fees",{"$f":"(D18+1)*$K$5","v":38328.374408967131},{"$f":"(E18+1)*$K$5","v":22370.01900256009},{"$f":"(F18+1)*$K$5","v":8605.0432180193893}]
[]
[null,null,"Required Increase in Water Rates w/o Elasticity",{"$f":"D16/$K$3","v":1.3743833381971671},{"$f":"E16/$K$3","v":0.68662415750133621},{"$f":"F16/$K$3","v":9.3393324700557598E-2}]
[null,null,"Required Increase in Water Rates w/ 0.5 Elasticity",{"$f":"(D21*0.5)+D21","v":2.0615750072957506},{"$f":"(E21*0.5)+E21","v":1.0299362362520044},{"$f":"(F21*0.5)+F21","v":0.14008998705083639},"Gail: Not sure if these elasticity calculations are done correctly"]

{"sheet":"Second Scenario","index":5,"n_rows":75,"n_cols":22,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Revenues and Expenses'!B3","v":9938660},"2013 Property Tax Collections",null,null,-0.5,"<-Never change this elasticity",null,null,"2013 water sales revenue",{"$f":"'Revenues and Expenses'!B20","v":7013377},null,null,null,"Scenario A","Scenario B","DSWRESR!i3 gives the FERC \"escalation rate\""]
[null,{"$f":"'Revenues and Expenses'!B20","v":7013377},"2013 water sales revenue Revenue",null,null," here; change it in 'Revenues and Expenses'G31",null,null,2013,"population",{"$f":"'Population Estimates'!$E$3*(1+'Population Estimates'!$I$10)^(I2-2010)","v":151208.58879260745},null,null,null,"FERC Low Cost","FERC High Cost Estimate"]
[null,{"$f":"'Revenues and Expenses'!B8","v":6102},"2013 Impact Fee per ERU",null,null,null,null,null,null,"2013 retail price of water, $/ac-ft",325.85300000000097,null,null,"Cost Estimate",{"$f":"'Revenues and Expenses'!L7","v":1328461943.8059647},{"$f":"'Revenues and Expenses'!$L$8","v":1750908554.5999455},null,null,"retail p, $/ac-ft"," = $/1000 gallons","whlsl p, $/ac-ft"," = $/1000 gallons"]
[null,{"$f":"'Population Estimates'!I9","v":3.3094116200343082E-2},"GOPB 50-Year Household Growth Rate Projection",null,null,null,{"$f":"EXP('Population Estimates'!I10*(A73-A24))","v":4.1578977495525988},"Factor by which # of people will grow, 2015--2064",null,null,null,null,null,"LPP O&M Costs (Column K)",{"$f":"'Revenues and Expenses'!$L$14","v":23493230.614828616},{"$f":"'Revenues and Expenses'!$L$15","v":62867794.266077146},null,null,{"$f":"K3","v":325.85300000000097},{"$f":"S4*'Revenues and Expenses'!$G$39/'Revenues and Expenses'!$G$40*1000","v":1.0000000000000031},{"$f":"S4-'Revenues and Expenses'!$G$44","v":143.86344867891847},{"$f":"U4*'Revenues and Expenses'!$G$39/'Revenues and Expenses'!$G$40*1000","v":0.44149800271569845}]
[null,{"$f":"1+B4","v":1.0330941162003431},"GOPB 50-Year Household Growth Rate Projection, plus one.",null,null,null,null,null,null,null,null,null,null,"LPP Power sale revenue (Column F)",{"$f":"'Revenues and Expenses'!$L$18","v":9947746.9633827638},{"$f":"'Revenues and Expenses'!$L$19","v":72005740.314571843},null,null,{"$f":"M10","v":1574.6333925046092},{"$f":"S5*'Revenues and Expenses'!$G$39/'Revenues and Expenses'!$G$40*1000","v":4.8323427818820424},{"$f":"S5-'Revenues and Expenses'!$G$44","v":1392.6438411835268},{"$f":"U5*'Revenues and Expenses'!$G$39/'Revenues and Expenses'!$G$40*1000","v":4.2738407845977386}]
[null,1.04,"<- enter 1 plus assumed interest rate on reserves (the interest rate on savings)",null,null,null,null,null,null,null,null,null,null,"B","<- enter A or B (capitalized) for which Scenario you want to analyze",null,null,null,{"$f":"K20","v":517.58390666832611},{"$f":"S6*'Revenues and Expenses'!$G$39/'Revenues and Expenses'!$G$40*1000","v":1.5883969356376222},{"$f":"S6-'Revenues and Expenses'!$G$44","v":335.59435534724361},{"$f":"U6*'Revenues and Expenses'!$G$39/'Revenues and Expenses'!$G$40*1000","v":1.0298949383533178}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N$6=\"A\", $O$3,$P$3)","v":1750908554.5999455},"Loan Amount"]
[null,{"$f":"G4^2","v":17.288113695734566},"If water price rises by a factor > this, (Q_2060 under new water price) < (Q_2010 under current water price).",null,null,null,null,null,null,null,null,"2013 water sales revenue",{"$f":"K1*B11","v":30884310.78300219},{"$f":"A73","v":2064},"year when all debt has to be paid back"]
[null,null,"Given unchanged impact fees: (see Column P)",null,null,null,null,null,null,null,2013,"population",{"$f":"'Population Estimates'!$E$3*(1+'Population Estimates'!$I$10)^(K9-2010)","v":151208.58879260745},{"$f":"A24","v":2015},"initial year of spreadsheet"]
[null,{"$f":"S75","v":3.4036290624334309},"The factor by which water sales revenue needs to increase to eliminate the debt by 2062, minus one",null,null,null,null,null,null,null,null,"2013 retail price of water, $/ac-ft",1574.6333925046092,10,"<- enter number of initial payment-free years (can be zero); water rates & impact fees don't change during this time"]
[null,{"$f":"B10+1","v":4.4036290624334313},"The factor by which water sales revenue needs to increase to eliminate the debt by 2062.",null,null,null,null,null,{"$f":"'Population Estimates'!I12*B13/G4","v":32.275229885739861},"gal/per person/day in 2064 w/ these water rate increases",null,null,null,0.04,"<- enter interest rate",null,null,null,null,null,"Total Expected Project Costs"]
[null,{"$f":"M10/K3","v":4.8323427818820281},"The factor by which retail water prices need to increase to eliminate the debt by 2062.",null,null,null,null,null,"whlsle p ratio->",{"$f":"(M10-'Revenues and Expenses'!G44)/(K3-'Revenues and Expenses'!G44)","v":9.6803173702008074},null,null,null,{"$f":"N8-N9+1-N10","v":40},"years allowed for paying back the loan",null,null,null,null,null,"Cost w/ interest and O&M",{"$f":"K74+L74","v":5237815369.6414175}]
[null,{"$f":"M10^(F1)/K3^(F1)","v":0.45490544307867986},"The factor by which water demanded will change vs. the base case when water prices rise enough to eliminate debt by 2062",null,null,null,null,null,null,null,null,null,null,{"$f":"N7*(1+N11)^N10","v":2591772381.3612089},"Loan Amount after initial years of negative amortization",null,null,null,null,null,"minus power sale revenue",{"$f":"V12-G74","v":5237815369.6414175}]
[null,null,"Given unchanged water prices: (see Column R)",null,null,null,null,null,null,null,null,null,null,{"$f":"-PMT(N11,N12,N13)","v":130945384.2410354},"Annual Debt Service"]
[null,{"$f":"U75","v":2.7105233872907024},"The factor by which Impact Fees need to increase to eliminate the debt by 2062, minus one.",null,null,null,null,null,"If any of these ->",{"$f":"(K3 - 'Revenues and Expenses'!G44)*'Revenues and Expenses'!G49*K2* K3^F1-K1","v":3.8184225559234619E-8},{"$f":"(M10 - 'Revenues and Expenses'!G44)*'Revenues and Expenses'!G49*M9* M10^F1-M8","v":2.1979212760925293E-7},{"$f":"(K20 - 'Revenues and Expenses'!G44)*'Revenues and Expenses'!G49*K19* K20^F1-K18","v":-1.1175870895385742E-7},"or","this ->",{"$f":"R73","v":-8.6426734924316406E-7},"or this ->",{"$f":"T73","v":-9.6857547760009766E-7},"is not zero,"]
[null,{"$f":"B15+1","v":3.7105233872907024},"The factor by which Impact Fees need to increase to eliminate the debt by 2062.",null,null,null,null,null,null,null,null,null,null,null,"click on this button ->",null,"to make them zero."]
[null,{"$f":"B3*B16","v":22641.613709247868},"2013 average Impact Fee per ERU, if Impact Fees increased as much as needed to eliminate the debt by 2062.",null,null,null,null,null,null,null,null,null,null,"(This will ensure that R75 and T75 change in order to make Q73, S73, and hence U73 equal to zero.)"]
[null,null,"Given Split Between Impact Fees and Water Rates: (see Column T)",null,null,null,null,null,null,"2013 water sales revenue",{"$f":"K1*B19","v":12981110.445750548},null,0.75,"<- enter Impact Fees' portion of Split financing"]
[null,{"$f":"B10*$M$19 + 1","v":1.8509072656083578},"The factor by which water sales revenue needs to increase to eliminate the debt by 2062.",null,null,null,null,null,2013,"population",{"$f":"'Population Estimates'!$E$3*(1+'Population Estimates'!$I$10)^(I19-2010)","v":151208.58879260745},null,{"$f":"1-M18","v":0.25},"Water Rates"]
[null,{"$f":"K20/K3","v":1.5883969356376175},"The factor by which retail water prices need to increase to eliminate the debt by 2062.",null,null,null,null,null,null,"2013 retail price of water, $/ac-ft",517.58390666832611,"whlsle p ratio->",{"$f":"(K20-'Revenues and Expenses'!G44)/(K3-'Revenues and Expenses'!G44)","v":2.3327284201023124}]
[null,{"$f":"1+B15*$M$18","v":3.0328925404680267},"The factor by which Impact Fees need to increase to eliminate the debt by 2062.",null,null,null,null,null,null,{"$f":"K20^(F1)/K3^(F1)","v":0.79345167215271117},"The factor by which water demanded will change vs. 2013 if water prices behave this way."]
[null,{"$f":"B3*B21","v":18506.710281935899},"2013 average Impact Fee per ERU, if Impact Fees increased as much as needed to eliminate the debt by 2062.",null,null,null,null,null,null,{"$f":"'Population Estimates'!I12*J21/G4","v":56.294853164735997},"gal/per person/day in 2064 w/ these water rate increases"]
["Year","Property Taxes","water sales revenue","Power sale revenue and Surcharges","Impact Fees","Real Estate sale revenue","LPP Power sale revenue","TOTAL REVENUES ","Annual Debt Service on Existing Debt","Existing O&M Costs","Annual LPP Debt Service","LPP O&M Costs","Total Annual Debt Service","TOTAL EXPENSES","Net Annual Surplus (Deficit) ","Cumulative  Surplus (Deficit)  ","Repayment Option 1: Annual Surplus (Deficit) w/ Increased Water Rate sale revenue","Repayment Option 1: Cumulative Surplus (Deficit) w/  Increased Water Rate sale revenue","Repayment Option 2: Annual Surplus (Deficit) w/ Increased Impact Fees","Repayment Option 2: Cumulative Surplus (Deficit) w/  Increased Impact Fees","Repayment Option 3: Annual Surplus (Deficit) w/  50/50 Split Between Impact Fees and Water Rates","Repayment Option 3: Cumulative Surplus (Deficit) w/ Split Between Impact Fees and Water Rates"]
[2015,{"$f":"'Revenues and Expenses'!B3*B5","v":10267571.168915702},{"$f":"'Revenues and Expenses'!B20*$B$5^2","v":7485261.2212441899},{"$f":"('Revenues and Expenses'!B19+'Revenues and Expenses'!B21) * $B$5","v":2381597.0315472321},{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A24-$A$24)*$B$4","v":9399311.1264014002},{"$f":"'Revenues and Expenses'!$D$27/10","v":15000000},0,{"$f":"B24+C24+E24+D24+G24+F24","v":44533740.548108526},7026322,{"$f":"'Revenues and Expenses'!I13","v":13231636},{"$f":"IF(ROW()-24<$N$10,0,$N$14)","v":0},0,{"$f":"K24+I24","v":7026322},{"$f":"J24+M24+L24","v":20257958},{"$f":"H24-N24","v":24275782.548108526},{"$f":"O24","v":24275782.548108526},{"$f":"IF(ROW()-24<$N$10,O24,O24+$B$10*C24)","v":24275782.548108526},{"$f":"Q24","v":24275782.548108526},{"$f":" IF(ROW()-24<$N$10,O24,O24+$B$15*E24)","v":24275782.548108526},{"$f":"S24","v":24275782.548108526},{"$f":"IF(ROW()-24<$N$10,S24,S24+$B$10*H24)","v":24275782.548108526},{"$f":"U24","v":24275782.548108526}]
[{"$f":"A24+1","v":2016},{"$f":"B24*$B$5","v":10607367.36227509},7732979.3258899674,{"$f":"D24*$B$5","v":2460413.8804516485},{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A25-$A$24)*$B$4","v":9710373.0210217051},{"$f":"'Revenues and Expenses'!$D$27/10","v":15000000},0,{"$f":"B25+C25+E25+D25+G25+F25","v":45511133.589638412},7039458,{"$f":"J24*$B$5","v":13669525.299304644},0,0,{"$f":"K25+I25","v":7039458},{"$f":"J25+M25+L25","v":20708983.299304642},24802150.29033377,{"$f":"P24*$B$6+O25","v":50048964.140366636},{"$f":"IF(ROW()-24<$N$10,O25,O25+$B$10*C25)","v":24802150.29033377},{"$f":"R24*$B$6+Q25","v":50048964.140366636},{"$f":" IF(ROW()-24<$N$10,O25,O25+$B$15*E25)","v":24802150.29033377},{"$f":"T24*$B$6+S25","v":50048964.140366636},24802150.29033377,{"$f":"V24*$B$6+U25","v":50048964.140366636}]
[{"$f":"A25+1","v":2017},10958408.810341949,7988895.4422758203,2541839.1033122526,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A26-$A$24)*$B$4","v":10031729.234128073},{"$f":"'Revenues and Expenses'!$D$27/10","v":15000000},0,46520872.590058096,7048107,14121906.157963362,0,0,7048107,21170013.157963362,25350859.432094734,77401782.138076037,25350859.432094734,77401782.138076037,25350859.432094734,77401782.138076037,25350859.432094734,77401782.138076037]
[2018,11321067.664882269,8253280.8763548872,2625959.021959844,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A27-$A$24)*$B$4","v":10363720.447092688},{"$f":"'Revenues and Expenses'!$D$27/10","v":15000000},0,47564028.010289684,7048318,14589258.161325341,0,0,7048318,21637576.161325343,25926451.848964341,106424305.27256343,25926451.848964341,106424305.27256343,25926451.848964341,106424305.27256343,25926451.848964341,106424305.27256343]
[2019,11695728.393695829,{"$f":"C27*$B$5","v":8526415.9127110448},2712862.8149699224,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A28-$A$24)*$B$4","v":10706698.615836641},{"$f":"'Revenues and Expenses'!$D$27/10","v":15000000},0,48641705.737213433,7050648,15072076.766193045,0,0,7050648,{"$f":"J28+M28+L28","v":22122724.766193047},26518980.971020386,137200258.45448637,26518980.971020386,137200258.45448637,26518980.971020386,137200258.45448637,26518980.971020386,137200258.45448637]
[2020,12082788.188204451,8808590.1116987579,2802642.612204127,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A29-$A$24)*$B$4","v":11061027.343951194},{"$f":"'Revenues and Expenses'!$D$27/10","v":15000000},0,49755048.256058529,6451090,15570873.82607393,0,0,6451090,22021963.82607393,27733084.429984599,170421353.22265044,27733084.429984599,170421353.22265044,27733084.429984599,170421353.22265044,27733084.429984599,170421353.22265044]
[2021,12482657.384529021,9100102.6164165102,2895393.5924804434,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A30-$A$24)*$B$4","v":11427082.268167086},{"$f":"'Revenues and Expenses'!$D$27/10","v":15000000},0,50905235.86159306,6456332,16086178.133814901,0,0,6456332,22542510.133814901,28362725.727778159,205600933.07933462,28362725.727778159,205600933.07933462,28362725.727778159,205600933.07933462,28362725.727778159,205600933.07933462]
[2022,12895759.898501694,9401262.4698392451,2991214.0844757198,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A31-$A$24)*$B$4","v":11805251.456580687},{"$f":"'Revenues and Expenses'!$D$27/10","v":15000000},0,52093487.909397341,6138580,16618535.982194789,0,0,6138580,22757115.982194789,29336371.927202553,243161342.32971057,29336371.927202553,243161342.32971057,29336371.927202553,243161342.32971057,29336371.927202553,243161342.32971057]
[2023,13322533.675074434,9712388.9424460288,3090205.670967462,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A32-$A$24)*$B$4","v":12195935.820059035},{"$f":"'Revenues and Expenses'!$D$27/10","v":15000000},0,53321064.108546957,5095230,17168511.743069127,0,0,5095230,22263741.743069127,31057322.36547783,283945118.38837683,31057322.36547783,{"$f":"R31*$B$6+Q32","v":283945118.38837683},31057322.36547783,283945118.38837683,{"$f":"IF(ROW()-24<$N$10,O32,O32 + $M$19*C32*$B$10 + $M$18*E32*$B$15)","v":31057322.36547783},{"$f":"V31*$B$6+U32","v":283945118.38837683}]
[2024,13763431.152600331,10033811.870690266,3192473.2965254183,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A33-$A$24)*$B$4","v":12599549.537259996},{"$f":"'Revenues and Expenses'!$D$27/10","v":15000000},0,54589265.857076012,5101740,17736688.46568121,0,0,5101740,22838428.46568121,31750837.391394801,327053760.51530671,31750837.391394801,327053760.51530671,31750837.391394801,{"$f":"T32*$B$6+S33","v":327053760.51530671},31750837.391394801,327053760.51530671]
[2025,14218919.742479909,10365872.00667127,3298125.378767123,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A34-$A$24)*$B$4","v":13016520.493718058},0,0,40899437.621636361,5109185,18323668.494773749,130945384.2410354,0,136054569.2410354,154378237.73580915,-113478800.11417279,226657110.8217462,-78197216.894801304,261938694.04111767,-78197216.894801259,261938694.04111773,-78197216.894801274,261938694.04111773]
[2026,14689482.324680891,10708921.379377933,3407273.9232953428,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A35-$A$24)*$B$4","v":13447290.73546131},0,{"$f":"IF($N$6=\"A\", $O$5,$P$5)","v":72005740.314571843},114258708.67738733,5099965,18930074.109156359,130945384.2410354,{"$f":"IF($N$6=\"A\", $O$4,$P$4)","v":62867794.266077146},136045349.2410354,217843217.61626893,-103584508.93888161,132138886.31573445,-67135312.904716164,205280928.89804623,-67135312.904716134,205280928.89804631,-67135312.904716134,205280928.89804631]
[2027,15175617.759656766,11063323.667887405,3520034.6424392778,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A36-$A$24)*$B$4","v":13892316.937640462},0,{"$f":"G35*(1+DSWRESR!$I$3)","v":74885969.92715472},118537262.93477863,3178350,19556548.181405887,130945384.2410354,{"$f":"L35*(1+DSWRESR!$I$3)","v":65382506.036720231},134123734.2410354,219062788.45916152,-100525525.52438289,36898916.243980944,-62870075.561253697,150622090.49271438,-62870075.561253667,150622090.49271449,-62870075.561253682,150622090.49271446]
[2028,15677841.417206837,11429454.586914476,3636527.0779253966,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A37-$A$24)*$B$4","v":14352070.888666729},0,{"$f":"G36*(1+DSWRESR!$I$3)","v":77881408.724240914},122977302.69495435,3178995,20203754.859398942,130945384.2410354,{"$f":"L36*(1+DSWRESR!$I$3)","v":67997806.278189048},134124379.2410354,222325940.37862337,-99348637.683669016,-60973764.789928831,-60447013.883883819,96199960.228539124,-60447013.883883797,96199960.228539288,-60447013.883883797,96199960.228539258]
[2029,16196685.722838432,11807702.285120368,3756874.7276079538,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A38-$A$24)*$B$4","v":14827039.990371825},0,{"$f":"G37*(1+DSWRESR!$I$3)","v":80996665.073210552},127584967.79914913,3188875,20872380.270399138,130945384.2410354,{"$f":"L37*(1+DSWRESR!$I$3)","v":70717718.529316619},134134259.2410354,225724358.04075116,-98139390.241602033,-161552105.62312803,-57950351.583404712,42097607.054275982,-57950351.58340469,42097607.054276168,-57950351.58340469,42097607.054276139]
[2030,16732700.722210484,12198467.756603198,3881205.1763935438,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A39-$A$24)*$B$4","v":15317727.774720324},0,{"$f":"G38*(1+DSWRESR!$I$3)","v":84236531.676138982},132366633.10606652,1786290,21563133.248445477,130945384.2410354,{"$f":"L38*(1+DSWRESR!$I$3)","v":73546427.27048929},132731674.2410354,227841234.75997019,-95474601.653903663,-263488791.50195682,-53955542.280371882,-10174030.943924859,-53955542.28037186,-10174030.943924643,-53955542.280371875,-10174030.943924688]
[2031,17286454.664256882,12602165.266006364,4009650.231498485,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A40-$A$24)*$B$4","v":15824654.437622139},0,{"$f":"G39*(1+DSWRESR!$I$3)","v":87605992.94318454},137328917.54256842,1610460,22276746.085813012,130945384.2410354,{"$f":"L39*(1+DSWRESR!$I$3)","v":76488284.361308858},132555844.2410354,231320874.68815726,-93991957.145588845,-368020300.30762398,-51098861.196620457,-61679853.378302313,-51098861.196620442,-61679853.378302068,-51098861.196620435,-61679853.378302112]
[2032,{"$f":"B40*$B$5","v":17858534.603607763},13019222.787695505,4142346.0621824283,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A41-$A$24)*$B$4","v":16348357.390411083},0,{"$f":"G40*(1+DSWRESR!$I$3)","v":91110232.660911918},142478693.50480869,1610460,23013975.309342444,130945384.2410354,{"$f":"L40*(1+DSWRESR!$I$3)","v":79547815.73576121},132555844.2410354,235117635.28613907,-92638941.781330377,-475380054.10125935,-48326336.730834365,-112473384.24426877,-48326336.730834343,-112473384.24426849,-48326336.73083435,-112473384.24426855]
[2033,18449547.022947405,13450082.459469654,4279433.3441063268,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A42-$A$24)*$B$4","v":16889391.829574082},0,{"$f":"G41*(1+DSWRESR!$I$3)","v":94754641.967348397},147823096.62344587,1610460,23775602.48246165,130945384.2410354,{"$f":"L41*(1+DSWRESR!$I$3)","v":82729728.365191668},132555844.2410354,239061175.08868873,-91238078.465242863,-585633334.73055267,-45458986.91406583,-162431306.52810535,-45458986.914065808,-162431306.52810505,-45458986.914065816,-162431306.52810511]
[2034,19060118.475968521,13895201.051287539,4421057.4084678041,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A43-$A$24)*$B$4","v":17448331.325335134},0,{"$f":"G42*(1+DSWRESR!$I$3)","v":98544827.646042332},153369535.90710133,1610460,24562435.033749402,130945384.2410354,{"$f":"L42*(1+DSWRESR!$I$3)","v":86038917.499799341},132555844.2410354,243157196.77458414,-89787660.867482811,-698846328.9872576,-42493550.740964979,-211422109.53019455,-42493550.740964957,-211422109.53019419,-42493550.740964957,-211422109.53019428]
[2035,19690896.251604531,14355050.449505979,4567368.3960720254,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A44-$A$24)*$B$4","v":18025768.429717857},0,{"$f":"G43*(1+DSWRESR!$I$3)","v":102486620.75188403},159125704.27878442,110460,25375307.112919681,130945384.2410354,{"$f":"L43*(1+DSWRESR!$I$3)","v":89480474.199791312},131055844.2410354,245911625.5537464,-86785921.274961978,-813586103.4217099,-37926654.372325338,-257805648.28372768,-37926654.372325324,-257805648.28372729,-37926654.372325324,-257805648.28372738]
[2036,20342549.060244031,14830118.157143718,4718521.4165014075,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A45-$A$24)*$B$4","v":18622315.304731414},0,{"$f":"G44*(1+DSWRESR!$I$3)","v":106586085.5819594},165099589.52057996,110460,26215080.475134037,130945384.2410354,{"$f":"L44*(1+DSWRESR!$I$3)","v":93059693.167782962},131055844.2410354,250330617.88395241,-85231028.363372445,-931360575.92195082,-34754807.204396375,-302872681.41947317,-34754807.204396367,-302872681.41947275,-34754807.204396367,-302872681.41947281]
[2037,21015767.742654927,15320907.81070105,4874676.7125529125,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A46-$A$24)*$B$4","v":19238604.371345628},0,{"$f":"G45*(1+DSWRESR!$I$3)","v":110849529.00523777},171299485.64249229,110460,27082645.39457947,130945384.2410354,{"$f":"L45*(1+DSWRESR!$I$3)","v":96782080.89449428},131055844.2410354,254920570.53010917,-83621084.887616873,-1052236083.8464458,-31474397.800251432,-346461986.47650355,-31474397.800251409,-346461986.47650307,-31474397.800251409,-346461986.47650313]
[2038,21711266.002369773,15827939.714083135,5035999.8301172452,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A47-$A$24)*$B$4","v":19875288.979943369},0,{"$f":"G46*(1+DSWRESR!$I$3)","v":115283510.16544729},177734004.69196081,110460,27978921.608280368,130945384.2410354,{"$f":"L46*(1+DSWRESR!$I$3)","v":100653364.13027406},131055844.2410354,259688129.97958982,-81954125.287629008,-1176279652.4879327,-28081689.67833136,-388402155.61389506,-28081689.678331338,-388402155.61389452,-28081689.678331345,-388402155.61389458]
[2039,22429781.162308756,16351751.390193028,5202661.7936800532,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A48-$A$24)*$B$4","v":20533044.102961008},0,{"$f":"G47*(1+DSWRESR!$I$3)","v":119894850.57206519},184412089.02120805,110460,28904859.29114509,130945384.2410354,{"$f":"L47*(1+DSWRESR!$I$3)","v":104679498.69548503},131055844.2410354,264640202.22766551,-80228113.206457466,-1303558951.7939074,-24572816.953110218,-428511058.79156107,-24572816.953110211,-428511058.79156053,-24572816.953110211,-428511058.79156059]
[2040,23172074.94644247,16892898.150779199,5374839.2876311867,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A49-$A$24)*$B$4","v":21212567.050451171},0,{"$f":"G48*(1+DSWRESR!$I$3)","v":124690644.5949478},191343024.03025183,110460,29861440.063280813,130945384.2410354,{"$f":"L48*(1+DSWRESR!$I$3)","v":108866678.64330444},131055844.2410354,269783962.94762063,-78440938.917368799,-1434142248.7830327,-20943779.822648756,-466595280.96587229,-20943779.822648749,-466595280.96587175,-20943779.822648756,-466595280.96587181]
[2041,23938934.287323095,17451953.685141645,5552714.8435742222,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A50-$A$24)*$B$4","v":21914578.209326368},0,{"$f":"G49*(1+DSWRESR!$I$3)","v":129678270.37874572},198536451.40411106,110460,30849678.030644611,130945384.2410354,{"$f":"L49*(1+DSWRESR!$I$3)","v":113221345.78903662},131055844.2410354,275126868.06071663,-76590416.656605572,-1568098355.3909595,-17190439.897615254,-502449532.10212243,-17190439.897615246,-502449532.10212189,-17190439.897615254,-502449532.10212195]
[2042,24731172.160340142,18029510.66832073,5736477.0338348374,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A51-$A$24)*$B$4","v":22639821.807067323},0,{"$f":"G50*(1+DSWRESR!$I$3)","v":134865401.19389555},206002382.86345857,110460,31870620.860133935,130945384.2410354,{"$f":"L50*(1+DSWRESR!$I$3)","v":117750199.62059809},131055844.2410354,280676664.72176743,-74674281.858308852,-1705496571.4649067,-13308515.366158828,-535856028.75236619,-13308515.366158821,-535856028.75236565,-13308515.366158821,-535856028.75236571]
[2043,25549628.445585128,18626181.389413461,5926320.6713731671,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A52-$A$24)*$B$4","v":23389066.700705465},0,{"$f":"G51*(1+DSWRESR!$I$3)","v":140260017.24165139},213751214.44872862,110460,32925350.890256286,130945384.2410354,{"$f":"L51*(1+DSWRESR!$I$3)","v":122460207.60542202},131055844.2410354,286441402.73671371,-72690188.287985086,-1846406622.6114881,-9293575.9888207316,-566583845.8912816,-9293575.9888207391,-566583845.89128113,-9293575.9888207391,-566583845.89128113]
[2044,26395170.818238914,19242598.400683377,6122447.016312086,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A53-$A$24)*$B$4","v":24163107.191916186},0,{"$f":"G52*(1+DSWRESR!$I$3)","v":145870417.93131745},221793741.358468,110460,34014986.278555498,130945384.2410354,{"$f":"L52*(1+DSWRESR!$I$3)","v":127358615.90963891},131055844.2410354,292429446.42922986,-70635705.070761859,-1990898592.5867095,-5141037.9174608588,-594388237.64439368,-5141037.9174608663,-594388237.64439332,-5141037.9174608588,-594388237.64439321]
[2045,27268695.668425616,19879415.188152127,6325063.9893003618,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A54-$A$24)*$B$4","v":24962763.869086802},0,{"$f":"G53*(1+DSWRESR!$I$3)","v":151705234.64857015},230141173.36353505,110460,35140682.187011085,130945384.2410354,{"$f":"L53*(1+DSWRESR!$I$3)","v":132452960.54602447},131055844.2410354,{"$f":"J54+M54+L54","v":298649486.97407097},-68508313.61053592,-2139042849.9007139,-846158.33196078241,-619009925.48213029,-846158.33196079731,-619009925.48212993,-846158.33196079731,-619009925.48212969]
[2046,28171129.051508285,20537306.864383698,6534386.391936874,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A55-$A$24)*$B$4","v":25788884.477252088},0,{"$f":"G54*(1+DSWRESR!$I$3)","v":157773444.03451297},238805150.81959391,110460,36303632.006667353,130945384.2410354,{"$f":"L54*(1+DSWRESR!$I$3)","v":137751078.96786547},131055844.2410354,305110555.21556818,-66305404.395974278,-2290909968.2927165,3595970.1117556691,-640174352.38965988,3595970.1117556691,-640174352.3896594,3595970.1117556617,-640174352.38965929]
[2047,29103427.669833761,21216970.884195715,6750636.1344895735,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A56-$A$24)*$B$4","v":26642344.816819493},0,{"$f":"G55*(1+DSWRESR!$I$3)","v":164084381.79589349},247797761.30123204,110460,37505068.622790501,{"$f":"IF(ROW()-24<$N$10,0,$N$14)","v":130945384.2410354},{"$f":"L55*(1+DSWRESR!$I$3)","v":143261122.12658009},131055844.2410354,311822034.99040604,-64024273.689173996,-2446570640.7135992,8190425.0290784687,-657590901.45616782,8190425.0290784687,-657590901.45616734,8190425.0290784687,-657590901.45616722]
[2048,{"$f":"B56*$B$5","v":30066579.886967517},21919127.784056585,6974042.4711506059,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A57-$A$24)*$B$4","v":27524049.672036927},0,{"$f":"G56*(1+DSWRESR!$I$3)","v":170647757.06772923},257131556.88194087,110460,38746265.721894972,130945384.2410354,{"$f":"L56*(1+DSWRESR!$I$3)","v":148991567.01164329},131055844.2410354,318793676.97457367,-61662120.0926328,-2606095586.4347758,12942460.256374285,-670952077.25804031,12942460.256374285,-670952077.25803983,12942460.256374277,-670952077.25803971]
[2049,31061606.775493719,22644521.945952322,7204842.2430769922,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A58-$A$24)*$B$4","v":28434933.770187326},0,{"$f":"G57*(1+DSWRESR!$I$3)","v":177473667.35043842},266819572.08514875,110460,40028539.142024733,130945384.2410354,{"$f":"L57*(1+DSWRESR!$I$3)","v":154951229.69210902},131055844.2410354,326035613.07516915,-59216040.990020394,-2769555450.8821874,17857512.010134563,-679932648.33822739,17857512.010134533,-679932648.33822691,17857512.010134555,-679932648.3382268]
[2050,32089563.199491274,23393922.386532888,7443280.1294745225,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A59-$A$24)*$B$4","v":29375962.772526972},0,{"$f":"G58*(1+DSWRESR!$I$3)","v":184572614.04445595},276875342.53248161,110460,41353248.267720878,130945384.2410354,{"$f":"L58*(1+DSWRESR!$I$3)","v":161149278.87979338},131055844.2410354,333558371.38854969,-56683028.856068075,-2937020697.7735429,22941205.263047308,-684188749.00870919,22941205.263047308,-684188749.00870872,22941205.2630473,-684188749.0087086]
[2051,33151538.932833493,24168123.572374616,7689608.9069910571,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A60-$A$24)*$B$4","v":30348134.298017923},0,{"$f":"G59*(1+DSWRESR!$I$3)","v":191955518.60623419},287312924.31645131,110460,42721797.471154466,130945384.2410354,{"$f":"L59*(1+DSWRESR!$I$3)","v":167595250.03498513},131055844.2410354,341372891.74717498,-54059967.430723667,-3108561493.1152081,28199360.34469305,-683356938.6243645,28199360.34469302,-683356938.62436402,28199360.344693024,-683356938.6243639]
[2052,34248659.814496882,24967946.262223031,7944089.7176942127,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A61-$A$24)*$B$4","v":31352478.980940148},0,{"$f":"G60*(1+DSWRESR!$I$3)","v":199633739.35048357},298146914.1258378,0,44135637.600952372,130945384.2410354,{"$f":"L60*(1+DSWRESR!$I$3)","v":174299060.03638452},130945384.2410354,349380081.87837231,-51233167.752534509,-3284137120.592351,33748459.774843946,-676942756.39449513,33748459.774843931,-676942756.39449465,33748459.774843931,-676942756.39449453]
[2053,35382088.942103863,25794238.377108961,8206992.3459175359,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A62-$A$24)*$B$4","v":32390061.563504193},0,{"$f":"G61*(1+DSWRESR!$I$3)","v":207619088.92450291},309392470.15313745,0,45596267.520294525,130945384.2410354,{"$f":"L61*(1+DSWRESR!$I$3)","v":181271022.4378399},130945384.2410354,357812674.19916981,-48420204.046032369,-3463922809.4620776,39373815.337631434,-664646651.31264353,39373815.337631404,-664646651.31264305,39373815.337631412,-664646651.31264293]
[2054,36553027.904964723,26647875.899260353,8478595.5042686574,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A63-$A$24)*$B$4","v":33461982.024623066},0,{"$f":"G62*(1+DSWRESR!$I$3)","v":215923852.48148304},321065333.81459987,0,47105235.695913084,130945384.2410354,{"$f":"L62*(1+DSWRESR!$I$3)","v":188521863.33535349},130945384.2410354,366572483.27230197,-45507149.4577021,-3647986871.2982631,45192335.405139834,-646040181.96000946,45192335.405139804,-646040181.96000898,45192335.405139811,-646040181.96000886]
[2055,37762718.057926007,27529763.800762799,8759187.1291026305,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A64-$A$24)*$B$4","v":34569376.746039733},0,{"$f":"G63*(1+DSWRESR!$I$3)","v":224560806.58074236},333181852.31457353,0,48664141.839678183,130945384.2410354,{"$f":"L63*(1+DSWRESR!$I$3)","v":196062737.86876765},130945384.2410354,375672263.94948125,-42490411.634907722,-3836396757.7851014,51210692.519296363,-620671096.71911347,51210692.519296333,-620671096.71911311,51210692.519296333,-620671096.71911299]
[2056,39012441.837375805,28440837.002953243,9049064.6857737023,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A65-$A$24)*$B$4","v":35713419.717046611},0,{"$f":"G64*(1+DSWRESR!$I$3)","v":233543238.84397206},345759002.08712143,0,50274638.604510471,130945384.2410354,{"$f":"L64*(1+DSWRESR!$I$3)","v":203905247.38351837},130945384.2410354,385125270.22906423,-39366268.141942799,-4029218896.2384486,57435791.241240978,-588062149.34663701,57435791.241240934,-588062149.34663665,57435791.241240948,-588062149.34663653]
[2057,40303524.120801046,29382061.367563993,9348535.4839891177,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A66-$A$24)*$B$4","v":36895323.77907417},0,{"$f":"G65*(1+DSWRESR!$I$3)","v":242884968.39773095},358814413.14915931,0,51938433.336418398,130945384.2410354,{"$f":"L65*(1+DSWRESR!$I$3)","v":212061457.27885911},130945384.2410354,394945274.85631287,-36130861.707153559,-4226518513.7951403,63874776.2776898,-547709859.04281271,63874776.277689755,-547709859.04281235,63874776.277689785,-547709859.04281223]
[2058,41637333.631338164,30354434.720667768,9657917.0035992842,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A67-$A$24)*$B$4","v":38116341.911468126},0,{"$f":"G66*(1+DSWRESR!$I$3)","v":252600367.1336402},372366394.40071356,0,53657289.884517603,130945384.2410354,{"$f":"L66*(1+DSWRESR!$I$3)","v":220543915.57001349},130945384.2410354,405146589.69556653,-32780195.294852972,-4428359449.641799,70535040.894150242,-499083212.51037502,70535040.894150183,-499083212.51037461,70535040.894150198,-499083212.51037449]
[2059,43015284.38880612,31358987.910509277,9977537.231169669,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A68-$A$24)*$B$4","v":39377768.559818268},0,{"$f":"G67*(1+DSWRESR!$I$3)","v":262704381.81898582},386433959.90928912,0,55433030.470951319,130945384.2410354,{"$f":"L67*(1+DSWRESR!$I$3)","v":229365672.19281405},130945384.2410354,415744086.90480077,-29310126.995511651,-4634803954.622983,77424235.625196338,-441622305.38559371,77424235.625196278,-441622305.38559335,77424235.625196293,-441622305.38559318]
[2060,44438837.208760075,32396785.900344826,10307735.007691247,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A69-$A$24)*$B$4","v":40680941.008247107},0,{"$f":"G68*(1+DSWRESR!$I$3)","v":273212557.09174526},401036856.21678853,0,57267537.622694142,130945384.2410354,{"$f":"L68*(1+DSWRESR!$I$3)","v":238540299.08052662},130945384.2410354,426753220.94425619,-25716364.727467656,-4845912477.5353699,84550277.292379603,-374736920.30863786,84550277.292379528,-374736920.30863762,84550277.292379558,-374736920.30863738]
[2061,45909501.251154914,33468928.897448473,10648860.387798125,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A70-$A$24)*$B$4","v":42027240.797113329},0,{"$f":"G69*(1+DSWRESR!$I$3)","v":284141059.37541509},416195590.7089299,0,59162756.167287104,130945384.2410354,{"$f":"L69*(1+DSWRESR!$I$3)","v":248081911.04374769},130945384.2410354,438190051.45207024,-21994460.74314034,-5061743437.3799248,91921358.340733364,-297805038.78025001,91921358.340733275,-297805038.78024983,91921358.340733305,-297805038.7802496]
[2062,47428835.620260432,34576553.519481651,11001275.010873146,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A71-$A$24)*$B$4","v":43418095.187632799},0,{"$f":"G70*(1+DSWRESR!$I$3)","v":295506701.75043172},431931461.08867973,0,61120695.294619866,130945384.2410354,{"$f":"L70*(1+DSWRESR!$I$3)","v":258005187.48549762},130945384.2410354,450071267.02115285,-18139805.932473123,-5282352980.8075953,99545956.505219549,-210171283.82624045,99545956.505219474,-210171283.82624036,99545956.505219489,-210171283.82624009]
[2063,48998451.017524302,35720833.999462761,11365352.484434912,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A72-$A$24)*$B$4","v":44854978.674969874},0,{"$f":"G71*(1+DSWRESR!$I$3)","v":307326969.82044899},448266585.99684083,0,63143430.686945781,130945384.2410354,{"$f":"L71*(1+DSWRESR!$I$3)","v":268325394.98491755},130945384.2410354,462414209.91289878,-14147623.916057944,-5507794723.9559565,107432844.81887372,-111145290.36041637,107432844.81887363,-111145290.36041637,107432844.81887364,-111145290.36041605]
[2064,{"$f":"B72*$B$5","v":50620011.449135073},{"$f":"C72*$B$5","v":36902983.430614151},{"$f":"D72*$B$5","v":11741478.780212659},{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A73-$A$24)*$B$4","v":46339414.551403239},0,{"$f":"G72*(1+DSWRESR!$I$3)","v":319620048.61326694},465223936.82463205,0,65233106.719387874,130945384.2410354,{"$f":"L72*(1+DSWRESR!$I$3)","v":279058410.78431427},130945384.2410354,475236901.74473757,-10012964.920105517,-5738119477.834301,115591101.97483216,-8.6426734924316406E-7,115591101.97483206,-9.6857547760009766E-7,115591101.9748321,-5.9604644775390625E-7]
[null,null,null,null,null,{"$f":"SUM(F24:F73)","v":150000000},null,null,null,null,{"$f":"SUM(K24:K73)","v":5237815369.6414175}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimated Factors to make Final-Year Debt (the blue cells) almost zero:",3.4036290624334309,0,2.7105233872907024]

{"sheet":"Water Demand","index":6,"n_rows":31,"n_cols":33,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,28,0,32],[1,28,1,32],[24,22,24,23],[0,10,0,14],[1,10,1,14],[0,16,0,20],[1,16,1,20],[0,22,0,26],[1,22,1,26]]}
["Note: for this graph to look right, cell M6 of the \"First Scenario\" tab should be \"A\" and cell M6 of the \"Second Scenario\" tab should be \"B\".",null,null,null,null,null,null,null,null,null,"First Scenario",null,null,null,null,null,"First Scenario",null,null,null,null,null,"Second Scenario",null,null,null,null,null,"Second Scenario"]
[null,null,null,null,null,null,null,null,null,null,"Increased Water Prices only",null,null,null,null,null,"Increased Water Prices and Impact Fees",null,null,null,null,null,"Increased Water Prices only",null,null,null,null,null,"Increased Water Prices and Impact Fees"]
[null,"Year","Current Supply","Supply with LPP","Base Per Capita Use (GPCD)","Assumed Conservation from 2005","Per Capita Use with Conservation (GPCD)","2005 Projected Water Demand w/ cons. (ac-ft/yr)","2012 Projected Water Demand w/ cons. (ac-ft/yr)","2012 Projected Water Demand w/o cons. (ac-ft/yr)","Demand w/ cons. (ac-ft/yr)","GPCD  w/ cons.","Demand  w/o cons. (ac-ft/yr)","GPCD  w/o cons.","Demand  (ac-ft/yr)",null,"Demand w/ cons. (ac-ft/yr)","GPCD  w/ cons.","Demand  w/o cons. (ac-ft/yr)","GPCD  w/o cons.","Demand  (ac-ft/yr)",null,"Demand w/ cons. (ac-ft/yr)","GPCD  w/ cons.","Demand  w/o cons. (ac-ft/yr)","GPCD  w/o cons.","Demand  (ac-ft/yr)",null,"Demand w/ cons. (ac-ft/yr)","GPCD  w/ cons.","Demand  w/o cons. (ac-ft/yr)","GPCD  w/o cons.","Demand  (ac-ft/yr)"]
[null,2009,{"$f":"74560+7450","v":82010},{"$f":"C4","v":82010},294.3,0,294.3,{"$f":"(G4*'Population Estimates'!E2*365)/325853","v":55407.974519185031},{"$f":"($G4*'Population Estimates'!E3*365)/325853","v":45739.15472927977},{"$f":"($E4*'Population Estimates'!E$3*365)/325853","v":45739.15472927977},{"$f":"$I4*'First Scenario'!$B$13","v":18921.04663328081},{"$f":"$G4*'First Scenario'!$B$13","v":121.74392065470131},{"$f":"$J4*'First Scenario'!$B$13","v":18921.04663328081},{"$f":"$E4*'First Scenario'!$B$13","v":121.74392065470131},{"$f":"IF(N4>G4,K4,M4)","v":18921.04663328081},null,{"$f":"$I4*'First Scenario'!$J$21","v":35035.464515969194},{"$f":"$G4*'First Scenario'!$J$21","v":225.42911577789218},{"$f":"$J4*'First Scenario'!$J$21","v":35035.464515969194},{"$f":"$E4*'First Scenario'!$J$21","v":225.42911577789218},{"$f":"IF(T4>M4,Q4,S4)","v":35035.464515969194},null,{"$f":"$I4*'Second Scenario'!$B$13","v":20806.990448167307},{"$f":"$G4*'Second Scenario'!$B$13","v":133.8786718980555},{"$f":"$J4*'Second Scenario'!$B$13","v":20806.990448167307},{"$f":"$E4*'Second Scenario'!$B$13","v":133.8786718980555},{"$f":"IF(Z4>S4,W4,Y4)","v":20806.990448167307},null,{"$f":"$I4*'Second Scenario'!$J$21","v":36291.808802798623},{"$f":"$G4*'Second Scenario'!$J$21","v":233.51282711454292},{"$f":"$J4*'Second Scenario'!$J$21","v":36291.808802798623},{"$f":"$E4*'Second Scenario'!$J$21","v":233.51282711454292},{"$f":"IF(AF4>Y4,AC4,AE4)","v":36291.808802798623}]
[null,2010,{"$f":"74560+7450","v":82010},{"$f":"C5","v":82010},294.3,0.01,{"$f":"$G$4*(100%-F5)","v":291.35700000000003},{"$f":"(G5*'Population Estimates'!E2*365)/325853","v":54853.894773993197},{"$f":"($G5*'Population Estimates'!E3*365)/325853","v":45281.763181986971},{"$f":"($E5*'Population Estimates'!E3*365)/325853","v":45739.15472927977},{"$f":"$I5*'First Scenario'!$B$13","v":18731.836166948004},{"$f":"$G5*'First Scenario'!$B$13","v":120.52648144815431},{"$f":"$J5*'First Scenario'!$B$13","v":18921.04663328081},{"$f":"$E5*'First Scenario'!$B$13","v":121.74392065470131},{"$f":"IF(N5>G5,K5,M5)","v":18921.04663328081},null,{"$f":"$I5*'First Scenario'!$J$21","v":34685.109870809501},{"$f":"$G5*'First Scenario'!$J$21","v":223.17482462011327},{"$f":"$J5*'First Scenario'!$J$21","v":35035.464515969194},{"$f":"$E5*'First Scenario'!$J$21","v":225.42911577789218},35035.464515969194,null,{"$f":"$I5*'Second Scenario'!$B$13","v":20598.920543685635},{"$f":"$G5*'Second Scenario'!$B$13","v":132.53988517907493},{"$f":"$J5*'Second Scenario'!$B$13","v":20806.990448167307},{"$f":"$E5*'Second Scenario'!$B$13","v":133.8786718980555},20806.990448167307,null,{"$f":"$I5*'Second Scenario'!$J$21","v":35928.890714770634},{"$f":"$G5*'Second Scenario'!$J$21","v":231.17769884339748},{"$f":"$J5*'Second Scenario'!$J$21","v":36291.808802798623},{"$f":"$E5*'Second Scenario'!$J$21","v":233.51282711454292},36291.808802798623]
[null,2020,{"$f":"$C$5+3830+7300+10080+27620","v":130840},{"$f":"C4+69000","v":151010},294.3,0.05,279.58499999999998,{"$f":"(G6*'Population Estimates'!F2*365)/325853","v":87645.988837297802},{"$f":"($G6*'Population Estimates'!F3*365)/325853","v":61620.644511635612},{"$f":"($E6*'Population Estimates'!F3*365)/325853","v":64863.836328037491},{"$f":"$I6*'First Scenario'!$B$13","v":25490.787822344959},{"$f":"$G6*'First Scenario'!$B$13","v":115.65672462196623},{"$f":"$J6*'First Scenario'!$B$13","v":26832.408234047329},{"$f":"$E6*'First Scenario'!$B$13","v":121.74392065470131},26832.408234047329,null,{"$f":"$I6*'First Scenario'!$J$21","v":47200.432911728982},{"$f":"$G6*'First Scenario'!$J$21","v":214.15765998899752},{"$f":"$J6*'First Scenario'!$J$21","v":49684.666222872613},{"$f":"$E6*'First Scenario'!$J$21","v":225.42911577789218},49684.666222872613,null,{"$f":"$I6*'Second Scenario'!$B$13","v":28031.566594359421},{"$f":"$G6*'Second Scenario'!$B$13","v":127.1847383031527},{"$f":"$J6*'Second Scenario'!$B$13","v":29506.912204588865},{"$f":"$E6*'Second Scenario'!$B$13","v":133.8786718980555},29506.912204588865,null,{"$f":"$I6*'Second Scenario'!$J$21","v":48893.003426885058},{"$f":"$G6*'Second Scenario'!$J$21","v":221.83718575881574},{"$f":"$J6*'Second Scenario'!$J$21","v":51466.319396721119},{"$f":"$E6*'Second Scenario'!$J$21","v":233.51282711454292},51466.319396721119]
[null,2030,{"$f":"$C$5+3830+7300+10080+27620","v":130840},{"$f":"C5+69000","v":151010},294.3,0.09,267.81300000000005,{"$f":"(G7*'Population Estimates'!G2*365)/325853","v":124647.70177027682},{"$f":"($G7*'Population Estimates'!G3*365)/325853","v":84163.822563272421},{"$f":"($E7*'Population Estimates'!G3*365)/325853","v":92487.717102497147},{"$f":"$I7*'First Scenario'!$B$13","v":34816.288603939509},{"$f":"$G7*'First Scenario'!$B$13","v":110.78696779577821},{"$f":"$J7*'First Scenario'!$B$13","v":38259.657806526928},{"$f":"$E7*'First Scenario'!$B$13","v":121.74392065470131},38259.657806526928,null,{"$f":"$I7*'First Scenario'!$J$21","v":64468.148491083623},{"$f":"$G7*'First Scenario'!$J$21","v":205.14049535788189},{"$f":"$J7*'First Scenario'!$J$21","v":70844.119220970999},{"$f":"$E7*'First Scenario'!$J$21","v":225.42911577789218},70844.119220970999,null,{"$f":"$I7*'Second Scenario'!$B$13","v":38286.580994340831},{"$f":"$G7*'Second Scenario'!$B$13","v":121.82959142723051},{"$f":"$J7*'Second Scenario'!$B$13","v":42073.165927847062},{"$f":"$E7*'Second Scenario'!$B$13","v":133.8786718980555},42073.165927847062,null,{"$f":"$I7*'Second Scenario'!$J$21","v":66779.925747592584},{"$f":"$G7*'Second Scenario'!$J$21","v":212.49667267423408},{"$f":"$J7*'Second Scenario'!$J$21","v":73384.533788563262},{"$f":"$E7*'Second Scenario'!$J$21","v":233.51282711454292},73384.533788563262]
[null,2040,{"$f":"$C$5+3830+7300+10080+27620","v":130840},{"$f":"C6+69000","v":199840},294.3,0.12,258.98400000000004,{"$f":"(G8*'Population Estimates'!H2*365)/325853","v":162358.90102960542},{"$f":"($G8*'Population Estimates'!H3*365)/325853","v":107841.73699760324},{"$f":"($E8*'Population Estimates'!H3*365)/325853","v":122547.42840636728},{"$f":"$I8*'First Scenario'!$B$13","v":44611.199022430766},{"$f":"$G8*'First Scenario'!$B$13","v":107.13465017613717},{"$f":"$J8*'First Scenario'!$B$13","v":50694.544343671318},{"$f":"$E8*'First Scenario'!$B$13","v":121.74392065470131},50694.544343671318,null,{"$f":"$I8*'First Scenario'!$J$21","v":82605.054078565052},{"$f":"$G8*'First Scenario'!$J$21","v":198.37762188454514},{"$f":"$J8*'First Scenario'!$J$21","v":93869.379634732992},{"$f":"$E8*'First Scenario'!$J$21","v":225.42911577789218},93869.379634732992,null,{"$f":"$I8*'Second Scenario'!$B$13","v":49057.793151269165},{"$f":"$G8*'Second Scenario'!$B$13","v":117.81323127028884},{"$f":"$J8*'Second Scenario'!$B$13","v":55747.492217351304},{"$f":"$E8*'Second Scenario'!$B$13","v":133.8786718980555},55747.492217351304,null,{"$f":"$I8*'Second Scenario'!$J$21","v":85567.206548601185},{"$f":"$G8*'Second Scenario'!$J$21","v":205.49128786079777},{"$f":"$J8*'Second Scenario'!$J$21","v":97235.461987046772},{"$f":"$E8*'Second Scenario'!$J$21","v":233.51282711454292},97235.461987046772]
[null,2050,{"$f":"$C$5+3830+7300+10080+27620","v":130840},{"$f":"C7+69000","v":199840},294.3,0.16,247.21199999999999,{"$f":"(G9*'Population Estimates'!I2*365)/325853","v":196516.75462285138},{"$f":"($G9*'Population Estimates'!I3*365)/325853","v":130859.14544122656},{"$f":"($E9*'Population Estimates'!I3*365)/325853","v":155784.69695384114},{"$f":"$I9*'First Scenario'!$B$13","v":54132.876043284763},{"$f":"$G9*'First Scenario'!$B$13","v":102.26489334994909},{"$f":"$J9*'First Scenario'!$B$13","v":64443.900051529476},{"$f":"$E9*'First Scenario'!$B$13","v":121.74392065470131},64443.900051529476,null,{"$f":"$I9*'First Scenario'!$J$21","v":100236.02259009953},{"$f":"$G9*'First Scenario'!$J$21","v":189.36045725342942},{"$f":"$J9*'First Scenario'!$J$21","v":119328.59832154705},{"$f":"$E9*'First Scenario'!$J$21","v":225.42911577789218},119328.59832154705,null,{"$f":"$I9*'Second Scenario'!$B$13","v":59528.53753783858},{"$f":"$G9*'Second Scenario'!$B$13","v":112.45808439436659},{"$f":"$J9*'Second Scenario'!$B$13","v":70867.306592664972},{"$f":"$E9*'Second Scenario'!$B$13","v":133.8786718980555},70867.306592664972,null,{"$f":"$I9*'Second Scenario'!$J$21","v":103830.40776681605},{"$f":"$G9*'Second Scenario'!$J$21","v":196.15077477621602},{"$f":"$J9*'Second Scenario'!$J$21","v":123607.62829382862},{"$f":"$E9*'Second Scenario'!$J$21","v":233.51282711454292},123607.62829382862]
[null,2060,{"$f":"$C$5+3830+7300+10080+27620","v":130840},{"$f":"C8+69000","v":199840},294.3,0.18,241.32600000000002,{"$f":"(G10*'Population Estimates'!J2*365)/325853","v":232575.81531617019},{"$f":"($G10*'Population Estimates'!J3*365)/325853","v":157252.4653346448},{"$f":"($E10*'Population Estimates'!J3*365)/325853","v":191771.29918859119},{"$f":"$I10*'First Scenario'!$B$13","v":65051.075985243515},{"$f":"$G10*'First Scenario'!$B$13","v":99.830014936855079},{"$f":"$J10*'First Scenario'!$B$13","v":79330.580469809152},{"$f":"$E10*'First Scenario'!$B$13","v":121.74392065470131},79330.580469809152,null,{"$f":"$I10*'First Scenario'!$J$21","v":120452.8855395264},{"$f":"$G10*'First Scenario'!$J$21","v":184.8518749378716},{"$f":"$J10*'First Scenario'!$J$21","v":146893.76285308093},{"$f":"$E10*'First Scenario'!$J$21","v":225.42911577789218},146893.76285308093,null,{"$f":"$I10*'Second Scenario'!$B$13","v":71535.002418271339},{"$f":"$G10*'Second Scenario'!$B$13","v":109.78051095640551},{"$f":"$J10*'Second Scenario'!$B$13","v":87237.807827160155},{"$f":"$E10*'Second Scenario'!$B$13","v":133.8786718980555},87237.807827160155,null,{"$f":"$I10*'Second Scenario'!$J$21","v":124772.23156991016},{"$f":"$G10*'Second Scenario'!$J$21","v":191.48051823392518},{"$f":"$J10*'Second Scenario'!$J$21","v":152161.25801208554},{"$f":"$E10*'Second Scenario'!$J$21","v":233.51282711454292},152161.25801208554]
[null,null,null,null,null,null,null,"2060 demand as a fraction of 2010 supply ->",{"$f":"I10/$C$4","v":1.917479152964819},null,null,null,null,null,{"$f":"O10/$C$4","v":0.96732813644444771},null,null,null,null,null,{"$f":"U10/$C$4","v":1.7911689166331048},null,null,null,null,null,{"$f":"AA10/$C$4","v":1.0637459800897471},null,null,null,null,null,{"$f":"AG10/$C$4","v":1.8553988295584141}]
[null,null,null,null,null,null,null,"2060 demand as a fraction of 2010 demand ->",{"$f":"I10/$I$4","v":3.4380273589529224},null,null,null,null,null,{"$f":"O10/$I$4","v":1.7344129103248587},null,null,null,null,null,{"$f":"U10/$I$4","v":3.2115539459028826},null,null,null,null,null,{"$f":"AA10/$I$4","v":1.907289462245247},null,null,null,null,null,{"$f":"AG10/$I$4","v":3.3267177522780065}]
[null,null,"Red = some water from outside WCWCD's non-LPP sources is actually used (total demand > 130,840 acre-feet)"]
[null,null,"Blue = no water from outside of WCWCD's non-LPP sources will be needed because water's so expensive that > 130,840 acre-feet are not demanded"]
[null,null,"Blue Italic = no water from outside of WCWCD's non-LPP sources will be needed because water's so expensive that > 82,010 acre-feet (2010's supply) are not demanded"]
[null,null,"Blue Italic Underline = no water from outside of WCWCD's non-LPP sources will be needed because water's so expensive that > 45,739 acre-feet (2010's demand) are not demanded"]
[null,null,"Source: 2011 LPP Water Needs Assessment"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!/C6","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1992 Water Use - Wash. Cty."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Culinary",18570]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Secondary",14710]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total M&I",{"$f":"SUM(X26:X27)","v":33280}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ag Water",87800]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"X28+X30","v":121080}]

{"sheet":"Water vs. Impact Fee Revenues","index":7,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"Water Revenues","Impact Fee Revenues",null,{"$f":"'First Scenario'!B8","v":17.288113695734566},"If Water Revenues rise by a factor > this, Q_2060 < Q_2010."]
[0,{"$f":"1+(1-A2)*'First Scenario'!B10","v":4.9520768800789963},{"$f":"1+(A2)*'First Scenario'!B15","v":1}]
[1,{"$f":"1+(1-A3)*'First Scenario'!B10","v":1},{"$f":"1+(A3)*'First Scenario'!B15","v":4.1472867975120318}]