{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

# Chapter05CorradoJordanRex - Chapter 5 Problems 1-22 Input...

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

Chapter 5 Problems 1-22 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 5 Question 1 Price-weighted Divisor Input Area: Stock split Able \$30 1 1 Baker \$148 2 1 Charlie \$89 1 1 Output Area: Last Index 89 New market value \$193 New divisor 2.16854 New divisor = New value / Last Index

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

View Full Document
Chapter 5 Question 2 Price-weighted Divisor Input Area: Stock plit Able \$30 1 1 Baker \$148 3 1 Charlie \$89 1 1 Output Area: Last Index 89 New market value \$168 New divisor 1.89139
Chapter 5 Question 3 Order Book Input Area: Buy Orders Sell Orders Shares Price Shares Price 350 81.01 100 81.04 100 81.00 600 81.05 900 80.98 1,000 81.07 75 80.96 700 81.08 900 81.10 Market buy order 100 last trade 81.03 Market sell order 100 Market buy order 400 Output Area: Market buy order Shares Share price Shares remaining 100 \$81.04 - - \$- - - \$- - Market sell order Shares Share price Shares remaining 100 \$81.01 - - \$- - - \$- - Market buy order Shares Share price Shares remaining 100 \$81.04 300 300 \$81.05 - - \$- -

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

View Full Document
Chapter 5 Question 4 Price-weighted Divisor Input Area: Price per share Shares Beg. Of Yr. End of Yr. Kirk, Inc 35,000 \$95 \$102 Picard, Inc 65,000 \$54 \$63 Output Area: Beginning index value 74.50 Ending index value 82.50 Return 10.74%

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

View Full Document
Chapter 5 Question 5 Value-weighted Divisor Input Area: Price per share Shares Beg. Of Yr. End of Yr. Kirk, Inc 35,000 \$95 \$102 Picard, Inc 65,000 \$54 \$63 Output Area: Beginning average market value \$3,417,500 Ending average market value \$3,832,500 Return 12.14%
Chapter 5 Question 6 Re-indexing Input Area: Beginning of year value \$3,417,500 End of year value \$3,832,500 Re-index value 100 Output Area: Beginning index level 100.00 1.12 Ending index level 112.14

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

View Full Document
Chapter 5 Question 7 Index Level Input Area: Beginning index level 408.16 Index return 12.14% Output Area: Ending index level 457.72
Chapter 5 Question 8 Re-indexing Input Area: Year 1 (in millions) 5,897 Year 2 (in millions) 6,194 Year 3 (in millions) 6,598

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.

{[ snackBarMessage ]}

### Page1 / 33

Chapter05CorradoJordanRex - Chapter 5 Problems 1-22 Input...

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

View Full Document
Ask a homework question - tutors are online