Direct Data Decisions

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.

Enhance your students' technology application and math skills by integration respective TEKS. Data skills are in very high demand. With this tool, your students can advance their math and technology applications skills by using Excel to plot coordinate points and find number patterns from the grid. As coordinates are entered into the X and Y columns, the coordinate grid dynamically plots the ordered pair. Uses Grade 5 Math TEKS 5.8A, 5.8B and Grade 5 Technology Applications TEKS (new for 2024) 5