How to sole in excel?

A B D E F G H 16 17 2) 18 You are given the following time line; Years: 0 1 CF $s o 1500 Rate: 12.00% CFs are at the end of the year. 2 3 1500 3000 4 4500 5 5000 a) Calculate the PV of the CFS 19 20 21 22 23 24 25 26 27 28 29 30 31 You are given the following time line; Years: 0 1 CF $s (10,000.00) 1500 Rate: 12.00% CFS are at the end of the year. 2 3 1500 3000 4 4500 5 5000 b) Calculate the PV of the CFS c) 32 33 34 35 36 37 38 If the CFs in this problem were part of a Net Present Value (NPV) calculation, what would be the NPV of this calculation? d) What is the IRR of the CFS