Hello!
I will be grateful for your help on the issue I have stumbled upon when trying to use the Goal Seek function. Instead of producing a correct value, it throws a truly bizarre number at me. Attachments don't work here, so I will show the numbers and formulas behind them. Please, help me!
a) 29.49
b) 32.84
c) 50%
d) 4.39%
e) 1,257.60
f) ((a/c)*(1+d)) / (i-d)
g) e - h
h) NPV(i, 29.49, 32.84+f)
i) -31777835039998100.00%
Goal Seek
Set cell that contains value g to 0
by changing cell that contains value i. Value at i should become 9.17%
But in my case it's something horrible, as you see.
Thank you!
Bookmarks