Loan payments do not appear as one expense on the profit and loss (P&L) statement because a payment combines principal repayment and interest. Principal reduces a liability on the balance sheet; interest is generally recorded as an expense on the P&L. This calculator estimates a fixed-rate monthly payment and its total interest from the loan amount, APR, and term, but it does not prepare accounting statements.
Formula
For a fixed-rate loan with equal monthly payments, the payment is the loan principal multiplied by the monthly interest rate, divided by one minus the factor for discounting that rate over all payments:
Payment = P × r / [1 − (1 + r)−n]
- P is the amount borrowed, in dollars.
- APR is the entered annual percentage rate, expressed as a percent.
- r is the monthly rate, calculated as APR ÷ 1,200.
- n is the number of monthly payments, calculated as years × 12.
The calculator’s total-interest estimate is rounded monthly payment × number of payments − principal. Because the monthly payment is displayed to the cent, this estimate uses that rounded payment. A real lender’s schedule can differ slightly because of payment dates, day-count methods, rounding, fees, or other loan terms.
Worked Example
Using the defaults—$20,000 principal, 8% APR, and five years—the monthly rate is 8 ÷ 1,200 = 0.0066667, and the term is 5 × 12 = 60 payments.
Payment = 20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] = $405.53 per month, rounded to the nearest cent.
Total interest = $405.53 × 60 − $20,000 = $4,331.80. The calculation uses the rounded monthly payment, as the calculator does.
Assumptions
- The interest rate is fixed for the full term.
- Payments are equal and made monthly, with the standard amortization assumption that the first payment is one month after borrowing.
- Interest compounds monthly at APR ÷ 12.
- Fees, taxes, insurance, PMI, and escrow are not included. The result is not a complete monthly housing or borrowing cost.
How Loan Payments Appear in Accounting
A P&L, also called an income statement, summarizes income and expenses over a period. A balance sheet reports assets, liabilities, and equity at a point in time. Borrowing creates cash (or another acquired asset) and a loan liability; receiving the loan is not, by itself, sales revenue. Paying back principal reduces the liability rather than representing a new operating expense.
Interest is the cost of borrowing for the period. Under accrual accounting, interest expense is recognized as it is incurred, even if its payment date falls in another period. The exact account names and bookkeeping entries depend on the organization’s accounting method and circumstances; the distinction between principal and interest is the key point.
For example, suppose a business makes a $405.53 payment in the first month of this illustrative loan. At a monthly rate of 0.0066667, interest for that month is about $133.33 ($20,000 × 0.0066667). The remaining roughly $272.20 of the payment reduces principal. The lender’s exact allocation may vary with its payment and rounding rules. The P&L reflects the interest expense, while the balance sheet reflects the principal reduction and the lower loan balance.
What a Loan Payment Includes
In a standard amortizing loan, each scheduled payment includes interest and principal. Early in the schedule, the outstanding balance is larger, so interest usually makes up a larger share. As principal is repaid, the interest portion generally falls and the principal portion rises, while the payment stays level if the rate and terms remain unchanged.
This is why “the payment” and “the expense” are not interchangeable. Cash flow records when cash moves; a P&L records income and expenses for a period; a balance sheet records what is owed. These views answer different questions. A business can have a substantial cash payment without having an equal P&L expense, and it can incur interest expense before paying it in cash.
Recording and Reconciling Payments
A typical bookkeeping entry separates the components: debit the loan liability for principal reduction, debit interest expense for interest incurred, and credit cash for the total payment. If interest has accrued but is not yet paid, an accrued-interest liability may also be involved. Follow the loan statement and the entity’s accounting policy when posting actual transactions.
To check a loan account, compare the opening balance, principal paid, and closing balance with the lender’s records. The basic roll-forward is opening principal + new borrowing − principal repaid = closing principal, subject to adjustments such as fees or other transactions. Interest should be checked separately against the statement or amortization schedule. If the lender bundles charges into a payment, identify each component rather than categorizing the full amount as interest.
Common Misconceptions and Limits
- “The whole payment is an expense.” Usually not: principal repays borrowed funds; interest is the borrowing cost.
- “A loan is income when received.” Borrowed money comes with an obligation to repay, so it is generally recorded as a liability rather than revenue.
- “The calculator payment must match the bank debit.” The estimate excludes fees, insurance, escrow, and other charges, and actual schedules can use different dates and rounding.
- “All loans have this payment pattern.” The formula assumes a fixed rate and equal monthly payments. Variable rates, interest-only periods, balloon payments, irregular payments, or changing terms require a different calculation.
The calculator is useful for understanding the arithmetic of a level-payment loan, not for deciding how a particular transaction should be presented in financial statements. For accounting records, use the lender’s breakdown and the applicable accounting method, and seek qualified accounting help when the treatment is uncertain.
Frequently Asked Questions
Is the principal portion of a loan payment an expense?
Generally, no. Principal repayment reduces the loan liability on the balance sheet. Interest is generally recorded as an expense as it accrues.
Where does loan principal appear on financial statements?
The outstanding principal appears as a liability on the balance sheet. The portion due within a relevant current period may be presented separately from longer-term debt, depending on reporting requirements and circumstances.
Does a loan payment appear on a cash flow statement?
Cash paid to repay a loan is a cash-flow item, but its classification can depend on the reporting framework and the nature of the borrowing. A cash flow statement is distinct from the P&L.
Why is the interest amount different each month?
For many amortizing loans, interest is calculated on the remaining balance. As principal falls, the interest share usually declines. The lender’s schedule determines the exact amounts.
Why does the calculator differ from my loan statement?
This estimate assumes a fixed APR, monthly compounding, equal payments, and no additional charges. Payment timing, fees, variable rates, rounding, or a different term can change the lender’s figures.
This result is an estimate; 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
- Trade In an Old Laptop for a New One?
- Trade In an Old Phone: Value, Steps, and Alternatives
- Trade In an Old iPhone: Options, Value and Steps
- Trade In an Old Laptop? Options, Value, and Safety
- AT&T Trade-In Offers: How They Work
- Trade In an Old iPad: Options, Value, and Preparation