Common-Size Statements and Financial Ratios for a Loan Application
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 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 equipment. The company's financial statements for the two most recent years follow:
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.
Required:
1. To assist in approaching the bank about the loan. Paul has asked you to compute the following ratios for both this year and last year:
a. The amount of
b. The
c. The acid-test ratio.
d. The average collection period. (The
e. The average sale period. (The inventory at the beginning of last year totaled $500,000.)
f The operating cycle.
g. The total asset turnover. (The total assets at the beginning of last year were $2,420,000.)
h. The debt-to-equity ratio.
i. The times interest earned ratio.
j. The equity multiplier. (The total
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 down through net income.
3. Paul Sabin has also gathered the following financial data and ratios that are typical of companies in the electronics industry:
Comment on the results of your analysis in (1) and (2) above and compare Sabin Electronics' performance to the benchmarks from the electronics industry. Do you think that the company is likely to get its loan application approved?
Financial Ratio Analysis:
The process of evaluating the financial ratios is known as financial ratio analysis
1.
Compute the following ratios for both this year and last year.
a. Working Capital
b. Current Ratio
c. Acid-Test Ratio
d. Average Collection Period
e. Average Sale Period
f. Operating Cycle
g. Total Asset Turnover
h. Debt-to-Equity Ratio
i. Times Interest Earned Ratio
j. Equity Multiplier
2.
Prepare balance sheet and income statement in common-size format for both this year and last year.
3.
Comment on the results of your analysis in (1) and (2) above and compare Sabin Electronics’ performance to the benchmarks from the electronics industry. Do you think that the company is likely to get its loan application approved?
Answer to Problem 18P
Solution:
1.
Ratios | This Year | Last Year |
Working Capital | $720,000 | $660,000 |
Current Ratio | 1.90 | 2.53 |
Acid-Test Ratio | 0.69 | 1.09 |
Average Collection Period | 28 days | 23 days |
Average Sale Period | 73 days | 58 days |
Average Payable Period | 58 days | 45 days |
Operating Cycle | 43 days | 36 days |
Total Asset Turnover | 1.83 | 1.78 |
Debt-to-Equity Ratio | 0.88 | 0.72 |
Times Interest Earned Ratio | 6.56 | 4.89 |
Equity Multiplier | 1.80 | 1.71 |
2.
SABIN ELECTRONICS
Common Size Balance Sheet | ||||
This Year | Percent | Last Year | Percent | |
Assets | ||||
Current assets: | ||||
Cash | $70,000 | 2.3% | $150,000 | 6.1% |
Marketable securities | 0 | 0.0% | 18,000 | 0.7% |
Accounts receivable, net | 480,000 | 16.0% | 300,000 | 12.2% |
Inventory | 950,000 | 31.7% | 600,000 | 24.4% |
Prepaid expenses | 20,000 | 0.7% | 22,000 | 0.9% |
Total current assets | 1,520,000 | 50.7% | 1,090,000 | 44.3% |
Plant and equipment, net | 1,480,000 | 49.3% | 1,370,000 | 55.7% |
Total Assets | $3,000,000 | 100% | $2,460,000 | 100% |
Liabilities and Stockholders’ Equity | ||||
Liabilities: | ||||
Current liabilities | $800,000 | 26.7% | $430,000 | 17.5% |
Bonds payable, 12% | 600,000 | 20% | 600,000 | 24.4% |
Total Liabilities | 1,400,000 | 46.7% | 1,030,000 | 41.9% |
Stockholders’ equity | ||||
Common stock, $15 par | 750,000 | 25% | 750,000 | 30.5% |
Retained Earnings | 850,000 | 28.3% | 680,000 | 27.6% |
Total Stockholders’ Equity | 1,600,000 | 53.3% | 1,430,000 | 58.1% |
Total liabilities and stockholders’ equity | $3,00,000 | 100% | $2,460,000 | 100% |
SABIN ELECTRONICS
Common Size Income Statement | ||||
This Year | Percent | Last Year | Percent | |
Sales | $5,000,000 | 100% | $4,350,000 | 100% |
Cost of goods sold | 3,875,000 | 77.5% | 3,450,000 | 79.3% |
Gross margin | 1,125,000 | 22.5% | 900,000 | 20.7% |
Selling and administrative expenses | 653,000 | 13.1% | 548,000 | 12.6% |
Net operating income | 472,000 | 9.4% | 352,000 | 8.1% |
Interest expense | 72,000 | 1.4% | 72,000 | 1.7% |
Net income before taxes | 400,000 | 8% | 280,000 | 6.4% |
Income taxes (30%) | 120,000 | 2.4% | 84,000 | 1.9% |
Net Income | 280,000 | 5.6% | 196,000 | 4.5% |
3.
Considering the financial data and ratios of companies in the electronics industry, Sabin Electronics is likely to get its loan approved because the low debt equity ratio and improving times interest earned ratio which are good signs for the bank. In addition to that, the company is planning to invest 80% of the loan amount into modernizing the equipment which increase the productivity and ultimately resulting in higher profitability.
Explanation of Solution
1.
a. Computation of Working Capital | ||||
This Year | Last Year | |||
Current Assets | $1,520,000 | $1,090,000 | ||
Less: Current Liabilities | $800,000 | $430,000 | ||
Working Capital | $720,000 | $660,000 |
With 80% of loan amount being invested in modernizing the equipment, the sales and net income of the company is likely to improve with productivity. The current ratio and acid-test ratio and other relevant ratios will probably improve with this investment. Considering all these factors, the bank is likely to approve the loan of the company.
Want to see more full solutions like this?
Chapter 14 Solutions
INTRO.TO MANAG...(LL)-W/ACCESS >CUSTOM<
- DO IT IN EXCEL AND SHOW FORMULAS DO IT IN EXCEL AND SHOW FORMULAS Jorge Del Llano, a start-up merchant, needs $360,000.00 liquid to invest in inventory and pay certain start-up expenses for his business. The Bank has investigated him and considers him eligible for credit. The Bank authorizes an unsecured credit facility, subject to the provision of a line of credit appropriate to your needs, charging 18% interest for a term of 60 days. The origination fee is 1.25%. For what amount was the loan signed for Del Llano to receive the $360,000 free of charge?arrow_forwardGrant Film Productions wishes to expand and has borrowed $100,000. As a condition for making this loan, the bank requires that the business maintain a current ratio of at least 1.50. Business has been good but not great. Expansion costs have brought the current ratio down to 1.40 on December 15. Rita Grant, owner of the business, is considering what might happen if she reports a current ratio of 1.40 to the bank. One course of action for Grant is to record in December $10,000 of revenue that the business will earn in January of next year. The contract for this job has been signed. Requirements Journalize the revenue transaction, and indicate how recording this revenue in December would affect the current ratio. Discuss whether it is ethical to record the revenue transaction in December. Identify the accounting principle relevant to this situation, and give the reasons underlying your conclusion.arrow_forward(Cash and Accrual Basis) On January 1, 2017, Norma Smith and Grant Wood formed a computer sales andservice company in Soapsville, Arkansas, by investing $90,000 cash. The new company, Arkansas Sales and Service, has the following transactions during January. 1. Pays $6,000 in advance for 3 months’ rent of office, showroom, and repair space. 2. Purchases 40 personal computers at a cost of $1,500 each, 6 graphics computers at a cost of $2,500 each, and 25 printers ata cost of $300 each, paying cash upon delivery. 3. Sales, repair, and office employees earn $12,600 in salaries and wages during January, of which $3,000 was still payable at the end of January. 4. Sells 30 personal computers at $2,550 each, 4 graphics computers for $3,600 each, and 15 printers for $500 each; $75,000 is received in cash in January, and $23,400 is sold on a deferred payment basis. 5. Other operating expenses of $8,400 are incurred and paid for during January; $2,000 of incurred expenses are payable at January…arrow_forward
- Question 1Aggressive Corporation approaches Matt Taylor, a loan officer for Oklahoma State Bank, seeking toincrease the company's borrowings with the bank from $100,000 to $150,000. Matt has an uneasyfeeling as he examines the loan application from Aggressive Corporation, which just completed itsfirst year of operations. The application included the following financial statements. AGGRESSIVE CORPORATIONIncome StatementFor the year ended December 31, 2018 Net sales $200,000Expenses:Cost of goods sold $110,000Operating expenses 50,000Depreciation expense 10,000Total expenses 170,000Net income $ 30,000 AGGRESSIVE CORPORATIONBalance Sheets For the year ended December 31, 2018/December 31, 2018 2018 2017 AssetsCurrent assets:Cash $ 10,000 $0Accounts receivable 60,000 0Inventory 40,000 0Long-term assets:Equipment 100,000 0Accumulated depreciation (10,000) 0Total assets $200,000 $0Liabilities and Stockholders' Equity Page 4 of 11 HI5020 Corporate Accounting Individual Assignment T2…arrow_forwardRead the instructions below and see the attached balance sheet of moon and star cooperation to support your answer. Moon Corporation and Star Corporation are in the same line of business and both were recently organized, so it may be assumed that the recorded costs for assets are close to current market values. The balance sheets for the two companies are as follows at July 31, 2011: Instructions a. Assume that you are a banker and that each company has applied to you for a 90-day loan of $12,000. Which would you consider to be the more favorable prospect? Explain your answer fully. b. Assume that you are an investor considering purchasing all the capital stock of one or both of the companies. For which business would you be willing to pay the higher price? Do you see any indication of a financial crisis that you might face shortly after buying either company? Explain your answer fully. (For either decision, additional information would be useful, but you are to reach your decision on…arrow_forwardASTRA Film Production (ASTRA) wishes to expand and has borrowed RM100,000. As a condition for making this loan, the bank requires that the store maintain a current ratio of at least 1.50. Business has been good but not great. Expansion costs have brought the current ratio down to 1.40 at 15th December. Amelia David, owner of the business, is considering what might happen if she reports a current ratio of 1.40 to the bank. One course of action for ASTRA is to record in December RM10,000 of revenue that the business will earn in January of next year. The contract for this job has been signed. Requirements 3(a). Indicate how recording this revenue in December would affect the current ratio. 3(b). Discuss whether it is ethical to record the revenue transaction in December. Identify the accounting principle relevant to this situation, and give the reasons underlying your conclusion.arrow_forward
- John Marshall is employed as a bank loan officer for First State Bank. He is comparing two companies that have applied for loans, and he wants your help in evaluating those companies. The two companies—Morris, Inc., and Walker Company—are approximately the same size and had approximately the same cash balance at the beginning of 2009. Because the total cash flows for the three-year period are virtually the same, John is inclined to evaluate the two companies as equal in terms of their desirability as loan candidates. Abbreviated information (in thousands of dollars) from Morris, Inc., and Walker Company is as follows: Morris, Inc. Walker Company 2009 2010 2011 2009 2010 2011 Cash flows from: Operating activities $10 $13 $15…arrow_forwardPlease answer question 1 in its entirety. I am using another question for number 2 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 a severe cash shortage. For this reason, it is requesting a $600,000 long-term loan from Gulfport State Bank, $150,000 of which will be used to bolster the Cash account and $450,000 of which will be used to modernize equipment. The company’s financial statements for the two most recent years follow: Sabin Electronics Comparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 110,000 $ 250,000 Marketable securities 0 28,000 Accounts receivable, net 607,000 400,000 Inventory 1,045,000 695,000 Prepaid expenses 30,000 32,000 Total current assets 1,792,000 1,405,000 Plant and equipment, net 1,946,400 1,470,000 Total assets $ 3,738,400 $ 2,875,000…arrow_forwardThangmo Company is a large manufacturing firm in Cherating that was created 20 years agoby the Thangmo family. It was initially financed with an equity investment by the Thangmofamily and 10 other individuals.Over time, Thangmo Company obtained substantial loans from finance companies andcommercial banks. The interest rate on the loans is tied to market interest rates and is adjustedevery six months. It has a credit line with a bank in case it suddenly needs additional funds fora temporary period. It has purchased Treasury securities that it could sell if it experiences anyliquidity problems.Thangmo Company has assets valued at about RM50 million and generates sales of aboutRM100 million per year. Some of its growth is attributed to its acquisitions of other firms.Because of its expectations of a strong Malaysian economy, Thangmo plans to grow in thefuture by expanding its business and by making more acquisitions. It expects that it will needsubstantial long-term financing and plans to…arrow_forward
- Thangmo Company is a large manufacturing firm in Cherating that was created 20 years agoby the Thangmo family. It was initially financed with an equity investment by the Thangmofamily and 10 other individuals.Over time, Thangmo Company obtained substantial loans from finance companies andcommercial banks. The interest rate on the loans is tied to market interest rates and is adjustedevery six months. It has a credit line with a bank in case it suddenly needs additional funds fora temporary period. It has purchased Treasury securities that it could sell if it experiences anyliquidity problems.Thangmo Company has assets valued at about RM50 million and generates sales of aboutRM100 million per year. Some of its growth is attributed to its acquisitions of other firms.Because of its expectations of a strong Malaysian economy, Thangmo plans to grow in thefuture by expanding its business and by making more acquisitions. It expects that it will needsubstantial long-term financing and plans to…arrow_forwardWi-Fi, Inc., has the following selected transactions during the year.1. Issues $20 million in bonds.2. Purchases equipment for $80,000.3. Pays a $20,000 account payable.4. Collects a $15,000 account receivable.5. Exchanges land for a new patent. Both are valued at $300,000.6. Declares and pays a cash dividend of $100,000.7. Loans $50,000 to a customer, accepting a note receivable.8. Pays $75,000 to suppliers for inventory.Required:Indicate in which section of the statement of cash flows each of these items would be reported: operating activities (indirect method), investing activities, financing activities, or a separate noncash activities note.arrow_forwardBob Jacobs wishes to expand his business and has borrowed $100,000. As a condition for making this loan, the bank requires that the business maintain a current ratio of at least 1.50. Business has been good but not great. The expansion costs have brought the current ratio down to 1.20 in the middle of December. Bob, as the owner of the business, is considering what might happen if he reports a current ratio of 1.4 to the bank. One possible action for Bob is to record in December $10,000 of revenue that the business will earn in January of next year. He thinks this is doable because the contract for this job has been signed. Journalize the revenue transaction and indicate how recording this revenue in December would affect the current ratio. Discuss whether it is ethical to record the revenue transaction in December. Identify the accounting principle relevant to this situation. and give the reasons underlying your conclusion. Propose an ethical action for Bob Jacobs.arrow_forward
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning