SLIDE 7 RBC Capital Markets / Public Financial Management 6 | Avon Grove School District
Hypothetical Financing Plan to Generate $127 Million of Project Funds
Series 2019 Series 2020 Series 2021 Series 2022 Less: Total Net $23,765,000 $33,495,000 $33,535,000 $30,625,000 Interest Total Value of Total Total Budget Outstanding Par Amount Par Amount Par Amount Par Amount Earnings/ Net 1 Mill Mills New Mills in Dollars Surplus Date D/S (1) Debt Service (2) Debt Service (3) Debt Service (4) Debt Service (5) SD Reserves Debt (6) Required Mills Place Appropriated (Deficit) (7) 2015 4,573,814 4,573,814 1,845,000 2.48 0.000 2.44 4,499,955
2016 3,693,812 3,693,812 1,845,000 2.00 0.000 2.44 4,499,955 806,143 2017 2,935,443 2,935,443 1,845,000 1.59 0.000 2.44 4,499,955 1,564,512 2018 2,933,412 2,933,412 1,845,000 1.59 0.000 2.44 4,499,955 1,566,543 2019 2,932,952 2,932,952 1,850,000 1.59 0.580 3.02 5,585,150 2,652,198 2020 2,929,840 1,050,651 3,980,491 1,850,000 2.15 0.580 3.60 6,658,150 2,677,659 2021 2,938,207 1,146,165 1,446,825 5,531,198 1,850,000 2.99 0.580 4.18 7,731,150 2,199,952 2022 2,253,260 1,146,165 1,578,355 1,814,669 6,792,449 1,850,000 3.67 0.570 4.75 8,785,650 1,993,201 2023 920,703 1,400,965 2,568,155 2,521,105 2,419,118 9,830,046 1,850,000 5.31 0.570 5.32 9,840,150 10,104 2024 713,368 1,608,325 2,571,680 2,516,028 2,418,243 9,827,643 1,850,000 5.31 0.000 5.32 9,840,150 12,508 2025 709,554 1,612,760 2,567,855 2,518,550 2,420,130 9,828,849 1,850,000 5.31 0.000 5.32 9,840,150 11,301 2026 709,975 1,610,880 2,571,265 2,518,375 2,419,290 9,829,785 1,850,000 5.31 0.000 5.32 9,840,150 10,365 2027 714,503 1,602,938 2,576,838 2,515,675 2,420,813 9,830,765 1,850,000 5.31 0.000 5.32 9,840,150 9,385 2028 713,284 1,607,750 2,572,350 2,513,250 2,422,350 9,828,984 1,850,000 5.31 0.000 5.32 9,840,150 11,166 2029 2,319,125 2,571,750 2,515,125 2,422,875 9,828,875 1,850,000 5.31 0.000 5.32 9,840,150 11,275 2030 2,322,125 2,572,125 2,513,375 2,419,625 9,827,250 1,850,000 5.31 0.000 5.32 9,840,150 12,900 2031 2,321,625 2,569,250 2,518,375 2,418,250 9,827,500 1,850,000 5.31 0.000 5.32 9,840,150 12,650 2032 2,317,625 2,572,875 2,519,875 2,418,500 9,828,875 1,850,000 5.31 0.000 5.32 9,840,150 11,275 2033 2,319,875 2,572,750 2,517,875 2,420,125 9,830,625 1,850,000 5.31 0.000 5.32 9,840,150 9,525 2034 2,318,125 2,573,750 2,517,250 2,422,875 9,832,000 1,850,000 5.31 0.000 5.32 9,840,150 8,150 2035 2,317,250 2,575,625 2,517,750 2,421,625 9,832,250 1,850,000 5.31 0.000 5.32 9,840,150 7,900 2036 2,321,875 2,568,375 2,519,125 2,421,250 9,830,625 1,850,000 5.31 0.000 5.32 9,840,150 9,525 2037 2,321,750 2,571,750 2,516,250 2,421,500 9,831,250 1,850,000 5.31 0.000 5.32 9,840,150 8,900 2038 2,316,875 2,575,250 2,514,000 2,422,125 9,828,250 1,850,000 5.31 0.000 5.32 9,840,150 11,900 2039 2,317,000 2,573,750 2,517,000 2,422,875 9,830,625 1,850,000 5.31 0.000 5.32 9,840,150 9,525 2040 2,321,625 2,572,125 2,515,000 2,418,625 9,827,375 1,850,000 5.31 0.000 5.32 9,840,150 12,775 2041 3,501,250 3,907,125 2,419,125 9,827,500 1,850,000 5.31 0.000 5.32 9,840,150 12,650 2042 3,485,000 3,925,750 2,419,000 9,829,750 1,850,000 5.31 0.000 5.32 9,840,150 10,400 2043 1,850,000 0.00 0.000 5.32 9,840,150 9,840,150 2044 1,850,000 0.00 0.000 5.32 9,840,150 9,840,150 TOTAL 29,672,125 40,621,474 56,308,948 54,951,527 48,408,318 229,962,392 2.880
(1) Annual Net Debt Service for Series of 2012, 2012A, 2014, and 2015 Bonds. (2) Proposed Series of 2019, $23,765,000 dated June 1, 2019. Average Coupon 4.93%, Yield 3.87% (current rates + 75bps). Local Effort 100%. Project fund deposit = $25MM. (3) Proposed Series of 2020, $33,495,000 dated June 1, 2020. Average Coupon 4.90%, Yield 3.90% (current rates + 75bps). Local Effort 100%. Project fund deposit = $35MM. (4) Proposed Series of 2021, $33,535,000 dated June 1, 2021. Average Coupon 4.92%, Yield 3.92% (current rates + 75bps). Local Effort 100%. Project fund deposit = $35MM. (5) Proposed Series of 2022, $30,625,000 dated March 1, 2022. Average Coupon 4.92%, Yield 3.92% (current rates + 75bps). Local Effort 100%. Project fund deposit = $32MM. (6) FY2018-19 collect mill is worth $1,850,000 and it remains constant (per the administration January 2018) (7) Budget surplus (about $13.5MM) will be transferred to capital reserve to use for phasing in mills for the projects.