Chapter_09

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

This preview shows pages 1–10. 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
Chapter 9 Question 1 Input area: Initial price \$83 Dividend paid 1.40 Ending share price 91 Output area: Total return 11.33%
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%

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

View Full Document
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%
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%

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

View Full Document
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%
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%

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

View Full Document
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 0.00010 2 0.06 0.10 (0.04) 0.00160 3 (0.08) 0.10 (0.18) 0.03240 4 0.28 0.10 0.18 0.03240 5 0.13 0.10 0.03 0.00090 Total 0.50 0.06740 Average return 0.1000 Variance = 0.016850 Standard Deviation = 12.98% X Deviation 1 0.36 0.16 0.20 0.03920 2 (0.07) 0.16 (0.23) 0.05382 3 0.21 0.16 0.05 0.00230 4 (0.12) 0.16 (0.28) 0.07952 5 0.43 0.16 0.27 0.07182 Total 0.81 0.24668 Average return 0.1620 Variance = 0.061670 Standard Deviation = 24.83% Actual Return Average Return Squared Deviation Actual Return Average Return Squared Deviation
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 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

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 12/21/2011 for the course NIKA 101 taught by Professor Temur during the Spring '11 term at Acton School of Business.

### Page1 / 31

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

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

View Full Document
Ask a homework question - tutors are online