sample_excel_sol_chapter-15

# sample_excel_sol_chapter-15 - Chapter 15 Odd Problems Input...

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

Chapter 15 Odd Problems 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
Chapter 15 Question 1 Input area: Seats open 7 Shares outstanding 600,000 Shares you own \$39 Output area: Straight voting: Number of shares needed 300,001 Total cost \$11,700,039 Cumulative voting: Percentage of stock needed 12.50% Number of shares needed 75,001 Total cost \$2,925,039
Chapter 15 Question 3 Input area: Shares outstanding 1,200,000 Share price \$9.00 Number of seats 3 Output area: Percent of stock needed 25.00% Cumulative voting shares required 300,001 Dollars required in cumulative voting \$2,700,009

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

View Full Document
Chapter 15 Question 5 Input area: Par value \$1,000 YTM 7% Years to maturity 25 Output area: Price when purchased \$179.05 Price at end of year \$191.81 Taxes on zero \$12.75
Chapter 15 Question 7 Input area: Coupon rate 10.00% Call premium \$150

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.

## This note was uploaded on 03/12/2012 for the course FIN 610 taught by Professor Khawaja during the Spring '08 term at University of Maryland Baltimore.

### Page1 / 9

sample_excel_sol_chapter-15 - Chapter 15 Odd Problems Input...

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

View Full Document
Ask a homework question - tutors are online