Retirement Calculations

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!
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
On 6/28/11 8:00 PM, Namit Nasih wrote:

http://www.techonthenet.com/excel/formulas/pv.php
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.