target corp
xlsx
keyboard_arrow_up
School
Louisiana State University *
*We aren’t endorsed by this school
Course
1
Subject
Finance
Date
Jan 9, 2024
Type
xlsx
Pages
18
Uploaded by JudgeTreeSheep41
RATIO ANALYSIS
Target Corp
2021
2020
2019
2018
2017
$
Percent
$
Percent
$
$
$
Income Statement
Revenue
106,005
100.0%
92,400
100.0%
78,112
75,356
76,432
Cost of Goods Sold
74,963
70.7%
66,177
71.6%
54,864
Interest Expense
421
0.4%
977
1.1%
477
Tax Expense
1,961
1.8%
1,178
1.3%
921
Income from Cont Operations
6,946
6.6%
4,368
4.7%
3,269
4,110
4,224
Net Income
6,946
6.6%
4,368
4.7%
Balance Sheet
Cash
5,911
11.0%
8,511
16.6%
1,556
Short Term Investments
4,985
9.3%
7,644
14.9%
1,810
Accounts Receivable
631
1.2%
498
1.0%
0
Inventory
13,902
25.8%
10,653
20.8%
9,497
Current Assets
21,573
40.1%
20,756
40.5%
12,519
Long Term Investments
13,549
25.2%
11,536
22.5%
Net Fixed Assets
28,813
53.5%
28,002
54.6%
Other Assets
1,760
3.3%
1,592
3.1%
Total Assets
53,811
100.0%
51,248
100.0%
41,290
Current Liabilities
21,747
40.4%
20,125
39.3%
15,014
Total Liabilities
40,984
76.2%
36,808
71.8%
29,993
Total Stockholders' Equity
12,827
23.8%
14,440
28.2%
11,297
Cash Flow
Cash Flow from Operations
8,625
10,525
7,117
Dividends Paid
1,548
1,343
1,330
Interest Paid
414
939
492
Share Information Market Price at Year End
231.44
176.53
124.76
Earnings Per Share - Basic
14.23
8.72
6.39
Shares Outstanding
488,000
500,600
510,900
RATIO ANALYSIS
Growth Ratios
Sales Growth
14.7%
18.3%
Income Growth
59.0%
33.6%
Asset Growth
5.0%
24.1%
Activity Ratios
Receivable Turnover
187.8
371.1
Inventory Turnover
6.1
6.6
Fixed Asset Turnover
3.7
3.3
Profitability Ratios
Profit Margin
6.6%
4.7%
Return on Assets
13.2%
9.4%
Return on Equity
50.9%
33.9%
Dividend Payout Ratio
22.3%
30.7%
Price Earnings Ratio
16.3
20.2
Liquidity Ratios
Current Ratio
0.99
1.03
Quick Ratio
0.53
0.83
Solvency Ratios
Debt to Total Assets
0.76
0.72
Times Interest Earned (Accrual)
22.16
6.68
Times Interest Earned (Cash)
21.83
12.21
© 2008 William R. Pasewark
PRIMARY COMPETITOR ANALYSIS
Target Corp
Nordstorm
$
$
Income Statement
Revenue
106,005
14,402
Cost of Goods Sold
74,963
9,344
Interest Expense
421
246
Tax Expense
1,961
68
Income from Cont Op
6,946
178
Net Income
6,946
178
Prior Year Revenue
92,400
10,357
Prior Year Income from Continuing Operations
4,368
690
Balance Sheet
Cash
5,911
322
Short Term Investments
4,985
258
Accounts Receivable
631
255
Inventory
13,902
2,289
Current Assets
21,573
3,172
Long Term Investments
13,549
5,058
Net Fixed Assets
28,813
506
Other Assets
1,760
390
Total Assets
53,811
8,869
Current Liabilities
21,747
1,529
Total Liabilities
40,984
8,288
Total Stockholders' Equity
12,827
581
Prior Year Accounts Receivable
498
245
Prior Year Inventory
10,653
1,863
Prior Year Assets
51,248
3,642
Prior Year Liabilities
36,808
9,233
Prior Year Stockholders' Equity
14,440
305
Cash Flow
Cash Flow from Operations
8,625
705
Dividends Paid
1,548
0
Interest Paid
414
164
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
RATIO ANALYSIS
Income Statement Common-Size Data
Gross Profit/Sales
29.3%
35.1%
Income from Continuing Operations/Sales
6.6%
1.2%
Balance Sheet Common-Size Data
Current Assets/Total Assets
40.1%
35.8%
Current Liabilities/Total Assets
40.4%
17.2%
Liabilities/Total Assets
76.2%
93.4%
Equity/Total Assets
23.8%
6.6%
Profitabilty Ratios
Profit Margin
6.6%
1.2%
Return on Assets
13.2%
2.8%
Return on Equity
50.9%
40.2%
Dividend Payout Ratio
22.3%
0.0%
Liquidity Ratios
Current Ratio
0.99
2.07
Quick Ratio
0.53
0.55
Solvency Ratios
Debt/Total Assets
0.76
0.93
Times Interest Earned (Accrual)
22.16
2.00
Operational Ratios
Receivable Turnover
187.8
57.6
Inventory Turnover
6.1
4.5
©
2008 William R. Pasewark
TREND ANALYSIS
Prior Year
Revenue
$76,423
$75,356
$78,112
$92,400
$106,005
Income - Continuing Operations
$4,224
$4,110
$3,269
$4,368
$6,946
Cash Flow from Operations
$7,117
$10,525
$8,625
Total Assets
$41,290
$51,248
$53,811
5 Years Ago
4 Years Ago
3 Years Ago
Current Year
5 Years Ago
4 Years Ago
3 Years Ago
Prior Year
Current Year
$0
$50,000
$100,000
$150,000
REVENUE TREND
5 Years Ago
4 Years Ago
3 Years Ago
Prior Year
Current Year
$0
$1,000
$2,000
$3,000
$4,000
$5,000
$6,000
$7,000
NET INCOME TREND
3 Years Ago
Prior Year
Current Year
$0
$2,000
$4,000
$6,000
$8,000
$10,000
$12,000
INCOME TO CASH FLOW COMPARISON
Income - Continuing Opera-
tions
Cash Flow from Op-
erations
©
2008 William R. Pasewark
3 Years Ago
Prior Year
Current Year
$0
$10,000
$20,000
$30,000
$40,000
$50,000
$60,000
ASSET CHANGES
Total Assets
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
QUARTERLY DATA
1st Q
2nd Q
3rd Q
4th Q
Annual
Current Year Revenue
26,520
26,040
25,170
31,000
108,730
Last Year Revenue
25,160
25,160
24,210
28,340
102,870
Current Year Income
712
1,830
1,010
1,540
5,092
Last Year Income
1,490
1,540
1,010
1,830
5,870
CURRENT YEAR QUARTERLY STOCK PRICES
1st Q
2nd Q
3rd Q
4th Q
High Price
$210.86
$263.46
$261.51
$268.98
Low Price
$168.12
$202.78
$222.88
$214.60
1st Q
2nd Q
3rd Q
4th Q
0
5,000
10,000
15,000
20,000
25,000
30,000
35,000
26,520
26,040
25,170
31,000
25,160
25,160
24,210
28,340
QUARTERLY REVENUE
Current Year Rev-
enue
Last Year Rev-
enue
1st Q
2nd Q
3rd Q
4th Q
0
500
1,000
1,500
2,000
QUARTERLY INCOME
Current Year Income
Last Year Income
1st Q
2nd Q
3rd Q
4th Q
$0.00
$50.00
$100.00
$150.00
$200.00
$250.00
$300.00
QUARTERLY STOCK HIGHS AND LOWS
High Price
Low Price
© 2008 William R. Pasewark
Previous Year 83.65
109.33
114.83
130.24
69.07
70.03
104.01
107.02
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
ANALYSIS OF ACCOUNTS RECEIVABLE
Target Corp
Nordstorm
Current Year
Prior Year
3 Years Ago
Current Year
Prior Year
Accounts Receivable
631
498
0
255
245
Allowance for Bad Debt
430
690
1016
59
43
Total Assets
53,811
51,248
41,290
8,869
3,642
Revenue
106,005
92,400
78,112
14,402
10,357
Bad Debt Expense
154
528
1185
52
42
IMPACT OF ACCOUNTS RECEIVABLE
Bad Debt Expense Percentage
0.1%
0.6%
1.5%
0.4%
0.4%
Allowance Percentage
40.5%
58.1%
100.0%
18.8%
14.9%
Accounts Receivable to Total Assets
1.2%
1.0%
0.0%
2.9%
6.7%
RECIEVABLE COLLECTION RATES
Receivable Turnover
189.3
108.3
282.4
Days of Receivable
1.9
3.4
1.3
© 2008 William R. Pasewark
ANALYSIS OF INVENTORY
Target Corp
Nordstorm
Current Year
Prior Year
3 Years Ago
Current Year
Prior Year
Total Assets
53,811
51,248
41,290
8,869
3,642
Inventory
13,902
10,653
9,497
2,289
1,863
Revenue
106,005
92,400
78,112
14,402
10,357
Cost of Goods Sold
74,963
66,177
54,864
9,344
7,600
Gross Profit
31,042
26,223
23,248
5,058
2,757
IMPACT OF INVENTORY
Inventory to Total Assets
25.8%
20.8%
23.0%
25.8%
51.2%
Cost of Goods Sold Percentage
70.7%
71.6%
70.2%
64.9%
73.4%
INVENTORY TURNOVER RATES
Inventory Turnover
6.1
6.6
4.5
Days in Inventory
59.8
55.6
81.1
INVENTORY YIELD
Inventory Yield
2.5
2.6
2.4
© 2008 William R. Pasewark
ANALYSIS OF FIXED ASSETS
Target Corp
Nordstorm
Current Year
Prior Year
3 Years Ago
Current Year
Prior Year
Total Assets
53,811
51,248
41,290
8,869
3,642
Gross Fixed Assets
28,181
26,789
26,014
4,863
3,921
Accumulated Depreciation
21,137
20,278
19,664
615
671
Net Fixed Assets
28,813
28,002
6,350
506
3,250
Depreciable Assets
20,899
19,973
19,417
4,205
3,405
Gross Capital Leases
2,972
3,578
3,984
4,409
4,456
Revenue
106,005
92,400
78,112
14,402
10,357
Depreciation Expense
2,642
2,485
2,604
790
839
Operating Lease Expense
387
332
287
191
0
IMPACT OF FIXED ASSETS
Tangibility Ratio 53.5%
54.6%
15.4%
5.7%
89.2%
Depreciation as a Percent of Revenue
2.5%
2.7%
3.3%
5.5%
8.1%
Operating Lease Utilization
0.4%
0.4%
0.4%
1.3%
0.0%
Capital Lease Utilization
5.5%
7.0%
9.6%
49.7%
122.4%
FIXED ASSET ACTIVITY RATIOS
Fixed Asset Turnover
3.7
5.4
7.7
Total Asset Turnover
2.0
2.0
2.3
FIXED ASSET USAGE RATIOS
Percent Depreciated
75.0%
75.7%
75.6%
12.6%
17.1%
Average Fixed Asset Life
7.9
8.0
7.5
5.3
4.1
© 2008 William R. Pasewark
cip
1257
780
533
373
231
land
6025
6036
6064
285
285
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
ANALYSIS OF DEBT
Target Corp
Nordstorm
Current Year
Prior Year
3 Years Ago
Current Year
Prior Year
Quick Assets
11,527
16,653
3,366
835
957
Current Assets
21,573
20,756
12,519
3,172
3,374
Current Liabilities
21,747
20,125
15,014
1,529
2,281
Accounts Payable
15,478
12,859
9,780
1,455
1,854
Purchases
78,212
67,333
9,770
Total Assets
53,811
51,248
41,290
8,869
3,642
Total Liabilities
40,984
36,808
29,993
8,288
9,233
Total Stockholders' Equity
12,827
14,440
11,297
581
305
Income from Continuing Operations
6,946
4,368
3,269
178
690
Interest Expense
421
977
477
68
Tax Expense
1,961
1,178
921
68
Cash Flow from Operations
8,625
10,525
7,117
705
Interest Paid
414
939
492
164
LIQUIDITY RATIOS (ANALYSIS OF CURRENT DEBT)
Current (Working Capital) Ratio
1.0
1.0
0.8
2.1
1.5
Quick (Acid-Test) Ratio
0.5
0.8
0.2
0.5
0.4
Days Payable Outstanding
66
61
62
SOLVENCY RATIOS (ANALYSIS OF LONG-TERM DEBT)
Debt to Total Assets
0.76
0.72
0.73
0.93
2.54
Debt to Equity 3.20
2.55
2.65
14.27
30.27
DEBT SERVICABILITY
Times Interest Earned (Accrual Basis)
22.2
6.7
9.8
4.6
Times Interest Earned (Cash Basis)
21.8
12.2
5.3
© 2008 William R. Pasewark
STOCKHOLDER ANALYSIS
Target Corp
Nordstorm
Current Year
Prior Year
3 Years Ago
Current Year
Prior Year
Total Assets
53,811
51,248
41,290
8,869
3,642
Total Stockholders' Equity
12,827
14,440
11,297
581
305
Income from Continuing Operations
6,946
4,368
3,269
178
690
Dividends Paid
1,548
1,343
1,330
0
58
Market Price at Year End
231.44
176.53
124.76
5.27
4.22
Basic Earnings per Share
14.23
8.72
6.39
4.39
3.18
Shares Outstanding
488,000
500,600
510,900
157
156
Dividends per Share
0.00
0.00
0.00
0.00
0.37
DIVIDEND RATIOS
Dividend Payout Ratio
22.3%
30.7%
40.7%
0.0%
8.4%
Dividend Yield
0.0%
0.0%
0.0%
0.0%
8.8%
EARNINGS AND RETURN RATIOS
Return on Assets
13.2%
9.4%
2.8%
Return on Equity
50.9%
33.9%
40.2%
Total Stockholder Return
31.1%
41.5%
24.9%
Price Earnings Ratio
16.3
20.2
19.5
1.2
1.3
© 2008 William R. Pasewark
ANALYSIS OF RETIREMENT PLANS
Target Corp
Nordstorm
Current Year
Prior Year
3 Years Ago
Current Year
Prior Year
Total Assets
53,811
51,248
41,290
8,869
3,642
Revenue
106,005
92,400
78,112
14,402
10,357
Defined Contribution Pension Expense
307
281
237
N/a
n/a
Defined Benefit Pension Expense
467
410
430
n/a
n/a
Defined Benefit Pension Cash Contribution
236
263
245
n/a
n/a
Other Post Retirement Expense
1,105
1,065
1,652
n/a
n/a
Other Post Retirement Cash Contribution
236
236
236
n/a
n/a
Fair Market Value of Pension Assets
4,433
4,588
4,387
n/a
n/a
Fair Market Value of Other Post-Retirement Assets
2,186
1,954
1,875
n/a
n/a
Accumulated Benefit Obligation (ABO) for Pensions
4,520
4,005
4,650
n/a
n/a
Projected Benefit Obligation (PBO) for Pension 4,305
4,594
4,605
n/a
n/a
Projected Benefit Obligation for Other Post-Retirement
238
242
248
n/a
n/a
IMPACT OF RETIREMENT PLANS ON EARNINGS
Defined Contribution Pension Expense to Revenue
0.3%
0.3%
0.3%
#VALUE!
#VALUE!
Defined Benefit Pension Expense to Revenue
0.4%
0.4%
0.6%
#VALUE!
#VALUE!
Total Pension Expense to Revenue
0.7%
0.7%
0.9%
#VALUE!
#VALUE!
Other Post Retirement Expense to Revenue
1.0%
1.2%
2.1%
#VALUE!
#VALUE!
Retirement Expense to Revenue
1.8%
1.9%
3.0%
#VALUE!
#VALUE!
IMPACT OF RETIREMENT PLANS ON FINANCIAL CONDITION
Pension ABO to Total Assets
8.4%
7.8%
11.3%
#VALUE!
#VALUE!
Pension PBO to Total Assets
8.0%
9.0%
11.2%
#VALUE!
#VALUE!
Retirement PBO to Total Assets
0.4%
0.5%
0.6%
#VALUE!
#VALUE!
RETIREMENT FUNDING RATIOS
FMV of Pension Assets to Pension ABO
98.1%
114.6%
94.3%
#VALUE!
#VALUE!
FMV of Pension Assets to Pension PBO
103.0%
99.9%
95.3%
#VALUE!
#VALUE!
FMV of Retirement Benefit Assets to Retirement PBO
918.5%
807.4%
756.0%
#VALUE!
#VALUE!
Pension Contribution Ratio
50.5%
64.1%
57.0%
#VALUE!
#VALUE!
Retirement Contribution Ratio
30.0%
33.8%
23.1%
#VALUE!
#VALUE!
© 2008 William R. Pasewark
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
ANALYSIS OF COMPENSATION PLANS
Target Corp
Nordstorm
Current Year
Prior Year
3 Years Ago
Current Year
Prior Year
Revenue
106,005
92,400
78,112
14,402
10,357
Shares Outstanding
488,000
500,600
510,900
157
156
Market Price at Year End
231.44
176.53
124.76
5.27
4.22
Stock Option Plan Stock Option Plan Expense
504
517
541
52
53
Shares Obtained by Options Exercised this Year
800
2,300
7,300
0
11
Shares Obtainable from:
Options Granted this Year
1,447
3,815
2,455
N/A
N/A
Exercisable Options
1,100
620
782
N/A
N/A
Outstanding Options
4,316
3,575
3,124
N/A
N/A
Average Exercise Price of Exercisable Options
58.17
55.81
48.15
N/A
N/A
Average Exercise Price of Outstanding Options
186.89
110.80
80.01
N/A
N/A
Stock Award Plan Stock Award Plan Expense
504
517
541
n/a
n/a
Shares Obtained by Awards Vested this Year
800
2,300
7,300
n/a
n/a
Shares Obtainable from:
Awards Issued (Granted) this Year
1,447
3,815
2,455
n/a
n/a
Outstanding (Non-vested) Awards
4,316
3,575
3,124
n/a
n/a
Stock Purchase Plan
Stock Purchase Plan Expense
504
517
541
n/a
n/a
POTENTIAL DILUTION RATIOS
As a Percentage of Shares Outstanding
OPTIONS - Granted this Year
0.3%
0.8%
0.5%
#VALUE!
#VALUE!
OPTIONS - Exercisable 0.2%
0.1%
0.2%
#VALUE!
#VALUE!
OPTIONS - Oustanding 0.9%
0.7%
0.6%
#VALUE!
#VALUE!
AWARDS - Net Issued
0.3%
0.8%
0.5%
#VALUE!
#VALUE!
AWARDS - Outstanding 0.9%
0.7%
0.6%
#VALUE!
#VALUE!
OPTIONS AND AWARDS - Outstanding
1.8%
1.4%
1.2%
#VALUE!
#VALUE!
ACTUAL DILUTION RATIOS
As a Percentage of Shares Outstanding
OPTIONS - Net Exercised 0.2%
0.5%
1.4%
0.0%
7.1%
AWARDS - Net Vested 0.2%
0.5%
1.4%
#VALUE!
#VALUE!
ALL PLANS - Share Increase this Year
0.3%
0.9%
2.9%
#VALUE!
#VALUE!
IMPACT ON EARNINGS RATIOS
OPTIONS - Expense to Revenue
0.5%
0.6%
0.7%
0.4%
0.5%
AWARDS - Expense to Revenue
0.5%
0.6%
0.7%
#VALUE!
#VALUE!
PURCHASE - Expense to Revenue
0.5%
0.6%
0.7%
#VALUE!
#VALUE!
ALL PLANS - Expense to Revenue
1.4%
1.7%
2.1%
#VALUE!
#VALUE!
BENEFIT TO PLAN PARTICIPANTS RATIOS
As a Percent of Year End Stock Price
OPTIONS - Price of Exercisable 25.1%
31.6%
38.6%
#VALUE!
#VALUE!
OPTIONS - Price of Outstanding 80.8%
62.8%
64.1%
#VALUE!
#VALUE!
© 2008 William R. Pasewark
ANALYSIS OF OPERATING LEASES
Target Corp
Average Borrowing Rate: 3.6%
Operating Lease PV PV of
Year
Payment
Factor
Payment
Increase
1
Current Year
185
0.96525
179
2
Next Year
226
0.93171
211
22.2%
3
Current Year + 2
411
0.89933
370
81.9%
4
Current Year + 3
596
0.86808
517
45.0%
5
Current Year + 4
781
0.83792
654
Average
31.0%
7
Current Year + 5
1,023
0.78070
799
increase
45.0%
8
Current Year + 6
1,341
0.75357
1,011
9
Current Year + 7
1,757
0.72738
1,278
10
Current Year + 8
2,303
0.70211
1,617
11
Current Year + 9
376
0.58831
221
Total minimum lease pmts
9,000
6,857
Total Liabilities
40,984
Total Stockholders' Equity
12,827
Income from Continuing Operations
6,946
Total Assets
53,811
Adjusted for Capitalized Operating Leases
Total Liabilites
47,841
Total Assets
60,668
RATIOS PRIOR TO CAPITALIZING OPERATING LEASES
Debt to Equity
3
Return on Assets
0
RATIOS ADJUSTED FOR CAPITALIZED OPERATING LEASES
Debt to Equity
4
Return on Assets
0
© 2008 William R. Pasewark
Percentag
e
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 Documents
Related Questions
Copp
arrow_forward
Problem 17-2A (Algo) Ratios, common-size statements, and trend percents LO P1,
[The following information applies to the questions displayed below.]
Selected comparative financial statements of Korbin Company follow.
KORBIN COMPANY
Comparative Income Statements.
For Years Ended December 31
2021
Sales:
Cost of goods sold
Gross profit
Selling expenses
Administrative expenses
Total expenses
Income before taxes
Income tax expense
Net income
Assets
Current assets
2020
$436,580 $ 334,456
262,821
173,759
61,994
39,292
Long-term investments
Plant assets, net
Total assets
KORBIN COMPANY
Comparative Balance Sheets
December 31
Liabilities and Equity
Current liabilities
Common stock
Other paid-in capital
Retained earnings
Total liabilities and equity
212,045
122,411
46, 155
101,286
72,473
13,480
$ 58,993 $ 37,225
29,432
75,587
46,824
9,599
2021
$ 54,789
0
100, 200
$154,989
$ 22,628
72,000
9,000
51,361
2019
$ 232,100
148,544
83,556
30,637
19,264
49,901
33,655
6,832
$ 26,823
2020
$36,670
900
91,178…
arrow_forward
please explain the result of income statement that provided in image below
arrow_forward
Computing and analyzing trend percents LO P1 2021 2020 2019 2018 2017 Sales $ 446,122 $ 293,501 $ 242,563 $ 173,880 $ 128,800 Cost of goods sold 221,100 145,365 122,206 87,101 63,112 Accounts receivable 21,592 17,140 16,664 10,137 8,784 Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable.
arrow_forward
Calculate net profit margin of the year 2019 and 2020
arrow_forward
Precision Tools
2021 Income Statement
Net sales
Less: Cost of goods sold
Less: Depreciation
Earnings before interest and taxes
Less: Interest paid
$36,408
28,225
1,760
6,423
510
5,913
Taxable Income
Less: Taxes
2.070
$3.843
Net Income
Precision Tools 2020 and 2021 Balance Sheets
2020
2021
2020
2021
$
Cash
2,060
1,003
Accounts
7,250
8,384
payable
Accounts
3,411
4,218
receivable
21.908
27,129
Inventory
18,776
24,247
17,500
3.825
Common stock
Retained
earnings
Total liability &
15,000
Net fixed assets
14,160
14.080
6.357
Total assets
38.407
41,209
38,407
41,209
equity
What is the times interest earned ratio for 2021?
arrow_forward
Required information
Problem 13-2A (Algo) Ratios, common-size statements, and trend percents LO P1, P2, P3
(The following information applies to the questions displayed below.]
Selected comparative financial statements of Korbin Company follow.
KORBIN COMPANY
Comparative Income Statements
For Years Ended December 31
2021
2020
2019
Sales
$ 442,035
$ 338,635
212,324
126, 311
$ 235,000
Cost of goods sold
Gross profit
Selling expenses
Administrative expenses
Total expenses
Income before taxes
266, 105
150,400
175,930
62,769
39,783
102,552
73,378
13,648
$ 59,730
84,600
31,020
46,732
29,800
76,532
49,779
19,505
50,525
34,075
Income tax expense
10, 205
6,917
Net income
$ 39,574
$ 27,158
KORBIN COMPANY
Comparative Balance Sheets
December 31
2021
2020
2019
Assets
Current assets
$ 55,578
$ 37, 199
$ 49,726
Long-term investments
Plant assets, net
900
4,570
56,095
104,820
$ 160,398
95,143
Total assets
$ 133, 242
$ 110,391
Liabilities and Equity
Current liabilities
$ 19,853
$ 23,418
68,000
8,500…
arrow_forward
Sales
Cost of goods sold
Gross profit
Operating expenses
Income from operations
Interest expense
Income before income tax
Income tax expense
Net income
(a)
2021
$1,595
900
695
524
171
80
Your answer is incorrect.
91
25
$66
2020
$1,387 $1,208
743
644
411
233
50
183
2019
46
596
612
402
210
40
170
43
$137 $127
Using horizontal analysis, calculate the horizontal percentage of a base-year amount, assuming 2019 is the base year. (Round
answers to 1 decimal place, e.g. 5.2%. Enter negative amounts using either a negative sign preceding the number e.g.
-45.1% or parentheses e.g. (45.1) %.)
arrow_forward
!
Required information
Problem 13-2A (Algo) Ratios, common-size statements, and trend percents LO P1, P2, P3
[The following information applies to the questions displayed below.]
Selected comparative financial statements of Korbin Company follow.
KORBIN COMPANY
Comparative Income Statements
For Years Ended December 31
2021
2019
$ 279,900
179, 136
Sales
Cost of goods sold
$ 526,492
316,948
2020
$ 403,336
252,892
Gross profit
209,544
150,444
100,764
Selling expenses
74,762
55,660
36,947
Administrative expenses
47,384
35,494
23,232
Total expenses
122,146
91,154
60,179
Income before taxes
87,398
59,290
40,585
Income tax expense
16,256
12,155
8,239
Net income
$ 71,142
$ 47,135
$ 32,346
KORBIN COMPANY
Comparative Balance Sheets
December 31
Assets
Current assets
Long-term investments
Plant assets, net
Current liabilities
Total assets
Liabilities and Equity
Common stock
Other paid-in capital
Retained earnings
8,750
66,994
2021
2020
$ 60,926
0
109,735
$ 40,778
1,000
99,989
$ 170,661
$ 141,767
$…
arrow_forward
please answer do not image format
arrow_forward
Problem 1:
Comparative income statements for 2020 and 2019 follow.
Sales
Cost of Sales
Gross Profit
Operating Expenses
Operating Income
Interest Expense
Earnings Before Tax
Income Taxes
Net Income
2020
$9,434,000
7,075,400
$2,358,600 $2,201,360
1,367,690
1,365,060
$ 990,910 $836,300
157,500
126,000
$ 833,410 $
710,300
400,000
317,200
$ 433,410 $ 393,100
2019
$7,862,000
5,660,640
Required:
4
a. Prepare a vertical common-size analysis of this statement for each year, using sales as
the base.
b. Comment briefly on the changes between the two years, based on the vertical
common-size statement.
arrow_forward
Problem 13-2A (Algo) Ratios, common-size statements, and trend percents LO P1, P2, P3
[The following information applies to the questions displayed below]
Selected comparative financial statements of Korbin Company follow.
KORBIN COMPANY
Comparative Income Statements
For Years Ended December 31
2021
2020
2019
Sales
Cost of goods sold
$ 402,346 $ 308,230
242,212
$ 213,900
194,493
136,896
Gross profit
160,134
113,737
77,004
Selling expenses
57,133
42,536
28,235
Administrative expenses
36,211
27,124
17,754
Total expenses
93,344
69,660
45,989
Income before taxes
Income tax expense
66,790
44,077
31,015
12,423
9,036
6,296
Net income
$ 54,367
$ 35,041
$ 24,719
KORBIN COMPANY
Comparative Balance Sheets
December 31
Assets
Current assets
Long-term investments
Plant assets, net
Total assets
Current liabilities
Liabilities and Equity
Common stock
Other paid-in capital
Retained earnings
Total liabilities and equity
$ 180,932
2021
$ 63,959
116,973
0
2020
$ 42,808
800
106,691
$ 180,932
$ 150,299
$…
arrow_forward
Net Sales
COGS
Depreciation
EBIT
Interest
Taxable Income
Taxes
Net Income
2019 Income Statement
Dividends
Additions to Retained Earnings
147
647.74
3,456
1,895
235
1,326
320
1,006
211.26
794.74
arrow_forward
Assignment
COMPARATIVE STATEMENTS
Sikat Manufacturing Corporation
Income Statement
For the year ended Dec. 31, 2020 and 202019
2020
2019
P 5,150,000
-150,000
5,000,000
3,200,000
1,800,000
Sales
4,250,000
na 250.000
4,000,000
2.600,000
1,400,000
Less: Sales Returns and Allowances
Net Sales
Less: Cost of Sales
Gross Profit
Less: Operating Expenses
Selling Expenses
General and Administrative Expenses
Total Operating Expenses
Operating Income
Less: Interest expense
Net Income before tax
Less: Income tax.(32% )
Net Income
720,000
780,000
1,500,000
300,000
60,000
240,000
76,800
P 163.200
600,000
600,000
1,200,000
200,000
40,000
160,000
51,200
P 108,800
Sikat Manufacturing Corporation
Balance Sheet
Dec. 31, 2020 and 2019
2020
2019
ASSETS
P 225,000
150,000
240,000
260,000
120,000
150,000
70,000
550,000
P1.765.000 P 1,520,000
Cash
P140.000
125,000
180,000
160,000
145,000
170,000
80,000
520,000
Marketable Securities
Accounts Receivable
Inventories: Finished Goods
Work-in-Process
Raw Materials…
arrow_forward
please help me solve
arrow_forward
ni1
arrow_forward
interpret and analyze the ratios
arrow_forward
Vertical analysis (common-size) percentages for Cullumber Company’s sales revenue, cost of goods sold, and expenses are listed here.
Vertical Analysis
2022
2021
2020
Sales revenue
100.0
%
100.0
%
100.0
%
Cost of goods sold
60.0
64.2
65.6
Expenses
24.7
27.1
29.5
Calculate Cullumber’s net income as a percent of sales. (Round answers to 1 decimal place, e.g. 5.2.)
2022
2021
2020
Net income
Enter percentages rounded to 1 decimal place.
Enter percentages rounded to 1 decimal place.
Enter percentages rounded to 1 decimal place.
Did Cullumber’s net income as a percent of sales increase, decrease, or remain unchanged over the 3-year period?
Cullumber’s net income as a percent of sales
Choose the correct answer increaseddecreasedremained unchanged
arrow_forward
C1
arrow_forward
jDL Coroproation Selected Financial Data as at december 21,2016
Current asset 2,50,000$
Current Liabilities 1,50,000$
Inventories 60,000$
Accounts Receivable 45,000$
Revenue 9,50,000$
Cost of Good Sold 6,75,000$
Note: Ignore averaging for this question
JDL's Quick ratio is:
1
0.8
2.45
1.27
JDL's average collection period is:
8 days
11 days
17 days
20 days
JDL's inventory turnover is:
9.50 times
11.25 times
4.50 times
5.43 times
JDL's receivables turnover is:
24.34 times
22.56 times
21.11 times
20.11 times
arrow_forward
rr
arrow_forward
Abhaliya
arrow_forward
B. Below is the Statement of Comprehensive Income of Q & A Trading Company:
Percentage
2020
P1,939,500
900,000
1,039,500
445,500
37,575
P 556,425
2019
Percentage
Revenue
Cost of Goods Sold
Gross Profit
Selling and General Experses
Other Experses
Net Income
P1,674,675
843,975
830,700
409,725
30,825
P 390,150
Requirements:
Prepare a vertical aralysis for Q & A Trading Compary.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Related Questions
- Copparrow_forwardProblem 17-2A (Algo) Ratios, common-size statements, and trend percents LO P1, [The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements. For Years Ended December 31 2021 Sales: Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes Income tax expense Net income Assets Current assets 2020 $436,580 $ 334,456 262,821 173,759 61,994 39,292 Long-term investments Plant assets, net Total assets KORBIN COMPANY Comparative Balance Sheets December 31 Liabilities and Equity Current liabilities Common stock Other paid-in capital Retained earnings Total liabilities and equity 212,045 122,411 46, 155 101,286 72,473 13,480 $ 58,993 $ 37,225 29,432 75,587 46,824 9,599 2021 $ 54,789 0 100, 200 $154,989 $ 22,628 72,000 9,000 51,361 2019 $ 232,100 148,544 83,556 30,637 19,264 49,901 33,655 6,832 $ 26,823 2020 $36,670 900 91,178…arrow_forwardplease explain the result of income statement that provided in image belowarrow_forward
- Computing and analyzing trend percents LO P1 2021 2020 2019 2018 2017 Sales $ 446,122 $ 293,501 $ 242,563 $ 173,880 $ 128,800 Cost of goods sold 221,100 145,365 122,206 87,101 63,112 Accounts receivable 21,592 17,140 16,664 10,137 8,784 Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable.arrow_forwardCalculate net profit margin of the year 2019 and 2020arrow_forwardPrecision Tools 2021 Income Statement Net sales Less: Cost of goods sold Less: Depreciation Earnings before interest and taxes Less: Interest paid $36,408 28,225 1,760 6,423 510 5,913 Taxable Income Less: Taxes 2.070 $3.843 Net Income Precision Tools 2020 and 2021 Balance Sheets 2020 2021 2020 2021 $ Cash 2,060 1,003 Accounts 7,250 8,384 payable Accounts 3,411 4,218 receivable 21.908 27,129 Inventory 18,776 24,247 17,500 3.825 Common stock Retained earnings Total liability & 15,000 Net fixed assets 14,160 14.080 6.357 Total assets 38.407 41,209 38,407 41,209 equity What is the times interest earned ratio for 2021?arrow_forward
- Required information Problem 13-2A (Algo) Ratios, common-size statements, and trend percents LO P1, P2, P3 (The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended December 31 2021 2020 2019 Sales $ 442,035 $ 338,635 212,324 126, 311 $ 235,000 Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes 266, 105 150,400 175,930 62,769 39,783 102,552 73,378 13,648 $ 59,730 84,600 31,020 46,732 29,800 76,532 49,779 19,505 50,525 34,075 Income tax expense 10, 205 6,917 Net income $ 39,574 $ 27,158 KORBIN COMPANY Comparative Balance Sheets December 31 2021 2020 2019 Assets Current assets $ 55,578 $ 37, 199 $ 49,726 Long-term investments Plant assets, net 900 4,570 56,095 104,820 $ 160,398 95,143 Total assets $ 133, 242 $ 110,391 Liabilities and Equity Current liabilities $ 19,853 $ 23,418 68,000 8,500…arrow_forwardSales Cost of goods sold Gross profit Operating expenses Income from operations Interest expense Income before income tax Income tax expense Net income (a) 2021 $1,595 900 695 524 171 80 Your answer is incorrect. 91 25 $66 2020 $1,387 $1,208 743 644 411 233 50 183 2019 46 596 612 402 210 40 170 43 $137 $127 Using horizontal analysis, calculate the horizontal percentage of a base-year amount, assuming 2019 is the base year. (Round answers to 1 decimal place, e.g. 5.2%. Enter negative amounts using either a negative sign preceding the number e.g. -45.1% or parentheses e.g. (45.1) %.)arrow_forward! Required information Problem 13-2A (Algo) Ratios, common-size statements, and trend percents LO P1, P2, P3 [The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended December 31 2021 2019 $ 279,900 179, 136 Sales Cost of goods sold $ 526,492 316,948 2020 $ 403,336 252,892 Gross profit 209,544 150,444 100,764 Selling expenses 74,762 55,660 36,947 Administrative expenses 47,384 35,494 23,232 Total expenses 122,146 91,154 60,179 Income before taxes 87,398 59,290 40,585 Income tax expense 16,256 12,155 8,239 Net income $ 71,142 $ 47,135 $ 32,346 KORBIN COMPANY Comparative Balance Sheets December 31 Assets Current assets Long-term investments Plant assets, net Current liabilities Total assets Liabilities and Equity Common stock Other paid-in capital Retained earnings 8,750 66,994 2021 2020 $ 60,926 0 109,735 $ 40,778 1,000 99,989 $ 170,661 $ 141,767 $…arrow_forward
- please answer do not image formatarrow_forwardProblem 1: Comparative income statements for 2020 and 2019 follow. Sales Cost of Sales Gross Profit Operating Expenses Operating Income Interest Expense Earnings Before Tax Income Taxes Net Income 2020 $9,434,000 7,075,400 $2,358,600 $2,201,360 1,367,690 1,365,060 $ 990,910 $836,300 157,500 126,000 $ 833,410 $ 710,300 400,000 317,200 $ 433,410 $ 393,100 2019 $7,862,000 5,660,640 Required: 4 a. Prepare a vertical common-size analysis of this statement for each year, using sales as the base. b. Comment briefly on the changes between the two years, based on the vertical common-size statement.arrow_forwardProblem 13-2A (Algo) Ratios, common-size statements, and trend percents LO P1, P2, P3 [The following information applies to the questions displayed below] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended December 31 2021 2020 2019 Sales Cost of goods sold $ 402,346 $ 308,230 242,212 $ 213,900 194,493 136,896 Gross profit 160,134 113,737 77,004 Selling expenses 57,133 42,536 28,235 Administrative expenses 36,211 27,124 17,754 Total expenses 93,344 69,660 45,989 Income before taxes Income tax expense 66,790 44,077 31,015 12,423 9,036 6,296 Net income $ 54,367 $ 35,041 $ 24,719 KORBIN COMPANY Comparative Balance Sheets December 31 Assets Current assets Long-term investments Plant assets, net Total assets Current liabilities Liabilities and Equity Common stock Other paid-in capital Retained earnings Total liabilities and equity $ 180,932 2021 $ 63,959 116,973 0 2020 $ 42,808 800 106,691 $ 180,932 $ 150,299 $…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning

Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning