# How to Calculate Your Mortgage Payment: Fixed, Variable, and More

## Calculations and Free Spreadsheets

Understanding your mortgage helps you make better financial decisions. Instead of just taking hoping for the best, it pays to look at the numbers behind any loanâ€” especially a significant loan like a home loan.

To calculate a mortgage, youâ€™ll need a few details about the loan. Then, you can do it all by hand or use free online calculators and spreadsheets to crunch the numbers.

Most people only focus on the monthly payment, but there are other important details that you need to pay attention to.

This article shows you:

- How to calculate the monthly payment for several different home loans.
- How much you pay in interest monthly, and over the life of the loan.
- How much you actually pay offâ€”or how much of your house youâ€™ll actually own at any given time.

### The Inputs

Start the process by gathering information needed to calculate your payments and other aspects of the loan. You need the following details:

- The
**loan amount**or â€œprincipal." This is the home purchase price, minus any down payment, although other charges may be added to the loan. - The
**interest rate**on the loan. This is not necessarily the APR, which also includesÂ closing costs. - The
**number of years**you have to repay, also known as theÂ term - The
**type of loan**: fixed-rate, interest-only, adjustable, etc. - The
**market value**of the home - Your
**monthly income**

### Calculations for Different Loans

The calculation you use will depend on the type of loan you have.

Most home loans areÂ fixed-rate loans. For example, standardÂ 30-year or 15-year mortgages keep the same interest rate and monthly payment for the life of the loan.

For those loans, the formula is:

Loan Payment = Amount / Discount Factor

orP = A / D

Youâ€™ll use the following values:

- Number of Periodic Payments (
**n**) = Payments per year times number of years

- Periodic Interest Rate (
**i**) = Annual rate divided by number of payments per - Discount Factor (
**D**) = {[(1 + i) ^n] - 1} / [i(1 + i)^n]

* Example:*Â Assume you borrow $100,000 at 6 percent for 30 years, to be repaid monthly. What is the monthly payment (

**P**)? The monthly payment is $599.55.

- n =Â
**360**Â (30 years times 12 monthly payments per year) - i = .
**005**Â (6 percentÂ annuallyÂ expressed as .06, divided byÂ 12 monthly paymentsÂ per year. For more details, see how toÂ convert percentages to decimal format) - D =Â
**166.7916**Â ({[(1+.005)^360] - 1} / [.005(1+.005)^360]) - P = A / D = 100,000 / 166.7916 =Â
**599.55**

Check your math with theÂ Loan Amortization CalculatorÂ spreadsheet.

### How Much Interest Do You Pay?

Your mortgage payment is important, but you also need to know how much you lose to interest each month. A portion of each monthly payment goes toward your interest cost, and the remainder pays down your loan balance. Note that you might also have taxes and insurance included in your monthly payment, but those are separate from your loan calculations.

An amortization table can show youâ€” month-by-monthâ€”exactly what happens with each payment. You can create amortization tables by hand, or use a free onlineÂ calculatorÂ and spreadsheetÂ to do the job for you.

Take a look at how muchÂ totalÂ interest you pay over the life of your loan. With that information, you can decide if you want to save money by:

- Borrowing less (by choosing a less expensive home or making a larger down payment)
- Paying extra each month
- Finding a lower interest rate
- Selecting a shorter-term loan (15 years instead of 30 years, for example)

### Interest-Only Loan Payment Calculation Formula

Interest-only loansÂ are much easier to calculate. For better or worse, you donâ€™t actually pay down the loan with each required payment. However, you can typically pay extra each month if you want to reduce your debt.

* Example:*Â Assume you borrow $100,000 at 6 percent, using an interest-only loan with monthly payments. What is the payment (

**P**)? The payment is $500.

Loan Payment = Amount x (Interest Rate / 12)

orP = A x i

P = $100,000 x (.06 / 12)

P = $500

Check your math with the Interest Only CalculatorÂ on Google Sheets.

In the example above, the interest-only payment is $500, and it will remain the same until:

- You makeÂ additionalÂ payments, above and beyond the required minimum payment. Doing so will reduce your loan balance, but your required payment might not change right away.
- After a certain number of years, youâ€™re required to start makingÂ amortizingÂ payments to eliminate the debt.
- Your loan may require a balloon paymentÂ to pay off the loan entirely.

### Adjustable-Rate Mortgage Payment Calculation

Adjustable-rate mortgages (ARMs) feature interest rates that can change, resulting in a new monthly payment. To calculate that payment:

- Determine how many months or payments are left.
- Create a new amortization schedule for the length of time remaining (see how to do that).
- Use the outstanding loan balance as the new loan amount.
- Enter the new (or future) interest rate.

** Example:** You have a hybrid-ARM loan balance of $100,000, and there are ten years left on the loan. Your interest rate is about to adjust to 5 percent. What will the monthly payment be? The payment will be $1,060.66.

### Know How Much You Own (Equity)

Itâ€™s crucial to understand how much of your home you actually own. Of course, you own the homeâ€”but until itâ€™s paid off, your lender hasÂ an interest or a lien on the property,Â so itâ€™s not free-and-clear. The amount thatâ€™s yours, known as your home equity, is the homeâ€™s market value minus any outstanding loan balance.

You might want to calculate your equity for several reasons.

**YourÂ ****loan-to-value (LTV) ratio**Â is critical because lenders look for a minimum ratio before approving loans. If you want to refinance or figure outÂ how big your down payment needs to be on your next home, you need to know the LTV ratio.

**Your net worth**Â is based on how much of your home you actually own. Having a one million dollar home doesnâ€™t do you much good if you owe $999,000 on the property.

**You can borrow against your home**Â using second mortgages andÂ home equity lines of credit (HELOCs). Lenders often prefer an LTV below 80 percent to approve a loan, but some lenders go higher.

### Can You Afford the Loan?

Lenders usually offer you the largest loan that theyâ€™ll approve you for using their standards for an acceptableÂ debt-to-income ratio. However, you donâ€™t need to take the full amountâ€”and itâ€™s often a good idea to borrow less than the maximum available.

Before you apply for loans or visit houses, look at your monthly budget and decide how much youâ€™re comfortable spending on a mortgage payment. After youâ€™ve made a decision, start talking to lenders and looking at debt-to-income ratios. If you do it the other way around, you might start shopping for more expensive homes (and you might even buy oneâ€”which affects your budget and leaves you vulnerable to surprises). Itâ€™s better to buy less and enjoy some wiggle room than to struggle to keep up with payments.

Learn more about how toÂ borrow without going broke.