In: Finance
|
You’ve observed the following returns on Crash-n-Burn Computer’s stock over the past five years: 11 percent, –10 percent, 19 percent, 18 percent, and 10 percent. |
| a. |
What was the arithmetic average return on the company’s stock over this five-year period? (Do not round intermediate calculations and enter your answer as a percent rounded to 1 decimal place, e.g., 32.1.) |
| b-1. | What was the variance of the company’s returns over this period? (Do not round intermediate calculations and round your answer to 5 decimal places, e.g., .16161.) |
| b-2. |
What was the standard deviation of the company’s returns over this period? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) |
|
|||||||||||||||||
| Solution | ||||||
| Year | Stock Returns % | |||||
| 1 | 11 | |||||
| 2 | (10) | |||||
| 3 | 19 | |||||
| 4 | 18 | |||||
| 5 | 10 | |||||
| 48 | ||||||
| a. | Sum of the five years returns | =48 | ||||
| Arithmetic average (Sum of returns/No. of years) | =48/5 | |||||
| =9.6% | ||||||
| b-1. | Variance of Stock Returns | |||||
| Year | Stock Returns % | Returns-Arithmetic average | (Returns-Arithmetic average)^2 | |||
| 1 | 0.11 | 0.014 | (.11-.096) | 0.000196 | (0.014^2) | |
| 2 | -0.10 | -0.196 | (-.10-.096) | 0.038416 | (0.138416^2) | |
| 3 | 0.19 | 0.094 | (.19-.096) | 0.008836 | (0.008836^2) | |
| 4 | 0.18 | 0.084 | (.18-.096) | 0.007056 | (0.007056^2) | |
| 5 | 0.10 | 0.004 | (.10-.096) | 0.000016 | (0.000016^2) | |
| 0.48 | 0.05452 | |||||
| Variance | =(SUM(Return-Arithmetic average)^2)/n-1 | |||||
| =.05452/(5-1) | ||||||
| =0.01363 | ||||||
| b-2. | Standard Deviation of the returns | =Square root of Variance | ||||
| =Square root of 0.01363 | ||||||
| =0.11675 | ||||||
| =11.67% | ||||||