Please provide the answers for 6%, 12% and 18% for columns A and B

Discounted payback period. Given the following two projects and their cash flows, 5, calculate the discounted payback period with a discount rate of 6%, 12%, and 18%. What do you notice about the payback period as the discount rate rises? Explain this relationship With a discount rate of 6%, the cash outflow for project A is: (Select the best response.) i Data Table O A. recovered in 2.79 years. B. recovered in 4 years. C. recovered in 5 years. D. never fully recovered. (Click on the following icon e in order to copy its contents into a spreadsheet.) Cash Flow Cost Cash flow year 1 Cash flow year 2 Cash flow year 3 Cash flow year 4 Cash flow year 5 Cash flow year 6 $12,000 $4,800 $4,800 $4,800 $4,800 $4,800 $4,800 B $90,000 $18,000 $9,000 $36,000 $27,000 $4,500 $0 Print Done Click to select your answer and