http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/histretSP.html

USE THE GRAPH AND EXTERNAL LINK TO HELP SOLVE THE PROBLEM. MUST USE EXCEL AND SHOW EXCEL FORMULAS

1Chapter 12 HW, Part A Data Source 2 From Textbook/Powerpoint (Years 1926-2007): 4 FIGURE 12.10 Historical Returns, Standard Deviations, and Frequency Distributions: 1926-2007 nt (Years 1926-2007) AVERAGE RETURN STANDARD DEVIATION SERIES DISTRIBUTION 12.396 20.0% Small-company stocks 17.1 32.6 16 6.2 8.4 government 5.8 9.2 bonds 23 5.5 5.7 6 government bonds o U.S. Treasury bills 3.8 3.1 4 Inflation 5 3.1 4.2 "The 1933 small-company stocks totareturn was 1 42.9 percont 8 SouncE: Modified from Stocks, Bonds, Bills and Infiation 2008 Yearbook, All rights reserved annually updates work by Roger Q. ibbotson and Rex A. Sinquefield (Chicago