Here are the steps to follow in this video lesson:
- Calculate your monthly payment on a loan using =PMT() function
- =PMT() requires three arguments: “Interest Rate” / # of payments per year, “# of payments” over the course of your loan, the “Amount Borrowed.”
- For Goal Seek: Select the cell that contains your formula and then choose Tools – Goal Seek.
- In the “To Value:” box type in your GOAL – e.g. The amount that you want your =PMT() to return.
- In the “By Changing Cell:” select a cell that is referenced in your =PMT() formula.
Find the video lesson that you want – Index to all Excel Video Lessons
“The 50 Best Tips for Excel 2007” DVD is now available to purchase. I invite you to visit my online bookstore for more details.
Link to this post!
