Question: Please show how to do the calculation on excel. During the period from 2011 through 2015 the annual returns on small U.S. stocks were -

Please show how to do the calculation on excel.
Please show how to do the calculation on excel. During the period

During the period from 2011 through 2015 the annual returns on small U.S. stocks were - 3.80 percent, 19.15 percent, 45.91 percent, 3.26 percent, and - 3.80 percent, respectively. What would a $1 investment, made at the beginning of 2011 , have been worth at the end of 2015 ? (Round answer to 3 decimol places, eg. 52.750.) Value in 2015$ What average annual return would have been earned on this investment? (Round answer to 2 decimai ploces, eg. 52.75) Average annual return percent per year

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!