Chapter_03 - Chapter 3 Input boxes in tan Output boxes in...

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

View Full Document Right Arrow Icon
Chapter 3 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 req the "Analysis ToolPak" or "Solver Add-In" be installed in Ex To install these, click on the Office button  then "Excel Options," "Add-Ins" and select "Go." Check "Analyis ToolPak" and  "Solver Add-In," then click "OK."
Background image of page 1

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

View Full DocumentRight Arrow Icon
quire that  xcel.
Background image of page 2
Chapter 3 Question 3 Input area: Accounts receivable Credit sales Output area: Receivables turnover #DIV/0! Days' sales in receivables #DIV/0! The average collection period for an outstanding accounts receivable was #DIV/0! days.
Background image of page 3

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

View Full DocumentRight Arrow Icon
Question 6 Input area: Addition to retained earnings Cash dividends Total equity Common shares outstanding Share price Sales Output area: Net income $- Earnings per share #DIV/0! Dividends per share #DIV/0! Book value per share #DIV/0! Market-to-book ratio
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 06/16/2011 for the course FIN 521 taught by Professor Varney during the Spring '11 term at Andrew Jackson.

Page1 / 10

Chapter_03 - Chapter 3 Input boxes in tan Output boxes in...

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

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