+ Reply to Thread
Results 1 to 4 of 4

NPV question!

  1. 05-11-2009, 03:38 PM #1
    danioma
    danioma is offline
    Registered User
    Join Date
    06-05-2006
    Posts
    9

    NPV question!

    I am trying to get what $1million at 10% in 2025 would be today - any idea how to do this in excel?
    Reply With QuoteRegister To Reply
  2. 05-11-2009, 04:53 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: NPV question!

    =PV(10%, 2025 - 2009, 0, -1000000) = $217,629.14

    The miracle of compound interest.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 05-12-2009, 08:42 AM #3
    danioma
    danioma is offline
    Registered User
    Join Date
    06-05-2006
    Posts
    9

    Re: NPV question!

    Thanks so much.

    I get a very different answer than another formula that I found

    =NPV(A2,N5,N6,N7,N8,N9,N10,N11,N12,N13,N14,N15,N16,N17,N18,N19)


    Any chance you could explain your formula?
    Im just trying to understand it!

    Thanks again.
    Reply With QuoteRegister To Reply
  4. 05-12-2009, 10:11 AM #4
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: NPV question!

    http://www.tvmcalcs.com/calculators/...unctions_page3
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1