Saturday, August 11, 2012

Calculate Home Loan Monthly Payment Amount

You can use Microsoft Excel to calculate the monthly payment amount for a home loan.



The PMT Function Arguments dialog box shown below:

 

You need to divide the Interest Rate (B15) by 12 to calculate for monthly payments.
You also need to multiply the No of Payments (Nper) (B14) by 12 to calculate for monthly payments.

Download the file: blog_excel_work_files.xlsx from:
http://seanexcel.weebly.com/work-files.html

1 comment:

  1. Great blog! There is lots of good information, not only me but also everyone can understand it easily. payday installment loans

    ReplyDelete