How to Calculate Mortgage Payments - Find Out Today

Computing for mortgage payments is quiteseries of future payments is wortho Fv - the future
complicated. This is why there are a few ways tovalue. The cash value you want to attain after the
compute for it. One is using the spreadsheetpaymento Type - Logical value. 1 = payment at the
application.beginning of the period or 0 = omitted
Here is how to calculate mortgage payments using theTo get the amount applied to the interest, use the
Excel spreadsheet application.IPMT function. Below are the values to enter.o Rate -
First, enter the information below into the topmost cell,the interest rate for the loano Per - period you want to
(which you can change it if you want).o Loan Amountofind the interest. This should be from one to the
Interest Rateo Number of periodsnumber of periodso Nper - the total number of
Next, number each row with each payment. You couldpayments to be madeo Pv - the present value. This is
use the "fill handle" for large numbers.the total amount of the series of future payments is
Then, create columns with the following information.owortho Fv - the future value. The cash value you
Starting loan balanceo Paymento Amount applied towant to attain after the paymento Type - Logical
interesto Amount applied to principalo Remaining loanvalue. 1 = payment at the beginning of the period or 0
balance= omitted
Now, let's enter the formulas.To get the amount applied to the principal, subtract the
Use the PMT function for the calculation of theinterest computed using Ipmt from the payment.
monthly payment. Here is what you need to enter forLastly, subtract the principal paid from the loan balance
this function.o Rate - the interest rate for the loanoto get your new loan balance.
Nper - the total number of payments to be madeo PvTo get the remaining payments, repeat the above
- the present value. This is the total amount of thesteps.