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.