Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several
ID: 2406323 • Letter: P
Question
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,000Explanation / Answer
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