I know no one can predict the IRS segment rates accurately, but I plugged in the three segment rates from November to May of this year from the IRS web site and used the EXCEL formula FORECAST.LINEAR to try to forecast what the segment rates would be in November when the cash balance would be recalculated for 2022.
May rates were just posted of 0.61, 2.84, 3.54
I got 0.82, 3.64 and 4.24 would be the future rate in November when I plugged into the Fidelity calculator using the FORECAST.LINEAR function, if these rates were close, I would have a lump sum reduction of $85k come 2022!
So my question is, what method should be used to project what the segments rates might be come November?