I am really struggling on this OTIS assignment could somebody please help me.

.

Chapter 11

Examples of 5 stocks with historical yearly market price for the last 5 years, Calculate the return for each period (4 returns)

same 5 years of yearly data for CPI (consumer price index) calculate return for each yearly period. tell me what site you use.how to Calculate the YTM (Rate in excel) When purchased given the current price (PV) year of maturity (Calculate NPER), Coupon Rate (Calculate PMT) 1000 (FV) and compute the YTM (RATE) Rank bonds from highest to lowest YTM

Written exercise

Compare the returns on your bonds to the returns on the CPI. Is there an inverse relationship? Why is this? Discuss difference you found between the YTM in part 2 and the duration in part 3.