Loan Calculator

What does this loan calculator estimate?

This calculator models a fixed-rate installment loan from the borrower’s perspective. It estimates the recurring payment, the amount of cash actually received, total interest, total payment, finance charge, calculated APR, effective APR, fee composition, and the balance path over time. The model treats the stated loan amount separately from the net proceeds because an origination fee may be deducted before funding. It also separates fees paid upfront from fees rolled into the balance, since only financed fees accrue interest.

The figures are planning estimates rather than a lender disclosure or personalized financial advice. Loan contracts can use different day-count conventions, payment dates, minimum charges, late-fee rules, and rounding methods. For consumer-credit terminology and disclosure concepts, consult the Consumer Financial Protection Bureau’s APR guidance and the Federal Reserve’s consumer resources.

How should each loan input be used?

Rate information and compounding

What rate information do you know? Select nominal interest rate when the lender quotes a contract rate, advertised APR when APR is the only rate supplied, both when you want to compare the advertised figure with the fee-adjusted result, or periodic payment when neither rate is known. In payment mode, the calculator solves for the periodic rate that amortizes the financed balance over the selected term. A payment that is too small to repay the balance produces a validation message.

Nominal interest rate is the annual contract rate before fees. A higher rate raises every scheduled payment and usually increases total interest sharply. Enter the rate as a percentage, such as 5 for 5%. Advertised APR is a lender-provided comparison rate; when entered, it is used as the borrowing-rate assumption and the calculator still shows a recalculated APR based on the current fee structure. Compound frequency controls how the nominal rate converts into a periodic rate. Monthly compounding with monthly payments uses the annual nominal rate divided by 12, while mismatched compounding and payment frequencies use an equivalent-period conversion.

Principal, term, and payment frequency

Loan amount is the principal stated in the agreement, not necessarily the cash deposited into your account. Raising it increases payment and interest in roughly proportional terms when all other assumptions remain unchanged. Loan term may be entered in years or months; switching the unit converts the current value instead of merely changing the label. Longer terms normally lower the periodic payment but increase cumulative interest. Very short terms do the opposite. Payment frequency determines whether installments occur quarterly, monthly, bi-weekly, or weekly. More frequent payments produce more schedule rows and change the periodic rate used by the model.

Prepaid, loaned, and ori gination fees

Prepaid fee is paid separately and does not earn interest in this model. It still raises total payment and the finance charge. Loaned fee is added to the financed balance, so the borrower repays the fee plus interest on that fee. Origination fee is entered as a percentage of the stated loan amount. The repayment selector determines whether it is deducted from proceeds, rolled into the loan, or paid in cash. Deduction reduces net proceeds; rolling increases the interest-bearing balance; cash payment leaves proceeds unchanged but increases upfront cost. Origination fees vary widely by product and lender, so use the exact disclosure rather than a market average.

How are the main results interpreted?

Periodic payment is the scheduled amount for each selected payment period. It includes repayment of principal and any financed fees. Net proceeds received is the cash available after a deducted origination fee. This can be materially lower than the contractual principal. Total interest includes interest on the stated principal and on fees rolled into the balance. A zero-rate loan has zero interest but may still have a positive finance charge because of fees.

Total payment combines all scheduled installments with fees paid separately. Finance charge is total payment minus net proceeds, showing the dollar cost above the cash received. Calculated APR converts the full borrowing cost into a nominal annual rate using the payment frequency. To remain comparable across fee structures, the model spreads the total payment evenly across the scheduled periods when solving the APR. Effective APR compounds the periodic APR rate over one year. It is normally higher than nominal APR when compounding occurs more than once annually.

How do the chart and schedule help?

The breakdown chart separates the major portions of total payment. When more than five categories are active, the smallest components are combined into an Other segment so the visual remains readable. Zero-value categories are omitted, and every visible segment is matched to the legend and data table. A larger fee segment indicates that comparing offers by contract rate alone may be misleading.

The balance chart shows the financed balance alongside cumulative principal and cumulative interest. The remaining balance should decline to zero by the final row. The payment-detail schedule lists opening balance, payment, principal, interest, fee principal, and closing balance for every period. Annual summary combines those rows into calendar-like loan years, which is useful for budgeting and audit checks. The amortization overview from Investopedia provides additional background on why the principal share typically rises over time.

Which assumptions matter most?

Interest rate, term, and financed balance are the strongest recurring-payment drivers. A longer term can make a loan appear affordable month to month while increasing lifetime cost. Deducted fees reduce usable proceeds without reducing the repayment principal. Rolled fees can be more expensive because they also generate interest. When comparing offers, enter each lender’s exact term, payment frequency, fee treatment, and disclosed APR rather than comparing monthly payments alone.

Common mistakes include entering 0.05 instead of 5 for a 5% rate, treating a deducted origination fee as cash paid separately, ignoring financed fees, comparing loans with different payment frequencies, and assuming every lender uses identical rounding. The reset button intentionally clears the model to a neutral zero state rather than restoring the sample values. The downloadable workbook reflects the current values and includes summary, inputs, breakdown, schedule, and notes sheets for further review.