Student_EOC_Chapter_10

# Student_EOC_Chapter_10 - 0.01690 0.00010 0.00160 0.01000...

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

Chapter 10 Problems 4, 7, 21 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green

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

View Full Document
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%
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

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

View Full Document
0.00640

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

View Full Document

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: 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

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online