A new loan is recorded by debiting Cash (or the asset received) and crediting a loan payable liability for the amount borrowed. This calculator estimates the fixed monthly payment and total interest for a fully amortizing loan from its principal, annual APR, and term; it does not create an accounting journal entry or account for fees.
Formula
The accounting entry when a borrower receives a loan is generally:
- Debit Cash (or the asset received) for the proceeds received.
- Credit Loan Payable, a liability, for the amount owed.
For example, if a business receives $20,000 in cash from a lender, the initial entry is a $20,000 debit to Cash and a $20,000 credit to Loan Payable. The calculator above answers a related cash-flow question: what the level monthly payment and total scheduled interest would be under a simplified fixed-rate repayment model.
The payment formula is PMT = P × r / [1 − (1 + r)−n], where P is principal in dollars, r = APR / 1,200 is the monthly rate as a decimal, and n = term in years × 12 is the number of monthly payments. Total interest is calculated as PMT × n − P. The displayed payment is rounded to cents, and total interest uses that rounded payment.
Worked Example
Using the calculator’s default inputs, the principal is $20,000, APR is 8%, and the term is 5 years. First convert the annual rate to a monthly decimal: 8 ÷ 1,200 = 0.0066667. The number of payments is 5 × 12 = 60.
Substitute these values: PMT = 20,000 × 0.0066667 ÷ [1 − (1 + 0.0066667)−60] = approximately $405.53 per month, rounded to the nearest cent. Total scheduled payments using the rounded payment are $405.53 × 60 = $24,331.80. Subtract the $20,000 principal: estimated total interest is $4,331.80.
Assumptions
- The interest rate is fixed for the full term.
- Payments are equal, monthly, and made at the end of each period.
- Interest compounds monthly using APR divided by 12.
- The estimate excludes fees, taxes, insurance, PMI, escrow, and any charges not entered as principal.
How the New-Loan Entry Works
Double-entry bookkeeping records equal debit and credit amounts so the accounting equation remains balanced. Borrowing creates both an increase in an asset—usually cash—and an increase in a liability. The loan is not revenue: the borrower has an obligation to repay it.
The exact accounts depend on what the borrower receives and how the transaction is structured. A lender might pay a vehicle seller directly, for instance. In that case, the borrower may debit an asset such as Vehicle rather than Cash, and credit the appropriate loan liability. If loan proceeds arrive in the borrower’s bank account and are then used to buy equipment, the loan receipt and equipment purchase are typically recorded as separate transactions.
Use the amount actually received or the amount of the obligation recognized under the applicable accounting basis and documentation. If the amount borrowed differs from cash received because of fees or deductions, do not assume the simple two-line entry captures every accounting effect. Keep the loan agreement and disbursement statement with the transaction records.
Recording Repayments and Interest
A scheduled payment commonly reduces the liability by its principal portion and records its interest portion as interest expense. The combined entry is a debit to Loan Payable for principal, a debit to Interest Expense for interest, and a credit to Cash for the full payment. The split changes over time: with a conventional amortizing loan, early payments generally contain more interest than later payments because interest is calculated on the outstanding balance.
For a simple illustration, suppose a payment is $405.53 and the lender’s statement identifies $133.33 as interest and $272.20 as principal. The entry would debit Interest Expense $133.33, debit Loan Payable $272.20, and credit Cash $405.53. Use the lender’s payment allocation or an appropriate amortization schedule; do not infer the exact split from a rounded estimate when the contractual schedule is available.
At the initial borrowing, interest is not usually recorded merely because the loan was received. It is recorded as it accrues or is incurred according to the accounting method and reporting requirements that apply. If reporting dates fall between payments, accrued interest may need a separate adjusting entry. The calculator does not determine accruals or accounting treatment.
Common Entry Problems and Calculator Limits
- Crediting income instead of a liability: borrowed funds are generally repayable and are not ordinary sales revenue.
- Recording only the cash received: omitting the liability leaves the books incomplete.
- Posting the entire payment to loan principal: payments may include interest and other charges, which should be classified using the lender’s breakdown.
- Ignoring timing or fees: a payment estimate may differ from a lender’s schedule when the first payment date, payment frequency, fees, or rate structure differs.
- Rounding every step: rounding intermediate calculations can create small discrepancies; this calculator rounds the monthly payment to cents and uses it for its total-interest estimate.
The payment formula assumes a positive APR and equal end-of-month payments. It is not designed for interest-only periods, variable rates, balloon payments, irregular payment dates, or loans with a different compounding convention. The total-interest result is a mathematical estimate under the stated assumptions, not necessarily the amount shown on a lender’s disclosure.
Frequently Asked Questions
What is the journal entry when a business takes out a loan?
Generally, debit Cash (or the asset received) and credit Loan Payable for the borrowed amount. The precise accounts and amounts depend on how funds are disbursed and the transaction documents.
Is a loan recorded as income?
Loan proceeds are generally recorded as a liability rather than income because they must be repaid. The initial receipt increases an asset and an obligation.
How do I record a loan payment?
Split the payment between principal and interest based on the lender’s schedule. Debit Loan Payable for principal, debit Interest Expense for interest, and credit Cash for the total payment.
Does the loan entry include interest?
The initial borrowing entry records the proceeds and liability; it does not normally include future interest as if already paid. Interest is recorded as it accrues or is incurred under the applicable accounting method.
Why does my calculated payment differ from the lender’s figure?
The lender may use different timing, a different rate convention, fees, a different payment amount or frequency, or rounding rules. Compare the estimate’s assumptions with the loan disclosure and payment schedule.
The result is an estimate, and 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
- Student Loan Balance England Calculator45,308.39 £
- Scottish Student Loan Balance Calculator and Repayment
- See Student Loan Balance: Estimate What You Owe$405.53
- Private Student Loan Past-Due Balance Calculator$855.33
- RD Student Loan Payment Calculator and Guidelines$405.53
- NI Student Loan Balance: How It’s Calculated$405.53