Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several
ID: 341238 • 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 s severe cash shortage. For this reason, it is requesting a $890,000 long-term loan from Gulfport State Bank, 5195,000 of which will be used to bolster the Cesh account and $495,000 of which will be used to modernize equipment. The company's financial statements for the two most recent years follow: Sabin Electronics Comperative Balance Sheet This Year Last Year Assets Current assets $ 146,000 340,000 Marketable securities Accounts receivable, net 16,000 724,000 1,135,000 490,000 41,000 1,672,000 Prepaid expenses Total current assets Plant and equipment, net 2,043,000 2,229,400 1,480,000 Total assets $4,272,400 S 3,152,000 Liabilities and Stockholders Equity Lisbilities 410,000 Current lisbilities Bonds payable, 12% S 895,00O 850,000 Total lisbilities 1,745,000 1,280,000 Stockholders' equity: Common stock, 515 par Retained eamings 840,000 1,687,400 840,000 1,052,000 1,892,000 $4,272,400 S 3,152,000 Total stockholders' equity 2,527,400 Total lisbilities and equityExplanation / Answer
This Year Last Year i time interest earned ration EBIT/Interest 1092000/327600 3.33 592000/177600 3.33 j Equity Multiplier Total Asset/stock holder equity 4272400/2527400 1.69 3152000/1892000 1.67 Absolute Common Size 2a. This Year Last Year Formula This Year Last Year Assets Respective amount/Total Asset Current Asset: -Cash 146000 340000 Cash/Total Asset 4272400 and 3152000 3.42 10.79 -Marketable Securities 0 16000 Sec/Total Asset 4272400 - 0.51 -Accounts Receivable 724000 490000 Receivable/Total Asset 4272400 16.95 15.55 -Inventory 1135000 785000 Inventory/Total Asset 4272400 26.57 24.90 -Prepaid 38000 41000 Prepaid/Total Asset 4272400 0.89 1.30 Total Current Asset 2043000 1672000 47.82 53.05 Plant and Equipment 2229400 1480000 Plant/Total Asset 4272400 52.18 46.95 Total Asset 4272400 3152000 100.00 100.00 Laibilities and equity Liabilities: -Current Liabilites 895000 410000 Current Liabi/Total Asset 4272400 20.95 13.01 -Bonds Payable 12% 850000 850000 Bond/Total Asset 4272400 19.90 26.97 Total Liabilities 1745000 1260000 40.84 39.97 Equity: -Common Stock 840000 840000 Common Stock/Total Asset 4272400 19.66 26.65 -Retained Earning 1687400 1052000 Retained Earning/Total Asset 4272400 39.50 33.38 Total Stockholder equity 2527400 1892000 59.16 60.03 Total Liabilitie and Equity 4272400 3152000 100.00 100.00 2b. Absolute Common Size This Year Last Year This Year Last Year Sales 5950000 4920000 Sale/Sale 5950000 and 4930000 100.00 100.00 Cost of goods sold 4065000 3640000 COGS/Sale 5950000 and 4930000 68.32 73.98 Gross Margin 1885000 1280000 GM/Sale 5950000 and 4930000 31.68 26.02 Selling and administrative 691000 586000 Selling adm/Sale 5950000 and 4930000 11.61 11.91 Net Operating Income 1194000 694000 Net ope income/Sale 5950000 and 4930000 20.07 14.11 Interest Expense 102000 102000 Int exp/Sale 5950000 and 4930000 1.71 2.07 Net income before tax 1092000 592000 before tax/Sale 5950000 and 4930000 18.35 12.03 Income Tax 327600 177600 tax/Sale 5950000 and 4930000 5.51 3.61 Net Income 764400 414400 net income/Sale 5950000 and 4930000 12.85 8.42