I do appreciate the replies, however I'm not asking for suggestions regarding what others may think is best for me. I am asking how to do a calculation.
What would help is to have an Excel formula for calculating the lump sum amount based on the three segments called out in the “Minimum Present Value Segment Rates” table. I've never seen PV calculated as three segments with three interest rates.
I think I found something helpful on slides 11 through 18 here (but it appears to be from 2014): https://www.asppa.org/sites/asppa.org/files/PDFs/Education/Conferences/AAS14/Session%203%20-%20IRS%2...
I'll eventually find the answer and post.
