Please show the work on Excel

Assume you are considering two mutually exclusive projects. The cash flows for project A and B are given below. Assume a discount rate of 6%. Project A can be renewed. Which project you would take? (15 points) time Project A Project B 0 1 2 3 4 5 $12,000,000.00 $18,000,000.00 $1,000,000.00 $3,000,000.00 $2,000,000.00 $3,000,000.00 $6,000,000.00 $3,000,000.00 $6,000,000.00 $3,000,000.00 $5,000,000.00 $3,000,000.00 $0.00 $3,000,000.00 $0.00 $3,000,000.00 $0.00 $5,000,000.00 $0.00 $5,000,000.00 $0.00 $1,000,000.00 6 7 8 9 10