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.