Advanced Cost of Debt Calculator
Example Data Table
| Case | Interest Expense | Market Price | Tax Rate | Approximate Result |
|---|---|---|---|---|
| Stable company bond | 48,000 | 940,000 | 25% | After tax cost near 4% to 5% |
| Discount debt issue | 65,000 | 900,000 | 28% | Higher pretax yield |
| Low risk refinancing | 32,000 | 985,000 | 21% | Lower after tax cost |
Formula Used
Average Debt = (Opening Debt + Closing Debt) / 2
Simple Pretax Cost of Debt = Interest Expense / Average Debt
Net Proceeds = Market Price × (1 − Issue Cost Rate)
Current Yield = Annual Coupon / Market Price
Approximate Yield to Maturity = [Annual Coupon + ((Face Value − Net Proceeds) / Years)] / [(Face Value + Net Proceeds) / 2]
After Tax Cost of Debt = Pretax Cost of Debt × (1 − Tax Rate)
Weighted After Tax Debt Cost = After Tax Cost of Debt × Debt Weight
Annual Tax Shield = Interest Expense × Tax Rate
How to Use This Calculator
- Enter annual interest expense from the income statement.
- Add opening and closing debt balances.
- Enter coupon payment, face value, market price, and issue costs.
- Add years to maturity for bond style debt.
- Enter the tax rate to calculate after tax cost.
- Enter debt weight for capital structure analysis.
- Press the calculate button.
- Download the result as CSV or PDF.
Cost of Debt Formula Guide
What Cost of Debt Means
Cost of debt measures the rate a business pays for borrowed money. It is a key part of capital budgeting. It also supports valuation, refinancing, and project review. The rate can be measured before tax or after tax. The after tax version is often more useful. Interest expense normally reduces taxable income. This tax shield lowers the real cost to the company.
Why the Formula Matters
A lender quotes one rate. A bond may trade at another rate. Accounting records may show a third rate. This calculator joins those views. It uses interest expense for a simple accounting estimate. It also uses coupon, market price, fees, and maturity. That gives an approximate yield to maturity. The result is helpful when debt trades above or below face value.
Pretax and After Tax Review
Pretax cost shows the financing rate before tax benefits. After tax cost adjusts that rate for deductible interest. A higher tax rate usually lowers the after tax cost. This does not mean more debt is always better. Debt adds fixed payments and financial risk. Managers should compare the cost with cash flow stability. They should also review covenants and refinancing risk.
Use in Capital Structure
Cost of debt is used inside weighted average cost of capital. The calculator includes a debt weight field. This shows the weighted debt contribution. Equity cost would be added separately. Together, these pieces help estimate a hurdle rate. The hurdle rate supports investment decisions. Projects should normally earn more than that rate.
Practical Notes
Use current market values when possible. Book values may be easier to find. Still, market values often give better decision data. Include issue costs for new borrowing. Fees reduce net proceeds. Lower proceeds increase the effective borrowing cost. For complex bonds, callable debt, or floating rates, use this tool as an estimate. Then compare results with lender quotes and treasury models.
FAQs
1. What is cost of debt?
Cost of debt is the effective rate a company pays on borrowed funds. It can be measured before tax or after tax.
2. Why is after tax cost of debt important?
Interest is often tax deductible. The after tax rate shows the real financing cost after the tax shield.
3. What is pretax cost of debt?
Pretax cost of debt is the borrowing rate before tax savings. It is useful for lender comparison and bond yield review.
4. Which tax rate should I enter?
Use the company marginal tax rate when possible. It usually gives a better estimate than an average historical tax rate.
5. Why does issue cost matter?
Issue cost reduces the cash received from borrowing. Lower net proceeds raise the effective cost of debt.
6. Is current yield the same as cost of debt?
No. Current yield ignores repayment gain or loss. Yield to maturity gives a broader estimate for bond debt.
7. Can this calculator support WACC analysis?
Yes. The weighted after tax debt cost can be used as the debt portion of a WACC estimate.
8. Should I use book value or market value?
Market value is usually better for decision making. Book value can still help when market data is unavailable.