Cost of Debt Calculator
Download our free cost of debt calculator
Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more. Start with a free account to explore 20+ always-free courses and hundreds of finance templates and cheat sheets.
Cost of Debt Calculator
This cost of debt calculator is used to calculate the annual yield to maturity of a company’s debt, otherwise known as its cost of debt or the interest rate. This calculator takes the following values for its inputs:
- bond face value
- bond price
- number of years to maturity
- coupon payment period (e.g. monthly, quarterly, etc.)
- coupon rate
Here is a preview of the cost of debt calculator:
Download the Free Template
Enter your name and email in the form below and download the free template now!
Estimating Cost of Debt
The cost of debt is the return provided to the debtholders and creditors of a company. These investors are given a return to compensate for the risk that comes with lending money.
Observable interest rates often contribute to quantifying cost of debt. Therefore, the cost of debt of a company reflects both its risk of default as well as the interest rates in the market. Additionally, it is also a component in calculating Weighted Average Cost of Capital (WACC).
There are two methods to calculating cost of debt:
- Calculating the yield to maturity (YTM) of a company’s debt
- Determining the cost of debt by referencing the credit rating of the firm
This cost of debt calculator uses the first calculation method. If a company is public, it can have observable debt in the market. We can look at the company’s bonds and use the values mentioned above to solve for the YTM of the bond. It is best to use this method when the company you are looking at has a simple capital structure. If it has a more complicated capital structure with multiple tranches of debt, there will be multiple differing interest rates.
More Free Templates
For more resources, check out our business templates library to download numerous free Excel modeling, PowerPoint presentation and Word document templates.
Analyst Certification FMVA® Program
Below is a break down of subject weightings in the FMVA® financial analyst program. As you can see there is a heavy focus on financial modeling, finance, Excel, business valuation, budgeting/forecasting, PowerPoint presentations, accounting and business strategy.
A well rounded financial analyst possesses all of the above skills!
Additional Questions & Answers
CFI is the global institution behind the financial modeling and valuation analyst FMVA® Designation. CFI is on a mission to enable anyone to be a great financial analyst and have a great career path. In order to help you advance your career, CFI has compiled many resources to assist you along the path.
In order to become a great financial analyst, here are some more questions and answers for you to discover:
- What is Financial Modeling?
- How Do You Build a DCF Model?
- What is Sensitivity Analysis?
- How Do You Value a Business?
