Please show all work in excel! Will upvote once both answred! Thank you in advance!
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%
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