{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

sample_excel_sol_chapter-15

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

This preview shows pages 1–7. 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
k"
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

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

View Full Document
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
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

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

View Full Document
Chapter 15 Question 7 Input area: Coupon rate 10.00% Call premium \$150
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}