PLEASE USE EXCEL AND EXPLAIN ALL FORMULAS

8. Using a required rate of return of 12 percent, determine the present value of the following annual cash flows expected to be received over the next five years (assume received on last day of the year): c F Using the information from problem above, determine the value of a company that is projected to yield the future cash flows listed above in years 1-5, plus a perpetual annual cash flow starting at the end of year 6 of $2,500. Using the information from problems above, determine the value of the company, but now assume that the $2,500 annual cash flow which starts at the end of year 6 grows by 3% per year, into perpetuity