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.