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?

Question

Want to see more full solutions like this?

Answer 1

Question

Definition Definition Financial statement that provides a snapshot of an organization's financial position at a specific point in time. It summarizes a company's assets, liabilities, and shareholder's equity, detailing what the company owns, what it owes, and what is left over for its owners. The balance sheet serves as a crucial tool to assess the financial health and stability of a company, as well as to help management make informed decisions about its future investments and financial obligations.

Chapter 15, Problem 18P

To determine

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?

Expert Solution & Answer

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

$b. Current Ratio= Current Assets Current Liabilities This Year = $1,520,000 $800,000 = 1.90Last Year = $1,090,000 $430,000 = 2.53$

$c. Acid−Test Ratio= Cash + Marketable Securities + Accounts Receivable Current Liabilities This Year = $70,000 + 0 + $480,000 $800,000 = 0.69 Last Year = $150,000 + $18,000 + $300,000 $430,000 = 1.09$

$d. Average Collection Period= 365 days Accounts Receivable Turnover Ratio *Accounts Receivable Turnover Ratio = Net Credit Sales Average Accounts Receivable Average Accounts Receivable = Beginning Accounts Receivable + Ending Accounts Receivable2$

$Average Payable Period= Average Accounts Payable Cost of goods Sold X 365 days*Average Accounts Payable = Beginning Accounts Payable + Ending Accounts Payable2 This Year = $615,000 $3,875,000 X 365 days = 58 Days*Average Accounts Payable = $430,000 + $800,0002 = $615,000 Last Year = $430,000 $3,450,000 X 365 days = 45 Days*Average Accounts Payable = $430,000$

$f. Operating Cycle= Average Collection Period + Average Sale Period − Average Payable Period This Year = 28 days + 73 days − 58 days = 43 days Last Year = 23 days + 58 days − 45 days= 36 days$

$g. Total Asset Turnover= Sales Revenue Average Total Assets *Average Total Assets = Beginning Total Assets + Ending Total Assets2$

$This Year = $5,000,000 $2,730,000 = 1.83*Average Total Assets = $2,460,000 + $3,000,0002 = $2,730,000 Last Year = $4,350,000 $2,440,000 = 1.78 *Average Total Assets = $2,420,000 + $2,460,000 2 = $2,440,000$

$h. Debt Equity Ratio= Total Liabilities Total Stockholders’ Equity This Year = $1,400,000 $1,600,000 = 0.88 Last Year = $1,030,000 $1,430,000 = 0.72$

$i. Times Interest Earned Ratio= Earnings Before Interest and Taxes Interest Expense This Year = $472,000 $72,000 = 6.56 Last Year = $352,000 $72,000 = 4.89$

Conclusion

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?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Students have asked these similar questions

Can you provide the accurate answer to this financial accounting question using correct methods?

Can you solve this financial accounting problem with appropriate steps and explanations?

Do fast answer general accounting question

Answer 2

Question

Definition Definition Financial statement that provides a snapshot of an organization's financial position at a specific point in time. It summarizes a company's assets, liabilities, and shareholder's equity, detailing what the company owns, what it owes, and what is left over for its owners. The balance sheet serves as a crucial tool to assess the financial health and stability of a company, as well as to help management make informed decisions about its future investments and financial obligations.

Chapter 15, Problem 18P

To determine

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?

Expert Solution & Answer

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