Please show all work in excel! will upvote once both answred thank you!

1. You are offered an annuity that will pay you 10,000 at the end of each year for 20 years, with the first payment being in 10 years from today. If the interest rate is 12% annually, what is this annuity worth to you today?

   		26,935.56
   		24,100.55
   		200,000
   		64,394.55
   		74,694.44

2. Your company is considering a project with the following cash flows.

   year	cashflow
   0	-800
   1	5000
   2	200
   3	-5000

   Assuming the cost of capital is 10%, first internal rate of return?

   		7.46%
   		7.51%
   		8.20%
   		0%
   		9.54%