Question

In: Accounting

The comparative statements of Bramble Interiors Ltd. are presented as follows: BRAMBLE INTERIORS LTD. Income Statement...

The comparative statements of Bramble Interiors Ltd. are presented as follows:

BRAMBLE INTERIORS LTD. Income Statement For the Year Ended December 31
	2021	2020
Net sales	$2,159,750	$1,836,500
Cost of goods sold	1,145,000	1,019,500
Gross profit	1,014,750	817,000
Selling and administrative expenses	500,000	491,000
Income from operations	514,750	326,000
Other expenses and losses
Interest expense	14,000	16,000
Income before income taxes	500,750	310,000
Income tax expense	108,275	82,000
Profit	$392,475	$228,000

BRAMBLE INTERIORS LTD. Balance Sheet December 31
Assets	2021	2020	2019
Current assets
Cash	$80,000	$129,100	$114,200
Accounts receivable	188,600	106,400	102,400
Inventory	213,800	143,000	114,500
Total current assets	482,400	378,500	331,100
Property, plant, and equipment (net)	647,700	601,300	510,300
Total assets	$1,130,100	$979,800	$841,400
Liabilities and Shareholders’ Equity
Current liabilities
Accounts payable	$289,175	$169,000	$144,400
Income taxes payable	40,000	47,000	45,500
Total current liabilities	329,175	216,000	189,900
Bonds payable	190,000	195,000	200,000
Total liabilities	519,175	411,000	389,900
Shareholders’ equity
Common shares	280,000	280,000	300,000
Retained earnings	330,925	288,800	151,500
Total shareholders’ equity	610,925	568,800	451,500
Total liabilities and shareholders’ equity	$1,130,100	$979,800	$841,400

Additional information:

1.		All sales were on account.
2.		Weighted-average common shares in 2021 were 52,000 and in 2020 were 54,000.

(a)

Calculate the following ratios for 2021 and 2020. (Round earnings per share, current ratio, acid-test ratio and asset turnover answers to 2 decimal places, e.g. 1.83 or 1.83% and all other answers to 1 decimal place, e.g. 1.5 or 1.5%. Use 365 days for calculation.)

		2021		2020
1.	Gross profit margin		%		%
2.	Profit margin		%		%
3.	Earnings per share	$		$
4.	Receivables turnover		times		times
5.	Collection period		days		days
6.	Inventory turnover		times		times
7.	Days sales in inventory		days		days
8.	Return on common shareholders’ equity		%		%
9.	Return on assets		%		%
10.	Current ratio
11.	Acid-test ratio
12.	Asset turnover		times		times
13.	Debt to total assets		%		%

Expert Solution

a.

.	.	2021	2020
1.	Gross profit margin	47%	44.5%
2.	Profit margin	18.2%	12.4%
3.	Earnings per share	$7.55	$4.22
4.	Receivables turnover	14.6 times	17.6 times
5.	Collection period	25 days	20.7 days
6.	Inventory turnover	6.4 times	7.9 times
7.	Days sales in inventory	57 days	46.2 days
8.	Return on common shareholders’	66.5%	44.7%
9.	Return on assets	37.2%	25.1%
10.	Current ratio	1.47	1.75
11.	Acid-test ratio	0.82	1.09
12.	Asset turnover	2.05 times	2.02 times
13.	Debt to total assets	45.9%	41.9%

Working note:-

.	.	2021	2021	2020	2020
1.	Gross profit margin = Gross profit / sales	1014750/ 2159750 = 0.4698	47%	817,000/ 1,836,500 =0.4449	44.5%
2.	Profit margin =profit / sales	392,475 / 2159750 =0.1817	18.2%	228,000 / 1,836,500 =0.1241	12.4%
3.	Earnings per share = Net income / average outstanding share	392,475 / 52,000	$7.55	228,000 / 54000	$4.22
4.	Receivables turnover =sales / average receivable Avg receivable = (beg + end ) / 2	2159750 / 147500	14.6 times	1,836,500 / 104400	17.6 times
5.	Collection period = 365 / Receivables turnover	365 / 14.6	25 days	365/ 17.6	20.7 days
6.	Inventory turnover = cost of goods sold / average inventory Avg inventory = ( beg + end ) / 2	1145000/ ((143000+ 213800)/2)	6.4 times	1019500 / (( 114500+ 143000 ) / 2)	7.9 times
7.	Days sales in inventory = 365 / Inventory turnover	365/6.4	57 days	365/7.9	46.2 days
8.	Return on common shareholders’ equity = net income / avg equity Avg equity = ( beg + end ) / 2*	392475 / 589862.5 =0.665	66.5%	228000 / 510150 = 0.447	44.7%
9.	Return on assets = Net income / average assets*	392475 / 1054950 =0.372	37.2%	228000/ 910600 =0.251	25.1%
10.	Current ratio = Current assets / current liabilities	482400 / 329175	1.47	378500 / 216000	1.75
11.	Acid-test ratio = quick assets* / current liabilities	268600 / 329175	0.82	235500 / 216000	1.09
12.	Asset turnover = sales / avg assets	2159750 / 1054950	2.05 times	1836500 / 910600	2.02 times
13.	Debt to total assets Total debt / assets	519175 / 1130100 =0.459	45.9%	411000 / 979800 = 0.419	41.9%

8 *2021 = avg equity = (568800 + 610925 ) / 2 = 589862.5

2020 = ( 451500 + 568800 ) / 2 = 510150

9. average assets = (beg + end ) / 2

2021 = ( 979800 + 1130100 ) / 2 = 1054950

2020 = ( 841400 + 979800 ) / 2 = 910600

11. Quick assets = cash + account receivable

2021 = 80000 + 188600 = 268600

2020 = 129100 + 106400 = 235500

ekkarill92 answered 2 years ago

The comparative statement of financial position of Bramble Corporation as at December 31, 2020, follows: BRAMBLE...

The comparative statement of financial position of Bramble Corporation as at December 31, 2020, follows: BRAMBLE CORPORATION Statement of Financial Position December 31 December 31 Assets 2020 2019 Cash $ 54,000 $ 14,700 Accounts receivable 89,600 88,600 Equipment 26,700 21,300 Less: Accumulated depreciation (10,300 ) (10,900 ) Total $ 160,000 $ 113,700 Liabilities and Shareholders’ Equity Accounts payable $ 19,600 $ 15,800 Common shares 100,000 80,100 Retained earnings 40,400 17,800 Total $ 160,000 $ 113,700 Net income of $36,100 was...

Presented below isthe comparative statement of income, prepared on a cash basis, for Mingwei Ltd. for...

Presented below isthe comparative statement of income, prepared on a cash basis, for Mingwei Ltd. for the past two years. The manager is puzzled by the fact that net income was lower in2023than 2022.MINGWEI LTD.Statementof Income, Cash BasisYears EndedDecember 31——————————————————————————————————————————20232022Service revenue.........................................................................$350,000$365,000ExpensesSalaries expense.................................................................200,000190,000Office expense....................................................................54,00055,000Repairs and maintenance expense.....................................20,00015,000Interest expense..................................................................15,0002,000Total expenses...........................................................................289,000262,000Income before income tax..........................................................61,000103,000Income tax expense...................................................................24,40041,200Net income.................................................................................$ 36,600$ 61,800In talking with the manager, you gather the following information, which was not reflected in the above statements:1.The company borrowed $200,000 on June 1, 2022and...

The comparative statements of Wahlberg Company are presented here. Wahlberg Company Income Statement For the Years...

The comparative statements of Wahlberg Company are presented here. Wahlberg Company Income Statement For the Years Ended December 31 2020 2019 Net sales $1,813,300 $1,745,300 Cost of goods sold 1,010,100 994,000 Gross profit 803,200 751,300 Selling and administrative expenses 512,200 481,600 Income from operations 291,000 269,700 Other expenses and losses Interest expense 18,700 14,000 Income before income taxes 272,300 255,700 Income tax expense 82,022 77,800 Net income $ 190,278 $ 177,900 Wahlberg Company Balance Sheets December 31 Assets 2020 2019...

The comparative unclassified statement of financial position for Carla Vista Ltd. follows: CARLA VISTA LTD. Statement...

The comparative unclassified statement of financial position for Carla Vista Ltd. follows: CARLA VISTA LTD. Statement of Financial Position December 31 Assets 2018 2017 Cash $55,000 $28,000 Accounts receivable 81,000 63,000 Inventory 183,000 203,500 Long-term investments 80,000 120,000 Equipment 285,000 156,000 Accumulated depreciation (61,000 ) (37,000 ) Total assets $623,000 $533,500 Liabilities and Shareholders’ Equity Accounts payable $32,000 $ 45,000 Bank loan payable 153,000 172,500 Common shares 219,000 176,000 Retained earnings 219,000 140,000 Total liabilities and shareholders’ equity $623,000 $533,500...

The income statement and additional data of Bayleaf Pty Ltd are as follows: Income statement for...

The income statement and additional data of Bayleaf Pty Ltd are as follows: Income statement for the year ended 31 December 2016 Revenue: Service Revenue R225 000 Dividend Revenue R6 300 (231 300) Expenses: Cost of goods sold R100 000 Salary Expense R52 000 Depreciation Expense R23 000 Advertising Expense R2 300 Interest Expense R2 400 Income tax expense R5 000 (R184 700) Net income R46 600 Additional Data: a) Acquisition of PPE was R170 000. Of this amount ,...

Presented below is the latest income statement of ABC Ltd.:

Presented below is the latest income statement of ABC Ltd.: Sales............................................................................. $380,000 Cost of goods sold........................................................ 225,000 Gross profit.................................................................... $155,000 Operating expenses...................................................... 85,000 Income before income taxes......................................... 70,000 Income taxes................................................................. 28,000 Net income.................................................................... $ 42,000 In addition, the following information related to net changes in working capital is available: Debit Credit Cash.............................................................................. $12,000 Accounts receivable (net)............................................. 8,000 Inventories..................................................................... $19,400 Salaries payable (operating expenses)........................ 6,000 Accounts payable.......................................................... 9,000 Income tax payable....................................................... 3,000 ABC Ltd. also reports that depreciation expense for the...

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...

1. The comparative statements of Pharoah Company are presented here. PHAROAH COMPANY Income Statements For the...

1. The comparative statements of Pharoah Company are presented here. PHAROAH COMPANY Income Statements For the Years Ended December 31 2022 2021 Net sales $1,890,800 $1,756,200 Cost of goods sold 1,060,095 1,011,700 Gross profit 830,705 744,500 Selling and administrative expenses 505,700 484,700 Income from operations 325,005 259,800 Other expenses and losses Interest expense 23,100 21,100 Income before income taxes 301,905 238,700 Income tax expense 93,045 74,100 Net income $ 208,860 $ 164,600 PHAROAH COMPANY Balance Sheets December 31 Assets 2022...

The comparative statements of Crane Company are presented here. CRANE COMPANY Income Statements For the Years...

The comparative statements of Crane Company are presented here. CRANE COMPANY Income Statements For the Years Ended December 31 2022 2021 Net sales $2,363,400 $2,205,000 Cost of goods sold 1,307,000 1,287,680 Gross profit 1,056,400 917,320 Selling and administrative expenses 640,000 613,120 Income from operations 416,400 304,200 Other expenses and losses Interest expense 28,160 25,600 Income before income taxes 388,240 278,600 Income tax expense 116,472 83,580 Net income $ 271,768 $ 195,020 CRANE COMPANY Balance Sheets December 31 Assets 2022 2021...

The comparative statements of Oriole Company are presented here. ORIOLE COMPANY Income Statements For the Years...

The comparative statements of Oriole Company are presented here. ORIOLE COMPANY Income Statements For the Years Ended December 31 2022 2021 Net sales $2,067,400 $1,925,000 Cost of goods sold 1,147,000 1,126,720 Gross profit 920,400 798,280 Selling and administrative expenses 560,000 536,480 Income from operations 360,400 261,800 Other expenses and losses Interest expense 24,640 22,400 Income before income taxes 335,760 239,400 Income tax expense 100,728 71,820 Net income $ 235,032 $ 167,580 ORIOLE COMPANY Balance Sheets December 31 Assets 2022 2021...