Long Term Debt Balance Sheet Calculator

Calculator Form

Report Name

Currency

Total Interest Bearing Debt

Leave zero to use computed total debt.

Current Debt Classification

Short Term Debt

Current Portion Of Long Term Debt

Long Term Debt Components

Bonds Payable

Long Term Bank Loans

Long Term Notes Payable

Long Term Lease Liability

Mortgage Payable

Other Long Term Debt

Carrying Value Adjustments

Debt Discount

Debt Premium

Deferred Financing Fees

Non-Current Accrued Interest

Balance Sheet And Coverage Data

Total Assets

Total Equity

Total Liabilities

Cash And Cash Equivalents

EBITDA

Interest Expense

Formula Used

Gross long term debt = bonds payable + long term bank loans + long term notes payable + long term lease liability + mortgage payable + other long term debt.

Debt adjustments = debt premium + non-current accrued interest - debt discount - deferred financing fees.

Net long term debt = gross long term debt + debt adjustments.

Total debt method = total interest bearing debt - short term debt - current portion of long term debt.

Debt to equity = total interest bearing debt ÷ total equity.

Debt to capital = total interest bearing debt ÷ total interest bearing debt plus total equity.

Net debt to EBITDA = total debt minus cash ÷ EBITDA.

How To Use This Calculator

Enter the report name and select the currency. Add total debt if it is available from the balance sheet or debt schedule.

Enter short term debt and the current portion of long term debt. These amounts are removed from long term classification.

Add each long term debt component. Include bonds, loans, notes, leases, mortgages, and other non-current borrowings.

Enter discounts, premiums, financing fees, and accrued interest. These fields adjust the carrying value.

Complete asset, equity, cash, EBITDA, and interest fields. They support ratio analysis and review notes.

Press calculate to view results. Use CSV for spreadsheet work. Use PDF for a summary report.

Example Data Table

Input	Example Value	Meaning
Bonds Payable	$300,000	Non-current bond balance.
Long Term Bank Loans	$220,000	Term loan due after one year.
Current Portion	$90,000	Principal due within twelve months.
Debt Discount	$8,000	Reduction in carrying value.
Deferred Financing Fees	$6,000	Cost deducted from debt carrying amount.
Total Assets	$1,500,000	Used for long term debt to assets.

Understanding Long Term Debt

Long term debt is the part of borrowing that is not due within the next twelve months. It normally appears under non-current liabilities on a balance sheet. Common examples include bonds, term loans, mortgages, and long lease obligations. This calculator helps separate those amounts from short term debt and the current portion of long term debt.

Why Balance Sheet Classification Matters

Classification affects liquidity analysis. A lender wants to know what must be paid soon. An investor wants to know how much leverage stays in the company for future years. A manager wants to compare carrying value with loan agreements. A clean calculation supports each view.

Carrying Value and Adjustments

Debt is often not reported at face value. Discounts reduce the carrying amount. Premiums increase it. Deferred financing fees usually reduce the liability. Some companies also track non-current accrued interest. The calculator includes these adjustments so the final number better matches financial statement presentation.

Ratio Review

The long term debt amount becomes more useful when it is compared with assets, equity, and total capital. The long term debt to assets ratio shows how much of the asset base is financed by long obligations. Debt to equity compares lender financing with owner financing. Debt to capital shows the share of permanent capital supplied by debt.

Using Results Carefully

The output is an estimate for planning and review. Always compare it with the company trial balance, loan schedules, and note disclosures. Some businesses classify lease liabilities differently. Some loan agreements define debt in special ways. Covenants may include guarantees, letters of credit, or related party loans.

Practical Finance Use

Use the calculator during month end review, loan renewal work, or financial statement preparation. Enter each liability group carefully. Then download the report for support files. The CSV helps spreadsheet analysis. The PDF gives a quick summary for managers, lenders, and auditors.

A strong balance sheet review does more than total numbers. It explains timing, risk, cost, and repayment pressure. Long term debt should be monitored with maturity schedules, interest rates, security terms, and covenant limits. This calculator gives a structured starting point for that review. It also highlights differences between book presentation and debt service planning needs clearly.

FAQs

What is long term debt on a balance sheet?

Long term debt is borrowing due after twelve months. It usually appears under non-current liabilities. Examples include bonds, mortgages, term loans, and long term lease liabilities.

Is the current portion included in long term debt?

No. The current portion is due within twelve months. It is normally reported as a current liability, not as long term debt.

Why are debt discounts deducted?

A debt discount reduces the carrying value of the liability. The discount is usually amortized over time using the interest method or another accepted method.

Do financing fees reduce long term debt?

In many financial statements, deferred financing fees reduce the debt carrying amount. Treatment can vary by reporting framework and debt type.

What does debt to equity show?

Debt to equity compares creditor financing with owner financing. A higher ratio often means more leverage and greater dependence on borrowed funds.

What is net debt?

Net debt equals total debt minus cash and cash equivalents. It shows debt burden after considering available cash resources.

Can this calculator replace accounting review?

No. It supports planning and checking. Always review loan agreements, accounting policies, maturity schedules, and financial statement disclosures.

Why compare components with total debt?

The comparison helps find missing debt items, classification errors, or adjustment differences. It is useful during balance sheet review and audit preparation.