Chapter_09

# Chapter_09 - Chapter 9 Problems 1-30 Input boxes in tan...

This preview shows pages 1–15. Sign up to view the full content.

Chapter 9 Problems 1-30 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-in" be installed in Excel. To install these, click on "Tools|Add-Ins" and select "Analysis ToolPak and "Solver Add-In."

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
k"
Chapter 9 Question 1 Input area: Initial price \$83 Dividend paid 1.40 Ending share price 91 Output area: Total return 11.33%

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Chapter 9 Question 2 Input area: Initial price \$83 Dividend paid 1.40 Ending share price 91 Output area: Dividend yield 1.69% Capital gains yield 9.64%
Chapter 9 Question 3 Input area: Initial price \$83 Dividend paid 1.40 Ending share price 76 Output area: Total return -6.75% Dividend yield 1.69% Capital gains yield -8.43%

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Chapter 9 Question 4 Input area: Initial price \$1,120 Coupon paid 90 Ending price 1,074 Inflation rate 3.00% Output area: a. Dollar return \$44.00 b. Nominal return 3.93% c. Real return 0.90%
Chapter 9 Question 5 Input area: Nominal return 12.40% Inflation rate 3.10% Output area: a. Nominal return 12.40% b. Real return 9.02%

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Chapter 9 Question 6 Input area: Long-term government 5.80% Long-term corporate 6.20% Inflation rate 3.10% Output area: Real long-term government return 2.62% Real long-term corporate return 3.01%
Chapter 9 Question 7 Input area: Year X Y 1 11% 36% 2 6% -7% 3 -8% 21% 4 28% -12% 5 13% 43% Output area: X Deviation 1 0.11 0.10 0.01 2 0.06 0.10 (0.04) 3 (0.08) 0.10 (0.18) 4 0.28 0.10 0.18 5 0.13 0.10 0.03 Total 0.50 Average return 0.1000 Variance = 0.016850 Standard Deviation = 12.98% X Deviation 1 0.36 0.16 0.20 2 (0.07) 0.16 (0.23) 3 0.21 0.16 0.05 4 (0.12) 0.16 (0.28) 5 0.43 0.16 0.27 Total 0.81 Average return 0.1620 Variance = 0.061670 Standard Deviation = 24.83% Actual Return Average Return Actual Return Average Return

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
0.00010 0.00160 0.03240 0.03240 0.00090 0.06740 0.03920 0.05382 0.00230 0.07952 0.07182 0.24668 Squared Deviation Squared Deviation

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Chapter 9 Question 8 Input area: Year T-bills 1973 -14.69% 7.29% 1974 -26.47% 7.99% 1975 37.23% 5.87% 1976 23.93% 5.07% 1977 -7.16% 5.45% 1978 6.57% 7.64% Output area: Large Stocks

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Large company stocks Year Deviation 1973 (0.1469) 0.0324 (0.1793) 0.03213 1974 (0.2647) 0.0324 (0.2971) 0.08824 1975 0.3723 0.0324 0.3400 0.11557 1976 0.2393 0.0324 0.2070 0.04283 1977 (0.0716) 0.0324 (0.1040) 0.01081 1978 0.0657 0.0324 0.0334 0.00111 Total 0.1941 0.29068 Average return 0.0324 Variance = 0.058136 Standard deviation = 24.11% T-bill returns Year Deviation 1973 0.0729 0.0655 0.0074 0.00005 1974 0.0799 0.0655 0.0144 0.00021 1975 0.0587 0.0655 (0.0068) 0.00005
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 42

Chapter_09 - Chapter 9 Problems 1-30 Input boxes in tan...

This preview shows document pages 1 - 15. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online