PPRF Common Debt Service Reserve Fund


Oct 31, 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,196,681     (Actual: $  32,429,512)
    Amount Over Funded:    $ 1,232,831
    Senior Lien Loans Outstanding:    $ 1,134,479,420
    Max Senior Lien Loan Revenue in 2021:   $ 130,310,861
    Senior Lien Bond Debt Service in 2021:   $ 119,507,806
    CDSR Fund Senior Loan Revenue Coverage:    23.9% (24.9%)
    CDSR Fund Senior Bond Debt Service Coverage:   26.1%   (27.1%)

Common Debt Service Reserve Calculation Methodology – Senior Lien Loans Only

Amount 2021 Loan % of 2021
Risk Group Reserved Revenue Loan Revenue
Group One – 0%
Govt Gross Receipts -0- 706,389 0.5%
State Gross Receipts -0- 5,852,588 4.5%
Total Group One -0- 6,558,977 5.0%
Group Two – 20%
Law Enforcement Fund 27,470 137,349 0.1%
Mill Levy 40,660 203,300 0.2%
General Obligation 6,671,214 33,356,069 25.6%
Gross Receipt 9,415,963 47,079,813 36.1%
Total Group Two 16,155,307 80,776,530 62.0%
Group Three – 35%
Fire Protection Fund 1,238,916 3,539,761 2.7%
Special Assessment 515,385 1,472,529 1.1%
Local Special Tax 2,850,218 8,143,480 6.2%
Net System Revenues 9,914,809 28,328,025 21.7%
Appropriation Loan 522,046 1,491,559 1.1%
Total Group Three 15,041,374 42,975,354 33.0%
Grand Total 31,196,681 130,310,861 100%

Senior Lien Loan Revenue ($millions):

2020   $129.6
2021   $130.3 2022   $119.6 2023   $109.6
2024   $  97.9 2025   $  97.0 2026   $  90.5
2027   $  86.3 2028   $  82.3 2029   $  83.1
2030   $  63.3 2031   $  57.3 2032   $  53.1
2033   $  50.4 2034   $  43.5 2035   $  40.9
2036   $  28.5 2037   $  21.4 2038   $  16.5
2039   $  13.2 2040   $    9.2 2041   $    7.9
2042   $    4.3 2043   $    3.8 2044   $    3.8
2045   $    2.8 2046   $    2.1 2047   $    0.2

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