Here are the comparative income statements of Carla Vista Corporation. CARLA VISTA CORPORATION Comparative Income Statement...

Here are the comparative income statements of Carla Vista Corporation.

CARLA VISTA CORPORATION Comparative Income Statement For the Years Ended December 31

	2022	2021
Net sales	$637,500	$555,200
Cost of goods sold	454,100	418,600
Gross Profit	183,400	136,600
Operating expenses	74,500	48,700
Net income	$ 108,900	$ 87,900

(a)

Prepare a horizontal analysis of the income statement data for Carla Vista Corporation, using 2021 as a base. (If amount and percentage are a decrease show the numbers as negative, e.g. -55,000, -20% or (55,000), (20%). Round percentages to 1 decimal place, e.g. 12.1%.)

CARLA VISTA CORPORATION Comparative Income Statement choose the accounting period For the Years Ended December 31For the Month Ended December 31December 31
			Increase or (Decrease) During 2022
	2022	2021	Amount	Percentage
Net sales	$637,500	$555,200	$enter a dollar amount	enter percentages rounded to 1 decimal place	%
Cost of goods sold	454,100	418,600	enter a dollar amount	enter percentages rounded to 1 decimal place	%
Gross Profit	183,400	136,600	enter a dollar amount	enter percentages rounded to 1 decimal place	%
Operating expenses	74,500	48,700	enter a dollar amount	enter percentages rounded to 1 decimal place	%
Net income	$ 108,900	$ 87,900	$enter a dollar amount	enter percentages rounded to 1 decimal place	%

(b)

Prepare a vertical analysis of the income statement data for Carla Vista Corporation for both years. (Round percentages to 1 decimal place, e.g. 12.1%.)

CARLA VISTA CORPORATION Condensed Income Statements choose the accounting period For the Month Ended December 31December 31For the Years Ended December 31
	2022			2021
	$	Percent		$	Percent
Net sales	$637,500	enter percentages rounded to 1 decimal place	%	$555,200	enter percentages rounded to 1 decimal place	%
Cost of goods sold	454,100	enter percentages rounded to 1 decimal place	%	418,600	enter percentages rounded to 1 decimal place	%
Gross Profit	183,400	enter percentages rounded to 1 decimal place	%	136,600	enter percentages rounded to 1 decimal place	%
Operating expenses	74,500	enter percentages rounded to 1 decimal place	%	48,700	enter percentages rounded to 1 decimal place	%
Net income	$ 108,900	enter percentages rounded to 1 decimal place	%	$ 87,900	enter percentages rounded to 1 decimal place	%

Solutions

Expert Solution

a) Horizontal analysis of Income Statement:

Horizontal Financial Stataements involves the analysis of the financial ratios over the time perio i.e, between different accounting periods. It involves the analysis of sales revenues, cost of sales, expenses , income, equity liabilities etc.

Here we are doing the Horizontal Analysis of Income statements which is the analysis of Sales Revenue, Cost Of Goods Sold, Gross Profiy, Operating Expenses, Net income. For the Analysis 2021 is taken as base amount.

Particulars	2022	2021	Increase or (Decrease) during 2022	Percentage
Net Sales	$637,500	$555,200	$82,300	14.8% [($82,300/$555,200)*100]
Cost Of Goods Sold	$454,100	$418,600	$35,500	8.4% [($35,500/$418,600)*100]
Gross Profit	$183,400	$136,600	$46,800	34.2% [($46,800/$136,600)*100]
Operating Expenses	$74,500	$48,700	$25,800	52.9% [($25,800/$48,700)*100]
Net Income	$108,900	$87,900	$21,000	23.8% [($21,000/$87,900)*100]

Net sales has increased by 14.8% from 2021. Cost of Goods Sold increased slightly by 8.4%. Gross profit increased by 34.2% from 2021. Operating expense has increased significantly by 52.9% $25,800 from $48,7000 in 2021 to $74,500 in 2022.

Nwt income has an increase by 23.8% from $87,900 in 2021.

b) Vertical analysis Of Income Statement:

Vertical Analysis of Income Statement is the analysis of the financial data drawn from the income statement to compare the each of the expenses to the total sales. It means Total Sales is taken as Base amount.

Particulars	2022	Percentage	2021	Percentage
Net Sales	$637,500	100% [($637,500/$637,500)*100]	$555,200	100% [($555,200/$555,200)*100]
Cost Of Goods Sold	$454,100	71.2% [($454,100/$637,500)*100]	$418,600	75.3% [($418,600/$555,200)*100]
Gross Profit	$183,400	28.7% [($183,400/$637,500)*100]	$136,600	24.6% [($136,600/$555,200)*100]
Operating Expenses	$74,500	11.6% [($74,500/$637,500)*100]	$48,700	8.7% [($48,700/$555,200)*100]
Net Income	$108,900	17% [($108,900/$637,500)*100]	$87,900	15.8% [($87,900/$555,200)*100]

Cost Of Goods sold For 2021 is 75.3% of the Net Sales While Operating expenses are 8.7%. So most of the expenses are from Cost of Goods Sold.

Gross Profit for 2021 is 24.6% whilw Net profit is 15.8%

Cost Of Goods sold For 2021 is 71.2% of the Net Sales While Operating expenses are 11.6%. So most of the expenses are from Cost of Goods Sold.

Gross Profit for 2021 is 28.7% whilw Net profit is 17%

It is analyszed that the Cost of Goods sold ratio has decreased from 2021 to 2022 because the sales has increased from $555,200 to $537,500.

Oeerating expenses has increased from 8.7% to 11.6% due to increase in sales.

Gross Profit and Net Profit is also increased from 24.6% and 15.8% in 2021 to 28.7% and 17% in 2022 respectively.

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Here are the comparative income statements of Carla VistaCorporation.CARLA VISTA CORPORATIONComparative Income Statement...

Here are the comparative income statements of Carla Vista Corporation. CARLA VISTA CORPORATIONComparative Income StatementFor the Years Ended December 31 2022 2021 Net sales $610,300 $540,600 Cost of goods sold 448,800 426,200 Gross Profit 161,500 114,400 Operating expenses 76,400 48,100 Net income $ 85,100 $ 66,300 (a)Prepare a horizontal analysis of the income statement data for Carla Vista Corporation, using 2021 as...

Here are the comparative income statements of Carla VistaCorporation.CARLA VISTA CORPORATIONComparative Income Statement...

Here are the comparative income statements of Carla Vista Corporation. CARLA VISTA CORPORATIONComparative Income StatementFor the Years Ended December 31 2022 2021 Net sales $610,300 $540,600 Cost of goods sold 448,800 426,200 Gross Profit 161,500 114,400 Operating expenses 76,400 48,100 Net income $ 85,100 $ 66,300 Prepare a vertical analysis of the income statement data for Carla Vista Corporation for both years....

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

Carla Vista Shoes’ comparative balance sheet is presented below. Carla Vista reports under ASPE. CARLA VISTA...

Carla Vista Shoes’ comparative balance sheet is presented below. Carla Vista reports under ASPE. CARLA VISTA SHOES Balance Sheet December 31 Assets 2021 2020 Cash $25,380 $15,930 Accounts receivable 21,780 20,070 Long-term investments 20,700 14,400 Equipment 54,000 63,000 Accumulated depreciation—equipment (12,600 ) (9,000 ) Total $109,260 $104,400 Liabilities and Shareholders’ Equity Accounts payable $17,640 $9,990 Notes payable 9,000 27,000 Common shares 54,000 40,500 Retained earnings 28,620 26,910 Total $109,260 $104,400 Additional Information: 1. Profit was $25,470. Dividends declared and paid...

Shown below are comparative balance sheets for Carla Vista Company. Carla Vista Company Comparative Balance Sheets...

Shown below are comparative balance sheets for Carla Vista Company. Carla Vista Company Comparative Balance Sheets December 31 Assets 2022 2021 Cash $ 170,000 $ 55,000 Accounts receivable 220,000 190,000 Inventory 417,500 472,500 Land 200,000 250,000 Equipment 650,000 500,000 Accumulated depreciation—equipment (165,000 ) (80,000 ) Total $1,492,500 $1,387,500 Liabilities and Stockholders’ Equity Accounts payable $ 97,500 $ 107,500 Bonds payable 375,000 500,000 Common stock ($1 par) 540,000 435,000 Retained earnings 480,000 345,000 Total $1,492,500 $1,387,500 Additional information: 1. Net income...

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 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 Carla Vista Supply Company reported the following information for 2017. Prepare a common-size income statement...

The Carla Vista Supply Company reported the following information for 2017. Prepare a common-size income statement for the year ended June 30, 2017. (Round answers to 1 decimal place, e.g. 52.7%.) Carla Vista Supply Company Income Statement for the Fiscal Year Ended June 30, 2017($ thousands) % of Net Sales Net sales $2,110,000 % Cost of goods sold 1,461,000 % Selling and administrative expenses 312,800 % Nonrecurring expenses 27,200 % Earnings before interest, taxes, depreciation, and amortization (EBITDA) $309,000 %...

Question 20 Carla Vista Company's condensed income statement is presented below: Revenues $906,000 Expenses Cost of...

Question 20 Carla Vista Company's condensed income statement is presented below: Revenues $906,000 Expenses Cost of goods sold $400,000 Operating and administrative expenses 165,000 Depreciation expense 59,500 624,500 Income before taxes 281,500 Income tax expenses 78,000 Net income $203,500 Earnings per share (100,000 shares) $2.04 The following data is compiled relative to Carla Vista's operating segments: Percent Identified with Segment Hotels Grains Candy Revenues 42 % 50 % 8 % Cost of goods sold 50 48 2 Operating and administrative...

Here are simplified financial statements for Phone Corporation in a recent year: INCOME STATEMENT (Figures in...

Here are simplified financial statements for Phone Corporation in a recent year: INCOME STATEMENT (Figures in $ millions) Net sales $ 12,700 Cost of goods sold 3,810 Other expenses 4,112 Depreciation 2,368 Earnings before interest and taxes (EBIT) $ 2,410 Interest expense 660 Income before tax $ 1,750 Taxes (at 30%) 525 Net income $ 1,225 Dividends $ 826 BALANCE SHEET (Figures in $ millions) End of Year Start of Year Assets Cash and marketable securities $ 84 $...

Subjects