Home Loan Budget Worksheet: Turning an EMI Into a Monthly Plan
Published 13 October 2026 · 6 min read · Clean EMI Editorial
A home loan budget calculator will give you an EMI figure, but that is only one number. The EMI has to be paid every month alongside groceries, school fees, insurance and the cost of running a home. A simple worksheet turns the EMI into a monthly plan, so the gap shows up before you sign anything. This guide walks through one sample family, using an illustrative rate of 8.5% a year, which is not a bank quote.
Part of the Home Loan guide series.
Step 1: Start with take-home pay, not gross salary
Begin with the money that actually reaches the bank account each month after tax and mandatory deductions. Take the sample family used here: a salaried couple in Lucknow with a combined take-home pay of ₹1,10,000 a month. Their gross pay looks higher, but the EMI is debited from the account, so the worksheet starts with what arrives.
Average the last three salary slips if pay varies. A bonus or allowance that arrives only in some months should not be treated as a fixed monthly amount.
Step 2: Work out the EMI on the loan
For a ₹38 lakh loan over 20 years (240 months) at an illustrative 8.5% a year, the EMI comes to ₹32,977 a month. The total paid over the term is ₹79,14,480, which means ₹41,14,480 of that is interest. The rate is illustrative, not a bank quote. The sanctioned rate and the bank's schedule of charges will set the real figure. You can test your own inputs with the EMI calculator.
Step 3: Build the monthly worksheet
List every outgo against the take-home figure, one line at a time:
- Take-home pay: ₹1,10,000
- Home loan EMI: ₹32,977, which is about 30% of take-home pay
- Groceries, utilities and transport: ₹28,000
- School fees and children's expenses: ₹14,000
- Insurance premiums and medical cover: ₹5,000
- Monthly buffer for repairs, society charges and emergencies: ₹10,000
After these lines, ₹20,023 is left each month.
Step 4: Read the result, not just the total
The sample family has about ₹20,000 left after the EMI and running costs. That is a workable position, but it does not yet include a retirement contribution, a yearly insurance premium or the rise in school fees that tends to come every year. Subtract the items that are missing, then check whether what remains can absorb a change.
A worksheet should show room to absorb a change, not only a month that balances on paper. If the leftover shrinks to near zero after the missing items are added, the loan amount or the tenure needs another look.
Step 5: Stress-test the plan before committing
- Add a 10% rise in running costs and see whether the plan still holds.
- Check what happens if the household runs on one income for a few months.
- On a floating-rate loan, ask the bank how the EMI changes if the rate moves, and rerun the worksheet on that basis.
For a second view on the same question, read how much salary you need for an EMI. The home loan page explains the general process, and the State Bank of India profile shows the bank's own details. The final decision on eligibility and the sanctioned terms rests with the lending bank.
Frequently Asked Questions
What should a home loan budget include besides the EMI?
Groceries, utilities, transport, school fees, insurance, medical costs, society or maintenance charges, and a monthly buffer for repairs and emergencies. Leaving these out makes the EMI look more affordable than it is.
Should the budget start from gross salary or take-home pay?
Take-home pay. The EMI is debited from the bank account, so the worksheet should start with the amount that actually arrives each month.
How much of take-home pay should go to the EMI?
There is no single figure that suits every household. Lenders assess eligibility with their own norms, and a family should also judge how much room remains after living costs. Check the bank's assessment with the lender.
Useful free tools
- Free Credit Analyzer — Upload your CIBIL report and see which loans you may be eligible for, with an indicative EMI.
- Check my Loan Eligibility — Answer a few questions and see how your application would be routed to a PSU bank.
- Home Loan Balance Transfer Calculator — Compare your current EMI with a lower-rate loan over the same remaining tenure.
- Credit Score Enhancer — Practical steps to improve your CIBIL score before you apply for a loan.
Ready to check your eligibility?
No fee to apply. CIBIL score of 700 or above required.