{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

Info icon This preview shows pages 1–10. 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."
Image of page 1

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

View Full Document Right Arrow Icon
Chapter 9 Question 1 Input area: Initial price $83 Dividend paid 1.40 Ending share price 91 Output area: Total return 11.33%
Image of page 2
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%
Image of page 3

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

View Full Document Right Arrow Icon
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%
Image of page 4
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%
Image of page 5

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

View Full Document Right Arrow Icon
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%
Image of page 6
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%
Image of page 7

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

View Full Document Right Arrow Icon
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
Image of page 8
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
Image of page 9

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

View Full Document Right Arrow Icon
Image of page 10
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}