+ Reply to Thread
Results 1 to 4 of 4

Fund Value Calculation

  1. #1
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Fund Value Calculation

    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
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    06-24-2016
    Location
    Slovakia
    MS-Off Ver
    MS Office 365
    Posts
    92

    Re: Fund Value Calculation

    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

  3. #3
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: Fund Value Calculation

    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.

  4. #4
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: Fund Value Calculation

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Provident fund calculation for salary computation
    By jvlkerala in forum Excel General
    Replies: 4
    Last Post: 06-25-2018, 11:13 AM
  2. Investment Fund Formula (need to make)
    By joao1232 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-12-2016, 01:11 PM
  3. Automatically retrieve Mutual Fund Data
    By Habanero Time in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-19-2012, 09:00 PM
  4. Track a fund raiser
    By thatotherguy in forum Excel General
    Replies: 4
    Last Post: 05-04-2010, 06:55 PM
  5. Fund:help
    By khalid79m in forum Excel General
    Replies: 3
    Last Post: 12-26-2006, 08:21 PM
  6. Replies: 3
    Last Post: 02-09-2006, 12:00 PM
  7. [SOLVED] Computing Mutual Fund Diversification
    By [email protected] in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-16-2006, 09:10 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1