Paul Sabin organized Sabin Electronics 10 years ago to produ

Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on which he had secured patents. Although the company has been fairly profitable, it is now experiencing a severe cash shortage. For this reason, it is requesting a $590,000 long-term loan from Gulfport State Bank, $145,000 of which will be used to bolster the Cash account and $445,000 of which will be used to modernize equipment. The company’s financial statements for the two most recent years follow:

To assist in approaching the bank about the loan, Paul has asked you to compute the following ratios for both this year and last year:

          

            

            

The average collection period. (The accounts receivable at the beginning of last year totaled $340,000.) (Round your intermediate calculations and final answers to 1 decimal place. Use 365 days in a year.)

            

            

            

The total asset turnover. (The total assets at the beginning of last year were $2,690,000.) (Round your answers to 2 decimal places.)

            

            

          

          

Present the balance sheet in common-size format. (Round your percentage answers to 1 decimal place (i.e., 0.1234 should be entered as 12.3).)

Present the income statement in common-size format down through net income. (Round your percentage answers to 1 decimal place (i.e., 0.1234 should be entered as 12.3).)

Sabin Electronics
Comparative Balance Sheet
	This Year	Last Year
Assets
Current assets:
Cash	$	104,000	$	240,000
Marketable securities		0		27,000
Accounts receivable, net		594,000		390,000
Inventory		1,035,000		685,000
Prepaid expenses		26,000		31,000
Total current assets		1,759,000		1,373,000
Plant and equipment, net		1,751,000		1,420,000
Total assets	$	3,510,000	$	2,793,000
Liabilities and Stockholders Equity
Liabilities:
Current liabilities	$	845,000	$	520,000
Bonds payable, 12%		700,000		700,000
Total liabilities		1,545,000		1,220,000
Stockholders\' equity:
Common stock, $15 par		960,000		960,000
Retained earnings		1,005,000		613,000
Total stockholders’ equity		1,965,000		1,573,000
Total liabilities and equity	$	3,510,000	$	2,793,000

Solution

This year Last year a Current assets 1759000 1373000 Current liabilities 845000 520000 Working capital = Current assets - current liabilities Working capital 914000 853000 b Current ratio = Current assets / current liabilities Current ratio 2.08 2.64 c Acid test ratio = Liquid assets / current liabilities Liquid assets = current assets - prepaid expense - merchandise inventory Liquid assets 698000 657000 Current liabilities 845000 520000 Acid test ratio 0.83 1.26 Accounts receivable turnover = net credit sales /Average accounts receivable Net sales 5450000 4620000 Beginning accounts receivable 390000 340000 Ending accounts receivable 594000 390000 Average accounts receivable 492000 365000 Accounts receivable turnover 11.1 12.7 d Average collection period = 365 / accounts receivable tunover Average collection period 33.0 28.8 Days Inventory turnover = Cost of goods sold / Average inventory Cost of goods sold 3965000 3540000 Beginning inventory 685000 590000 Ending inventory 1035000 685000 Average inventory 860000 637500 Average inventory = (Beginning + Ending )/2 Inventory turnover 4.6 5.6 e Average sales period = 365 / inventory turnover Average sales period 79.2 65.7 Days f Operating cycle = days sales in inventory + average collection period Operating cycle 112.1 94.6 Days g Assets turnover ratio = Net sales / average total assets Net sales 5450000 4620000 Beginning total assets 2793000 2690000 Ending total assets 3510000 2793000 Average total assets 3151500 2741500 Assets turnover ratio 1.73 1.69