Microsoft Excel offers a simple tool to make this task easier: the PMT function. This function allows you to calculate the monthly payments for a loan ... Let's start with the simple example in the ...

Note that this is built into our mortgage calculator spreadsheet template. These functions, FV and NPER, can significantly simplify your financial calculations, saving time and energy on complex math.