Loan OD & Offset Calculator | EMI vs Prepayment Optimizer
Loan OD/Offset: Multi‑Option Budget Optimizer
Tip: Set your loan to the longest tenure to keep EMI low, then decide how to use your remaining budget via EMI vs Prepay vs OD/Offset strategies.
1) Loan & Budget
Advanced cashflow (optional)
Example: 10 means your budget grows 10% every year.
Formulas used
- Monthly rate: r = (AnnualRate/12).
- EMI (initial N months): EMI = P·r·(1+r)^N / ((1+r)^N − 1).
- OD/Offset interest base: Base = max(0, Balance − Offset).
- Monthly interest: I = Base·r.
- Principal paid: Principal = Payment − Interest (capped at remaining Balance).
- Prepayment (periodic): Balance := max(0, Balance − LumpSum).
- Tenure reduction mode: EMI stays constant; loan closes early when Balance ≤ 0.
- EMI reduction mode: after a prepayment, EMI is recalculated for remaining months.
2) Strategy & Optimizer
Constraints & rules
Best split
—
Best strategy
—
Objective value
—
Loan closure
—
Top 5 found
—
Base EMI
₹ 0
Monthly surplus
₹ 0
Interest saved
₹ 0
Months saved
0
3) Comparison (Baseline vs Best vs Alternatives)
| Plan | Total Interest | Months | Closure Balance Check | Avg Liquidity |
|---|
“Avg Liquidity” is average parked amount in OD/Offset (reserve + parking). For direct prepay mode, liquidity will be low.
4) Charts
Interest saved vs EMI-split ratio (only for ratio-optimizer strategy)
Outstanding balance vs months (best plan)
5) Amortization Schedule (Best Plan)
| Month | Rate % | Budget | EMI Paid | Surplus | Interest | Loan Limit | Offset Balance | Utilized | Reserve |
|---|