What is the best approach of how to figure out the possible present value of
a future single payment annuity, based on the variability of several
possible interest rates?

Would like to do a small spreadsheet plugging in the term, future payment
and interest rate so we could do a test of 'what happens when this changes?'

Thnaks in advance for any help.