Parker is 50 and wants to retire in 15 years. His family has a history of living well into their 90s. Therefore, he estimates that he will live to age 95. He currently has a salary of $120,000 and expects that he will need about 65% of that amount annually if he were retired. He can earn 9 percent in his portfolio while he is working. However, he expects that he will only earn 8 percent in his portfolio during retirement. He expects inflation to continue at 3 percent. Parker currently has $350,000 invested for his retirement. His Social Security benefit in todays dollars is $30,000 per year at normal age retirement of age 67. His Social Security benefit will be reduced by 6 2/3 percent for each year he begins collecting before full age retirement. How much does he need to save each year to meet his retirement goals?

PLEASE SHOW ALL WORK, IF IN EXCEL PLEASE SHOW ALL EQUATIONS THANKS!