Solve in excel questions 5 and 6 of corporate finance.

for 15 years, with the first payment occurring one year from now. If the required return is 8 percent, what is the value of the investment? What would the value be if the payments occurred for 40 years? For 75 years? Forever? 5. Calculating Annuity Cash Flows. For each of the following annuities, calculate the annual cash flow. Present Value $ 24,500 19,700 136,400 285,650 CalCUIating Annuity Values. the present value. Annuity Payment $ 2,100 1,095 11,000 30,000 Years 6 8 15 20 Interest Rate 7 8 6 For each of the following annuities, calculate Years 7 9 18 28 Interest Rate 5% 10 8 14