Excel GoalSeek Algorithm

Question

Does anyone have code for this algorithm? Any C programming language would be fine, but I prefer C #.

I could try to implement it, but I'm sure I'm not the first ...

edit: This is not homework, this is the question "gimme tez codez": D I just don't want to reinvent the wheel

Answer 1

GoalSeek most likely uses the Bisection method

- , , . , . - , . 1 , 2 [3] [4].

# : XIRR Bisection #

Answer 2

:

https://www.nuget.org/packages/TridentGoalSeek/

IGoalSeekAlgorithm. :

var myAlgorithm = new MyAlgorithm(90463.45M, 200);
var goalSeeker = new GoalSeek(myAlgorithm);
var seekResult = goalSeeker.SeekResult(96178.21M);