calculate-loan

01 Loan payments

Interest on a Loan in the Balance Sheet Explained

Calculator No. 01-12313 · Updated · Formula and assumptions shown below

Monthly payment $405.53
Total interest
$4,331.67
= Monthly payment × loan term × 12 − loan amount
Loan amount
$20,000
Input
Interest rate (APR)
8 %
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years)
You get
Monthly payment ($), Total interest ($)
Rounding
2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

Interest on a loan appears in different places on a balance sheet depending on whether it has been paid, accrued, or remains payable. The balance sheet shows interest owed as a liability, while interest expense for a period belongs on the income statement; this calculator estimates a level-payment loan’s payment and total interest from its amount, APR, and term.

Formula

For the estimated monthly payment, the standard level-payment formula is:

Payment = P × r ÷ [1 − (1 + r)−n]

  • P is the original principal, in dollars.
  • APR is the annual percentage rate, entered as a percentage.
  • r is the monthly rate as a decimal: APR ÷ 1,200.
  • n is the number of monthly payments: years × 12.
  • Payment is the monthly amount, in dollars.

The calculator’s second output is estimated total interest: monthly payment × number of payments − principal. The payment formula uses the unrounded expression internally; displayed dollars are rounded to cents. The total-interest output uses the displayed, cent-rounded payment, as specified by the calculator formula.

Worked Example

Using the default inputs—$20,000 principal, 8% APR, and five years—the monthly rate is 0.08 ÷ 12 = 0.0066667, and the payment count is 5 × 12 = 60.

  1. Substitute into the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)−60].
  2. The monthly payment is approximately $405.53 when rounded to cents.
  3. Using the rounded payment, total interest is $405.53 × 60 − $20,000 = $4,331.80.

Assumptions

  • The rate is fixed throughout the modeled term.
  • Payments are equal monthly payments made at the end of each monthly period.
  • Interest accrues monthly at APR divided by 12; the calculation treats APR as a nominal annual rate.
  • Fees, taxes, insurance, and other charges are not included.

How Interest Appears on a Balance Sheet

A balance sheet reports an entity’s financial position at a particular date. It lists assets, liabilities, and equity—not income and expenses accumulated over a period. Accordingly, “interest on a loan” is not always a separate balance-sheet line: its presentation depends on the accounting event and the organization’s reporting format.

When a borrower has incurred interest but has not yet paid it, the amount is generally recognized as interest payable, an accrued liability. It may appear as a separate current-liability item or be included in accrued expenses or another appropriate liability grouping. Whether it is current depends on when it is due and the applicable reporting framework and circumstances.

The loan principal still outstanding is a separate liability, often described as a loan payable, note payable, or borrowing. It should not be confused with unpaid interest. The principal balance represents the amount borrowed that remains to be repaid; interest payable represents the cost accrued for using the borrowed money.

Accrual and Payment: The Accounting Entries

Under accrual accounting, interest expense is generally recorded as it is incurred, even if cash payment happens later. A simplified entry to recognize accrued interest is a debit to interest expense and a credit to interest payable. The expense reduces profit for the reporting period; the payable increases liabilities on the balance sheet.

When the borrower pays that accrued amount, the simplified entry is a debit to interest payable and a credit to cash. The payment settles the liability; it does not record the same expense a second time. If interest is paid as it accrues, the expense is recognized and cash decreases, without an unpaid-interest balance remaining at the reporting date.

For example, if a business owes $150 of interest at month-end but will pay it next month, the month-end accounts can show $150 of interest expense and $150 of interest payable. The next month’s payment removes the payable and reduces cash. The principal remains separately recorded until repayments reduce it.

How Loan Payments Affect the Principal Balance

A regular loan payment often contains both interest and principal. The interest portion is the borrowing cost for that period; the principal portion reduces the loan liability. In an amortizing loan, the split changes over time: as principal is repaid, the interest calculated on the outstanding balance generally declines, while a larger share of a fixed payment goes toward principal.

For a simplified monthly calculation, interest for a period is the opening principal balance multiplied by the monthly rate. The principal repaid is the payment less that period’s interest. The closing principal balance is the opening balance less principal repaid. Actual loan statements may differ because of payment dates, daily interest calculations, variable rates, fees, payment changes, or other contract terms.

The calculator estimates payments and total interest for a fixed-rate, level-payment loan. It does not calculate the balance at a particular date or show the interest payable at a reporting date. To determine those figures, use the actual statement, loan schedule, payment history, and accrual period rather than treating the calculator’s lifetime interest estimate as a current liability.

Common Presentation Mistakes and Limits

  • Putting all future interest on the balance sheet: Interest that has not yet been incurred is not automatically a current payable. The balance sheet reports amounts owed at its reporting date, not every future financing cost over the remaining loan term.
  • Combining principal and interest: They are different obligations and affect the accounts differently. A payment allocation is needed to identify the principal reduction and interest expense.
  • Confusing expense with cash paid: Accrued interest can be an expense before cash leaves the account. Conversely, a payment may settle a liability recorded in an earlier period.
  • Assuming the estimate matches a lender statement: APR conventions, fees, payment timing, rounding, variable-rate changes, and loan-specific rules can change actual figures. The calculator uses a simplified monthly model.

For a reporting balance, identify the loan’s outstanding principal and any interest incurred but unpaid on the exact balance-sheet date. Accounting presentation can depend on the applicable accounting framework, the entity’s policies, and the loan terms; this explanation is general and does not determine a particular entity’s accounting treatment.

Frequently Asked Questions

Is interest on a loan an asset or a liability?
For a borrower, interest incurred but not yet paid is generally a liability called interest payable. For a lender, interest earned but not yet received may be recognized as an interest receivable, subject to the applicable accounting rules.

Is loan interest shown on the balance sheet or income statement?
Interest expense for a period is reported on the income statement. Any amount incurred but unpaid at the balance-sheet date is also reported as a liability, often as interest payable or within accrued liabilities.

Does the balance sheet include all interest due over the life of a loan?
No. It generally reflects amounts owed at the reporting date, including interest already incurred and unpaid. Future interest that has not yet accrued is not simply added to today’s loan liability in this simplified presentation.

Does a loan payment reduce the principal by the full payment?
Usually not for an interest-bearing amortizing loan. The payment first covers the interest due for that period, and the remainder reduces principal, subject to the loan’s terms and any additional charges.

Why does the calculator’s total interest differ from my statement?
The calculator assumes a fixed APR, equal end-of-month payments, and monthly accrual. A lender’s figures may reflect actual payment dates, daily accrual, fees, rate changes, or different rounding and contract provisions.

This result is an estimate for educational purposes; the lender’s disclosure gives the exact figures.

Related

Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Loan term | years | 5 | 0.0833 | 50
out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →