Please use excel to solve and show steps. The problem and the data provided must be clearly laid out in the spreadsheet and cell referencing must be used.

6. An investor buys a stock for $35 and sells it for $56.38 after five years. a) What is the holding period return? b) What is the true annual rate of return