Hi, If you can solve this using EXCEL that would be Amazing. Please DO NOT use power series to answer it. Thank you.

10. Richard is 65 years old and about to retire. He has $500,000 saved to supplement his pension and Social Security and would like to withdraw it in equal annual dollar amounts so that nothing is left after 15 years. How much does he have to withdraw each year if he earns 5 percent on his money