please solve it and fill in the appropriate figures
Save & Exh Check my work Paul Sabin organized Sabin Electronics 10 years ago in order 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 $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 of equipment. The company's financial statements for the two most recent years follow: SABIN ELECTRONICS Comparative Balance This Year Last Ye Assets Current assets: $ 57.400 $ Marketable securities Inventory 401.800 Prepaid expenses 95-000 fetal current assets 1.281.000 Total assets 2, 281,000 51,530, Liabilities and Sha olders' Equity Liabilities: current Haelli Total liabilities $64000 Preferred shares, no Setaon shares, no par (unlimited authorized. 22,090 issued) 209.00 209.C Total shareholders 323, Total liabilities and shareholders" equity $2.281,000 $ 1,550. SABIN ELECTRONICS Comparative Income Statement Gross margin separating expenses Less: Interest expense Less: Income taxes (305) 273, 706 Dividends paid: preferred dividend 75:806 Retained earnings. During the past year, the company introduced several new product lines and raised the selling prices on a number of old product lines in order to improve its profit margin. The company also hired a new sales manager, who has expanded sales into several new territories. Sales terms are 2/10, n/30. All sales are on account. Assume that the following ratios are typical of firms in the electronics industry: Current ratio Acid-test (quick) ratio Inventory turnover in days 60 Says mes interest earn Price-earnings ratio 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 calculations to 1 decimal place. Round Debt-to-equity ratio to 3 decimal places and 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 the beginning of last year totalled $186,000). e. The inventory turnover in days (the inventory at the beginning of last year totalled $372,000). f. The debt-to-equity ratio. g. The times interest earned. This Year Last Year forking capa Current ratio Acks-test ratio Average age of receiv Inventory turnover in days Debs-to-equity ratio 2. For both this year and last year: (a) Present the balance sheet in common-size format. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 1 decimal place.) SABIN ELECTRONICS common-Size Balance Sheets This Year Last Year Marketable securities otal current assets Plant and equipment n Total assets Current liabilities Bonds payable, 12% Total liabilities Shareholders' equity Preferred shares, no par, $6 permon shares, no par Retained earnings Total shareholders' equity Total liabilities and equity (b) Present the income statement in common-size format down through net income. (Input all values as positive values. Round your answers to 1 decimal place.) SABIN ELECTRONICS mmin-Size Balance Sheet This Year Last Year Less cost of goods sold Gross margin Less operating experts Net operating incom Net income before tases Less income taxes
