Loading...
HomeMy WebLinkAbout19-5, Attachment Old Greenwood Refunding ModelAttachment 5 Truckee Donner Public Utility District Special Tax Refunding Bonds, Series 2013 CFD No. 03-1, Old Greenwood Net Debt Service Schedule and Savings Calculation (Cash Flow NPV Basis) New Issue Reserve Fund 1,155,501.62 Prior Issue Reserve Fund 1,265,632.37 Investment Yield 1.00 Investment Yield 1.00 Net Net Prior Issue Less: Prior Issue Prior Issue Periodic Less: RF Periodic Annual Periodic Debt Service Less: RF Net Periodic Net Annual Annual 4.33085 Date Debt Service Earnings Debt Service Debt Service Debt Service Contribution Earnings Debt Service Debt Service (Savings) / Cost Present Value 7/2/2013 9/1/2013 503,490.00 (503,490.00) (6,328.16) (6,328.16) (6,328.16) 6,328.16 6,283.88 3/1/2014 244,458.75 (7,671.25) 236,787.50 344,770.00 (6,328.16) 338,441.84 (98,803.50) 9/1/2014 424,458.75 (5,777.51) 418,681.24 655,468.75 524,770.00 (6,328.16) 518,441.84 856,883.68 (201,414.93) (94,907.71) 3/1/2015 243,018.75 (5,777.51) 237,241.24 340,270.00 (6,328.16) 333,941.84 (90,046.67) 9/1/2015 418,018.75 (5,777.51) 412,241.24 649,482.48 545,270.00 (6,328.16) 538,941.84 872,883.68 (223,401.19) (115,481.72) 3/1/2016 241,312.50 (5,777.51) 235,534.99 335,042.50 (6,328.16) 328,714.34 (83,128.57) 9/1/2016 406,312.50 (5,777.51) 400,534.99 636,069.98 565,042.50 (6,328.16) 558,714.34 887,428.68 (251,358.69) (138,126.32) 3/1/2017 239,456.25 (5,777.51) 233,678.74 329,062.50 (6,328.16) 322,734.34 (76,117.40) 9/1/2017 574,456.25 (5,777.51) 568,678.74 802,357.48 589,062.50 (6,328.16) 582,734.34 905,468.68 (103,111.19) (11,758.94) 3/1/2018 235,017.50 (5,777.51) 229,239.99 322,172.50 (6,328.16) 315,844.34 (70,917.68) 9/1/2018 600,017.50 (5,777.51) 594,239.99 823,479.98 612,172.50 (6,328.16) 605,844.34 921,688.68 (98,208.69) (9,301.04) 3/1/2019 229,816.25 (5,777.51) 224,038.74 314,270.00 (6,328.16) 307,941.84 (65,824.10) 9/1/2019 619,816.25 (5,777.51) 614,038.74 838,077.48 639,270.00 (6,328.16) 632,941.84 940,883.68 (102,806.19) (14,515.63) 3/1/2020 223,673.75 (5,777.51) 217,896.24 305,170.00 (6,328.16) 298,841.84 (60,840.43) 9/1/2020 648,673.75 (5,777.51) 642,896.24 860,792.48 670,170.00 (6,328.16) 663,841.84 962,683.68 (101,891.19) (15,409.47) 3/1/2021 216,342.50 (5,777.51) 210,564.99 294,767.50 (6,328.16) 288,439.34 (56,077.10) 9/1/2021 676,342.50 (5,777.51) 670,564.99 881,129.98 699,767.50 (6,328.16) 693,439.34 981,878.68 (100,748.69) (16,122.63) 3/1/2022 207,947.50 (5,777.51) 202,169.99 282,820.00 (6,328.16) 276,491.84 (51,274.30) 9/1/2022 707,947.50 (5,777.51) 702,169.99 904,339.98 732,820.00 (6,328.16) 726,491.84 1,002,983.68 (98,643.69) (16,423.88) 3/1/2023 198,447.50 (5,777.51) 192,669.99 269,545.00 (6,328.16) 263,216.84 (46,628.66) 9/1/2023 738,447.50 (5,777.51) 732,669.99 925,339.98 769,545.00 (6,328.16) 763,216.84 1,026,433.68 (101,093.69) (19,762.31) 3/1/2024 187,647.50 (5,777.51) 181,869.99 254,545.00 (6,328.16) 248,216.84 (42,013.39) 9/1/2024 767,647.50 (5,777.51) 761,869.99 943,739.98 804,545.00 (6,328.16) 798,216.84 1,046,433.68 (102,693.69) (22,528.39) 3/1/2025 175,757.50 (5,777.51) 169,979.99 238,045.00 (6,328.16) 231,716.84 (37,454.50) 9/1/2025 800,757.50 (5,777.51) 794,979.99 964,959.98 838,045.00 (6,328.16) 831,716.84 1,063,433.68 (98,473.69) (21,815.11) 3/1/2026 162,632.50 (5,777.51) 156,854.99 220,045.00 (6,328.16) 213,716.84 (33,050.09) 9/1/2026 832,632.50 (5,777.51) 826,854.99 983,709.98 875,045.00 (6,328.16) 868,716.84 1,082,433.68 (98,723.69) (23,815.85) 3/1/2027 148,227.50 (5,777.51) 142,449.99 200,395.00 (6,328.16) 194,066.84 (28,743.21) 9/1/2027 868,227.50 (5,777.51) 862,449.99 1,004,899.98 920,395.00 (6,328.16) 914,066.84 1,108,133.68 (103,233.69) (28,133.99) 3/1/2028 132,387.50 (5,777.51) 126,609.99 178,795.00 (6,328.16) 172,466.84 (24,464.71) 9/1/2028 907,387.50 (5,777.51) 901,609.99 1,028,219.98 963,795.00 (6,328.16) 957,466.84 1,129,933.68 (101,713.69) (29,168.11) 3/1/2029 114,950.00 (5,777.51) 109,172.49 155,245.00 (6,328.16) 148,916.84 (20,314.37) 9/1/2029 949,950.00 (5,777.51) 944,172.49 1,053,344.98 1,010,245.00 (6,328.16) 1,003,916.84 1,152,833.68 (99,488.69) (29,889.65) 3/1/2030 95,118.75 (5,777.51) 89,341.24 129,167.50 (6,328.16) 122,839.34 (16,403.64) 9/1/2030 995,118.75 (5,777.51) 989,341.24 1,078,682.48 1,064,167.50 (6,328.16) 1,057,839.34 1,180,678.68 (101,996.19) (32,831.79) 3/1/2031 73,743.75 (5,777.51) 67,966.24 100,650.00 (6,328.16) 94,321.84 (12,364.74) 9/1/2031 1,033,743.75 (5,777.51) 1,027,966.24 1,095,932.48 1,110,650.00 (6,328.16) 1,104,321.84 1,198,643.68 (102,711.19) (35,063.00) 3/1/2032 50,943.75 (5,777.51) 45,166.24 69,845.00 (6,328.16) 63,516.84 (8,248.11) 9/1/2032 1,085,943.75 (5,777.51) 1,080,166.24 1,125,332.48 1,169,845.00 (6,328.16) 1,163,516.84 1,227,033.68 (101,701.19) (36,669.84) 3/1/2033 26,362.50 (5,777.51) 20,584.99 36,295.00 (6,328.16) 29,966.84 (4,040.03) 9/1/2033 1,136,362.50 (1,161,279.13) (24,916.63) (4,331.64) 1,226,295.00 (1,271,960.53) (45,665.53) (15,698.69) 11,367.06 8,745.56 Totals 18,639,525.00 (1,388,495.68) 17,251,029.32 17,251,029.32 21,555,325.00 (503,490.00) (1,525,087.01) 19,526,747.99 19,526,747.99 (2,275,718.68) (1,623,451.15) Plus: Prior Issue Other Source of Funds Net Total (2,275,718.68) (1,623,451.15) Savings % New 13.82 Page 1 of 1 Savings % Prior 13.80