Question
The following financial statements apply to Walton Company: Year 2 Year 1 Revenues $ 220,700 $ 181,100 Expenses Cost of goods sold 125,300 101,500 Selling
The following financial statements apply to Walton Company:
Year 2 | Year 1 | ||||||
Revenues | $ | 220,700 | $ | 181,100 | |||
Expenses | |||||||
Cost of goods sold | 125,300 | 101,500 | |||||
Selling expenses | 19,500 | 17,500 | |||||
General and administrative expenses | 9,500 | 8,500 | |||||
Interest expense | 2,600 | 2,600 | |||||
Income tax expense | 20,200 | 17,600 | |||||
Total expenses | 177,100 | 147,700 | |||||
Net income | $ | 43,600 | $ | 33,400 | |||
Assets | |||||||
Current assets | |||||||
Cash | $ | 5,300 | $ | 7,200 | |||
Marketable securities | 2,500 | 2,500 | |||||
Accounts receivable | 35,500 | 30,200 | |||||
Inventories | 102,000 | 94,800 | |||||
Prepaid expenses | 4,900 | 3,900 | |||||
Total current assets | 150,200 | 138,600 | |||||
Plant and equipment (net) | 105,300 | 105,300 | |||||
Intangibles | 20,800 | 0 | |||||
Total assets | $ | 276,300 | $ | 243,900 | |||
Liabilities and Stockholders Equity | |||||||
Liabilities | |||||||
Current liabilities | |||||||
Accounts payable | $ | 38,500 | $ | 34,500 | |||
Other | 16,200 | 16,300 | |||||
Total current liabilities | 54,700 | 50,800 | |||||
Bonds payable | 64,100 | 65,100 | |||||
Total liabilities | 118,800 | 115,900 | |||||
Stockholders equity | |||||||
Common stock (50,000 shares) | 114,200 | 114,200 | |||||
Retained earnings | 43,300 | 13,800 | |||||
Total stockholders equity | 157,500 | 128,000 | |||||
Total liabilities and stockholders equity | $ | 276,300 | $ | 243,900 | |||
Required Calculate the following ratios for Year 1 and Year 2. Since opening balance numbers are not presented do not use averages when calculating the ratios for Year 1. Instead, use the number presented on the Year 1 balance sheet. a. Net margin. (Round your answers to 2 decimal places.) b. Return on investment. (Round your answers to 2 decimal places.) c. Return on equity. (Round your answers to 2 decimal places.) d. Earnings per share. (Round your answers to 2 decimal places.) e. Price-earnings ratio (market prices at the end of Year 1 and Year 2 were $6.13 and $4.92, respectively). (Round your intermediate calculations and final answers to 2 decimal places.) f. Book value per share of common stock. (Round your answers to 2 decimal places.) g. Times interest earned. (Round your answers to 2 decimal places.) h. Working capital. i. Current ratio. (Round your answers to 2 decimal places.) j. Quick (acid-test) ratio. (Round your answers to 2 decimal places.) k. Accounts receivable turnover. (Round your answers to 2 decimal places.) l. Inventory turnover. (Round your answers to 2 decimal places.) m. Debt-to-equity ratio. (Round your answers to 2 decimal places.) n. Debt-to-assets ratio. (Round your answers to the nearest whole percent.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started