PPRF Common Debt Service Reserve Fund


Jun 30, 2019

Calculated on the Total PPRF Senior Lien Loan Portfolio Revenues
Based on the Year in Which the Loan Revenue Amount is Greatest
Funds are Held by Trustee as Indentured Funds


Common Debt Service Reserve Funding Calculation:   $ 31,971,440     (Actual: $  32,200,000)
    Amount Over Funded:    $ 228,560
    Senior Lien Loans Outstanding:    $ 1,073,478,814
    Max Senior Lien Loan Revenue in 2020:   $ 130,921,677
    Senior Lien Bond Debt Service in 2020:   $ 121,176,872
    CDSR Fund Senior Loan Revenue Coverage:    24.4% (24.6%)
    CDSR Fund Senior Bond Debt Service Coverage:   26.4%   (26.6%)

Common Debt Service Reserve Calculation Methodology – Senior Lien Loans Only

Amount 2020 Loan % of 2020
Risk Group Reserved Revenue Loan Revenue
Group One – 0%
Govt Gross Receipts -0- 704,826 0.5%
State Gross Receipts -0- 6,072,565 4.6%
Total Group One -0- 6,777,391 5.2%
Group Two – 20%
Law Enforcement Fund 42,283 211,417 0.2%
Mill Levy 43,557 217,786 0.2%
General Obligation 5,865,824 29,329,121 22.4%
Gross Receipt 9,353,747 46,768,735 35.7%
Total Group Two 15,305,411 76,527,059 58.5%
Group Three – 35%
Fire Protection Fund 1,475,203 4,214,865 3.2%
Special Assessment 515,773 1,473,638 1.1%
Local Special Tax 3,238,879 9,253,939 7.1%
Net System Revenues 10,626,786 30,362,247 23.2%
Appropriation Loan 809,388 2,312,537 1.8%
Total Group Three 16,666,029 47,617,226 36.4%
Grand Total 31,971,440 130,921,677 100%

Senior Lien Loan Revenue ($millions):

2020   $130.9
2021   $124.0 2022   $115.4 2023   $108.3
2024   $  96.2 2025   $  93.2 2026   $  86.2
2027   $  82.0 2028   $  77.6 2029   $  77.8
2030   $  58.6 2031   $  54.0 2032   $  49.9
2033   $  48.0 2034   $  41.7 2035   $  39.4
2036   $  27.8 2037   $  18.5 2038   $  13.8
2039   $  10.4 2040   $    8.3 2041   $    7.1
2042   $    3.5 2043   $    2.9 2044   $    2.9
2045   $    2.8 2046   $    2.1 2047   $    0.1

CDSR Calculation – June 30, 2018
CDSR Calculation – June 30, 2017
CDSR Calculation – June 30, 2016
CDSR Calculation – June 30, 2015

CONTACT

Direct Comments, Requests or Questions to:
Michael Zavelle, Chief Financial Strategist NMFA, 505-992-9639, EMAIL