Loading...
HomeMy WebLinkAbout15-4, 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.24948 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.67) 3/1/2015 219,867.38 - 219,867.38 340,270.00 - (6,347.22) 333,922.78 (108,938.14) 9/1/2015 389,867.38 - 389,867.38 609,734.75 545,270.00 - (6,347.22) 538,922.78 872,845.57 (263,110.82) (139,405.80) 3/1/2016 216,254.88 - 216,254.88 335,042.50 - (6,347.22) 328,695.28 (102,973.28) 9/1/2016 411,254.88 - 411,254.88 627,509.75 565,042.50 - (6,347.22) 558,695.28 887,390.57 (259,880.82) (132,217.12) 3/1/2017 212,111.13 - 212,111.13 329,062.50 - (6,347.22) 322,715.28 (97,120.67) 9/1/2017 432,111.13 - 432,111.13 644,222.25 589,062.50 - (6,347.22) 582,715.28 905,430.57 (261,208.32) (129,492.97) 3/1/2018 207,436.13 - 207,436.13 322,172.50 - (6,347.22) 315,825.28 (91,256.57) 9/1/2018 555,836.13 - 555,836.13 763,272.25 612,172.50 - (6,347.22) 605,825.28 921,650.57 (158,378.32) (41,211.95) 3/1/2019 200,032.63 - 200,032.63 314,270.00 - (6,347.22) 307,922.78 (87,095.99) 9/1/2019 582,432.63 - 582,432.63 782,465.25 639,270.00 - (6,347.22) 632,922.78 940,845.57 (158,380.32) (39,910.96) 3/1/2020 191,906.63 - 191,906.63 305,170.00 - (6,347.22) 298,822.78 (82,755.67) 9/1/2020 612,406.63 - 612,406.63 804,313.25 670,170.00 - (6,347.22) 663,822.78 962,645.57 (158,332.32) (38,969.34) 3/1/2021 182,971.00 - 182,971.00 294,767.50 - (6,347.22) 288,420.28 (78,259.33) 9/1/2021 640,471.00 - 640,471.00 823,442.00 699,767.50 - (6,347.22) 693,420.28 981,840.57 (158,398.57) (38,478.81) 3/1/2022 173,249.13 - 173,249.13 282,820.00 - (6,347.22) 276,472.78 (73,453.05) 9/1/2022 671,349.13 - 671,349.13 844,598.25 732,820.00 - (6,347.22) 726,472.78 1,002,945.57 (158,347.32) (38,409.41) 3/1/2023 162,664.50 - 162,664.50 269,545.00 - (6,347.22) 263,197.78 (68,592.80) 9/1/2023 705,364.50 - 705,364.50 868,029.00 769,545.00 - (6,347.22) 763,197.78 1,026,395.57 (158,366.57) (38,638.08) 3/1/2024 151,132.13 - 151,132.13 254,545.00 - (6,347.22) 248,197.78 (63,499.79) 9/1/2024 736,932.13 - 736,932.13 888,064.25 804,545.00 - (6,347.22) 798,197.78 1,046,395.57 (158,331.32) (39,245.77) 3/1/2025 138,683.88 - 138,683.88 238,045.00 - (6,347.22) 231,697.78 (58,343.53) 9/1/2025 766,383.88 - 766,383.88 905,067.75 838,045.00 - (6,347.22) 831,697.78 1,063,395.57 (158,327.82) (40,116.17) 3/1/2026 125,345.25 - 125,345.25 220,045.00 - (6,347.22) 213,697.78 (53,137.59) 9/1/2026 798,645.25 - 798,645.25 923,990.50 875,045.00 - (6,347.22) 868,697.78 1,082,395.57 (158,405.07) (41,254.92) 3/1/2027 111,037.63 - 111,037.63 200,395.00 - (6,347.22) 194,047.78 (47,868.76) 9/1/2027 838,637.63 - 838,637.63 949,675.25 920,395.00 - (6,347.22) 914,047.78 1,108,095.57 (158,420.32) (42,581.39) 3/1/2028 95,576.13 - 95,576.13 178,795.00 - (6,347.22) 172,447.78 (42,503.55) 9/1/2028 875,976.13 - 875,976.13 971,552.25 963,795.00 - (6,347.22) 957,447.78 1,129,895.57 (158,343.32) (44,109.75) 3/1/2029 78,992.63 - 78,992.63 155,245.00 - (6,347.22) 148,897.78 (37,060.07) 9/1/2029 915,392.63 - 915,392.63 994,385.25 1,010,245.00 - (6,347.22) 1,003,897.78 1,152,795.57 (158,410.32) (45,944.62) 3/1/2030 61,219.13 - 61,219.13 129,167.50 - (6,347.22) 122,820.28 (31,312.95) 9/1/2030 961,019.13 - 961,019.13 1,022,238.25 1,064,167.50 - (6,347.22) 1,057,820.28 1,180,640.57 (158,402.32) (48,181.99) 3/1/2031 42,098.38 - 42,098.38 100,650.00 - (6,347.22) 94,302.78 (25,443.71) 9/1/2031 998,098.38 - 998,098.38 1,040,196.75 1,110,650.00 - (6,347.22) 1,104,302.78 1,198,605.57 (158,408.82) (50,685.62) 3/1/2032 21,783.38 - 21,783.38 69,845.00 - (6,347.22) 63,497.78 (19,493.84) 9/1/2032 1,046,883.38 - 1,046,883.38 1,068,666.75 1,169,845.00 - (6,347.22) 1,163,497.78 1,226,995.57 (158,328.82) (53,362.05) 3/1/2033- - - 36,295.00 - (6,347.22) 29,947.78 (13,418.81) 9/1/2033- - - - 1,226,295.00 - (1,275,790.39) (49,495.39) (19,547.60) 19,547.60 21,716.16 Totals 15,953,470.67 - 15,953,470.67 15,953,470.67 21,051,835.00 (434,770.00) (1,523,331.80) 19,093,733.20 19,093,733.20 (3,140,262.53) (2,201,059.77) Plus: Prior Issue Other Source of Funds- - Net Total (3,140,262.53) (2,201,059.77) Savings % New20.95%Savings % Prior18.96%Page 1 of 1ATTACHMENT 4