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

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

View Full Document Right Arrow Icon
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."
Background image of page 1

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

View Full DocumentRight Arrow Icon
k"
Background image of page 2
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
Background image of page 3

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

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

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

View Full DocumentRight Arrow Icon
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%
Background image of page 8
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
Background image of page 9

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

View Full DocumentRight Arrow Icon
Chapter 5 Question 7 Index Level Input Area: Beginning index level 408.16 Index return 12.14% Output Area: Ending index level 457.72
Background image of page 10
Chapter 5 Question 8 Re-indexing Input Area:
Background image of page 11

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

View Full DocumentRight Arrow Icon
Image of page 12
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/17/2011 for the course FINANCE 1001 taught by Professor Lochengshu during the Spring '11 term at National Cheng Kung University.

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 Right Arrow Icon
Ask a homework question - tutors are online