Paul Sabin organized Sabin Electronics 10 years ago in order to produce and sell several electronic...

60.1K

Verified Solution

Question

Accounting

Paul Sabin organized Sabin Electronics 10 years ago in order toproduce and sell several electronic devices on which he had securedpatents. Although the company has been fairly profitable, it is nowexperiencing a severe cash shortage. For this reason, it isrequesting a $500,000 long-term loan from Gulfport State Bank,$100,000 of which will be used to bolster the cash account and$400,000 of which will be used to modernize certain key items ofequipment. The company’s financial statements for the two mostrecent years follow:

  

SABIN ELECTRONICS
Comparative Balance Sheet
This YearLast Year
Assets
  Current assets:
     Cash$50,900$79,000
     Marketable securities9,200
     Accounts receivable, net354,800158,000
     Inventory710,000316,000
     Prepaid expenses15,30011,800
  Total current assets1,131,000574,000
  Plant and equipment, net1,000,000726,000
  Total assets$2,131,000$1,300,000
Liabilities and Shareholders’ Equity
  Liabilities:
     Current liabilities$588,000$455,500
     Bonds payable, 12%300,000300,000
  Total liabilities888,000755,500
  Shareholders’ equity:
     Preferred shares, no par ($6;14,320 shares issued)179,000179,000
     Common shares, no par (unlimitedauthorized,
       17,000 issued)
170,000170,000
     Retained earnings894,000195,500
  Total shareholders’ equity1,243,000544,500
  Total liabilities and shareholders’ equity$2,131,000$1,300,000
SABIN ELECTRONICS
Comparative Income Statement
This YearLast Year
  Sales$3,700,000$3,400,000
  Less: Cost of goods sold2,847,0002,680,000
  Gross margin853,000720,000
  Less: Operating expenses481,000427,000
  Net operating income372,000293,000
  Less: Interest expense36,00036,000
  Net income before taxes336,000257,000
  Less: Income taxes (30%)100,80077,100
  Net income235,200179,900
  Dividends paid:
     Preferred dividends20,00020,000
     Common dividends66,60058,450
  Total dividends paid86,60078,450
  Net income retained148,600101,450
  Retained earnings, beginning of year525,400423,950
  
  Retained earnings, end of year$674,000$525,400

     During the past year, the companyintroduced several new product lines and raised the selling priceson a number of old product lines in order to improve its profitmargin. The company also hired a new sales manager, who hasexpanded sales into several new territories. Sales terms are 2/10,n/30. All sales are on account. Assume that the following ratiosare typical of firms in the electronics industry:

  Current ratio2.5to 1
  Acid-test (quick) ratio1.3to 1
  Average age of receivables18days
  Inventory turnover in days60days
  Debt-to-equity ratio0.90to 1
  Times interest earned6.0times
  Return on total assets13%
  Price–earnings ratio12
Required:
1.

To assist the Gulfport Bank in making a decision about the loan,compute the following ratios for both this year and last year(Use 365 days a year. Round your intermediate calculationsto 1 decimal place. Round Debt-to-equity ratio to 3 decimal placesand other answers to 2 decimal places.):

a.The amount of working capital.
b.The current ratio.
c.The acid-test (quick) ratio.
d.

The average age of receivables (the accounts receivable at thebeginning of last year totalled $156,000).

e.

The inventory turnover in days (the inventory at the beginningof last year totalled $312,000).

f.The debt-to-equity ratio.
g.The times interest earned.
2.For both this year and last year:
(a)

Present the balance sheet in common-size format. (Leaveno cells blank - be certain to enter "0" wherever required. Roundyour answers to 1 decimal place.)

(b)

Present the income statement in common-size format down throughnet income. (Input all values as positive values. Roundyour answers to 1 decimal place.)

Answer & Explanation Solved by verified expert
4.2 Ratings (706 Votes)
Solution 1a Working Capital This Year Last Year Total Current Assets A 1131000 574000 Total Current Liabilities B 588000 455500 Working Capital Total Current Assets Total Current Liabilities 543000 118500 1b Current Ratio This Year Last Year Total Current    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students