Question

In: Accounting

Salza Technology Corporation Annual Income Statements (in $ Thousands) 2012 2013 Net sales $375 $450 Less:...

Salza Technology Corporation

Annual Income Statements (in $ Thousands)

2012

2013

Net sales

$375

$450

Less: Cost of goods sold

-225

-270

Gross profit

150

180

Less: Operating expenses

-46

-46

Less: Depreciation

-25

-30

Less: Interest

-4

-4

Income before taxes

75

100

Less: Income taxes

-20

-30

Net income

$ 55

$70

Cash dividends

$ 17

$ 20

Balance Sheets as of December 31 (in $ Thousands)

2012

2013

Cash

$ 39

$ 16

Accounts receivable

50

80

Inventories

151

204

Total current assets

240

300

Gross fixed assets

200

290

Less accumulated depreciation

−95

−125

Net fixed assets

105

165

Total assets

$345

$465

Accounts payable

$ 30

$ 45

Bank loan

20

27

Accrued liabilities

10

23

Total current liabilities

60

95

Long-term debt

15

15

Common stock

85

120

Retained earnings

185

235

Total liabilities and equity

$345

$465

2. [Liquidity and Financial Leverage Ratios] Refer to the Salza Technology Corporation in Problem 1.

A.     Using average balance sheet account data, calculate the (a) current ratio, (b) quick ratio, (c) total-debt-to-total-assets ratio, and (d) the interest coverage ratio for 2013.

           

     

B.     Repeat the ratio calculations requested in Part A separately for 2012 and 2013 using year-end balance sheet account data. What changes, if any, have occurred in terms of liquidity and financial leverage?

Solutions

Expert Solution

1,A,

  1. Current Ratio= Average current assets/Average Current Liabilities

Average current Assets=$240 +$300/2=$270

Average current Liabilities=$60+$95/2=$77.50

Therefore Current Ratio=$270/$77.50=3.48 Times

b) Quick Ratio= Average current Assets-Average Inventories- Short term Marketable      securities/Average current Liabilities

=($240 +$300/2)-($151+$204/2) /$60+$95/2=1.19 Times

c) total debt to total asset ratio = Average total debt/Average total assets

=($60+$95)/2 + ($15+$15)/2 / ($345+$465)/2=$92.50/$405=22.84%

d)Interest coverage ratio: Average earnings before interest and taxes depreciation /Average Interest

EBITDA = Net sales – Cost of goods sold- operating expenses

2012=$375-$225-$46=$104

2013=$450-$270-$46=$134

Interest Coverage Ratio=($104+$134/2 ) /($4 +$4)/2=29.75 Times

1 B

  1. Current Ratio:

2012=$240/$60=4 Times

2013=$300/$95=3.16 Times

  1. Quick ration:

2012=($240-$151)/$60=1.48 Times

2013=($300-$204)/$95=1.01 Times

  1. Total debt to total assets ratio

2012=($60+$15/$345)=21.74%

2013=($95+$15)/$465=22.66%

  1. Interest Coverage Ration:

2012=($375-$225-$46)/$4=26 Times

2013 ($450-$270-$46)$4=33.50 Times


Related Solutions

Income Statements for Years Ending December 31, 2011-13 2011 2012 2013 Net sales $1,697 $2,013 $2,694...
Income Statements for Years Ending December 31, 2011-13 2011 2012 2013 Net sales $1,697 $2,013 $2,694 Cost of goods sold      Beginning inventory 183 239 326      Purchases 1,278 1,524 2,042      $1,461 $1,763 $2,368      Ending inventory 239 326 418      Total cost of goods sold $1,222 $1,437 $1,950 Gross profit 475 576 744 Operating expense 425 515 658 Interest expense 13 20 33 Net income before taxes $ 37 $ 41 $ 53 Provision for income taxes 6...
Year 2015 2014 2013 2012 2011 Net income $1042 $903 $753 $850 $805 Net sales $11454...
Year 2015 2014 2013 2012 2011 Net income $1042 $903 $753 $850 $805 Net sales $11454 $10773 $10459 $10364 $9613 Profit margin 9.1 8.4 7,2 8.2 8,4 Industry profit margin 2.8 2.5 8,2 2,2 2,1 How to create journal entries in a correct format for this problem.
Common-Size Income Statements Consider the following income statement data from the Ross Company: 2013 2012 Sales...
Common-Size Income Statements Consider the following income statement data from the Ross Company: 2013 2012 Sales revenue $529,000 $454,000 Cost of goods sold 336,000 279,000 Selling expenses 105,000 99,000 Administrative expenses 64,000 58,000 Income tax expense 11,800 9,400 Prepare common-size income statements for each year. Note: Round answers to one decimal place (ex: 0.2345 = 23.5%). ROSS COMPANY Common-Size Income Statements (Percent of Sales Revenue) 2013 2012 Sales Revenue Answer Answer Cost of Goods Sold Answer Answer AnswerGross Profit on...
Bayside Inc. 2005 Income Statement ($ in thousands) Net sales $5,680 Less: Cost of goods sold...
Bayside Inc. 2005 Income Statement ($ in thousands) Net sales $5,680 Less: Cost of goods sold 4,060 Less: Depreciation 420 Earnings before interest and taxes 1,200 Less: Interest paid 30 Taxable Income $1,170 Less: Taxes 410 Net income $ 760 Bayside, Inc. 2004 and 2005 Balance Sheets ($ in thousands) 2004 2005 2004 2005 Cash $ 70 $ 180 Accounts payable $1,350 $1,170 Accounts rec. 980 840 Long-term debt 720 500 Inventory 1,560 1,990 Common stock 3,200 3,500 Total $2,610...
Rosnan Industries' 2013 and 2012 balance sheets and income statements are shown below. Balance Sheets: 2013...
Rosnan Industries' 2013 and 2012 balance sheets and income statements are shown below. Balance Sheets: 2013 2012 Cash and equivalents $100   $85   Accounts receivable 275   300   Inventories 375   250         Total current assets $750   $635   Net plant and equipment 2,300   1,490   Total assets $3,050   $2,125   Accounts payable $150   $85   Accruals 75   50   Notes payable 150   75         Total current liabilities $375   $210   Long-term debt 450   290   Common stock 1,225   1,225   Retained earnings 1,000   400   Total liabilities and equity $3,050   $2,125   Income Statements:...
Comparative Income Statement Analysis Comparative 2012 and 2013 income statements for Dakota Products: 2017 2018 Change...
Comparative Income Statement Analysis Comparative 2012 and 2013 income statements for Dakota Products: 2017 2018 Change Unit Sales       10,000         14,000      4,000 Revenue $ 150,000 $    220,000     70,000 Expenses      120,000        160,000     40,000 Operating Profit $    30,000 $      60,000 a. What is the break-even point? b. What number of units are required to earn an operating profit of $70,000 c. What was the margin of safety for both 2017 and 2018?
Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales...
Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales $ 895.00 Cost of goods sold 755.00 Depreciation 45.00 Earnings before interest and taxes (EBIT) $ 95.00 Interest expense 26.00 Income before tax $ 69.00 Taxes 14.49 Net income $ 54.51 BALANCE SHEET (Figures in $ millions) End of Year Start of Year Assets Current assets $ 383 $ 340 Long-term assets 286 236 Total assets $ 669 $ 576 Liabilities and shareholders’ equity...
Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales...
Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales $ 887.00 Cost of goods sold 747.00 Depreciation 37.00 Earnings before interest and taxes (EBIT) $ 103.00 Interest expense 18.00 Income before tax $ 85.00 Taxes 29.75 Net income $ 55.25 BALANCE SHEET (Figures in $ millions) End of Year Start of Year Assets Current assets $ 375 $ 324 Long-term assets 270 228 Total assets $ 645 $ 552 Liabilities and shareholders’ equity...
Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales...
Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales $ 895.00 Cost of goods sold 755.00 Depreciation 45.00 Earnings before interest and taxes (EBIT) $ 95.00 Interest expense 26.00 Income before tax $ 69.00 Taxes 14.49 Net income $ 54.51 BALANCE SHEET (Figures in $ millions) End of Year Start of Year Assets Current assets $ 383 $ 340 Long-term assets 286 236 Total assets $ 669 $ 576 Liabilities and shareholders’ equity...
Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales...
Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales $ 888.00 Cost of goods sold 748.00 Depreciation 38.00 Earnings before interest and taxes (EBIT) $ 102.00 Interest expense 19.00 Income before tax $ 83.00 Taxes 17.43 Net income $ 65.57 BALANCE SHEET (Figures in $ millions) End of Year Start of Year Assets Current assets $ 376 $ 326 Long-term assets 272 229 Total assets $ 648 $ 555 Liabilities and shareholders’ equity...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT