Can someone show me the correct excel formula to answer these questions?

15. What is the rate of return you would earn if you paid $950 for a perpetuity that pays $85 per year? Rate Periods Payment Future value Present value Answer 16. You have a chance to buy an annuity that pays $5,000 at the beginning of each year for 5 years. You could earn 4.5% on your money in other investments with equal risk. What is the most you should pay for the annuity? Rate Periods Payment Future value Present value Answer 17. A bank is offering an account with a nominal interest rate of 6% with monthly compounding. What is the effective annual rate on this account. Rate Periods Payment Future value Present value Note: you need a periodic interest rate to calculate the EAR. Periodic rate = annual rateumber of periods per year. For example: 12% with quarterly compounding gives a periodic rate of 0.12/4) = .03 = 3% EAR = [(1 + periodic rate) raised to the power of the number of compouding periods per year] - 1 For my example: [(1 +.03)^4] - 1 = .1255 = 12.55%