How this instrument works
A personal loan carries no collateral — no car, no house, no gold sits behind it — so a lender prices that added risk into the deal twice: once inside Annual interest rate, %, and again as a one-time Processing fee, % of loan taken straight out of Sanctioned loan amount, ₹ before a rupee reaches the borrower. That second charge is why Net amount disbursed, ₹ comes in smaller than the figure on the approval message, even though Equated Monthly Installment (EMI), ₹ is computed against the full sanctioned figure, fee included, and repaid in full regardless of how much cash actually landed in the account.
The distortion this creates is sharper here than on a longer loan, because Loan tenure, months for a personal loan usually runs in the dozens, not the hundreds. Spread the same 2% charge across a 240-month mortgage and it barely moves the true annual cost; spread it across the 36 months typical of a debt-consolidation or medical-expense loan and the effect concentrates hard. On the case worked below — ₹500,000 at a quoted 12% for 36 months with a 2% fee — the quoted rate and the rate the borrower actually pays diverge by roughly 1.4 percentage points once that upfront deduction is weighed against the cash actually received, a gap a 20-year loan at the identical fee percentage would barely register.
This sheet prices one flat, one-time fee against reducing-balance interest and nothing else. It excludes tax charged on that processing fee (common practice among lenders that levy GST on the charge itself), any loan-protection insurance premium bundled into the disbursed amount, and prepayment or foreclosure charges a lender may apply if the loan is closed early. It also does not compute an annualized effective rate as a labeled output — that figure has to be reasoned out from Equated Monthly Installment (EMI), ₹ and Net amount disbursed, ₹ together, the way the worked example below does.
- Enter the amount your lender approved under Sanctioned loan amount, ₹ — the figure on the approval letter, not what you expect in hand.
- Set Annual interest rate, % to the lender's quoted yearly rate, and Loan tenure, months to the repayment length in months, not years.
- Enter the lender's one-time charge under Processing fee, % of loan — deducted from the loan, never added on top of it.
- Read Equated Monthly Installment (EMI), ₹ for the fixed monthly repayment, and Net amount disbursed, ₹ for what actually reaches the account.
- Change Processing fee, % of loan on its own and watch Net amount disbursed, ₹ move while Equated Monthly Installment (EMI), ₹ stays exactly fixed.
Worked example — ₹500,000 for 36 months at 12%
Take the golden case: Sanctioned loan amount, ₹ at 500,000, Annual interest rate, % at 12, Loan tenure, months at 36, and Processing fee, % of loan at 2. The monthly rate is r = 12 divided by 1200, or 0.01, and 1.01 raised to the 36th power works out to roughly 1.43077, which the formula turns into Equated Monthly Installment (EMI), ₹ = 16,607.15 — the exact figure this instrument returns for those four inputs.
The processing fee never touches that number. It only touches Net amount disbursed, ₹, which is 500,000 times (1 minus 2 divided by 100), or 490,000.00 — ten thousand rupees short of the sanctioned figure, even though the EMI keeps being calculated against the full ₹500,000 for all 36 months. Measured against the ₹490,000 actually received rather than the ₹500,000 borrowed on paper, the same repayment stream implies a rate closer to 13.4% a year than the 12% quoted, the gap this sheet is built to expose.
Questions
Why is my EMI calculated on the sanctioned amount instead of what I actually receive?
Because the debt is the sanctioned figure, not the smaller sum that lands in the account — the processing fee is a deduction from the loan, not separate cash you never borrowed. Equated Monthly Installment (EMI), ₹ reflects the full ₹500,000 in the worked example, fee included, while Net amount disbursed, ₹ shows only what actually reached the borrower, ₹490,000 in that same case.
Why do personal loans carry a higher processing fee than a car loan or a mortgage?
A personal loan is unsecured — no vehicle, property, or deposit backs it — so a lender has no asset to recover if repayment stops. That extra risk gets priced in twice: partly through Annual interest rate, %, and partly through a one-time Processing fee, % of loan that typically runs a full percentage point or two above the fee on a secured car or home loan of comparable size.
Does a longer loan tenure make the processing fee matter less?
Yes. The fee is charged once, so spreading it across more months of Equated Monthly Installment (EMI), ₹ dilutes its effect on the loan's true annualized cost. A 2% fee on a 36-month personal loan concentrates into a noticeably higher effective rate than the same 2% fee would on a 240-month home loan, where the identical charge barely moves the yearly figure at all.
How much higher is my real borrowing cost than the quoted annual rate?
On the ₹500,000, 12%, 36-month, 2%-fee example here, the quoted rate and the rate implied by what was actually disbursed diverge by roughly 1.4 percentage points — closer to 13.4% than 12% once the ₹10,000 fee is weighed against the ₹490,000 actually received rather than the ₹500,000 borrowed. A smaller fee, a lower rate, or a longer tenure would narrow that gap; a steeper fee on a shorter loan widens it further.
Does the processing fee shown here include tax or bundled insurance?
No. This sheet models one flat, one-time Processing fee, % of loan deducted from Sanctioned loan amount, ₹ and nothing else. Tax charged on that fee, a loan-protection insurance premium some lenders fold into the disbursed amount, and any prepayment or foreclosure charge for closing the loan early all sit outside these two figures — check the loan agreement for each separately.
Can this sheet compare two lenders that quote the same rate but different fees?
Yes, and that comparison is exactly why the EMI alone can mislead. Equated Monthly Installment (EMI), ₹ never changes with Processing fee, % of loan, so two lenders quoting an identical rate, tenure, and sanctioned amount will show the same EMI even if one charges a much steeper fee. Net amount disbursed, ₹ is the figure that actually separates a cheaper offer from a costlier one.
References
- Consumer Financial Protection Bureau — Consumer Tools
- Federal Reserve — Consumer Credit statistical release (G.19)
Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.