In this code, C5 is the cell that goal seek is solving for (where it places the result). Excel Solver is a powerful method to solve optimization problem. To do this, right-click on the worksheets tab, select View code, and paste this code into the Code pane. If you have a complex problem which contains multiple equations and multiple constraints and you are asked to find the optimal solution, you should look for Excel's Solver Add-In instead of Goal Seek. As shown in the second case study, it takes time to transform equation of loan payment and calculate the terms without using Goal Seek. It saves a lot of time when it is difficult to derive a formula to calculate unknown value. Goal Seek is very helpful for quickly solving any financial and statistical formula for a single unknown value. Solution : Goal Seek found the solution and it is required to pay 50 monthly payments when $4000 is paid monthly in installment. In By changing cell:, give cell reference of C4 ( Refer figure 2).Make sure it is negative since it is a payment. In Set cell:, enter reference of cell C6.Go to Data tab and then click on What-If Analysis and select Goal Seek.Since C5 is annual interest rate, we need to divide it by 12 Enter formula =PMT(C5/12,C4,C3) in cell C6 (Refer the image above).of Payments (Monthly) and Annual Interest Rate from cell C3 through C5.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |