Solve using Excel: Ms. Landis is the president of Modern Manufacturing. Her company has developed a new 3D printer for use in the construction industry. She has received three offers to purchase this 3D printer technology, as follows: a payment of $500,000 now, followed by annual payments of $120,000 at the end of years 6 through 15. a payment of $900,000 today a series of semiannual payments of $80,000 spread over the next 10 years. The first payment will be received today and the remaining payments will come at the beginning of each semiannual period. A. Using a required rate of return of 12% per year, calculate the present value of each of the three offers. B. Based on your answers to part A, which of the three offers should be accepted? That is, which has the largest present value? C. If the required rate of return were increased to 15% per year, would that change the decision about which offer to accept? Which offer should be accepted at the higher required rate of return