Forum Discussion
sum quotient
I was invited by Mr Kim for help. However, I am not so familiar with Financial Mathematics.
I created a column to create the quotients (C/(1+r)^t), where r is indicated in L1. Changing the value in L1 will give a different sum in L4. So, the user can guess the value of r.
There is a function called "XIRR" which seems to do this type of problem. But, I do not understand the setting.
solving for I2 is - there could be a circular reference in this..
maybe other people can solve this..
good luck
I was invited by Mr Kim for help. However, I am not so familiar with Financial Mathematics.
I created a column to create the quotients (C/(1+r)^t), where r is indicated in L1. Changing the value in L1 will give a different sum in L4. So, the user can guess the value of r.
There is a function called "XIRR" which seems to do this type of problem. But, I do not understand the setting.
Mr. Chan
thank you for helping..
I think what Mr. Behler wanted is to determine first what the value of r is -- this is what's jolting my brain!
anyway I hope He can see something out of this...
many thanks and good health.
Hey thanks a lot for all the help! XIRR is the solution to my problem! (only the dates are a little messed up but I will be able to solve on the basis of XIRR! So thanks a lot for all your suggestions!
welcome - glad to help.
thanks to Mr. Chan, too...
