ACC 556 Strayer University Carla Vista Corporation Analysis

Question Description

Current Attempt in Progress

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

Current Attempt in Progress

Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions).

	Target Corporation		Wal-Mart Stores, Inc.
	Income Statement Data for Year
Net sales		$66,400		$410,000
Cost of goods sold		46,000		308,000
Selling and administrative expenses		14,200		78,000
Interest expense		650		2,200
Other income (expense)		(70	)	(390	)
Income tax expense		1,400		7,100
Net income		$ 4,080		$ 14,310

	Balance Sheet Data (End of Year)
Current assets		$19,000		$48,000
Noncurrent assets		26,900		122,000
Total assets		$45,900		$170,000
Current liabilities		$10,000		$56,000
Long-term debt		16,900		44,000
Total stockholders equity		19,000		70,000
Total liabilities and stockholders equity		$45,900		$170,000

	Beginning-of-Year Balances
Total assets		$43,000		$162,000
Total stockholders equity		14,300		65,000
Current liabilities		10,500		55,000
Total liabilities		28,700		97,000

	Other Data
Average net accounts receivable		$7,600		$3,900
Average inventory		6,900		32,900
Net cash provided by operating activities		5,500		26,600
Capital expenditures		1,700		12,400
Dividends		460		3,900

For each company, compute the following ratios. (Round current ratio answers to 2 decimal places, e.g. 15.50, debt to assets ratio and free cash flow answers to 0 decimal places, e.g. 5,275 and all answers to 1 decimal place, e.g. 1.8 or 1.83%.)

	Ratio	Target		Wal-Mart
(1)	Current ratio	enter the current ratio	:1		enter the current ratio	:1
(2)	Accounts receivable turnover	enter accounts receivable turnover in times	times		enter accounts receivable turnover in times	times
(3)	Average collection period	enter average collection period in days	days		enter average collection period in days	days
(4)	Inventory turnover	enter inventory turnover in times	times		enter inventory turnover in times	times
(5)	Days in inventory	enter days in inventory ratio	days		enter days in inventory ratio	days
(6)	Profit margin	enter percentages	%		enter percentages	%
(7)	Asset turnover	enter asset turnover in times	times		enter asset turnover in times	times
(8)	Return on assets	enter percentages	%		enter percentages	%
(9)	Return on common stockholders equity	enter percentages	%		enter percentages	%
(10)	Debt to assets ratio	enter percentages	%		enter percentages	%
(11)	Times interest earned	enter times interest earned	times		enter times interest earned	times
(12)	Free cash flow	$enter a dollar amount			$enter a dollar amount

^{"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you "A" results."}