How this instrument works
A home loan's sanction letter names one number — the amount a lender agrees to lend — but a borrower rarely receives that whole sum. Lenders subtract a one-time processing charge before the money moves, so Amount actually disbursed (after fee) is always the sanctioned figure minus that deduction. The instrument here keeps the two numbers separate on purpose: Sanctioned loan amount, $ is the debt you are taking on; Amount actually disbursed (after fee) is the cash that lands in an account or gets forwarded to a seller at closing.
The detail that catches people off guard sits in the third output. EMI (based on the full sanctioned amount) is computed on the sanctioned figure, not the disbursed one — a borrower repays interest on that charge too, even though it never reached them as usable money. Two lenders quoting the same rate, term, and sanctioned amount but different processing percentages will therefore show an identical EMI on paper, while one of them hands over noticeably less cash. Reading the EMI alone hides that gap entirely; only Amount actually disbursed (after fee) reveals it.
This sheet prices the sanctioned principal, a flat one-time processing charge, and reducing-balance interest only. Stamp duty, registration, legal and valuation charges, mortgage insurance premiums, and any tax levied on that processing charge itself are outside what these three outputs cover, and it is treated as deducted once at disbursement rather than financed into the loan balance — a lender that instead adds it on top and lends against it would need a larger Sanctioned loan amount, $ entered here to match.
- Enter the amount your lender approved under Sanctioned loan amount, $ — the figure printed on the sanction letter, not what you expect to receive.
- Set the lender's one-time charge under Processing fee, % of loan; this is deducted from the loan, not added on top of it.
- Enter the lender's quoted yearly rate under Annual interest rate, % and the repayment length under Loan term, years.
- Read Processing fee and Amount actually disbursed (after fee) to see what actually reaches you, then compare it against EMI (based on the full sanctioned amount) below.
- Change Processing fee, % of loan on its own and watch Amount actually disbursed (after fee) move while EMI (based on the full sanctioned amount) stays exactly fixed.
Worked example — a $3,000,000 sanction at a 0.5% fee
Take the sheet's own numbers: Sanctioned loan amount, $ at 3,000,000, Processing fee, % of loan at 0.5, Annual interest rate, % at 8.5, and Loan term, years at 20. That charge is 3,000,000 times 0.5 divided by 100, or $15,000, so Amount actually disbursed (after fee) reads $2,985,000 — the money that actually lands in the borrower's account or gets forwarded to a seller at closing, fifteen thousand dollars short of the figure on the sanction letter.
EMI (based on the full sanctioned amount) does not use that smaller figure. With a monthly rate of 8.5 divided by 1200, or 0.0070833, compounded over 240 months, the formula returns $26,034.70 — worked from the full $3,000,000, not the $2,985,000 that was disbursed. Raise Processing fee, % of loan to 2 instead and Amount actually disbursed (after fee) drops to $2,940,000, yet EMI (based on the full sanctioned amount) holds at exactly $26,034.70, because that charge never enters that formula — only the sanctioned figure, the rate, and the term do.
Questions
Why is my EMI based on the sanctioned amount instead of what I actually received?
Because the debt you owe is the sanctioned amount — the processing charge is not extra cash you borrowed and kept, it is a deduction the lender takes from that same loan before handing over the rest. Amount actually disbursed (after fee) is what reaches you or a seller at closing, but EMI (based on the full sanctioned amount) reflects the loan in full, charge included, which is why the two figures rarely match a first guess.
Does raising the processing fee percentage change my monthly EMI?
No. Processing fee, % of loan only moves Processing fee and Amount actually disbursed (after fee) — it never enters the EMI formula, which uses only Sanctioned loan amount, $, Annual interest rate, %, and Loan term, years. Two lenders quoting the identical rate, term, and sanctioned amount but different fees will show the same EMI on paper, even though one hands you noticeably less cash at disbursement.
What's the real cost gap between a 0.5% and a 2% processing fee on the same loan?
On a $3,000,000 sanction, a 0.5% charge costs $15,000 and a 2% charge costs $60,000 — a $45,000 gap in Processing fee alone, all deducted before Amount actually disbursed (after fee) reaches you. EMI stays fixed at $26,034.70 either way, so that $45,000 difference has to be compared charge against charge, never inferred from the monthly payment.
Should the processing fee be financed into the loan instead of paid upfront?
This sheet assumes the fee is deducted once from the sanctioned amount at disbursement, matching how most lenders structure it. A lender that instead adds the fee on top and finances it would need that larger total entered as Sanctioned loan amount, $, which raises the EMI rather than leaving it untouched — check which structure your loan agreement uses before comparing two offers.
Does the disbursed amount always cover the full purchase price?
Not necessarily. Amount actually disbursed (after fee) shows what the sanctioned loan delivers after the lender's own charge, but a home purchase also carries stamp duty, registration, legal fees, and often a down payment the loan was never meant to cover. Compare the disbursed figure against total cash required at closing, not the property price alone, before assuming the loan bridges the gap.
Why might my lender's actual EMI differ slightly from this sheet's figure?
Small gaps usually trace back to rounding conventions or a day-count method charging interest on an actual calendar rather than a flat monthly rate. A larger gap suggests the quoted rate is not a plain reducing-balance annual rate, or that costs beyond the processing fee modeled here — insurance, legal charges — were folded into what the lender calls the installment; ask for the full amortization schedule and compare it line by line.
References
- CFPB — Loan Estimate and closing cost explainer
- Federal Reserve — Consumer's guide to mortgage settlement costs
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.