Accountant Forums


Reply
Thread Tools

Retirement Calculations

 
 
Namit Nasih
Guest
Posts: n/a
Thanked:
 
      06-29-2011, 02:00 AM
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!

 
Reply With Quote
 
 
 
 
Alan
Guest
Posts: n/a
Thanked:
 
      07-01-2011, 06:42 PM
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

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Balancing Retirement and Non-Retirement Savings Bill Woessner Financial Planning 21 05-21-2008 02:35 PM
Depreciation calculations Willaa Accounting 2 12-17-2006 03:21 PM
finance lease liability calculations Richard UK Accountancy 43 05-01-2004 07:25 PM
Depreciation calculations D.M. Procida UK Accountancy 32 12-14-2003 12:14 AM
Computerised Payroll Calculations Frank X UK Accountancy 30 08-16-2003 05:21 PM


All times are GMT. The time now is 07:06 AM.
Posts in this forum do not constitute the advice of AccountantForums.com or its members. Financial advice should always be taken from qualified advisors before committing to a financial decision.