Please show all work in excel! Will upvote once both answred! Thank you in advance!

1. You were offered the following returns on a $1,000 you make today. What is the rate of return on this investment?

   yar	cash
   1	500
   2	400
   3	300
   4	200

   		18.35%
   		8.75%
   		17.80%
   		19.50%
   		11.25%

2. What is the present value of the following cash flows if the opportunity cost is 10%, with daily compounding?

   year	cash
   1	1000
   2	2000
   3	3000
   4	4000

   		$10,289.75
   		$7,446.33
   		$8,865.36
   		$9,753.82
   		$7,547.98