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

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
Get step-by-step solutions from verified subject matter experts
