{"id":78107,"date":"2018-02-20T23:50:30","date_gmt":"2018-02-20T23:50:30","guid":{"rendered":"https:\/\/writemyessayfree.com\/problem-15-18-common-size-statements-and-financial-ratios-for-a-loan-application-lo15-1-lo15-2-lo15-3-lo15-4-2"},"modified":"2017-08-18T07:18:26","modified_gmt":"2017-08-18T07:18:26","slug":"problem-15-18-common-size-statements-and-financial-ratios-for-a-loan-application-lo15-1-lo15-2-lo15-3-lo15-4-2","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/problem-15-18-common-size-statements-and-financial-ratios-for-a-loan-application-lo15-1-lo15-2-lo15-3-lo15-4-2\/","title":{"rendered":"PROBLEM 15\u201318 Common-Size Statements and Financial Ratios for a Loan Application [LO15\u20131, LO15\u20132, LO15\u20133, LO15\u20134]"},"content":{"rendered":"<p><a class=\"problem-15-18-common-size-statements-financial-ratios-loan-application-lo15-1-lo15-2-lo15-3-lo15-4\/\"><\/a> <\/p>\n<p>PROBLEM 15\u201318 Common-Size Statements and Financial Ratios for a Loan Application [LO15\u20131,<br \/> LO15\u20132, LO15\u20133, LO15\u20134]<br \/> Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices<br \/> on which he had secured patents. Although the company has been fairly profitable, it is now experiencing<br \/> a severe cash shortage. For this reason, it is requesting a $500,000 long-term loan from<br \/> Gulfport State Bank, $100,000 of which will be used to bolster the Cash account and $400,000 of<br \/> which will be used to modernize equipment. The company\u2019s financial statements for the two most<br \/> recent ye ars f ollow:<br \/> Sabin Electronics<br \/> Comparative Balance Sheet<br \/> This Year Last Year<br \/> Assets<br \/> Current assets:<br \/> Cash . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 70,000 $ 150,000<br \/> Marketable securities . . . . . . . . . . . . . . . . 0 18,000<br \/> Accounts receivable, net . . . . . . . . . . . . . 480,000 300,000<br \/> Inventory . . . . . . . . . . . . . . . . . . . . . . . . . 950,000 600,000<br \/> Prepaid expenses . . . . . . . . . . . . . . . . . . . 20,000 22,000<br \/> Total current assets . . . . . . . . . . . . . . . . . . . 1,520,000 1,090,000<br \/> Plant and equipment, net . . . . . . . . . . . . . . . 1,480,000 1,370,000<br \/> Total assets . . . . . . . . . . . . . . . . . . . . . . . . . $3,000,000 $2,460,000<br \/> Liabilities and Stockholders\u2019 Equity<br \/> Liabilities:<br \/> Current liabilities . . . . . . . . . . . . . . . . . . . . $ 800,000 $ 430,000<br \/> Bonds payable, 12% . . . . . . . . . . . . . . . . 600,000 600,000<br \/> Total liabilities . . . . . . . . . . . . . . . . . . . . . . . . 1,400,000 1,030,000<br \/> Stockholders\u2019 equity:<br \/> Common stock, $15 par . . . . . . . . . . . . . 750,000 750,000<br \/> Retained earnings . . . . . . . . . . . . . . . . . . 850,000 680,000<br \/> Total stockholders\u2019 equity . . . . . . . . . . . . . . 1,600,000 1,430,000<br \/> Total liabilities and equity . . . . . . . . . . . . . . $3,000,000 $2,460,000<br \/> Sabin Electronics<br \/> Comparative Income Statement and Reconciliation<br \/> This Year Last Year<br \/> Sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $5,000,000 $4,350,000<br \/> Cost of goods sold . . . . . . . . . . . . . . . . . . . 3,875,000 3,450,000<br \/> Gross margin . . . . . . . . . . . . . . . . . . . . . . . . 1,125,000 900,000<br \/> Selling and administrative expenses . . . . . . 653,000 548,000<br \/> Net operating income . . . . . . . . . . . . . . . . . 472,000 352,000<br \/> Interest expense . . . . . . . . . . . . . . . . . . . . . 72,000 72,000<br \/> Net income before taxes . . . . . . . . . . . . . . . 400,000 280,000<br \/> Income taxes (30%) . . . . . . . . . . . . . . . . . . 120,000 84,000<br \/> Net income . . . . . . . . . . . . . . . . . . . . . . . . . 280,000 196,000<br \/> Common dividends . . . . . . . . . . . . . . . . . . . 110,000 95,000<br \/> Net income retained . . . . . . . . . . . . . . . . . . 170,000 101,000<br \/> Beginning retained earnings . . . . . . . . . . . . 680,000 579,000<br \/> Ending retained earnings . . . . . . . . . . . . . . . $ 850,000 $ 680,000<br \/> 708 Chapter 15<br \/> During the past year, the company introduced several new product lines and raised the selling<br \/> prices on a number of old product lines in order to improve its profit margin. The company also<br \/> hired a new sales manager, who has expanded sales into several new territories. Sales terms are<br \/> 2\/10, n\/30. All sales are on account.<br \/> Required:<br \/> 1. To assist in approaching the bank about the loan, Paul has asked you to compute the following<br \/> ratios for both this year and last year:<br \/> a. The a mount of w orking capital.<br \/> b. The c urrent r atio.<br \/> c. The a cid-test r atio.<br \/> d. The average collection period. (The accounts receivable at the beginning of last year<br \/> totaled $250,000.)<br \/> e. The average sale period. (The inventory at the beginning of last year totaled $500,000.)<br \/> f. The ope rating c ycle.<br \/> g. The total asset turnover. (The total assets at the beginning of last year were $2,420,000.)<br \/> h. The de bt-to-equity r atio.<br \/> i. The t imes i nterest e arned r atio.<br \/> j. The equity multiplier. (The total stockholders\u2019 equity at the beginning of last year totaled<br \/> $1,420,000.)<br \/> 2. For both this year and last year:<br \/> a. Present t he ba lance s heet i n c ommon-size f ormat.<br \/> b. Present the income statement in common-size format down through net income.<br \/> 3. Paul Sabin has also gathered the following financial data and ratios that are typical of companies<br \/> in the electronics industry:<br \/> Current ratio . . . . . . . . . . . . . . . . . . . . . . . . . . . 2.5<br \/> Acid-test ratio . . . . . . . . . . . . . . . . . . . . . . . . . . 1.3<br \/> Average collection period . . . . . . . . . . . . . . . . . . 18 days<br \/> Average sale period . . . . . . . . . . . . . . . . . . . . . . 60 days<br \/> Debt-to-equity ratio . . . . . . . . . . . . . . . . . . . . . . 0.90<br \/> Times interest earned ratio . . . . . . . . . . . . . . . . 6.0<br \/> Comment on the results of your analysis in (1) and (2) above and compare Sabin Electronics\u2019<br \/> performance to the benchmarks from the electronics industry. Do you think that the company<br \/> is likely to get its loan application approved?<i><\/i><\/p>\n","protected":false},"excerpt":{"rendered":"<p>PROBLEM 15\u201318 Common-Size Statements and Financial Ratios for a Loan Application [LO15\u20131, LO15\u20132, LO15\u20133, LO15\u20134] 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 <a href=\"https:\/\/www.benedictsol.com\/blogs\/problem-15-18-common-size-statements-and-financial-ratios-for-a-loan-application-lo15-1-lo15-2-lo15-3-lo15-4-2\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-78107","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/78107","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=78107"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/78107\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=78107"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=78107"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=78107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}