Chapter_10_HWK

Chapter_10_HWK - Output area a Average real return 0.00 b...

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

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."

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

View Full Document
k"
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!

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

View Full Document
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%
Chapter 10 Question 10 Input area: Stock return Average inflation Average T-bill rate

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.

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

{[ snackBarMessage ]}

Page1 / 7

Chapter_10_HWK - Output area a Average real return 0.00 b...

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

View Full Document
Ask a homework question - tutors are online