sample_excel_sol_chapter_14

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

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

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

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

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

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

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

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.

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

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online