What is the present value of the following payment stream at an interest rate of 7%; $1000 invested at the end of year 0, Cash inflows of $2000 at the end of year 1, $5000 at the end of year 3, $6000 at the end of year 5?

A.$11,243

B.$11,812

C.$12,943

D.$9,229

Please use excel to resolve the question and please show how to set the formular in excel