The First-Time Buyer Affordability Worksheet 2026

Before you fall for a listing — the granite countertop, the balcony view, the "just ₹500 more per sq ft" pitch from the sales office — fill one sheet. Not a mood board. Not a wishlist. A worksheet: rows of numbers that convert your actual income and actual savings into an actual, defensible home budget.

Most first-time buyers do this backwards. They fall in love with a flat first, then reverse-engineer a loan amount that makes it "work," then discover in month four of EMIs that "working" meant skipping the emergency fund, the annual vacation, and the insurance renewal. The worksheet in this article is designed to stop that sequence before it starts. It's built for people who are organized, spreadsheet-friendly, and would rather see an honest number today than an unpleasant surprise in 2027.

This isn't vague advice about "living within your means." It's a specific, row-by-row worksheet, with example values, sized for a 2026 Indian metro or tier-1 household — plus a live version at DrawMagic's financial planning workspace that does the arithmetic for you and explains every number it produces.

What a real affordability worksheet must include in India (2026)

Most online "affordability calculators" ask for two numbers — income and property price — and spit out a loan eligibility figure. That's not a worksheet; it's a sales funnel. A real one has to account for the specific texture of Indian home buying:

• EMI ceilings that vary sharply by city. According to the Knight Frank Affordability Index (H1 2024, via Outlook Money), the EMI-to-income ratio for a typical buyer was roughly 51% in Mumbai versus 24% in Pune and Kolkata, and about 21% in Ahmedabad. A worksheet that uses one national "40% of income" rule for every city is already wrong before you've filled in a single cell.
• A national credit backdrop that's expanding, but from a low base. The National Housing Bank's Report on Trend & Progress of Housing in India 2024-25 puts Individual Housing Loans (IHL) at roughly 11.23% of GDP in FY25, and notes housing accounts for close to half of the entire personal-loan segment in the country. Credit is available — but the report also underscores that most first-time buyers are still relatively new to structured mortgage debt, which is exactly why a personal ceiling matters more than a system-wide average.
• One-time acquisition costs that are easy to underestimate. Stamp duty and registration (which vary by state and, in several states, offer a rebate for women co-owners), GST on under-construction property, brokerage, legal and documentation fees, and initial interiors.
• Recurring costs that don't show up on the price tag. Property tax, society/maintenance charges, home insurance, and ongoing upkeep — all separate from your EMI.
• A reserve line that assumes something will go wrong. Job change, medical cost, or a slow quarter for a self-employed spouse.

Step by step: building the worksheet, row by row

Work through these rows in order. Each one depends on the one before it, which is exactly why skipping ahead (straight to "what can I borrow?") produces bad numbers.

1. Net monthly household income. Use take-home pay, not CTC. If it's a dual-income household, use the combined figure but note each partner's share separately — it matters for the reserve calculation later.

2. EMI ceiling. Multiply net income by a ceiling appropriate to your city context. Use the Knight Frank city bands as a cap, not a target — a Mumbai household stretching to 51% has far less room for anything to go wrong than a Pune household holding to 24%. If you're unsure, start conservative (25–30%) regardless of city and revise upward only if reserves and other obligations comfortably allow it. DrawMagic's EMI calculator will show you exactly how a given EMI ceiling translates into a loan amount at current rates and tenures.

3. Loan amount. Feed your EMI ceiling, a realistic tenure (20–25 years for most first-time buyers), and a real, quoted interest rate into the EMI calculator working backward from EMI to principal.

4. Down payment. Banks typically finance up to 75–90% of a property's value depending on ticket size, so your down payment is the remainder — usually 10–25%. Add a margin above the minimum; a thinner sliver of equity means a larger loan and larger EMI for the same house.

5. One-time (upfront) costs. Stamp duty and registration (the stamp duty calculator will give you a state-specific number), brokerage if applicable, legal/documentation, GST if the property is under construction, and a starter interiors budget.

6. Recurring costs beyond EMI. Property tax (the property tax calculator estimates this from your city and property details), monthly society maintenance, annual insurance, and a monthly upkeep allowance.

7. Emergency reserve. A minimum of 6 months of (EMI + recurring costs + essential living expenses), held in a liquid instrument — not invested, not "accessible in theory," genuinely liquid. Single-income metro households should lean toward 9–12 months.

The worksheet itself (fillable, with example values)

Here is the full sheet with example numbers for a household earning ₹1,60,000/month net, in a tier-1 city with a moderate EMI ceiling. Replace every number in the "Your Value" column with your own.

Geographic and demographic specifics

If you're in Mumbai, treat the 51% EMI-to-income figure from Knight Frank as a warning sign, not a benchmark — it reflects what many buyers are actually doing, not what's prudent. Build your own ceiling closer to 30–35% and expect a longer search for a property that fits it. If you're in Pune, Kolkata, or Ahmedabad, the 21–24% figures suggest more headroom, but resist the temptation to spend all of it on EMI; redirect the difference into your reserve and interiors line instead of a larger loan.

Nationally, the NHB's Trend & Progress report shows individual housing credit is growing faster than the overall personal-loan book, which means underwriting is active and lenders are competing for first-time-buyer business — a reasonable moment to shop multiple lenders for rate, not a reason to raise your own ceiling.

Mini scenario: a dual-income Pune couple

Aditi and Rohan, both salaried, bring home a combined ₹1,45,000/month in Pune. Using the Knight Frank Pune band (~24%) as an upper bound, they set their own ceiling more conservatively at 28% — about ₹40,600/month — because they also want to keep contributing to a child-education fund. Running that EMI through the EMI calculator at a 20-year tenure gives them a loan eligibility of roughly ₹44 lakh. Adding a ₹10 lakh down payment (from savings and a small maturing FD), their realistic property budget lands near ₹54 lakh — noticeably below the ₹70 lakh 3BHK they'd initially shortlisted on a property portal. Rather than stretching, they moved their search to a slightly further suburb where ₹54 lakh bought a comparable 2BHK, and redirected the difference into their one-time-cost and reserve rows.

Reading the result: healthy vs. stretched

A healthy sheet looks like this: EMI comfortably under your city-adjusted ceiling, one-time costs fully funded from savings (not borrowed on a personal loan or credit card), and a 6–9 month reserve intact after the down payment and one-time costs are paid — not something you'll "rebuild later."

A stretched sheet looks like this: EMI at or above the ceiling, one-time costs partly financed on short-term debt, and a reserve of a month or two that will need to be rebuilt from the same salary that's now servicing a new EMI. If your sheet looks stretched, the fix is almost never "find a way to make it work" — it's lowering the target property price row and re-running the sheet.

Pro tips

1. Run the sheet before you shortlist, not after. Once you've seen and loved a property outside your number, every subsequent calculation gets biased toward justifying it.
2. Use take-home pay, never CTC, for every income-based calculation — bonuses and variable pay should not anchor your EMI ceiling.
3. Re-run the one-time-cost row with your actual state's stamp duty, not a national average — the gap between states is large enough to change your usable down payment materially.
4. Separate "can afford" from "want to spend." Your ceiling is a cap, not a goal — leaving margin below it is what makes the reserve row realistic.
5. Revisit the sheet after every major life change (job switch, new dependent, rate change) rather than treating it as a one-time exercise.

Common mistakes to avoid

• Sizing the EMI to the loan eligibility a bank offers, rather than to your own ceiling — banks will often approve more than is prudent for your situation.
• Forgetting GST on under-construction properties, then discovering it as a surprise demand from the builder.
• Treating the down payment as "whatever's left in savings" instead of leaving the reserve untouched.
• Ignoring society maintenance and property tax as "small," when together they can equal a meaningful fraction of the EMI itself.
• Assuming a lower interest rate quote will hold through disbursement without re-checking closer to booking.

Bringing it together with DrawMagic's tools

Every row above maps to a free, live tool. Start with the EMI calculator to convert your income ceiling into a loan and property-price range. Move to the stamp duty calculator for a state-accurate one-time-cost figure. Use the property tax calculator to size your recurring bucket honestly. Then take the completed sheet into DrawMagic's financial planning workspace, where the same rows become a living plan — one that updates automatically as your inputs change and gives you an explainable readiness read instead of a single opaque "eligible" number.

All of these tools are free to use, with no sign-up required just to run the numbers — sign up only when you're ready to save your worksheet and track it over time.

Key takeaways

• Build your affordability worksheet before shortlisting properties, not after.
• Set your EMI ceiling using your own city's realistic range (Mumbai ~51%, Pune/Kolkata ~24%, Ahmedabad ~21%, per Knight Frank H1 2024) — and lean conservative.
• Individual housing credit is a growing share of the personal-loan book nationally (NHB, FY25), so lenders are competing — shop rates, but don't raise your own ceiling because credit is available.
• Separate one-time costs (stamp duty, brokerage, legal, GST, interiors) from recurring costs (EMI, property tax, maintenance, insurance, upkeep).
• Fund one-time costs from savings, not short-term borrowing.
• Keep 6–9 months of reserves intact after the down payment and one-time costs are paid.
• Use free tools — EMI calculator, stamp duty calculator, property tax calculator — to populate each row with real numbers.
• Re-run the sheet whenever income, rates, or family circumstances change.
• A stretched sheet is fixed by lowering the target price, not by "making it work."

FAQ

Is this worksheet a substitute for a bank's loan-eligibility check? No. It's a personal-planning tool to help you decide your own ceiling before you talk to any lender. Always confirm final eligibility, rates, and terms directly with your bank or a licensed financial advisor.

Does DrawMagic calculate my exact stamp duty or tax liability? The free tools give planning-grade estimates from public rate structures. Confirm exact, current state stamp-duty rates and any applicable rebates with your state's registration department before transacting.

How often should I redo this worksheet? At minimum, whenever your income changes, before finalizing any property, and again just before loan disbursement, since rates and property prices can shift between shortlisting and closing.

Ready to turn this worksheet into a living plan? Start your affordability plan on DrawMagic and keep it updated as your numbers change.