10-18 1
.xlsx
keyboard_arrow_up
School
Arizona State University *
*We aren’t endorsed by this school
Course
COM554
Subject
Finance
Date
Apr 3, 2024
Type
xlsx
Pages
32
Uploaded by MateDonkeyPerson1060
Date
Week
Owner
Price
Region
Sales
1/1/2019
1
National
$2.83
North
$14,942
1/1/2019
1
National
$2.82
North
$15,431
1/1/2019
1
Local
$2.71
North
$15,707
1/1/2019
1
National
$2.75
North
$19,602
1/1/2019
1
Local
$2.71
North
$13,683
1/1/2019
1
National
$2.79
North
$23,436
1/1/2019
1
National
$2.74
North
$18,988
1/1/2019
1
Local
$2.76
North
$20,645
1/1/2019
1
National
$2.78
North
$28,022
1/1/2019
1
Local
$2.71
North
$25,799
1/1/2019
1
Local
$2.74
South
$30,381
1/1/2019
1
National
$2.75
South
$16,632
1/1/2019
1
National
$2.78
South
$25,220
1/1/2019
1
National
$2.80
South
$30,240
1/1/2019
1
National
$2.77
South
$24,315
1/1/2019
1
National
$2.74
South
$27,729
1/1/2019
1
National
$2.76
South
$30,835
1/1/2019
1
National
$2.75
South
$16,929
1/1/2019
1
National
$2.75
South
$22,770
1/1/2019
1
Local
$2.74
South
$14,467
1/1/2019
1
National
$2.80
East
$16,934
1/1/2019
1
Local
$2.76
East
$59,616
1/1/2019
1
National
$2.81
East
$18,726
1/1/2019
1
National
$2.76
East
$32,844
1/1/2019
1
Local
$2.81
East
$31,528
1/1/2019
1
National
$2.78
East
$15,879
1/1/2019
1
National
$2.81
East
$29,224
1/1/2019
1
National
$2.79
East
$11,718
1/1/2019
1
National
$2.78
East
$37,530
1/1/2019
1
National
$2.83
East
$15,010
1/1/2019
1
National
$2.77
West
$28,719
1/1/2019
1
National
$2.79
West
$44,997
1/1/2019
1
National
$2.80
West
$16,890
1/1/2019
1
National
$2.74
West
$13,974
1/1/2019
1
National
$2.81
West
$42,959
1/1/2019
1
National
$2.79
West
$29,529
1/1/2019
1
National
$2.77
West
$30,581
1/1/2019
1
National
$2.76
West
$22,853
1/1/2019
1
National
$2.77
West
$17,789
1/1/2019
1
National
$2.78
West
$33,760
1/2/2019
1
Local
$2.79
North
$38,591
1/2/2019
1
Local
$2.78
North
$10,208
1/2/2019
1
National
$2.80
North
$37,632
1/2/2019
1
Local
$2.73
North
$15,315
1/2/2019
1
National
$2.73
North
$18,837
1/2/2019
1
National
$2.80
North
$31,181
1/2/2019
1
National
$2.82
North
$16,539
1/2/2019
1
National
$2.77
North
$26,758
1/2/2019
1
National
$2.80
North
$27,048
1/2/2019
1
National
$2.76
North
$16,957
1/2/2019
1
National
$2.76
South
$20,766
1/2/2019
1
National
$2.81
South
$12,038
1/2/2019
1
Local
$2.77
South
$27,423
1/2/2019
1
National
$2.78
South
$28,022
1/2/2019
1
National
$2.74
South
$30,743
1/2/2019
1
Local
$2.73
South
$22,823
1/2/2019
1
National
$2.78
South
$35,495
1/2/2019
1
National
$2.78
South
$29,357
1/2/2019
1
National
$2.75
South
$35,640
1/2/2019
1
National
$2.77
South
$25,994
1/2/2019
1
National
$2.83
East
$29,160
1/2/2019
1
Local
$2.78
East
$27,222
1/2/2019
1
National
$2.77
East
$12,676
1/2/2019
1
National
$2.82
East
$16,827
1/2/2019
1
Local
$2.78
East
$35,445
1/2/2019
1
National
$2.86
East
$49,730
1/2/2019
1
National
$2.82
East
$24,365
1/2/2019
1
Local
$2.82
East
$9,644
1/2/2019
1
National
$2.78
East
$26,688
1/2/2019
1
National
$2.81
East
$18,546
1/2/2019
1
Local
$2.74
West
$33,839
1/2/2019
1
Local
$2.78
West
$16,880
1/2/2019
1
National
$2.81
West
$20,358
1/2/2019
1
Local
$2.79
West
$22,588
1/2/2019
1
Local
$2.73
West
$50,510
1/2/2019
1
Local
$2.79
West
$31,639
1/2/2019
1
National
$2.79
West
$14,999
1/2/2019
1
National
$2.81
West
$19,060
1/2/2019
1
National
$2.79
West
$28,358
1/2/2019
1
National
$2.79
West
$29,775
1/3/2019
1
Local
$2.80
North
$23,520
1/3/2019
1
Local
$2.79
North
$49,274
1/3/2019
1
Local
$2.80
North
$21,420
1/3/2019
1
Local
$2.79
North
$31,700
1/3/2019
1
National
$2.82
North
$33,874
1/3/2019
1
Local
$2.78
North
$10,008
1/3/2019
1
National
$2.81
North
$16,545
1/3/2019
1
Local
$2.76
North
$46,277
1/3/2019
1
National
$2.76
North
$13,248
1/3/2019
1
National
$2.81
North
$32,315
1/3/2019
1
Local
$2.74
South
$31,072
1/3/2019
1
Local
$2.75
South
$17,226
1/3/2019
1
Local
$2.72
South
$20,019
1/3/2019
1
National
$2.74
South
$13,152
1/3/2019
1
National
$2.74
South
$31,828
1/3/2019
1
National
$2.76
South
$20,739
1/3/2019
1
National
$2.75
South
$29,348
1/3/2019
1
National
$2.76
South
$13,116
1/3/2019
1
National
$2.76
South
$18,282
1/3/2019
1
National
$2.81
South
$13,488
1/3/2019
1
National
$2.81
East
$36,839
1/3/2019
1
Local
$2.76
East
$24,288
1/3/2019
1
Local
$2.77
East
$16,753
1/3/2019
1
Local
$2.79
East
$21,176
1/3/2019
1
National
$2.78
East
$14,261
1/3/2019
1
National
$2.83
East
$28,526
1/3/2019
1
Local
$2.83
East
$28,391
1/3/2019
1
Local
$2.83
East
$39,620
1/3/2019
1
National
$2.80
East
$14,784
1/3/2019
1
National
$2.85
East
$16,758
1/3/2019
1
National
$2.81
West
$11,869
1/3/2019
1
National
$2.83
West
$25,017
1/3/2019
1
National
$2.83
West
$29,341
1/3/2019
1
National
$2.83
West
$22,583
1/3/2019
1
National
$2.77
West
$20,642
1/3/2019
1
National
$2.79
West
$33,946
1/3/2019
1
National
$2.84
West
$15,268
1/3/2019
1
National
$2.79
West
$46,202
1/3/2019
1
Local
$2.81
West
$22,930
1/3/2019
1
National
$2.79
West
$15,066
1/4/2019
1
National
$2.83
North
$19,196
1/4/2019
1
National
$2.82
North
$14,269
1/4/2019
1
National
$2.80
North
$15,422
1/4/2019
1
National
$2.78
North
$44,836
1/4/2019
1
National
$2.77
North
$20,387
1/4/2019
1
National
$2.79
North
$30,132
1/4/2019
1
National
$2.79
North
$15,066
1/4/2019
1
National
$2.78
North
$42,890
1/4/2019
1
National
$2.85
North
$36,053
1/4/2019
1
National
$2.81
North
$14,837
1/4/2019
1
Local
$2.75
South
$30,740
1/4/2019
1
Local
$2.73
South
$18,084
1/4/2019
1
Local
$2.75
South
$23,983
1/4/2019
1
National
$2.79
South
$17,326
1/4/2019
1
National
$2.77
South
$19,196
1/4/2019
1
National
$2.78
South
$31,525
1/4/2019
1
National
$2.80
South
$22,218
1/4/2019
1
Local
$2.77
South
$33,448
1/4/2019
1
National
$2.82
South
$23,756
1/4/2019
1
National
$2.79
South
$18,280
1/4/2019
1
National
$2.88
East
$32,314
1/4/2019
1
Local
$2.77
East
$15,556
1/4/2019
1
National
$2.83
East
$37,424
1/4/2019
1
National
$2.84
East
$15,904
1/4/2019
1
Local
$2.78
East
$24,244
1/4/2019
1
National
$2.87
East
$27,328
1/4/2019
1
National
$2.80
East
$15,725
1/4/2019
1
National
$2.79
East
$15,178
1/4/2019
1
Local
$2.83
East
$18,395
1/4/2019
1
National
$2.81
East
$26,909
1/4/2019
1
National
$2.80
West
$8,064
1/4/2019
1
National
$2.84
West
$34,080
1/4/2019
1
National
$2.77
West
$12,742
1/4/2019
1
National
$2.80
West
$31,450
1/4/2019
1
National
$2.78
West
$29,051
1/4/2019
1
Local
$2.76
West
$33,137
1/4/2019
1
National
$2.80
West
$56,448
1/4/2019
1
Local
$2.75
West
$23,909
1/4/2019
1
National
$2.79
West
$18,972
1/4/2019
1
National
$2.79
West
$24,106
1/5/2019
1
Local
$2.82
North
$14,094
1/5/2019
1
Local
$2.81
North
$21,356
1/5/2019
1
Local
$2.75
North
$21,236
1/5/2019
1
National
$2.81
North
$40,464
1/5/2019
1
National
$2.83
North
$26,557
1/5/2019
1
Local
$2.76
North
$38,254
1/5/2019
1
Local
$2.76
North
$40,804
1/5/2019
1
National
$2.81
North
$42,487
1/5/2019
1
National
$2.83
North
$10,584
1/5/2019
1
National
$2.79
North
$42,938
1/5/2019
1
National
$2.79
South
$25,780
1/5/2019
1
National
$2.83
South
$31,515
1/5/2019
1
National
$2.76
South
$27,600
1/5/2019
1
Local
$2.75
South
$15,428
1/5/2019
1
National
$2.78
South
$25,960
1/5/2019
1
National
$2.81
South
$36,350
1/5/2019
1
National
$2.78
South
$37,080
1/5/2019
1
National
$2.77
South
$52,120
1/5/2019
1
National
$2.85
South
$29,845
1/5/2019
1
Local
$2.75
South
$34,155
1/5/2019
1
Local
$2.77
East
$21,789
1/5/2019
1
National
$2.79
East
$23,748
1/5/2019
1
National
$2.81
East
$11,802
1/5/2019
1
National
$2.80
East
$32,928
1/5/2019
1
National
$2.87
East
$18,879
1/5/2019
1
Local
$2.84
East
$34,097
1/5/2019
1
National
$2.86
East
$15,704
1/5/2019
1
National
$2.81
East
$42,375
1/5/2019
1
National
$2.83
East
$24,519
1/5/2019
1
National
$2.85
East
$18,120
1/5/2019
1
Local
$2.83
West
$23,534
1/5/2019
1
Local
$2.80
West
$23,142
1/5/2019
1
National
$2.80
West
$19,757
1/5/2019
1
National
$2.86
West
$40,309
1/5/2019
1
Local
$2.83
West
$15,893
1/5/2019
1
National
$2.86
West
$19,668
1/5/2019
1
Local
$2.82
West
$23,688
1/5/2019
1
National
$2.84
West
$47,235
1/5/2019
1
National
$2.83
West
$17,744
1/5/2019
1
National
$2.87
West
$7,749
1/6/2019
1
Local
$2.81
North
$21,328
1/6/2019
1
Local
$2.80
North
$31,360
1/6/2019
1
Local
$2.83
North
$16,357
1/6/2019
1
National
$2.84
North
$20,519
1/6/2019
1
National
$2.84
North
$23,311
1/6/2019
1
National
$2.83
North
$29,432
1/6/2019
1
National
$2.82
North
$16,074
1/6/2019
1
National
$2.81
North
$29,151
1/6/2019
1
National
$2.81
North
$21,480
1/6/2019
1
National
$2.81
North
$22,255
1/6/2019
1
National
$2.83
South
$16,938
1/6/2019
1
National
$2.82
South
$35,329
1/6/2019
1
National
$2.82
South
$10,423
1/6/2019
1
Local
$2.79
South
$15,959
1/6/2019
1
Local
$2.75
South
$26,648
1/6/2019
1
National
$2.81
South
$24,506
1/6/2019
1
Local
$2.78
South
$29,348
1/6/2019
1
National
$2.76
South
$13,248
1/6/2019
1
National
$2.80
South
$31,360
1/6/2019
1
National
$2.83
South
$8,694
1/6/2019
1
National
$2.86
East
$27,628
1/6/2019
1
National
$2.80
East
$14,515
1/6/2019
1
Local
$2.81
East
$41,071
1/6/2019
1
Local
$2.79
East
$25,043
1/6/2019
1
National
$2.86
East
$32,032
1/6/2019
1
National
$2.80
East
$30,106
1/6/2019
1
National
$2.88
East
$36,288
1/6/2019
1
Local
$2.81
East
$14,162
1/6/2019
1
Local
$2.84
East
$41,152
1/6/2019
1
National
$2.83
East
$27,168
1/6/2019
1
National
$2.84
West
$17,807
1/6/2019
1
National
$2.82
West
$34,246
1/6/2019
1
Local
$2.80
West
$12,813
1/6/2019
1
Local
$2.84
West
$23,617
1/6/2019
1
National
$2.85
West
$12,415
1/6/2019
1
National
$2.80
West
$33,488
1/6/2019
1
National
$2.85
West
$34,414
1/6/2019
1
National
$2.84
West
$26,582
1/6/2019
1
Local
$2.82
West
$20,575
1/6/2019
1
National
$2.83
West
$43,333
1/7/2019
2
National
$2.81
North
$35,204
1/7/2019
2
National
$2.80
North
$10,108
1/7/2019
2
National
$2.83
North
$34,639
1/7/2019
2
National
$2.87
North
$28,206
1/7/2019
2
National
$2.83
North
$29,036
1/7/2019
2
National
$2.88
North
$26,496
1/7/2019
2
National
$2.86
North
$23,747
1/7/2019
2
National
$2.86
North
$25,740
1/7/2019
2
National
$2.86
North
$16,359
1/7/2019
2
Local
$2.77
North
$19,944
1/7/2019
2
National
$2.80
South
$22,176
1/7/2019
2
National
$2.83
South
$35,862
1/7/2019
2
National
$2.84
South
$21,368
1/7/2019
2
Local
$2.76
South
$21,851
1/7/2019
2
Local
$2.76
South
$39,330
1/7/2019
2
National
$2.78
South
$16,013
1/7/2019
2
National
$2.79
South
$15,178
1/7/2019
2
National
$2.85
South
$22,572
1/7/2019
2
National
$2.82
South
$17,146
1/7/2019
2
National
$2.77
South
$16,088
1/7/2019
2
Local
$2.82
East
$28,155
1/7/2019
2
National
$2.85
East
$17,545
1/7/2019
2
National
$2.86
East
$19,562
1/7/2019
2
National
$2.83
East
$33,620
1/7/2019
2
National
$2.83
East
$42,026
1/7/2019
2
Local
$2.87
East
$19,516
1/7/2019
2
National
$2.90
East
$28,954
1/7/2019
2
Local
$2.81
East
$28,662
1/7/2019
2
Local
$2.83
East
$14,382
1/7/2019
2
National
$2.84
East
$31,240
1/7/2019
2
Local
$2.81
West
$20,940
1/7/2019
2
National
$2.84
West
$23,319
1/7/2019
2
Local
$2.85
West
$28,090
1/7/2019
2
National
$2.85
West
$42,476
1/7/2019
2
National
$2.88
West
$14,008
1/7/2019
2
Local
$2.84
West
$10,042
1/7/2019
2
National
$2.79
West
$31,873
1/7/2019
2
Local
$2.83
West
$24,757
1/7/2019
2
National
$2.83
West
$19,697
1/7/2019
2
Local
$2.82
West
$27,566
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Pa help po salamat
arrow_forward
II. Direction: The following comparative financial statements are provided by Zeus Company. Using
Horizontal and Vertical approach, calculate the missing and write your answer on the blank. Show
supporting solutions in a separate sheet of paper. Answer the questions at the bottom of this activity.
arrow_forward
comparative income statements of Arab
Manufacturing Company are shown below.
2019
$38,610 $32,175 $25,740
2020
2018
Net sales
25,100 19,950
S13,510 S12,225 $10,340
7,700
4,270
Cost of sales
15,400
Gross profit
Selling expenses
6,565
5,148
Administrative
4.175
3,861
expenses
Total operating
S11,970 $10,740 $9.009
expenses
Operating
S 1,540 S1,485 $1,331
income
Interest expense
115
95
100
Net income
S 1,425 S 1,390 $1,231
before tax
655
645
S 770 S 745
541
$ 690
Income taxes
Net income
Required:
a. Perform a vertical, common size analysis of the
income statement data for Arab Manufacturing
Company in columnar form, using sales as the
base.
b. Comment briefly on significant trends and
relationships revealed by the computations. :52 PM
arrow_forward
Find the following:
•Sales revenue
•Cost of Good Sold
•Insurance Expense
•Income before Tax
•Income after Tax
arrow_forward
Compute the following
Output Tax due for the Month
PH TAXATION show solution
Vatable sale P1, 500,000
Domestic purchase of goods other than Capital Goods P 100,000
Domestic Purchase of Service 200,000
Purchase of agricultural food products in original state P 150,000
arrow_forward
Excerpts from the annual report of XYZ Corporation follow:
2019
$675,138
$241,154
$64,150
$93,650
$25,100
2020
Cost of goods sold
Inventory
Net income
$754,661
$219,686
$31,185
$68,685
$26,900
Retained earnings
LIFO reserve
Tax rate
20%
20%
If XYZ used FIFO, its net income for fiscal 2020 would be
O a. $34,165
O b. $30,375
O c. $32,625
d. $36,545
arrow_forward
Operating data for Joshua Corporation are presented as follows:
Net Sales
Cost of Goods Sold
Selling Expenses
Administrative Expenses
Income Tax Expense
Net Income
2022
800,000
520,000
120,000
60,000
30,000
70,000
Instructions
Prepare a schedule showing a vertical analysis for 2022 and 2021.
Net Sales
Cost of Goods Sold
Gross Profit
Selling Expenses
Your Answers:
FYI: Format the percent cols to one decimal place. Ex 99.9%
2022
Administrative Expenses
Total Operating Expenses
Income Before Income Taxes
Income Tax Expense
Net Income
2021
600,000
408,000
72,000
48,000
24,000
48,000
Amount
800,000
520,000
280,000
120,000
60,000
180,000
100,000
30,000
70,000
Percent
100.0%
2021
Amount Percent
600,000
100.0%
408,000
192,000
72,000
48,000
120,000
72,000
24,000
48,000
arrow_forward
Company XYZ it made sales of $230,000 during 2019 the fixed expenses were $90,000 and variable expense with $50,000 the cost of goods as sold was $35,000 calculate the gross margin for XYZ
arrow_forward
LOGIC COMPANYComparative Income StatementFor Years Ended December 31, 2019 and 2020
2020
2019
Gross sales
$
19,000
$
15,000
Sales returns and allowances
1,000
100
Net sales
$
18,000
$
14,900
Cost of merchandise (goods) sold
12,000
9,000
Gross profit
$
6,000
$
5,900
Operating expenses:
Depreciation
$
700
$
600
Selling and administrative
2,200
2,000
Research
550
500
Miscellaneous
360
300
Total operating expenses
$
3,810
$
3,400
Income before interest and taxes
$
2,190
$
2,500
Interest expense
560
500
Income before taxes
$
1,630
$
2,000
Provision for taxes
640
800
Net income
$
990
$
1,200
LOGIC COMPANYComparative Balance SheetDecember 31, 2019 and 2020
2020
2019
Assets
Current assets:
Cash
$
12,000
$
9,000
Accounts receivable
16,500
12,500
Merchandise inventory
8,500
14,000
Prepaid expenses
24,000
10,000
Total current assets
$
61,000
$
45,500
Plant and…
arrow_forward
LOGIC COMPANYComparative Income StatementFor Years Ended December 31, 2019 and 2020
2020
2019
Gross sales
$
19,000
$
15,000
Sales returns and allowances
1,000
100
Net sales
$
18,000
$
14,900
Cost of merchandise (goods) sold
12,000
9,000
Gross profit
$
6,000
$
5,900
Operating expenses:
Depreciation
$
700
$
600
Selling and administrative
2,200
2,000
Research
550
500
Miscellaneous
360
300
Total operating expenses
$
3,810
$
3,400
Income before interest and taxes
$
2,190
$
2,500
Interest expense
560
500
Income before taxes
$
1,630
$
2,000
Provision for taxes
640
800
Net income
$
990
$
1,200
LOGIC COMPANYComparative Balance SheetDecember 31, 2019 and 2020
2020
2019
Assets
Current assets:
Cash
$
12,000
$
9,000
Accounts receivable
16,500
12,500
Merchandise inventory
8,500
14,000
Prepaid expenses
24,000
10,000
Total current assets
$
61,000
$
45,500
Plant and…
arrow_forward
Natal Company provided the following information:
Pro
Problem 10-2 (IAA)
1,400,000
200,000
650,000
60,000
150,000
2,000,000
Sum
beg
of 9
yea
Materiale
Advance for materials ordered
Goods in process
Unexpired insurance on inventories
Advertising catalogs and ehipping cartona
Finished gooda in factory
Finished goods in company-owned retail store,
including 50% profit on cost
Pinished goods in hands of consignees including
40% profit on sales
Finished goods in tranait to customers, shipped FOB
deatination at cost
Finished gooda out on approval, at cost
Unsalable fininhed gooda, at cost
Office supplies
Materials in transit shipped FOB nhipping point,
excluding freight of P30,000
Goods held on consignment, at sales price, cost P150,000
1.
2.
750,000
3.
4.
400,000
250,000
100,000
50,000
40,000
330,000
200,000
Required:
Compute the correct amount of inventory.
arrow_forward
LOGIC COMPANY
Comparative Income Statement
For Years Ended December 31, 2019 and 2020
2020
2019
Gross sales
$20,600
$16,200
Sales returns and allowances
800
100
Net sales
$19,800
11,600
$ 8,200
$16,100
8,600
$ 7,500
Cost of merchandise (goods) sold
Gross profit
Operating expenses:
Depreciation
Selling and administrative
Research
Miscellaneous
Total operating expenses
Income before interest and taxes
Interest expense
860
680
3,400
2,800
710
580
520
380
sa
$5,490
$ 2,710
$ 4,440
$ 3,060
720
580
Income before taxes
$ 1,990
$2,480
992
Provision for taxes
796
Net income
$ 1,194
$ 1,488
LOGIC COMPANY
Comparative Balance Sheet
December 31, 2019 and 2020
2020
2019
Assets
Current assets:
Cash
Accounts receivable
Merchandise inventory
Prepaid expenses
Total current assets
Plant and equipment:
Building (net)
$12,800
17,300
9,300
24,800
$64, 200 $ 48, 700
$ 9,800
13,300
14,800
10,800
$15,300
14,300
$11, 800
9,800
Land
acer
Σ
%24
%24
arrow_forward
ni1
arrow_forward
Calculate the following Ratio:
Gross profit Ratio
Net profit Ratio
arrow_forward
Financial statement analysis The financial statements of Zach Industries for the year ended December 31, 2019, follow .
a. Use the financial statements to complete the following table E. Assume the industry averages given in the table are applicable for both 2018 and 2019.
b. Analyze Zach Industries' financial condition as it is related to (1) liquidity, (2) activity, (3) debt, (4) profitability, and (5) market. Summarize the company's overall financial condition.
.....
a. The current ratio is 1.04. (Round to two decimal places.)
The quick ratio is .38. (Round to two decimal places.)
The inventory turnover is 2.32. (Round to two decimal places.)
The average collection period is 56.1 days. (Round to one decimal place.)
The debt ratio is 61.7 %. (Round to one decimal place.)
The times interest earned ratio is
|. (Round to one decimal place.)
arrow_forward
please answer do not image
arrow_forward
Perform profitability analysis for the two quotas
arrow_forward
Assume the following cost of goods sold data for a company:
2023
$1295360
2022
1209000
2021
1012000
If 2021 is the base year, what is the percentage increase in cost of goods sold from 2021 to 2023?
arrow_forward
prepare common size income state for this company
Frontier Communications
Fiscal year is January-December. All values USD Millions.
2020
Sales/Revenue
7,155
Sales Growth
-11.74%
Cost of Goods Sold (COGS) incl. D&A
4,299
COGS excluding D&A
2,701
Depreciation & Amortization Expense
1,598
Depreciation
1,255
Amortization of Intangibles
343
COGS Growth
-11.12%
Gross Income
2,856
Gross Income Growth
-12.66%
Gross Profit Margin
39.92%
SG&A Expense
1,648
Other SG&A
1,648
SGA Growth
-8.65%
EBIT
1,208
Unusual Expense
568
Non Operating Income/Expense
-368
Non-Operating Interest Income
4
Interest Expense
762
Interest Expense Growth
-50.36%
Gross Interest Expense
762
Interest Capitalized
-
Pretax Income
-486
Pretax Income Growth
92.55%
Pretax Margin
-6.79%
Income Tax
-84
Income Tax - Current Domestic
7
Income Tax - Deferred Domestic
-91
Other After Tax Income (Expense)
-
Consolidated Net Income
-402
Net Income…
arrow_forward
salamagundi, inc. has the following income statement:
For the year ended December 31, 2021
net sales: $160
Cost of goods sold: $100
gross profit: $60
Operating expenses: $40
Net income: $20
Using vertical analysis, what percentage is assigned to operating expenses?
a. 25%
b. 40%
c. 66.7%
d. 200%
arrow_forward
A comparative income statement is given below for Rainbow Company
Rainbow Company
Comparative Income Statement
For the Years Ended June 30, 2019, and 2018
2019
2018
Sales
P
5,000,000.00
P
4,000,000.00
Less: Cost of Goods Sold
3,160,000.00
2,400,000.00
Gross Margin
1,840,000.00 P
1,600,000.00
Selling Expenses
900,000.00
700,000.00
Administrative Expenses
680,000.00
584,000.00
Total Expenses
1,580,000.00
1,284,000.00
Net Operating Income
260,000.00
P
316,000.00
Interest Expense
70,000.00
40,000.00
Net Income Before Taxes
P
190,000.00 P
276,000.00
The president is concerned that net income is down in 2019 even though sales have increased
during the year. The president is also concerned that administrative expenses have increased,
since the company made a concerted effort during 2019 to pare "fat" out of the organization.
Required:
1. Express each year's income statement in common-size percentages. Carry
computations to one decimal place.
2. Comment briefly on the changes between the two…
arrow_forward
Question - Oman Environme
ps://www.classmarker.com/online-
Question 6 of 16
ABC Computers (January) Actual (OMR) Target (OMR)
277,350
Sales Turnover
325.000
Sales Tax (14%)
38,829
45,500
Net Turnover
238,521
279,500
Labor Costs
166.000
175,000
Other Costs
36.000
41.000
Gross Profit
36,521
63,500
If actual labor costs rise so as to halve their difference from the target, what will be the change in
actual Gross Profit?
O A) Falls by OMR 4,500
O B) Rises by OMR 4,500
O C) No overall effect
O D) Rises by OMR 9.000
Next
DOLL
arrow_forward
Would you please help me with this
arrow_forward
National Chemicals Company
Income Statements for the years Ended June 30
2020
2019
$
$
Revenue
6,336.3
5790.4
Cost of sales
1,617.4
1476.3
Gross profit
4,718.9
4,314.1
Selling and Administrative Expenses
4,007.6
3679
PBIT
711.3
635.1
Interest Expense
13.9
27.1
PBT
697.4
608.0
Income Tax
291.3
232.6
Net Profit
406.1
375.4
Calculate the following ratios:
Interest Cover ratio for 2020 is:
Net Profit Margin for 2020 is
arrow_forward
Problem 13-02A (Video)
The comparative statements of Cullumber Company are presented here:
Cullumber CompanyIncome StatementsFor the Years Ended December 31
2020
2019
Net sales
$1,891,640
$1,751,600
Cost of goods sold
1,059,640
1,007,100
Gross profit
832,000
744,500
Selling and administrative expenses
501,100
480,100
Income from operations
330,900
264,400
Other expenses and losses
Interest expense
23,700
21,700
Income before income taxes
307,200
242,700
Income tax expense
93,700
74,700
Net income
$213,500
$168,000
Cullumber CompanyBalance SheetsDecember 31
Assets
2020
2019
Current assets
Cash
$60,100
$64,200
Debt investments (short-term)
74,000
50,000
Accounts receivable
118,900
103,900
Inventory
127,700
117,200
Total current assets
380,700
335,300
Plant assets (net)…
arrow_forward
Dollar-Value LIFO and Inventory Pools
Webster Company adopted dollar-value LIFO on January 1, 2019. Webster produces three products: X, Y, and Z. Webster's beginning inventory consisted of the following:
Type
Quantity
Cost perUnit
Total Cost
X
30,000
$4.25
$127,500
Y
10,000
3.50
35,000
Z
25,000
2.00
50,000
65,000
$212,500
During 2019, Webster had the following purchases and sales:
Type
QuantityPurchased
Cost PerUnit
QuantitySold
Selling Priceper Unit
X
110,000
$4.75
90,000
$10.00
Y
100,000
3.75
85,000
7.50
Z
75,000
2.10
70,000
5.00
285,000
245,000
Required:
1. Compute the LIFO cost of the ending inventory assuming Webster uses a single inventory pool. Round cost index to four decimal places.$
arrow_forward
Walang Kayo Company Question: Under accrual basis, what amount should be reported as gross sales for the current year?
a. P6,650,000
b. P6,600,000
c. P6,350,000
d. P6,550,000
arrow_forward
Please help me
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Related Questions
- Pa help po salamatarrow_forwardII. Direction: The following comparative financial statements are provided by Zeus Company. Using Horizontal and Vertical approach, calculate the missing and write your answer on the blank. Show supporting solutions in a separate sheet of paper. Answer the questions at the bottom of this activity.arrow_forwardcomparative income statements of Arab Manufacturing Company are shown below. 2019 $38,610 $32,175 $25,740 2020 2018 Net sales 25,100 19,950 S13,510 S12,225 $10,340 7,700 4,270 Cost of sales 15,400 Gross profit Selling expenses 6,565 5,148 Administrative 4.175 3,861 expenses Total operating S11,970 $10,740 $9.009 expenses Operating S 1,540 S1,485 $1,331 income Interest expense 115 95 100 Net income S 1,425 S 1,390 $1,231 before tax 655 645 S 770 S 745 541 $ 690 Income taxes Net income Required: a. Perform a vertical, common size analysis of the income statement data for Arab Manufacturing Company in columnar form, using sales as the base. b. Comment briefly on significant trends and relationships revealed by the computations. :52 PMarrow_forward
- Find the following: •Sales revenue •Cost of Good Sold •Insurance Expense •Income before Tax •Income after Taxarrow_forwardCompute the following Output Tax due for the Month PH TAXATION show solution Vatable sale P1, 500,000 Domestic purchase of goods other than Capital Goods P 100,000 Domestic Purchase of Service 200,000 Purchase of agricultural food products in original state P 150,000arrow_forwardExcerpts from the annual report of XYZ Corporation follow: 2019 $675,138 $241,154 $64,150 $93,650 $25,100 2020 Cost of goods sold Inventory Net income $754,661 $219,686 $31,185 $68,685 $26,900 Retained earnings LIFO reserve Tax rate 20% 20% If XYZ used FIFO, its net income for fiscal 2020 would be O a. $34,165 O b. $30,375 O c. $32,625 d. $36,545arrow_forward
- Operating data for Joshua Corporation are presented as follows: Net Sales Cost of Goods Sold Selling Expenses Administrative Expenses Income Tax Expense Net Income 2022 800,000 520,000 120,000 60,000 30,000 70,000 Instructions Prepare a schedule showing a vertical analysis for 2022 and 2021. Net Sales Cost of Goods Sold Gross Profit Selling Expenses Your Answers: FYI: Format the percent cols to one decimal place. Ex 99.9% 2022 Administrative Expenses Total Operating Expenses Income Before Income Taxes Income Tax Expense Net Income 2021 600,000 408,000 72,000 48,000 24,000 48,000 Amount 800,000 520,000 280,000 120,000 60,000 180,000 100,000 30,000 70,000 Percent 100.0% 2021 Amount Percent 600,000 100.0% 408,000 192,000 72,000 48,000 120,000 72,000 24,000 48,000arrow_forwardCompany XYZ it made sales of $230,000 during 2019 the fixed expenses were $90,000 and variable expense with $50,000 the cost of goods as sold was $35,000 calculate the gross margin for XYZarrow_forwardLOGIC COMPANYComparative Income StatementFor Years Ended December 31, 2019 and 2020 2020 2019 Gross sales $ 19,000 $ 15,000 Sales returns and allowances 1,000 100 Net sales $ 18,000 $ 14,900 Cost of merchandise (goods) sold 12,000 9,000 Gross profit $ 6,000 $ 5,900 Operating expenses: Depreciation $ 700 $ 600 Selling and administrative 2,200 2,000 Research 550 500 Miscellaneous 360 300 Total operating expenses $ 3,810 $ 3,400 Income before interest and taxes $ 2,190 $ 2,500 Interest expense 560 500 Income before taxes $ 1,630 $ 2,000 Provision for taxes 640 800 Net income $ 990 $ 1,200 LOGIC COMPANYComparative Balance SheetDecember 31, 2019 and 2020 2020 2019 Assets Current assets: Cash $ 12,000 $ 9,000 Accounts receivable 16,500 12,500 Merchandise inventory 8,500 14,000 Prepaid expenses 24,000 10,000 Total current assets $ 61,000 $ 45,500 Plant and…arrow_forward
- LOGIC COMPANYComparative Income StatementFor Years Ended December 31, 2019 and 2020 2020 2019 Gross sales $ 19,000 $ 15,000 Sales returns and allowances 1,000 100 Net sales $ 18,000 $ 14,900 Cost of merchandise (goods) sold 12,000 9,000 Gross profit $ 6,000 $ 5,900 Operating expenses: Depreciation $ 700 $ 600 Selling and administrative 2,200 2,000 Research 550 500 Miscellaneous 360 300 Total operating expenses $ 3,810 $ 3,400 Income before interest and taxes $ 2,190 $ 2,500 Interest expense 560 500 Income before taxes $ 1,630 $ 2,000 Provision for taxes 640 800 Net income $ 990 $ 1,200 LOGIC COMPANYComparative Balance SheetDecember 31, 2019 and 2020 2020 2019 Assets Current assets: Cash $ 12,000 $ 9,000 Accounts receivable 16,500 12,500 Merchandise inventory 8,500 14,000 Prepaid expenses 24,000 10,000 Total current assets $ 61,000 $ 45,500 Plant and…arrow_forwardNatal Company provided the following information: Pro Problem 10-2 (IAA) 1,400,000 200,000 650,000 60,000 150,000 2,000,000 Sum beg of 9 yea Materiale Advance for materials ordered Goods in process Unexpired insurance on inventories Advertising catalogs and ehipping cartona Finished gooda in factory Finished goods in company-owned retail store, including 50% profit on cost Pinished goods in hands of consignees including 40% profit on sales Finished goods in tranait to customers, shipped FOB deatination at cost Finished gooda out on approval, at cost Unsalable fininhed gooda, at cost Office supplies Materials in transit shipped FOB nhipping point, excluding freight of P30,000 Goods held on consignment, at sales price, cost P150,000 1. 2. 750,000 3. 4. 400,000 250,000 100,000 50,000 40,000 330,000 200,000 Required: Compute the correct amount of inventory.arrow_forwardLOGIC COMPANY Comparative Income Statement For Years Ended December 31, 2019 and 2020 2020 2019 Gross sales $20,600 $16,200 Sales returns and allowances 800 100 Net sales $19,800 11,600 $ 8,200 $16,100 8,600 $ 7,500 Cost of merchandise (goods) sold Gross profit Operating expenses: Depreciation Selling and administrative Research Miscellaneous Total operating expenses Income before interest and taxes Interest expense 860 680 3,400 2,800 710 580 520 380 sa $5,490 $ 2,710 $ 4,440 $ 3,060 720 580 Income before taxes $ 1,990 $2,480 992 Provision for taxes 796 Net income $ 1,194 $ 1,488 LOGIC COMPANY Comparative Balance Sheet December 31, 2019 and 2020 2020 2019 Assets Current assets: Cash Accounts receivable Merchandise inventory Prepaid expenses Total current assets Plant and equipment: Building (net) $12,800 17,300 9,300 24,800 $64, 200 $ 48, 700 $ 9,800 13,300 14,800 10,800 $15,300 14,300 $11, 800 9,800 Land acer Σ %24 %24arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning