{"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,"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":34,"n_cols":15,"rows_kept":34,"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}]
[]
["Net Revenues",{"$f":"B32-I15","v":9167677}]

{"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,null,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,"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":"(1+'Population Estimates'!I10)^(2060-2010)","v":4.1927162914059775},"If water sales revenue 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.2008532103870886},"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.2008532103870886},"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,null,0.04,"<- enter interest rate",null,null,null,null,null,"Total Expected Project Costs"]
[null,{"$f":"B11^2","v":17.647167695219508},"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.23804687998318674},"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.4673843485452975},"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":-9.8347663879394531E-7},"or this ->",{"$f":"T73","v":6.5565109252929688E-7},"is not zero,"]
[null,{"$f":"B15+1","v":3.4673843485452975},"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":21157.979294823406},"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.6004266051935443},"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.7622185289984218},"The factor by which water prices need to increase to eliminate the debt by 2062."]
[null,{"$f":"1+B15*$M$18","v":2.2336921742726488},"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.38455228769110833},"The factor by which water demanded will change vs. base case if water prices behave this way."]
[null,{"$f":"B3*B21","v":13629.989647411703},"2013 average Impact Fee per ERU, if Impact Fees increased as much as needed to eliminate the debt by 2062."]
["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","v":7245478.513394814},{"$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":44293957.84025915},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":-37804169.933496103},{"$f":"O24","v":-37804169.933496103},{"$f":"IF(ROW()-24<$N$10,O24,O24+$B$10*C24)","v":-14612456.773105644},{"$f":"Q24","v":-14612456.773105644},{"$f":"IF(ROW()-24<$N$10,O24,O24+$B$15*E24)","v":-14612456.773105618},{"$f":"S24","v":-14612456.773105618},{"$f":"IF(ROW()-24<$N$10,O24,O24 + $M$19*C24*$B$10 + $M$18*E24*$B$15)","v":-14612456.773105631},{"$f":"U24","v":-14612456.773105631}]
[{"$f":"A24+1","v":2016},{"$f":"B24*$B$5","v":10607367.36227509},{"$f":"C24*$B$5","v":7485261.2212441908},{"$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":45263415.484992638},7039458,{"$f":"J24*$B$5","v":13669525.299304644},61840169.773755245,0,{"$f":"K25+I24","v":68866491.773755252},{"$f":"J25+M25+L25","v":82536017.073059902},-37272601.588067263,{"$f":"P24*$B$6+O25","v":-76588938.318903208},{"$f":"IF(ROW()-24<$N$10,O25,O25+$B$10*C25)","v":-13313379.177461814},{"$f":"R24*$B$6+Q25","v":-28510334.221491683},{"$f":"IF(ROW()-24<$N$10,O25,O25+$B$15*E25)","v":-13313379.177461792},{"$f":"T24*$B$6+S25","v":-28510334.221491635},{"$f":"IF(ROW()-24<$N$10,O25,O25 + $M$19*C25*$B$10 + $M$18*E25*$B$15)","v":-13313379.177461805},{"$f":"V24*$B$6+U25","v":-28510334.221491661}]
[{"$f":"A25+1","v":2017},10958408.810341949,7732979.3258899683,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,46264956.473672241,7048107,14121906.157963362,61840169.773755245,0,68879627.773755252,83001533.931718618,-36736577.458046377,-116389073.30970572,-11984445.756914489,-41635193.34726584,-11984445.756914467,-41635193.347265765,-11984445.756914478,-41635193.34726581]
[2018,11321067.664882269,7988895.4422758212,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,47299642.576210618,7048318,14589258.161325341,61840169.773755245,0,68888276.773755252,83477534.935080588,-36177892.35886997,-157222528.60096392,-10606610.735014629,-53907211.81617111,-10606610.735014599,-53907211.81617099,-10606610.735014616,-53907211.816171058]
[2019,11695728.393695829,{"$f":"C27*$B$5","v":8253280.8763548881},{"$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,48368570.700857282,7050648,15072076.766193045,61840169.773755245,0,68888487.773755252,{"$f":"J28+M28+L28","v":83960564.5399483},-35591993.839091018,-199103423.58409351,-9174453.249784112,-65237953.538602069,-9174453.2497840896,-65237953.53860192,-9174453.2497841008,-65237953.538602009]
[2020,12082788.188204451,8526415.9127110466,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,49472874.057070822,6451090,15570873.82607393,61840169.773755245,0,68890817.773755252,84461691.599829182,-34988817.542758361,-242056378.07021564,-7697011.7954616472,-75544483.475607812,-7697011.7954616211,-75544483.475607619,-7697011.7954616342,-75544483.475607738]
[2021,12482657.384529021,8808590.1116987597,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,50613723.356875308,6456332,16086178.133814901,61840169.773755245,0,68291259.773755252,84377437.907570153,-33763714.550694846,-285502347.7437191,-5568710.6126799062,-84134973.427312046,-5568710.6126798801,-84134973.427311808,-5568710.6126798932,-84134973.427311942]
[2022,12895759.898501694,9100102.6164165121,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,51792328.05597461,6138580,16618535.982194789,61840169.773755245,0,68296501.773755252,84915037.755950034,-33122709.699975424,-330045151.35344332,-3994617.0253666863,-91494989.389771223,-3994617.0253666602,-91494989.38977094,-3994617.0253666732,-91494989.389771104]
[2023,13322533.675074434,9401262.4698392469,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,53009937.635940179,5095230,17168511.743069127,61840169.773755245,0,67978749.773755252,85147261.51682438,-32137323.8808842,-375384281.28846526,-2045262.7226075977,-97200051.68796967,-2045262.7226075791,-97200051.687969357,-2045262.7226075884,-97200051.687969536]
[2024,13763431.152600331,9712388.9424460307,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,54267842.928831778,5101740,17736688.46568121,61840169.773755245,0,66935399.773755245,84672088.239436448,-30404245.310604669,-420803897.85060859,683686.01635176688,-100404367.7391367,683686.01635178924,-100404367.73913634,683686.01635177806,-100404367.73913655]
[2025,14218919.742479909,10033811.870690268,3298125.378767123,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A34-$A$24)*$B$4","v":13016520.493718058},0,0,40567377.48565536,5109185,18323668.494773749,61840169.773755245,0,66941909.773755245,85265578.268528998,-44698200.782873638,-482334254.54750657,-12581441.844154615,-117001984.29285678,-12581441.844154593,-117001984.2928564,-12581441.844154606,-117001984.29285662]
[2026,14689482.324680891,10365872.006671272,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},51857665.953491576,5099965,18930074.109156359,61840169.773755245,{"$f":"IF($N$6=\"A\", $O$4,$P$4)","v":23493230.614828616},66949354.773755245,109372659.49774022,-57514993.544248648,-559142618.27365553,-24335358.853233255,-146017422.51780432,-24335358.853233229,-146017422.51780388,-24335358.853233241,-146017422.51780412]
[2027,15175617.759656766,10708921.379377935,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},53642547.561032511,3178350,19556548.181405887,61840169.773755245,{"$f":"L35*(1+DSWRESR!$I$3)","v":24432959.83942176},66940134.773755245,110929642.79458289,-57287095.233550377,-638795418.23815215,-23009409.856585585,-174867529.27510211,-23009409.856585562,-174867529.2751016,-23009409.856585573,-174867529.27510184]
[2028,15677841.417206837,11063323.667887406,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},55489246.167281166,3178995,20203754.859398942,61840169.773755245,{"$f":"L36*(1+DSWRESR!$I$3)","v":25410278.232998632},65018519.773755245,110632552.86615282,-55143306.698871657,-719490541.66654992,-19731231.618962795,-201593462.06506899,-19731231.618962772,-201593462.06506842,-19731231.618962783,-201593462.06506872]
[2029,16196685.722838432,11429454.586914478,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},57399917.467951275,3188875,20872380.270399138,61840169.773755245,{"$f":"L37*(1+DSWRESR!$I$3)","v":26426689.362318579},65019164.773755245,112318234.40647295,-54918316.938521676,-803188480.27173352,-18334310.531023033,-227991511.07869479,-18334310.531023018,-227991511.07869419,-18334310.531023026,-227991511.07869449]
[2030,16732700.722210484,11807702.28512037,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},59376792.896272056,1786290,21563133.248445477,61840169.773755245,{"$f":"L38*(1+DSWRESR!$I$3)","v":27483756.936811324},65029044.773755245,114075934.95901205,-54699142.062739991,-890015161.5453428,-16904420.296117492,-254015591.81796008,-16904420.296117477,-254015591.81795946,-16904420.296117485,-254015591.81795976]
[2031,17286454.664256882,12198467.7566032,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},61422182.305321135,1610460,22276746.085813012,61840169.773755245,{"$f":"L39*(1+DSWRESR!$I$3)","v":28583107.214283779},63626459.773755245,114486313.07385203,-53064130.768530898,-978679898.77568734,-14018626.088004157,-278194841.57868266,-14018626.088004142,-278194841.57868195,-14018626.088004149,-278194841.5786823]
[2032,17858534.603607763,12602165.266006365,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},63538476.746161684,1610460,23013975.309342444,61840169.773755245,{"$f":"L40*(1+DSWRESR!$I$3)","v":29726431.502855133},63450629.773755245,116191036.58595283,-52652559.839791149,-1070479654.566506,-12314878.690266013,-301637513.932096,-12314878.690265998,-301637513.93209523,-12314878.690266006,-301637513.93209565]
[2033,18449547.022947405,13019222.787695508,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},65728151.345235527,1610460,23775602.48246165,61840169.773755245,{"$f":"L41*(1+DSWRESR!$I$3)","v":30915488.762969341},63450629.773755245,118141721.01918624,-52413569.673950717,-1165712410.4231169,-10740948.617210805,-324443963.10659069,-10740948.617210798,-324443963.10658985,-10740948.617210802,-324443963.10659027]
[2034,19060118.475968521,13450082.459469657,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},67993768.284589827,1610460,24562435.033749402,61840169.773755245,{"$f":"L42*(1+DSWRESR!$I$3)","v":32152108.313488115},63450629.773755245,120165173.12099276,-52171404.836402938,-1264512311.6764445,-9119665.2160384133,-346541386.84689271,-9119665.2160383984,-346541386.84689188,-9119665.2160384059,-346541386.8468923]
[2035,19690896.251604531,13895201.051287543,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},70337979.888644591,110460,25375307.112919681,61840169.773755245,{"$f":"L43*(1+DSWRESR!$I$3)","v":33438192.64602764},63450629.773755245,122264129.53270257,-51926149.644057974,-1367018953.7875605,-7449650.7500701919,-367852693.07083863,-7449650.7500701845,-367852693.07083774,-7449650.7500701882,-367852693.07083821]
[2036,20342549.060244031,14355050.449505983,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},72763531.821343988,110460,26215080.475134037,61840169.773755245,{"$f":"L44*(1+DSWRESR!$I$3)","v":34775720.351868749},61950629.773755245,122941430.60075803,-50177898.779414043,-1471877610.7184768,-4229489.4628442004,-386796290.2565164,-4229489.4628442004,-386796290.25651544,-4229489.4628442004,-386796290.25651592]
[2037,21015767.742654927,14830118.157143721,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},75273266.397672772,110460,27082645.39457947,61840169.773755245,{"$f":"L45*(1+DSWRESR!$I$3)","v":36166749.165943503},61950629.773755245,125200024.33427823,-49926757.936605453,-1580679473.0838213,-2457726.622892119,-404725868.4896692,-2457726.6228921041,-404725868.48966813,-2457726.6228921115,-404725868.48966873]
[2038,21711266.002369773,15320907.810701054,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},77870126.013666064,110460,27978921.608280368,61840169.773755245,{"$f":"L46*(1+DSWRESR!$I$3)","v":37613419.132581241},61950629.773755245,127542970.51461685,-49672844.500950783,-1693579496.5081251,-632867.54902369529,-421547770.77827966,-632867.54902368039,-421547770.77827853,-632867.54902368784,-421547770.77827919]
[2039,22429781.162308756,15827939.714083139,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},80557156.699188977,110460,28904859.29114509,61840169.773755245,{"$f":"L47*(1+DSWRESR!$I$3)","v":39117955.897884496},61950629.773755245,129973444.96278483,-49416288.263595849,-1810738964.632046,1246623.38404046,-437163058.22537041,1246623.38404046,-437163058.22536922,1246623.38404046,-437163058.22536987]
[2040,23172074.94644247,16351751.390193032,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},83337511.797920108,110460,29861440.063280813,61840169.773755245,{"$f":"L48*(1+DSWRESR!$I$3)","v":40682674.133799873},61950629.773755245,132494743.97083592,-49157232.172915816,-1932325755.3902435,3182323.7598350868,-451467256.79455018,3182323.7598350868,-451467256.79454893,3182323.7598350868,-451467256.79454964]
[2041,23938934.287323095,16892898.150779203,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},86214455.77913323,110460,30849678.030644611,61840169.773755245,{"$f":"L49*(1+DSWRESR!$I$3)","v":42309981.099151872},61950629.773755245,135110288.90355173,-48895833.124418497,-2058514618.7302718,5175854.1542452276,-464350092.91208696,5175854.1542452127,-464350092.91208571,5175854.1542452201,-464350092.91208643]
[2042,24731172.160340142,17451953.685141649,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},89191368.186039507,110460,31870620.860133935,61840169.773755245,{"$f":"L50*(1+DSWRESR!$I$3)","v":44002380.343117945},61950629.773755245,137823630.97700712,-48632262.790967613,-2189487466.2704501,{"$f":"IF(ROW()-24<$N$10,O51,O51+$B$10*C51)","v":7228879.1896448135},-475695217.43892562,7228879.1896448135,-475695217.43892437,7228879.1896448135,-475695217.43892509]
[2043,25549628.445585128,18029510.668320734,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},92271747.725626275,110460,32925350.890256286,61840169.773755245,{"$f":"L51*(1+DSWRESR!$I$3)","v":45762475.556842662},61950629.773755245,140638456.22085419,-48366708.495227918,-2325433673.4164958,9343108.6091747656,-485379917.52730787,9343108.6091747507,-485379917.52730662,9343108.6091747582,-485379917.52730739]
[2044,26395170.818238914,18626181.389413465,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},95459216.505108088,110460,34014986.278555498,61840169.773755245,{"$f":"L52*(1+DSWRESR!$I$3)","v":47592974.579116367},61950629.773755245,143558590.63142711,-48099374.126319021,-2466550394.4794745,11520298.371237308,-493274815.85716283,11520298.371237293,-493274815.85716164,11520298.3712373,-493274815.85716242]
[2045,27268695.668425616,19242598.400683381,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},98757524.42029269,110460,35140682.187011085,61840169.773755245,{"$f":"L53*(1+DSWRESR!$I$3)","v":49496693.56228102},61950629.773755245,{"$f":"J54+M54+L54","v":146588005.52304736},-47830481.102754667,-2613042891.3614082,13762251.764262185,-499243556.72718716,13762251.764262162,-499243556.72718596,13762251.764262173,-499243556.72718674]
[2046,28171129.051508285,19879415.188152131,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},102170553.70135778,110460,36303632.006667353,61840169.773755245,{"$f":"L54*(1+DSWRESR!$I$3)","v":51476561.304772265},61950629.773755245,149730823.08519486,-47560269.383837074,-2765124876.3997021,16070820.541777521,-503142478.4544971,16070820.541777506,-503142478.45449591,16070820.541777514,-503142478.45449674]
[2047,29103427.669833761,20537306.864383701,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},105702323.62173527,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":-47288998.531773627},-2923018869.987464,18447906.077793732,-504820271.51488328,18447906.077793725,-504820271.51488203,18447906.077793729,-504820271.51488292]
[2048,{"$f":"B56*$B$5","v":30066579.886967517},{"$f":"C56*$B$5","v":21216970.884195719},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},109356995.37600787,110460,{"$f":"J56*$B$5","v":38746265.721894972},61840169.773755245,{"$f":"L56*(1+DSWRESR!$I$3)","v":55677048.707241684},{"$f":"K57+I56","v":61950629.773755245},156373944.20289189,-47016948.826884016,{"$f":"P56*$B$6+O57","v":-3086956573.6138463},20895460.54248324,-504117621.83299541,20895460.542483225,-504117621.8329941,20895460.542483233,-504117621.83299506]
[2049,31061606.775493719,21919127.784056589,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},113138877.132938,110460,40028539.142024733,61840169.773755245,{"$f":"L57*(1+DSWRESR!$I$3)","v":57904130.655531354},61950629.773755245,159883299.57131132,-46744422.438373327,-3257179258.9967737,23415488.098109037,-500866838.60820627,23415488.098109007,-500866838.6082049,23415488.098109022,-500866838.60820585]
[2050,32089563.199491274,22644521.945952326,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},117052429.2699734,110460,41353248.267720878,61840169.773755245,{"$f":"L58*(1+DSWRESR!$I$3)","v":60220295.88175261},61950629.773755245,163524173.92322874,-46471744.653255343,-3433938174.0099001,26010046.115127042,-494891466.03740752,26010046.115127027,-494891466.03740609,26010046.115127034,-494891466.0374071]
[2051,33151538.932833493,23393922.386532892,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},121102269.7958048,110460,42721797.471154466,61840169.773755245,{"$f":"L59*(1+DSWRESR!$I$3)","v":62629107.717022717},61950629.773755245,167301534.96193242,-46199265.166127622,-3617494966.1364241,28681246.408352569,-486005878.27055126,28681246.408352524,-486005878.27054977,28681246.408352546,-486005878.27055085]
[2052,34248659.814496882,24168123.57237462,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},125293179.96779248,0,44135637.600952372,61840169.773755245,{"$f":"L60*(1+DSWRESR!$I$3)","v":65134272.025703631},61950629.773755245,171220539.40041125,-45927359.432618767,-3808122124.2145,31431256.4930484,-474014856.90832496,31431256.49304837,-474014856.90832341,31431256.493048385,-474014856.90832454]
[2053,35382088.942103863,24967946.262223035,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},129630110.11132671,0,45596267.520294525,61840169.773755245,{"$f":"L61*(1+DSWRESR!$I$3)","v":67739642.906731784},61840169.773755245,175176080.20078155,-45545970.089454845,-4005992979.2725348,34372760.860754073,-458602690.32390392,34372760.860754028,-458602690.32390237,34372760.86075405,-458602690.32390344]
[2054,36553027.904964723,25794238.377108965,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},134118185.64844663,0,47105235.695913084,61840169.773755245,{"$f":"L62*(1+DSWRESR!$I$3)","v":70449228.623001054},61840169.773755245,179394634.09266937,-45276448.444222733,-4211509146.8876591,37287122.274636343,-439659675.66222376,37287122.274636313,-439659675.66222215,37287122.274636328,-439659675.66222328]
[2055,37762718.057926007,26647875.899260357,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},138762713.34330919,0,48664141.839678183,61840169.773755245,{"$f":"L63*(1+DSWRESR!$I$3)","v":73267197.767921105},61840169.773755245,183771509.38135451,-45008796.038045317,-4424978308.8012104,40287143.08409892,-416958919.60461378,40287143.08409889,-416958919.60461217,40287143.084098905,-416958919.6046133]
[2056,39012441.837375805,27529763.800762802,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},143569187.77237859,0,50274638.604510471,61840169.773755245,{"$f":"L64*(1+DSWRESR!$I$3)","v":76197885.678637952},61840169.773755245,188312694.05690366,-44743506.284525067,-4646720947.4377842,43375226.558344811,-390262049.83045352,43375226.558344766,-390262049.83045191,43375226.558344789,-390262049.8304531]
[2057,40303524.120801046,28440837.002953246,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},148543298.02749404,0,51938433.336418398,61840169.773755245,{"$f":"L65*(1+DSWRESR!$I$3)","v":79245801.105783477},61840169.773755245,193024404.21595711,-44481106.188463062,-4877070891.5237589,46553838.238535732,-359318693.58513594,46553838.238535687,-359318693.58513427,46553838.23853571,-359318693.58513552]
[2058,41637333.631338164,29382061.367563996,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},153690934.6602731,0,53657289.884517603,61840169.773755245,{"$f":"L66*(1+DSWRESR!$I$3)","v":82415633.150014818},61840169.773755245,197913092.80828768,-44222158.148014575,-5116375885.3327246,49825507.308143094,-323865934.02039832,49825507.308143035,-323865934.02039665,49825507.308143064,-323865934.0203979]
[2059,43015284.38880612,30354434.720667772,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},159018196.87661749,0,55433030.470951319,61840169.773755245,{"$f":"L67*(1+DSWRESR!$I$3)","v":85712258.476015419},61840169.773755245,202985458.72072199,-43967261.844104499,-5364998182.5901384,53192827.981030241,-283627743.40018404,53192827.981030196,-283627743.40018237,53192827.981030218,-283627743.40018362]
[2060,44438837.208760075,31358987.910509281,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},164531399.99040961,0,57267537.622694142,61840169.773755245,{"$f":"L68*(1+DSWRESR!$I$3)","v":89140748.815056041},61840169.773755245,208248456.21150541,-43717056.2210958,-5623315166.1148405,56658460.906747729,-238314392.2294437,56658460.906747669,-238314392.22944203,56658460.906747699,-238314392.22944325]
[2061,45909501.251154914,32396785.90034483,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},170237083.14582118,0,59162756.167287104,61840169.773755245,{"$f":"L69*(1+DSWRESR!$I$3)","v":92706378.767658278},61840169.773755245,213709304.70870063,-43472221.562879443,-5891719994.3223143,60225134.592462465,-187621833.326159,60225134.592462376,-187621833.32615733,60225134.59246242,-187621833.32615858]
[2062,47428835.620260432,33468928.897448476,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},176142017.31800124,0,61120695.294619866,61840169.773755245,{"$f":"L70*(1+DSWRESR!$I$3)","v":96414633.918364614},61840169.773755245,219375498.98673972,-43233481.668738484,-6170622275.7639456,63895646.840876669,-131231059.81832871,63895646.840876594,-131231059.81832702,63895646.840876631,-131231059.81832829]
[2063,48998451.017524302,34576553.519481659,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},182253213.60226858,0,63143430.686945781,61840169.773755245,{"$f":"L71*(1+DSWRESR!$I$3)","v":100271219.2750992},61840169.773755245,225254819.73580021,-43001606.13353163,-6460448772.9280348,67672866.203422219,-68807436.007639647,67672866.203422129,-68807436.007637978,67672866.203422174,-68807436.007639244]
[2064,50620011.449135073,35720833.999462768,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},188577931.80230588,0,65233106.719387874,61840169.773755245,{"$f":"L72*(1+DSWRESR!$I$3)","v":104282068.04610318},61840169.773755245,231355344.53924629,-42777412.736940414,-6761644136.5820971,71559733.447944254,-9.8347663879394531E-7,71559733.447944149,6.5565109252929688E-7,71559733.447944194,-6.2584877014160156E-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.2008532103870886,0,2.4673843485452975]

{"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,null,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":"(1+'Population Estimates'!I10)^(2060-2010)","v":4.1927162914059775},"If water sales revenue 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.5768778552397915},"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.5768778552397915},"The factor by which water sales revenue need to increase to eliminate the debt by 2062.",null,null,null,null,null,null,null,null,null,null,0.04,"<- enter interest rate",null,null,null,null,null,"Total Expected Project Costs"]
[null,{"$f":"B11^2","v":20.947810901784393},"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.21848955371512926},"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.7572437274028063},"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":6.7055225372314453E-7},"or this ->",{"$f":"T73","v":4.0233135223388672E-7},"is not zero,"]
[null,{"$f":"B15+1","v":3.7572437274028063},"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":22926.701224611923},"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.7884389276198958},"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.7753916530659941},"The factor by which water prices need to increase to eliminate the debt by 2062."]
[null,{"$f":"1+B15*$M$18","v":2.3786218637014032},"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.35862359763194152},"The factor by which water demanded will change vs. base case if water prices behave this way."]
[null,{"$f":"B3*B21","v":14514.350612305961},"2013 average Impact Fee per ERU, if Impact Fees increased as much as needed to eliminate the debt by 2062."]
["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","v":7245478.513394814},{"$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":44293957.84025915},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":24035999.84025915},{"$f":"O24","v":24035999.84025915},{"$f":"IF(ROW()-24<$N$10,O24,O24+$B$10*C24)","v":24035999.84025915},{"$f":"IF(ROW()-24<$N$10,P24,P24+$B$10*D24)","v":24035999.84025915},{"$f":"IF(ROW()-24<$N$10,Q24,Q24+$B$10*E24)","v":24035999.84025915},{"$f":"IF(ROW()-24<$N$10,R24,R24+$B$10*G24)","v":24035999.84025915},24035999.84025915,24035999.84025915]
[{"$f":"A24+1","v":2016},{"$f":"B24*$B$5","v":10607367.36227509},7485261.2212441908,{"$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":45263415.484992638},7039458,{"$f":"J24*$B$5","v":13669525.299304644},0,0,{"$f":"K25+I24","v":7026322},{"$f":"J25+M25+L25","v":20695847.299304642},24567568.185687996,{"$f":"P24*$B$6+O25","v":49565008.019557513},{"$f":"IF(ROW()-24<$N$10,O25,O25+$B$10*C25)","v":24567568.185687996},{"$f":"IF(ROW()-24<$N$10,P25,P25+$B$10*D25)","v":49565008.019557513},24567568.185687996,49565008.019557513,24567568.185687996,49565008.019557513]
[{"$f":"A25+1","v":2017},10958408.810341949,7732979.3258899683,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,46264956.473672241,7048107,14121906.157963362,0,0,7039458,21161364.157963362,25103592.315708879,76651200.6560487,25103592.315708879,76651200.6560487,25103592.315708879,76651200.6560487,25103592.315708879,76651200.6560487]
[2018,11321067.664882269,7988895.4422758212,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,47299642.576210618,7048318,14589258.161325341,0,0,7048107,21637365.161325343,25662277.414885275,105379526.09717593,25662277.414885275,105379526.09717593,25662277.414885275,105379526.09717593,25662277.414885275,105379526.09717593]
[2019,11695728.393695829,{"$f":"C27*$B$5","v":8253280.8763548881},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,48368570.700857282,7050648,15072076.766193045,0,0,7048318,{"$f":"J28+M28+L28","v":22120394.766193047},26248175.934664235,135842883.07572719,26248175.934664235,135842883.07572719,26248175.934664235,135842883.07572719,26248175.934664235,135842883.07572719]
[2020,12082788.188204451,8526415.9127110466,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,49472874.057070822,6451090,15570873.82607393,0,0,7050648,22621521.82607393,26851352.230996892,168127950.62975317,26851352.230996892,168127950.62975317,26851352.230996892,168127950.62975317,26851352.230996892,168127950.62975317]
[2021,12482657.384529021,8808590.1116987597,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,50613723.356875308,6456332,16086178.133814901,0,0,6451090,22537268.133814901,28076455.223060407,202929523.87800372,28076455.223060407,202929523.87800372,28076455.223060407,202929523.87800372,28076455.223060407,202929523.87800372]
[2022,12895759.898501694,9100102.6164165121,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,51792328.05597461,6138580,16618535.982194789,0,0,6456332,23074867.982194789,28717460.073779821,239764164.90690368,28717460.073779821,239764164.90690368,28717460.073779821,239764164.90690368,28717460.073779821,239764164.90690368]
[2023,13322533.675074434,9401262.4698392469,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,53009937.635940179,5095230,17168511.743069127,0,0,6138580,23307091.743069127,29702845.892871052,279057577.39605093,29702845.892871052,{"$f":"R31*$B$6+Q32","v":279057577.39605093},{"$f":"IF(ROW()-24<$N$10,O32,O32+$B$15*E32)","v":29702845.892871052},{"$f":"T31*$B$6+S32","v":279057577.39605093},{"$f":"IF(ROW()-24<$N$10,O32,O32 + $M$19*C32*$B$10 + $M$18*E32*$B$15)","v":29702845.892871052},{"$f":"V31*$B$6+U32","v":279057577.39605093}]
[2024,13763431.152600331,9712388.9424460307,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,54267842.928831778,5101740,17736688.46568121,0,0,5095230,22831918.46568121,31435924.463150568,321655804.95504355,31435924.463150568,321655804.95504355,31435924.463150568,321655804.95504355,31435924.463150568,321655804.95504355]
[2025,14218919.742479909,10033811.870690268,3298125.378767123,{"$f":"$B$3*'Population Estimates'!$E$4*$B$5^(A34-$A$24)*$B$4","v":13016520.493718058},0,0,40567377.48565536,5109185,18323668.494773749,130945384.2410354,0,136047124.2410354,154370792.73580915,-113803415.25015378,220718621.90309155,-77913695.766239613,256608341.38700572,-77913695.766239583,256608341.38700575,-77913695.766239598,256608341.38700575]
[2026,14689482.324680891,10365872.006671272,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},113915659.30468065,5099965,18930074.109156359,130945384.2410354,{"$f":"IF($N$6=\"A\", $O$4,$P$4)","v":62867794.266077146},136054569.2410354,217852437.61626893,-103936778.31158829,125610588.46762693,-66859320.280675754,200013354.76181018,-66859320.280675724,200013354.76181024,-66859320.280675747,200013354.76181024]
[2027,15175617.759656766,10708921.379377935,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},118182860.64626916,3178350,19556548.181405887,130945384.2410354,{"$f":"L35*(1+DSWRESR!$I$3)","v":65382506.036720231},136045349.2410354,220984403.45916152,-102801542.81289236,27833469.193439648,-64497039.077491462,143516849.87479115,-64497039.077491432,143516849.87479123,-64497039.077491455,143516849.8747912]
[2028,15677841.417206837,11063323.667887406,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},122611171.77592728,3178995,20203754.859398942,130945384.2410354,{"$f":"L36*(1+DSWRESR!$I$3)","v":67997806.278189048},134123734.2410354,222325295.37862337,-99714123.602696091,-70767315.641518861,-60141966.169679359,89115557.700103447,-60141966.169679336,89115557.700103551,-60141966.169679359,89115557.700103506]
[2029,16196685.722838432,11429454.586914478,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},127206720.10094324,3188875,20872380.270399138,130945384.2410354,{"$f":"L37*(1+DSWRESR!$I$3)","v":70717718.529316619},134124379.2410354,225714478.04075116,-98507757.939807922,-172105766.20698756,-57625994.930404663,35054185.077702925,-57625994.930404641,35054185.077703051,-57625994.930404648,35054185.077702999]
[2030,16732700.722210484,11807702.28512037,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},131975867.63458371,1786290,21563133.248445477,130945384.2410354,{"$f":"L38*(1+DSWRESR!$I$3)","v":73546427.27048929},134134259.2410354,229243819.75997019,-97267952.125386477,-276257948.98065352,-55033243.300475143,-18576890.819664098,-55033243.300475113,-18576890.819663942,-55033243.300475135,-18576890.819664016]
[2031,17286454.664256882,12198467.7566032,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},136925220.03316525,1610460,22276746.085813012,130945384.2410354,{"$f":"L39*(1+DSWRESR!$I$3)","v":76488284.361308858},132731674.2410354,231496704.68815726,-94571484.654992014,-381879751.59487164,-50939055.468541406,-70259021.920992076,-50939055.468541384,-70259021.920991883,-50939055.468541399,-70259021.920991972]
[2032,{"$f":"B40*$B$5","v":17858534.603607763},12602165.266006365,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},142061635.98311955,1610460,23013975.309342444,130945384.2410354,{"$f":"L40*(1+DSWRESR!$I$3)","v":79547815.73576121},132555844.2410354,235117635.28613907,-93055999.303019524,-490210940.96168602,-47979593.434969276,-121048976.23280104,-47979593.434969254,-121048976.23280081,-47979593.434969261,-121048976.23280092]
[2033,18449547.022947405,13019222.787695508,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},147392236.95167172,1610460,23775602.48246165,130945384.2410354,{"$f":"L41*(1+DSWRESR!$I$3)","v":82729728.365191668},132555844.2410354,239061175.08868873,-91668938.137017012,-601488316.73717046,-45100768.455275685,-170991703.73738876,-45100768.45527567,-170991703.73738852,-45100768.455275677,-170991703.73738864]
[2034,19060118.475968521,13450082.459469657,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},152924417.31528345,1610460,24562435.033749402,130945384.2410354,{"$f":"L42*(1+DSWRESR!$I$3)","v":86038917.499799341},132555844.2410354,243157196.77458414,-90232779.459300697,-715780628.86595798,-42123477.35887453,-219954849.24575883,-42123477.358874507,-219954849.24575856,-42123477.358874515,-219954849.24575871]
[2035,19690896.251604531,13895201.051287543,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},158665854.88056597,110460,25375307.112919681,130945384.2410354,{"$f":"L43*(1+DSWRESR!$I$3)","v":89480474.199791312},132555844.2410354,247411625.5537464,-88745770.673180431,-833157624.69377673,-39044333.738725349,-267797376.95431453,-39044333.738725334,-267797376.95431426,-39044333.738725342,-267797376.95431441]
[2036,20342549.060244031,14355050.449505983,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},164624521.81294224,110460,26215080.475134037,130945384.2410354,{"$f":"L44*(1+DSWRESR!$I$3)","v":93059693.167782962},131055844.2410354,250330617.88395241,-85706096.071010172,-952190025.75253797,-34359834.007322207,-312869106.03980929,-34359834.0073222,-312869106.03980905,-34359834.007322207,-312869106.03980917]
[2037,21015767.742654927,14830118.157143721,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},170808695.98893496,110460,27082645.39457947,130945384.2410354,{"$f":"L45*(1+DSWRESR!$I$3)","v":96782080.89449428},131055844.2410354,254920570.53010917,-84111874.541174203,-1074389501.3238137,-31066353.314297281,-356450223.59569895,-31066353.314297259,-356450223.59569865,-31066353.314297274,-356450223.59569883]
[2038,21711266.002369773,15320907.810701054,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},177226972.78857875,110460,27978921.608280368,130945384.2410354,{"$f":"L46*(1+DSWRESR!$I$3)","v":100653364.13027406},131055844.2410354,259688129.97958982,-82461157.191011071,-1199826238.5677772,-27660141.32074412,-398368373.86027104,-27660141.320744097,-398368373.86027074,-27660141.320744112,-398368373.86027092]
[2039,22429781.162308756,15827939.714083139,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},183888277.34509814,110460,28904859.29114509,130945384.2410354,{"$f":"L47*(1+DSWRESR!$I$3)","v":104679498.69548503},131055844.2410354,264640202.22766551,-80751924.882567376,-1328571212.9930556,-24137317.825192958,-438440426.63987482,-24137317.825192958,-438440426.63987458,-24137317.825192958,-438440426.6398747]
[2040,23172074.94644247,16351751.390193032,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},190801877.26966566,110460,29861440.063280813,130945384.2410354,{"$f":"L48*(1+DSWRESR!$I$3)","v":108866678.64330444},131055844.2410354,269783962.94762063,-78982085.677954972,-1460696147.1907327,-20493868.235987037,-476471911.94145691,-20493868.23598703,-476471911.94145656,-20493868.235987034,-476471911.94145674]
[2041,23938934.287323095,16892898.150779203,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},197977395.86974859,110460,30849678.030644611,130945384.2410354,{"$f":"L49*(1+DSWRESR!$I$3)","v":113221345.78903662},131055844.2410354,275126868.06071663,-77149472.190968037,-1596273465.26933,-16725638.884624682,-512256427.30373985,-16725638.884624682,-512256427.30373949,-16725638.884624686,-512256427.30373967]
[2042,24731172.160340142,17451953.685141649,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},205424825.88027951,110460,31870620.860133935,130945384.2410354,{"$f":"L50*(1+DSWRESR!$I$3)","v":117750199.62059809},131055844.2410354,280676664.72176743,-75251838.841487914,-1735376242.7215912,-12828332.174434274,-545575016.57032371,-12828332.174434267,-545575016.57032335,-12828332.174434271,-545575016.57032359]
[2043,25549628.445585128,18029510.668320734,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},213154543.72763589,110460,32925350.890256286,130945384.2410354,{"$f":"L51*(1+DSWRESR!$I$3)","v":122460207.60542202},131055844.2410354,286441402.73671371,-73286859.009077817,-1878078151.4395328,-8797501.5587518066,-576195518.79188848,-8797501.5587518215,-576195518.79188812,-8797501.5587518141,-576195518.79188836]
[2044,26395170.818238914,18626181.389413465,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},221177324.3471981,110460,34014986.278555498,130945384.2410354,{"$f":"L52*(1+DSWRESR!$I$3)","v":127358615.90963891},131055844.2410354,292429446.42922986,-71252122.082031757,-2024453399.5791459,-4628546.3425592035,-603871885.8861233,-4628546.342559211,-603871885.88612282,-4628546.3425592072,-603871885.88612318]
[2045,27268695.668425616,19242598.400683381,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},229504356.57606632,110460,35140682.187011085,130945384.2410354,{"$f":"L53*(1+DSWRESR!$I$3)","v":132452960.54602447},131055844.2410354,{"$f":"J54+M54+L54","v":298649486.97407097},-69145130.398004651,-2174576665.9603167,-316706.30132763088,-628343467.62289584,-316706.30132766068,-628343467.62289548,-316706.30132764578,-628343467.62289572]
[2046,28171129.051508285,19879415.188152131,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},238147259.14336234,110460,36303632.006667353,130945384.2410354,{"$f":"L54*(1+DSWRESR!$I$3)","v":137751078.96786547},131055844.2410354,305110555.21556818,-66963296.072205842,-2328523028.6709356,4142943.8894130886,-649334262.4383986,4142943.8894130737,-649334262.43839824,4142943.8894130811,-649334262.43839848]
[2047,29103427.669833761,20537306.864383701,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},247118097.28142002,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,-64703937.708986014,-2486367887.5267591,8755500.420492202,-666552132.51544237,8755500.420492202,-666552132.51544201,8755500.420492202,-666552132.51544225]
[2048,{"$f":"B56*$B$5","v":30066579.886967517},21216970.884195719,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},256429399.98208001,110460,38746265.721894972,130945384.2410354,{"$f":"L56*(1+DSWRESR!$I$3)","v":148991567.01164329},131055844.2410354,318793676.97457367,-62364276.992493659,-2648186880.0203233,13526236.318453431,-679687981.49760664,13526236.318453431,-679687981.49760628,13526236.318453431,-679687981.49760652]
[2049,31061606.775493719,21919127.784056589,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},266094177.92325306,110460,40028539.142024733,130945384.2410354,{"$f":"L57*(1+DSWRESR!$I$3)","v":154951229.69210902},131055844.2410354,326035613.07516915,-59941435.151916087,-2814055790.3730521,18460607.625047162,-688414893.13246369,18460607.625047147,-688414893.13246346,18460607.625047155,-688414893.13246357]
[2050,32089563.199491274,22644521.945952326,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},276125942.09190106,110460,41353248.267720878,130945384.2410354,{"$f":"L58*(1+DSWRESR!$I$3)","v":161149278.87979338},131055844.2410354,333558371.38854969,-57432429.296648622,-2984050451.2846227,23564259.794319719,-692387229.06344247,23564259.794319719,-692387229.06344223,23564259.794319719,-692387229.06344235]
[2051,33151538.932833493,23393922.386532892,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},286538723.13060951,110460,42721797.471154466,130945384.2410354,{"$f":"L59*(1+DSWRESR!$I$3)","v":167595250.03498513},131055844.2410354,341372891.74717498,-54834168.616565466,-3158246637.9525728,28843034.315022454,-691239683.91095769,28843034.315022424,-691239683.91095746,28843034.315022439,-691239683.91095757]
[2052,34248659.814496882,24168123.57237462,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},297347091.43598944,0,44135637.600952372,130945384.2410354,{"$f":"L60*(1+DSWRESR!$I$3)","v":174299060.03638452},131055844.2410354,349490541.87837231,-52143450.442382872,-3336719953.9130588,34302975.566342711,-684586295.70105326,34302975.566342682,-684586295.70105302,34302975.566342697,-684586295.70105314]
[2053,35382088.942103863,24967946.262223035,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},308566178.03825152,0,45596267.520294525,130945384.2410354,{"$f":"L61*(1+DSWRESR!$I$3)","v":181271022.4378399},130945384.2410354,357812674.19916981,-49246496.160918295,-3519435248.2304993,40060797.915244401,-671908949.61385107,40060797.915244371,-671908949.61385083,40060797.915244386,-671908949.61385095]
[2054,36553027.904964723,25794238.377108965,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},320211696.29244846,0,47105235.695913084,130945384.2410354,{"$f":"L62*(1+DSWRESR!$I$3)","v":188521863.33535349},130945384.2410354,366572483.27230197,-46360786.979853511,-3706573445.1395731,45902053.064003929,-652883254.53440118,45902053.0640039,-652883254.53440094,45902053.064003915,-652883254.53440106]
[2055,37762718.057926007,26647875.899260357,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},332299964.4130711,0,48664141.839678183,130945384.2410354,{"$f":"L63*(1+DSWRESR!$I$3)","v":196062737.86876765},130945384.2410354,375672263.94948125,-43372299.536410153,-3898208682.4815664,51943897.656832367,-627054687.05894494,51943897.656832337,-627054687.0589447,51943897.656832352,-627054687.05894482]
[2056,39012441.837375805,27529763.800762802,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},344847928.88493097,0,50274638.604510471,130945384.2410354,{"$f":"L64*(1+DSWRESR!$I$3)","v":203905247.38351837},130945384.2410354,385125270.22906423,-40277341.344133258,-4094414371.1249628,58193261.154797241,-593943613.3865056,58193261.154797211,-593943613.38650537,58193261.154797226,-593943613.38650548]
[2057,40303524.120801046,28440837.002953246,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},357873188.78454852,0,51938433.336418398,130945384.2410354,{"$f":"L65*(1+DSWRESR!$I$3)","v":212061457.27885911},130945384.2410354,394945274.85631287,-37072086.07176435,-4295263032.0417261,64657313.988583565,-553044043.93338227,64657313.988583505,-553044043.93338203,64657313.988583535,-553044043.93338215]
[2058,41637333.631338164,29382061.367563996,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},371394021.04760981,0,53657289.884517603,130945384.2410354,{"$f":"L66*(1+DSWRESR!$I$3)","v":220543915.57001349},130945384.2410354,405146589.69556653,-33752568.647956729,-4500826121.9713526,71343475.998979509,-503822329.69173807,71343475.998979449,-503822329.69173789,71343475.998979479,-503822329.69173801]
[2059,43015284.38880612,30354434.720667772,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},385429406.71944761,0,55433030.470951319,130945384.2410354,{"$f":"L67*(1+DSWRESR!$I$3)","v":229365672.19281405},130945384.2410354,415744086.90480077,-30314680.18535316,-4711173847.0355597,78259425.175325245,-445715797.70408237,78259425.1753252,-445715797.70408219,78259425.175325215,-445715797.70408231]
[2060,44438837.208760075,31358987.910509281,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},399999058.22695297,0,57267537.622694142,130945384.2410354,{"$f":"L68*(1+DSWRESR!$I$3)","v":238540299.08052662},130945384.2410354,426753220.94425619,-26754162.717303216,-4926374963.6342859,85413106.702529773,-378131322.90971589,85413106.702529714,-378131322.90971577,85413106.702529743,-378131322.90971589]
[2061,45909501.251154914,32396785.90034483,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},415123447.71182632,0,59162756.167287104,130945384.2410354,{"$f":"L69*(1+DSWRESR!$I$3)","v":248081911.04374769},130945384.2410354,438190051.45207024,-23066603.740243912,-5146496565.9199018,92812742.327644229,-300443833.49846029,92812742.32764414,-300443833.49846029,92812742.327644184,-300443833.49846035]
[2062,47428835.620260432,33468928.897448476,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},430823836.46664655,0,61120695.294619866,130945384.2410354,{"$f":"L70*(1+DSWRESR!$I$3)","v":258005187.48549762},130945384.2410354,450071267.02115285,-19247430.554506302,-5371603859.1112041,100466840.05737229,-211994746.78102642,100466840.0573722,-211994746.78102648,100466840.05737224,-211994746.78102651]
[2063,48998451.017524302,34576553.519481659,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},447122305.51685977,0,63143430.686945781,130945384.2410354,{"$f":"L71*(1+DSWRESR!$I$3)","v":268325394.98491755},130945384.2410354,462414209.91289878,-15291904.396039009,-5601759917.8716917,108384204.19830841,-112090332.45395908,108384204.19830832,-112090332.45395923,108384204.19830836,-112090332.45395921]
[2064,{"$f":"B72*$B$5","v":50620011.449135073},{"$f":"C72*$B$5","v":35720833.999462768},{"$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},464041787.39348066,0,65233106.719387874,130945384.2410354,{"$f":"L72*(1+DSWRESR!$I$3)","v":279058410.78431427},130945384.2410354,475236901.74473757,-11195114.351256907,-5837025428.9378166,116573945.75211811,6.7055225372314453E-7,116573945.75211801,4.0233135223388672E-7,116573945.75211805,4.6193599700927734E-7]
[null,null,null,null,null,{"$f":"SUM(F24:F73)","v":150000000},null,null,null,null,{"$f":"SUM(K24:K73)","v":5237815369.6414175}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimated Factors to make Final-Year Debt (the blue cells) almost zero:",3.5768778552397915,0,2.7572437274028063]

{"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]]}
[null,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":10888.06307637327},{"$f":"$G4*'First Scenario'!$B$13","v":70.057196779051864},{"$f":"$J4*'First Scenario'!$B$13","v":10888.06307637327},{"$f":"$E4*'First Scenario'!$B$13","v":70.057196779051864},{"$f":"IF(N4>G4,K4,M4)","v":10888.06307637327},null,{"$f":"$I4*'First Scenario'!$J$21","v":17589.096588202112},{"$f":"$G4*'First Scenario'!$J$21","v":113.17373826749319},{"$f":"$J4*'First Scenario'!$J$21","v":17589.096588202112},{"$f":"$E4*'First Scenario'!$J$21","v":113.17373826749319},{"$f":"IF(T4>M4,Q4,S4)","v":17589.096588202112},null,{"$f":"$I4*'Second Scenario'!$B$13","v":9993.5275041075802},{"$f":"$G4*'Second Scenario'!$B$13","v":64.301475658362548},{"$f":"$J4*'Second Scenario'!$B$13","v":9993.5275041075802},{"$f":"$E4*'Second Scenario'!$B$13","v":64.301475658362548},{"$f":"IF(Z4>S4,W4,Y4)","v":9993.5275041075802},null,{"$f":"$I4*'Second Scenario'!$J$21","v":16403.140221658345},{"$f":"$G4*'Second Scenario'!$J$21","v":105.54292478308039},{"$f":"$J4*'Second Scenario'!$J$21","v":16403.140221658345},{"$f":"$E4*'Second Scenario'!$J$21","v":105.54292478308039},{"$f":"IF(AF4>Y4,AC4,AE4)","v":16403.140221658345}]
[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":10779.182445609536},{"$f":"$G5*'First Scenario'!$B$13","v":69.356624811261341},{"$f":"$J5*'First Scenario'!$B$13","v":10888.06307637327},{"$f":"$E5*'First Scenario'!$B$13","v":70.057196779051864},{"$f":"IF(N5>G5,K5,M5)","v":10888.06307637327},null,{"$f":"$I5*'First Scenario'!$J$21","v":17413.205622320093},{"$f":"$G5*'First Scenario'!$J$21","v":112.04200088481826},{"$f":"$J5*'First Scenario'!$J$21","v":17589.096588202112},{"$f":"$E5*'First Scenario'!$J$21","v":113.17373826749319},17589.096588202112,null,{"$f":"$I5*'Second Scenario'!$B$13","v":9893.5922290665058},{"$f":"$G5*'Second Scenario'!$B$13","v":63.658460901778923},{"$f":"$J5*'Second Scenario'!$B$13","v":9993.5275041075802},{"$f":"$E5*'Second Scenario'!$B$13","v":64.301475658362548},9993.5275041075802,null,{"$f":"$I5*'Second Scenario'!$J$21","v":16239.108819441759},{"$f":"$G5*'Second Scenario'!$J$21","v":104.48749553524959},{"$f":"$J5*'Second Scenario'!$J$21","v":16403.140221658345},{"$f":"$E5*'Second Scenario'!$J$21","v":105.54292478308039},16403.140221658345]
[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":14668.602168547937},{"$f":"$G6*'First Scenario'!$B$13","v":66.554336940099262},{"$f":"$J6*'First Scenario'!$B$13","v":15440.633861629409},{"$f":"$E6*'First Scenario'!$B$13","v":70.057196779051864},15440.633861629409,null,{"$f":"$I6*'First Scenario'!$J$21","v":23696.359815950014},{"$f":"$G6*'First Scenario'!$J$21","v":107.51505135411851},{"$f":"$J6*'First Scenario'!$J$21","v":24943.536648368437},{"$f":"$E6*'First Scenario'!$J$21","v":113.17373826749319},24943.536648368437,null,{"$f":"$I6*'Second Scenario'!$B$13","v":13463.467118985895},{"$f":"$G6*'Second Scenario'!$B$13","v":61.086401875444409},{"$f":"$J6*'Second Scenario'!$B$13","v":14172.0706515641},{"$f":"$E6*'Second Scenario'!$B$13","v":64.301475658362548},14172.0706515641,null,{"$f":"$I6*'Second Scenario'!$J$21","v":22098.617223161717},{"$f":"$G6*'Second Scenario'!$J$21","v":100.26577854392636},{"$f":"$J6*'Second Scenario'!$J$21","v":23261.702340170228},{"$f":"$E6*'Second Scenario'!$J$21","v":105.54292478308039},23261.702340170228]
[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":20034.935368645536},{"$f":"$G7*'First Scenario'!$B$13","v":63.752049068937204},{"$f":"$J7*'First Scenario'!$B$13","v":22016.412493017066},{"$f":"$E7*'First Scenario'!$B$13","v":70.057196779051864},22016.412493017066,null,{"$f":"$I7*'First Scenario'!$J$21","v":32365.390507534932},{"$f":"$G7*'First Scenario'!$J$21","v":102.98810182341882},{"$f":"$J7*'First Scenario'!$J$21","v":35566.36319509332},{"$f":"$E7*'First Scenario'!$J$21","v":113.17373826749319},35566.36319509332,null,{"$f":"$I7*'Second Scenario'!$B$13","v":18388.916030808719},{"$f":"$G7*'Second Scenario'!$B$13","v":58.514342849109923},{"$f":"$J7*'Second Scenario'!$B$13","v":20207.600033855731},{"$f":"$E7*'Second Scenario'!$B$13","v":64.301475658362548},20207.600033855731,null,{"$f":"$I7*'Second Scenario'!$J$21","v":30183.132838097128},{"$f":"$G7*'Second Scenario'!$J$21","v":96.044061552603168},{"$f":"$J7*'Second Scenario'!$J$21","v":33168.277844062774},{"$f":"$E7*'Second Scenario'!$J$21","v":105.54292478308039},33168.277844062774]
[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":25671.389024246848},{"$f":"$G8*'First Scenario'!$B$13","v":61.650333165565641},{"$f":"$J8*'First Scenario'!$B$13","v":29172.032982098681},{"$f":"$E8*'First Scenario'!$B$13","v":70.057196779051864},29172.032982098681,null,{"$f":"$I8*'First Scenario'!$J$21","v":41470.786671011163},{"$f":"$G8*'First Scenario'!$J$21","v":99.592889675394019},{"$f":"$J8*'First Scenario'!$J$21","v":47125.893944330855},{"$f":"$E8*'First Scenario'!$J$21","v":113.17373826749319},47125.893944330855,null,{"$f":"$I8*'Second Scenario'!$B$13","v":23562.292988470675},{"$f":"$G8*'Second Scenario'!$B$13","v":56.585298579359048},{"$f":"$J8*'Second Scenario'!$B$13","v":26775.332941443943},{"$f":"$E8*'Second Scenario'!$B$13","v":64.301475658362548},26775.332941443943,null,{"$f":"$I8*'Second Scenario'!$J$21","v":38674.591696958123},{"$f":"$G8*'Second Scenario'!$J$21","v":92.877773809110749},{"$f":"$J8*'Second Scenario'!$J$21","v":43948.399655634217},{"$f":"$E8*'Second Scenario'!$J$21","v":105.54292478308039},43948.399655634217]
[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":31150.611289550037},{"$f":"$G9*'First Scenario'!$B$13","v":58.848045294403562},{"$f":"$J9*'First Scenario'!$B$13","v":37084.06105898814},{"$f":"$E9*'First Scenario'!$B$13","v":70.057196779051864},37084.06105898814,null,{"$f":"$I9*'First Scenario'!$J$21","v":50322.183744727146},{"$f":"$G9*'First Scenario'!$J$21","v":95.065940144694267},{"$f":"$J9*'First Scenario'!$J$21","v":59907.361600865646},{"$f":"$E9*'First Scenario'!$J$21","v":113.17373826749319},59907.361600865646,null,{"$f":"$I9*'Second Scenario'!$B$13","v":28591.356286996783},{"$f":"$G9*'Second Scenario'!$B$13","v":54.013239553024533},{"$f":"$J9*'Second Scenario'!$B$13","v":34037.328913091405},{"$f":"$E9*'Second Scenario'!$B$13","v":64.301475658362548},34037.328913091405,null,{"$f":"$I9*'Second Scenario'!$J$21","v":46929.177521174148},{"$f":"$G9*'Second Scenario'!$J$21","v":88.656056817787515},{"$f":"$J9*'Second Scenario'!$J$21","v":55868.068477588269},{"$f":"$E9*'Second Scenario'!$J$21","v":105.54292478308039},55868.068477588269]
[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":37433.458742576426},{"$f":"$G10*'First Scenario'!$B$13","v":57.446901358822529},{"$f":"$J10*'First Scenario'!$B$13","v":45650.559442166363},{"$f":"$E10*'First Scenario'!$B$13","v":70.057196779051864},45650.559442166363,null,{"$f":"$I10*'First Scenario'!$J$21","v":60471.795289504371},{"$f":"$G10*'First Scenario'!$J$21","v":92.802465379344412},{"$f":"$J10*'First Scenario'!$J$21","v":73746.091816468732},{"$f":"$E10*'First Scenario'!$J$21","v":113.17373826749319},73746.091816468732,null,{"$f":"$I10*'Second Scenario'!$B$13","v":34358.020971570375},{"$f":"$G10*'Second Scenario'!$B$13","v":52.72721003985729},{"$f":"$J10*'Second Scenario'!$B$13","v":41900.02557508582},{"$f":"$E10*'Second Scenario'!$B$13","v":64.301475658362548},41900.02557508582,null,{"$f":"$I10*'Second Scenario'!$J$21","v":56394.444854802488},{"$f":"$G10*'Second Scenario'!$J$21","v":86.545198322125927},{"$f":"$J10*'Second Scenario'!$J$21","v":68773.713237564007},{"$f":"$E10*'Second Scenario'!$J$21","v":105.54292478308039},68773.713237564007]
[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.5566462558488765},null,null,null,null,null,{"$f":"U10/$C$4","v":0.89923292057637771},null,null,null,null,null,{"$f":"AA10/$C$4","v":0.51091361510896016},null,null,null,null,null,{"$f":"AG10/$C$4","v":0.83860155148840398}]
[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":0.99806303182387646},null,null,null,null,null,{"$f":"U10/$I$4","v":1.612318641499958},null,null,null,null,null,{"$f":"AA10/$I$4","v":0.91606471136344936},null,null,null,null,null,{"$f":"AG10/$I$4","v":1.5036070002740725}]
[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,"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":"SQRT('First Scenario'!B8)","v":2.0476123391418546},"If Water Revenues rise by a factor > this, Q_2060 < Q_2010."]
[0,{"$f":"1+(1-A2)*'First Scenario'!B10","v":4.2008532103870886},{"$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.4673843485452975}]