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.