{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

sample_excel_sol_chapter_24

# sample_excel_sol_chapter_24 - Chapter 24 Problems 1-17...

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

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."

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

View Full Document
k"
Chapter 24 Question 1 Input Area: Face value \$1,000 Conversion ratio 22.4 Output Area: Conversion price \$44.64

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

View Full Document
Chapter 24 Question 3 Input Area: Face value \$1,000 Conversion ratio 15 Stock price \$62 Output Area: Conversion value \$930
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

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

View Full Document
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
Chapter 24 Question 9 Input Area:

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 ]}