Use Excel and explain in detail with formulas Thanks

1. You were given the following information regarding 4 investments your aunt recently liquidated: Investment Quantity Stock A Stock B Bond C Bond D 150 80 20 10 Purchase Price $27.50 $5.25 $1003.50 $985.25 Annual Income $0.40 $0.04 $65.00 $57.50 Sale Price $28.75 $5.35 $1010.25 $980.00 Holding Period 5 months 17 weeks 2 years 170 days (a) Determine the holding period return (HPR) for each of the investments. (b) Can you identify the investment [based on (a)] with the best performance and the investment with the worst performance? If yes, name your choices. If no, why not. (c) Determine the annual percentage rate (APR) for each of the investments. (d) Can you identify the investment [based on (c)] with the best performance and the investment with the worst performance? If yes, name your choices. If no, why not. (e) Determine the effective annual rate (EAR) for each of the investments. (f) Can you identify the investment [based on (e)] with the best performance and the investment with the worst performance? If yes, name your choices. If no, why not. 1. You were given the following information regarding 4 investments your aunt recently liquidated: Investment Quantity Stock A Stock B Bond C Bond D 150 80 20 10 Purchase Price $27.50 $5.25 $1003.50 $985.25 Annual Income $0.40 $0.04 $65.00 $57.50 Sale Price $28.75 $5.35 $1010.25 $980.00 Holding Period 5 months 17 weeks 2 years 170 days (a) Determine the holding period return (HPR) for each of the investments. (b) Can you identify the investment [based on (a)] with the best performance and the investment with the worst performance? If yes, name your choices. If no, why not. (c) Determine the annual percentage rate (APR) for each of the investments. (d) Can you identify the investment [based on (c)] with the best performance and the investment with the worst performance? If yes, name your choices. If no, why not. (e) Determine the effective annual rate (EAR) for each of the investments. (f) Can you identify the investment [based on (e)] with the best performance and the investment with the worst performance? If yes, name your choices. If no, why not