Question: How can I do this on excel? (what values for PMT NPER RATE FV for #1?) If you want your retirement saving be large enough

How can I do this on excel? (what values for PMT NPER RATE FV for #1?)  How can I do this on excel? (what values for PMT
NPER RATE FV for #1?) If you want your retirement saving be

If you want your retirement saving be large enough to allow you to withdraw $80,000 at the beginning of each year for 30 year, with 5% annual compounding interest rate, how much saving do you need to have on the day your retire? Rounded your answer to two decimals without thousand separators and $. Answer: Your answer to the previous is your financial goal. If you can contribute a constant amount to your investment account and are able to earn 8% on your investment each year for 35 years, how much do you need to contribute to your retirement account at the end of each year to achieve the financial goal? Round your answer to two decimals without thousand separator and $ sign

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!