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

Info iconThis 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."
Background image of page 1

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

View Full DocumentRight 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%
Background 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%
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 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 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%
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 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 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%
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 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
Background 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 0.0655 0.0074 0.00005 1974 0.0799
Background image of page 9

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

View Full DocumentRight Arrow Icon
Image of page 10
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 Right Arrow Icon
Ask a homework question - tutors are online