Show the solution in EXCEL

Problem 4. Which of the following investment opportunities all maturing at the end of 2 years and requiring the rate of return of 6% would you choose? Investment Compounding Future Value 1 2 Annually Monthly Quarterly $1,123,600.00 21,127,159.78 $1,126,492.59 3 Problem 5. Your firm is evaluating a project that should generate revenue of P4,600 in year one, P5,200 in year two, P5,900 in year three, and P5,700 in year four. The firm receives each cash flow at the end of each year. If your firm's required return is 12%, compounding semi-annually, what is the future value of these cash flows at the end of year four? Problem 6. Justine Global Info Tech records the following cash flows at the end of each year for a project. If the firm's discount rate is 11%, what is the PRESENT VALUE of the project? Year Cash Flow 1 2. 3 P794,633.00 P542,149.00 P836,200.00 P716,080.00 $520,354.00 4 5