Chapter_10_HWK - Output area: a. Average real return 0.00%...

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

View Full Document Right Arrow Icon
Chapter 10 Problems 4, 6, 10, 18 ,19 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 10 Question 4 Input area: Coupon paid Initial price Ending price Inflation rate Output area: a. Dollar return $- b. Nominal return #DIV/0! c. Real return #DIV/0!
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 10 Question 6 Input area: Long-term government Long-term corporate Inflation rate Output area: Real long-term government return 0.00% Real long-term corporate return 0.00%
Background image of page 4
Chapter 10 Question 10 Input area: Stock return Average inflation Average T-bill rate
Background image of page 5

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

View Full DocumentRight Arrow Icon
Background image of page 6
Background image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Output area: a. Average real return 0.00% b. Average nominal risk premium 0.00% Chapter 10 Question 18 Input area: Average return Standard deviation Output area: Range Lower return Upper return 68 percent 0.00% 0.00% 95 percent 0.00% 0.00% Chapter 10 Question 19 Input area: Year Returns 1 19% 2-27% 3 6% 4 34% Average return 11% Output area: Sum of all returns 55.00% Sum of known returns 32.00% Missing return 23.00% X Deviation 1 0.19 0.11 0.08 0.00640 2 (0.27) 0.11 (0.38) 0.14440 3 0.06 0.11 (0.05) 0.00250 4 0.34 0.11 0.23 0.05290 5 0.23 0.11 0.12 0.01440 Total 0.55 0.22060 Average return 0.1100 Variance 0.055150 Standard Deviation 23.48% Actual Return Average Return Squared Deviation...
View Full Document

Page1 / 7

Chapter_10_HWK - Output area: a. Average real return 0.00%...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online