Please show how to do in excel

Present value: Mixed streams Consider the mixed streams of cash flows shown in the following table, a. Find the present value of each stream using a 7% discount rate. b. Compare the calculated present values and discuss them in light of the undiscounted cash flows totaling $30,000 in each case. Is there some discount rate at which the present values of the two streams would be equal? a. The present value of the cash flows of stream A is $ (Round to the nearest dollar.) Data table (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.)