Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Goal Seek returning different results
I am using Goal Seek to determine an interest rate for an investment stream
that returns a zero. The investment is irrgular in amount but the period is annual for each transaction. My problem is I am getting different answers depending on the source of the numbers. BUT the imported investment stream is the same regardless of the source. If I run it from one source Goal Seek returns 3.1362%. If I flip to the "other" source, Goal Seek returns 3.2072% I am stymied as to why there are different results depending on identical sources. Below is the investment stream 8,616.77 8,616.77 8,616.77 8,616.77 8,616.77 8,616.77 8,616.77 8,616.77 8,616.77 8,616.77 8,616.77 8,616.77 8,616.77 8,616.77 8,616.77 8,616.77 3,269.89 2,062.33 940.42 -165.44 -18,279.87 -20,304.66 -22,524.53 -25,033.38 -27,804.93 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please Help With Goal Seek | New Users to Excel | |||
vba GOAL SEEK | New Users to Excel | |||
Goal Seek | Excel Discussion (Misc queries) | |||
How to use goal seek | Excel Worksheet Functions | |||
Goal Seek | Excel Discussion (Misc queries) |