Blog

Use Excel for this question: Given the following beginning o…

Use Excel for this question: Given the following beginning of month prices of a security over time, what is the geometric average monthly return? Note: first calculate the holding period return HPR = (ending value – beginning value)/beginning value. Use 7 for number of observations n. Date:                     Price: 12/1/2022       $132.69 11/1/2022       $119.05 10/1/2022       $108.86 9/1/2022         $115.81 8/1/2022         $129.04 7/1/2022         $106.26 6/1/2022         $91.20