Retirement Calculations

Discussion in 'Financial Planning' started by Namit Nasih, Jun 29, 2011.

  1. Namit Nasih

    Namit Nasih Guest

    How can I use PV function in Excel to derive amount needed at the time
    of retirement?
    Assume years in retirement 35,
    Post retirement return 6 pa,
    Inflation 4 pa,
    Required income 5000 pm.

    ps: I know how to do this using NPV function but very specifically
    need to use PV.

    Thanks!
     
    Namit Nasih, Jun 29, 2011
    #1
    1. Advertisements

  2. Namit Nasih

    Alan Guest

    On 6/28/11 8:00 PM, Namit Nasih wrote:
    > How can I use PV function in Excel to derive amount needed at the time
    > of retirement?
    > Assume years in retirement 35,
    > Post retirement return 6 pa,
    > Inflation 4 pa,
    > Required income 5000 pm.
    >
    > ps: I know how to do this using NPV function but very specifically
    > need to use PV.
    >
    > Thanks!
    >

    http://www.techonthenet.com/excel/formulas/pv.php
     
    Alan, Jul 1, 2011
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Frank X

    Computerised Payroll Calculations

    Frank X, Aug 13, 2003, in forum: UK Accountancy
    Replies:
    30
    Views:
    896
    Tiscali Stan
    Aug 16, 2003
  2. D.M. Procida

    Depreciation calculations

    D.M. Procida, Dec 3, 2003, in forum: UK Accountancy
    Replies:
    32
    Views:
    912
    Ronald Raygun
    Dec 14, 2003
  3. Richard

    finance lease liability calculations

    Richard, Apr 27, 2004, in forum: UK Accountancy
    Replies:
    43
    Views:
    1,350
    Troy Steadman
    May 1, 2004
  4. Willaa

    Depreciation calculations

    Willaa, Dec 15, 2006, in forum: Accounting
    Replies:
    1
    Views:
    302
    Rusty
    Dec 16, 2006
  5. Bill Woessner

    Balancing Retirement and Non-Retirement Savings

    Bill Woessner, May 7, 2008, in forum: Financial Planning
    Replies:
    21
    Views:
    1,687
    Bill Woessner
    May 21, 2008
Loading...

Share This Page