Loading...
HomeMy WebLinkAbout15-4 revised, Attachment Old Greenwood Summary Cash FlowTruckee Donner Public Utility DistrictSpecial Tax Refunding Bonds, Series 2014(CFD No. 03-1, Old Greenwood)Net Debt Service Schedule and Savings Calculation (Cash Flow NPV Basis)New Issue Reserve Fund - Prior Issue Reserve Fund 1,269,443.17 Investment Yield 1.00 Investment Yield 1.00 Net Net Prior Issue Less: Prior Issue Prior IssuePeriodic Less: RF Periodic Annual Periodic Debt Service Less: RF Net Periodic Net Annual Annual 4.24947 Date Debt Service Earnings Debt Service Debt Service Debt Service Contribution Earnings Debt Service Debt Service (Savings) / Cost Present Value1/28/20143/1/2014344,770.00 (434,770.00) (6,347.22) (96,347.22) 95,976.56 9/1/2014 422,046.92 - 422,046.92 422,046.92 524,770.00 - (6,347.22) 518,422.78 422,075.57 (28.65) (94,007.68) 3/1/2015 219,867.38 - 219,867.38 340,270.00 - (6,347.22) 333,922.78 (108,938.15) 9/1/2015 471,667.38 - 471,667.38 691,534.75 545,270.00 - (6,347.22) 538,922.78 872,845.57 (181,310.82) (62,901.41) 3/1/2016 214,516.63 - 214,516.63 335,042.50 - (6,347.22) 328,695.28 (104,565.20) 9/1/2016 491,516.63 - 491,516.63 706,033.25 565,042.50 - (6,347.22) 558,695.28 887,390.57 (181,357.32) (60,242.45) 3/1/2017 208,630.38 - 208,630.38 329,062.50 - (6,347.22) 322,715.28 (100,177.12) 9/1/2017 515,530.38 - 515,530.38 724,160.75 589,062.50 - (6,347.22) 582,715.28 905,430.57 (181,269.82) (57,767.17) 3/1/2018 202,108.75 - 202,108.75 322,172.50 - (6,347.22) 315,825.28 (95,741.90) 9/1/2018 538,208.75 - 538,208.75 740,317.50 612,172.50 - (6,347.22) 605,825.28 921,650.57 (181,333.07) (55,744.29) 3/1/2019 194,966.63 - 194,966.63 314,270.00 - (6,347.22) 307,922.78 (91,185.64) 9/1/2019 564,566.63 - 564,566.63 759,533.25 639,270.00 - (6,347.22) 632,922.78 940,845.57 (181,312.32) (54,033.52) 3/1/2020 187,112.63 - 187,112.63 305,170.00 - (6,347.22) 298,822.78 (86,466.39) 9/1/2020 594,212.63 - 594,212.63 781,325.25 670,170.00 - (6,347.22) 663,822.78 962,645.57 (181,320.32) (52,758.97) 3/1/2021 178,461.75 - 178,461.75 294,767.50 - (6,347.22) 288,420.28 (81,605.93) 9/1/2021 622,061.75 - 622,061.75 800,523.50 699,767.50 - (6,347.22) 693,420.28 981,840.57 (181,317.07) (51,857.04) 3/1/2022 169,035.25 - 169,035.25 282,820.00 - (6,347.22) 276,472.78 (76,451.66) 9/1/2022 652,635.25 - 652,635.25 821,670.50 732,820.00 - (6,347.22) 726,472.78 1,002,945.57 (181,275.07) (51,449.02) 3/1/2023 158,758.75 - 158,758.75 269,545.00 - (6,347.22) 263,197.78 (71,257.71) 9/1/2023 686,358.75 - 686,358.75 845,117.50 769,545.00 - (6,347.22) 763,197.78 1,026,395.57 (181,278.07) (51,335.75) 3/1/2024 147,547.25 - 147,547.25 254,545.00 - (6,347.22) 248,197.78 (65,845.06) 9/1/2024 717,547.25 - 717,547.25 865,094.50 804,545.00 - (6,347.22) 798,197.78 1,046,395.57 (181,301.07) (51,663.45) 3/1/2025 135,434.75 - 135,434.75 238,045.00 - (6,347.22) 231,697.78 (60,381.62) 9/1/2025 746,634.75 - 746,634.75 882,069.50 838,045.00 - (6,347.22) 831,697.78 1,063,395.57 (181,326.07) (52,246.25) 3/1/2026 122,446.75 - 122,446.75 220,045.00 - (6,347.22) 213,697.78 (54,880.89) 9/1/2026 778,646.75 - 778,646.75 901,093.50 875,045.00 - (6,347.22) 868,697.78 1,082,395.57 (181,302.07) (53,032.38) 3/1/2027 108,502.50 - 108,502.50 200,395.00 - (6,347.22) 194,047.78 (49,330.73) 9/1/2027 818,302.50 - 818,302.50 926,805.00 920,395.00 - (6,347.22) 914,047.78 1,108,095.57 (181,290.57) (54,063.97) 3/1/2028 93,419.25 - 93,419.25 178,795.00 - (6,347.22) 172,447.78 (43,696.18) 9/1/2028 855,119.25 - 855,119.25 948,538.50 963,795.00 - (6,347.22) 957,447.78 1,129,895.57 (181,357.07) (55,401.99) 3/1/2029 77,233.13 - 77,233.13 155,245.00 - (6,347.22) 148,897.78 (37,992.92) 9/1/2029 894,233.13 - 894,233.13 971,466.25 1,010,245.00 - (6,347.22) 1,003,897.78 1,152,795.57 (181,329.32) (56,928.98) 3/1/2030 59,871.88 - 59,871.88 129,167.50 - (6,347.22) 122,820.28 (31,997.83) 9/1/2030 939,471.88 - 939,471.88 999,343.75 1,064,167.50 - (6,347.22) 1,057,820.28 1,180,640.57 (181,296.82) (58,907.05) 3/1/2031 41,180.38 - 41,180.38 100,650.00 - (6,347.22) 94,302.78 (25,891.17) 9/1/2031 976,080.38 - 976,080.38 1,017,260.75 1,110,650.00 - (6,347.22) 1,104,302.78 1,198,605.57 (181,344.82) (61,193.72) 3/1/2032 21,313.75 - 21,313.75 69,845.00 - (6,347.22) 63,497.78 (19,713.34) 9/1/2032 1,024,313.75 - 1,024,313.75 1,045,627.50 1,169,845.00 - (6,347.22) 1,163,497.78 1,226,995.57 (181,368.07) (63,689.89) 3/1/2033 - - - 36,295.00 - (6,347.22) 29,947.78 (13,418.83) 9/1/2033 - - - - 1,226,295.00 - (1,275,790.39) (49,495.39) (19,547.60) 19,547.60 21,716.20 Totals 15,849,562.42 - 15,849,562.42 15,849,562.42 21,051,835.00 (434,770.00) (1,523,331.80) 19,093,733.20 19,093,733.20 (3,244,170.78) (2,201,070.51) Plus: Prior Issue Other Source of Funds- - Net Total (3,244,170.78) (2,201,070.51) Savings % New20.95%Savings % Prior18.96%REVISED ATTACHMENT 4