Loading...
HomeMy WebLinkAboutMinutes - Water Finance Subcommittee - 12/3/2012 ACTION SUMMARY MINUTES ORO VALLEY WATER UTILITY COMMISSION FINANCE SUBCOMMITTEE MEETING DECEMBER 3, 2012 HOPI CONFERENCE ROOM 11000 N. LA CANADA DRIVE ORO VALLEY, AZ 85737 CALL TO ORDER at 10:06 a.m. PRESENT: Winston Tustison, Chair, Finance Subcommittee Betty Shapiro, Finance Subcommittee Member Stacey Lemos, Finance Director Shirley Seng, Water Utility Administrator Philip Saletta, Water Utility Director David Ruiz, Engineering Division Manager Call to the audience No public attendance at the meeting. Discussion of the following items occurred and no action was taken: 1. Discussion and/or possible action on the Central Arizona Project Non-Indian Agricultural Water (CAP NIA water) a. Discussed the background of the CAP NIA water i. 51,962 AF/YR available to reallocate to CAP M&I water users ii. Possible request for 1,000 AF for reallocation to Oro Valley iii. NIA pricing components (repay debt, back capital charges and possibly supply availability) ranging from $1,288 to $2,288 per acre foot. iv. Source of funds: acquisition costs from the Alternative Water Resources Development Impact Fee Fund; O&M costs from the Operating Fund v. Subject to shortages— projected 67% availability vi. May have negative impact on the Groundwater Allowance Account vii. If the Town chooses to not request a reallocation, other options include purchase of extinguishment credits viii. Must take delivery of NIA water by 2020 ix. Brief discussion on payment date of acquisition costs; the volume that the Town will be requesting; and the selection criteria used in the reallocation process. b. Discussed 3 scenarios handed out related to taking delivery of a reallocation of CAP NIA water (scenarios are attached to minutes) i. Scenario 1: Shortage of CAP NIA water occurs in later years ii. Scenario 2: Shortage of CAP NIA water occurs in earlier years iii. Scenario 3: Comparison of 650 AF of CAP M&I water annually 1) This is the Town's current allocation of CAP Municipal & Industrial water 2) Discussed the inflation percentage used with suggestions to increase it from 1.5% to 3.0% 3) Discussed the need to determine the financial implications to water rates and impact fees c. Discussed 2 additional scenarios reviewed in electronic format (scenarios not handed out) i. Scenario 4: Comparison of 1,000 AF of CAP M&I water annually ii. Scenario 5: Comparison of 10,305 AF of CAP M&I water annually d. Reviewed the summary table comparing scenarios (attached to minutes) e. Further discussions regarding CAP NIA water acquisition will be at the next Water Utility Commission meeting and then to Council. 2. Discussion on the Update on Cost of Service Study a. Discussion on the addition of an impact fee analysis included in the Request for Proposals (RFP) for the cost of service study. The RFP originally excluded an impact fee analysis. b. The impact fee analysis was added to gain time efficiencies and a potential for reduced financial costs. c. The work may be performed concurrently; however, the cost of service study must be completed by June 30, 2013 and the impact fee analysis must be completed on or before December 31, 2013. Adjourned at 11:28 a.m. I hereby certify that I prepared the foregoing minutes and that they are a true and correct copy of the minutes of the Finance Subcommittee meeting held on the 3rd day of December 2012. further certify that the meeting was duly called and held and that a quorum was present. Prepared by: _ •, Shirley eng, Water i i , A = - nistrato NIA WATER AVAILABILITY AND COST SCENARIO 1 -LATER YEARS SHORTAGE INITIAL CAPITAL COST TOTAL COST COST PER AF NPV NPV/AF $1,300,000 FOR 1000 AF $21,845,230 $336.08 $6,035,409 $92.85 OVWU ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL CAPITAL O&M RECHARGE TOTAL O&M RECHARGE YEAR AF $ $ $ $ $/AF $/AF 2015 500 $17,000 $74,500 $7,500 $99,000 $149.00 $15.00 2016 500 $18,000 $77,500 $7,500 $103,000 $155.00 $15.00 2017 500 $18,000 $79,500 $7,500 $105,000 $159.00 $15.00 2018 500 $18,000 $80,000 $7,500 $105,500 $160.00 $15.00 2019 500 $18,000 $81,200 $7,575 $106,775 $162.40 $15.15 2020 1000 $18,000 $164,836 $15,302 $198,138 $164.84 $15.30 2021 1000 $18,000 $167,309 $15,455 $200,763 $167.31 $15.45 2022 1000 $18,000 $169,818 $15,609 $203,427 $169.82 $15.61 2023 1000 $18,000 $172,365 $15,765 $206,131 $172.37 $15.77 2024 1000 $18,000 $174,951 $15,923 $208,874 $174.95 $15.92 2025 1000 $18,000 $177,575 $16,082 $211,657 $177.58 $16.08 2026 1000 $180,239 $16,243 $196,482 $180.24 $16.24 2027 1000 $182,942 $16,405 $199,348 $182.94 $16.41 2028 1000 $185,687 $16,569 $202,256 $185.69 $16.57 2029 1000 $188,472 $16,735 $205,207 $188.47 $16.74 2030 1000 $191,299 $16,902 $208,201 $191.30 $16.90 2031 500 • $97,084 $8,536 $105,620 $194.17 • $17.07 2032 0 $0 $0 $0 $197.08 $17.24 2033 0 $0 $0 $0 $200.04 $17.41 2034 0 $0 $0 $0 $203.04 $17.59 2035 200 $41,217 $3,553 $44,770 $206.08 $17.76 2036 500 $104,587 $8,971 $113,558 $209.17 $17.94 2037 1000 $212,312 $18,122 $230,434 $212.31 $18.12 2038 1000 $215,497 $18,303 $233,800 $215.50 $18.30 2039 1000 $218,729 $18,486 $237,215 $218.73 $18.49 2040 1000 $222,010 $18,671 $240,681 $222.01 $18.67 2041 1000 $225,340 $18,857 $244,198 $225.34 $18.86 2042 1000 $228,720 $19,046 $247,766 $228.72 $19.05 2043 1000 $232,151 $19,236 $251,388 $232.15 $19.24 2044 1000 $235,634 $19,429 $255,062 $235.63 $19.43 2045 1000 $239,168 $19,623 $258,791 $239.17 $19.62 2046 1000 $242,756 $19,819 $262,575 $242.76 $19.82 2047 1000 $246,397 $20,018 $266,414 $246.40 $20.02 2048 1000 $250,093 $20,218 $270,311 $250.09 $20.22 NIA WATER AVAILABILITY AND COST SCENARIO 1 -LATER YEARS SHORTAGE INITIAL CAPITAL COST TOTAL COST COST PER AF NPV NPV/AF $1,300,000 FOR 1000 AF $21,845,230 $336.08 $6,035,409 $92.85 OVWU ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL CAPITAL O&M RECHARGE TOTAL O&M RECHARGE YEAR AF $ $ $ $ $/AF $/AF 2049 1000 $253,844 $20,420 $274,264 $253.84 $20.42 2050 1000 $257,652 $20,624 $278,276 $257.65 $20.62 2051 1000 $261,517 $20,830 $282,347 $261.52 $20.83 2052 1000 $265,439 $21,039 $286,478 $265.44 $21.04 2053 1000 $269,421 $21,249 $290,670 $269.42 $21.25 2054 1000 $273,462 $21,462 $294,924 $273.46 $21.46 2055 1000 $277,564 $21,676 $299,240 $277.56 $21.68 2056 1000 $281,728 $21,893 $303;621 $281.73 $21.89 2057 1000 $285,954 $22,112 $308,065 $285.95 $22.11 2058 1000 $290,243 $22,333 $312,576 $290.24 $22.33 2059 1000 $294,597 $22,556 $317,153 $294.60 $22.56 2060 1000 $299,016 $22,782 $321,797 $299.02 $22.78 2061 1000 $303,501 $23,010 $326,510 $303.50 $23.01 2062 1000 $308,053 $23,240 $331,293 $308.05 $23.24 2063 1000 $312,674 $23,472 $336,146 $312.67 $23.47 2064 1000 $317,364 . $23,707 $341,071 $317.36 $23.71 2065 1000 ' $322,125 $23,944 $346,069 $322.12 ' $23.94 2066 1000 $326,957 $24,183 $351,140 $326.96 $24.18 2067 1000 $331,861 $24,425 $356,286 $331.86 $24.43 2068 1000 $336,839 $24,669 $361,508 $336.84 $24.67 2069 1000 $341,891 $24,916 $366,808 $341.89 $24.92 2070 1000 $347,020 $25,165 $372,185 $347.02 $25.17 2071 1000 $352,225 $25,417 $377,642 $352.23 $25.42 2072 1000 $357,508 $25,671 $383,180 $357.51 $25.67 2073 1000 $362,871 $25,928 $388,799 $362.87 $25.93 2074 1000 $368,314 $26,187 $394,501 $368.31 $26.19 2075 1000 $373,839 $26,449 $400,288 $373.84 $26.45 2076 1000 $379,446 $26,714 $406,160 $379.45 $26.71 2077 1000 $385,138 $26,981 $412,119 $385.14 $26.98 2078 1000 $390,915 $27,250 $418,166 $390.92 $27.25 2079 1000 $396,779 $27,523 $424,302 $396.78 $27.52 2080 1000 $402,731 $27,798 $430,529 $402.73 $27.80 2081 600 $245,263 $16,846 $262,109 $408.77 $28.08 2082 300 $124,471 $8,507 $132,978 $414.90 $28.36 NIA WATER AVAILABILITY AND COST SCENARIO 1 -LATER YEARS SHORTAGE INITIAL CAPITAL COST TOTAL COST COST PER AF NPV NPV/AF $1,300,000 FOR 1000 AF $21,845,230 $336.08 $6,035,409 $92.85 OVW U ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL CAPITAL O&M RECHARGE TOTAL O&M RECHARGE YEAR AF $ $ $ $ $/AF $/AF 2083 300 $126,338 $8,592 $134,930 $421.13 $28.64 2084 300 $128,233 $8,678 $136,911 $427.44 $28.93 2085 300 $130,157 $8,765 $138,921 $433.86 $29.22 2086 300 $132,109 $8,852 $140,961 $440.36 $29.51 2087 300 $134,091 $8,941 $143,032 $446.97 $29.80 2088 300 $136,102 $9,030 $145,132 $453.67 $30.10 2089 300 $138,143 $9,121 $147,264 $460.48 $30.40 2090 300 $140,216 $9,212 $149,428 $467.39 $30.71 2091 0 $0 $0 $0 $474.40 $31.01 2092 0 $0 $0 $0 $481.51 $31.32 2093 300 $146,620 $9,491 $156,111 $488.73 $31.64 2094 300 $148,820 $9,586 $158,406 $496.07 $31.95 2095 300 $151,052 $9,682 $160,734 $503.51 $32.27 2096 0 $0 $0 $0 $511.06 $32.60 2097 0 $0 $0 $0 $518.73 $32.92 2098 0 $0 $0 $0 $526.51 $33.25 2099 ' 0 $0 • $0 $0 • $534.40 $33.58 • 2100 0 $0 $0 $0 $542.42 $33.92 2101 0 $0 $0 $0 $550.56 $34.26 2102 0 $0 $0 $0 $558.81 $34.60 2103 0 $0 $0 $0 $567.20 $34.95 2104 0 $0 $0 $0 $575.70 $35.30 2105 0 $0 $0 $0 $584.34 $35.65 2106 0 $0 $0 $0 $593.11 $36.01 2107 0 $0 $0 $0 $602.00 $36.37 2108 300 $183,310 $11,019 $194,328 $611.03 $36.73 2109 300 $186,059 $11,129 $197,188 $620.20 $37.10 2110 300 $188,850 $11,240 $200,090 $629.50 $37.47 2111 300 $191,683 $11,353 $203,036 $638.94 $37.84 2112 300 $194,558 $11,466 $206,024 $648.53 $38.22 2113 300 $197,476 $11,581 $209,057 $658.25 $38.60 2114 300 $200,439 $11,697 $212,135 $668.13 $38.99 65000 $20,545,230 NIA WATER AVAILABILITY AND COST SCENARIO 2 -EARLIER YEARS SHORTAGE INITIAL CAPITAL COST TOTAL COST COST PER AF NPV NPV/AF $1,300,000 FOR 1000 AF $29,057,502 $447.04 $4,871,969 $74.95 OVWU ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL CAPITAL O&M RECHARGE TOTAL O&M RECHARGE YEAR AF $ $ $ $ $/AF $/AF 2015 500 $17,000 $74,500 $7,500 $99,000 $149.00 $15.00 2016 500 $18,000 $77,500 $7,500 $103,000 $155.00 $15.00 2017 500 $18,000 $79,500 $7,500 $105,000 $159.00 $15.00 2018 500 $18,000 $80,000 $7,500 $105,500 $160.00 $15.00 2019 500 $18,000 $81,200 $7,575 $106,775 $162.40 $15.15 2020 1000 $18,000 $164,836 $15,302 $198,138 $164.84 $15.30 2021 1000 $18,000 $167,309 $15,455 $200,763 $167.31 $15.45 2022 1000 $18,000 $169,818 $15,609 $203,427 $169.82 $15.61 2023 1000 $18,000 $172,365 $15,765 $206,131 $172.37 $15.77 2024 1000 $18,000 $174,951 $15,923 $208,874 $174.95 $15.92 2025 1000 $18,000 $177,575 $16,082 $211,657 $177.58 $16.08 2026 500 $90,119 $8,121 $98,241 $180.24 $16.24 2027 500 $91,471 $8,203 $99,674 $182.94 $16.41 2028 500 $92,843 $8,285 $101,128 $185.69 $16.57 2029 1000 $188,472 $16,735 $205,207 $188.47 $16.74 2030 1000 $191,299 $16,902 $208,201 $191.30 $16.90 2031 500 $97,084 $8,536 $105,620 $194.17 $17.07 2032 400 $78,832 $6,897 $85,729 $197.08 $17.24 2033 400 $80,015 $6,966 $86,981 $200.04 $17.41 2034 1000 $203,038 $17,589 $220,626 $203.04 $17.59 2035 1000 $206,083 $17,765 $223,848 $206.08 $17.76 2036 200 $41,835 $3,588 $45,423 $209.17 $17.94 2037 300 $63,694 $5,436 $69,130 $212.31 $18.12 2038 400 $86,199 $7,321 $93,520 $215.50 $18.30 2039 400 $87,492 $7,394 $94,886 $218.73 $18.49 2040 200 $44,402 $3,734 $48,136 $222.01 $18.67 2041 200 $45,068 $3,771 $48,840 $225.34 $18.86 2042 0 $0 $0 $0 $228.72 $19.05 2043 0 $0 $0 $0 $232.15 $19.24 2044 0 $0 $0 $0 $235.63 $19.43 2045 0 $0 $0 $0 $239.17 $19.62 2046 0 $0 $0 $0 $242.76 $19.82 2047 0 $0 $0 $0 $246.40 $20.02 2048 0 $0 $0 $0 $250.09 $20.22 NIA WATER AVAILABILITY AND COST SCENARIO 2 -EARLIER YEARS SHORTAGE INITIAL CAPITAL COST TOTAL COST COST PER AF NPV NPV/AF $1,300,000 FOR 1000 AF $29,057,502 $447.04 $4,871,969 $74.95 OVWU ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL CAPITAL O&M RECHARGE TOTAL O&M RECHARGE YEAR AF $ $ $ $ $/AF $/AF 2049 0 $0 $0 $0 $253.84 $20.42 2050 0 $0 $0 $0 $257.65 $20.62 2051 0 $0 $0 $0 $261.52 $20.83 2052 0 $0 $0 $0 $265.44 $21.04 2053 0 $0 $0 $0 $269.42 $21.25 2054 0 $0 $0 $0 $273.46 $21.46 2055 0 $0 $0 $0 $277.56 $21.68 2056 0 $0 $0 $0 $281.73 $21.89 2057 0 $0 $0 $0 $285.95 $22.11 2058 0 $0 $0 $0 $290.24 $22.33 2059 0 $0 $0 $0 $294.60 $22.56 2060 0 $0 $0 $0 $299.02 $22.78 2061 0 $0 $0 $0 $303.50 $23.01 2062 0 $0 $0 $0 $308.05 $23.24 2063 500 $156,337 $11,736 $168,073 $312.67 $23.47 2064 1000 $317,364 $23,707 $341,071 $317.36 $23.71 2065 1000 $322,125 $23,944 $346,069 $322.12 $23.94 2066 1000 $326,957 $24,183 $351,140 $326.96 $24.18 2067 1000 $331,861 $24,425 $356,286 $331.86 $24.43 2068 1000 $336,839 $24,669 $361,508 $336.84 $24.67 2069 1000 $341,891 $24,916 $366,808 $341.89 $24.92 2070 1000 $347,020 $25,165 $372,185 $347.02 $25.17 2071 1000 $352,225 $25,417 $377,642 $352.23 $25.42 2072 1000 $357,508 $25,671 $383,180 $357.51 $25.67 2073 1000 $362,871 $25,928 $388,799 $362.87 $25.93 2074 1000 $368,314 $26,187 $394,501 $368.31 $26.19 2075 1000 $373,839 $26,449 $400,288 $373.84 $26.45 2076 1000 $379,446 $26,714 $406,160 $379.45 $26.71 2077 1000 $385,138 $26,981 $412,119 $385.14 $26.98 2078 1000 $390,915 $27,250 $418,166 $390.92 $27.25 2079 1000 $396,779 $27,523 $424,302 $396.78 $27.52 2080 1000 $402,731 $27,798 $430,529 $402.73 $27.80 2081 1000 $408,772 $28,076 $436,848 $408.77 $28.08 2082 1000 $414,903 $28,357 $443,260 $414.90 $28.36 NIA WATER AVAILABILITY AND COST SCENARIO 2 -EARLIER YEARS SHORTAGE INITIAL CAPITAL COST TOTAL COST COST PER AF NPV NPV/AF $1,300,000 FOR 1000 AF $29,057,502 $447.04 $4,871,969 $74.95 OVWU ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL CAPITAL O&M RECHARGE TOTAL O&M RECHARGE YEAR AF $ $ $ $ $/AF $/AF 2083 200 $84,225 $5,728 $89,953 $421.13 $28.64 2084 0 $0 $0 $0 $427.44 $28.93 2085 300 $130,157 $8,765 $138,921 $433.86 $29.22 2086 500 $220,182 $14,754 $234,936 $440.36 $29.51 2087 500 $223,484 $14,902 $238,386 $446.97 $29.80 2088 1000 $453,673 $30,101 $483,774 $453.67 $30.10 2089 1000 $460,478 $30,402 $490,881 $460.48 $30.40 2090 1000 $467,385 $30,706 $498,092 $467.39 $30.71 2091 1000 $474,396 $31,014 $505,410 $474.40 $31.01 2092 1000 $481,512 $31,324 $512,836 $481.51 $31.32 2093 1000 $488,735 $31,637 $520,372 $488.73 $31.64 2094 1000 $496,066 $31,953 $528,019 $496.07 $31.95 2095 1000 $503,507 $32,273 $535,780 $503.51 $32.27 2096 1000 $511,059 $32,596 $543,655 $511.06 $32.60 2097 1000 $518,725 $32,922 $551,647 $518.73 $32.92 2098 1000 $526,506 $33,251 $559,757 $526.51 $33.25 2099 1000 $534,404 $33,583 $567,987 $534.40 $33.58 2100 1000 $542,420 $33,919 $576,339 $542.42 $33.92 2101 1000 $550,556 $34,258 $584,814 $550.56 $34.26 2102 1000 $558,814 $34,601 $593,415 $558.81 $34.60 2103 1000 $567,197 $34,947 $602,143 $567.20 $34.95 2104 1000 $575,704 $35,296 $611,001 $575.70 $35.30 2105 1000 $584,340 $35,649 $619,989 $584.34 $35.65 2106 1000 $593,105 $36,006 $629,111 $593.11 $36.01 2107 1000 $602,002 $36,366 $638,368 $602.00 $36.37 2108 1000 $611,032 $36,729 $647,761 $611.03 $36.73 2109 1000 $620,197 $37,097 $657,294 $620.20 $37.10 2110 1000 $629,500 $37,468 $666,968 $629.50 $37.47 2111 1000 $638,943 $37,842 $676,785 $638.94 $37.84 2112 1000 $648,527 $38,221 $686,748 $648.53 $38.22 2113 1000 $658,255 $38,603 $696,858 $658.25 $38.60 2114 1000 $668,129 $38,989 $707,118 $668.13 $38.99 65,000 $27,757,502 CAP WATER COST M&I SUBCONTRACT SCENARIO 3 -650 AF/YR INITIAL CAPITAL COST TOTAL COST COST PER AF NPV NPV/AF NONE $24,496,071.98 $376.86 $4,028,224.00 $61.97 OVWU ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL CAPITAL O&M RECHARGE TOTAL O&M RECHARGE YEAR AF $ $ $ $ $/AF $/AF 2015 650 $11,050 $96,850 $9,750 $117,650 $149.00 $15.00 2016 650 $11,700 $100,750 $9,750 $122,200 $155.00 $15.00 2017 650 $11,700 $103,350 $9,750 $124,800 $159.00 $15.00 2018 650 $11,700 $104,000 $9,750 $125,450 $160.00 $15.00 2019 650 $11,700 $105,560 $9,848 $127,108 $162.40 $15.15 2020 650 $11,700 $107,143 $9,946 $128,789 $164.84 $15.30 2021 650 $11,700 $108,751 $10,045 $130,496 $167.31 $15.45 2022 650 $11,700 $110,382 $10,146 $132,228 $169.82 $15.61 2023 650 $11,700 $112,038 $10,247 $133,985 $172.37 $15.77 2024 650 $11,700 $113,718 $10,350 $135,768 $174.95 $15.92 2025 650 $11,700 $115,424 $10,453 $137,577 $177.58 $16.08 2026 650 $117,155 $10,558 $127,713 $180.24 $16.24 2027 650 $118,913 $10,663 $129,576 $182.94 $16.41 2028 650 $120,696 $10,770 $131,466 $185.69 $16.57 2029 650 $122,507 $10,878 $133,384 $188.47 $16.74 2030 650 $124,344 $10,987 $135,331 $191.30 $16.90 2031 650 $126,209 $11,096 $137,306 $194.17 $17.07 2032 650 $128,103 $11,207 $139,310 $197.08 $17.24 2033 650 $130,024 $11,319 $141,344 $200.04 $17.41 2034 650 $131,974 $11,433 $143,407 $203.04 $17.59 2035 650 $133,954 $11,547 $145,501 $206.08 $17.76 2036 650 $135,963 $11,662 $147,626 $209.17 $17.94 2037 650 $138,003 $11,779 $149,782 $212.31 $18.12 2038 650 $140,073 $11,897 $151,970 $215.50 $18.30 2039 650 $142,174 $12,016 $154,190 $218.73 $18.49 2040 650 $144,307 $12,136 $156,443 $222.01 $18.67 2041 650 $146,471 $12,257 $158,729 $225.34 $18.86 2042 650 $148,668 $12,380 $161,048 $228.72 $19.05 2043 650 $150,898 $12,504 $163,402 $232.15 $19.24 2044 650 $153,162 $12,629 $165,791 $235.63 $19.43 2045 650 $155,459 $12,755 $168,214 $239.17 $19.62 2046 650 $157,791 $12,883 $170,674 $242.76 $19.82 2047 650 $160,158 $13,011 $173,169 $246.40 $20.02 2048 650 $162,560 $13,142 $175,702 $250.09 $20.22 CAP WATER COST M&I SUBCONTRACT SCENARIO 3-650 AF/YR INITIAL CAPITAL COST TOTAL COST COST PER AF NPV NPV/AF NONE $24,496,071.98 $376.86 $4,028,224.00 $61.97 OVWU ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL CAPITAL O&M RECHARGE TOTAL O&M RECHARGE YEAR AF $ $ $ $ $/AF $/AF 2049 650 $164,999 $13,273 $178,272 $253.84 $20.42 2050 650 $167,474 $13,406 $180,879 $257.65 $20.62 2051 650 $169,986 $13,540 $183,526 $261.52 $20.83 2052 650 $172,536 $13,675 $186,211 $265.44 $21.04 2053 650 $175,124 $13,812 $188,936 $269.42 $21.25 2054 650 $177,751 $13,950 $191,701 $273.46 $21.46 2055 650 $180,417 $14,089 $194,506 $277.56 . $21.68 2056 650 $183,123 $14,230 $197,353 $281.73 $21.89 2057 650 $185,870 $14,373 $200,243 $285.95 $22.11 2058 650 $188,658 $14,516 $203,174 $290.24 $22.33 2059 650 $191,488 $14,662 $206,149 $294.60 $22.56 2060 650 $194,360 $14,808 $209,168 $299.02 $22.78 2061 650 $197,276 $14,956 $212,232 $303.50 $23.01 2062 650 $200,235 $15,106 $215,340 $308.05 $23.24 2063 650 $203,238 $15,257 $218,495 $312.67 $23.47 2064 650 $206,287 $15,409 $221,696 $317.36 $23.71 2065 650 $209,381 $15,564 $224,945 $322.12 $23.94 2066 650 $212,522 $15,719 $228,241 $326.96 $24.18 2067 650 $215,710 $15,876 $231,586 $331.86 $24.43 2068 650 $218,945 $16,035 $234,980 $336.84 $24.67 2069 650 $222,229 $16,196 $238,425 $341.89 $24.92 2070 650 $225,563 $16,357 $241,920 $347.02 $25.17 2071 650 $228,946 $16,521 $245,467 $352.23 $25.42 2072 650 $232,380 $16,686 $249,067 $357.51 $25.67 2073 650 $235,866 $16,853 $252,719 $362.87 $25.93 2074 650 $239,404 $17,022 $256,426 $368.31 $26.19 2075 650 $242,995 $17,192 $260,187 $373.84 $26.45 2076 650 $246,640 $17,364 $264,004 $379.45 $26.71 2077 650 $250,340 $17,537 $267,877 $385.14 $26.98 2078 650 $254,095 $17,713 $271,808 $390.92 $27.25 2079 650 $257,906 $17,890 $275,796 $396.78 $27.52 2080 650 $261,775 $18,069 $279,844 $402.73 $27.80 2081 650 $265,701 $18,250 $283,951 $408.77 $28.08 2082 650 $269,687 $18,432 $288,119 $414.90 $28.36 CAP WATER COST M&I SUBCONTRACT SCENARIO 3-650 AF/YR INITIAL CAPITAL COST TOTAL COST COST PER AF NPV NPV/AF NONE $24,496,071.98 $376.86 $4,028,224.00 $61.97 OVWU ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL ANNUAL CAPITAL O&M RECHARGE TOTAL O&M RECHARGE YEAR AF $ $ $ $ $/AF $/AF 2083 650 $273,732 $18,616 $292,349 $421.13 $28.64 2084 650 $277,838 $18,802 $296,641 $427.44 $28.93 2085 650 $282,006 $18,991 $300,996 $433.86 $29.22 2086 650 $286,236 $19,180 $305,416 $440.36 $29.51 2087 650 $290,530 $19,372 $309,902 $446.97 $29.80 2088 650 $294,887 $19,566 $314,453 $453.67 $30.10 2089 650 $299,311 $19,762 $319,072 $460.48 $30.40 2090 650 $303,800 $19,959 $323,760 $467.39 $30.71 2091 650 $308,357 $20,159 $328,516 $474.40 $31.01 2092 650 $312,983 $20,360 $333,343 $481.51 $31.32 2093 650 $317,678 $20,564 $338,242 $488.73 $31.64 2094 650 $322,443 $20,770 $343,212 $496.07 $31.95 2095 650 $327,279 $20,977 $348,257 $503.51 $32.27 2096 650 $332,189 $21,187 $353,376 $511.06 $32.60 2097 650 $337,171 $21,399 $358,570 $518.73 $32.92 2098 650 $342,229 $21,613 $363,842 $526.51 $33.25 2099 650 $347,362 $21,829 $369,191 $534.40 $33.58 2100 650 $352,573 $22,047 $374,620 $542.42 $33.92 2101 650 $357,861 $22,268 $380,129 $550.56 $34.26 2102 650 $363,229 $22,491 $385,720 $558.81 $34.60 2103 650 $368,678 $22,715 $391,393 $567.20 $34.95 2104 650 $374,208 $22,943 $397,151 $575.70 $35.30 2105 650 $379,821 $23,172 $402,993 $584.34 $35.65 2106 650 $385,518 $23,404 $408,922 $593.11 $36.01 2107 650 $391,301 $23,638 $414,939 $602.00 $36.37 2108 650 $397,171 $23,874 $421,045 $611.03 $36.73 2109 650 $403,128 $24,113 $427,241 $620.20 $37.10 2110 650 $409,175 $24,354 $433,529 $629.50 $37.47 2111 650 $415,313 $24,598 $439,910 $638.94 $37.84 2112 650 $421,542 $24,844 $446,386 $648.53 $38.22 2113 650 $427,866 $25,092 $452,958 $658.25 $38.60 2114 650 $434,284 $25,343 $459,626 $668.13 $38.99 65000 $24,496,072 $376,863 CAP NIA WATER COMPARISON TO CAP M&I SUBCONTRACT WATER TOTAL COST/AF NPV NPV/AF MILLION $ $ MILLION $ $ Scenario 1 (NIA water) Later Shortage at 1000 AF/YR 21.8 336 6 93 Scenario 2 (NIA water) Early Shortage at 1000 AF/YR 29 447 4.9 75 Scenario 3 (M&l water) Current at 650 AF/YR 24.5 377 4 62 Scenario 4 (M&l water) Current at 1000 AF/Yr 37.7 377 6.2 62 Scenario 5 (M&l water) Current at 10,305 AF/YR 388.4 377 63.8 62 Prepard 12/3/12 by P.Saletta