Student_EOC_Chapter_10

Student_EOC_Chapter_10 - 0.01690 0.00010 0.00160 0.01000...

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

View Full Document Right Arrow Icon
Chapter 10 Problems 4, 7, 21 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green
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 10 Question 4 Input area: Shares Price div Initial price $11,280 750 16.4 0.05 Coupon paid 150.00 Ending price 12,300 Inflation rate Output area: a. Dollar return $1,170.00 b. Nominal return 10.37% c. Real return 10.37%
Background image of page 2
Chapter 10 Question 7 Input area: Year X Y 1 18% 8% 2 -3% -33% 3 11% -2% 4 14% 47% 5 12% Output area: X Deviation 1 0.18 0.10 0.08 2 (0.03) 0.10 (0.13) 3 0.11 0.10 0.01 4 0.14 0.10 0.04 5 - 0.10 (0.10) Total 0.40 Average return 0.1000 Variance = 0.008333 Standard Deviation = 9.13% X Deviation 1 0.08 0.06 0.02 2 (0.33) 0.06 (0.39) 3 (0.02) 0.06 (0.09) 4 0.47 0.06 0.40 5 0.12 0.06 0.05 Total 0.32 Average return 0.0646 Variance = 0.081504 Standard Deviation = 28.55% Actual Return Average Return Actual Return Average Return
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
0.00640
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

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

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

Unformatted text preview: 0.01690 0.00010 0.00160 0.01000 0.02500 0.00034 0.15179 0.00750 0.16354 0.00285 0.32602 Squared Deviation Squared Deviation Chapter 10 Question 21 Input area: Year Price Divdend 1 2 3 4 5 6 Output area: Year 1 to 2 #DIV/0! #DIV/0! #DIV/0! 2 to 3 #DIV/0! #DIV/0! #DIV/0! 3 to 4 #DIV/0! #DIV/0! #DIV/0! 4 to 5 #DIV/0! #DIV/0! #DIV/0! 5 to 6 #DIV/0! #DIV/0! #DIV/0! Arithmetic return #DIV/0! Geometric return #DIV/0! Capital Gains Yield Dividend Yield Total Return Total Percentage Return Shares Price Annual DvdntEnding Price 300 3800 0.05 4080 Return % 0.08 Shares Price per Price ttl Return % 200 60 14000-0.06-2000-1160-840 Arithmetic -5.88 Annual R 6.8-14.7 6.3 1.1-28.9 1.07 0.05 0.09-0.07 0.5 0.24 Dividend yield 0.03...
View Full Document

Page1 / 8

Student_EOC_Chapter_10 - 0.01690 0.00010 0.00160 0.01000...

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

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