I need help finding the ending value. Please put it in excel format.

Required:

Note: Use cells A$2$ to D$6$ from the given information to complete this question.

Please calculate the beginning and ending values for the price$-$weighted and market$-$weighted indexes. Avoid hardcoding any data, always call data from cells.