The formula for the PMT function is PMT(rate,nper,pv,[fv], [type]). In this tutorial, we want to find the monthly payment. Open Microsoft Excel. Use an existing table or create a table.

It’s one of the Excel functions I wish I knew ... 20 years You can now use the monthly mortgage payment using the following function. =PMT(9.5%/12, 20*12, 5000000) Overall, you can use the ...

More specifically, I will explain the Future Value (FV) and Number of Periods (NPER) functions in Microsoft Excel ... you have a $10,000 loan with a monthly payment of $300, and an annual interest ...

In Excel, functions are simple formulas you type ... The negative 500 and 10,000 values represent a monthly payment of $500 into the investment with an initial payment of $10,000.