Excel Payment (PMT) function and goal seek

Описание: This step-by-step video demonstrates an Excel payment (PMT) function given a loan amount, annual interest rate, and # of years. The PMT function is written to yield a monthly payment. Then, goal seek is used to find a loan amount that yields a monthly payment $3,500.