Hi,
I need help, please check the screen shot, I want to know what is the formula for Fund value (highlighted red writing) you can see in screenshot, how the value come? what is the formula?
Thanks in Advance
Farhangul
Hi,
I need help, please check the screen shot, I want to know what is the formula for Fund value (highlighted red writing) you can see in screenshot, how the value come? what is the formula?
Thanks in Advance
Farhangul
Hi Farhangul,
it's not question related to Excel at all, but seems like nice challenge to find out formula based on picture, which maybe is not complete
So looking at numbers there is hard to find some trend so my guess is that for year one is formula (Total Saved )*1.07
for rest of years it could be something like (Total Saved)*2*1.07+ Rand()*X
Please let me know when you will have a spreadsheet with formula how far from reality was my guess
Thanks
Have a fantastic day
Hi Thanks for response,
I have received spreadsheet as it is, I also confused, how they calculated?, that's reason I'm here with experts.
Hi Thanks for response,
I have received spreadsheet as it is, I also confused, how they calculated?, that's reason I'm here with experts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks