Chapter 12
Question 13
Input area:
Output area:
Chapter 12
Question 14
Input area:
Year Returns
Output area:
Chapter 12
Question 15
Input Area:
Output Area:
Year 1 14%
Year 2 18%
Year 3 26%
Year 4 -19%
Year 5 34%
Year 6 -9%
Chapter 12
Question 16
Input area:
Year Price Dividend
Output area:
Capital Gains
Dividend
Total
Chapter 12
Question 17
Input area:
Output area:
Chapter 12
Question 18
Input area:
Standard deviation 32.60%
Output area:
Chapter 12
Question 19
Chapter 12
Question 20
Input Area:
Output Area:
Arithmetic return 11.70%
Years of historical estimation 40
Geometric return 9.60%
Years for future estimation 20
Chapter 12
Question 21
Input Area:
Output Area:
Arithmetic return 11.90%
Years of historical estimation 85
Geometric return 9.90%
Years for future estimation 30
Chapter 12
Question 22
Input area:
Year T-bills Inflation
Output area:
T-bills
Actual
Average
Squared
Inflation
Return
Return
Deviation
Actual
Average
Squared
Average observed real return
Year
Actual
Return
Average
Return
Deviation
Squared
Deviation
Chapter 12
Question 23
Input area:
Output area:
Chapter 12
Question 24
Input area:
Output area: