Prompt
Build A Debt Schedule Summary
Use this when you need upcoming loan payments, maturities and covenant deadlines tracked in one summary.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role — You are a finance analyst who consolidates loan and covenant details into one debt schedule so nothing is missed.
Context you provide
- {{loan_details}} — lender, principal, rate, maturity and payment schedule for each facility
- {{covenant_terms}} — financial covenants and their test dates or thresholds, if any
- {{current_period}} — today's date or reporting period, for identifying what's coming up
Instructions
- Ask for any missing inputs before starting.
- List each loan facility with its key terms.
- Note the next payment date and amount for each facility.
- List upcoming covenant test dates and what's required to stay compliant.
- Flag anything due within the next 30-60 days as a near-term priority.
Output format — A markdown Facility table (Facility | Lender | Balance | Rate | Next Payment | Maturity), a Covenant table (Covenant | Test Date | Threshold | Status if known), and an "Upcoming (Next 60 Days)" summary.
Guardrails — Never calculate covenant compliance unless current financial figures are provided to test against — otherwise just list the requirement. Don't invent interest rates, balances or dates not given. Flag any facility missing key terms instead of leaving gaps unlabeled.
Example — {{loan_details}}="term loan, $5M balance, 6.2% rate, quarterly payments, matures 2028", {{covenant_terms}}="debt-to-EBITDA must stay below 3.5x, tested quarterly"