sample_excel_sol_chapter_14

sample_excel_sol_chapter_14 - a. Common stock $2,050,000...

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

View Full Document Right Arrow Icon
Chapter 14 Problems 1-7 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 14 Question 1 Input Area: Common stock par value $0.50 Common stock $165,320 Capital surplus $2,876,145 Retained earnings $2,370,025 Total $5,411,491 Output Area: a. Shares outstanding 330,640 b. Capital from sale of shares $3,041,465 Average sale price $9.20 c. Book value per share $16.37
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 14 Question 3 Input Area: Common stock par value $5.00 Shares outstanding 410,000 Price over par 30% Net income $650,000 Payout ratio 30% Previous retained earnings $3,545,000 New shares issued 25,000 Issue price $4 Output Area:
Background image of page 4
Background image of page 5

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

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

Unformatted text preview: a. Common stock $2,050,000 Average sale price $6.50 Capital surplus $615,000 New retained earnings $4,000,000 Comon stock $2,050,000 Capital surplus $615,000 Retained earnings $4,000,000 Total equity $6,665,000 b. Comon stock $2,050,000 Capital surplus $590,000 Retained earnings $4,000,000 Total equity $6,640,000 Chapter 7 Question 5 Input area: Seats open 3 Shares outstanding 2,500 Shares you own 300 Output area: Percentage of stock needed 25.00% Number of shares needed 626 Number of shares to buy 326 Chapter 7 Question 7 Input area: Percent of stock owned 17.30% Number of seats 8 Number of seats if staggered 4 Output area: Percent of stock needed 11.11% Her nominee is guaranteed election. Staggered election: Percent of stock needed 20.00% Her nominee is not guaranteed election....
View Full Document

Page1 / 6

sample_excel_sol_chapter_14 - a. Common stock $2,050,000...

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