calculate-loan

01 Loan payments

Equity Bank Loan Schedule: How to Read It

Calculator No. 01-26317 · Updated · Formula and assumptions shown below

Monthly payment $405.53
Total interest
$4,331.67
= Monthly payment × loan term × 12 − loan amount
Loan amount
$20,000
Input
Interest rate (APR)
8 %
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years)
You get
Monthly payment ($), Total interest ($)
Rounding
2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

An Equity Bank loan schedule shows each payment’s date, principal, interest, and remaining balance over the loan term. To use it, you enter your loan amount, interest rate, and term, and the calculator below generates the full schedule. This article explains how the schedule works, how to read it, and what to watch for.

Formula

The monthly payment for a fixed-rate loan is calculated with the standard amortization formula:

M = P × [r(1 + r)^n] / [(1 + r)^n − 1]

  • M = monthly payment (in $)
  • P = loan amount (principal, in $)
  • r = monthly interest rate = annual percentage rate (APR) divided by 12, expressed as a decimal (e.g., 8% APR → 0.08/12 = 0.0066667)
  • n = total number of monthly payments = loan term in years × 12

Each month, the interest portion is r × current balance, and the principal portion is M − interest. The new balance is the old balance minus the principal portion.

Worked Example

Using the defaults: loan amount $20,000, APR 8%, term 5 years.

  1. Convert APR to monthly rate: r = 8 / 1200 = 0.0066667
  2. Total payments: n = 5 × 12 = 60
  3. Compute (1 + r)^n = (1.0066667)^60 ≈ 1.48985
  4. Payment = 20000 × [0.0066667 × 1.48985] / [1.48985 − 1] = 20000 × 0.009933 / 0.48985 ≈ 405.53
  5. Rounded to the cent: $405.53
  6. Total paid = 405.53 × 60 = $24,331.80
  7. Total interest = 24,331.80 − 20,000 = $4,331.80

These match the calculator outputs exactly.

Assumptions

  • Fixed interest rate for the entire term (no rate changes).
  • Payments are made monthly at the end of each period.
  • Interest compounds monthly at APR/12.
  • No fees, taxes, insurance, or other charges are included.
  • The payment is rounded to the cent, and the final payment may be slightly adjusted to clear the balance.

How Equity Bank Loan Schedules Work

Equity Bank (a commercial bank in Kenya) offers various loans—personal, business, mortgage, and asset financing—most with monthly repayments. The schedule is an amortization table that breaks down each installment into interest and principal. Early payments are mostly interest; later payments are mostly principal. This is because interest is calculated on the outstanding balance, which decreases over time.

For example, in the first month of a $20,000 loan at 8% APR, interest is $133.33 (0.0066667 × 20,000), so principal repaid is $405.53 − $133.33 = $272.20. After 30 months, the balance is roughly $11,000, so interest is about $73.33, and principal is $332.20.

Equity Bank may also offer reducing balance or flat rate schedules. The calculator above uses reducing balance, which is the standard for most bank loans. Flat rate schedules calculate interest on the original principal for the whole term, resulting in higher effective APR—be sure to check which method your loan uses.

How to Use the Calculator and Read the Schedule

Enter your loan amount, APR (ask your lender for the exact rate), and term in years. The calculator gives your monthly payment and total interest. To see the full schedule, you would list each month’s payment, interest, principal, and remaining balance. Many banks provide this schedule when you apply; you can also create it in a spreadsheet using the formulas above.

When reading a schedule, focus on the remaining balance column. It shows how much you still owe after each payment. This is useful if you plan to pay off the loan early—the balance is your payoff amount (plus any prepayment penalties, if applicable).

Common Mistakes and Misconceptions

  • Mixing up APR and monthly rate: Always divide the annual rate by 12 before using it in the formula.
  • Ignoring rounding: The payment is rounded to cents; total interest may differ by a few cents if you use unrounded numbers.
  • Assuming equal interest each month: Interest decreases each month because the balance decreases.
  • Confusing flat rate with reducing balance: A flat rate of 8% is not the same as an APR of 8%—the effective APR is higher.

A common misconception is that paying “double” each month cuts the term in half. Actually, it reduces the term to about 3.5 years for a 5-year loan, because extra payments go directly to principal, saving significant interest.

Comparing Loan Offers and Early Payoff

Use the schedule to compare loans with different rates and terms. A lower monthly payment may mean a longer term and more total interest. For example, a $20,000 loan at 8% for 5 years costs $4,331.80 in interest; the same loan for 7 years (at the same rate) would have a payment of about $312.28 and total interest of about $6,231.52. The calculator lets you test different scenarios.

If you make extra payments, the schedule shortens. To see the effect, use the balance formula after a certain number of payments. For instance, after 12 payments on the 5-year loan, the balance is about $16,800. If you pay an extra $500 that month, you reduce the principal to $16,300, and the loan will be paid off about 2 months earlier, saving about $200 in interest.

Costs and Fees Not in the Schedule

The schedule only covers principal and interest. Equity Bank may charge loan application fees, appraisal fees, insurance, or late payment penalties. These are not included in the amortization. Always ask the lender for a full breakdown of all charges and the annual percentage rate (APR) that includes fees, if applicable. The APR is a better measure of the true cost than the nominal interest rate.

Frequently Asked Questions

How do I get my Equity Bank loan schedule?

You can request a loan amortization schedule from the bank when you take out the loan, or you can generate one yourself using the calculator above and a spreadsheet. The bank’s schedule will show each payment date, amount, interest, principal, and balance.

Can I pay off my Equity Bank loan early?

Most loans allow early repayment, but there may be a prepayment penalty or a minimum period before you can do so. Check your loan agreement or ask the bank. If allowed, paying extra reduces the balance and total interest, as shown in the schedule.

Why is my first payment mostly interest?

Because interest is calculated on the full outstanding balance at the start. As you pay down the principal, the interest portion decreases. This is normal for reducing balance loans.

What is the difference between flat rate and reducing balance?

Flat rate calculates interest on the original loan amount for the whole term, so the monthly interest is constant. Reducing balance calculates interest on the remaining balance, so interest decreases over time. For the same quoted rate, reducing balance results in lower total interest.

Does the calculator include bank fees?

No. The calculator only computes principal and interest. Fees such as application, legal, or insurance costs are not included. To get the true cost, add those fees to the loan amount or ask the lender for the APR that includes them.

This result is an estimate based on the inputs you provide; the exact figures will be in your lender’s disclosure.

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

The whole Loan payments section →