Assignment #2
PADM-GP 2144
Debt Financing & Management for Public Organizations
Fall 2025
Please submit one Excel file with your answers to the following questions marked in yellow. You must show all of your calculations, including the Excel formulas that were used to arrive at your answer. Submit your Excel file on the Brightspace platform. before midnight ET on Friday October 17, 2025.
Make a debt service table including a subset of the bond maturities from the NYU Series 2017A tax-exempt bond issue (shown below) that are either premium bonds or par bonds, including the serial and term bonds. This subset is NOT THE ENTIRE SERIES 2017A. Note that the dated date and delivery date for the Series 2017A is June 1, 2017.
Your Excel submission should state the par amount, coupon and yield of each maturity in this subset of the NYU Series 2017A bond series.
· Make sure to model the term bond with the mandatory sinking fund redemption schedule highlighted below.
· Make sure to take into account the call features of the bond as detailed in the optional redemption paragraph below.
· Calculate the price for each maturity in this subset of bonds and display it in a separate column in your debt service table.
· Calculate the total sale proceeds of each maturity in this subset and display in a separate column (par amount x price in % form. = total proceeds collected).
· Calculate the aggregate debt service on this subset of maturities for each semiannual payment.
Questions:
1. What is the total par amount of bonds identified in this subset of the Series 2017A?
2. What is the total production of the consolidated group of maturities in this subset? Reminder: production = par + premium – discount.
3. What is the total gross debt service over the life of the bond for this subset of maturities?
4. What is the blended yield (%) on this subset of the NYU Series 2017A bonds if you set the present value debt service to the total production?