Question

In: Accounting

Comparative financial statement data for Donovan Company and Maltese Company, two competitors in the same industry,...

Comparative financial statement data for Donovan Company and Maltese Company, two competitors in the same industry, appear below. All balance sheet data are as of December 31, 2012, and December 31, 2011.

Donovan Company

Maltese Company

2012

2011

2012

2011

Net sales

$1,549,035

$339,038

Cost of goods sold

1,080,490

241,000

Operating expenses

302,275

79,000

Interest expense

8,980

2,252

Income tax expense

54,500

6,650

Current Assets

325,975

312,410

83,336

79,467

Common Stock, $10 par

500,000

500,000

120,000

120,000

Retained earnings

173,460

146,595

38,096

28,998

Non-current liabilities

108,500

90,000

29,620

25,000

Current liabilities

65,325

75,815

35,348

30,281

REQUIRED:

(a) Prepare a common-size 2012 income statement using the data for Donovan Company and Maltese Company in columnar form. (A table is needed)

(b) Comment on the relative profitability of the companies by computing the return on assets (Net income/(Average total assets) and the return on total equity (Net income / (Average Shareholders’ Equity) ratios for both companies.

Answer:

(a)

(b)

Solutions

Expert Solution

a) A common size income statement is an income statement in which each account is expressed as a percentage of the value of sales.

Particulars Donovan Maltese
Amount % Amount %
Sales 1,549,035 100 339,038 100
Less:-
COGS 1080490 69.75 241000 71.08
Operating expense 302275 19.51 79000 23.30
Interest expense 8980 0.57 2252 0.66
Incomebefore tax 157290 10.15 16786 4.95
Less income tax 54500 3.52 6650 1.96
net income 102790 6.64 10136 2.99

b)

Avg total assets = Opening + cloing /2

Total assets = Total liab = Common stock + retained earning + current liab + Non current liab

Donovan

2011 = 500000+146595+90000+75815 = 812410

2012 = 500000+173460+108500+65325 = 847285

Avg total assets = (812410 + 847285)/2 = 829847.5

Maltese

2011 = 204279

2012 = 223064

Avg total assets = (204279+223064)/2 = 213671.5

1) Return on net assets = net income / avg total assets

Donovan = 102790/829847.5 *100 = 12.38%

Maltese = 10136/213671.5 *100 = 4.74

2)

Avg shareholder equity = Op + clo / 2

Donovan = (646595+673460)/2 = 660027.5

Maltese = ( 148998+158096) / 2 = 153547

Return on total equity = Net income / Avg Shareholder equity

Donovan = 102790/660027.5 *100 = 15.57%

Maltese = 10136/153547 *100 = 6.60

Donovan earn more profit as compared to Maltese as seen in both the ratios. It has more assets as well as more equity , more sales and more earning.


Related Solutions

Here are comparative statement data for Wildhorse Company and Sandhill Company, two competitors. All balance sheet...
Here are comparative statement data for Wildhorse Company and Sandhill Company, two competitors. All balance sheet data are as of December 31, 2022, and December 31, 2021. Wildhorse Company Sandhill Company 2022 2021 2022 2021 Net sales $1,892,000 $580,000 Cost of goods sold 1,075,000 298,000 Operating expenses 260,000 87,000 Interest expense 8,200 2,200 Income tax expense 65,300 29,000 Current assets 498,742 $477,987 127,504 $ 121,585 Plant assets (net) 806,004 765,000 213,784 192,492 Current liabilities 101,477 115,997 54,082 46,330 Long-term liabilities...
Comparative statement data for Farris Company and Ratzlaff Company, two competitors, appear below. All balance sheet...
Comparative statement data for Farris Company and Ratzlaff Company, two competitors, appear below. All balance sheet data are as of December 31, 2017, and December 31, 2016. Farris Company Ratzlaff Company 2017 2016 2017 2016 Net sales $1,549,035 $339,038 Cost of goods sold 1,080,490 241,000 Operating expenses 302,275 79,000 Interest expense 8,980 2,252 Income tax expense 54,500 6,650 Current assets 325,975 $312,410 83,336 $79,467 Plant assets (net) 521,310 500,000 139,728 125,812 Current liabilities 65,325 75,815 35,348 30,281 Long-term liabilities 108,500...
Question 1 Comparative statement data for Whispering Company and Metlock Company, two competitors, appear below. All...
Question 1 Comparative statement data for Whispering Company and Metlock Company, two competitors, appear below. All statement of financial position data are as of December 31, 2017, and December 31, 2016. Whispering Company Metlock Company 2017 2016 2017 2016 Net sales £1,504,113 £339,668 Cost of goods sold 1,023,277 236,886 Operating expenses 277,402 76,916 Interest expense 7,970 2,320 Income tax expense 61,839 7,410 Plant assets (net) 596,402 £572,775 143,285 £ 128,013 Current assets 408,279 385,366 85,117 81,019 Share capital—ordinary, £5 par...
4. Two companies, X and Y, are competitors in the same industry, but company X is...
4. Two companies, X and Y, are competitors in the same industry, but company X is more efficient at using its resources than company Y. a. If the MRTS is the same in the production processes of both companies, show and discuss how the isoquants will be different for company X than they are for company Y. b. Both companies can hire labor at the same wage, w, but company X is able to pay a lower rent per unit...
Two companies, X and Y, are competitors in the same industry, but company X is more...
Two companies, X and Y, are competitors in the same industry, but company X is more efficient at using its resources than company Y . a. If the MRTS is the same in the production processes of both companies, show and discuss how the isoquants will be different for company X than they are for company Y. b. Both companies can hire labor at the same wage, w, but company X is able to pay a lower rent per unit...
Two companies, X and Y, are competitors in the same industry, but company X is more...
Two companies, X and Y, are competitors in the same industry, but company X is more efficient at using its resources than company Y. a.         If the MRTS is the same in the production processes of both companies, show and discuss how the isoquants will be different for company X than they are for company Y. b.         Both companies can hire labor at the same wage, w, but company X is able to pay a lower rent per unit on...
6. The following financial data are for two companies in the same industry. CASS HAKN Industry...
6. The following financial data are for two companies in the same industry. CASS HAKN Industry Average EBITDA/Interest exp 4.94 3.23 43.65 Total Debt to Capital 55.19% 50.2% 28.32% FFO/Debt 0.14 0.23 3.01 Current Ratio 0.54 0.71 1.01 Credit Rating A- The industry is rated A- on the average. What rating would you give these two companies? Describe by using the given ratios.
Comparative income statement data for Carla Vista Inc. and Martinez Ltd., two competitors, are shown below...
Comparative income statement data for Carla Vista Inc. and Martinez Ltd., two competitors, are shown below for the year ended December 31, 2021. Carla Vista Martinez Net sales $1,920,000 $563,000 Cost of goods sold 1,102,080 356,942 Gross profit 817,920 206,058 Operating expenses 556,800 87,828 Profit from operations 261,120 118,230 Interest expense 6,960 1,252 Profit before income tax 254,160 116,978 Income tax expense 76,248 29,245 Profit $177,912 $87,733 Additional information: Average total assets $894,000 $250,563 Average total shareholders’ equity 751,000 212,808...
The following financial data of two firms in the same industry are obtained from Yahoo Finance...
The following financial data of two firms in the same industry are obtained from Yahoo Finance Statistics as of October 2019. Firm A    Firm B S& P 500 Market price per share 120 298 Market Cap 342B 131B Enterprise value 415B 129B P/E (trailing) 27.2 36.0 22.1 (S&P 500) EPS 4.42 8.26 EV/Revenue 0.80 0.85 EV/EBITDA 12.76 20.70 Profit margin 2.48% 2.4% Operating margin 4.20% 3.1% Total cash 9.28B 9.44B Long-term debt 44.4B 5.1B Beta 0.65 0.93 Short %...
Comparative financial statement data of Lannister Inc. are as follows: Lannister Inc. Comparative Income Statement Years...
Comparative financial statement data of Lannister Inc. are as follows: Lannister Inc. Comparative Income Statement Years Ended December 31, 2016 and 2015 2016 2015 Net sales $687,000 $595,000 Cost of goods sold 375,000 276,000 Gross profit 312,000 319,000 Operating expenses 129,000 142,000 Income from operations 183,000 177,000 Interest expense 37,000 45,000 Income before income tax 146,000 132,000 Income tax expense 36,000 51,000 Net income $110,000 $81,000 Lannister Inc. Comparative Balance Sheet December 31, 2016 and 2015 2016 2015 2014 Current...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT