Loading...
HomeMy WebLinkAbout2022/07/06 - Belfair Sewer ExcelCreated and updated 06/24/2022 @ 1425hrs Assumptions 5 million dollar project with a 1.5 million dollar contribution from ARPA 5% loan forgiveness applied to new debt O&M for 2022 is actual. Escalates 3% annually for assumed inflation Rates. Beginning in 2023 rates escalate 1% more than inflation 5% delinquency rate CFC's adjusted to reflect new rate in 2025 Paying off existing debt in 2027 with reserved REET CFC's used for future Capital costs Rates Expenses Alt Rev Sources Alt Rev Sources Alt Rev Sources Alt Rev Sources Alt Rev Sources Alt Rev Sources CFC's Earned YEAR ERU's Estimated max tolerable rate Est Rev MTR Rate/ERU (no increase) Revenue (no increase) Rate/ERU REVENUE w/1% over CPI Inc O&M DEBT Service B O&M+Debt Service+Capital Exp DEBT Service A O&M+Debt Service+Capital Exp Multi Family Rate/ERU Comm Rate/ERU Capital expenditures PWB Funding Option B (20 years @ 0.54%) YEAR CFC's (Used) REET .09 Tax ARPA Total Fund by year Deficit / Surplus CFC's (Used) REET .09 Tax ARPA Total Fund by year Deficit / Surplus CFC's (Used) REET .09 Tax ARPA Total Fund by year Deficit / Surplus PWB Funding Option A (22 years @ 0.79%) CFC's (Used) REET .09 Tax ARPA Total Fund by year Deficit / Surplus CFC's (Used) REET .09 Tax ARPA Total Fund by year Deficit / Surplus CFC's (Used) REET .09 Tax ARPA Total Fund by year Deficit / Surplus Residential & Multi Family Rate 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 Current Rate w/increase equal to 1%>CPI 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 72036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 Current Rate no annual increase 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 72036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 YEAR Res MF Comm 641300 2021 96 105 109.2 113.568 118.1107 122.8351 127.7486 132.8585 138.1728 143.6998 149.4477 155.4256 161.6427 168.1084 174.8327 181.826 189.0991 196.663 204.5296 212.7107 221.2192 230.0679 239.2706 248.8415 258.7951 96 99.84 103.8336 107.9869 112.3064 116.7987 121.4706 126.3295 131.3826 136.6379 142.1035 147.7876 153.6991 159.8471 166.2409 172.8906 179.8062 186.9984 194.4784 202.2575 210.3478 218.7617 227.5122 236.6127 246.0772 255.9203 266.1571 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 2022 318 0/127 104 422/549 510000 2022 421/549 114.73 599664.282 96 509771.52 96 509771.52 725970 778351.46 1834321.46 778351.46 1834321.46 67.2 96 330000 2022 800000 194549.94 330000 1834321.46 0 800000 194549.94 330000 1834321.46 0 800000 104657.18 330000 1834321.462 0.002 800000 194549.94 330000 1834321.46 0 800000 194549.94 330000 1834321.46 0 800000 104657.18 330000 1834321.462 0.002 1152 1260 1310.4 1362.816 1417.3286 1474.0218 1532.9827 1594.302 1658.074 1724.397 1793.3729 1865.1078 1939.7121 2017.3006 2097.9926 2181.9123 2269.1888 2359.9564 2454.3546 2552.5288 2654.63 2760.8152 2871.2478 2986.0977 3105.5416 1152 1198.08 1246.0032 1295.8433 1347.6771 1401.5841 1457.6475 1515.9534 1576.5915 1639.6552 1705.2414 1773.4511 1844.3891 1918.1647 1994.8913 2074.6869 2157.6744 2243.9814 2333.7406 2427.0903 2524.1739 2625.1408 2730.1464 2839.3523 2952.9264 3071.0435 3193.8852 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 2023 318 228 104 650 226000 2023 650 118.1719 783508.0583 96 636503.04 99.84 661963.1616 747749.1 1021473.7 2442014.94 1021473.7 2442014.94 69.888 96 672792.14 2023 555511.9 800000 450000 2442014.94 0 530051.78 800000 450000 2442014.9416 0.0016 408506.885 800000 450000 2442014.9433 0.0033 555511.9 800000 450000 2442014.94 0 530051.78 800000 450000 2442014.9416 0.0016 408506.885 800000 450000 2442014.9433 0.0033 2133900 484992 399420 416707.2 433375.488 450710.5075 468738.9278 487488.4849 506988.0243 527267.5453 548358.2471 570292.577 593104.2801 616828.4513 641501.5893 667161.6529 693848.119 721602.0438 750466.1255 780484.7706 811704.1614 844172.3278 877939.221 913056.7898 949579.0614 987562.2238 509771.52 504391.68 524567.3472 545550.0411 567372.0427 590066.9244 613669.6014 638216.3855 663745.0409 690294.8425 717906.6362 746622.9017 776487.8177 807547.3305 839849.2237 873443.1926 908380.9203 944716.1571 982504.8034 1021804.9956 1062677.1954 1105184.2832 1149391.6545 1195367.3207 1243182.0135 1292909.2941 1344625.6658 509771.52 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 2024 338 228 104 670 339000 2024 670 121.7171 834764.789 96 658391.04 103.8336 712115.7489 770181.573 1101301.39 2451907.393 1090574.94 2441180.943 72.6835 99.84 580424.43 2024 543516.355 800000 450000 2451907.395 0.002 489791.645 800000 450000 2451907.3939 0.0009 367142.605 800000 450000 2451907.394 0.001 532789.905 800000 450000 2441180.945 0.002 479065.195 800000 450000 2441180.9439 0.0009 356416.155 800000 450000 2441180.944 0.001 2133899.995 0.005 550195.2 570490.2 594554.688 618336.8755 643070.3505 668793.1646 695544.8911 723366.6868 752301.3543 782393.4084 813689.1448 846236.7106 880086.179 915289.6261 951901.2112 989977.2596 1029576.35 1070759.404 1113589.7802 1158133.3714 1204458.7062 1252637.0545 1302742.5367 1354852.2381 1409046.3277 670003.2 661963.1616 688441.6881 715979.3556 744618.5298 774403.271 805379.4018 837594.5779 871098.361 905942.2955 942179.9873 979867.1868 1019061.8743 1059824.3492 1102217.3232 1146306.0161 1192158.2568 1239844.587 1289438.3705 1341015.9053 1394656.5416 1450442.8032 1508460.5153 1568798.936 1631550.8934 1696812.9291 1764685.4463 670003.2 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 2025 368 228 104 700 208800 2025 700 125.3686 902683.7832 96 691223.04 107.9869 777531.9137 793287.0202 1097261.26 2057136.2802 1086534.81 2046409.8302 75.5909 103.8336 166588 2025 115913.245 800000 450000 2057136.285 0.0048 29604.37 800000 450000 2057136.2837 0.0035 800000 354452.5 2057136.2832 0.003 105186.795 800000 450000 2046409.835 0.0048 18877.92 800000 450000 2046409.8337 0.0035 800000 340011.01 2042694.7932 -3715.037 636503.04 601776 652055.04 719021.7216 770459.8487 824862.5912 888516.748 957537.7592 1030658.8244 1071885.1774 1114760.5845 1159351.0079 1205725.0482 1253954.0501 1304112.2121 1356276.7006 1410527.7686 1466948.8794 1525626.8345 1586651.9079 1650117.9842 1716122.7036 1784767.6117 1856158.3162 1930404.6489 636503.04 661963.1616 712115.7489 777531.9137 829117.8815 883586.6758 946625.4455 1014733.7338 1086776.0845 1130247.1279 1175457.013 1222475.2936 1271374.3053 1322229.2775 1375118.4486 1430123.1866 1487328.114 1546821.2386 1608694.0881 1673041.8516 1739963.5257 1809562.0667 1881944.5494 1957222.3314 2035511.2246 2116931.6736 2201608.9406 636503.04 636503.04 658391.04 691223.04 708733.44 726243.84 748131.84 771114.24 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 2026 384 228 104 716 208800 2026 716 129.1296 902683.7832 96 708733.44 112.3064 829117.8815 817085.6308 1102413.75 5299910.3808 1091687.3 5289183.9308 78.6145 107.9869 3380411 2026 918958.5 800000 450000 2877691.94 -2422218.4408 1084452.2 800000 450000 3163570.0815 -2136340.2993 1358250.51 800000 450000 3510934.2932 -1788976.0876 940411.395 800000 450000 2899144.835 -2390039.0958 1105905.1 800000 450000 3185022.9815 -2104160.9493 1379583.61 800000 450000 3532267.3932 -1756916.5376 509771.52 655783.29 737822.592 806175.7517 859966.1771 916769.9553 982567.424 1053676.4451 1128902.0801 1174058.1633 1221020.4898 1269861.3094 1320655.7618 1373481.9922 1428421.2719 1485558.1228 1544980.4477 1606779.6656 1671050.8522 1737892.8863 1807408.6018 1879704.9459 1954893.1437 2033088.8694 2114412.4242 2027 400 228 104 732 261000 2027 732 133.0035 1006176.9077 96 726243.84 116.7987 883586.6758 841598.1997 1101156.24 1942754.4397 1090429.79 1932027.9897 81.7591 112.3064 2027 800000 1526243.84 -416510.5997 800000 1683586.6758 -259167.7639 800000 1806176.9077 -136577.5321 800000 1526243.84 -405784.1497 800000 1683586.6758 -248441.3139 800000 1806176.9077 -125851.0821 1006176.9077 1067596.7603 1133404.8239 1202200.5342 1238266.5502 1275414.5467 1313676.9831 1353087.2926 1393679.9114 1435490.3088 1478555.018 1522911.6686 1568599.0186 1615656.9892 1664126.6989 1714050.4998 1765472.0148 1818436.1753 1818436.1753 1818436.1753 Max Tolerable rate 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 72036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2028 420 228 104 752 274050 2028 752 136.9936 1067596.7603 96 748131.84 121.4706 946625.4455 866846.1457 175426.43 1224307.5757 164699.98 1213581.1257 85.0294 116.7987 182035 2028 182035 294140.74 1224307.58 0.0043 182034.99 95647.145 1224307.5805 0.0048 156710.82 1224307.5803 0.0045 182035 283414.29 1213581.13 0.0043 182035 84920.685 1213581.1305 0.0048 145984.37 1213581.1303 0.0045 Commercial 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 114.73 118.1719 121.7171 125.3686 129.1296 133.0035 136.9936 141.1034 145.3365 149.6966 154.1875 158.8132 163.5775 168.4849 173.5394 178.7456 184.108 189.6312 195.3201 201.1797 207.2151 213.4316 219.8345 226.4296 233.2225 240.2191 247.4257 2029 441 228 104 773 274050 2029 773 141.1034 1133404.8239 96 771114.24 126.3295 1014733.7338 892851.5301 175426.43 1255774.0101 164699.98 1245047.5601 88.4306 121.4706 187496.05 2029 187496.05 297163.725 1255774.015 0.0049 187496.05 53544.23 1255774.0138 0.0038 122369.19 1255774.0139 0.0038 187496.05 286437.275 1245047.565 0.0049 187496.05 42817.78 1245047.5638 0.0038 111642.74 1245047.5639 0.0038 96 99.84 103.8336 107.9869 112.3064 116.7987 121.4706 126.3295 131.3826 136.6379 142.1035 147.7876 153.6991 159.8471 166.2409 172.8906 179.8062 186.9984 194.4784 202.2575 210.3478 218.7617 227.5122 236.6127 1376.76 1418.0628 1460.6047 1504.4228 1549.5555 1596.0422 1643.9234 1693.2411 1744.0384 1796.3595 1850.2503 1905.7578 1962.9306 2021.8185 2082.473 2144.9472 2209.2956 2275.5745 2343.8417 2414.157 2486.5817 2561.1792 2638.0145 2717.155 2798.6696 2882.6297 2969.1086 2030 462 228 104 794 2030 794 145.3365 1202200.5342 96 794096.64 131.3826 1086776.0845 919637.076 175426.43 1288184.436 164699.98 1277457.986 91.9678 126.3295 193120.93 2030 193120.93 300966.87 1288184.44 0.004 193120.93 8287.425 1288184.4395 0.0035 85983.905 1288184.4392 0.0032 193120.93 290240.42 1277457.99 0.004 190681.905 1277457.9895 0.0035 75257.455 1277457.9892 0.0032 1152 1198.08 1246.0032 1295.8433 1347.6771 1401.5841 1457.6475 1515.9534 1576.5915 1639.6552 1705.2414 1773.4511 1844.3891 1918.1647 1994.8913 2074.6869 2157.6744 2243.9814 2333.7406 2427.0903 2524.1739 2625.1408 2730.1464 2839.3523 599664.282 597004.4388 614914.572 633362.0091 652362.8694 671933.7555 692091.7681 712854.5212 734240.1568 756267.3615 778955.3824 802324.0438 826393.7652 851185.5781 876721.1455 903022.7798 930113.4632 958016.8671 986757.3731 1016360.0943 1046850.8971 1078256.4241 1110604.1168 1143922.2403 1178239.9075 1213587.1047 1249994.7179 2031 462 228 104 794 2031 794 149.6966 1238266.5502 96 794096.64 136.6379 1130247.1279 947226.1883 175426.43 1321567.1783 164699.98 1310840.7283 95.6466 131.3826 198914.56 2031 198914.56 328555.98 1321567.18 0.0017 191320.055 1321567.1829 0.0047 83300.63 1321567.1802 0.002 198914.56 317829.53 1310840.73 0.0017 180593.605 1310840.7329 0.0047 72574.18 1310840.7302 0.002 119808 124600.32 129584.3328 134767.7061 140158.4144 145764.7509 151595.341 157659.1546 163965.5208 170524.1416 177345.1073 184438.9116 191816.468 199489.1268 207468.6918 215767.4395 224398.1371 233374.0626 242709.0251 252417.3861 262514.0815 273014.6448 283935.2306 295292.6398 800723.616 783508.0583 807013.3 831223.699 856160.41 881845.2223 908300.5789 935549.5963 963616.0842 992524.5667 1022300.3037 1052969.3128 1084558.3922 1117095.144 1150607.9983 1185126.2383 1220680.0254 1257300.4262 1295019.439 1333870.0221 1373886.1228 1415102.7065 1457555.7877 1501282.4613 1546320.9351 1592710.5632 1640491.8801 2032 462 228 104 794 2032 794 154.1875 1275414.5467 96 794096.64 142.1035 1175457.013 975642.9739 175426.43 1151069.4039 164699.98 1140342.9539 99.4724 136.6379 2032 356972.765 1151069.405 0.0011 1175457.013 24387.6091 1275414.5467 124345.1428 346246.315 1140342.955 0.0011 1175457.013 35114.0591 1275414.5467 135071.5928 522685.44 543592.8576 565336.5719 587950.0348 611468.0362 635926.7576 661363.8279 687818.381 715331.1163 743944.3609 773702.1354 804650.2208 836836.2296 870309.6788 905122.066 941326.9486 978980.0265 1018139.2276 1058864.7967 1101219.3886 1145268.1641 1191078.8907 1238722.0463 1288270.9282 760687.4352 783508.0583 834764.789 902683.7832 953317.5404 1006176.9077 1067596.7603 1133404.8239 1202200.5342 1238266.5502 1275414.5467 1313676.9831 1353087.2926 1393679.9114 1435490.3088 1478555.018 1522911.6686 1568599.0186 1615656.9892 1664126.6989 1714050.4998 1765472.0148 1818436.1753 1872989.2605 1929178.9383 1987054.3065 2046665.9357 2033 462 228 104 794 2033 794 158.8132 1313676.9831 96 794096.64 147.7876 1222475.2936 1004912.2631 175426.43 1180338.6931 164699.98 1169612.2431 103.4513 142.1035 2033 386242.055 1180338.695 0.0019 1222475.2936 42136.6004 1313676.9831 133338.29 375515.605 1169612.245 0.0019 1222475.2936 52863.0504 1313676.9831 144064.74 522685.44 684726.6816 747626.8401 797228.7323 849602.5729 910216.7745 975705.5133 1044977.0044 1086776.0845 1130247.1279 1175457.013 1222475.2936 1271374.3053 1322229.2775 1375118.4486 1430123.1866 1487328.114 1546821.2386 1608694.0881 1673041.8516 1739963.5257 1809562.0667 1881944.5494 1957222.3314 2034 462 228 104 794 2034 794 163.5775 1353087.2926 96 794096.64 153.6991 1271374.3053 1035059.631 175426.43 1427845.371 164699.98 1417118.921 107.5894 147.7876 217359.31 2034 47533.46 416389.425 169825.85 1427845.375 0.004 55127.98 101343.09 1427845.3753 0.0043 74758.08 1427845.3726 0.0016 47533.46 405662.975 169825.85 1417118.925 0.004 68293.44 77451.18 1417118.9253 0.0043 64031.63 1417118.9226 0.0016 2021 2022 2023 2024 2025 2026 2027 2028 169825.85 47533.46 217359.31 2035 462 228 104 794 2035 794 168.4849 1393679.9114 96 794096.64 159.8471 1322229.2775 1066111.42 175426.43 1464897.16 164699.98 1454170.71 111.8929 153.6991 223359.31 2035 447441.21 223359.31 1464897.16 0 142667.885 1464897.1625 0.0026 71217.25 1464897.1614 0.0015 436714.76 223359.31 1454170.71 0 131941.435 1454170.7125 0.0026 60490.8 1454170.7114 0.0015 CFC Earned 641300 510000 226000 339000 180800 226000 237300 237300 2036 462 228 104 794 2036 794 173.5394 1435490.3088 96 794096.64 166.2409 1375118.4486 1098094.7626 175426.43 1504117.6826 164699.98 1493391.2326 116.3687 159.8471 230596.49 2036 479424.555 230596.49 1504117.685 0.0024 128999.235 1504117.6836 0.0011 68627.375 1504117.6838 0.0012 468698.1 230596.495 1493391.235 0.0024 118272.785 1493391.2336 0.0011 57900.925 1493391.2338 0.0012 CFC Used 672792.14 580424.43 166588 3380411 182035 187496.05 193120.93 198914.56 217359.31 223359.31 230596.49 237514.39 2037 462 228 104 794 2037 794 178.7456 1478555.018 96 794096.64 172.8906 1430123.1866 1131037.6054 175426.43 1543978.4254 164699.98 1533251.9754 121.0234 166.2409 237514.39 2037 512367.4 237514.39 1543978.43 0.0046 113855.24 1543978.4266 0.0011 65423.41 1543978.428 0.0026 501640.95 237514.39 1533251.98 0.0046 103128.79 1533251.9766 0.0011 54696.96 1533251.978 0.0026 Remaining 641300 1151300 1345807.86 1104383.43 1118595.43 -2035815.57 -1798515.57 -1743250.57 -1930746.62 -2123867.55 -2322782.11 -2322782.11 -2322782.11 -2540141.42 -2763500.73 -2994097.22 -3231611.61 2038 794 184.108 1522911.6686 96 794096.64 179.8062 1487328.114 1164968.7336 175426.43 1340395.1636 164699.98 1329668.7136 125.8643 172.8906 2038 546298.525 1340395.165 0.0014 1487328.114 146932.9504 1522911.6686 182516.505 535572.075 1329668.715 0.0014 1487328.114 157659.4004 1522911.6686 193242.955 2039 794 189.6312 1568599.0186 96 794096.64 186.9984 1546821.2386 1199917.7956 175426.43 1375344.2256 164699.98 1364617.7756 130.8989 179.8062 2039 581247.59 1375344.23 0.0044 1546821.2386 171477.013 1568599.0186 193254.793 570521.14 1364617.78 0.0044 1546821.2386 182203.463 1568599.0186 203981.243 1344595.43 2040 794 195.3201 1615656.9892 96 794096.64 194.4784 1608694.0881 1235915.3295 175426.43 1670880.1495 164699.98 1660153.6995 136.1349 186.9984 259538.39 2040 617245.12 259538.39 1670880.15 0.0005 62186.065 1670880.1531 0.0037 55223.165 1670880.1542 0.0047 606518.67 259538.39 1660153.7 0.0005 51459.615 1660153.7031 0.0037 44496.715 1660153.7042 0.0047 2041 794 201.1797 1664126.6989 96 794096.64 202.2575 1673041.8516 1272992.7894 175426.43 1715743.7611 164699.98 1705017.3111 141.5803 194.4784 267324.5417 2041 654322.585 267324.54 1715743.765 0.0039 42701.91 1715743.7616 0.0006 25486.175 26130.89 1715743.7639 0.0028 643596.135 267324.54 1705017.315 0.0039 31975.46 1705017.3116 0.0006 40890.615 1705017.3139 0.0028 2042 794 207.2151 1714050.4998 96 794096.64 210.3478 1739963.5257 1311182.573 175426.43 1761953.281 164699.98 1751226.831 147.2435 202.2575 275344.278 2042 692512.365 275344.28 1761953.285 0.004 21989.76 1761953.2857 0.0047 47902.785 1761953.2848 0.0038 681785.915 275344.28 1751226.835 0.004 11263.31 1751226.8357 0.0047 37176.335 1751226.8348 0.0038 2043 794 213.4316 1765472.0148 96 794096.64 218.7617 1809562.0667 1350518.0502 175426.43 1809549.0865 164699.98 1798822.6365 153.1332 210.3478 283604.6063 2043 731847.84 283604.61 1809549.09 0.0035 1809562.0667 12.9802 44077.075 1809549.0898 0.0033 721121.39 283604.61 1798822.64 0.0035 1809562.0667 10739.4302 33350.625 1798822.6398 0.0033 2044 794 219.8345 1818436.1753 96 794096.64 227.5122 1881944.5494 1391033.5917 1391033.5917 164699.98 1555733.5717 159.2585 218.7617 2044 596936.955 1391033.595 0.0033 1881944.5494 490910.9577 1818436.1753 427402.5835 761636.935 1555733.575 0.0033 1881944.5494 326210.9777 1818436.1753 262702.6035 2045 794 226.4296 1872989.2605 96 794096.64 236.6127 1957222.3314 1432764.5995 1432764.5995 164699.98 1597464.5795 165.6289 227.5122 2045 638667.96 1432764.6 0.0005 1957222.3314 524457.7319 1872989.2605 440224.661 803367.94 1597464.58 0.0005 1957222.3314 359757.7519 1872989.2605 275524.681 2046 794 233.2225 1929178.9383 96 794096.64 246.0772 2035511.2246 0 0 0 1475747.5375 1475747.5375 1475747.5375 2626.351 3611.3173 0 2046 681650.9 1475747.54 0.0025 2035511.2246 559763.6872 1929178.9383 453431.4009 681650.9 1475747.54 0.0025 2035511.2246 559763.6872 1929178.9383 453431.4009 4267799.995 0.005 0 0 3467234.76 5060501.37 6005314.6992 6050027.0944 5717008.9459 8408748.4352 4259513.3869 4846953.2716 4793864.6652 4855751.0192 5091452.9393 4991697.8894 5271059.9995 5561202.451 5645185.3243 5734803.741 5829273.3997 9160995.8078 9511669.0899 9875898.6836 10254212.7239 10647160.0479 11055311.0097 11424705.243 11808875.2057 2047 794 240.2191 1987054.3065 96 794096.64 255.9203 2116931.6736 1520019.9636 1520019.9636 1520019.9636 2047 725923.325 1520019.965 0.0014 2116931.6736 596911.71 1987054.3065 467034.3429 725923.325 1520019.965 0.0014 2116931.6736 596911.71 1987054.3065 467034.3429 2048 794 247.4257 2046665.9357 96 794096.64 266.1571 2201608.9406 1565620.5625 1565620.5625 1565620.5625 2048 771523.925 1565620.565 0.0025 2201608.9406 635988.3781 2046665.9357 481045.3732 771523.925 1565620.565 0.0025 2201608.9406 635988.3781 2046665.9357 481045.3732 2943000 37425995.8386 20537948.16 36407876.4222 0 0 0 29553972.6458 9008780.68 46449176.7517 9123651.64 46564047.7117 5252.702 7222.6346 7886423.4259 0 54945 2943000 15857841.815 3941657.8 330000 43610447.775 -2838728.9767 2943000 4957478.8 2608293.125 330000 47246648.3472 797471.5955 2943000 4800000 1927220.43 330000 47426216.2686 977039.5169 2942999.995 16015618.57 3941657.805 330000 43768224.53 -2795823.1817 2942999.995 4927738.465 2520042.515 330000 47128657.3972 564609.6855 2943000 4800000 1794668.19 330000 47293664.0286 729616.3169 Created and updated 06/24/2022 @ 1425hrs Assumptions 5 million dollar project with a 1.5 million dollar contribution 5% loan forgiveness applied to new debt O&M for 2022 is actual. Escalates 3% annually for assumed inflation Rates. Beginning in 2023 rates escalate 1% more than inflation 5% delinquency rate CFC's adjusted to reflect new rate in 2025 Paying off existing debt in 2027 with reserved REET CFC's used for future Capital costs Rates Expenses Alt Rev Sources Alt Rev Sources Alt Rev Sources Alt Rev Sources Alt Rev Sources Alt Rev Sources CFC's Earned YEAR ERU's Estimated max tolerable rate Est Rev MTR Rate/ERU (no increase) Revenue (no increase) Rate/ERU REVENUE w/1% over CPI Inc O&M DEBT Service B O&M+Debt Service+Capital Exp DEBT Service A O&M+Debt Service+Capital Exp DEBT Service 5yr delay O&M debt Service+Capital Exp Res Rate/ERU Multi Family Rate/ERU Comm Rate/ERU RATE/ERU Estimated max tolerable rate Capital expenditures PWB Funding Option B (20 years @ 0.54%) CFC's (Used) REET .09 Tax ARPA Total Fund by year Deficit / Surplus CFC's (Used) REET .09 Tax ARPA Total Fund by year Deficit / Surplus CFC's (Used) REET .09 Tax ARPA Total Fund by year Deficit / Surplus PWB Funding Option A (22 years @ 0.79%) CFC's (Used) REET .09 Tax ARPA Total Fund by year Deficit / Surplus CFC's (Used) REET .09 Tax ARPA Total Fund by year Deficit / Surplus CFC's (Used) REET .09 Tax ARPA Total Fund by year Deficit / Surplus Residential & Multi Family Rate 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 Current Rate w/increase equal to 1%>CPI 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 72036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 Current Rate no annual increase 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 72036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 YEAR Res MF Comm 641300 2021 96 105 109.2 113.568 118.1107 122.8351 127.7486 132.8585 138.1728 143.6998 149.4477 155.4256 161.6427 168.1084 174.8327 181.826 189.0991 196.663 204.5296 212.7107 221.2192 230.0679 239.2706 248.8415 258.7951 96 99.84 103.8336 107.9869 112.3064 116.7987 121.4706 126.3295 131.3826 136.6379 142.1035 147.7876 153.6991 159.8471 166.2409 172.8906 179.8062 186.9984 194.4784 202.2575 210.3478 218.7617 227.5122 236.6127 246.0772 255.9203 266.1571 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 2022 318 0/127 104 422/549 510000 2022 421/549 114.73 599664.282 96 509771.52 96 509771.52 725970 778351.46 1834321.46 778351.46 1834321.46 778351.46 96 67.2 96 96 114.73 330000 800000 194549.94 330000 1834321.46 0 800000 194549.94 330000 1834321.46 0 800000 104657.18 330000 1834321.462 0.002 800000 194549.94 330000 1834321.46 0 800000 194549.94 330000 1834321.46 0 800000 104657.18 330000 1834321.462 0.002 1152 1260 1310.4 1362.816 1417.3286 1474.0218 1532.9827 1594.302 1658.074 1724.397 1793.3729 1865.1078 1939.7121 2017.3006 2097.9926 2181.9123 2269.1888 2359.9564 2454.3546 2552.5288 2654.63 2760.8152 2871.2478 2986.0977 3105.5416 1152 1198.08 1246.0032 1295.8433 1347.6771 1401.5841 1457.6475 1515.9534 1576.5915 1639.6552 1705.2414 1773.4511 1844.3891 1918.1647 1994.8913 2074.6869 2157.6744 2243.9814 2333.7406 2427.0903 2524.1739 2625.1408 2730.1464 2839.3523 2952.9264 3071.0435 3193.8852 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 2023 318 228 104 650 226000 2023 650 118.1719 783508.0583 96 636503.04 99.84 661963.1616 747749.1 1021473.7 2442014.94 1021473.7 2442014.94 1021473.7 105 73.5 96 99.84 118.1719 672792.14 555511.9 800000 450000 2442014.94 0 530051.78 800000 450000 2442014.9416 0.0016 408506.885 800000 450000 2442014.9433 0.0033 555511.9 800000 450000 2442014.94 0 530051.78 800000 450000 2442014.9416 0.0016 408506.885 800000 450000 2442014.9433 0.0033 2157900 484992 399420 416707.2 433375.488 450710.5075 468738.9278 487488.4849 506988.0243 527267.5453 548358.2471 570292.577 593104.2801 616828.4513 641501.5893 667161.6529 693848.119 721602.0438 750466.1255 780484.7706 811704.1614 844172.3278 877939.221 913056.7898 949579.0614 987562.2238 509771.52 504391.68 524567.3472 545550.0411 567372.0427 590066.9244 613669.6014 638216.3855 663745.0409 690294.8425 717906.6362 746622.9017 776487.8177 807547.3305 839849.2237 873443.1926 908380.9203 944716.1571 982504.8034 1021804.9956 1062677.1954 1105184.2832 1149391.6545 1195367.3207 1243182.0135 1292909.2941 1344625.6658 509771.52 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 2024 338 228 104 670 339000 2024 670 121.7171 834764.789 96 658391.04 103.8336 712115.7489 770181.573 1176484.15 2527090.153 1161160.65 2511766.653 925874.96 109.2 76.44 182228.45 103.8336 121.7171 580424.43 618699.115 800000 450000 2527090.155 0.002 564974.405 800000 450000 2527090.1539 0.0009 442325.365 800000 450000 2527090.154 0.001 603375.615 800000 450000 2511766.655 0.002 549650.905 800000 450000 2511766.6539 0.0009 427001.865 800000 450000 2511766.654 0.001 2133900 24000 550195.2 570490.2 594554.688 618336.8755 643070.3505 668793.1646 695544.8911 723366.6868 752301.3543 782393.4084 813689.1448 846236.7106 880086.179 915289.6261 951901.2112 989977.2596 1029576.35 1070759.404 1113589.7802 1158133.3714 1204458.7062 1252637.0545 1302742.5367 1354852.2381 1409046.3277 670003.2 661963.1616 688441.6881 715979.3556 744618.5298 774403.271 805379.4018 837594.5779 871098.361 905942.2955 942179.9873 979867.1868 1019061.8743 1059824.3492 1102217.3232 1146306.0161 1192158.2568 1239844.587 1289438.3705 1341015.9053 1394656.5416 1450442.8032 1508460.5153 1568798.936 1631550.8934 1696812.9291 1764685.4463 670003.2 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 2025 368 228 104 700 220800 2025 700 125.3686 902683.7832 96 691223.04 107.9869 777531.9137 793287.0202 1172444.02 2132319.0402 1157120.52 2116995.5402 921834.83 113.568 79.4976 0 107.9869 125.3686 166588 191096.005 800000 450000 2132319.045 0.0048 104787.13 800000 450000 2132319.0437 0.0035 800000 429635.26 2132319.0432 0.003 175772.505 800000 450000 2116995.545 0.0048 89463.63 800000 450000 2116995.5437 0.0035 800000 414311.76 2116995.5432 0.003 636503.04 601776 652055.04 719021.7216 770459.8487 824862.5912 888516.748 957537.7592 1030658.8244 1071885.1774 1114760.5845 1159351.0079 1205725.0482 1253954.0501 1304112.2121 1356276.7006 1410527.7686 1466948.8794 1525626.8345 1586651.9079 1650117.9842 1716122.7036 1784767.6117 1856158.3162 1930404.6489 636503.04 661963.1616 712115.7489 777531.9137 829117.8815 883586.6758 946625.4455 1014733.7338 1086776.0845 1130247.1279 1175457.013 1222475.2936 1271374.3053 1322229.2775 1375118.4486 1430123.1866 1487328.114 1546821.2386 1608694.0881 1673041.8516 1739963.5257 1809562.0667 1881944.5494 1957222.3314 2035511.2246 2116931.6736 2201608.9406 636503.04 636503.04 658391.04 691223.04 708733.44 726243.84 748131.84 771114.24 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 2026 384 228 104 716 220800 2026 716 129.1296 902683.7832 96 708733.44 112.3064 829117.8815 817085.6308 1177596.51 5375093.1408 1162273.01 5359769.6408 926987.32 118.1107 82.6775 0 112.3064 129.1296 3380411 559792.98 800000 450000 2518526.42 -2856566.7208 934086.685 800000 450000 3013204.5665 -2361888.5743 1283067.75 800000 450000 3435751.5332 -1939341.6076 799239.98 800000 450000 2757973.42 -2601796.2208 964733.69 800000 450000 3043851.5715 -2315918.0693 1298391.25 800000 450000 3451075.0332 -1908694.6076 509771.52 655783.29 737822.592 806175.7517 859966.1771 916769.9553 982567.424 1053676.4451 1128902.0801 1174058.1633 1221020.4898 1269861.3094 1320655.7618 1373481.9922 1428421.2719 1485558.1228 1544980.4477 1606779.6656 1671050.8522 1737892.8863 1807408.6018 1879704.9459 1954893.1437 2033088.8694 2114412.4242 2027 400 228 104 732 276000 2027 732 133.0035 1006176.9077 96 726243.84 116.7987 883586.6758 841598.1997 1176339 2017937.1997 1161015.5 2002613.6997 925729.81 122.8351 85.9846 0 116.7987 133.0035 800000 1526243.84 -491693.3597 800000 1683586.6758 -334350.5239 800000 1806176.9077 -211760.2921 800000 1526243.84 -476369.8597 800000 319027.025 2002613.7008 0.0011 800000 196436.795 2002613.7027 0.0029 1006176.9077 1067596.7603 1133404.8239 1202200.5342 1238266.5502 1275414.5467 1313676.9831 1353087.2926 1393679.9114 1435490.3088 1478555.018 1522911.6686 1568599.0186 1615656.9892 1664126.6989 1714050.4998 1765472.0148 1818436.1753 1818436.1753 1818436.1753 Max Tolerable rate 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 72036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2028 420 228 104 752 276000 2028 752 136.9936 1067596.7603 96 748131.84 121.4706 946625.4455 866846.1457 250609.19 1299490.3357 235285.69 1284166.8357 265047.03 127.7486 89.424 1315633.2739 121.4706 136.9936 182035 182035 369323.5 1299490.34 0.0043 182035 170829.895 1299490.3405 0.0048 182035 49858.58 1299490.3403 0.0045 182035 354000 1284166.84 0.0043 182035 155506.395 1284166.8405 0.0048 216570.08 1284166.8403 0.0045 Commercial 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 114.73 118.1719 121.7171 125.3686 129.1296 133.0035 136.9936 141.1034 145.3365 149.6966 154.1875 158.8132 163.5775 168.4849 173.5394 178.7456 184.108 189.6312 195.3201 201.1797 207.2151 213.4316 219.8345 226.4296 233.2225 240.2191 247.4257 2029 441 228 104 773 289800 2029 773 141.1034 1133404.8239 96 771114.24 126.3295 1014733.7338 892851.5301 250609.19 1330956.7701 235285.69 1315633.2701 265047.03 132.8585 93.0009 0.0038 126.3295 141.1034 187496.05 187496.05 372346.485 1330956.775 0.0049 187496.05 128726.99 1330956.7738 0.0038 187496 10055.95 1330956.7739 0.0038 187496 357023.035 1315633.275 0.0049 187496.05 113403.49 1315633.2738 0.0038 182228.45 1315633.2739 0.0038 96 99.84 103.8336 107.9869 112.3064 116.7987 121.4706 126.3295 131.3826 136.6379 142.1035 147.7876 153.6991 159.8471 166.2409 172.8906 179.8062 186.9984 194.4784 202.2575 210.3478 218.7617 227.5122 236.6127 1376.76 1418.0628 1460.6047 1504.4228 1549.5555 1596.0422 1643.9234 1693.2411 1744.0384 1796.3595 1850.2503 1905.7578 1962.9306 2021.8185 2082.473 2144.9472 2209.2956 2275.5745 2343.8417 2414.157 2486.5817 2561.1792 2638.0145 2717.155 2798.6696 2882.6297 2969.1086 2030 462 228 104 794 2030 794 145.3365 1202200.5342 96 794096.64 131.3826 1086776.0845 919637.076 250609.19 1363367.196 235285.69 1348043.696 265047.03 138.1728 96.721 0 131.3826 145.3365 193120.93 193120.93 376149.63 1363367.2 0.004 193120.93 83470.185 1363367.1995 0.0035 161166.665 1363367.1992 0.0032 186966.87 366980.19 1348043.7 0.004 186966.865 74300.75 1348043.6995 0.0035 145843.165 1348043.6992 0.0032 1152 1198.08 1246.0032 1295.8433 1347.6771 1401.5841 1457.6475 1515.9534 1576.5915 1639.6552 1705.2414 1773.4511 1844.3891 1918.1647 1994.8913 2074.6869 2157.6744 2243.9814 2333.7406 2427.0903 2524.1739 2625.1408 2730.1464 2839.3523 599664.282 597004.4388 614914.572 633362.0091 652362.8694 671933.7555 692091.7681 712854.5212 734240.1568 756267.3615 778955.3824 802324.0438 826393.7652 851185.5781 876721.1455 903022.7798 930113.4632 958016.8671 986757.3731 1016360.0943 1046850.8971 1078256.4241 1110604.1168 1143922.2403 1178239.9075 1213587.1047 1249994.7179 2031 462 228 104 794 2031 794 149.6966 1238266.5502 96 794096.64 136.6379 1130247.1279 947226.1883 250609.19 1396749.9383 235285.69 1381426.4383 265047.03 143.6998 100.5898 0 136.6379 149.6966 198914.56 198914.56 403738.74 1396749.94 0.0017 198914.56 67588.255 1396749.9429 0.0047 158483.39 1396749.9402 0.002 176878.57 410451.23 1381426.44 0.0017 176878.565 74300.75 1381426.4429 0.0047 143159.89 1381426.4402 0.002 119808 124600.32 129584.3328 134767.7061 140158.4144 145764.7509 151595.341 157659.1546 163965.5208 170524.1416 177345.1073 184438.9116 191816.468 199489.1268 207468.6918 215767.4395 224398.1371 233374.0626 242709.0251 252417.3861 262514.0815 273014.6448 283935.2306 295292.6398 800723.616 783508.0583 807013.3 831223.699 856160.41 881845.2223 908300.5789 935549.5963 963616.0842 992524.5667 1022300.3037 1052969.3128 1084558.3922 1117095.144 1150607.9983 1185126.2383 1220680.0254 1257300.4262 1295019.439 1333870.0221 1373886.1228 1415102.7065 1457555.7877 1501282.4613 1546320.9351 1592710.5632 1640491.8801 2032 462 228 104 794 2032 794 154.1875 1275414.5467 96 794096.64 142.1035 1175457.013 975642.9739 250609.19 1226252.1639 235285.69 1210928.6639 265047.03 149.4477 104.6134 0 142.1035 154.1875 432155.525 1226252.165 0.0011 50795.155 1226252.168 0.0041 1275414.5467 49162.3828 416832.025 1210928.665 0.0011 35471.655 1210928.668 0.0041 1275414.5467 64485.8828 522685.44 543592.8576 565336.5719 587950.0348 611468.0362 635926.7576 661363.8279 687818.381 715331.1163 743944.3609 773702.1354 804650.2208 836836.2296 870309.6788 905122.066 941326.9486 978980.0265 1018139.2276 1058864.7967 1101219.3886 1145268.1641 1191078.8907 1238722.0463 1288270.9282 760687.4352 783508.0583 834764.789 902683.7832 953317.5404 1006176.9077 1067596.7603 1133404.8239 1202200.5342 1238266.5502 1275414.5467 1313676.9831 1353087.2926 1393679.9114 1435490.3088 1478555.018 1522911.6686 1568599.0186 1615656.9892 1664126.6989 1714050.4998 1765472.0148 1818436.1753 1872989.2605 1929178.9383 1987054.3065 2046665.9357 2033 462 228 104 794 2033 794 158.8132 1313676.9831 96 794096.64 147.7876 1222475.2936 1004912.2631 250609.19 1255521.4531 235285.69 1240197.9531 265047.03 155.4256 108.798 0 147.7876 158.8132 461424.815 1255521.455 0.0019 33046.16 1255521.4536 0.0004 1313676.9831 58155.53 446101.315 1240197.955 0.0019 17722.66 1240197.9536 0.0004 1313676.9831 73479.03 522685.44 684726.6816 747626.8401 797228.7323 849602.5729 910216.7745 975705.5133 1044977.0044 1086776.0845 1130247.1279 1175457.013 1222475.2936 1271374.3053 1322229.2775 1375118.4486 1430123.1866 1487328.114 1546821.2386 1608694.0881 1673041.8516 1739963.5257 1809562.0667 1881944.5494 1957222.3314 2034 462 228 104 794 2034 794 163.5775 1353087.2926 96 794096.64 153.6991 1271374.3053 1035059.631 250609.19 1503028.131 235285.69 1487704.631 265047.03 161.6427 113.1499 0 153.6991 163.5775 217359.31 217359.31 491572.185 1503028.135 0.004 104233.46 127420.37 1503028.1353 0.0043 149940.84 1503028.1326 0.0016 132423.56 448058.585 113125.85 1487704.635 0.004 132423.515 83906.815 1487704.6353 0.0043 134617.34 1487704.6326 0.0016 2021 2022 2023 2024 2025 2026 2027 2028 -1.9349 2035 462 228 104 794 2035 794 168.4849 1393679.9114 96 794096.64 159.8471 1322229.2775 1066111.42 250609.19 1540079.92 235285.69 1524756.42 265047.03 168.1084 117.6759 96 159.8471 168.4849 223359.31 95674.15 522623.97 127685.16 1540079.92 0 217850.645 1540079.9225 0.0026 26678.1 119721.91 1540079.9214 0.0015 507300.47 223359.31 1524756.42 0 202527.145 1524756.4225 0.0026 43381.07 87695.44 1524756.4214 0.0015 CFC Earned 641300 510000 226000 339000 180800 226000 237300 237300 2036 462 228 104 794 2036 794 173.5394 1435490.3088 96 794096.64 166.2409 1375118.4486 1098094.7626 250609.19 1579300.4426 235285.69 1563976.9426 265047.03 174.8327 122.3829 99.84 166.2409 173.5394 230596.49 554607.315 230596.49 1579300.445 0.0024 204181.995 1579300.4436 0.0011 143810.135 1579300.4438 0.0012 539283.81 230596.495 1563976.945 0.0024 188858.495 1563976.9436 0.0011 128486.635 1563976.9438 0.0012 CFC Used 672792.14 580424.43 166588 3380411 182035 187496.05 193120.93 198914.56 217359.31 223359.31 230596.49 237514.39 2037 462 228 104 794 2037 794 178.7456 1478555.018 96 794096.64 172.8906 1430123.1866 1131037.6054 250609.19 1619161.1854 235285.69 1603837.6854 265047.03 181.826 127.2782 103.8336 172.8906 178.7456 237514.39 587550.16 237514.39 1619161.19 0.0046 189038 1619161.1866 0.0011 140606.17 1619161.188 0.0026 572226.66 237514.39 1603837.69 0.0046 173714.5 1603837.6866 0.0011 125282.67 1603837.688 0.0026 Remaining 641300 1151300 1345807.86 1104383.43 1118595.43 -2035815.57 -1798515.57 -1743250.57 -1930746.62 -2123867.55 -2322782.11 -2322782.11 -2322782.11 -2540141.42 -2763500.73 -2994097.22 -3231611.61 2038 794 184.108 1522911.6686 96 794096.64 179.8062 1487328.114 1164968.7336 250609.19 1415577.9236 235285.69 1400254.4236 265047.03 189.0991 132.3693 107.9869 179.8062 184.108 621481.285 1415577.925 0.0014 1487328.114 71750.1904 1522911.6686 107333.745 606157.785 1400254.425 0.0014 1487328.114 87073.6904 1522911.6686 122657.245 2039 794 189.6312 1568599.0186 96 794096.64 186.9984 1546821.2386 1199917.7956 250609.19 1450526.9856 235285.69 1435203.4856 265047.03 196.663 137.6641 112.3064 186.9984 189.6312 656430.35 1450526.99 0.0044 1546821.2386 96294.253 1568599.0186 118072.033 641106.85 1435203.49 0.0044 1546821.2386 111617.753 1568599.0186 133395.533 1344595.43 2040 794 195.3201 1615656.9892 96 794096.64 194.4784 1608694.0881 1235915.3295 250609.19 1746062.9095 235285.69 1730739.4095 265047.03 204.5296 143.1707 116.7987 194.4784 195.3201 259538.39 692427.88 259538.39 1746062.91 0.0005 137368.825 1746062.9131 0.0037 130405.925 1746062.9142 0.0047 677104.38 259538.39 1730739.41 0.0005 122045.325 1730739.4131 0.0037 115082.425 1730739.4142 0.0047 2041 794 201.1797 1664126.6989 96 794096.64 202.2575 1673041.8516 1272992.7894 250609.19 1790926.5211 235285.69 1775603.0211 265047.03 212.7107 148.8975 121.4706 202.2575 201.1797 267324.5417 729505.345 267324.54 1790926.525 0.0039 117884.67 1790926.5216 0.0006 126799.825 1790926.5239 0.0028 714181.845 267324.54 1775603.025 0.0039 102561.17 1775603.0216 0.0006 111476.325 1775603.0239 0.0028 2042 794 207.2151 1714050.4998 96 794096.64 210.3478 1739963.5257 1311182.573 250609.19 1837136.041 235285.69 1821812.541 265047.03 221.2192 154.8534 126.3295 210.3478 207.2151 275344.278 767695.125 275344.28 1837136.045 0.004 97172.52 1837136.0457 0.0047 123085.545 1837136.0448 0.0038 752371.625 275344.28 1821812.545 0.004 81849.02 1821812.5457 0.0047 107762.045 1821812.5448 0.0038 2043 794 213.4316 1765472.0148 96 794096.64 218.7617 1809562.0667 1350518.0502 250609.19 1884731.8465 235285.69 1869408.3465 265047.03 230.0679 161.0476 131.3826 218.7617 213.4316 283604.6063 800000 283604.61 1877701.25 -7030.5965 75169.78 1884731.8467 0.0002 119259.835 1884731.8498 0.0033 791707.1 283604.61 1869408.35 0.0035 59846.28 1869408.3467 0.0002 103936.335 1869408.3498 0.0033 2044 794 219.8345 1818436.1753 96 794096.64 227.5122 1881944.5494 1391033.5917 1391033.5917 235285.69 1626319.2817 265047.03 239.2706 167.4895 136.6379 227.5122 219.8345 596936.955 1391033.595 0.0033 1881944.5494 490910.9577 1818436.1753 427402.5835 800000 1594096.64 -32222.6417 1881944.5494 255625.2677 1818436.1753 192116.8935 2045 794 226.4296 1872989.2605 96 794096.64 236.6127 1957222.3314 1432764.5995 1432764.5995 235285.69 1668050.2895 265047.03 248.8415 174.189 142.1035 236.6127 226.4296 638667.96 1432764.6 0.0005 1957222.3314 524457.7319 1872989.2605 440224.661 800000 1594096.64 -73953.6495 1957222.3314 289172.0419 1872989.2605 204938.971 2046 794 233.2225 1929178.9383 96 794096.64 246.0772 2035511.2246 0 0 0 1475747.5375 1475747.5375 1475747.5375 265047.03 258.7951 181.1566 147.7876 246.0772 233.2225 681650.9 1475747.54 0.0025 2035511.2246 559763.6872 1929178.9383 453431.4009 681650.9 1475747.54 0.0025 2035511.2246 559763.6872 1929178.9383 453431.4009 2047 794 240.2191 1987054.3065 96 794096.64 255.9203 2116931.6736 1520019.9636 1520019.9636 1520019.9636 265047.03 269.1469 188.4029 153.6991 255.9203 240.2191 725923.325 1520019.965 0.0014 2116931.6736 596911.71 1987054.3065 467034.3429 725923.325 1520019.965 0.0014 2116931.6736 596911.71 1987054.3065 467034.3429 2048 794 247.4257 2046665.9357 96 794096.64 266.1571 2201608.9406 1565620.5625 1565620.5625 1565620.5625 279.9128 195.939 159.8471 266.1571 247.4257 771523.925 1565620.565 0.0025 2201608.9406 635988.3781 2046665.9357 481045.3732 771523.925 1565620.565 0.0025 2201608.9406 635988.3781 2046665.9357 481045.3732 2999700 37425995.8386 20537948.16 36407876.4222 0 0 0 29553972.6458 10512435.88 47952831.9517 10676537.26 48116933.3317 2999700 2999466.7775 7886423.4259 2999700 17053735.375 3676157.8 330000 44597541.335 -3355290.6167 2999700 5762052.435 2733040.95 330000 48232669.8072 279837.8555 2999699.995 4800000 2847896.315 330000 48403592.1486 450760.1969 0 2999700 17179985.055 3884957.805 330000 44932591.02 -3184342.3117 2999700 5270705.7 3328885.715 330000 48337167.8372 220234.5055 2999699.995 4800000 2845127.61 330000 48400823.4436 283890.1119 0 0 Current CFC Loan amt 3500000 New CFC 11300 1750 13050 Loan amt 5000000 11300 2500 13800 Created and updated 05/31/2022 @ 0910hrs Assumptions ESDC $785,000 5% loan forgiveness applied to new debt O&M for 2022 is actual. Escalates 3% annually for assumed inflation Rates. Beginning in 2023 rates escalate 1% more than inflation 5% delinquency rate CFC's adjusted to reflect new rate in 2025 Using collected CFC's for Capital costs as they occur. CFC's YEAR ERU's Estimated max tolerable rate Est Rev MTR Rate/ERU No Increase RATE REVENUE No increase RATE/ERU REVENUE w/1% over CPI Inc REVENUE w/1% over CPI Inc O&M DEBT Service B O&M+Debt Service+Capital Exp DEBT Service A O&M+Debt Service+Capital Exp DEBT Service 5yr delay O&M debt Service+Capital Exp Res Rate/ERU Multi Family Rate/ERU Comm Rate/ERU RATE/ERU Estimated max tolerable rate Capital expenditures PWB Funding Option B YEAR CFC's REET .09 Tax ARPA Total Available Funds Deficit/Surpuls PWB Funding Option A CFC's REET .09 Tax ARPA Total Available Funds Deficit/Surpuls CFC's REET .09 Tax ARPA Total Available Funds Deficit/Surpuls 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 Current Rate no annual increase 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 72036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 Res MF Comm 641300 2021 96 105 109.2 113.568 118.1107 122.8351 127.7486 132.8585 138.1728 143.6998 149.4477 155.4256 161.6427 168.1084 174.8327 181.826 189.0991 196.663 204.5296 212.7107 221.2192 230.0679 239.2706 248.8415 258.7951 269.1469 279.9128 Comm Res MF 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 2022 318 0/127 104 422/549 510000 2022 421/549 114.73 599664.282 96 509771.52 96 509771.52 509771.52 725970 778351.46 1834321.46 778351.46 1834321.46 778351.46 96 67.2 96 96 114.73 330000 2022 800000 194549.94 330000 1834321.46 0 800000 194549.94 330000 1834321.46 0 509771.52 509771.52 1152 1260 1310.4 1362.816 1417.3286 1474.0218 1532.9827 1594.302 1658.074 1724.397 1793.3729 1865.1078 1939.7121 2017.3006 2097.9926 2181.9123 2269.1888 2359.9564 2454.3546 2552.5288 2654.63 2760.8152 2871.2478 2986.0977 3105.5416 3229.7632 3358.9538 159.85 174.83 122.381 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 1152 2023 318 228 104 650 226000 2023 650 118.1719 783508.0583 96 636503.04 99.84 661963.1616 661963.1616 747749.1 1021473.7 2442014.94 1021473.7 2442014.94 1021473.7 105 73.5 96 99.84 118.1719 672792.14 2023 530051.78 800000 450000 2416554.82 -25460.1200000001 530051.78 800000 450000 2416554.82 -25460.12 661963.1616 661963.1616 484992 399420 416707.2 433375.488 450710.5075 468738.9278 487488.4849 506988.0243 527267.5453 548358.2471 570292.577 593104.2801 616828.4513 641501.5893 667161.6529 693848.119 721602.0438 750466.1255 780484.7706 811704.1614 844172.3278 877939.221 913056.7898 949579.0614 987562.2238 1027064.7128 1068147.3013 104 462 228 794 509771.52 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 484992 2024 338 228 104 670 339000 2024 670 121.7171 834764.789 96 658391.04 103.8336 712115.7489 712115.7489 770181.573 1176484.15 2527090.153 1161160.65 2511766.653 925874.96 109.2 76.44 99.84 103.8336 121.7171 580424.43 2024 564974.405 800000 450000 2473365.445 -53724.7080000006 549650.905 800000 450000 2458041.945 -53724.708 712115.7489 712115.7489 550195.2 570490.2 594554.688 618336.8755 643070.3505 668793.1646 695544.8911 723366.6868 752301.3543 782393.4084 813689.1448 846236.7106 880086.179 915289.6261 951901.2112 989977.2596 1029576.35 1070759.404 1113589.7802 1158133.3714 1204458.7062 1252637.0545 1302742.5367 1354852.2381 1409046.3277 1465408.1808 1524024.508 1918.2 2097.96 1468.572 1428405.4992 670003.2 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 636503.04 2025 368 228 104 700 220800 2025 700 125.3686 902683.7832 96 691223.04 107.9869 777531.9137 777531.9137 793287.0202 1172444.02 2132319.0402 1157120.52 2116995.5402 921834.83 113.568 79.4976 103.8336 107.9869 125.3686 166588 2025 104787.13 800000 450000 2046010.17 -86308.8701900002 89463.63 800000 450000 2030686.67 -86308.8702 777531.9137 777531.9137 636503.04 601776 652055.04 719021.7216 770459.8487 824862.5912 888516.748 957537.7592 1030658.8244 1071885.1774 1114760.5845 1159351.0079 1205725.0482 1253954.0501 1304112.2121 1356276.7006 1410527.7686 1466948.8794 1525626.8345 1586651.9079 1650117.9842 1716122.7036 1784767.6117 1856158.3162 1930404.6489 2007620.8348 2087925.6682 199492.8 969257.52 334834.416 1503584.736 636503.04 636503.04 658391.04 691223.04 708733.44 726243.84 748131.84 771114.24 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 794096.64 2026 384 228 104 716 220800 2026 716 129.1296 953317.5404 96 708733.44 112.3064 829117.8815 829117.8815 817085.6308 1177596.51 5375093.1408 1162273.01 5359769.6408 926987.32 118.1107 82.6775 107.9869 112.3064 129.1296 3380411 2026 958086.69 800000 450000 2916820.13 -2458273.0107957 964733.69 800000 450000 2923467.13 -2436302.5108 829117.8815 829117.8815 509771.52 655783.29 737822.592 806175.7517 859966.1771 916769.9553 982567.424 1053676.4451 1128902.0801 1174058.1633 1221020.4898 1269861.3094 1320655.7618 1373481.9922 1428421.2719 1485558.1228 1544980.4477 1606779.6656 1671050.8522 1737892.8863 1807408.6018 1879704.9459 1954893.1437 2033088.8694 2114412.4242 2198988.9212 2286948.478 Res/ERU 105 1260 687960 1897100 1749804.57 147295.43 180800 328095.43 2027 400 228 104 732 276000 2027 732 133.0035 1006176.9077 96 726243.84 116.7987 883586.6758 883586.6758 841598.1997 1176339 2017937.1997 1161015.5 2002613.6997 925729.81 122.8351 85.9846 112.3064 116.7987 133.0035 2027 800000 334350.525 1860594.365 -157342.834719571 800000 319027.025 1845270.865 -157342.8347 883586.6758 883586.6758 1006176.9077 1067596.7603 1133404.8239 1202200.5342 1238266.5502 1275414.5467 1313676.9831 1353087.2926 1393679.9114 1435490.3088 1478555.018 1522911.6686 1568599.0186 1615656.9892 1664126.6989 1714050.4998 1765472.0148 1818436.1753 2028 420 228 104 752 276000 2028 752 136.9936 1067596.7603 96 748131.84 121.4706 946625.4455 946625.4455 866846.1457 250609.19 1299490.3357 235285.69 1284166.8357 265047.03 127.7486 89.424 116.7987 121.4706 136.9936 182035 2028 182035 170829.895 1100996.735 -198493.600711158 182035 155506.395 1085673.235 -198493.6007 946625.4455 946625.4455 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 Comm/eru 81.3645 976.374 101542.896 Current Rate w/increase equal to 1%>CPI 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 72036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2029 441 228 104 773 289800 2029 773 141.1034 0 96 771114.24 126.3295 1014733.7338 1014733.7338 892851.5301 250609.19 1330956.7701 235285.69 1315633.2701 265047.03 132.8585 93.0009 121.4706 126.3295 141.1034 187496.05 2029 187496.05 128726.99 1087337.28 -243619.490082493 187496.045 113403.495 1072013.78 -243619.4901 1014733.7338 1014733.7338 96 99.84 103.8336 107.9869 112.3064 116.7987 121.4706 126.3295 131.3826 136.6379 142.1035 147.7876 153.6991 159.8471 166.2409 172.8906 179.8062 186.9984 194.4784 202.2575 210.3478 218.7617 227.5122 236.6127 246.0772 255.9203 789502.896 750027.7512 96 99.84 103.8336 107.9869 112.3064 116.7987 121.4706 126.3295 131.3826 136.6379 142.1035 147.7876 153.6991 159.8471 166.2409 172.8906 179.8062 186.9984 194.4784 202.2575 210.3478 218.7617 227.5122 236.6127 246.0772 255.9203 266.1571 2030 462 228 104 794 2030 794 145.3365 0 96 794096.64 131.3826 1086776.0845 1086776.0845 919637.076 250609.19 1363367.196 235285.69 1348043.696 265047.03 138.1728 96.721 126.3295 131.3826 145.3365 193120.93 2030 193120.93 83470.185 1070687.755 -292679.440984968 193120.93 68146.685 1055364.255 -292679.441 1086776.0845 1086776.0845 1152 1198.08 1246.0032 1295.8433 1347.6771 1401.5841 1457.6475 1515.9534 1576.5915 1639.6552 1705.2414 1773.4511 1844.3891 1918.1647 1994.8913 2074.6869 2157.6744 2243.9814 2333.7406 2427.0903 2524.1739 2625.1408 2730.1464 2839.3523 2952.9264 3071.0435 1152 1198.08 1246.0032 1295.8433 1347.6771 1401.5841 1457.6475 1515.9534 1576.5915 1639.6552 1705.2414 1773.4511 1844.3891 1918.1647 1994.8913 2074.6869 2157.6744 2243.9814 2333.7406 2427.0903 2524.1739 2625.1408 2730.1464 2839.3523 2952.9264 3071.0435 3193.8852 2031 462 228 104 794 2031 794 149.6966 0 96 794096.64 136.6379 1130247.1279 1130247.1279 947226.1883 250609.19 1396749.9383 235285.69 1381426.4383 265047.03 143.6998 100.5898 131.3826 136.6379 149.6966 198914.56 2031 198914.56 67588.255 1060599.455 -336150.483264517 198914.56 52264.755 1045275.955 -336150.4833 1130247.1279 1130247.1279 119808 124600.32 129584.3328 134767.7061 140158.4144 145764.7509 151595.341 157659.1546 163965.5208 170524.1416 177345.1073 184438.9116 191816.468 199489.1268 207468.6918 215767.4395 224398.1371 233374.0626 242709.0251 252417.3861 262514.0815 273014.6448 283935.2306 295292.6398 307104.3454 319388.5192 509771.52 504391.68 524567.3472 545550.0411 567372.0427 590066.9244 613669.6014 638216.3855 663745.0409 690294.8425 717906.6362 746622.9017 776487.8177 807547.3305 839849.2237 873443.1926 908380.9203 944716.1571 982504.8034 1021804.9956 1062677.1954 1105184.2832 1149391.6545 1195367.3207 1243182.0135 1292909.2941 1344625.6658 2032 462 228 104 794 2032 794 154.1875 0 96 g119 142.1035 1175457.013 1175457.013 975642.9739 250609.19 1226252.1639 235285.69 1210928.6639 265047.03 149.4477 104.6134 136.6379 142.1035 154.1875 2032 50795.155 35471.655 1175457.013 1175457.013 522685.44 543592.8576 565336.5719 587950.0348 611468.0362 635926.7576 661363.8279 687818.381 715331.1163 743944.3609 773702.1354 804650.2208 836836.2296 870309.6788 905122.066 941326.9486 978980.0265 1018139.2276 1058864.7967 1101219.3886 1145268.1641 1191078.8907 1238722.0463 1288270.9282 1339801.7653 1393393.8359 670003.2 661963.1616 688441.6881 715979.3556 744618.5298 774403.271 805379.4018 837594.5779 871098.361 905942.2955 942179.9873 979867.1868 1019061.8743 1059824.3492 1102217.3232 1146306.0161 1192158.2568 1239844.587 1289438.3705 1341015.9053 1394656.5416 1450442.8032 1508460.5153 1568798.936 1631550.8934 1696812.9291 1764685.4463 2033 462 228 104 794 2033 794 158.8132 0 96 794096.64 147.7876 1222475.2936 1222475.2936 1004912.2631 250609.19 1255521.4531 235285.69 1240197.9531 265047.03 155.4256 108.798 142.1035 147.7876 158.8132 2033 33046.16 827142.8 -428378.653129826 17722.66 811819.3 -428378.6531 1222475.2936 1222475.2936 522685.44 684726.6816 747626.8401 797228.7323 849602.5729 910216.7745 975705.5133 1044977.0044 1086776.0845 1130247.1279 1175457.013 1222475.2936 1271374.3053 1322229.2775 1375118.4486 1430123.1866 1487328.114 1546821.2386 1608694.0881 1673041.8516 1739963.5257 1809562.0667 1881944.5494 1957222.3314 2035511.2246 2116931.6736 636503.04 661963.1616 712115.7489 777531.9137 829117.8815 883586.6758 946625.4455 1014733.7338 1086776.0845 1130247.1279 1175457.013 1222475.2936 1271374.3053 1322229.2775 1375118.4486 1430123.1866 1487328.114 1546821.2386 1608694.0881 1673041.8516 1739963.5257 1809562.0667 1881944.5494 1957222.3314 2035511.2246 2116931.6736 2201608.9406 2034 462 228 104 794 2034 794 163.5775 0 96 794096.64 153.6991 1271374.3053 1271374.3053 1035059.631 250609.19 1503028.131 235285.69 1487704.631 265047.03 161.6427 113.1499 147.7876 153.6991 163.5775 217359.31 2034 80233.45 151420.38 1025750.47 -477277.661023721 104233.46 112096.87 1010426.97 -477277.661 1271374.3053 1271374.3053 2021 2022 2023 2024 2025 2026 2027 2028 2029 2035 462 228 104 794 2035 794 168.4849 0 96 794096.64 159.8471 1322229.2775 1322229.2775 1066111.42 250609.19 1540079.92 235285.69 1524756.42 265047.03 168.1084 117.6759 153.6991 159.8471 168.4849 223359.31 2035 217850.645 1011947.285 -528132.634954432 202527.145 996623.785 -528132.635 1322229.2775 1322229.2775 CFC Earned 641300 510000 226000 339000 180800 180800 226000 237300 237300 2036 462 228 104 794 2036 794 173.5394 0 96 794096.64 166.2409 1375118.4486 1375118.4486 1098094.7626 250609.19 1579300.4426 235285.69 1563976.9426 265047.03 174.8327 122.3829 159.8471 166.2409 173.5394 230596.49 2036 204181.995 998278.635 -581021.807553065 188858.495 982955.135 -581021.8076 1375118.4486 1375118.4486 CFC Used 672792.14 580424.43 166588 3380411 182035 187496.05 193120.93 198914.56 217359.31 223359.31 230596.49 237514.39 2037 462 228 104 794 2037 794 178.7456 0 96 794096.64 172.8906 1430123.1866 1487328.114 1131037.6054 250609.19 1619161.1854 235285.69 1603837.6854 265047.03 181.826 127.2782 166.2409 172.8906 178.7456 237514.39 2037 131833.075 925929.715 -693231.470429657 116509.575 910606.215 -693231.4704 1487328.114 1487328.114 Remaining 641300 1151300 704507.86 2778500 2038 794 184.108 0 96 794096.64 179.8062 1487328.114 1487328.114 1164968.7336 250609.19 1415577.9236 235285.69 1400254.4236 265047.03 189.0991 132.3693 172.8906 179.8062 184.108 2038 794096.64 -621481.283592547 794096.64 -606157.7836 1487328.114 1487328.114 2039 794 189.6312 0 96 794096.64 186.9984 1546821.2386 1546821.2386 1199917.7956 250609.19 1450526.9856 235285.69 1435203.4856 265047.03 196.663 137.6641 179.8062 186.9984 189.6312 2039 794096.64 -656430.345600324 794096.64 -641106.8456 1546821.2386 1546821.2386 226000 55265 292565 105068.95 2040 794 195.3201 0 96 794096.64 194.4784 1608694.0881 1608694.0881 1235915.3295 250609.19 1746062.9095 235285.69 1730739.4095 265047.03 204.5296 143.1707 186.9984 194.4784 195.3201 259538.39 2040 137368.825 931465.465 -814597.444468333 122045.325 916141.965 -814597.4445 1608694.0881 1608694.0881 21&22&23 24 25 26 27 28 29 2041 794 201.1797 0 96 794096.64 202.2575 1673041.8516 1673041.8516 1272992.7894 250609.19 1790926.5211 235285.69 1775603.0211 265047.03 212.7107 148.8975 194.4784 202.2575 201.1797 267324.5417 2041 117884.67 911981.31 -878945.211052383 102561.17 896657.81 -878945.2111 1673041.8516 1673041.8516 1377300 -672792.14 704507.86 339000 1043507.86 -479065.2 564442.66 180800 745242.66 -18877.92 726364.74 180800 907164.74 -907164.74 0 226000 226000 -182035 43965 237300 281265 -187496.05 93768.95 237300 331068.95 -190681.91 140387.04 -140387.04 0 2042 794 207.2151 0 96 794096.64 210.3478 1739963.5257 1739963.5257 1311182.573 250609.19 1837136.041 235285.69 1821812.541 265047.03 221.2192 154.8534 202.2575 210.3478 207.2151 275344.278 2042 97172.52 891269.16 -945866.880983955 81849.02 875945.66 -945866.881 1739963.5257 1739963.5257 2023 2024 2025 2026 2028 2029 2030 2031 2043 794 213.4316 0 96 794096.64 218.7617 1809562.0667 1809562.0667 1350518.0502 250609.19 1884731.8465 235285.69 1869408.3465 265047.03 230.0679 161.0476 210.3478 218.7617 213.4316 283604.6063 2043 75169.78 869266.42 -1015465.42651347 59846.28 853942.92 -1015465.4265 1809562.0667 1809562.0667 641300 2044 794 219.8345 0 96 794096.64 227.5122 1881944.5494 1881944.5494 1391033.5917 1391033.5917 235285.69 1626319.2817 265047.03 239.2706 167.4895 218.7617 219.8345 2044 794096.64 -596936.951730662 794096.64 -832222.6417 1881944.5494 1881944.5494 510000 672792.14 672792.14 704507.86 2045 794 226.4296 0 96 794096.64 236.6127 1957222.3314 1957222.3314 1432764.5995 1432764.5995 235285.69 1668050.2895 265047.03 248.8415 174.189 227.5122 226.4296 2045 794096.64 -638667.959482582 794096.64 -873953.6495 1957222.3314 1957222.3314 226000 580424.43 580424.43 2046 794 233.2225 0 96 794096.64 246.0772 2035511.2246 2035511.2246 1475747.5375 1475747.5375 1475747.5375 265047.03 258.7951 181.1566 236.6127 233.2225 2046 794096.64 -681650.897467059 794096.64 -681650.8975 0 2047 794 240.2191 0 96 794096.64 255.9203 2116931.6736 2116931.6736 1520019.9636 1520019.9636 1520019.9636 265047.03 269.1469 188.4029 246.0772 240.2191 2047 794096.64 -725923.323591071 794096.64 -725923.3236 0 2048 794 247.4257 0 96 794096.64 266.1571 2201608.9406 2201608.9406 1565620.5625 1565620.5625 1565620.5625 279.9128 195.939 255.9203 247.4257 2048 794096.64 -771523.922498803 794096.64 -771523.9225 0 2999700 26271862.6301 22168786.391 10512435.88 40567645.697 10205965.88 40261175.697 3452.7662 2416.9363 3165.0434 3287.8051 3503.4848 0 7886423.4259 2999699.995 5334456.64 3461782.355 330000 2999700 5242515.645 3299870.845 330000 0 0 0 0 26271862.6301 26271862.6301 339000 166588 166588 2023 672792.14 2778500 672792.14 -0.005 180800 658095.43 658095.43 2024 479065.195 2999700 0.005 2943000 -56700 180800 2025 18877.92 2999700 2999699.995 4.99999988824129E-03 226000 182035 182035 2026 907164.74 237300 187496.05 187496.05 2027 237300 193120.93 193120.93 2028 182035 137948.02 139383.02 2029 187496.05 2030 190681.905 2031 137948.02