Included in this resource is an Excel workbook demonstrating three applications of Excel's PMT (payment) function: calculating monthly payments for (1) car payment, (2) mortgage payment, and (3) monthly investment payment to reach an investment goal.
This reference guide illustrates how to apply the Excel PMT (payment) function with step-by-step instruction to calculate a monthly car payment, mortgage payment, and a monthly investment payment in order to reach a future investment goal.
This Excel spreadsheet demonstrates how to apply the Excel PMT (payment) function to calculate a monthly car payment, a mortgage payment, and a monthly investment in order to reach a future investment goal. This spreadsheet is to be used in conjunction with the Excel PMT reference guide.