Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with questions 8, 19-20 Twenty metrics of liquidity, Solvency, and Profitability The comparative financial statements of Automotive Solutions Inc. are as follows.

I need help with questions 8, 19-20

Twenty metrics of liquidity, Solvency, and Profitability

The comparative financial statements of Automotive Solutions Inc. are as follows. The market price of Automotive Solutions Inc. common stock was $69 on December 31, 20Y8.

AUTOMOTIVE SOLUTIONS INC. Comparative Income Statement For the Years Ended December 31, 20Y8 and 20Y7
20Y8 20Y7
Sales $3,994,560 $3,680,420
Cost of goods sold (1,423,500) (1,309,620)
Gross profit $2,571,060 $2,370,800
Selling expenses $(886,200) $(1,106,070)
Administrative expenses (754,910) (649,590)
Total operating expenses (1,641,110) (1,755,660)
Operating income $929,950 $615,140
Other revenue and expense:
Other income 48,950 39,260
Other expense (interest) (288,000) (158,400)
Income before income tax $690,900 $496,000
Income tax expense (82,900) (59,100)
Net income $608,000 $436,900

AUTOMOTIVE SOLUTIONS INC. Comparative Statement of Stockholders Equity For the Years Ended December 31, 20Y8 and 20Y7
20Y8 20Y7
Preferred Stock Common Stock Retained Earnings Preferred Stock Common Stock Retained Earnings
Balances, Jan. 1 $550,000 $630,000 $2,534,025 $550,000 $630,000 $2,133,175
Net income 608,000 436,900
Dividends:
Preferred stock (7,700) (7,700)
Common stock (28,350) (28,350)
Balances, Dec. 31 $550,000 $630,000 $3,105,975 $550,000 $630,000 $2,534,025

AUTOMOTIVE SOLUTIONS INC. Comparative Balance Sheet December 31, 20Y8 and 20Y7
Dec. 31, 20Y8 Dec. 31, 20Y7
Assets
Current assets:
Cash $893,620 $603,410
Temporary investments 1,352,510 999,930
Accounts receivable (net) 722,700 678,900
Inventories 540,200 408,800
Prepaid expenses 169,061 120,680
Total current assets $3,678,091 $2,811,720
Long-term investments 1,002,457 158,139
Property, plant, and equipment (net) 4,320,000 3,888,000
Total assets $9,000,548 $6,857,859
Liabilities
Current liabilities $1,114,573 $1,163,834
Long-term liabilities:
Mortgage note payable, 8%, due in 15 years $1,620,000 $0
Bonds payable, 8%, due in 20 years 1,980,000 1,980,000
Total long-term liabilities $3,600,000 $1,980,000
Total liabilities $4,714,573 $3,143,834
Stockholders' Equity
Preferred $0.70 stock, $50 par $550,000 $550,000
Common stock, $10 par 630,000 630,000
Retained earnings 3,105,975 2,534,025
Total stockholders' equity $4,285,975 $3,714,025
Total liabilities and stockholders' equity $9,000,548 $6,857,859

Instructions:

Determine the following measures for 20Y8. Round ratio values to one decimal place and dollar amounts to the nearest cent. For number of days' sales in receivables and number of days' sales in inventory, round intermediate calculations to the nearest whole dollar and final amounts to one decimal place. Assume there are 365 days in the year.

1. Working capital $
2. Current ratio
3. Quick ratio
4. Accounts receivable turnover
5. Days' sales in receivables days
6. Inventory turnover
7. Days' sales in inventory days
8. Debt ratio %
9. Ratio of liabilities to stockholders' equity
10. Ratio of fixed assets to long-term liabilities
11. Times interest earned times
12. Times preferred dividends earned times
13. Asset turnover
14. Return on total assets %
15. Return on stockholders equity %
16. Return on common stockholders equity %
17. Earnings per share on common stock $
18. Price-earnings ratio
19. Dividends per share of common stock $
20. Dividend yield %

Feedback

1. Subtract current liabilities from current assets. 2. Divide current assets by current liabilities. 3. Divide quick assets by current liabilities. Quick assets are cash, temporary investments, and receivables. 4. Divide net sales by average accounts receivable. Average Accounts receivable = (Beginning Net Accounts Receivable + Ending Net Accounts Receivable) 2 5. Divide average accounts receivable by average daily sales. Average Accounts receivable = (Beginning Net Accounts Receivable + Ending Net Accounts Receivable) 2 Average daily sales are net sales divided by 365 days. 6. Divide cost of goods sold by average inventory. Average Inventory = (Beginning Inventories + Ending Inventories) 2 7. Divide average inventory by average daily cost of goods sold. Average Inventory = (Beginning Inventories + Ending Inventories) 2 Average cost of goods sold are cost of goods sold divided by 365 days. 8. Divide total liabilities by total assets. 9. Divide total liabilities by total stockholders equity. 10. Divide property, plant and equipment (net) by long-term liabilities. 11. Divide the sum of income before income tax plus interest expense by interest expense. 12. Divide net income by preferred dividends [Preferred stock par value x dividend per preferred share]. 13. Divide net sales by average property, plant & equipment, . Average PPE = (Beginning PPE + Ending PPE) 2 14. Divide the sum of net income plus interest expense by average total assets. Average total assets = (Beginning Total Assets + Ending Total Assets) 2 15. Divide net income by average stockholders equity. Average stockholders equity = (Beginning StockholdersEquity + Ending StockholdersEquity) 2 16. Divide net income minus preferred dividends [Preferred stock par value x dividend per preferred share] by average common stockholders equity. Common StockholdersEquity = Common Stock + Retained Earnings Average Common StockholdersEquity = (Beginning Common Stockholders equity + Ending Common StockholdersEquity) 2 17. Divide net income minus preferred dividends [Preferred stock par value x dividend per preferred share] by common shares outstanding (common stock par value). 18. Divide common market share price by common earnings per share (use answer from requirement 17). 19. Divide common dividends (from Statement of Stockholders Equity) by common shares outstanding (common stock par value). 20. Divide common dividends per share (use answer from requirement 19) by market share price.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Labor Economics

Authors: Campbell McConnell, Stanley Brue, David Macpherson

9th Edition

0073375950, 9780073375953

More Books

Students also viewed these Accounting questions

Question

How do you decide how much background to provide in a report?

Answered: 1 week ago

Question

What do you think is likely to be Liams problem? Discuss.

Answered: 1 week ago

Question

What laws were passed because of domestic violence?

Answered: 1 week ago