📊 Monthly Instalment Calculator
Calculate earnings with monthly installment repayments - EMI (Equal Monthly Installment)
📈 Your Lending Summary
💼 PRINCIPAL FLOW
A
Lending Amount
₹0
B
NPA Loss (0%)
₹0
C
Net Principal Received
₹0
C = A - B
📈 INTEREST & FEES
D
Interest Earned (0%)
₹0
D = C × Interest Rate × Days ÷ 360
E
Fees (FF/CF 0%)
₹0
E = C × FF/CF %
F
Net Interest
₹0
F = D - E
💰 FINAL RETURNS
A
Lending Amount
₹0
G
Total Received
₹0
G = C + F
H
Net Profit
₹0
H = G - A
I
Effective Return
0%
I = (H ÷ A) × 100
Total Days
0
Monthly EMI (Gross)
₹0
Monthly Receipt (Net)
₹0
💰 What You Receive Each Month:
Gross EMI
₹0
Fee Deducted
-₹0
✓ Net Received
₹0
Repayment Schedule
| EMI No. | Due Date | Days | Opening Balance | Gross EMI | Principal | Interest | Fee Deducted | Net Received | Closing Balance |
|---|
📌 Important Notes:
- NPA Loss: If 2% default, you lose 2% of principal (₹1,000 on ₹50,000 lent)
- Interest Calculation: Interest is calculated ONLY on the repaid principal (98% = ₹49,000)
- Cumulative Interest Method: Interest = Repaid Principal × Interest Rate × Days ÷ 360 (calculated cumulatively to each EMI date)
- Fees (FF/CF): Calculated on repaid principal only = 3% of ₹49,000 = ₹1,470
- Net Received: (Repaid Principal + Gross Interest) - Fees = (₹49,000 + ₹8,400) - ₹1,470 = ₹55,930
- Net Profit: Net Received - Principal Lent = ₹55,930 - ₹50,000 = ₹5,930
- Absolute Return: (Net Profit ÷ Principal Lent) × 100 = (₹5,930 ÷ ₹50,000) × 100 = 11.86%
- Effective Return (Annualized): Absolute Return × (365 ÷ Total Days) = 11.86% × (365 ÷ 172) = 25.17% p.a.
- EMI: Equal Monthly Installment = (Repaid Principal + Gross Interest) ÷ Tenure Months
- Days Column: Shows cumulative days from disbursement date to each EMI date
- Fair to Borrower: If borrower pays early, they only pay interest for actual days used
- Auto Repayment Date: If disbursement is before 20th, repayment starts 1st of next month. If after 20th, starts 1st of month after next