1. Investment A offers to pay you $5,300 per year for eight years, and Investment B offers you $7,300 for five years. Which Investment has a higher present value if the discount rate is 5%.

2. What is the value today of $5,500 per year, at a discount rate of 8.5%, if the first payment is received 6 years from now and the last payment is received 25 years from today?

Please include with your answer the excel formula used to answer the question (EX. =FV, =PV, =NPER, =RATE)