
Debt Schedule models
What is a Debt Schedule?
A debt schedule is made to lay out the debt that a business has accrued based on its maturity. A debt schedule is commonly used by businesses to build a cash flow analysis. In the debt schedule, interest expense flows into the income statement.
The total of closing debt balances also flows into the balance sheet. The debt schedule is a supporting schedule, and it is one of the schedules that ties together the three financial statements.
Components of a Debt Schedule in a Financial Model
Most of the time, an analyst will have to build a supporting schedule that outlines interest and debt when they are building a financial model in Excel.
A debt schedule is made up of:
-Opening balance
-Draws
-Repayments
-Interest Expense
-Closing balance
These components allow tracking of the debt until maturity. From the schedule, the closing balance flows back to the balance sheet, and the interest expense flows to the income statement.
Type of Debt is Listed in a Debt Schedule
All debt that is currently owed by a business must be included in the debt schedule. The types of debt included are:
- Leases
- Loans
- Debentures
- Bonds
Things to be Considered in the Construction of a Debt Schedule
Before deciding to go ahead and borrow money, it’s important that the company carefully considers whether or not it is able to repay debt, as well as evaluating the real cost of the debt. Companies need to consider the following factors:
- Debt maturity – The majority of debt is paid monthly and amortized. The longer the maturity of the debt is, the less amount of money is due monthly, but the higher the interest accrued and the total sum of the debt.
- Interest rate – Usually, the lower the interest rate is, the better. For a long-term debt, a low interest rate generally results in a higher interest than a short term debt with the high interest rate. It’s the investor that will need to calculate the total interest.
- Floating or fixed interest – The overall debt amount will be changed each year if there is a floating interest rate, whilst you will have a reliable calculation if there is a fixed interest rate. It depends on the future assumption, but generally a floating interest rate is the better option in a declining or low interest rate environment.
- Ability to generate gain – If the debtor is not able to pay the debt off via a steady stream of income for example, then there is no reason to take on new debt. If you cannot pay off your debt, it may result in a loss of trust and forced liquidation.
Why is a Debt Schedule Important?
Usually a debt schedule is made because once a debt matures, it’s useful to be able to estimate the total amount of money that a company has to pay. A debt schedule is also used so that the company can monitor the maturity of the debt, which is then used to make decisions. An example of a decision made based on debt maturity would be considering the refinancing of debt through a different source or institution when the interest rate declines.
As well as this, the debt schedule report is able to be used to negotiate a new line of credit for the business. Lenders will consider the balance between risk and reward using the report before they grant a new credit.
If you'd like to read more about Debt Schedules, visit:]
Most popular models
- Powerful, highly customization and free debt calculations module.1,712Discussadd_shopping_cart$19.00
by Alex Martyanov
Debt/Loan Refinancing Analysis Excel Tool
User-friendly Excel tool to calculate financial impacts of refinancing a portfolio of debt/loan facilities889Discussadd_shopping_cart$35.00by Projectify
Lender Business Model (UNLOCKED)
Enables Lender or Creditor to compute loan originations, payouts, and loan sales. Displays up to 4 borrower profiles.420Discussadd_shopping_cart$54.00by ExcelModels
Debt Capacity Calculator Excel Model
Learn how to compute Debt Capacity622Discussadd_shopping_cart$9.00by Alexander Jarvis
Debt/Loan Analysis Excel Template Bundle
Debt/Loan analysis model bundle combining 3 templates at a 25% discount compared to their separate list prices104Discussadd_shopping_cart$50.00by Projectify
Excel Calculator: Full Loan Pay Off or Invest it All
Compare the effects of paying off all your loans right away or using that money to invest with.250Discussadd_shopping_cart$20.00by Jason Varner
Small Business Cash Flow Model
A daily cash flow model for small businesses, in Microsoft Excel.80Discussadd_shopping_cart$19.00by Wesley Kennedy
Enhanced Debt/Loan Refinancing Analysis Excel Tool
User-friendly Excel tool to calculate financial impacts of refinancing a portfolio of debt/loan facilities39Discussadd_shopping_cart$40.00by Projectify
Mortgage payment Excel Calculator
Flexible, simple mortgage calculator in Excel/Spreadsheet186Discussadd_shopping_cart$25.00by ModellingGuy
Total Debt/Loan Composition Analysis Excel Tool
Highly versatile Excel tool for analysing composition of debt facilities & finacial impact of changes to facilities328Discussadd_shopping_cart$35.00by Projectify
Multiple Debt Calculator Model
Calculate your debt schedule for all of your loans at once87Discussadd_shopping_cartfreeby AZ Finserv
Cash Flow Excel Model with Monthly P&L, Balance Sheet, CF Statement, Scenarios, DCF, Capital and Debt Structure
An extended Excel version of a Cash Flow financial model with a free video tutorial.8,242Discussadd_shopping_cartfreeby Jacek Polewski
Loan Amortization Schedule Calculator
Simple and effective tool for debt scheduling and loan amortization426Discussadd_shopping_cartDebt Rating Costs Schedule - Excel Model Template
This is an Excel template of a Debt Rating Costs Schedule152Discussadd_shopping_cartfreeby Wall Street Oasis
Lender Business Model (DEMO)
Enables Lender or Creditor to compute loan originations, payouts, and loan sales. Displays up to 4 borrower profiles.618Discussadd_shopping_cartfreeby ExcelModels
Adjusted Present Value for Optimizing Debt
Estimate an "optimal" Capital Structure for a company using the Adjusted Present Value Approach.464Discussadd_shopping_cartfreeby Aswath Damodaran
priced models
Powerful and Customizable Debt Module Excel Model
Powerful, highly customization and free debt calculations module.1,712Discussadd_shopping_cart$19.00by Alex Martyanov
Debt/Loan Refinancing Analysis Excel Tool
User-friendly Excel tool to calculate financial impacts of refinancing a portfolio of debt/loan facilities889Discussadd_shopping_cart$35.00by Projectify
Mortgage payment Excel Calculator
Flexible, simple mortgage calculator in Excel/Spreadsheet186Discussadd_shopping_cart$25.00by ModellingGuy
Total Debt/Loan Composition Analysis Excel Tool
Highly versatile Excel tool for analysing composition of debt facilities & finacial impact of changes to facilities328Discussadd_shopping_cart$35.00by Projectify
Debt Capacity Calculator Excel Model
Learn how to compute Debt Capacity622Discussadd_shopping_cart$9.00by Alexander Jarvis
Lender Business Model (UNLOCKED)
Enables Lender or Creditor to compute loan originations, payouts, and loan sales. Displays up to 4 borrower profiles.420Discussadd_shopping_cart$54.00by ExcelModels
Debt/Loan Analysis Excel Template Bundle
Debt/Loan analysis model bundle combining 3 templates at a 25% discount compared to their separate list prices104Discussadd_shopping_cart$50.00by Projectify
Excel Calculator: Full Loan Pay Off or Invest it All
Compare the effects of paying off all your loans right away or using that money to invest with.250Discussadd_shopping_cart$20.00by Jason Varner
Small Business Cash Flow Model
A daily cash flow model for small businesses, in Microsoft Excel.80Discussadd_shopping_cart$19.00by Wesley Kennedy
Enhanced Debt/Loan Refinancing Analysis Excel Tool
User-friendly Excel tool to calculate financial impacts of refinancing a portfolio of debt/loan facilities39Discussadd_shopping_cart$40.00by Projectify
Loan Amortization Schedule Excel Spreadsheet
Manage Your Loan Payments Yourself, With This Simple Spreadsheet.340Discussadd_shopping_cart$19.00by Jatin Goel
Credit Control & Debt Recovery Procedures
A Word Document outlining Best Practices for Credit Control & Debt Recovery.20Discussadd_shopping_cart$20.00by ECF Consultancy
Ultimate fixed-rate mortgage payoff calculator | Model extra payments monthly/yearly/lump-sum
A Fixed-Rate Mortgage PayOff Calculator in Microsoft Excel.12Discussadd_shopping_cart$10.00by Last Mile Publishing
Newly published
Enhanced Debt/Loan Refinancing Analysis Excel Tool
User-friendly Excel tool to calculate financial impacts of refinancing a portfolio of debt/loan facilities39Discussadd_shopping_cart$40.00by Projectify
Ultimate fixed-rate mortgage payoff calculator | Model extra payments monthly/yearly/lump-sum
A Fixed-Rate Mortgage PayOff Calculator in Microsoft Excel.12Discussadd_shopping_cart$10.00by Last Mile Publishing
Cash Flow Excel Model with Monthly P&L, Balance Sheet, CF Statement, Scenarios, DCF, Capital and Debt Structure
An extended Excel version of a Cash Flow financial model with a free video tutorial.8,242Discussadd_shopping_cartfreeby Jacek Polewski
Credit Control & Debt Recovery Procedures
A Word Document outlining Best Practices for Credit Control & Debt Recovery.20Discussadd_shopping_cart$20.00by ECF Consultancy
Multiple Debt Calculator Model
Calculate your debt schedule for all of your loans at once87Discussadd_shopping_cartfreeby AZ Finserv
Lender Business Model (UNLOCKED)
Enables Lender or Creditor to compute loan originations, payouts, and loan sales. Displays up to 4 borrower profiles.420Discussadd_shopping_cart$54.00by ExcelModels
Loan Amortization Schedule Excel Spreadsheet
Manage Your Loan Payments Yourself, With This Simple Spreadsheet.340Discussadd_shopping_cart$19.00by Jatin Goel
Amortised Debt Repayment Schedule Calculator
Calculate the Amortisation Schedule of a mortgage or consumer loan, either at fixed or variable interest rate or both.132Discussadd_shopping_cartSmall Business Cash Flow Model
A daily cash flow model for small businesses, in Microsoft Excel.80Discussadd_shopping_cart$19.00by Wesley Kennedy
Debt Servicing Tool with Moratorium Period Option
The tool calculates debt servicing based on term, interest, payment frequency, moratorium.111Discussadd_shopping_cartLender Business Model (DEMO)
Enables Lender or Creditor to compute loan originations, payouts, and loan sales. Displays up to 4 borrower profiles.618Discussadd_shopping_cartfreeby ExcelModels
Modeling different principal debt repayment methods
This Excel file runs through five methods for modelling debt principal repayment430Discussadd_shopping_cartfreeby FinExMod
Debt Service Reserve Account (Manual & Excel Template)
Free Excel template and detailed manual covering the concept and structure of Debt Service Reserve Account.341Discussadd_shopping_cartfreeby FinExMod
Project Finance Debt Metrics (Manual and Template)
This manual and workbook are designed to help you build metrics required by lenders for project finance transactions.378Discussadd_shopping_cartfreeby FinExMod
Debt Schedule - Excel Model Template
This is an Excel debt schedule template for recording interest and debt payments for your company.526Discussadd_shopping_cartfreeby Wall Street Oasis
Interest Payments - Excel Model Template
This is an Interest Payments model Excel template141Discussadd_shopping_cartfreeby Wall Street Oasis
Full catalog
Amortization Schedule - Excel Model Template
This is WSO's free Amortization Schedule template for calculating debt repayments and loan amortization729Discussadd_shopping_cartfreeby Wall Street Oasis
Powerful and Customizable Debt Module Excel Model
Powerful, highly customization and free debt calculations module.1,712Discussadd_shopping_cart$19.00by Alex Martyanov
Debt Servicing Tool with Moratorium Period Option
The tool calculates debt servicing based on term, interest, payment frequency, moratorium.111Discussadd_shopping_cartDebt/Loan Refinancing Analysis Excel Tool
User-friendly Excel tool to calculate financial impacts of refinancing a portfolio of debt/loan facilities889Discussadd_shopping_cart$35.00by Projectify
Multiple Debt Calculator Model
Calculate your debt schedule for all of your loans at once87Discussadd_shopping_cartfreeby AZ Finserv
Convertible Loan Note: Guidance for Startup Founders
The accelerator program's standard template for CLN163Discussadd_shopping_cartfreeby SOSV
Interest Payments - Excel Model Template
This is an Interest Payments model Excel template141Discussadd_shopping_cartfreeby Wall Street Oasis
Mortgage payment Excel Calculator
Flexible, simple mortgage calculator in Excel/Spreadsheet186Discussadd_shopping_cart$25.00by ModellingGuy
Total Debt/Loan Composition Analysis Excel Tool
Highly versatile Excel tool for analysing composition of debt facilities & finacial impact of changes to facilities328Discussadd_shopping_cart$35.00by Projectify
Adjusted Present Value for Optimizing Debt
Estimate an "optimal" Capital Structure for a company using the Adjusted Present Value Approach.464Discussadd_shopping_cartfreeby Aswath Damodaran
Synthetic Rating & Cost of Debt
Allows you to estimate a rating and a cost of debt for your company from the firm's interest coverage ratio1,430Discussadd_shopping_cartfreeby Aswath Damodaran
Betas and Leverage
Obtain a table of betas at different debt ratios1,749Discussadd_shopping_cartfreeby Aswath Damodaran
Loan Amortization Schedule in Excel
A loan amortization schedule template along with step-by-step instructions.578Discussadd_shopping_cartDebt Modeling Workbook (Training)
Train yourself at generating loan schedules for personal loans1,708Discussadd_shopping_cartfreeby Lance Rubin
Modeling different principal debt repayment methods
This Excel file runs through five methods for modelling debt principal repayment430Discussadd_shopping_cartfreeby FinExMod
Design debt (by looking at sensitivity to macro variables)
Allows you to estimate the duration of a firm's assets and its sensitivity to other macro economic variables453Discussadd_shopping_cartfreeby Aswath Damodaran
- Have a Debt Schedule Financial Model to share?
Your Debt Schedule Financial Model
Publish a model
Learn more about digital publishing
Related categories
Corporate Finance
Loan Amortization
Amortization & Depreciation Schedule
Raising Capital
Project Finance Models
Cash Flow
Bank Financial Models
Valuation Models
Investment Banking
Financial Modeling
Software-as-a-Service (SaaS)
Startup Financial Models
Shareholder Agreements
Industry Specific Financial Models
Sensitivity Analysis
Leveraged Buyout (LBO)
Macroeconomics
Personal Finance
Stock Valuation
Coronavirus (COVID-19)