- Chapter 7 Problems 1,5 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE Some functions

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

View Full Document Right Arrow Icon
Chapter 7 Problems 1,5 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 7 Question 1 Income Statements Input area: Cost of goods sold $118,000.00 Investing income 1,500 Net sales 195,000 Operating expenses 41,000 Interest expense 4,200 Divedends 4,000 Tax rate 35% Output Area: Net sales $195,000 Cost of goods sold 118,000 Gross profit $77,000 Operating expenses 41,000 Operating income $36,000 Investing income 1,500 Interest expense 4,200 Pretax income $30,300 Income taxes 10,605 Net income $19,695 Divedends $4,000 Retained earnings $15,695
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 7 Question 2 Balance Sheets Input area: Balance Sheets Current liabilities $24,000.00 Cash 28,000 Long term debt 91,000 Other assets 18,000 Fixed assets 105,000 Other liabilities 7,000 Investments 23,000 Operating assets 62,000 Output area: Cash $28,000 Current liabilities $24,000 Operating assets 62,000 Long term debt 91,000 Fixed assets 105,000 Other liabilities 7,000 Investments 23,000 Other assets 18,000 Stockholder equity 114,000 Total assets $236,000 Total liability and equity $236,000
Background image of page 4
Chapter 7 Question 3 Performance Ratios Input area: Income Statements Net sales $195,000 Cost of goods sold 118,000 Gross profit $77,000 Operating expenses 41,000 Operating income $36,000 Investing income 1,500 Interest expense 4,200 Pretax income $30,300 Income taxes 10,605 Net income $19,695 Divedends $4,000 Retained earnings $15,695 Balance Sheets Cost of goods sold $28,000 Net sales $24,000 Pretax income 62,000 Gross profit 91,000 Operating income $105,000 Investing income 7,000 Interest expense 23,000 $- Operating expenses $18,000 Stockholder equity 114,000 Total assets $236,000 Total liability and equity $236,000 Output area: Gross margin 10.10% Operating margin 18.46% ROA 8.35% ROE 17.28%
Background image of page 5

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

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

This note was uploaded on 04/17/2011 for the course FINANCE 1001 taught by Professor Lochengshu during the Spring '11 term at National Cheng Kung University.

Page1 / 22

- Chapter 7 Problems 1,5 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE Some functions

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