Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Download the data from the following data table file excel in this link : https://www.dropbox.com/s/suxn65bvyexhims/data-11-2-2017-12-22%20AM.xlsx?dl=0 a. Compute the average return for each of the assets

Download the data from the following data table

image text in transcribed

file excel in this link :

https://www.dropbox.com/s/suxn65bvyexhims/data-11-2-2017-12-22%20AM.xlsx?dl=0

a. Compute the average return for each of the assets from 1929 to 1940 (the Great Depression).

b. Compute the variance and standard deviation for each of the assets from 1929 to 1940.

c. Which asset was riskiest during the Great Depression? How does that fit with your intuition?

Answers:

a. Compute the average return for each of the assets from 1929 to 1940 (the Great Depression).

The average return for the S&P 500 was (______) (Round to five decimal places.)

The average return for the Small Stocks was (______) (Round to five decimal places.)

The average return for the Corp Bonds was (______) (Round to five decimal places.)

The average return for the World Portfolio was (______) (Round to five decimal places.)

The average return for the Treasury Bills was (______) (Round to five decimal places.)

The average for the CPI was (______) (Round to five decimal places.)

b. Compute the variance and standard deviation for each of the assets from 1929 to 1940.

The variance for the S&P 500 was (______) (Round to five decimal places.)

The variance for the Small Stocks was (______) (Round to five decimal places.)

The variance for the Corp Bonds was (______) (Round to five decimal places.)

The variance for the World Portfolio was (______) (Round to five decimal places.)

The variance for the Treasury Bills was (______) (Round to five decimal places.)

The variance for the CPI was (______) (Round to five decimal places.)

The standard deviation for the S&P 500 was (______) (Round to five decimal places.)

The standard deviation for the Small Stocks was (______) (Round to five decimal places.)

The standard deviation for the Corp Bonds was (______) (Round to five decimal places.)

The standard deviation for the World Portfolio was (______) (Round to five decimal places.)

The standard deviation for the Treasury Bills was (______) (Round to five decimal places.)

The standard deviation for the CPI was (______) (Round to five decimal places.)

c. Which asset was riskiest during the Great Depression? How does that fit with your intuition? (Select the best choice below.)

A. The riskiest assets were the Treasury Bills. Intuition tells us that government securities would be the riskiest.

B. The riskiest assets were the stocks in the S&P 500. Intuition tells us that large companies should be the riskiest.

C. The riskiest assets were the small stocks. Intuition tells us that smaller companies should be riskiest.

D. The riskiest assets were the corporate bonds. Intuition tells us that company debt should be riskiest.

Year 1929 1930 1931 1932 1933 1934 1935 1936 10 1937 1938 1939 1940 S&P 500Small StocksCorp Bonds World Portfolio Treasury Bills -0,08906 -0,25256-0,44698 -0,43861 -0,08854 0,5288 -0,02341 0,47221 0,32796 -0,35258 0,33204 -0,00914 -0,10078 0,0432 0,06343 -0,0238 0,12199 0,05255 0,09728 0,0686 0,06219 0,02546 0,04357 0,04247 0,04512 -0,07692 -0,22574 -0,39305 0,0303 0,66449 0,02552 0,22782 0,19283 -0,1695 0,05614 -0,01441 0,03528 0,04471 0,02266 0,01153 0,00882 0,00516 0,00265 0,00171 0,00173 0,00267 0,0006 0,00042 0,00037 CPI 0,00585 -0,06395 -0,09317 -0,10274 0,00763 0,01515 0,02985 0,01449 0,02857 -0,02778 0 0,00714 -0,43081 -0,54676 -0,00471 2,16138 0,57195 0,69112 0,70023 -0,56131 0,08928 0,04327 -0,28063 4 6 12 13

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Elements Of Financial Risk Management

Authors: Peter Christoffersen

2nd Edition

0128102357, 9780128102350

More Books

Students also viewed these Finance questions