sample_excel_sol_chapter_18

sample_excel_sol_chapter_18 - Chapter 18 Problems 1-24...

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

View Full Document Right Arrow Icon
Chapter 18 Problems 1-24 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 18 Question 1 Input Area: Dividend per share $6.00 Tax rate 15% Price $80 Output Area: After-tax Dividend $5.10 Ex-dividend price $74.90
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 18 Question 3 Input Area: Common stock #REF! Par value #REF! Capital surplus #REF! Retained earnings #REF! Total owners'Equity #REF! Stock price #REF! a. Stock split 4 for 1 b. Stock split 1 for 5 Output Area: a. New shares outstanding #REF! The accounts are unchanged except that par value is now #REF! b. New shares outstanding #REF! The accounts are unchanged except that par value is now #REF!
Background image of page 4
Chapter 18 Question 5 Input Area: Shares outstanding 5,000 Dividend per share $1.50 Cash $20,000 Equity $175,000 Fixed assets $155,000 Total $175,000 Total $175,000 Output Area: $35.00 $33.50 The equity and cash accounts will decline by: $7,500 Cash $12,500 Equity $167,500 Fixed assets $155,000 Total $167,500 Total $167,500 Market Value Balance Sheet Price 0 Price X Market Value Balance Sheet
Background image of page 5

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

View Full DocumentRight Arrow Icon
Chapter 18 Question 7 Input Area: Shares outstanding
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 15

sample_excel_sol_chapter_18 - Chapter 18 Problems 1-24...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online