What is the equations to find the answers for the following?

What is the equations to find the answers for the following?
We can use the two valuation formulas to find values under different r’s, in a 2-output data table, and then use an IF statement to determine which value is appropriate:
Nominal rate,r: 8%
Rate,r