Need help with this one! From Gapenski 7th edition Understanding Financial healthcare Management, thx!

Chapter 4- Time Value Analysis Assigned Problem 2 John Adams is the CEO of a nursing home in San Jose. He is now 50 years old and plans to retire in ten years. He expects to live for 25 years after he retires that is until he is 85. He wants a fixed retirement income that has the same purchasing power at the time he retires as S40,000 has today (he realizes that the real value of his retirement income will decline year by year after he retires) His retirement income will begin the day he retires, ten years from today, and he will then get 24 additional annual payments. Inflation is expected to be percent per year for ten years (ignore inflation after John retires): he currently has S100.000 saved up: and he expects to earn a return on his savings of 8 percent per year, annual compounding. To the nearest dollar, how much must he save during each of the next ten years (with deposits being made at the end of each year) to meet his retirement goal Hint: The inflation rate percent per year isused only to calculate desired retirement income) ANSWER Annual inflation rate est rate Annual Years until rement Years of life after retirement Desired retirement income in today's dollars Desired retirement income 10 years from today retirement income (annuit PV of desire due) Current savings FV of current savings Amount needed 10 years from today Annual amo nt to be save