Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Help with NPV (Excel 2002)

    Hi all,

    I need the financial guru's to assist nme with the NPV function.
    A user mentioned that on the attached sheet the manually (with calculator) work out the NPV to be R24 118.69.

    I've read the help, but I'm not sure what the value are and how to work them out before I can slot them into the function!

    Can you please help using the attachment!

    Many thanx
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Help with NPV (Excel 2002)

    Is it possible to ask the user how the calculation was done?

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Help with NPV (Excel 2002)

    I asked the user, and she said that the financial calculator she has does it by simply typing in the values as they are entered on the sheet ( PMT, N, I FV, PV ) and then she presses NPV and it throws out the result.

    The help shows values that must be fed into the function...and I'm not sure how to ge those values.

    Any NPV financial experts out there to help?
    Regards,
    Rudi

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Help with NPV (Excel 2002)

    Rudi

    Does this help?

    I am beginning to understand it a little now!!
    Jerry

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Help with NPV (Excel 2002)

    Thanx Jezza,
    This does make it more clear!
    Cheers
    Regards,
    Rudi

Posting Permissions

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