Excel gurus: time value of money formula?

Discussion in 'Horn Depot' started by Craigcito, Nov 15, 2008.

  1. Craigcito

    Craigcito 250+ Posts

    Well, "present value of an annuity due" actually. Say I receive $250 annuity payments on the first day of the month for which the payment is due. There are 12 years left in the annuity. What is it worth today?

    Anyone have a formula for this handy? Thanks in advance.
     
  2. Bookman

    Bookman 1,000+ Posts

  3. Agent007

    Agent007 250+ Posts

    or if you want to be EXTREMELY accurate (adjusting for the fact that the payments occur at different intervals because months have different number of days, use the XNPV function.

    (See excel help or google for implementation)
     

Share This Page