How Much EMI Can I Afford: A Simple Worksheet

You're asking the wrong first question

Almost every first-time buyer starts their home search by asking, "How much loan can I get?" It feels like the natural first step — call a bank, get a sanction letter, and now you know your budget. But that number answers a different question than the one that actually matters for your life: how much loan can I get, versus how much EMI can I actually live with, month after month, for the next 15 to 20 years?

Lenders calculate eligibility based on formulas like FOIR (Fixed Obligation to Income Ratio) that look at your income and existing debts and arrive at a maximum they're willing to lend. That maximum is designed to protect the lender's risk, not to protect your lifestyle. It's entirely possible to be "eligible" for an EMI that leaves you stressed every month — cutting into savings, delaying other goals, or leaving no room for anything going wrong.

This article gives you a different starting point: a simple worksheet you can fill in yourself, using your own income and your own fixed costs, to arrive at a safe EMI number before you ever start house-hunting. Once you have that number, you flip the usual process around — instead of shopping for the biggest loan you're eligible for, you shop for a home whose EMI fits the number you already know is comfortable.

Affordability vs. eligibility: two different numbers

Eligibility is what a lender calculates it will offer you, based on your income, existing obligations, credit profile, and its own risk policies. It's a ceiling set by someone else's formula.

Affordability is what you calculate for yourself, based on your actual monthly cash flow — income, fixed unavoidable costs, and the savings rate you're not willing to give up. It's a number you set, grounded in your own life, not a lender's risk model.

The two numbers are often different, and the gap can be significant. A common rule of thumb used across Indian home-loan discussions is that EMI should stay at or below roughly 40% of net monthly income — but this is a general guideline, not a personalized calculation, and real affordability varies enormously by city and by household. According to Knight Frank's Affordability Index (H1 2024, as reported by Outlook Money in August 2024), the EMI-to-income ratio for a typical home purchase varied dramatically across Indian cities — around 51% in Mumbai versus roughly 24% in Pune and Kolkata and about 21% in Ahmedabad — reflecting how differently priced housing markets translate into very different real affordability burdens even for similar incomes. A single flat percentage rule simply doesn't capture that. Your own worksheet, built from your actual numbers, is more reliable than any one-size-fits-all rule.

The worksheet: income minus fixed costs minus savings equals safe EMI

Here's the core arithmetic, step by step:

Step 1 — Start with net monthly income. Use take-home pay after tax, not gross salary. If you have variable income (bonus, freelance), use a conservative average, not your best month.

Step 2 — List every fixed, non-negotiable monthly cost. This includes:

• Existing EMIs (car loan, personal loan, education loan)
• Rent, if you'll continue paying it until possession (common with under-construction purchases)
• Insurance premiums (life, health)
• School or education fees for dependents
• Recurring family support payments
• Existing SIPs or investment commitments you don't want to disrupt

Step 3 — Decide your non-negotiable savings rate. This is the amount you want to keep saving regardless of the new EMI — retirement contributions, an emergency fund top-up, or a SIP you consider untouchable. Many financial planners suggest treating this as a fixed cost, not a "leftover," precisely so a new EMI doesn't quietly erode it.

Step 4 — Subtract fixed costs and savings from income. What's left is your discretionary room — covering groceries, utilities, transport, entertainment, and everything else day-to-day.

Step 5 — Decide how much of that discretionary room you're willing to commit to an EMI. This is a judgment call, not a formula — most people don't want to commit 100% of what's left, since that leaves zero buffer for the unexpected. A conservative approach is to earmark somewhere around half to two-thirds of the remaining discretionary room, keeping the rest as breathing space.

Step 6 — That final number is your safe EMI. Not the lender's maximum. Yours.

The worksheet in numbers: a ₹1 lakh net income example

Notice that this buyer's income (₹1,00,000) would, under a blanket "40% rule," suggest an EMI of ₹40,000. Their actual worksheet — built from real fixed costs, including a rent payment they're still making until possession — lands on a more conservative ₹30,000. That ₹10,000 gap matters enormously over a 20-year loan, both in total interest paid and in month-to-month comfort.

The 40% rule, FOIR, and why city context matters

The "EMI should not exceed 40% of net income" guideline is a widely used starting heuristic, but lenders' actual FOIR calculations can allow for a higher ratio depending on income level, credit score, and other factors — meaning you may be "eligible" for more than the rule-of-thumb suggests. That's exactly the trap: eligibility creeping above what's genuinely comfortable. City context matters too — the Knight Frank data above shows that in a high-cost market like Mumbai, buyers were carrying EMI-to-income ratios around 51% as of H1 2024, well above the traditional 40% guideline, reflecting how expensive housing forces trade-offs, while in a market like Ahmedabad, buyers were at roughly 21%, well under it. If you live in a high-cost metro, it may be worth deliberately building a larger buffer elsewhere in your finances specifically because your local EMI-to-income ratio is likely to run higher than the textbook guideline — a decision best made consciously with your own worksheet, not by default.

A real-world sequence: shopping within the safe EMI

Consider a buyer in a metro city who works the worksheet above and lands on a safe EMI of ₹30,000/month. Instead of first calling banks to find their maximum eligible loan (which, based on income alone, might come out closer to ₹40,000–₹45,000/month), they take their ₹30,000 figure to the EMI calculator and work backward: at current interest rates and a chosen tenure, ₹30,000/month supports a certain loan amount. Combined with their planned down payment, that gives them a realistic target property price — and they shop for homes within that price band from the outset.

The result: they never fall in love with a flat priced for the bank's maximum eligibility, only to feel the pinch every month after possession. Their search is narrower, but every option within it is genuinely affordable by their own definition, not the lender's.

Turning your safe EMI into a target price and deposit

Once you know your safe EMI, the EMI calculator works in reverse for you: enter the EMI you can afford, along with an expected interest rate and tenure, and see the loan amount that supports. Add your planned down payment to that loan amount, and you have your realistic target property price — the number that should actually guide your house-hunting, not the lender's maximum sanction.

This reframing — starting from EMI, not from loan eligibility — is the single biggest mindset shift a first-time buyer can make before starting the search.

Pro tips

• Use net (take-home) income, never gross. Gross income overstates what's actually available every month and inflates every downstream number.
• Include rent until possession if you're buying under construction. Many buyers forget they'll be paying both rent and a pre-EMI or full EMI simultaneously for months or years.
• Treat savings as a fixed cost, not a leftover. If your SIP or emergency fund contribution isn't protected in the worksheet, a new EMI will quietly eat into it first.
• Re-run the worksheet if your income or obligations change before possession, especially for under-construction purchases with long timelines.
• Don't earmark 100% of your discretionary room for the EMI. Keep a genuine buffer — irregular expenses (medical, travel, repairs) always show up eventually.

Common mistakes to avoid

• Starting with "how much loan can I get?" instead of "how much EMI can I live with?" This single ordering mistake is behind most cases of post-purchase EMI stress.
• Using a blanket percentage rule without checking your own city's typical EMI-to-income reality. A rule built for one city can be badly miscalibrated for another, as the Knight Frank city comparison shows.
• Forgetting existing EMIs or informal family support payments when listing fixed costs — these are real and recurring, even if not "official" debt.
• Assuming your income will definitely rise to meet a stretched EMI. Plan for today's income, not a hoped-for future raise.
• Skipping the worksheet because "the bank already told me my eligibility." Eligibility and affordability answer different questions — always run your own numbers too.

Making the worksheet part of your bigger financial plan

A worksheet on paper is a great starting point, but it's most useful when it becomes a living plan you can revisit as your situation changes. The financial planning workspace is built for exactly this — an evolving planning companion (not financial advice) where your safe EMI, income, fixed costs, and target property price can live together and update as your numbers shift.

If you haven't yet defined what you're actually looking for in a home, DrawMagic's AI home-buying companion can help you turn a safe EMI and a rough sense of your needs into a structured requirements brief, so your search stays anchored to a number you know you can live with. All of this — the EMI calculator, the requirements brief — is free to start; sign up for a free account to save your plan, and see pricing if you want more advanced AI-assisted planning tools down the line.

Key takeaways

• Loan eligibility (what a lender will offer) and affordability (what you can genuinely live with) are different numbers — always calculate your own.
• The worksheet is simple: net income, minus fixed costs (existing EMIs, rent, insurance, dependents), minus non-negotiable savings, leaves discretionary room — commit only part of that room to a new EMI.
• A widely used starting guideline caps EMI at around 40% of net income, but real affordability varies hugely by city, so treat it as a rough anchor, not a rule.
• Knight Frank's Affordability Index (H1 2024, via Outlook Money, August 2024) found EMI-to-income ratios ranging from around 51% in Mumbai to roughly 21–24% in Ahmedabad, Pune, and Kolkata — a reminder that a flat percentage rule can badly misfit your city.
• Treat your savings rate as a fixed, protected cost in the worksheet, not something the new EMI can eat into.
• Use the EMI calculator to turn your safe EMI figure into a loan amount and, combined with your down payment, a realistic target property price.
• Shopping within a pre-calculated safe EMI, rather than a lender's maximum eligibility, is the single biggest habit that prevents post-purchase financial stress.
• The financial planning workspace can hold your worksheet as a living, updatable plan alongside the rest of your buying journey.
• Re-run the worksheet whenever your income, obligations, or city-specific costs change, especially across a long under-construction timeline.

Key Takeaways addendum — FAQ

Is the 40% EMI-to-income rule an official regulation? No — it's a widely used general guideline in personal-finance and lending discussions, not a fixed regulatory cap. Actual lender FOIR calculations and your own comfortable number can both differ from it.

Should I include my spouse's income in the worksheet? If you're applying for the loan jointly and genuinely combining household finances, yes — but make sure both incomes are stable and that you're comfortable with both being committed to the EMI long-term.

What if my safe EMI is much lower than what I'm eligible for? That's common and not a problem — it simply means your realistic target property price is lower than the lender's maximum sanction would suggest. It's better to discover that now, through the worksheet, than after years of a stretched budget.

Source referenced: Knight Frank India Affordability Index (H1 2024), via Outlook Money, August 2024 — https://www.outlookmoney.com/real-estate/steady-interest-rates-enhance-home-affordability-knight-frank-india