can you help me with the exact forumal inputs for this problem, I now the maual formula just not how to input it in excel. the problem in Excel is modified from the book question just a bit. Thank you

A B C D E F G H 1 P5-22M (change the amount offered in 10 years to $950.00 from $1,079.50) 2 3 PV 4 FV 5n 6 i 7 00 5-22. (Solving for :) (Related to Checkpoint 5.6 on page 144) If you were offered $1,079.50 in 10 years from now in return for an investment of $500 currently, what annual rate of interest would you earn if you took the offer