How this instrument works
A personal loan is a fixed-rate, fixed-term lump sum with no collateral attached to any specific purchase — unlike a mortgage or auto loan, where the house or car secures the debt, a personal loan is backed only by the borrower's promise to repay. Because there is nothing to repossess if payments stop, a lender prices the loan almost entirely on creditworthiness: credit score, income, and existing debt sort applicants into risk tiers, and the rate spread between the best and worst tier at the same lender commonly runs from the high single digits past thirty percent.
The payment formula is the standard amortization shape used across every installment loan — Monthly payment, $ is sized so equal payments retire the exact balance typed into Loan amount, $ over Loan term, months, with interest charged only on whatever principal remains outstanding each month. What this sheet does not price is the origination fee many online personal-loan lenders subtract from the amount they actually wire to your account, commonly one to eight percent of the loan; if you need a specific sum in hand, the figure you type into Loan amount, $ has to be the full note amount, not the smaller sum that lands after the fee comes out.
Personal loans fund almost anything — debt consolidation, a medical bill, a move, a wedding — which is exactly why comparing this sheet's output against the alternative matters more than for a loan tied to one asset. The comparison people get wrong most often is checking a card's minimum payment against this loan's Monthly payment, $ instead of checking Total interest paid, $ against what the same balance would cost carried on a card for the same number of months; a card's minimum payment schedule is built to stretch a balance far longer than any personal-loan term, so the two numbers are not measuring the same thing.
- Enter the full amount of the loan under Loan amount, $ — the note's face value, not the smaller sum you would receive after any origination fee is deducted.
- Set the fixed rate from your loan offer under Annual interest rate, % — the rate on the note itself, entered as a whole number such as 12, not 0.12.
- Choose the repayment length under Loan term, months; online personal loans commonly run 24 to 60 months, occasionally longer.
- Read Monthly payment, $ for the fixed installment, then check Total of all payments, $ and Total interest paid, $ beneath it.
- Compare Total interest paid, $ against what the same balance would cost sitting on a credit card for the same number of months.
Worked example — $10,000 at 10% over 36 months
Borrow $10,000 (Loan amount, $) at a 10% annual rate (Annual interest rate, %) over 36 months (Loan term, months) — a common size and term for an online personal loan used to consolidate a few credit-card balances. The monthly rate is r = 10 ÷ 1200 = 0.008333, and (1.008333) raised to the 36th power works out to about 1.34818. Feeding those figures into the formula returns a Monthly payment, $ of $322.67, the exact figure this sheet shows for these inputs.
Across all 36 installments that totals $11,616.19 in Total of all payments, $, of which Total interest paid, $ accounts for $1,616.19 — about sixteen cents of interest for every dollar borrowed, more than a mortgage or auto loan of the same size would carry at a comparable rate, because there is no house or car behind an unsecured personal loan for the lender to reclaim if payments stop. Stretch the same $10,000 to 60 months instead and Total interest paid, $ rises to $2,748.23 even though neither the loan amount nor the rate changed — only the number of months the balance stayed outstanding.
Questions
Why do personal loan rates vary so much between lenders and applicants?
Because there is no collateral, the price is set almost entirely by creditworthiness — credit score, income, and existing debt sort applicants into risk tiers, and lenders publish a wide 'as low as' to 'up to' range because most applicants land somewhere in the middle, not at the advertised floor. Two borrowers requesting the same amount and term from the same lender can see rates several times apart if their credit profiles differ.
Does the loan amount I enter match what lands in my bank account?
Not necessarily. Many online personal-loan lenders subtract an origination fee, commonly one to eight percent of the loan, from the amount they disburse, so a $10,000 note might deposit closer to $9,500 after a five percent fee. Loan amount, $ in this sheet is the full note amount the payment is calculated on — if you need a specific sum in hand, the figure you enter has to be larger than that target by roughly the fee.
Is a personal loan cheaper than carrying the balance on a credit card?
It depends on how long the card balance would otherwise sit unpaid, since the two charge interest by different mechanics. Compare Total interest paid, $ at this loan's fixed rate and term against what the card's own APR would charge over the same number of months — a card's minimum payment is built to stretch a balance far longer than a 36- or 60-month personal-loan term, so comparing monthly payments alone understates what the card option actually costs over time.
Why is Loan term, months usually shorter than a mortgage's?
Because the loan is unsecured, a lender limits its exposure by capping how long the balance can stay outstanding — personal-loan terms commonly run 24 to 60 months, occasionally out to seven years for a large loan from a handful of lenders, against 180 or 360 months for a mortgage backed by real estate. The shorter ceiling concentrates the same principal into fewer, larger installments, part of why unsecured borrowing trades a higher rate for a faster payoff.
Does paying extra toward the balance reduce Total interest paid, $?
Yes, in the arithmetic this sheet is built on: interest accrues only on the outstanding balance, so extra principal paid early removes future interest that balance would otherwise have generated, shrinking the true total below what a payment held to term would produce. A small number of personal-loan contracts carry a prepayment penalty that claws some of that saving back — this sheet has no field for one, so check your note before assuming the full saving is yours.
References
Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.