Burrows C Analysis
xls
keyboard_arrow_up
School
University of California, Los Angeles *
*We aren’t endorsed by this school
Course
231E
Subject
Finance
Date
Nov 24, 2024
Type
xls
Pages
6
Uploaded by leedevin
1980-1981
Source/
(Use)
BALANCE SHEET
Cash
154.0
Accounts Receivable
311.0
Note Payable, Curr. Port. Lease
22.0
Accounts Payable
424.0
LT Debt
150.0
Deferred Taxes
78.0
Common Stock
1.0
Income
16.0
1,156.0
Inventory
(256.0)
Prepaid Expenses and other
(219.0)
Fixed Assets, net
(334.0)
Other Assets
(13.0)
Accrued Liabilities
(51.0)
Taxes Payable
(241.0)
LT Capital Lease
(1.0)
Preferred Stock
(9.0)
Additional Paid-in Capital, net of T-stock
(32.0)
(1,156.0)
BURROWS B
Page 2
Burrows A
REAL
EXPECTED
INCOME STATEMENT
1/31/1970
1/31/1971
###
###
###
###
###
###
###
1970
1971
1972
1973
1974
1975
1976
1977
1978
Total Sales
4,235
4,231
4,422
5,207
5,967
6,990
7,945
9,115
10,165
Cost of Goods Sold
3,222
3,266
3,426
2,977
3,341
3,914
4,449
5,104
5,692
Gross Margin
1,013
965
996
2,230
2,626
3,076
3,496
4,011
4,473
Expenses
913
869
908
1,950
2,296
2,666
2,946
3,231
3,543
Income Before Income Taxes
100
96
88
280
330
410
550
780
930
Income Taxes (50%)
-
-
-
140
165
205
275
390
465
Net Income
100
96
88
140
165
205
275
390
465
BALANCE SHEET
###
2/3/1973
###
###
###
###
###
Cash
14
14
678
819
1,162
1,578
2,036
Accounts Receivable
100
3
-
-
-
100
200
Inventory
1,412
1,363
1,310
1,540
1,683
1,800
2,000
Prepaid Expenses
23
-
-
-
-
-
-
Current Assets
1,549
1,380
1,988
2,359
2,845
3,478
4,236
Fixtures and Equipment
627
665
870
1,044
1,154
1,264
1,374
Less Res. for Depreciation
-
(470)
(542)
(629)
(733)
(859)
(996)
Leasehold Improvements
293
320
320
320
320
320
320
Less Res. for Depreciation
-
(250)
(250)
(250)
(250)
(250)
(250)
Lease Valuation
-
50
50
50
50
50
50
Less Res. for Depreciation
(712)
-
(8)
(16)
(24)
(32)
(40)
Fixed Assets, net
208
315
440
519
517
493
458
Other Assets
22
30
40
50
60
70
80
Total Assets
1,779
1,725
2,468
2,928
3,422
4,041
4,774
Accounts Payable
233
36
350
650
750
850
1,000
Accrued Liabilities
112
131
230
300
400
500
600
Taxes Payable
2
-
165
50
69
98
116
Current Debt
347
167
745
1,000
1,219
1,448
1,716
Senior Subordinated Note
1,432
1,000
1,000
1,000
1,000
1,000
1,000
Total Debt
1,779
1,167
1,745
2,000
2,219
2,448
2,716
Preferred Stock
-
248
248
248
248
248
248
Common Stock
-
13
13
13
13
13
13
Paid-in Surplus
-
297
297
297
297
297
297
Retained Earnings
-
-
165
370
645
1,035
1,500
Total Equity
-
558
723
928
1,203
1,593
2,058
Total Debt and Equity
1,779
1,725
2,468
2,928
3,422
4,041
4,774
-
-
-
-
-
-
-
BURROWS B
Page 3
Burrows B
HIGBEE
BURROWS
INCOME STATEMENT
###
###
###
###
###
###
###
###
2/2/1980
###
1972
1973
1974
1975
1976
1977
1978
1979
1980
1981
Total Sales
4,422
5,169
5,671
6,365
6,960
7,982
9,617
11,735
13,730
13,777
Cost of Goods Sold
3,455
4,007
3,285
3,699
3,864
4,338
5,300
6,308
7,634
7,673
Gross Margin
967
1,162
2,386
2,666
3,096
3,644
4,317
5,427
6,096
6,104
Operating & SG&A
908
1,050
2,119
2,361
2,695
3,140
3,688
4,620
5,626
6,171
Interest expense
73
108
73
75
86
113
224
282
Income Before Income Taxes
59
112
194
197
328
429
543
694
246
(349)
Income Taxes (50%)
-
-
93
88
147
192
222
275
68
(186)
Net Income
59
112
101
109
181
237
321
419
178
(163)
BALANCE SHEET
###
2/3/1973
2/1/1974
2/1/1975
###
###
###
2/3/1979 2/2/1980
###
Cash
14
15
517
140
185
153
169
215
86
61
Accounts Receivable
4
91
206
277
283
271
354
523
225
212
Inventory
1,412
1,514
1,610
1,588
1,765
2,205
2,060
2,901
2,959
3,157
Prepaid Expenses and other
71
61
53
80
95
101
112
163
184
382
Current Assets
1,501
1,681
2,386
2,085
2,328
2,730
2,695
3,802
3,454
3,812
Fixtures and Equipment
627
680
285
408
524
691
883
1,115
1,250
1,334
Leasehold Improvements
293
321
186
206
225
310
402
482
771
863
Vehicles
-
-
-
-
11
16
30
53
66
66
Less Res. for Depreciation
(711)
(720)
(47)
(106)
(178)
(266)
(381)
(527)
(610)
(806)
Fixed Assets, net
209
281
424
508
582
751
934
1,123
1,477
1,457
Other Assets
22
14
36
39
41
43
49
177
267
190
Total Assets
1,732
1,976
2,846
2,632
2,951
3,524
3,678
5,102
5,198
5,459
Note Payable, Curr. Port. Lease
-
-
290
-
-
-
-
15
36
37
Accounts Payable
182
344
780
828
722
928
780
1,367
1,247
1,791
Accrued Liabilities
110
88
280
201
258
313
374
408
308
357
Taxes Payable
51
47
77
61
175
228
221
282
85
41
Current Debt
343
479
1,427
1,090
1,155
1,469
1,375
2,072
1,676
2,226
LT Debt
1,389
1,497
750
750
800
800
700
900
1,100
1,050
LT Capital Lease
-
-
-
-
-
-
-
56
96
55
Deferred Taxes
-
-
10
23
46
68
95
139
202
217
Total Debt
1,732
1,976
2,187
1,863
2,001
2,337
2,170
3,167
3,074
3,548
Preferred Stock
-
-
248
248
248
248
248
248
248
239
Common Stock
-
-
13
13
13
13
13
14
14
15
Additional Paid-in Capital, net of T-stock
-
-
297
297
297
297
297
304
315
272
Retained Earnings
-
-
101
211
392
629
950
1,369
1,547
1,385
Total Equity
-
-
659
769
950
1,187
1,508
1,935
2,124
1,911
Total Debt and Equity
1,732
1,976
2,846
2,632
2,951
3,524
3,678
5,102
5,198
5,459
-
-
-
-
-
-
-
-
-
-
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
BURROWS B
Page 4
RATIO ANALYSIS
Operational
(1970)
1972
1973
1974
1975
1976
1977
1978
1979
1980
1981
Sales Growth
Burrows A
-0.1%
4.5%
17.8%
14.6%
17.1%
13.7%
14.7%
11.5%
Burrows B
16.9%
9.7%
12.2%
9.3%
14.7%
20.5%
22.0%
17.0%
0.3%
COGS/Sales
Burrows A
77.2%
77.5%
57.2%
56.0%
56.0%
56.0%
56.0%
56.0%
Burrows B
78.1%
77.5%
57.9%
58.1%
55.5%
54.3%
55.1%
53.8%
55.6%
55.7%
Gross Margin
Burrows A
22.8%
22.5%
42.8%
44.0%
44.0%
44.0%
44.0%
44.0%
Burrows B
21.9%
22.5%
42.1%
41.9%
44.5%
45.7%
44.9%
46.2%
44.4%
44.3%
Expenses/Sales
Burrows A
20.5%
20.5%
37.4%
38.5%
38.1%
37.1%
35.4%
34.9%
Burrows B
20.5%
20.3%
37.4%
37.1%
38.7%
39.3%
38.3%
39.4%
41.0%
44.8%
EBIT Margin
Burrows A
2.3%
2.0%
5.4%
5.5%
5.9%
6.9%
8.6%
9.1%
Burrows B
1.3%
2.2%
3.4%
3.1%
4.7%
5.4%
5.6%
5.9%
1.8%
-2.5%
Net Profit Margin
Burrows A
2.7%
2.8%
2.9%
3.5%
4.3%
4.6%
Burrows B
1.8%
1.7%
2.6%
3.0%
3.3%
3.6%
1.3%
-1.2%
Activity
(1970)
1972
1973
1974
1975
1976
1977
1978
1979
1980
1981
Collection Days
Burrows A
8
0
-
-
-
4
7
Burrows B
0
6
13
16
15
12
13
16
6
6
Inventory Turnover
Burrows A
2.4
2.2
2.6
2.5
2.6
2.8
2.8
Burrows B
2.4
2.6
2.0
2.3
2.2
2.0
2.6
2.2
2.6
2.4
Inventory Days
Burrows A
150
167
143
144
138
129
128
Burrows B
149
138
179
157
167
186
142
168
141
150
Asset Turnover
Burrows A
2.5
3.0
2.4
2.4
2.3
2.3
2.1
Burrows B
2.6
2.6
2.0
2.4
2.4
2.3
2.6
2.3
2.6
2.5
Payable Days
Burrows A
37
20
63
89
94
97
103
(Acc. Pay + Accr. Liab.)
Burrows B
31
39
118
102
93
104
79
103
74
102
Leverage
1971
1972
1973
1974
1975
1976
1977
1978
1979
1980
1981
Current Ratio
Burrows A
4.5
8.3
2.7
2.4
2.3
2.4
2.5
Burrows B
4.4
3.5
1.7
1.9
2.0
1.9
2.0
1.8
2.1
1.7
Acid Test
Burrows A
0.3
0.1
0.9
0.8
1.0
1.2
1.3
Burrows B
0.1
0.2
0.5
0.4
0.4
0.3
0.4
0.4
0.2
0.1
BURROWS B
Page 5
Current Debt/Total Debt
Burrows A
20%
14%
43%
50%
55%
59%
63%
Burrows B
20%
24%
65%
59%
58%
63%
63%
65%
55%
63%
Debt/Equity
Burrows A
2.1
2.4
2.2
1.8
1.5
1.3
Burrows B
3.3
2.4
2.1
2.0
1.4
1.6
1.4
1.9
Debt/Assets
Burrows A
100%
68%
71%
68%
65%
61%
57%
Burrows B
100%
100%
77%
71%
68%
66%
59%
62%
59%
65%
Profitability
1971
1972
1973
1974
1975
1976
1977
1978
1979
1980
1981
Return on Assets
Burrows A
8.1%
6.7%
7.0%
8.0%
9.7%
9.7%
Burrows B
3.5%
4.1%
6.1%
6.7%
8.7%
8.2%
3.4%
-3.0%
Return on Equity
Burrows A
25.1%
22.8%
22.1%
22.9%
24.5%
22.6%
Burrows B
15.3%
14.2%
19.1%
20.0%
21.3%
21.7%
8.4%
-8.5%
BURROWS B
Page 6
CASH FLOW ANALYSIS
Burrows A
1972
1973
1974
1975
1976
1977
1978
1979
1980
1981
Net Income
165
205
275
390
465
Depreciation
80
95
112
134
145
Changes in Current Assets
Changes in Current Liabilities
Changes in Fixed and Other Assets
Net Operational Cash Flows
245
300
387
524
610
Burrows B
1972
1973
1974
1975
1976
1977
1978
1979
1980
1981
Net Income
101
109
181
237
321
419
178
(163)
Interest
73
108
73
75
85
86
224
282
Capex
530
(143)
(146)
(257)
(298)
(335)
(437)
(176)
Depreciation
(673)
59
72
88
115
146
83
196
Changes in working capital
270
(292)
(141)
(52)
(486)
128
235
Net Operational Cash Flows
31
403
(112)
2
171
(170)
176
374
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
Category
Prior Year Current Year
Accounts payable
???
Accounts receivable
320,715
397,400
Accruals
40,500
33,750
Additional paid in capital
500,000
541,650
Cash
17,500
47,500
Common Stock
94,000 105,000
COGS
328,500 431,516.41
Current portion long-term debt
33,750
35,000
Depreciation expense
54,000
55,946.66
Interest expense
40,500 41,874.31
Inventories
279,000
288,000
Long-term debt
336,467.85 401,942.46
Net fixed assets
946,535
999,000
Notes payable
148,500
162,000
Operating expenses (excl. depr.) 126,000
161,499.58
Retained earnings
306,000
342,000
Sales
639,000 854,554.01
Taxes
24,750 48,384.56
???
What is the current year's return on equity (ROE)?
Submit
Answer format: Percentage Round to: 2 decimal places (Example: 9.24%, % sign re
rounded to 4 decimal places (ex: 0.0924))
arrow_forward
Balance Sheet Income Statement ($ in millions) ($ in millions)
Assets LIABILITIES Cash & Marketable Securities 449.90 Accounts Payable 1,611.20 Revenue 28,681.10
Accounts Receivable 954.80 Salaries Payable 225.20 Cost Of Goods Sold 20,768.80 Inventories 3,645.20 Other Current Liabilities 1,118.80 Gross Profit 7,912.30 Other Current Assets 116.60 Total…
arrow_forward
Category
Prior Year
Current Year
Accounts payable
???
???
Accounts receivable
320,715
397,400
Accruals
40,500
33,750
Additional paid in capital
500,000
541,650
Cash
17,500
47,500
Common Stock
94,000
105,000
COGS
328,500
428,571.00
Current portion long-term debt
33,750
35,000
Depreciation expense
54,000
54,035.00
Interest expense
40,500
42,155.00
Inventories
279,000
288,000
Long-term debt
339,577.00
401,377.00
Net fixed assets
946,535
999,000
Notes payable
148,500
162,000
Operating expenses (excl. depr.)
126,000
162,171.00
Retained earnings
306,000
342,000
Sales
639,000
849,094.00
Taxes
24,750
47,192.00
What is the current year's entry for long-term debt on a common-sized balance sheet?
(ROUND TO 4 DECIMAL PLACES.)
arrow_forward
Category
Prior Year
Current Year
Accounts payable
???
???
Accounts receivable
320,715
397,400
Accruals
40,500
33,750
Additional paid in capital
500,000
541,650
Cash
17,500
47,500
Common Stock
94,000
105,000
COGS
328,500
431,139.00
Current portion long-term debt
33,750
35,000
Depreciation expense
54,000
54,349.00
Interest expense
40,500
41,741.00
Inventories
279,000
288,000
Long-term debt
337,728.00
398,725.00
Net fixed assets
946,535
999,000
Notes payable
148,500
162,000
Operating expenses (excl. depr.)
126,000
162,280.00
Retained earnings
306,000
342,000
Sales
639,000
847,106.00
Taxes
24,750
48,618.00
What is the current year's return on assets (ROA)?
(Round to 4 decimal places.)
arrow_forward
($ in 000s)
Cash and cash equivalents
$247,286
Short-term investments
362,700
Accounts receivable
513,944
Inventory
468,738
Prepaid expenses (current)
92,259
Total current assets
1,684,927
Long-term receivables
119,800
Equipment (net)
Total assets
Notes payable (current)
40,116
Accounts payable
41,072
Accrued liabilities
430,772
Other current liabilities
190,604
Total current liabilities
702,564
Long-term debt
343,576
Total liabilities
1,046,140
Common stock
460,627
Retained earnings
1,000,000
1. Find Equipment (net)
2. Find Total Assests
arrow_forward
Balance sheet ($ in millions)
ASSETS
Cash & Marketable Securities
449.90
Accounts Receivable
954.80
Inventories
3,645.20
Other Current Assets
116.60
Total Current Assets
5,166.50
Machinery & Equipment
1,688.90
Land
1,129.70
Buildings
2,348.40
Depreciation
(575.60)
Property, Plant & Equip. - Net
4,591.40
Other Long Term Assets
120.90
Total Long-Term Assets
4,712.30
Total Assets
9,878.80
part of Balance Sheet
LIABILITIES
Accounts Payable
1,611.20
Salaries Payable
225.20
Other Current Liabilities
1,118.80
Total Current Liabilities
2,955.20
Other Liabilities
693.40
Total Liabilities
3,648.60
SHAREHOLDER'S EQUITY
Common Stock
828.50
Retained Earnings
5,401.70
Total Shareholder's Equity
6,230.20
Total Liabilities…
arrow_forward
Take a look at this balance sheet and income statement:
Balance Sheet (all numbers are in $ millions unless stated otherwise)
Current Assets Current Liabilities
Cash 98 Accounts Payable 344
A/C Receivable 188 Notes Payable 196
Inventory 422
Total 708 Total 540
Fixed Assets Long-Term Liabilities
Net PPE 2880 Long-Term Debt 457
Common Stock and Paid-In Surplus 550
Retained Earnings 2041
Total Assets 3588 Total Liabilities + Net Worth 3588
Income Statement (all numbers are in $ million unless stated otherwise)
Sales…
arrow_forward
Solve all questions
arrow_forward
Problem 84 (LAA)
Summa Company revealed the following account balances
on December 31, 2020
Accota payable
Accounta receivable, net of allowance for doubtful
accounts PS0.000
Accrued taxes
Aecrued interest receivable
Autherined sbare capital, 60,000 aharea. P100 par
Building, net ofaccumulated depreciation of P500,000 3,000.000
Cash on hand
Cash in bank
Bond sinking fund
Furniture and equipment, net ofaccumulated
depreciation of P900,000
Iaventory
Investment property
Land
Deferred tax liability
Bonds payable due June 30, 2021
Notes payable
Notes reoeivable
Patent
Ocher accrued liabilities
Prepaid expenses
Share premium
Retained earninge appropristed for contingencies
Retained eantings
Share ubecription receivable
Subscribed share capital E000 shares
Unianoed share capital
1000,000
50.000
30,000
5,000.000
50.000
650.000
2000.000
1,500,000
1,200,000
700.000
1,000,000
650.000
2.000.000
850.000
200,000
370,000
150,000
100,000
300,000
200,000
2.700,000
500,000
L000,000
2.000,000
Required:…
arrow_forward
Item
Prior year
Current year
Accounts payable
8,109.00
7,758.00
Accounts receivable
6,059.00
6,782.00
Accruals
1,036.00
1,609.00
Cash
???
???
Common Stock
11,891.00
11,189.00
COGS
12,683.00
18,018.00
Current portion long-term debt
4,980.00
4,993.00
Depreciation expense
2,500
2,813.00
Interest expense
733
417
Inventories
4,192.00
4,777.00
Long-term debt
13,329.00
13,523.00
Net fixed assets
50,636.00
54,376.00
Notes payable
4,329.00
9,999.00
Operating expenses (excl. depr.)
13,977
18,172
Retained earnings
28,278.00
29,801.00
Sales
35,119
47,221.00
Taxes
2,084
2,775
What is the firm's total change in cash from the prior year to the current year?
arrow_forward
Item
Prior year
Current year
Accounts payable
8,109.00
7,758.00
Accounts receivable
6,059.00
6,782.00
Accruals
1,036.00
1,609.00
Cash
???
???
Common Stock
11,891.00
11,189.00
COGS
12,683.00
18,018.00
Current portion long-term debt
4,980.00
4,993.00
Depreciation expense
2,500
2,813.00
Interest expense
733
417
Inventories
4,192.00
4,777.00
Long-term debt
13,329.00
13,523.00
Net fixed assets
50,636.00
54,376.00
Notes payable
4,329.00
9,999.00
Operating expenses (excl. depr.)
13,977
18,172
Retained earnings
28,278.00
29,801.00
Sales
35,119
47,221.00
Taxes
2,084
2,775
What is the firm's cash flow from investing?
arrow_forward
BALANCE SHEET
INCOME STATEMENT
($ in millions)
($ in millions)
ASSETS
Cash & Marketable Securities
LIABILITIES
Revenue
Cost Of Goods Sold
28,681. 10
Accounts Payable
Salaries Payable
449.90
1,611.20
20,768.80
Accounts Receivable
954.80
225.20
Gross Profit
7.912.30
Inventories
3,645.20
Other Current Liabilities
1,118.80
Operating Expenses:
Selling, General & Admin.
Depreciation
Operating income
Other Current Assets
Total Current Assets
116.60
5,166.50
Total Current Liabilities
2,955.20
5,980.80
Other Liabilities
693.40
307.30
1,688.90
1,129.70
2,348.40
(575.60)
Machinery & Equipment
Land
1,624.20
Total Liabilities
3,648.60
Buildings
Depreciation
Property, Plant & Equip. - Net
Other Long Term Assets
Total Long-Term Assets
Interest
SHAREHOLDER'S EQUITY
Other Expense (Income)
(13.10)
4,591.40
120.90
828.50
5.401.70
1,637.30
618.10
1,019.20
Common Stock
Income Before Taxes
Retained Earnings
Total Shareholder's Equity
Income Taxes
4,712.30
6,230.20
Net Income
Total Assets
9,878.80
Total…
arrow_forward
Item Prior year Current year Accounts payable 8,194.00 7,893.00 Accounts receivable 6,066.00 6,786.00 Accruals 977.00 1,572.00 Cash ??? ??? Common Stock 11,869.00 12,264.00 COGS 12,616.00 18,108.00 Current portion long-term debt 5,038.00 5,064.00 Depreciation expense 2,500 2,825.00 Interest expense 733 417 Inventories 4,145.00 4,778.00 Long-term debt 13,680.00 14,055.00 Net fixed assets 50,966.00 54,551.00 Notes payable 4,331.00 9,956.00 Operating expenses (excl. depr.) 13,977 18,172 Retained earnings 28,104.00 29,983.00 Sales 35,119 45,456.00 Taxes 2,084 2,775 What is the firm's net income in the current year? . .
arrow_forward
Category
Prior Year Current Year
Accounts payable
3,159.00
5,955.00
Accounts receivable
6,974.00
8,952.00
Accruals
5,771.00
6,100.00
Additional paid in capital
19,965.00 13,214.00
Cash
???
???
Common Stock
2,850
2,850
COGS
22,509.00 18,563.00
Current portion long-term debt
500
500
Depreciation expense
1,044.00
984.00
Interest expense
1,285.00
1,168.00
Inventories
3,015.00
6,719.00
Long-term debt
16,894.00 22,766.00
Net fixed assets
75,882.00 73,989.00
Notes payable
4,022.00
6,500.00
Operating expenses (excl. depr.) 19,950
20,000
Retained earnings
35,811.00 34,391.00
Sales
46,360
45,993.00
Taxes
350
920
What is the firm's cash flow from operations?
Submit
Answer format: Number: Round to: 0 decimal places.
unanswered
not_submitted
Attempts Remaining: Infinity
arrow_forward
Item
Prior year
Current year
Accounts payable
8,174.00
7,997.00
Accounts receivable
6,053.00
6,627.00
Accruals
985.00
1,669.00
Cash
???
???
Common Stock
11,632.00
12,699.00
COGS
12,739.00
18,024.00
Current portion long-term debt
4,909.00
4,968.00
Depreciation expense
2,500
2,846.00
Interest expense
733
417
Inventories
4,157.00
4,806.00
Long-term debt
14,646.00
14,472.00
Net fixed assets
51,341.00
54,892.00
Notes payable
4,311.00
9,948.00
Operating expenses (excl. depr.)
13,977
18,172
Retained earnings
28,728.00
30,469.00
Sales
35,119
46,331.00
Taxes
2,084
2,775
What is the firm's cash flow from financing?
arrow_forward
Category
Accounts payable
Accounts receivable
Accruals
Additional paid in capital
Cash
Common Stock
COGS
Current portion long-term debt
Depreciation expense
Interest expense
Inventories
Long-term debt
Net fixed assets
Notes payable
Operating expenses (excl. depr.)
Retained earnings
Sales
Taxes
Prior Year Current Year
3,106.00
5,972.00
6,919.00
8,940.00
5,691.00
6,099.00
20,212.00
13,343.00
???
???
2,850
18,751.00
500
2,850
22,826.00
500
965.00
1,016.00
1,259.00
1,123.00
3,086.00 6,750.00
16,982.00 22,296.00
75,731.00 73,844.00
4,053.00 6,596.00
19,950 20,000
35,937.00
34,762.00
46,360 45,530.00
350
920
What is the firm's cash flow from operations?
Submit
Answer format: Number: Round to: 0 decimal places.
arrow_forward
What is average payment period using balance sheet below?
BALANCE SHEET
INCOME STATEMENT
($ in millions)
($ in millions)
ASSETS
LIABILITIES
Revenue
28,681.10
Cash & Marketable Securities
449.90
Accounts Payable
1,611.20
Cost Of Goods Sold
20,768.80
Accounts Receivable
954.80
Salaries Payable
225.20
Gross Profit
7,912.30
Inventories
3,645.20
Other Current Liabilities
1,118.80
Other Current Assets
116.60
Total Current Liabilities
2,955.20
Operating Expenses:
Total Current Assets
5,166.50
Selling, General & Admin.
5,980.80
Other Liabilities
693.40
Depreciation
307.30
Machinery & Equipment
1,688.90
Operating income
1,624.20
Land
1,129.70
Total Liabilities
3,648.60
Buildings
2,348.40
Interest
-
Depreciation
(575.60)
SHAREHOLDER'S EQUITY
Other Expense (Income)
(13.10)
Property, Plant & Equip. - Net…
arrow_forward
# 3
Category.
Prior Year Current Year
Accounts payable
3,136.00
5,904.00
Accounts receivable
6,838.00
9,068.00
Accruals
5,663.00
6,026.00
Additional paid in capital
20,182.00 13,570.00
Cash
???
???
Common Stock
2,850
2,850
COGS
22,844.00 18,591.00
Current portion long-term debt
500
500
Depreciation expense
955.00
1,036.00
Interest expense
1,275.00
1,169.00
Inventories
3,020.00
6,732.00
Long-term debt
16,947.00 22,144.00
Net fixed assets
75,056.00 74,173.00
Notes payable
4,022.00
6,569.00
Operating expenses (excl. depr.) 19,950
20,000
Retained earnings
35,957.00 34,753.00
Sales
46,360
45,431.00
Таxes
350
920
What is the firm's total change in cash from the prior
year to the current year?
Submit
Answer format: Number: Round to: 0 decimal places.
arrow_forward
Liabilities
Liquid assets
Monthly credit payments
Monthly savings
$ 8,800
$ 5,000
24668
$ 150
Net worth
Current liabilities
Take-home pay
Gross income
$ 59, 000
$ 1,350
$ 2,600
2,900
a. Debt ratio
b. Current ratio
arrow_forward
#2
Category.
Prior Year Current Year
Accounts payable
3,136.00
5,904.00
Accounts receivable
6,838.00
9,068.00
Accruals
5,663.00
6,026.00
Additional paid in capital
20,182.00
13,570.00
Cash
???
???
Common Stock
2,850
2,850
COGS
22,844.00 18,591.00
Current portion long-term debt
500
500
Depreciation expense
955.00
1,036.00
Interest expense
1,275.00
1,169.00
Inventories
3,020.00
6,732.00
Long-term debt
16,947.00 22,144.00
Net fixed assets
75,056.00 74,173.00
Notes payable
4,022.00
6,569.00
Operating expenses (excl. depr.) 19,950
20,000
Retained earnings
35,957.00 34,753.00
Sales
46,360
45,431.00
Таxes
350
920
What is the firm's cash flow from investing?
Submit
Answer format: Number: Round to: 0 decimal places.
arrow_forward
answer in text form please (without image)
arrow_forward
E9-6 Current Position Analysis
Obj. 3
..................
The following data were taken from the comparative balance sheet of Icon Living,
Inc., for the years ended December 31, 20Y9 and December 31, 20Y8:
Cash
Temporary
investments
Accounts and notes receivable (net)
Inventories
Prepaid expenses
Total current assets
Accounts payable
Accrued liabilities
Total current liabilities
▸ Details
Dec. 31, 20Y9
$ 75,000
125,000
250,000
425,000
25,000
$ 900,000
$ 350,000
25,000
$ 375,000
Dec. 31, 2018
$ 50,000
75,000
200,000
305,000
20,000
$ 650,000
$ 230,000
20,000
$ 250,000
a. Determine for each year (1) the working capital, (2) the current ratio, and (3)
the quick ratio.
b. What conclusions can be drawn from these data?
arrow_forward
What is the financial performance summary for this balance sheet?
BALANCE SHEET
INCOME STATEMENT
($ in millions)
($ in millions)
ASSETS
LIABILITIES
Revenue
28,681.10
Cash & Marketable Securities
449.90
Accounts Payable
1,611.20
Cost Of Goods Sold
20,768.80
Accounts Receivable
954.80
Salaries Payable
225.20
Gross Profit
7,912.30
Inventories
3,645.20
Other Current Liabilities
1,118.80
Other Current Assets
116.60
Total Current Liabilities
2,955.20
Operating Expenses:
Total Current Assets
5,166.50
Selling, General & Admin.
5,980.80
Other Liabilities
693.40
Depreciation
307.30
Machinery & Equipment
1,688.90
Operating income
1,624.20
Land
1,129.70
Total Liabilities
3,648.60
Buildings
2,348.40
Interest
-
Depreciation
(575.60)
SHAREHOLDER'S EQUITY
Other Expense (Income)
(13.10)
Property, Plant & Equip. - Net…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,



Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,

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

Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education
Related Questions
- Category Prior Year Current Year Accounts payable ??? Accounts receivable 320,715 397,400 Accruals 40,500 33,750 Additional paid in capital 500,000 541,650 Cash 17,500 47,500 Common Stock 94,000 105,000 COGS 328,500 431,516.41 Current portion long-term debt 33,750 35,000 Depreciation expense 54,000 55,946.66 Interest expense 40,500 41,874.31 Inventories 279,000 288,000 Long-term debt 336,467.85 401,942.46 Net fixed assets 946,535 999,000 Notes payable 148,500 162,000 Operating expenses (excl. depr.) 126,000 161,499.58 Retained earnings 306,000 342,000 Sales 639,000 854,554.01 Taxes 24,750 48,384.56 ??? What is the current year's return on equity (ROE)? Submit Answer format: Percentage Round to: 2 decimal places (Example: 9.24%, % sign re rounded to 4 decimal places (ex: 0.0924))arrow_forwardBalance Sheet Income Statement ($ in millions) ($ in millions) Assets LIABILITIES Cash & Marketable Securities 449.90 Accounts Payable 1,611.20 Revenue 28,681.10 Accounts Receivable 954.80 Salaries Payable 225.20 Cost Of Goods Sold 20,768.80 Inventories 3,645.20 Other Current Liabilities 1,118.80 Gross Profit 7,912.30 Other Current Assets 116.60 Total…arrow_forwardCategory Prior Year Current Year Accounts payable ??? ??? Accounts receivable 320,715 397,400 Accruals 40,500 33,750 Additional paid in capital 500,000 541,650 Cash 17,500 47,500 Common Stock 94,000 105,000 COGS 328,500 428,571.00 Current portion long-term debt 33,750 35,000 Depreciation expense 54,000 54,035.00 Interest expense 40,500 42,155.00 Inventories 279,000 288,000 Long-term debt 339,577.00 401,377.00 Net fixed assets 946,535 999,000 Notes payable 148,500 162,000 Operating expenses (excl. depr.) 126,000 162,171.00 Retained earnings 306,000 342,000 Sales 639,000 849,094.00 Taxes 24,750 47,192.00 What is the current year's entry for long-term debt on a common-sized balance sheet? (ROUND TO 4 DECIMAL PLACES.)arrow_forward
- Category Prior Year Current Year Accounts payable ??? ??? Accounts receivable 320,715 397,400 Accruals 40,500 33,750 Additional paid in capital 500,000 541,650 Cash 17,500 47,500 Common Stock 94,000 105,000 COGS 328,500 431,139.00 Current portion long-term debt 33,750 35,000 Depreciation expense 54,000 54,349.00 Interest expense 40,500 41,741.00 Inventories 279,000 288,000 Long-term debt 337,728.00 398,725.00 Net fixed assets 946,535 999,000 Notes payable 148,500 162,000 Operating expenses (excl. depr.) 126,000 162,280.00 Retained earnings 306,000 342,000 Sales 639,000 847,106.00 Taxes 24,750 48,618.00 What is the current year's return on assets (ROA)? (Round to 4 decimal places.)arrow_forward($ in 000s) Cash and cash equivalents $247,286 Short-term investments 362,700 Accounts receivable 513,944 Inventory 468,738 Prepaid expenses (current) 92,259 Total current assets 1,684,927 Long-term receivables 119,800 Equipment (net) Total assets Notes payable (current) 40,116 Accounts payable 41,072 Accrued liabilities 430,772 Other current liabilities 190,604 Total current liabilities 702,564 Long-term debt 343,576 Total liabilities 1,046,140 Common stock 460,627 Retained earnings 1,000,000 1. Find Equipment (net) 2. Find Total Assestsarrow_forwardBalance sheet ($ in millions) ASSETS Cash & Marketable Securities 449.90 Accounts Receivable 954.80 Inventories 3,645.20 Other Current Assets 116.60 Total Current Assets 5,166.50 Machinery & Equipment 1,688.90 Land 1,129.70 Buildings 2,348.40 Depreciation (575.60) Property, Plant & Equip. - Net 4,591.40 Other Long Term Assets 120.90 Total Long-Term Assets 4,712.30 Total Assets 9,878.80 part of Balance Sheet LIABILITIES Accounts Payable 1,611.20 Salaries Payable 225.20 Other Current Liabilities 1,118.80 Total Current Liabilities 2,955.20 Other Liabilities 693.40 Total Liabilities 3,648.60 SHAREHOLDER'S EQUITY Common Stock 828.50 Retained Earnings 5,401.70 Total Shareholder's Equity 6,230.20 Total Liabilities…arrow_forward
- Take a look at this balance sheet and income statement: Balance Sheet (all numbers are in $ millions unless stated otherwise) Current Assets Current Liabilities Cash 98 Accounts Payable 344 A/C Receivable 188 Notes Payable 196 Inventory 422 Total 708 Total 540 Fixed Assets Long-Term Liabilities Net PPE 2880 Long-Term Debt 457 Common Stock and Paid-In Surplus 550 Retained Earnings 2041 Total Assets 3588 Total Liabilities + Net Worth 3588 Income Statement (all numbers are in $ million unless stated otherwise) Sales…arrow_forwardSolve all questionsarrow_forwardProblem 84 (LAA) Summa Company revealed the following account balances on December 31, 2020 Accota payable Accounta receivable, net of allowance for doubtful accounts PS0.000 Accrued taxes Aecrued interest receivable Autherined sbare capital, 60,000 aharea. P100 par Building, net ofaccumulated depreciation of P500,000 3,000.000 Cash on hand Cash in bank Bond sinking fund Furniture and equipment, net ofaccumulated depreciation of P900,000 Iaventory Investment property Land Deferred tax liability Bonds payable due June 30, 2021 Notes payable Notes reoeivable Patent Ocher accrued liabilities Prepaid expenses Share premium Retained earninge appropristed for contingencies Retained eantings Share ubecription receivable Subscribed share capital E000 shares Unianoed share capital 1000,000 50.000 30,000 5,000.000 50.000 650.000 2000.000 1,500,000 1,200,000 700.000 1,000,000 650.000 2.000.000 850.000 200,000 370,000 150,000 100,000 300,000 200,000 2.700,000 500,000 L000,000 2.000,000 Required:…arrow_forward
- Item Prior year Current year Accounts payable 8,109.00 7,758.00 Accounts receivable 6,059.00 6,782.00 Accruals 1,036.00 1,609.00 Cash ??? ??? Common Stock 11,891.00 11,189.00 COGS 12,683.00 18,018.00 Current portion long-term debt 4,980.00 4,993.00 Depreciation expense 2,500 2,813.00 Interest expense 733 417 Inventories 4,192.00 4,777.00 Long-term debt 13,329.00 13,523.00 Net fixed assets 50,636.00 54,376.00 Notes payable 4,329.00 9,999.00 Operating expenses (excl. depr.) 13,977 18,172 Retained earnings 28,278.00 29,801.00 Sales 35,119 47,221.00 Taxes 2,084 2,775 What is the firm's total change in cash from the prior year to the current year?arrow_forwardItem Prior year Current year Accounts payable 8,109.00 7,758.00 Accounts receivable 6,059.00 6,782.00 Accruals 1,036.00 1,609.00 Cash ??? ??? Common Stock 11,891.00 11,189.00 COGS 12,683.00 18,018.00 Current portion long-term debt 4,980.00 4,993.00 Depreciation expense 2,500 2,813.00 Interest expense 733 417 Inventories 4,192.00 4,777.00 Long-term debt 13,329.00 13,523.00 Net fixed assets 50,636.00 54,376.00 Notes payable 4,329.00 9,999.00 Operating expenses (excl. depr.) 13,977 18,172 Retained earnings 28,278.00 29,801.00 Sales 35,119 47,221.00 Taxes 2,084 2,775 What is the firm's cash flow from investing?arrow_forwardBALANCE SHEET INCOME STATEMENT ($ in millions) ($ in millions) ASSETS Cash & Marketable Securities LIABILITIES Revenue Cost Of Goods Sold 28,681. 10 Accounts Payable Salaries Payable 449.90 1,611.20 20,768.80 Accounts Receivable 954.80 225.20 Gross Profit 7.912.30 Inventories 3,645.20 Other Current Liabilities 1,118.80 Operating Expenses: Selling, General & Admin. Depreciation Operating income Other Current Assets Total Current Assets 116.60 5,166.50 Total Current Liabilities 2,955.20 5,980.80 Other Liabilities 693.40 307.30 1,688.90 1,129.70 2,348.40 (575.60) Machinery & Equipment Land 1,624.20 Total Liabilities 3,648.60 Buildings Depreciation Property, Plant & Equip. - Net Other Long Term Assets Total Long-Term Assets Interest SHAREHOLDER'S EQUITY Other Expense (Income) (13.10) 4,591.40 120.90 828.50 5.401.70 1,637.30 618.10 1,019.20 Common Stock Income Before Taxes Retained Earnings Total Shareholder's Equity Income Taxes 4,712.30 6,230.20 Net Income Total Assets 9,878.80 Total…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education

Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,



Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,

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

Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education