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 |
||||||
---|---|---|---|---|---|---|---|
Income Statement Data for Year |
|||||||
Net sales |
$66,400 |
$410,000 |
|||||
Cost of goods sold |
46,000 |
308,000 |
|||||
|
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 |
|||||||
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 |
|||||
|
19,000 |
70,000 |
|||||
|
$45,900 |
$170,000 |
|||||
Beginning-of-Year Balances |
|||||||
Total assets |
$43,000 |
$162,000 |
|||||
|
14,300 |
65,000 |
|||||
|
10,500 |
55,000 |
|||||
Total liabilities |
28,700 |
97,000 |
|||||
Other Data |
|||||||
|
$7,600 |
$3,900 |
|||||
|
6,900 |
32,900 |
|||||
|
5,500 |
26,600 |
|||||
|
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."