Instructions
  • From the dropdown menu, pick the fund you want to display on the table.
  • Click on the buttons next to the table to export the payments or the bonds to a specific file format.
  • Hover over the "HELP" next to each option to learn more about the options.
  
Notes
  • Data sources: The most recent CAFR.
  • We assume that all bonds issue biannual coupon payments, any bond with an issue date in July or after pays two coupons in its terminal year.
  • We do not account for variable coupons: we use the first coupon rate for the entirety of the issue. As of 2018, only 13 issues had variable coupon rates.
  • A very small number of the dates may be inaccurate; their dates changed between 2017 and 2018, and we were not able to definitively determine the correct values.
  • Although most eligible bonds have been refinanced, it may be possible that interest payments will change as the county refinances its debt.


New Bond Options:

Help Select the fund to which the bond is being issued. The "general" fund is for county infrastructure and capital expenditures (parks, transportation, buildings, etc.). The "school" fund is for expenditures related to school construction and other school capital projects. "Utility" are for projects related to utilities. "IDA Revenue" bonds are bonds issued to finance revenue-producing projects such as housing construction.


Help Pick the year in which the bond is issued.

Issue Year:

Help This is the "interest rate" on the bonds. A bond with a five percent coupon pays five percent of the face value each year (usually in two payments).

Coupon Rate (Interest Payments): %

Help This is the amount of principle paid over the life of the bond. We assume that the principle is paid in even installments; so if a $250 bond were paid out over five-years, the principle would be split into five $50 payments.

Face Value: $

Help How long the bond lasts. A 30-year bond is paid back over the subsequent 30 years (assuming no delay).

Number of Years to Maturity:

Help Most bond issues begin with principle payments in the first year; however, it's there's not necessarily a reason a bond has to be structured to start payments immediately. We allow you to delay the payments until later in the life of the bond. Note: if the delay is as long or longer than the actual bond, we assume a single principle payment at the end.

Years of Delay Until First Redemption:

Help (OPTIONAL): The only thing this value is used for is computing the auction price of the bond (excluding any fees). Typically, if the coupon rate or the amount of interest paid is higher than the yield, the bond will sell for more money because people want bonds that pay extra interest. For example: a $1 million, 1-year bond that pays a coupon of 5 percent (or $50,000 in interest payments) would sell for $1,009,615 at auction. Changing the yield does not affect the interest payments or the principle payments, however, it does change the amount of money the county would get from issuing a bond.

Current Yield: %

Help Creating a new bond? Give it a bond ID number. Click the "Add New Bond" below, and your bond is "issued". Click that button again with the same bond ID number, and it is removed. That way if you make a mistake, you can delete the bond.



Debt Service Costs:



New Bonds: