Chapter_24

Chapter_24 - Chapter 24 Problems 1-17 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE Some

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

View Full Document Right Arrow Icon
Chapter 24 Problems 1-17 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 24 Question 1 Input Area: Face value $1,000 Conversion ratio 22.4 Output Area: Conversion price $44.64
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 24 Question 2 Input Area: Face value $1,000 Conversion price $64.85 Output Area: Conversion ratio 15.42
Background image of page 4
Chapter 24 Question 3 Input Area: Face value $1,000 Conversion ratio 15 Stock price $62 Output Area: Conversion value $930
Background image of page 5

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

View Full DocumentRight Arrow Icon
Chapter 24 Question 4 Input Area: Face value $1,000 Conversion ratio 14.50 Stock price $46.24 Output Area: Conversion price $68.97 Conversion premium 49.15%
Background image of page 6
Chapter 24 Question 5 Input Area: Face value $1,000 Conversion ratio 24.25 Stock price $31.25 Stock price increas $2.00 Output Area: a. Conversion ratio 24.25 b. Conversion price $41.24 c. Conversion premium 31.96% d. Conversion value $757.81 e. Conversion value $806.31
Background image of page 7

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

View Full DocumentRight Arrow Icon
Question 6 Input Area: Shares per warrant 3 Exercise price $32.00 Stock price
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/14/2010 for the course FINC 311 taught by Professor Stanley,t during the Fall '08 term at Winthrop.

Page1 / 19

Chapter_24 - Chapter 24 Problems 1-17 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE Some

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

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