Opportunity Investment tern Expected cash inflow Cost of investment 4 years $ 7,800 $20,700 B 5 years 3 years $3,000 $3,700 $9,000 $8,900 D 5 years $ 4,100 $15,000 Required a. Compute the net present value of each investment opportunity and record your answers in the following table. The results for Investment Opportunity A have been recorded in the table as an example. b. Determine the net present value and the internal rate of return for each investment opportunity. Record the results in the followin table. The results for investment Opportunity A have been recorded in the following table as an example. Note that the manual computation yields the same net present value amounts as the financial function routines of Excel or a financial calculator Complete this question by entering your answers in the tabs below. Required A Required B Compute the net present value of each investment opportunity and record your answers in the following table. The results for Investment Opportunity A have been recorded in the table as an example. (Negative amounts should indicated by minus sign. Round "Present value factor" to 6 decimal places. Round "Present value of cash flows and Net present value to 2 decimal places.) Opportunity B Cash Inflow $ 7,800 $ 3.000 $ 3,700 $ 4 100 Times present value factor 3037349 Present value of cash flows 5 23,691 32 Minus cost of investment (20.700.00) (9.000.00) (8.900.00) (15,000.00) Net present value 5 2.991.32 . Peonid