sample_excel_sol_chapter-15

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

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

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

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
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
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 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
Background image of page 4
Chapter 15 Question 7 Input area: Coupon rate 10.00% Call premium $150
Background image of page 5

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

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

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