Work backwards from a comfortable monthly payment to the largest loan you could take at a given rate and term.
How the Loan Affordability Calculator works
This calculator runs a payment calculation in reverse: you tell it the monthly payment you can comfortably afford, and it solves for the largest loan that payment will support at a given rate and term. A normal loan calculator starts with a loan amount and gives you a payment; this one starts with the payment and gives you the amount, so you set your budget before you ever look at a price tag.
The engine uses the present-value-of-an-annuity formula:
Max loan = P x [(1 + i)n - 1] / [i(1 + i)n]
- P = the monthly payment you can afford (principal and interest only).
- i = the periodic interest rate = annual rate / 12, as a decimal. A 7% APR becomes 0.07 / 12 = 0.0058333.
- n = the total number of monthly payments = years x 12. A 5-year term is 60.
Internally the tool does this:
- Converts your annual rate to a monthly rate (i) and your term to a number of months (n).
- Computes the discount factor [(1 + i)n - 1] / [i(1 + i)n], which is how many dollars of principal each $1 of monthly payment can buy. At 7% over 5 years that factor is 50.502.
- Multiplies your affordable payment by that factor to get the maximum principal.
- If you enter your gross income and existing debts, it also caps the payment by the 28/36 rule so the answer respects debt-to-income limits before it sizes the loan.
Edge cases it handles: a 0% rate (the formula would divide by zero, so it falls back to payment x months); very long terms where the factor flattens out and extra months add little borrowing power; and the gap between principal-and-interest and the full bill, so it reminds you to subtract taxes and insurance first on a mortgage. The result is always a ceiling on the financed amount, never a purchase price - your down payment and closing costs sit on top of it.
Example calculation
Each example below starts with a payment you can afford and works backward to the largest loan it supports. Every figure is recomputed with the formula above.
Example 1 - Car shopper. You can afford $450 a month, a dealer quotes 7% APR, and you want a 5-year (60-month) loan. Here i = 0.07 / 12 = 0.0058333 and n = 60. The factor works out to 50.502, so max loan = $450 x 50.502 = $22,725.90. That is your ceiling on the financed amount, before any down payment or trade-in is added on top.
Example 2 - Home buyer using the 28/36 rule. You earn $6,000 gross per month. The 28% front-end limit caps housing at $1,680. In this simplified principal-and-interest view the full $1,680 goes to P&I at 6.5% over 30 years (n = 360). The factor is 158.211, giving a max loan of $1,680 x 158.211 = $265,794.18. In real life you would subtract property tax, insurance, and any HOA dues from the $1,680 first, which lowers this number - the single most common reason buyers overshoot.
Example 3 - Debt consolidation. You can spare $300 a month for a 4-year (48-month) personal loan at 12% APR. Here i = 0.01 and n = 48. The factor is 37.974, so max loan = $300 x 37.974 = $11,392.19.
| Scenario | Affordable payment | Rate | Term | Max loan |
|---|---|---|---|---|
| Car | $450 | 7% | 5 yr | $22,725.90 |
| Home (28% rule) | $1,680 | 6.5% | 30 yr | $265,794.18 |
| Personal loan | $300 | 12% | 4 yr | $11,392.19 |
Notice how term does the heavy lifting: the same $1,680 over 30 years buys far more principal than it would over 15 years, because each payment is spread across more periods. That is exactly why a longer term raises borrowing power but also stacks up far more total interest - the tradeoff this calculator is built to expose.
Tips for using the Loan Affordability Calculator
- Enter only principal and interest, not the full bill. On a mortgage, subtract property tax, homeowners insurance, PMI, and HOA dues from your affordable payment first, or the tool will overstate the loan by tens of thousands. Feeding $1,680 in full instead of $1,280 after escrow can inflate your ceiling by roughly $63,000 at 6.5% over 30 years.
- Run the 28/36 rule as a hard cap, not a target. The 28% front-end limit (housing) and 36% back-end limit (all debt) are ceilings lenders underwrite to, not goals; aim well below them so a rate reset or income dip does not corner you.
- Build the payment from take-home pay, not gross. Lenders qualify you on gross income, but you make payments from your net deposit. Re-run the calculator using a payment you could actually cover from your paycheck after taxes and retirement contributions.
- Stress-test the rate before you set a price. On a 30-year loan, one extra percentage point cuts the max loan by roughly 10% - a $2,500 payment supports about $416,979 at 6% but only $375,769 at 7%. Bump the APR up 1-2 points and shop to the lower ceiling.
- Resist stretching the term just to qualify for more. Going from a 5-year to a 7-year car loan at 7% only raises a $500 payment's ceiling from $25,251 to $33,129, but it keeps you underwater (owing more than the car is worth) for far longer.
- Leave a maintenance buffer inside the payment. A home runs roughly 1% of value per year in upkeep and a car needs tires, brakes, and repairs; subtract that from your affordable payment before you calculate, so the ceiling reflects ownership, not just the loan.
- Treat the result as a ceiling, not an approval. This formula ignores credit score, employment history, down payment, and your full DTI - all of which a lender weighs - so a strong number here does not guarantee the loan.
- Cross-check existing debts against your 36% back-end room before you shop, using the debt-to-income ratio calculator, since a $500 car payment already consumes part of the limit before housing is counted.
- If you have a target purchase price, confirm it the other way too: take the ceiling from this tool into a forward loan or mortgage calculator to verify the payment lands inside the budget you started with here.
- Keep your emergency fund out of the math entirely. The affordable payment should be what is left after you have already funded savings, retirement, and a cash cushion - never money you would have to pull from those to cover.
Affordability calculator vs forward loan calculator: which to use
Use this calculator when you know your monthly budget but not your price; use a forward calculator when you know the price but not the payment. They are mirror images of the same annuity equation, so picking the right starting point is the whole point.
| Loan affordability calculator | Forward loan / mortgage calculator | |
|---|---|---|
| You input | Affordable monthly payment, rate, term | Loan amount, rate, term |
| You get | Maximum loan that payment supports | Monthly payment for that loan |
| Best for | Setting a budget before you shop | Checking a specific price tag |
| Risk it guards against | Shopping above your means | Payment shock on a chosen loan |
A smart workflow uses both: start here to set your ceiling, then plug that ceiling into the mortgage calculator or loan calculator to confirm the payment lands where you expected. If you are car shopping, the auto loan calculator does that forward check. Because both use the same math, the two answers always reconcile - if they do not, you entered different inputs somewhere.
How it pairs with the 28/36 rule and your DTI
The 28/36 rule is the guardrail that turns a raw payment into a responsible one: keep housing costs at or under 28% of gross monthly income and all debt payments at or under 36%. This calculator only respects that rule if you feed it the capped payment, so the rule comes first and the loan size comes second.
Say you earn $6,000 gross per month. The 28% front-end limit is $1,680 for housing. The 36% back-end limit is $2,160 for all debt combined; if you already pay $400 toward a car and credit cards, only $1,760 is left for housing under that limit. You take the lower of the two ceilings - $1,680 - and feed that into this calculator, not whatever payment feels comfortable.
This is the single biggest reason an affordability calculator beats eyeballing a price tag: it forces the loan size to flow from a ratio lenders actually underwrite to, rather than from wishful thinking. Confirm your starting ratios with the debt-to-income ratio calculator before you commit, because every dollar of existing debt quietly shrinks the housing payment - and therefore the loan - you can support.
Why you should borrow less than the maximum
The maximum loan is a ceiling, not a recommendation - the safe number usually sits 10-20% below it. The formula only accounts for principal and interest, but real ownership costs do not stop there, and they are exactly what the affordability math leaves out.
- Taxes and insurance: property tax, homeowners or auto insurance, and PMI ride on top of every loan payment and are never part of the principal-and-interest figure you entered.
- Maintenance: a home runs about 1% of value per year; a car needs tires, brakes, and repairs as it ages.
- Emergencies: a roof leak or transmission failure should not force you to skip a payment, so leave slack the formula never reserves.
- Life changes: a baby, a move, or a variable-rate reset can raise costs fast against a maxed-out payment.
Worked example: a $600 budget fully committed at 8% over 6 years borrows about $34,221; commit only 80% ($480) and you borrow about $27,377 but keep $120 a month free for surprises. A loan you can carry on a bad month, not just a perfect one, is the one to take. Keep your emergency fund fully funded before you stretch toward the ceiling.
Common mistakes that inflate your maximum
Most people overstate their borrowing power by feeding this calculator an optimistic payment. Each of these mistakes pushes the ceiling up without changing what you can actually afford:
- Using the full housing payment as P&I. On a mortgage, taxes and insurance can be 20-30% of the bill. Entering $2,000 as principal and interest when $400 of it is really escrow overstates the loan by about $60,123 at 7% over 30 years.
- Calculating off gross income. You qualify on gross but pay from net. Build the payment from your actual take-home figure - the take-home pay calculator shows what really lands in your account.
- Ignoring existing debts. A $500 car payment already eats into your 36% back-end room before housing is even counted, so the loan this tool returns may be one no lender will grant.
- Confusing loan size with purchase price. This tool sizes the loan only; closing costs and the down payment are separate cash you must bring on top.
- Assuming the ceiling equals approval. Credit score, employment history, and full DTI still decide the outcome regardless of what the math allows.
How to do it by hand or in Excel
The fastest spreadsheet route is the PV (present value) function, which is the affordability formula built into Excel and Google Sheets.
To find the max loan for a $450 payment at 7% over 5 years, type:
=PV(0.07/12, 60, -450)
That returns $22,725.90 - the same answer as this calculator. The arguments are: rate per period (annual rate / 12), number of periods (years x 12), and the payment as a negative number, because it is cash leaving you. To go the other direction and check the payment on a known loan, use =PMT(0.07/12, 60, 22725.90), which returns about -$450.
By hand, compute the factor [(1 + i)n - 1] / [i(1 + i)n] first, then multiply by the payment. For the car: i = 0.0058333, n = 60, factor = 50.502, so 450 x 50.502 = $22,725.90. PV and PMT are simply two views of the same equation - PV solves for the loan when you fix the payment (affordability), PMT solves for the payment when you fix the loan (forward) - which is why this tool and a forward calculator always agree.
Is your number good? Affordability benchmarks
A loan is in healthy territory when its payment keeps your total debt load under 36% of gross income and ideally under 28% for housing alone. Because this calculator ignores those ratios, check the payment you entered against these bands before you trust the ceiling:
| Metric | Comfortable | Stretched | Risky |
|---|---|---|---|
| Housing as % of gross (front-end) | Under 28% | 28-33% | Over 33% |
| All debt as % of gross (back-end) | Under 36% | 36-43% | Over 43% |
| Car payment as % of take-home | Under 10% | 10-15% | Over 15% |
The 43% back-end figure matters because it is a common threshold above which many lenders tighten or decline. If the payment you fed in pushes you past these bands, lower the payment, extend the term cautiously, or accept a smaller loan. For the cash side of a purchase, the down payment calculator handles the money you bring up front, which is a separate question from the loan size this tool returns.
How rate and term change your borrowing power
For a fixed payment, a lower rate or a longer term both raise the maximum loan - but they do it for different reasons and at very different costs.
Hold the $1,680 housing payment over 30 years and watch the rate move: at 5.5% the max loan is about $295,885; at 6.5% it drops to $265,794; at 7.5% it falls to $240,270. That is roughly a $55,615 swing in buying power from a 2-point rate change, with no change to your budget at all - which is why you should re-run this tool whenever quoted rates shift before you lock in a price.
Term is the other lever, and it works in the same direction for affordability. The same $450 car payment at 7% supports about $18,792 over 4 years, $22,726 over 5 years, and $26,394 over 6 years: a longer term raises the ceiling because each payment is spread across more months. The catch is total interest - those extra two years on the 6-year loan add far more cost than the $7,602 of extra borrowing power suggests. Lengthening a term to qualify for more is the most expensive way to raise your ceiling, so treat it as a last resort, not a first move.
Maximum loan by monthly payment, rate, and term (quick reference)
Here is how much loan a given monthly payment can support at common rates and terms - all figures are principal only, recomputed using standard present-value math. Read it as a borrowing ceiling, not a budget: your real payment must also cover taxes, insurance, and upkeep, so plan to borrow below these numbers. A higher rate or shorter term shrinks every figure, while a longer term inflates it (and the total interest you pay).
| Monthly payment | 5% / 30 yr | 6% / 30 yr | 7% / 30 yr | 8% / 30 yr | 7% / 5 yr |
|---|---|---|---|---|---|
| $500 | $93,141 | $83,396 | $75,154 | $68,142 | $25,251 |
| $1,000 | $186,282 | $166,792 | $150,308 | $136,283 | $50,502 |
| $1,500 | $279,422 | $250,187 | $225,461 | $204,425 | $75,753 |
| $2,000 | $372,563 | $333,583 | $300,615 | $272,567 | $101,004 |
| $2,500 | $465,704 | $416,979 | $375,769 | $340,709 | $126,255 |
Example read: a $2,000 payment supports about $300,615 at 7% over 30 years, but only $101,004 if you finance over 5 years instead - term swings borrowing power dramatically, which is the lever this calculator makes visible.
Related on this site
Debt-to-Income Ratio Calculator · Mortgage Calculator · Auto Loan Calculator · Down Payment Calculator · Take-Home Pay Calculator · Loan Calculator
For a related deep dive, see CFPB: Buying a house.
Loan Affordability Calculator — frequently asked questions
- Should I borrow the maximum?
- Rarely — leave room for taxes, insurance, maintenance and emergencies.
- Does this guarantee approval?
- No — lenders also weigh credit score, income and debt-to-income ratio.
- Does a high affordability mean I'll be approved?
- No — approval also depends on income, credit and DTI, not just the payment.
- Should I borrow the maximum shown?
- Rarely; a payment you can sustain through job or rate changes is wiser.
- If I can afford $400 a month, how big a car loan can I get at 7% over 5 years?
- About $20,201. The <a href="/loan-affordability-calculator/">loan affordability calculator</a> works backward from your payment: $400 a month at 7% for 60 months supports a loan of roughly $20,201 in principal. A higher rate or shorter term lowers that figure, while a longer term raises it. This is your borrowing ceiling, not a purchase budget - leave room for tax, title, and fees on top.
- How much house can a $2,000 monthly payment buy at 7% over 30 years?
- Roughly $300,615 in loan principal. A $2,000 payment at 7% over 360 months backs about $300,615 of mortgage. But that $2,000 must cover principal and interest only - if $400 of your real budget goes to property tax and insurance, then only $1,600 funds the loan, which drops your borrowing power to about $240,492, a $60,123 difference.
- Does the loan affordability calculator guarantee I will be approved for that amount?
- No - it only shows the maximum a payment can support, not what a lender will grant. Approval also depends on your credit score, verified income, employment history, and total <a href="/debt-to-income-ratio-calculator/">debt-to-income ratio</a>. Two people with identical budgets can get very different offers. Treat the result as an upper bound for shopping, then expect a lender to approve that or less.
- How does the 28/36 rule limit the loan amount the calculator gives me?
- The 28/36 rule caps your payment first, which then caps the loan. On $6,000 monthly gross income, 28% allows up to $1,680 for housing and 36% allows $2,160 for all debt combined. You feed the smaller safe payment - not an optimistic one - into the tool. At $1,680 and 6.75% over 30 years, that supports roughly $259,020, well under what raw budgeting might tempt you toward.
- Why should I borrow less than the maximum the calculator shows?
- Because the maximum leaves no cushion for the real costs of ownership. The tool sizes a loan to a bare payment, ignoring property tax, insurance, maintenance, repairs, and emergencies. If you commit a $600 budget fully at 8% over 6 years you can borrow about $34,221; commit only 80% ($480) and you borrow about $27,377 but keep $120 a month free for surprises - a far safer cushion.
- How much does a 1% higher rate cut my borrowing power on a $2,500 payment?
- About $41,210 less over a 30-year term. A $2,500 monthly payment supports roughly $416,979 at 6% but only $375,769 at 7% - a $41,210 drop from one percentage point. Rate moves your ceiling sharply on long loans, so rerun the <a href="/loan-affordability-calculator/">affordability calculator</a> whenever quoted rates change before you set a price target.
- How do I calculate maximum loan from a payment in Excel?
- Use the PV function: =PV(rate/12, years*12, -payment). For $400 a month at 7% over 5 years, enter =PV(0.07/12, 60, -400), which returns about $20,201. Enter the payment as a negative number so the result is positive. This is the same present-value math the <a href="/loan-affordability-calculator/">affordability calculator</a> runs, just done in a spreadsheet.
- How is the loan affordability calculator different from a regular loan calculator?
- It runs the math in reverse. A standard <a href="/loan-calculator/">loan calculator</a> takes a loan amount and gives you the payment; the affordability calculator takes the payment you can handle and gives you the maximum loan. Use the affordability tool when you know your budget but not your price, and the loan calculator once you have a specific amount in mind.
- Is the loan affordability calculator the same as a down payment calculator?
- No - they answer different questions. The affordability calculator turns a monthly payment into a maximum loan amount you can finance. A <a href="/down-payment-calculator/">down payment calculator</a> tells you the upfront cash a purchase requires and how it shrinks the loan. Use affordability to find your borrowing ceiling, then add your down payment to estimate the total price you can target.
- How much more can I borrow on a 30-year term versus 15-year at a $1,000 payment?
- About $39,052 more. At 7%, a $1,000 monthly payment supports roughly $111,256 over 15 years but about $150,308 over 30 years. The longer term raises your borrowing power but greatly increases total interest paid, since you carry the balance twice as long. Stretching the term to qualify for more is a real cost, not free room.
- With $7,000 income and $800 in monthly debts, how much can I borrow at 6.5%?
- Your safe housing payment is about $1,720, supporting roughly $272,123 over 30 years. The 36% back-end rule allows $2,520 for all debt; subtract your $800 in existing payments and $1,720 is left for housing. Feeding $1,720 into a 6.5%, 30-year calculation yields about $272,123 of loan. Existing debt directly steals from your borrowing ceiling.
- Is a 7-year auto loan worth it just to borrow more car?
- Usually not - the extra borrowing power comes with more interest and longer risk of being underwater. A $500 payment at 7% buys about $25,251 over 5 years but $33,129 over 7 years, roughly $7,878 more car. Yet you pay interest two extra years and may owe more than the car is worth for most of the term. Borrow shorter when you can.
- How much can I borrow with a $500 payment if the loan is 0% promotional financing?
- Exactly $30,000 over 5 years, because no interest means payment times months equals the loan. At 0%, $500 for 60 months is simply $500 x 60 = $30,000. Compare that to about $25,251 at 7% over the same term - a true 0% offer adds about $4,749 of borrowing power. Confirm the rate is genuinely 0% and not a teaser that resets later.
- What counts as a good DTI to actually get approved at my calculated max?
- A back-end DTI at or below 36% is widely seen as comfortable, and many lenders draw a harder line near 43%. The affordability calculator ignores DTI entirely, so a payment it accepts may still push you over a lender's limit. Run your numbers through a <a href="/debt-to-income-ratio-calculator/">DTI calculator</a> first; if you are above 36%, expect a smaller approval than the affordability max.
- How much can I borrow if I cap my payment at 28% of a $7,500 income at 6.75%?
- About $323,775 over 30 years. The 28% front-end rule on $7,500 monthly income gives a $2,100 housing payment; at 6.75% over 360 months that supports roughly $323,775 of principal. Remember this $2,100 must absorb tax and insurance too, so the financeable loan is lower in practice - treat $323,775 as a ceiling, then trim for those costs.
Guides & articles
- How Much Can I Borrow From a Monthly Payment? Work Backward
- How Much Should I Borrow vs. How Much Can I Borrow?
Related calculators
Mortgage Calculator · Loan Calculator · Auto Loan Calculator · Student Loan Calculator · Home Equity Loan Calculator · Business Loan Calculator