![]() ![]() This is the number of months that you want to pay off the loan. This is the amount that you want to borrow. Prepare the worksheetįirst, add some labels in the first column to make it easier to read the worksheet. In this example, the monthly payment amount is the goal that you seek. ![]() ![]() The PMT function calculates a monthly payment amount. Let's look at the preceding example, step-by-step.īecause you want to calculate the loan interest rate needed to meet your goal, you use the PMT function. For more information, see Define and solve a problem by using Solver. If you want to accept more than one input value for example, both the loan amount and the monthly payment amount for a loan, you use the Solver add-in. Note: Goal Seek works only with one variable input value. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |