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.
- Convert APR to monthly rate: r = 8 / 1200 = 0.0066667
- Total payments: n = 5 × 12 = 60
- Compute (1 + r)^n = (1.0066667)^60 ≈ 1.48985
- Payment = 20000 × [0.0066667 × 1.48985] / [1.48985 − 1] = 20000 × 0.009933 / 0.48985 ≈ 405.53
- Rounded to the cent: $405.53
- Total paid = 405.53 × 60 = $24,331.80
- 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
- Jet Fuel Cost per Gallon? Prices and What Affects Them
- High Amount Personal Loan Interest Rate Calculator$405.53
- Fuel Costs and Home Loans: How They Connect$405.53
- Fuel Costs Perth: Prices, Factors and Savings
- Car Quote for a Used-Car Trade-In: What It Means
- Cost of Fuel: Calculate Your Trip’s Fuel Expense$42.00