Tag Archive: PMT

Articles sur le thème : PMT

Mortgage calculator with Excel

In Excel, you can easily create a mortgage calculator with the PMT function Explanation of the PMT function PMT calculates the PayMenT for a loan for a constant interest rate. The arguments of the function are: Rate    The interest rate on the loan. Nper    The total number of payment periods for the loan. Pv  …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/mortgage-calculator-with-excel/