Please Show work on Excel

Annual cash inflows that will arise from two competing investment projects are given below: Year 1 2 3 4 Investment A Investment B $3,000 $6,000 4,000 5,000 5,000 4,000 6,000 3,000 Total $18,000 $18,000 The discount rate is 8%. Use Excel or a financial calculator to solve the homework. Round answers to the nearest dollar. Required: Compute the present value of the cash inflows for each investment. Each investment opportunity will require the same initial investment. Present Value of Cash Flows Investment A Investment B