sample_excel_sol_chapter_24

sample_excel_sol_chapter_24 - Chapter 24 Problems 1-17...

Info iconThis preview shows pages 1–7. 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 3 Input Area: Face value $1,000 Conversion ratio 15 Stock price $62 Output Area: Conversion value $930
Background image of page 4
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 5

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

View Full DocumentRight Arrow Icon
Chapter 24 Question 7 Input Area: Scenario A Scenario B Face value of bond $1,000 $1,000 Straight value of convertible bond $900 $950 Market value of convertible bond $1,000 $900 Output Area: Scenario A Feasible Scenario B Not feasible
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/14/2011 for the course FINANCE 620 taught by Professor Halstead during the Fall '09 term at UMBC.

Page1 / 11

sample_excel_sol_chapter_24 - Chapter 24 Problems 1-17...

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

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