15.

Ratio Analysis: Decision Focus LO1, 2, 4, 5, 6

Avantronics is a manufacturer of electronic components and accessories that has total assets of $20,000,000. Selected financial ratios for Avantronics and the industry averages for firms of similar size are as follows:

	Avantronics	Industry Average
	Year 1	Year 2	Year 3
Current ratio	2.09	2.27	2.51	2.24
Quick ratio	1.15	1.12	1.19	1.22
Inventory turnover	2.40	2.18	2.02	3.50
Profit margin	0.14	0.15	0.17	0.11
Debt-to-equity ratio	0.24	0.37	0.44	0.35

Avantronics is being reviewed by several entities whose interests vary, and the companys financial ratios are a part of the data being considered. Each of the following parties must recommend an action based on its evaluation of Avantronicss financial position:

MidCoastal Bank. The bank is processing Avantronicss application for a new five-year term note. MidCoastal has been the banker for Avantronics for several years but must reevaluate the companys financial position for each major transaction.

Ozawa Company. Ozawa is a new supplier to Avantronics and must decide on the appropriate credit terms to extend to the company.

Drucker & Denon. A brokerage firm specializing in the stock of electronics firms that are sold over the counter, Drucker & Denon must decide whether it will include Avantronics in a new fund being established for sale to Drucker & Denons clients.

Working Capital Management Committee. This is a committee of Avantronicss management personnel chaired by the chief operating officer. The committee is responsible for periodically reviewing the companys working-capital position, comparing actual data against budgets, and recommending changes in strategy as needed.

Required

A.Describe the analytical use of each of the five ratios presented in the chart.

B.For each of the four entities described, identify the financial ratios, from those ratios presented, that would be most valuable as a basis for its decision regarding Avantronics.

C.Discuss what the financial ratios presented in the question reveal about Avantronics. Support your answer by citing specific ratio levels and trends, as well as the interrelationships among these ratios.

16.

Horizontal Analysis LO2

Following are the income statements for Marthas Miscellaneous for Year 1 and Year 2:

Marthas Miscellaneous Comparative Statements of Income and Retained Earnings
			$	%
	Year 2	Year 1	Change	Change
Sales revenue	$700,000	$650,000
Cost of goods sold	500,000	455,000
Gross profit	$200,000	$195,000
Payroll expense	$ 50,000	$ 42,250
Insurance expense	30,000	29,000
Rent expense	18,000	18,000
Depreciation	35,000	15,000
Total expenses	$133,000	$104,250
Operating income	$ 67,000	$ 90,750
Interest expense	(7,000)	(5,000)
Gain on vehicle sale	25,000
Loss on sale of securities	(25,000)
Interest revenue	75,000	50,000
Net income before interest and taxes	$135,000	$135,750
Income taxes	40,000	40,250
Net income	$ 95,000	$ 95,500
Dividends	38,000	38,000
Total retained earnings	$ 57,000	$ 57,500
Retained earnings, 1/1	193,500	136,000
Retained earnings, 12/31	$250,500	$193,500

Required

Complete the comparative income statement by computing dollar change ($ change) and percentage change (% change).

18.

Comprehensive Ratio Analysis LO4, 5, 6

The 2012 financial statements for the Griffin Company are as follows:

Griffin Company Statement of Financial Position
	12/31/12	12/31/11
Assets
Cash	$ 40,000	$ 10,000
Accounts receivable	30,000	55,000
Inventory	110,000	70,000
Property, plant, and equipment	250,000	257,000
Total assets	$430,000	$392,000
Liabilities and Stockholders Equity
Current liabilities	$ 60,000	$ 50,000
5% mortgage payable	120,000	162,000
Common stock (30,000 shares)	150,000	150,000
Retained earnings	100,000	30,000
Total liabilities and stockholders equity	$430,000	$392,000
Griffin Company Income Statement For the Year Ended December 31, 2012
Sales on account	$420,000
Less expenses:
Cost of goods sold	$214,000
Salary expense	50,000
Depreciation expense	7,000
Interest expense	9,000
Total expenses	$280,000
Income before taxes	$140,000
Income tax expense (50%)	70,000
Net income	$ 70,000

Required

Compute the following ratios for the Griffin Company for the year ending December 31, 2012:

A.Profit margin ratio (before interest and taxes)

B.Total asset turnover

C.Rate of return on total assets

D.Rate of return on common stockholders equity

E.Earnings per share of stock

F.Inventory turnover

G.Current ratio

H.Quick ratio

I.Accounts receivable turnover

J.Debt-to-equity ratio

K.Times interest earned

14.

Adjustments to Income via the Indirect Method: Operating Activites LO1, 2, 3

The following account balances are for the noncash current assets and current liabilities of Wynn Bicycle Company at the end of 2011 and 2012.

	December 31
	2011	2012
Accounts receivable	$ 4,000	$ 6,000
Inventory	30,000	20,000
Office supplies	5,000	8,000
Accounts payable	10,000	7,000
Salaries and wages payable	2,500	4,000
Interest payable	1,500	2,500
Income taxes payable	5,500	2,500

In addition, the income statement for 2012 is as follows:

Sales revenue	$110,000
Cost of goods sold	85,000
Gross profit	$ 25,000
General and administrative expense	$ 9,000
Depreciation expense	2,000
Income before interest and taxes	$ 14,000
Interest expense	2,000
Income before tax	$ 12,000
Income tax expense	4,800
Net income	$ 7,200

Required

A.Prepare the operating activities section of the statement of cash flows, using the indirect method.

B.What does the use of the direct method reveal about a company that the indirect method does not?