{"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":61840169.773755245},{"$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":368.6338396694897},{"$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]
[]
[]
[]
["Total Gross Revenues",{"$f":"E27+B22+B13+B6+B3","v":29425635},null,null,null,"app. GPCD w/ cons. in 2013",287.8254]
[null,null,null,null,null,"app. population in 2013",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,"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)^(-1/2), what is the constant?"]
[null,null,null,null,null,null,{"$f":"G47/(G33*(G50^(-1/2)))","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,null,null,null,null,null,null,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,null,null,null,null,null,null,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,null,null,null,null,"Cost Estimate",{"$f":"'Revenues and Expenses'!L7","v":1328461943.8059647},{"$f":"'Revenues and Expenses'!$L$8","v":1750908554.5999455}]
[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,{"$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,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,"Q µ P^(-1/2) is the assumed demand curve, so revenues R = P^(1/2), so to increase R by a factor of \"x\" requires P to go up by a factor of \"x^2\".",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,null,null,{"$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,null,null,null,{"$f":"A24","v":2015},"initial year of spreadsheet"]
[null,{"$f":"S75","v":3.0529965081443597},"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,null,null,0,"<- 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.0529965081443597},"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":17.505397682398723},"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":"B11^2","v":16.426780695030374},"The factor by which water prices need to increase to eliminate the debt by 2062.",null,null,null,null,null,null,null,null,null,null,{"$f":"N8-N9+1-N10","v":50},"years allowed for paying back the loan",null,null,null,null,null,"Cost w/ interest and O&M",{"$f":"K74+L74","v":3092008488.6877604}]
[null,{"$f":"1/B11","v":0.24673102924972518},"The factor by which water demanded will change vs. base case when water prices rise enough to eliminate debt by 2062 (since revenue = PQ µ  B5^(-2t) Q^(-2) Q = B5^(-2t) (1/Q) ).",null,null,null,null,null,null,null,null,null,null,{"$f":"N7*(1+N11)^N10","v":1328461943.8059647},"Loan Amount after initial years of negative amortization",null,null,null,null,null,"minus power sale revenue",{"$f":"V12-G74","v":3092008488.6877604}]
[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":61840169.773755245},"Annual Debt Service"]
[null,{"$f":"U75","v":2.4312926834411717},"The factor by which Impact Fees need to increase to eliminate the debt by 2062, minus one.",null,null,null,null,null,null,null,null,null,null,"If either this ->",{"$f":"R73","v":-7.0035457611083984E-7},"or this ->",{"$f":"T73","v":2.6822090148925781E-7},"is not zero,"]
[null,{"$f":"B15+1","v":3.4312926834411717},"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":20937.74795435803},"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,null,null,null,0.5,"<- enter Impact Fees' portion of Split financing"]
[null,{"$f":"B10*$M$19 + 1","v":2.5264982540721799},"The factor by which water sales revenue needs to increase to eliminate the debt by 2062.",null,null,null,null,null,null,null,null,null,{"$f":"1-M18","v":0.5},"Water Rates"]
[null,{"$f":"B19^2","v":6.3831934278297728},"The factor by which water prices need to increase to eliminate the debt by 2062."]
[null,{"$f":"1+B15*$M$18","v":2.2156463417205856},"The factor by which Impact Fees need to increase to eliminate the debt by 2062.",null,null,null,null,null,null,{"$f":"1/B19","v":0.39580474610984268},"The factor by which water demanded will change vs. base case if water prices behave this way."]
[null,{"$f":"B3*B21","v":13519.873977179013},"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":28.082075879563789},"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":61840169.773755245},0,{"$f":"K24+I24","v":68866491.773755252},{"$f":"J24+M24+L24","v":82098127.773755252},{"$f":"H24-N24","v":-37564387.225646727},{"$f":"O24","v":-37564387.225646727},{"$f":"IF(ROW()-24<$N$10,O24,O24+$B$10*C24)","v":-14711910.854639828},{"$f":"Q24","v":-14711910.854639828},{"$f":"IF(ROW()-24<$N$10,O24,O24+$B$15*E24)","v":-14711910.854639806},{"$f":"S24","v":-14711910.854639806},{"$f":"IF(ROW()-24<$N$10,O24,O24 + $M$19*C24*$B$10 + $M$18*E24*$B$15)","v":-14711910.854639817},{"$f":"U24","v":-14711910.854639817}]
[{"$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},61840169.773755245,0,{"$f":"K25+I25","v":68879627.773755252},{"$f":"J25+M25+L25","v":82549153.073059902},-37038019.48342149,{"$f":"P24*$B$6+O25","v":-76104982.198094085},{"$f":"IF(ROW()-24<$N$10,O25,O25+$B$10*C25)","v":-13429260.603926893},{"$f":"R24*$B$6+Q25","v":-28729647.892752316},{"$f":"IF(ROW()-24<$N$10,O25,O25+$B$15*E25)","v":-13429260.603926871},{"$f":"T24*$B$6+S25","v":-28729647.892752267},{"$f":"IF(ROW()-24<$N$10,O25,O25 + $M$19*C25*$B$10 + $M$18*E25*$B$15)","v":-13429260.603926884},{"$f":"V24*$B$6+U25","v":-28729647.892752293}]
[{"$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,61840169.773755245,0,68888276.773755252,{"$f":"J26+M26+L26","v":83010182.931718618},-36489310.341660522,-115638491.82767838,-12099240.452462051,-41978074.260924459,-12099240.452462029,-41978074.260924384,-12099240.452462042,-41978074.260924429]
[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,61840169.773755245,0,68888487.773755252,83477745.935080588,-35913717.924790904,-156177749.42557642,-10716480.228544813,-54373677.45990625,-10716480.228544783,-54373677.459906146,-10716480.2285448,-54373677.459906206]
[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,61840169.773755245,0,68890817.773755252,{"$f":"J28+M28+L28","v":83962894.5399483},-35321188.802734867,-197746048.20533437,-9290070.7942415439,-65838695.352544039,-9290070.7942415215,-65838695.35254392,-9290070.7942415345,-65838695.352543987]
[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,61840169.773755245,0,68291259.773755252,83862133.599829182,-34107085.343770653,-239762975.47731841,-7214490.4910794087,-75686733.657725215,-7214490.4910793789,-75686733.657725051,-7214490.4910793919,-75686733.65772514]
[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,61840169.773755245,0,68296501.773755252,84382679.907570153,-33477444.045977093,-282830938.54238826,-5694862.5343021341,-84409065.538336352,-5694862.534302108,-84409065.538336158,-5694862.5343021229,-84409065.538336277]
[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,61840169.773755245,0,67978749.773755252,84597285.755950034,-32503797.846552692,-326647973.93063647,-3801776.3539848588,-91587204.513854668,-3801776.3539848328,-91587204.513854444,-3801776.3539848439,-91587204.513854578]
[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,61840169.773755245,0,66935399.773755245,84103911.516824365,-30782847.408277407,-370496740.2961393,-1130957.8812497891,-96381650.575658649,-1130957.8812497705,-96381650.575658396,-1130957.8812497798,-96381650.575658545]
[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,61840169.773755245,0,66941909.773755245,84678598.239436448,-30089332.382360436,-415405942.29034537,543860.22223437205,-99693056.376450628,543860.22223439068,-99693056.37645033,543860.22223438136,-99693056.376450509]
[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,61840169.773755245,0,66949354.773755245,85273023.268528998,-44373585.646892637,-476395765.62885189,-12726614.60665388,-116407393.23816255,-12726614.606653854,-116407393.2381622,-12726614.606653869,-116407393.2381624]
[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,61840169.773755245,{"$f":"IF($N$6=\"A\", $O$4,$P$4)","v":23493230.614828616},66940134.773755245,109363439.49774022,-57162724.171541981,-552614320.42554796,-24468424.594308671,-145532113.56199771,-24468424.594308648,-145532113.56199735,-24468424.594308659,-145532113.56199756]
[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,61840169.773755245,{"$f":"L35*(1+DSWRESR!$I$3)","v":24432959.83942176},65018519.773755245,109008027.79458289,-55011077.945040904,-629729971.18761086,-21234789.418509811,-172588187.52298743,-21234789.418509781,-172588187.52298704,-21234789.4185098,-172588187.52298728]
[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,61840169.773755245,{"$f":"L36*(1+DSWRESR!$I$3)","v":25410278.232998632},65019164.773755245,110633197.86615282,-54777820.77984459,-709696990.81496,-19883735.836000159,-199375450.85990709,-19883735.836000137,-199375450.85990667,-19883735.836000152,-199375450.85990691]
[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,61840169.773755245,{"$f":"L37*(1+DSWRESR!$I$3)","v":26426689.362318579},65029044.773755245,112328114.40647295,-54549949.240315787,-792634819.6878742,-18501075.394635126,-225851544.28893852,-18501075.394635111,-225851544.28893805,-18501075.394635115,-225851544.28893831]
[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,61840169.773755245,{"$f":"L38*(1+DSWRESR!$I$3)","v":27483756.936811324},63626459.773755245,112673349.95901205,-52905791.591257162,-877246004.06664646,-15663912.125636034,-250549518.1861321,-15663912.125636019,-250549518.1861316,-15663912.125636026,-250549518.18613189]
[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,61840169.773755245,{"$f":"L39*(1+DSWRESR!$I$3)","v":28583107.214283779},63450629.773755245,114310483.07385203,-52484603.259127736,-964820447.48844004,-14010236.70695217,-274581735.62052959,-14010236.706952162,-274581735.62052906,-14010236.706952166,-274581735.62052935]
[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,61840169.773755245,{"$f":"L40*(1+DSWRESR!$I$3)","v":29726431.502855133},63450629.773755245,116191036.58595283,-52235502.31810201,-1055648767.7060797,-12487860.60851416,-298052865.65386498,-12487860.608514138,-298052865.65386438,-12487860.608514149,-298052865.65386468]
[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,61840169.773755245,{"$f":"L41*(1+DSWRESR!$I$3)","v":30915488.762969341},63450629.773755245,118141721.01918624,-51982710.002176568,-1149857428.4164994,-10919655.21916201,-320894635.49918157,-10919655.219161995,-320894635.49918097,-10919655.219162002,-320894635.49918127]
[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,61840169.773755245,{"$f":"L42*(1+DSWRESR!$I$3)","v":32152108.313488115},63450629.773755245,120165173.12099276,-51726286.244585067,-1247578011.7977445,-9304285.9550403729,-343034706.87418926,-9304285.9550403506,-343034706.87418854,-9304285.9550403617,-343034706.87418884]
[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,61840169.773755245,{"$f":"L43*(1+DSWRESR!$I$3)","v":33438192.64602764},61950629.773755245,120764129.53270257,-49966300.245839536,-1347447432.5154939,-6140381.3492616564,-362896476.49841851,-6140381.349261649,-362896476.49841774,-6140381.3492616527,-362896476.49841803]
[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,61840169.773755245,{"$f":"L44*(1+DSWRESR!$I$3)","v":34775720.351868749},61950629.773755245,122941430.60075803,-49702831.071776301,-1451048160.8878901,-4426532.1226482615,-381838867.68100351,-4426532.1226482615,-381838867.68100268,-4426532.1226482615,-381838867.68100303]
[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,61840169.773755245,{"$f":"L45*(1+DSWRESR!$I$3)","v":36166749.165943503},61950629.773755245,125200024.33427823,-49435968.283048123,-1558526055.6064539,-2661290.2353761718,-399773712.62361985,-2661290.2353761569,-399773712.62361896,-2661290.2353761643,-399773712.62361938]
[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,61840169.773755245,{"$f":"L46*(1+DSWRESR!$I$3)","v":37613419.132581241},61950629.773755245,127542970.51461685,-49165812.597568706,-1670032910.4282808,-843167.91935345531,-416607829.04791808,-843167.91935344785,-416607829.04791719,-843167.91935345158,-416607829.0479176]
[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,61840169.773755245,{"$f":"L47*(1+DSWRESR!$I$3)","v":39117955.897884496},61950629.773755245,129973444.96278483,-48892476.587485969,-1785726703.432898,1029363.3088180274,-432242778.90101677,1029363.3088180274,-432242778.90101582,1029363.3088180274,-432242778.90101629]
[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,61840169.773755245,{"$f":"L48*(1+DSWRESR!$I$3)","v":40682674.133799873},61950629.773755245,132494743.97083592,-48616085.412329644,-1905771856.9825437,2957873.6544375643,-446574616.4026199,2957873.6544375643,-446574616.40261894,2957873.6544375643,-446574616.40261942]
[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,61840169.773755245,{"$f":"L49*(1+DSWRESR!$I$3)","v":42309981.099151872},61950629.773755245,135110288.90355173,-48336777.590056047,-2030339508.8519015,4943976.070978485,-459493624.98774624,4943976.070978485,-459493624.98774529,4943976.070978485,-459493624.98774576]
[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,61840169.773755245,{"$f":"L50*(1+DSWRESR!$I$3)","v":44002380.343117945},61950629.773755245,137823630.97700712,-48054705.807788551,-2159607795.0137663,{"$f":"IF(ROW()-24<$N$10,O51,O51+$B$10*C51)","v":6989327.3061461225},-470884042.68110996,6989327.3061461151,-470884042.68110895,6989327.3061461188,-470884042.68110949]
[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,61840169.773755245,{"$f":"L51*(1+DSWRESR!$I$3)","v":45762475.556842662},61950629.773755245,140638456.22085419,-47770037.774135187,-2293762144.5884523,9095628.9678075686,-480623775.42054677,9095628.9678075537,-480623775.42054582,9095628.9678075612,-480623775.42054629]
[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,61840169.773755245,{"$f":"L52*(1+DSWRESR!$I$3)","v":47592974.579116367},61950629.773755245,143558590.63142711,-47482957.115049094,-2432995587.4870396,11264628.609861501,-488584097.82750714,11264628.609861486,-488584097.82750618,11264628.609861493,-488584097.82750666]
[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,61840169.773755245,{"$f":"L53*(1+DSWRESR!$I$3)","v":49496693.56228102},61950629.773755245,{"$f":"J54+M54+L54","v":146588005.52304736},-47193664.315285921,-2577509075.3018074,13498120.838094473,-494629340.90251297,13498120.838094458,-494629340.90251195,13498120.838094465,-494629340.90251249]
[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,61840169.773755245,{"$f":"L54*(1+DSWRESR!$I$3)","v":51476561.304772265},61950629.773755245,149730823.08519486,-46902377.707605511,-2727511816.0214853,15797948.436047107,-498616566.10256636,15797948.4360471,-498616566.10256535,15797948.436047103,-498616566.10256594]
[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":61840169.773755245},{"$f":"L55*(1+DSWRESR!$I$3)","v":53535623.756963156},61950629.773755245,{"$f":"J56+M56+L56","v":152991322.1535089},{"$f":"H56-N56","v":-46609334.511961609},-2883221623.1743064,18166003.510888457,-500395225.2357806,18166003.51088845,-500395225.23577952,18166003.510888454,-500395225.23578012]
[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},61840169.773755245,{"$f":"L56*(1+DSWRESR!$I$3)","v":55677048.707241684},61950629.773755245,156373944.20289189,-46314791.927023157,{"$f":"P56*$B$6+O57","v":-3044865280.0283017},20604228.659271613,-499806805.58594024,20604228.659271605,-499806805.58593911,20604228.659271609,-499806805.58593976]
[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,61840169.773755245,{"$f":"L57*(1+DSWRESR!$I$3)","v":57904130.655531354},61950629.773755245,159883299.57131132,-46019028.276477605,-3212678919.5059118,23114618.153113157,-496684459.65626466,23114618.153113127,-496684459.65626359,23114618.153113142,-496684459.65626425]
[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,61840169.773755245,{"$f":"L58*(1+DSWRESR!$I$3)","v":60220295.88175261},61950629.773755245,163524173.92322874,-45722344.212674767,-3386908420.4988232,25699219.145210311,-490852618.89730495,25699219.145210296,-490852618.89730382,25699219.145210303,-490852618.89730453]
[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,61840169.773755245,{"$f":"L59*(1+DSWRESR!$I$3)","v":62629107.717022717},61950629.773755245,167301534.96193242,-45425063.980285883,-3567809821.2990618,28360132.894575208,-482126590.75862193,28360132.894575164,-482126590.7586208,28360132.894575186,-482126590.75862157]
[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,61840169.773755245,{"$f":"L60*(1+DSWRESR!$I$3)","v":65134272.025703631},61840169.773755245,171110079.40041125,-45017076.742770359,-3755539290.8937945,31209976.011332572,-470201678.37763423,31209976.011332542,-470201678.37763309,31209976.011332557,-470201678.37763387]
[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,61840169.773755245,{"$f":"L61*(1+DSWRESR!$I$3)","v":67739642.906731784},61840169.773755245,175176080.20078155,-44719677.974568918,-3950480540.5041151,34030041.720987976,-454979703.79175162,34030041.720987946,-454979703.79175043,34030041.720987961,-454979703.79175127]
[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,61840169.773755245,{"$f":"L62*(1+DSWRESR!$I$3)","v":70449228.623001054},61840169.773755245,179394634.09266937,-44422810.922071368,-4152922573.0463514,36933061.147834733,-436245830.795587,36933061.147834703,-436245830.79558575,36933061.147834718,-436245830.79558659]
[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,61840169.773755245,{"$f":"L63*(1+DSWRESR!$I$3)","v":73267197.767921105},61840169.773755245,183771509.38135451,-44126908.136542886,-4363166384.1047487,39921364.617224932,-413774299.41018558,39921364.617224902,-413774299.41018426,39921364.617224917,-413774299.41018516]
[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,61840169.773755245,{"$f":"L64*(1+DSWRESR!$I$3)","v":76197885.678637952},61840169.773755245,188312694.05690366,-43832433.082334608,-4581525472.5512733,42997342.976384535,-387327928.41020846,42997342.976384491,-387327928.41020715,42997342.976384513,-387327928.41020805]
[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,61840169.773755245,{"$f":"L65*(1+DSWRESR!$I$3)","v":79245801.105783477},61840169.773755245,193024404.21595711,-43539881.823852301,-4808326373.2771769,46163448.933403865,-356657596.61321294,46163448.933403805,-356657596.61321169,46163448.933403835,-356657596.61321253]
[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,61840169.773755245,{"$f":"L66*(1+DSWRESR!$I$3)","v":82415633.150014818},61840169.773755245,197913092.80828768,-43249784.794910818,-5043909213.0031748,49422198.413983792,-321501702.06375766,49422198.413983718,-321501702.06375647,49422198.413983755,-321501702.0637573]
[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,61840169.773755245,{"$f":"L67*(1+DSWRESR!$I$3)","v":85712258.476015419},61840169.773755245,202985458.72072199,-42962708.65426299,-5288628290.1775646,52776171.935463026,-281585598.21084499,52776171.935462967,-281585598.2108438,52776171.935462996,-281585598.21084458]
[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,61840169.773755245,{"$f":"L68*(1+DSWRESR!$I$3)","v":89140748.815056041},61840169.773755245,208248456.21150541,-42679258.23126024,-5542852680.0159273,56228015.997592941,-236621006.1416859,56228015.997592866,-236621006.14168471,56228015.997592904,-236621006.14168546]
[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,61840169.773755245,{"$f":"L69*(1+DSWRESR!$I$3)","v":92706378.767658278},61840169.773755245,213709304.70870063,-42400078.565775812,-5806966865.78234,59780444.489466235,-186305401.89788711,59780444.489466146,-186305401.89788598,59780444.48946619,-186305401.89788669]
[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,61840169.773755245,{"$f":"L70*(1+DSWRESR!$I$3)","v":96414633.918364614},61840169.773755245,219375498.98673972,-42125857.046705335,-6081371397.4603395,63436240.111938715,-130321377.86186388,63436240.11193864,-130321377.86186279,63436240.111938678,-130321377.86186349]
[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,61840169.773755245,{"$f":"L71*(1+DSWRESR!$I$3)","v":100271219.2750992},61840169.773755245,225254819.73580021,-41857325.653550535,-6366483579.0123034,67198255.814813599,-68335977.161524847,67198255.814813495,-68335977.161523819,67198255.814813554,-68335977.161524475]
[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,61840169.773755245,{"$f":"L72*(1+DSWRESR!$I$3)","v":104282068.04610318},61840169.773755245,231355344.53924629,-41595263.305789024,-6662738185.4785843,71069416.247985139,-7.0035457611083984E-7,71069416.247985035,2.6822090148925781E-7,71069416.247985095,-3.5762786865234375E-7]
[null,null,null,null,null,{"$f":"SUM(F24:F73)","v":150000000},null,null,null,null,{"$f":"SUM(K24:K73)","v":3092008488.6877604}]
[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.0529965081443597,0,2.4312926834411717]

{"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,null,null,null,null,null,null,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,null,null,null,null,null,null,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,null,null,null,null,"Cost Estimate",{"$f":"'Revenues and Expenses'!L7","v":1328461943.8059647},{"$f":"'Revenues and Expenses'!$L$8","v":1750908554.5999455}]
[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},null,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,{"$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,1.04,"<- enter 1 plus assumed interest rate on reserves",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,"Q µ P^(-1/2) is the assumed demand curve, so revenues R = P^(1/2), so to increase R by a factor of \"x\" requires P to go up by a factor of \"x^2\".",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,null,null,{"$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,null,null,null,{"$f":"A24","v":2015},"initial year of spreadsheet"]
[null,{"$f":"S75","v":3.4036290624334322},"The factor by which water sales revenue need to increase to eliminate the debt by 2062, minus one",null,null,null,null,null,null,null,null,null,null,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.4036290624334322},"The factor by which water sales revenue need to increase to eliminate the debt by 2062.",null,null,null,null,null,{"$f":"'Population Estimates'!I12*B13/G4","v":16.111555872336353},"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":"B11^2","v":19.391948919508348},"The factor by which water prices need to increase to eliminate the debt by 2062.",null,null,null,null,null,null,null,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":"1/B11","v":0.22708543018094329},"The factor by which water demanded will change vs. base case when water prices rise enough to eliminate debt by 2062 (since revenue = PQ µ  B5^(-2t) Q^(-2) Q = B5^(-2t) (1/Q) ).",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.7105233872907029},"The factor by which Impact Fees need to increase to eliminate the debt by 2062, minus one.",null,null,null,null,null,null,null,null,null,null,"If either this ->",{"$f":"R73","v":4.0233135223388672E-7},"or this ->",{"$f":"T73","v":5.8114528656005859E-7},"is not zero,"]
[null,{"$f":"B15+1","v":3.7105233872907029},"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,null,null,null,0.5,"<- enter Impact Fees' portion of Split financing"]
[null,{"$f":"B10*$M$19 + 1","v":2.7018145312167161},"The factor by which water sales revenue needs to increase to eliminate the debt by 2062.",null,null,null,null,null,null,null,null,null,{"$f":"1-M18","v":0.5},"Water Rates"]
[null,{"$f":"B19^2","v":7.2998017610938035},"The factor by which water prices need to increase to eliminate the debt by 2062."]
[null,{"$f":"1+B15*$M$18","v":2.3552616936453514},"The factor by which Impact Fees need to increase to eliminate the debt by 2062.",null,null,null,null,null,null,{"$f":"1/B19","v":0.3701216306471144},"The factor by which water demanded will change vs. base case if water prices behave this way."]
[null,{"$f":"B3*B21","v":14371.806854623934},"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":26.25987641294148},"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,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},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,130945384.2410354,0,136054569.2410354,154378237.73580915,-113478800.11417279,226657110.8217462,-78197216.894801289,261938694.0411177,-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.904716149,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.561253682,150622090.49271441,-62870075.561253659,150622090.49271449,-62870075.561253667,150622090.49271449]
[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.883883804,96199960.228539169,-60447013.883883789,96199960.228539303,-60447013.883883789,96199960.228539303]
[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.583404697,42097607.054276042,-57950351.583404683,42097607.054276191,-57950351.58340469,42097607.054276183]
[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.280371867,-10174030.943924785,-53955542.280371852,-10174030.943924613,-53955542.28037186,-10174030.943924628]
[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.196620442,-61679853.378302217,-51098861.196620435,-61679853.37830203,-51098861.196620435,-61679853.378302053]
[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.73083435,-112473384.24426866,-48326336.730834335,-112473384.24426845,-48326336.730834335,-112473384.24426848]
[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.914065816,-162431306.52810523,-45458986.914065801,-162431306.52810499,-45458986.914065808,-162431306.52810502]
[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.740964964,-211422109.5301944,-42493550.740964949,-211422109.53019413,-42493550.740964957,-211422109.53019416]
[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.372325324,-257805648.28372753,-37926654.372325316,-257805648.28372723,-37926654.372325324,-257805648.28372726]
[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.204396352,-302872681.41947299,-34754807.20439636,-302872681.41947269,-34754807.204396352,-302872681.41947269]
[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.800251409,-346461986.47650337,-31474397.800251395,-346461986.47650301,-31474397.800251402,-346461986.47650301]
[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.678331338,-388402155.61389482,-28081689.67833133,-388402155.61389446,-28081689.678331338,-388402155.61389446]
[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.953110196,-428511058.79156083,-24572816.953110203,-428511058.79156047,-24572816.953110196,-428511058.79156047]
[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.822648734,-466595280.96587205,-20943779.822648741,-466595280.96587169,-20943779.822648738,-466595280.96587169]
[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.897615232,-502449532.10212219,-17190439.897615239,-502449532.10212183,-17190439.897615232,-502449532.10212183]
[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.366158798,-535856028.75236589,-13308515.366158806,-535856028.75236553,-13308515.366158802,-535856028.75236553]
[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.9888207018,-566583845.89128125,-9293575.9888207242,-566583845.89128089,-9293575.988820713,-566583845.89128089]
[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.9174608365,-594388237.64439332,-5141037.9174608514,-594388237.64439297,-5141037.9174608402,-594388237.64439297]
[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.33196076751,-619009925.48212993,-846158.33196078241,-619009925.48212945,-846158.33196077496,-619009925.48212945]
[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.1117556989,-640174352.3896594,3595970.111755684,-640174352.38965893,3595970.1117556915,-640174352.38965893]
[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.0290784985,-657590901.45616734,8190425.0290784687,-657590901.45616686,8190425.0290784836,-657590901.45616686]
[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.256374314,-670952077.25803971,12942460.256374285,-670952077.25803936,12942460.2563743,-670952077.25803924]
[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.010134593,-679932648.3382268,17857512.010134548,-679932648.33822632,17857512.01013457,-679932648.3382262]
[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.263047338,-684188749.0087086,22941205.263047323,-684188749.008708,22941205.26304733,-684188749.00870788]
[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.34469308,-683356938.6243639,28199360.344693035,-683356938.6243633,28199360.344693057,-683356938.62436318]
[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.774843991,-676942756.39449453,33748459.774843946,-676942756.39449394,33748459.774843968,-676942756.39449382]
[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.337631464,-664646651.31264293,39373815.337631419,-664646651.31264222,39373815.337631442,-664646651.3126421]
[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.405139863,-646040181.96000886,45192335.405139819,-646040181.96000814,45192335.405139841,-646040181.96000803]
[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.519296408,-620671096.71911287,51210692.519296348,-620671096.71911216,51210692.519296378,-620671096.71911192]
[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.241241008,-588062149.34663641,57435791.241240948,-588062149.3466357,57435791.241240978,-588062149.34663546]
[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.277689844,-547709859.04281211,63874776.27768977,-547709859.04281127,63874776.277689807,-547709859.04281104]
[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.894150287,-499083212.51037431,70535040.894150198,-499083212.51037353,70535040.894150242,-499083212.51037323]
[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.625196382,-441622305.38559288,77424235.625196308,-441622305.38559222,77424235.625196338,-441622305.38559186]
[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.292379647,-374736920.3086369,84550277.292379558,-374736920.30863637,84550277.292379603,-374736920.30863595]
[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.340733409,-297805038.780249,91921358.340733305,-297805038.78024852,91921358.340733349,-297805038.78024805]
[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.505219609,-210171283.82623938,99545956.505219489,-210171283.82623896,99545956.505219549,-210171283.82623842]
[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.81887376,-111145290.36041519,107432844.81887364,-111145290.36041489,107432844.8188737,-111145290.36041427]
[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.97483221,4.0233135223388672E-7,115591101.97483207,5.8114528656005859E-7,115591101.97483215,1.3113021850585938E-6]
[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.4036290624334322,0,2.7105233872907029]

{"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":11285.268723367632},{"$f":"$G4*'First Scenario'!$B$13","v":72.612941908194117},{"$f":"$J4*'First Scenario'!$B$13","v":11285.268723367632},{"$f":"$E4*'First Scenario'!$B$13","v":72.612941908194117},{"$f":"IF(N4>G4,K4,M4)","v":11285.268723367632},null,{"$f":"$I4*'First Scenario'!$J$21","v":18103.77452490139},{"$f":"$G4*'First Scenario'!$J$21","v":116.4853367801267},{"$f":"$J4*'First Scenario'!$J$21","v":18103.77452490139},{"$f":"$E4*'First Scenario'!$J$21","v":116.4853367801267},{"$f":"IF(T4>M4,Q4,S4)","v":18103.77452490139},null,{"$f":"$I4*'Second Scenario'!$B$13","v":10386.695627811223},{"$f":"$G4*'Second Scenario'!$B$13","v":66.831242102251608},{"$f":"$J4*'Second Scenario'!$B$13","v":10386.695627811223},{"$f":"$E4*'Second Scenario'!$B$13","v":66.831242102251608},{"$f":"IF(Z4>S4,W4,Y4)","v":10386.695627811223},null,{"$f":"$I4*'Second Scenario'!$J$21","v":16929.050532821704},{"$f":"$G4*'Second Scenario'!$J$21","v":108.92679589944576},{"$f":"$J4*'Second Scenario'!$J$21","v":16929.050532821704},{"$f":"$E4*'Second Scenario'!$J$21","v":108.92679589944576},{"$f":"IF(AF4>Y4,AC4,AE4)","v":16929.050532821704}]
[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":11172.416036133956},{"$f":"$G5*'First Scenario'!$B$13","v":71.886812489112188},{"$f":"$J5*'First Scenario'!$B$13","v":11285.268723367632},{"$f":"$E5*'First Scenario'!$B$13","v":72.612941908194117},{"$f":"IF(N5>G5,K5,M5)","v":11285.268723367632},null,{"$f":"$I5*'First Scenario'!$J$21","v":17922.736779652376},{"$f":"$G5*'First Scenario'!$J$21","v":115.32048341232544},{"$f":"$J5*'First Scenario'!$J$21","v":18103.77452490139},{"$f":"$E5*'First Scenario'!$J$21","v":116.4853367801267},18103.77452490139,null,{"$f":"$I5*'Second Scenario'!$B$13","v":10282.828671533111},{"$f":"$G5*'Second Scenario'!$B$13","v":66.162929681229102},{"$f":"$J5*'Second Scenario'!$B$13","v":10386.695627811223},{"$f":"$E5*'Second Scenario'!$B$13","v":66.831242102251608},10386.695627811223,null,{"$f":"$I5*'Second Scenario'!$J$21","v":16759.760027493485},{"$f":"$G5*'Second Scenario'!$J$21","v":107.83752794045132},{"$f":"$J5*'Second Scenario'!$J$21","v":16929.050532821704},{"$f":"$E5*'Second Scenario'!$J$21","v":108.92679589944576},16929.050532821704]
[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":15203.725043387283},{"$f":"$G6*'First Scenario'!$B$13","v":68.982294812784403},{"$f":"$J6*'First Scenario'!$B$13","v":16003.921098302404},{"$f":"$E6*'First Scenario'!$B$13","v":72.612941908194117},16003.921098302404,null,{"$f":"$I6*'First Scenario'!$J$21","v":24389.743556052803},{"$f":"$G6*'First Scenario'!$J$21","v":110.66106994112036},{"$f":"$J6*'First Scenario'!$J$21","v":25673.414269529268},{"$f":"$E6*'First Scenario'!$J$21","v":116.4853367801267},25673.414269529268,null,{"$f":"$I6*'Second Scenario'!$B$13","v":13993.150566951756},{"$f":"$G6*'Second Scenario'!$B$13","v":63.489679997139028},{"$f":"$J6*'Second Scenario'!$B$13","v":14729.63217573869},{"$f":"$E6*'Second Scenario'!$B$13","v":66.831242102251608},14729.63217573869,null,{"$f":"$I6*'Second Scenario'!$J$21","v":22807.133428172732},{"$f":"$G6*'Second Scenario'!$J$21","v":103.48045610447348},{"$f":"$J6*'Second Scenario'!$J$21","v":24007.508871760772},{"$f":"$E6*'Second Scenario'!$J$21","v":108.92679589944576},24007.508871760772]
[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":20765.826566627446},{"$f":"$G7*'First Scenario'!$B$13","v":66.07777713645666},{"$f":"$J7*'First Scenario'!$B$13","v":22819.589633656531},{"$f":"$E7*'First Scenario'!$B$13","v":72.612941908194117},22819.589633656531,null,{"$f":"$I7*'First Scenario'!$J$21","v":33312.440421289888},{"$f":"$G7*'First Scenario'!$J$21","v":106.00165646991532},{"$f":"$J7*'First Scenario'!$J$21","v":36607.077386032841},{"$f":"$E7*'First Scenario'!$J$21","v":116.4853367801267},36607.077386032841,null,{"$f":"$I7*'Second Scenario'!$B$13","v":19112.377852453297},{"$f":"$G7*'Second Scenario'!$B$13","v":60.816430313048976},{"$f":"$J7*'Second Scenario'!$B$13","v":21002.613024673952},{"$f":"$E7*'Second Scenario'!$B$13","v":66.831242102251608},21002.613024673952,null,{"$f":"$I7*'Second Scenario'!$J$21","v":31150.851248612787},{"$f":"$G7*'Second Scenario'!$J$21","v":99.12338426849567},{"$f":"$J7*'Second Scenario'!$J$21","v":34231.704668805258},{"$f":"$E7*'Second Scenario'!$J$21","v":108.92679589944576},34231.704668805258]
[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":26607.902765496812},{"$f":"$G8*'First Scenario'!$B$13","v":63.899388879210832},{"$f":"$J8*'First Scenario'!$B$13","v":30236.253142610007},{"$f":"$E8*'First Scenario'!$B$13","v":72.612941908194117},30236.253142610007,null,{"$f":"$I8*'First Scenario'!$J$21","v":42684.271332380777},{"$f":"$G8*'First Scenario'!$J$21","v":102.5070963665115},{"$f":"$J8*'First Scenario'!$J$21","v":48504.853786796324},{"$f":"$E8*'First Scenario'!$J$21","v":116.4853367801267},48504.853786796324,null,{"$f":"$I8*'Second Scenario'!$B$13","v":24489.287237560879},{"$f":"$G8*'Second Scenario'!$B$13","v":58.811493049981429},{"$f":"$J8*'Second Scenario'!$B$13","v":27828.735497228263},{"$f":"$E8*'Second Scenario'!$B$13","v":66.831242102251608},27828.735497228263,null,{"$f":"$I8*'Second Scenario'!$J$21","v":39914.559549370155},{"$f":"$G8*'Second Scenario'!$J$21","v":95.855580391512291},{"$f":"$J8*'Second Scenario'!$J$21","v":45357.454033375165},{"$f":"$E8*'Second Scenario'!$J$21","v":108.92679589944576},45357.454033375165]
[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":32287.011641453311},{"$f":"$G9*'First Scenario'!$B$13","v":60.994871202883054},{"$f":"$J9*'First Scenario'!$B$13","v":38436.918620777753},{"$f":"$E9*'First Scenario'!$B$13","v":72.612941908194117},38436.918620777753,null,{"$f":"$I9*'First Scenario'!$J$21","v":51794.670837515652},{"$f":"$G9*'First Scenario'!$J$21","v":97.84768289530642},{"$f":"$J9*'First Scenario'!$J$21","v":61660.322425613871},{"$f":"$E9*'First Scenario'!$J$21","v":116.4853367801267},61660.322425613871,null,{"$f":"$I9*'Second Scenario'!$B$13","v":29716.205335631559},{"$f":"$G9*'Second Scenario'!$B$13","v":56.138243365891348},{"$f":"$J9*'Second Scenario'!$B$13","v":35376.4349233709},{"$f":"$E9*'Second Scenario'!$B$13","v":66.831242102251608},35376.4349233709,null,{"$f":"$I9*'Second Scenario'!$J$21","v":48433.800295794681},{"$f":"$G9*'Second Scenario'!$J$21","v":91.498508555534443},{"$f":"$J9*'Second Scenario'!$J$21","v":57659.286066422239},{"$f":"$E9*'Second Scenario'!$J$21","v":108.92679589944576},57659.286066422239]
[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":38799.062624073638},{"$f":"$G10*'First Scenario'!$B$13","v":59.542612364719183},{"$f":"$J10*'First Scenario'!$B$13","v":47315.930029358089},{"$f":"$E10*'First Scenario'!$B$13","v":72.612941908194117},47315.930029358089,null,{"$f":"$I10*'First Scenario'!$J$21","v":62241.272116925924},{"$f":"$G10*'First Scenario'!$J$21","v":95.517976159703906},{"$f":"$J10*'First Scenario'!$J$21","v":75903.990386495017},{"$f":"$E10*'First Scenario'!$J$21","v":116.4853367801267},75903.990386495017,null,{"$f":"$I10*'Second Scenario'!$B$13","v":35709.743737531688},{"$f":"$G10*'Second Scenario'!$B$13","v":54.801618523846329},{"$f":"$J10*'Second Scenario'!$B$13","v":43548.46797259961},{"$f":"$E10*'Second Scenario'!$B$13","v":66.831242102251608},43548.46797259961,null,{"$f":"$I10*'Second Scenario'!$J$21","v":58202.538892937562},{"$f":"$G10*'Second Scenario'!$J$21","v":89.319972637545533},{"$f":"$J10*'Second Scenario'!$J$21","v":70978.705966997019},{"$f":"$E10*'Second Scenario'!$J$21","v":108.92679589944576},70978.705966997019]
[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.57695317679987912},null,null,null,null,null,{"$f":"U10/$C$4","v":0.92554554793921495},null,null,null,null,null,{"$f":"AA10/$C$4","v":0.53101411989513003},null,null,null,null,null,{"$f":"AG10/$C$4","v":0.86548842783803215}]
[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.0344732059306936},null,null,null,null,null,{"$f":"U10/$I$4","v":1.6594970072305539},null,null,null,null,null,{"$f":"AA10/$I$4","v":0.95210478266058118},null,null,null,null,null,{"$f":"AG10/$I$4","v":1.5518149906159118}]
[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.0529965081443597},{"$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":3.4312926834411717}]