Chapter_09

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

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

View Full Document Right Arrow Icon
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."
Background image of page 1

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

View Full DocumentRight Arrow Icon
k"
Background image of page 2
Chapter 9 Question 1 Input area: Initial price $83 Dividend paid 1.40 Ending share price 91 Output area: Total return 11.33%
Background image of page 3

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

View Full DocumentRight Arrow Icon
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%
Background image of page 4
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%
Background image of page 5

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

View Full DocumentRight Arrow Icon
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%
Background image of page 6
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%
Background image of page 7

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

View Full DocumentRight Arrow Icon
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%
Background image of page 8
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
Background image of page 9

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

View Full DocumentRight Arrow Icon
Background image of page 10
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
Background image of page 11

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

View Full DocumentRight Arrow Icon
Background image of page 12
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
Background image of page 13

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

View Full DocumentRight Arrow Icon
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
Background image of page 14
Image of page 15
This is the end of the preview. Sign up to access the rest of the document.

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 Right Arrow Icon
Ask a homework question - tutors are online