Solved

Excel 2007 Using Goal Seek To Determine New Rate

Posted on 2010-11-17
449 Views
Hello,

Please see the attached example.  I apologize for how the data is located but I tried to keep everything on the same rows as the actual spreadsheet.

I would like to know if goal seek can be used with a payment formula in order to take the guess work on adjusting a rate to equal a particular amount.  As it stands, in order to make the calculation result equal the amount required, we are having to enter multiple random rate percentages.  Im hoping someone will have suggestions on how to take the guess work out and thought goal seek might be a solution but I can seem to wrap my head around it with this existing format.

What Im hoping to obtain is some instructions on how to use goal seek in the attached file so that if we want the amount in E74 to equal \$1,880.00 goal seek will automatically change the rate amount in cell E64 to 4.55%.

Thanks!
0
Question by:Escanaba
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 1

Author Comment

ID: 34155763
0

LVL 92

Accepted Solution

Patrick Matthews earned 500 total points
ID: 34155902
Yes, Goal Seek will do this readily.

1) Select Data / Data Tools / What If / Goal Seek from the ribbon

2) In Goal Seek, set e74 to value 1880 by changing cell e64

3) Result is 4.55%
0

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
When we purchase storage, we typically are advertised storage of 500GB, 1TB, 2TB and so on. However, when you actually install it into your computer, your 500GB HDD will actually show up as 465GB. Why? It has to do with the way people and computersâ€¦
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a â€¦