if you can solve using excel and show the formulas that would be appreciated

Consider the streams of income given in the following table: a. Find the present value of each income stream, using a discount rate of 5%, then repeat those calculations using a discount rate of 6%. b. Compare the calculated present values and discuss them in light of the fact that the undiscounted total income amounts to $34,000 in each case. 3 4 M N 00 7 8 9 a. The present value of income stream A, using a discount rate of 5% is $. (Round to the nearest cent.) 10 Data table Income Stream End of Year A B 1 $10,000 $7,000 2 $9,000 $8,990 3 $8,000 $9,000 4 $7,000 $10,000 Total $34,000 $34,000 (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.)