Mortgage Payment Calculator

Posted on September 13, 2009
Filed Under Finance |

This is just a simple mortgage payment calculator that will help you calculate your monthly payment quickly. This spreadsheet is a continuation of several financial calculator spreadsheets that I created in relation with teaching my nephew learning some built-in excel financial function and use it for her school purposes.

There are many mortgage payment tools available in internet, either online or created in excel spreadsheet provided by bank, financial institution or unrelated parties…. like me :-).

This calculator only uses single excel built-in function, PMT(rate,nper,pv,[fv],[type]), to find out monthly payment of your mortgage. You just fill your yearly interest rate (rate), your loan period (nper), and your mortgage amount (pv). [fv] and [type] are optional. The default of those parameter are zero. If you need the monthly table of your mortgage payment you can download my amortization schedule calculator. And use this calculator as your side reference only since some banks or financial institutions should have other schemes for their mortgage calculation.

You can download the file here.

You can read and download my other templates below :