# How To Figure Out Monthly Mortgage

### Contents

Example: Calculating a Monthly Car Payment in Excel. Calculating a monthly car payment is similar to figuring a monthly mortgage payment. To start, you will need the interest rate, length of loan, and the amount borrowed. For this example, let’s say the car loan is for \$32,000 over five years at a 3.9% interest rate:

When you take out a fixed-rate mortgage to buy or refinance a home, your lender takes three numbers and plugs them into a formula to calculate your monthly payment. Those three numbers are your.

How do I Calculate Monthly Mortgage Interest? – Calculating Your Monthly Mortgage Interest In order to determine how much interest you will be paying per month on your mortgage, In order to calculate your interest on your first month of payment, In order to calculate successive interest.

To calculate your mortgage payment manually, apply the interest rate (r), the principal (B) and the loan length in months (m) to this formula: P = B[(r/12)(1 + r/12)^m)]/[(1 + r/12)^m – 1]. This formula takes into account the monthly compounding of interest that goes into each payment. Determine the principal, rate and mortgage length in months