How much mortgage can I afford?

Original Size

Loan Carrying Cost: Interest Reduction Techniques

from The Reading Room

You can use this calculator to answer such questions as:

- How much mortgage can I afford?
- What is the mortgage payment?
- How much money do I need to buy a house?
- What is the down payment on a house?

Unlike our general loan or simple loan calculators, this calculator will allow you to have more than one unknown value in certain cases.

To indicate an unknown value, enter '0' (zero).

You can enter the price of the real estate, the down payment percent you need, the total number of periods for which you want to borrow the money and the interest rate. When you click on "Calc", the amount of the loan and the monthly payment will be calculated.

If you enter the loan amount and "0" for the down payment percentage, then the down payment percentage (and down payment amount) will be calculated.

If you enter "0" for the price, a down payment percentage, "0" for the amount of loan, the total periods, the interest rate and the payment you can afford, the calculator will calculate the loan amount and the price you can afford to pay. You can use this calculation to tell you what you can afford to pay and borrow and still stay within a budget.

Auto Loan Calculator. It also accepts six inputs, but it asks for an amount for the down payment rather than a percentage.

You may also like theThis Mortgage Calculator is not limited to solving mortgage loan problems of course. It can be a useful tool whenever money is borrowed to purchase an asset and the down payments is expressed as a percent.

Please tell me how you use this calculator. Are you using it personally or professionally? What feature is important to you? If it didn't meet your needs, why? Your feedback will help me make improvements. Complete sentences aren't necessary! :)

Your columns are mixed up.

The interest and the principal columns are wrong which is causing numbers to be incorrect.

You’re referencing the print preview? The numbers aren’t wrong there. Using the default example, click on calc and then print preview. I see the following number for interest and principal for the first payment.

1,516.67 interest

922.43 principal

The loan amount is $280,000 @ 6.5% interest rate.

(6.5 / 100 / 12) * 280,000 = 1516.667

Also, check the last running total of the principal column, the total equals the loan amount i.e $280,000.

Or were you talking about something else?

How can I enter the payment dates in the payment schedule?

If you want to enter payments as they are made (to determine exact loan balance or to handle extra or missed payments) then you can use this

Time Value of Money Calculator. (This is a more flexible calculator but it will take time to learn. Please scroll to the bottom of the page for 25 tutorials.)If you just want to specify the loan’s origination date and first payment date and have the other payments on a regular schedule then you can use this

amortization table, which I see you have already found.Why don’t the calculators auto-complete with the correct calculations once the required fills are filled in. It would lead to a much smoother user experience. Additionally, the errors that pop up when the calculator cannot calculate are vague, it would be helpful if they could pinpoint the exact source of error. Thank you!

Hi Rachel, so there are 2 questions / issues here. I’ll take the 2nd one first.

As to the messages being vague, that should be very easy for me to fix. The problem is, they are not vague to me! Can you copy / paste here and tell me what isn’t clear and I’ll reword an update. I guess you keep seeing the message because they aren’t clear. The basic point to remember is, a user never types anything except for a number or the decimal character. And a user should use backspace to delete.

As to the calculator auto calculating rather than clicking on the calculate button, that might be a future enhancement, but it’s tricky because many calculators can solve for multiple unknowns and there also does not need to be an unknown. Lets’s say a user wants to create a schedule with a specific payment amount which is not the normal payment amount and they want to have a term that results in a final larger balloon payment. Now they enter all their values and has they get to the payment amount, it has been calculated by the calculator because it previously had been 0. That means they have to clear out the just calculated value. That’s not ideal either.

Probably the best thing is to let the user type Alt-C to calculate?

Thanks for your comments and hope to hear what text you find not to be clear.