FCF 9th edition Chapter 03

FCF 9th edition Chapter 03 - Chapter 3 Problems 1-30 Input...

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

View Full Document Right Arrow Icon
Chapter 3 Problems 1-30 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 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
Chapter 3 Question 1 Input area: Net working capital $1,370 Current liabilities 3,720 Inventory 1,950 Output area: Current assets $5,090 Current ratio 1.37 Quick ratio 0.84
Background image of page 2
Chapter 3 Question 2 Input area: Sales $29,000,000 Total assets 17,500,000 Total debt 6,300,000 Profit margin 8% Output area: Net income $2,320,000 Return on assets 13.26% Total equity $11,200,000 Return on equity 20.71%
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 3 Question 3 Input area: Accounts receivable $431,287 Credit sales 3,943,709 Output area: Receivables turnover 9.14 Days' sales in receivables 39.92 The average collection period for an outstanding accounts receivable was 39.92 days.
Background image of page 4
Chapter 3 Question 4 Input area: Ending inventory $407,534 Cost of goods sold 4,105,612 Output area: Inventory turnover 10.07 Days' sales in inventory 36.23 On average, a unit of inventory sat on the shelf 36.23 days.
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 3 Question 5 Input area: Total debt ratio 0.63 Output area: Debt/equity ratio 1.70 Equity multiplier 2.70
Background image of page 6
Chapter 3 Question 6 Input area: Addition to retained earnings $430,000 Cash dividends $175,000 Total equity $5,300,000 Common shares outstanding 210,000 Share price $63 Sales $4,500,000 Output area: Net income $605,000 Earnings per share $2.88 Dividends per share $0.83 Book value per share $25.24 Market-to-book ratio 2.50 P/E ratio 21.87 Sales per share $21.43 P/S ratio 2.94
Background image of page 7

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

View Full DocumentRight Arrow Icon
Chapter 3 Question 7 Input area: Equity multiplier 2.80 Total asset turnover 1.15 Profit margin 5.50% Output area: Return on equity 17.71%
Background image of page 8
Chapter 3 Question 8 Input area: Profit margin 6.80% Total asset turnover 1.95 Return on equity 18.27% Output area: Equity multiplier 1.38 Debt/equity ratio 0.38
Background image of page 9

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

View Full DocumentRight Arrow Icon
Chapter 3 Question 9 Input area: Decrease in inventory $375 Decrease in accounts payable 190 Increase in notes payable 210 Increase in accounts receivable 105 Output area: Decrease in inventory is a source of cash $375 Decrease in accounts payable is a use of cash (190) Increase in notes payable is a source of cash 210 Increase in accounts receivable is a use of cash (105) Change in cash $290
Background image of page 10
Chapter 3 Question 10 Input area: Cost of goods sold $28,384 Accounts payable balance 6,105 Output area: Payables turnover 4.65 Days' sales in payables 78.51
Background image of page 11

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

View Full DocumentRight Arrow Icon
Image of page 12
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 26

FCF 9th edition Chapter 03 - Chapter 3 Problems 1-30 Input...

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

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