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:


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

  2. Thank you for sharing such great information.
    It is informative, can you help me in finding out more detail on
    home loan blog.