APR vs. Interest Rate: A Loan Comparison Worksheet for Total Borrowing Cost
APRinterest ratesloan comparisonborrowing decisionsdebt planning

APR vs. Interest Rate: A Loan Comparison Worksheet for Total Borrowing Cost

CCreditScore.page Editorial Team
2026-11-19
6 min read

Compare APR and interest rates with a practical worksheet for fees, payments, total loan cost, rate risks, and repayment terms.

When comparing loans, the interest rate is only one part of the cost. This guide explains APR vs. interest rate, shows how to estimate total repayment, and provides a reusable loan comparison worksheet for reviewing fees, payment amounts, rate changes, and repayment flexibility before you borrow.

Overview

The interest rate is the percentage a lender charges for allowing you to use its money. It is applied to the outstanding principal according to the loan agreement. A loan with a lower interest rate will often have lower interest charges, but the rate alone does not show every cost of borrowing.

APR, or annual percentage rate, is a broader annualized measure intended to reflect the interest rate plus certain finance charges connected with obtaining the loan. Depending on the product and lender, those charges may include an origination fee, discount points, or other borrowing costs. APR does not necessarily include every fee you could pay, such as late fees, optional insurance, or charges unrelated to obtaining credit. Review the agreement and disclosure rather than assuming APR captures everything.

In practical terms, the interest rate helps you estimate the loan's interest expense, while APR helps you compare the overall cost of similar offers. Neither number should be reviewed by itself. Also compare the principal, term, scheduled payment, total of payments, upfront fees, prepayment terms, and whether the rate can change.

ItemWhat it tells youWhy it matters
Interest rateThe stated charge on the unpaid principalHelps estimate interest and monthly payments
APRAn annualized cost measure that may include certain finance chargesUseful for comparing similar loan offers
TermHow long repayment is scheduled to lastA longer term can reduce the payment but increase total interest
Total of paymentsThe scheduled amount paid over the loan termShows the repayment obligation before optional or unexpected costs

How to estimate the total borrowing cost

Start with the amount you will receive or the purchase price being financed. Then collect the offer's rate, term, scheduled payment, APR, and every listed fee. For a fixed-rate installment loan, use this basic calculation:

Total scheduled payments = monthly payment × number of payments

Scheduled interest = total scheduled payments − principal

To estimate your broader cash cost, add fees you will pay, whether they are deducted from the proceeds or paid separately:

Estimated total out-of-pocket cost = total scheduled payments + upfront fees + other required borrowing costs

If a fee is deducted from the loan proceeds, adjust the amount you actually receive. For example, a $10,000 loan with a $300 fee may provide only $9,700 in usable funds if the fee is withheld at closing. You may still repay based on the full $10,000 principal. This distinction is important when deciding how much the loan actually costs you.

You can use a loan repayment calculator or spreadsheet to check the lender's payment. For a standard fixed-rate, fully amortizing loan, the payment is based on the principal, periodic interest rate, and number of payments. The lender's disclosure should be your primary reference because rounding, payment timing, and fee treatment can affect the result.

Do not compare APRs without checking that the offers have similar terms. A three-year loan and a seven-year loan may have different APRs, payment schedules, and risk profiles. A lower payment is not automatically a lower-cost loan.

Inputs and assumptions: loan comparison worksheet

Copy the following worksheet for each offer. Record the figures exactly as shown in the disclosure, keeping dollars and percentages separate.

InputOffer AOffer B
Loan purpose
Amount borrowed
Net amount received
Interest rate
APR
Fixed or variable rate
Number of payments
Scheduled payment
Origination or application fee
Other required fees
Total scheduled payments
Estimated total cash cost
Prepayment or early-payoff terms
Late-payment consequences

Before choosing, ask these questions:

  • Is the interest rate fixed for the entire term or subject to change?
  • What event could change the payment or rate on a variable-rate loan?
  • Are fees paid upfront, deducted from the proceeds, or added to the balance?
  • Is there a minimum payment that could extend repayment, as with some revolving credit?
  • Can you make extra payments without a charge, and will extra payments reduce principal?
  • What happens if you pay late or miss a payment?

For a credit card, the comparison changes slightly. The APR may apply to purchases, balance transfers, or cash advances under different terms. Check which balance receives which rate, how promotional periods end, and how payments are allocated. A balance transfer fee or annual fee can materially affect the cost even when the advertised rate appears low.

Worked example

Suppose you need $10,000 and are comparing two illustrative fixed-rate, three-year installment loans. These figures are examples for demonstrating the method, not current offers.

TermOffer AOffer B
Interest rate12.00%10.50%
Term36 months36 months
Monthly payment, approximately$332$325
Required fee$300$600
Scheduled payments, approximately$11,957$11,704
Scheduled interest, approximately$1,957$1,704
Payments plus fee, approximately$12,257$12,304

Offer B has the lower interest rate and lower monthly payment, but the larger fee makes its estimated total cost slightly higher in this simplified example. The lender's disclosed APR should reflect relevant finance charges and is another useful comparison point. Still, check whether both offers define fees, payment timing, and the amount financed in the same way.

Your decision may not be based on cost alone. A slightly more expensive loan could be preferable if it has a fixed rate, a manageable payment, no restrictive prepayment terms, or a term that better fits your household budget. On the other hand, a lower payment that leaves little room for emergencies can create repayment risk. Review the proposed payment alongside your monthly cash flow and emergency savings plan. The emergency fund calculator guide can help you set a separate savings target before committing to a new payment.

When to recalculate

Revisit this worksheet whenever you receive a new loan offer, refinance an existing balance, negotiate a different fee, or consider changing the term. Recalculate if the lender changes the rate, the amount financed, the payment schedule, or the loan's variable-rate terms.

For a variable-rate loan, create more than one scenario: the payment at the starting rate, the payment after a modest increase, and the payment at the agreement's stated maximum or cap when that information is available. Do not assume a variable rate will remain at its introductory level.

Recalculate before consolidating debt as well. A consolidation loan can simplify payments, but extending the term may increase total interest. Compare the new loan's total cost with the balances, rates, fees, and remaining repayment periods of the debts it replaces. If the loan is intended to pay off credit cards, avoid treating the newly available credit as extra spending room.

Finally, save the completed worksheet with the offer disclosure and approval terms. Confirm the final documents before signing, especially the APR, amount financed, payment, number of payments, fees, and any variable-rate language. When the numbers change, update the worksheet rather than relying on the original estimate. That simple habit turns a one-time comparison into a repeatable borrowing decision process.

For related planning, see the debt snowball and avalanche comparison, review how a new application may affect your credit with the hard inquiry vs. soft inquiry guide, and use the home affordability worksheet before taking on a mortgage payment.

Related Topics

#APR#interest rates#loan comparison#borrowing decisions#debt planning
C

CreditScore.page Editorial Team

Personal Finance Editors

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.