APR Calculator

APR Calculator
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Description

APR Calculator

Estimate the true annual cost of a general loan or U.S. mortgage after interest, financed charges, upfront fees, points, and recurring mortgage insurance.

Mode General loan Real APR 6.563% Payment $1,110.21 Periods 120

Loan assumptions

Results update as values change.

Cash principal made available before fees.
Whole or partial years.
Use 0–11 months in addition to years.
Nominal annual rate before fees.
Determines the equivalent rate per payment period.
Payment frequency used for the installment schedule and APR annualization.
Charges added to the financed balance.
Cash charges paid separately at origination.

Live results

General loan cost

Real APR
6.563%

Annualized periodic rate that equates net proceeds with scheduled payments.

Amount financed
$100,000.00
Upfront out-of-pocket fees
$2,500.00
Payment every month
$1,110.21
Total of 120 payments
$133,224.60
Total interest
$33,224.60
All payments and fees
$135,724.60
APR premium over rate
0.563 pp
Net proceeds
$97,500.00
Real APR 6.563 percent; payment $1,110.21; 120 payments.

Cost breakdown and payoff path

Both visuals are generated from the same live amortization model used by the results and workbook.

Lifetime cost composition

Principal, interest, and fees as shares of all-in cost.

Category Amount Share
Fees are small relative to principal, but they can materially raise APR because they reduce the value received at origination.

Balance and cumulative interest

Year-end loan balance compared with interest accumulated to date.

The balance generally falls slowly at first because a larger share of early payments goes to interest.

Amortization schedule

Switch between annual summaries and every scheduled installment.

Amounts are calculated with full precision and rounded only for display. The final installment is adjusted by fractions of a cent when necessary so the ending balance does not become negative.

How to use and interpret the APR calculator

What this calculator estimates

Annual percentage rate is designed to express borrowing cost as one yearly rate. Unlike the stated interest rate, a real APR estimate also considers qualifying finance charges and the timing of the cash flows. The calculator first builds the contractual payment from the financed balance, stated rate, compounding convention, payment frequency, and term. It then solves for the periodic rate that makes the present value of all scheduled payments equal to the amount of value actually received by the borrower. That periodic rate is annualized to produce the displayed APR.

The general-loan mode is appropriate for fixed-payment personal, auto, equipment, or business loans where fees may either be added to the balance or paid upfront. Mortgage mode uses monthly payments and adds house value, down payment, points, lender fees, and annual private mortgage insurance. The estimate is a planning tool rather than a lender disclosure. Formal U.S. disclosures can depend on fee classifications and regulatory conventions described in Regulation Z guidance from the CFPB.

General-loan inputs

  • Loan amount is the cash principal requested. Enter the amount before financed or prepaid charges. A larger amount raises the payment and total interest in dollars, although APR may remain similar when fees scale proportionally.
  • Loan term combines years and additional months. A longer term usually lowers each payment but increases lifetime interest. Additional months should be between 0 and 11; use a decimal year only when the contract itself is stated that way.
  • Interest rate is the nominal annual rate before fees. A higher rate raises the periodic payment, total interest, and normally the real APR. Do not enter the lender’s disclosed APR in this field unless there are no extra finance charges and you are testing a no-fee case.
  • Interest compounds controls how the annual rate is converted to the payment period. More frequent compounding can increase the effective periodic cost. Pay back every controls installment frequency and the number of periods. The two frequencies can differ, so the model converts the compounding rate into an equivalent rate for each payment interval.
  • Loaned fees are charges rolled into the balance. They increase the financed amount and therefore accrue interest. Upfront fees are paid separately and reduce net proceeds without increasing the contractual balance. Either type generally pushes APR above the stated rate, with upfront fees having a particularly visible effect on short terms.

Mortgage inputs

  • House value is the purchase price. Down payment can be entered as dollars or a percentage; changing the unit converts the current value rather than only changing its label. A larger down payment reduces the mortgage principal, monthly payment, and interest in dollars.
  • Loan term and interest rate drive the principal-and-interest payment. Shorter terms normally create higher monthly payments but less total interest. Mortgage calculations use monthly installments and monthly rate conversion.
  • Loan fees represent qualifying upfront charges. Points are entered as a percent of the mortgage principal, with one point equal to 1%. Point s reduce the value received for APR purposes and are shown separately in the results because they are prepaid interest or financing cost.
  • PMI insurance per year is divided into monthly installments and included in the cash-flow APR estimate for the full modeled term. In practice, PMI may terminate before maturity, so use a separate scenario with a shorter expected PMI duration when comparing lender disclosures.

Understanding every result

Real APR is the primary comparison rate. When it equals the stated rate, fees are zero and the payment/compounding conventions are aligned. A higher APR indicates that charges or timing increase the effective borrowing cost. The APR premium over rate shows the difference in percentage points, which is useful when comparing two offers with similar note rates.

Amount financed is the balance used to calculate payments. In general-loan mode it includes loaned fees; in mortgage mode it is the house value minus the down payment. Net proceeds is the economic value received after upfront APR charges. A low net-proceeds figure relative to the balance is a warning that fees are substantial.

Periodic payment is the scheduled installment. Mortgage mode includes monthly PMI when entered. Total of payments is the sum of installments over the full term. Total interest is interest generated by the amortizing principal; recurring insurance and upfront fees are kept in separate categories. All-in cost combines principal, interest, financed fees, upfront charges, points, and recurring insurance as applicable.

The donut uses those same categories, so its segments cross-foot to the all-in total. A zero-value category is omitted rather than drawn as a fake slice. The line chart plots year-end balance and cumulative interest. The annual and payment-detail tables expose the exact schedule behind the chart: opening balance, payment, principal reduction, interest, recurring fee, and ending balance. A zero ending balance confirms the schedule fully amortizes.

Practical comparison method

Use identical loan amounts and terms when comparing offers, then enter each lender’s rate and APR-eligible fees. Compare the real APR, payment, and all-in cost together. APR is best for standardizing cost, while payment shows near-term affordability and total interest shows long-run dollars. The CFPB explains the distinction between rate and APR for general loans and mortgages.

A lower note rate is not automatically the cheaper offer. A loan with discount points or large origination charges may have a lower payment but a higher cost if it is refinanced or paid off early.

For mortgages, compare Loan Estimates for the same loan type, term, and lock period. The CFPB’s Loan Estimate explainer shows where APR and other comparison measures appear. For market context, the Federal Reserve’s G.19 consumer credit release publishes selected APR statistics for common credit products.

Common mistakes and model limits

  • Do not include optional products, late fees, or penalties unless they are required finance charges for the specific credit offer.
  • Do not double-count a fee as both loaned and upfront. A financed fee increases the balance; a prepaid fee reduces net proceeds.
  • Do not compare APRs across different terms without also reviewing total interest and expected holding period. Upfront costs are spread over the modeled term, so an early payoff can make the realized cost higher.
  • Fixed-rate assumptions do not represent adjustable-rate resets, balloons, irregular first periods, skipped payments, taxes, escrow, or changing PMI. Use lender disclosures for regulated decisions and professional advice for complex transactions.