What Is a City Debt Schedule and How Do You Build One?

What a city debt schedule actually tracks

A city debt schedule is a structured table that captures every outstanding debt instrument a municipality carries, along with its repayment terms over time. It serves three practical purposes: supporting annual budget planning, enabling ongoing debt service monitoring, and satisfying year-end financial disclosure requirements under GASB and state reporting rules. It is not the same as a bond prospectus or official statement. Those documents describe a debt at the moment of issuance; the debt schedule reflects the ongoing, living picture of what is still owed and when each payment lands.

The schedule connects directly to several other financial documents your office produces. It feeds the long-term debt note in the Annual Comprehensive Financial Report, supports the debt service line in the adopted budget, and provides the raw numbers behind any debt affordability schedule the city publishes. Auditors reference it, state comptrollers in many states require a formal version of it, and your finance team should be able to pull it up on demand rather than rebuilding it from scratch every audit season.

City debt schedule: fields to include

Every instrument on a well-built debt schedule should capture a core set of fields. Together, they answer distinct questions about the city's outstanding debt by year and its total exposure:

• Debt description or identifier, the loan name, project purpose, or issuing institution
• Debt type, general obligation bond, revenue bond, state revolving fund loan, lease, or line of credit
• Original principal, the face amount at issuance
• Outstanding opening balance, the city's current exposure at the start of the period
• Principal repayments by year, what retires annually
• Annual interest expense and interest rate, what this debt costs in the current fiscal year
• Maturity date, when the final payment lands
• Ending balance, the remaining obligation after each year's payment

Additional fields for bond-carrying cities

For cities that carry bond-style debt, the schedule needs additional fields. CUSIP numbers are commonly included for bonds and are often used in EMMA filings for continuing disclosure and investor reporting. Bond type, general obligation versus revenue, matters for debt limit calculations. Coupon rate and whether it is fixed or variable affects how you model future interest costs. Call provisions that allow early redemption are worth flagging because they create refinancing opportunities tied to a municipal bond schedule. Not every municipality carries bonds; smaller cities may carry only state loans or bank-financed capital notes. When bonds are present, these fields are non-negotiable for accurate reporting.

Primary sources

Start with the adopted budget packet or capital budget. Many cities publish a long-term debt schedule or debt service payment schedule as a supplemental table in the budget book. Next, check the Annual Comprehensive Financial Report. GASB standards require disclosure of aggregate maturities for all long-term borrowings for each of the five years following the balance sheet date, with five-year increments after that. The ACFR debt note is the most consistently formatted public disclosure most cities produce. Your city controller or comptroller's office is a third source; it often publishes a standalone annual city debt report on capital debt and obligations separate from the ACFR itself.

State and open data sources

A second tier of sources includes state-level reporting databases and open data portals. Some states, check your state comptroller's website, host Schedule of Debt datasets compiled from annual reports submitted under state law. Many cities also publish debt-related records through municipal open data portals. Practical search terms include "debt schedule," "debt service," "long-term debt," "bond," "capital debt," and "indebtedness." One important caveat: open data cadence varies. These datasets often refresh annually and may lag by six to twelve months after fiscal year-end, so they are useful for historical context but should not substitute for the internal schedule your team maintains.

How finance teams use the schedule for capital planning

An active debt schedule is not just a historical record. When a city is considering a new capital project that requires borrowing, the finance team consults the schedule to calculate current debt service as a percentage of revenues or assessed valuation. That ratio gets compared against the city's debt policy thresholds or the legal debt limits set by state statute. A clear, year-by-year view of principal and interest payments also reveals when capacity opens up as older debt retires, giving the team a defensible timeline for when new issuance is realistic.

Building a working city debt schedule your team can maintain

For a fixed-rate, fully amortizing loan, annual debt service equals the principal payment plus the interest payment. The standard column structure runs: Beginning Balance, Interest Expense, Principal Repayment, Total Debt Service, Ending Balance. Interest for each year is calculated on the beginning balance at the stated rate. The total annual payment is determined by the amortization schedule or the loan payment formula. Principal is the total payment minus interest. The ending balance is the beginning balance minus the principal repayment.

In Excel, three functions handle most of the math. PMT calculates the constant periodic payment; IPMT isolates the interest portion for a specific period; PPMT isolates the principal portion. For a 20-year, 5% loan of $10,000,000 with annual payments, the formulas look like this:

For cities with monthly loan payments that need an annual summary, set the rate to the annual rate divided by 12 and nper to years multiplied by 12, then sum the 12 monthly results for each calendar or fiscal year.

When a city carries multiple debt instruments, organize the schedule with one row block per instrument and consistent columns across all obligations. That consistency is what allows you to aggregate across the portfolio and produce a total debt service figure by year, which is what budget documents and council presentations actually need. The schedule should cover every obligation through its final maturity, not just the next five years, because capital planning decisions depend on seeing the full picture.

• Total annual payment: =PMT(5%,20,-10000000)
• Year 1 interest: =IPMT(5%,1,20,-10000000)
• Year 1 principal: =PMT(5%,20,-10000000)-IPMT(5%,1,20,-10000000)

Keeping the schedule defensible for council and audit

A debt schedule that lives in a shared spreadsheet with no version control and no reconciliation to the ERP is a liability, not an asset. The schedule should reconcile to the outstanding principal balances in your general ledger and to the debt service appropriations in the adopted budget. Any discrepancy between the schedule and either of those sources may lead to audit findings or require reconciliation during audit. Build in a reconciliation step at each year-end and any time new debt is issued or retired.

The audience for this document extends beyond the finance office. Council members vote on debt issuances and capital plans. Bond counsel and financial advisors rely on it when structuring new deals. Underwriters and rating agencies consult it when evaluating creditworthiness. The schedule needs to be complete, dated, and clearly labeled so that anyone picking it up can understand what it shows without needing a guided tour. If your schedule requires a conversation to interpret, it is not ready for public accountability.

A clearer debt picture starts with one well-maintained document

A well-maintained city debt schedule puts every obligation in plain view: what is owed, when it is due, and what it costs through final maturity. That clarity gives finance directors a defensible answer when a council member asks how much debt the city is carrying, when the next large payment hits, or whether there is room to borrow for the water main replacement. Without a current, complete schedule, those questions require hours of reconciliation and still leave room for error.