I need help solving in excel

1) You are given the following time line; CFs are at the end of the year. Years: 0 1 2 3 CF $s 0 0 0 0 This is a perpetuity that starts in year 4 end. The required return is; Calculate the PV of the perpetuity in year-end 3 (begin 4) at the required return: 4 100 6.00% 5 100 -on--> 100 What is the present value at t = 0? 2) You are given the following time line; Years: 0 CF $s 0 Rate: 12.00% 1 1500 CFs are at the end of the year. 2 3 1500 3000 4 4500 5 5000 a) Calculate the PV of the CFS