I was able to do the calculations on a calculator and got eh answer right. How would I enter this problem to show in excel.

Time value Personal Finance Problem Jim Nance has been offered an investment that will pay him $670 three years from today. a. If his opportunity cost is 7% compounded annually, what value should he place on this opportunity today? b. What is the most he should pay to purchase this payment today? c. If Jim can purchase this investment for less than the amount calculated in part (a), what does that imply about the rate of return that he will earn on the investment? a. The value Jim should place on this opportunity today is $ 546.92 . (Round to the nearest cent.) b. The most he should pay to purchase this payment today is $ 546.92 . (Round to the nearest cent.)