Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on...

50.1K

Verified Solution

Question

Accounting

Paul Sabin organized Sabin Electronics 10 years ago to produceand 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 $530,000 long-term loan from Gulfport State Bank,$115,000 of which will be used to bolster the Cash account and$415,000 of which will be used to modernize equipment. Thecompany’s financial statements for the two most recent yearsfollow:

Sabin Electronics
Comparative Balance Sheet
This YearLast Year
Assets
Current assets:
Cash$82,000$180,000
Marketable securities021,000
Accounts receivable, net516,000330,000
Inventory980,000625,000
Prepaid expenses22,00025,000
Total current assets1,600,0001,181,000
Plant and equipment, net1,570,2001,400,000
Total assets$3,170,200$2,581,000
Liabilities and Stockholders Equity
Liabilities:
Current liabilities$815,000$460,000
Bonds payable, 12%750,000750,000
Total liabilities1,565,0001,210,000
Stockholders' equity:
Common stock, $15 par720,000720,000
Retained earnings885,200651,000
Total stockholders’ equity1,605,2001,371,000
Total liabilities and stockholders' equity$3,170,200$2,581,000
Sabin Electronics
Comparative Income Statement andReconciliation
This YearLast Year
Sales$5,150,000$4,440,000
Cost of goods sold3,905,0003,480,000
Gross margin1,245,000960,000
Selling and administrative expenses659,000554,000
Net operating income586,000406,000
Interest expense90,00090,000
Net income before taxes496,000316,000
Income taxes (30%)148,80094,800
Net income347,200221,200
Common dividends113,00092,000
Net income retained234,200129,200
Beginning retained earnings651,000521,800
Ending retained earnings$885,200$651,000

During the past year, the company introduced several new productlines and raised the selling prices on a number of old productlines in order to improve its profit margin. The company also hireda new sales manager, who has expanded sales into several newterritories. Sales terms are 3/10, n/30. All sales are onaccount.

Required:

1. To assist in approaching the bank about the loan, Paul hasasked you to compute the following ratios for both this year andlast year:

a. The amount of working capital.

b. The current ratio.

c. The acid-test ratio.

d. The average collection period. (The accounts receivable atthe beginning of last year totaled $280,000.)

e. The average sale period. (The inventory at the beginning oflast year totaled $530,000.)

f. The operating cycle.

g. The total asset turnover. (The total assets at the beginningof last year were $2,510,000.)

h. The debt-to-equity ratio.

i. The times interest earned ratio.

j. The equity multiplier. (The total stockholders’ equity at thebeginning of last year totaled $1,361,000.)

2. For both this year and last year:

a. Present the balance sheet in common-size format.

b. Present the income statement in common-size format downthrough net income.

NB: Please I need all parts to be answered

Answer & Explanation Solved by verified expert
4.3 Ratings (670 Votes)
Ans A Working capital Total current assets Total current liabilities This year 1600000 815000 785000 Last year 1181000 460000 721000 Ans B Current ratio Total current assets Total current liabilities This year 1600000 815000 196 1 Last year 1181000 460000 257 1 Ans C Acid test ratio Total current assets Inventory Prepaid expenses Total current liabilities This year 1600000 980000 22000 815000 073 1 Last year 1181000 625000 25000 460000 115 1 Ans D Average collection period No of days in year Net credit sales Average accounts receivables This year 365 5150000 423000 2998 days Last year 365 4440000 305000 2507 days Average receivable Beginning receivables Ending receivables 2 This year 330000 516000 2 423000 Last year 280000    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