Loan Equal Installment Calculator (Simple Interest)
🔁 Forward Calculation (Given N → Find M)
🔄 Reverse Calculation (Given M → Find N)
Simple Interest Loan Equal Installment — Solved Example
Complete Mathematical Proof & Verification Report based on standard default inputs
1. Initial Input Parameters
The calculation assumes equal monthly installments ($X$) where principal repayment is distributed uniformly over $N$ months, followed by interest repayment over $M$ months (or vice-versa):
| Parameter Name | Variable Symbol | Forward Value | Reverse Value |
|---|---|---|---|
| Principal Loan Amount | P | ₹55,00,000.00 | ₹55,00,000.00 |
| Annual Interest Rate | R | 9.50% p.a. | 9.50% p.a. |
| Principal Payment Period | N | 120 months (10 yrs) | 116.48 months (Target) |
| Interest Payment Period | M | 48 months (Target) | 48 months |
2. Step-by-Step Forward Calculation (Given N = 120 → Find M)
Step 2.1: Monthly Installment ($X$)
The monthly principal installment is calculated by dividing total principal $P$ by the principal tenure $N$:
X = 5,50,0000 / 120 = ₹45,833.33 / month
Step 2.2: Average Outstanding Principal & Total Interest
Under a linear reduction schedule, average outstanding principal over tenure $N$ is $P / 2$:
Time in Years = N / 12 = 120 / 12 = 10 Years
Total Interest = (Average Principal) × (Rate / 100) × Years
Total Interest = 27,50,000 × 0.095 × 10 = ₹26,12,500.00
Step 2.3: Interest Period ($M$) and Total Duration
The number of equal monthly installments required to clear total interest:
M = Math.round( 26,12,500 / 45833.333 ) = Math.round( 57.00 ) = 57 months
Total Interest Paid = X × M = 45833.333 × 57 = ₹26,12,500.00
Total Duration = N + M = 120 + 57 = 177 months
3. Step-by-Step Reverse Calculation (Given M = 48 → Find N)
Step 3.1: Derivation of Quadratic Identity for $N$
Equating monthly installment $X = P / N$ with interest amortization $X = \text{Total Interest} / M$:
P / N = [ (P × R × N) / 2400 ] / M
N² = (2400 × M) / R
Step 3.2: Exact Computation of $N$, $X$, and Total Interest
X = P / N = 55,00,000 / 110.1195 = ₹49,945.74 / month
Total Interest = X × M = 49945.74 × 48 = ₹23,97,395.52
Total Duration = Math.round(N + M) = Math.round(110.12 + 48) = 158 months
0 Comments
If you have any doubts, suggestions , corrections etc. let me know