Please show work and answers completed on an excel format

1. (5 points) Asset A was purchased six months ago for $20,000 and has generated $1,500 cash flow during that period. What is the asset's rate of return if it can be sold for $22,750 today? 2. (10 points) The following historical returns have been reported for Best Buy: 2014 10% 2015 12% 2016 5% 2017 8% 2018 10% A) What was the average return for Best Buy during this five year period? B) What is the standard deviation of Best Buy's returns for this period? C) What is the coefficient of variation of Best Buy? 3. (5 points) A capital project has an initial investment of S100.000 and cash flows in years 1-6 of $25.000. 510.000, 550.000, $10.000. $10,000 and $60.000. respectively. Given a 15 percent cost of capital (a) compute the net present value. (b) compute the internal rate of retum (c) should the project be accepted? Why or why not