What it is
Debt issuance costs and discounts reduce the carrying amount of debt and are amortized into interest expense over the term. The effective interest method sets interest expense at the carrying amount multiplied by a constant periodic rate. This workbook calculates that rate and builds the schedule.
Enter face amount, stated rate, payments per year, number of periods, cash proceeds and issuance costs. The Schedule tab shows 60 periods of interest expense, cash coupon, amortization, carrying amount and the unamortized balance, with the last period absorbing rounding so the carrying amount ends at face.
When to use it
- When a term loan, note or bond is issued with fees or at a discount.
- Each period, to post interest expense and the amortization of costs.
- At year end, to tie the net debt balance and unamortized costs to the ledger.
What’s inside
- Debt tab with terms, net proceeds, discount, coupon and the calculated effective rate
- Schedule tab for 60 periods with dates, interest, coupon, amortization and carrying amount
- Unamortized discount and costs, with the issuance cost share split out pro rata
- JE tab for any period with a balance check
- Tie-out of the schedule carrying amount to the general ledger
Standard cited
This template follows ASC 470 / ASC 835. It is written in our own words, except for phrases the standard requires the document to contain, with [bracketed placeholders] for client details, amounts in USD and dates as MM/DD/YYYY. Check it against the current standard and your firm’s methodology before use.
Questions
How is debt shown on the balance sheet?
Debt is presented at its carrying amount: the face amount less unamortized discount and issuance costs. The costs are not shown as a separate asset. Costs of a line of credit follow separate treatment.
Why not amortize on a straight-line basis?
The effective interest method gives a constant rate on the carrying amount. Straight-line is acceptable only when the result does not differ materially from the effective interest method.
What happens on prepayment or modification?
The schedule stops fitting. Account for the extinguishment or modification, write off or carry forward the unamortized balance as the analysis requires, and restart the schedule from the date of the change.
Which payment frequencies work?
Annual, semiannual, quarterly and monthly (1, 2, 4 and 12 payments per year), so dates fall on whole months. The schedule holds 60 periods.
Related templates
- Debt and Interest Rollforward Schedule
- Debt Covenant Compliance Workbook
- Disclosure Checklist: Debt (ASC 470)
- Debt Classification and Covenant Memo (ASC 470)
Last updated 11/05/2026. All free templates.