6.Use a VBA function to find each single-period return of a portfolio over a multi-period holding interval.

An investor invested $50,000 in four US stocks for five years (60 months). Specifically, the investor invested in $10,000 each in stocks A, B, and C, and $20,000 in stock D. The monthly returns of the four stocks over the investor's five-year holding period are provided in the spreadsheet for you to answer the following four questions (note that return means rate of return):

7.Based on the VBA function created in Question 6, find the monthly returns of the investor's portfolio over the five-year holding horizon.

8.Based on the monthly returns of the investor's portfolio, find the arithmetic average return and the geometric average return?

9.Based on the monthly returns of the investor's portfolio, find the minimum return, maximum return, and the return standard deviation.

10.What is the five-year buy-and-hold return of the investor's portfolio?