Financial Statements, Cash Flow, and Taxes-ab6873
xlsx
keyboard_arrow_up
School
Northern Arizona University *
*We aren’t endorsed by this school
Course
120
Subject
Accounting
Date
Nov 24, 2024
Type
xlsx
Pages
5
Uploaded by MegaResolve8522
Financial Statements, Cash Flow, and Taxes
Laiho Industries: Balance Sheets as of December 31
(in thousands of dollars)
2021
2020
Assets
Cash
$104,979
$91,530
Accounts receivable
104,651
86,523
Inventories
39,005
35,575
Total current assets
$248,635
$213,628
Net fixed assets
69,223
44,014
Total assets
$317,858
$257,642
Liabilities and equity
Accounts payable
$29,253
$21,190
Accruals
28,822
21,746
Notes payable
17,156
14,246
Total current liabilities
$75,231
$57,182
Long-term debt
75,043
63,793
Total liabilities
$150,274
$120,975
Common stock
105,500
93,000
Retained earnings
62,084
43,667
Total common equity
$167,584
$136,667
Total liabilities and equity
$317,858
$257,642
a. Constructing the firm's 2021 income statement
Laiho Industries: financial information for 2021
(in thousands of dollars)
Sales $464,150
EBITDA as a percentage of sales
15%
Depr. as a % of fixed assets
19%
Tax rate
25%
Interest expense
$9,019
Dividend payout ratio
48.25%
A
B
C
D
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
Laiho Industries: Income Statement for Year Ending December 31, 2021
(in thousands of dollars)
2021
Formulas
Sales
$464,150 =C31
394,528 =C41-C43
EBITDA
$69,623 =C41*C32
Depreciation and amortization
13,152 =C11*C33
EBIT
$56,470 =C43-C44
Interest
9,019 =C35
EBT
$47,451 =C45-C46
Taxes (25%)
11,863 =C47*C34
Net Income
$35,588 =C47-C48
Common dividends
$17,171 =C49*0.4825
Addition to retained earnings
$18,417 =C49-C51
b. Constructing the statement of stockholders' equity for the year ending Decemb
and the 2021 statement of cash flows
(in thousands of dollars)
Retained Earnings
Balances, December 31, 2020
$93,000
$43,667
Common stock issue
12,500
2021 Net income
35,588
Cash dividends
-17,171
Addition to retained earnings
Balances, December 31, 2021
$105,500
$62,084
Operating costs excluding depreciation and amortization
Laiho Industries: Statement of Stockholders' Equity, December 31, 2021
Common Stock
A
B
C
D
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
(in thousands of dollars)
Operating Activities
2021
Formulas
Net income
$35,588 =C49
Depreciation and amortization
13,152 =C44
Increase in accounts payable
8,063 =C15-D15
Increase in accruals
7,076 =C16-D16
Increase in accounts receivable
-18,128 =-(C8-D8)
Increase in inventories
-3,430 =-(C9-D9)
Net cash provided by operating activities
$42,322 =SUM(C70:C75)
Investing Activities
Additions to property, plant, and equipment
-$38,361 =-(C11-D11+C44)
Net cash used in investing activities
-$38,361 =C79
Financing Activities
Increase in notes payable
$2,910 =C17-D17
Increase in long-term debt
11,250 =C19-D19
Increase in common stock
12,500 =C21-D21
Payment of common dividends
-17,171 =-C51
Net cash provided by financing activities
$9,489 =SUM(C83:C86)
Summary
Net increase/decrease in cash
$13,449 =C76+C80+C87
Cash at the beginning of the year
91,530 =D7
Cash at the end of the year
$104,979 =C90+C91
c. Calculating 2020 and 2021 net operating working capital (NOWC) and 2021 free
Excesss cash
$0
$170,692 =(D10-0)-(D18-D17)
$190,560 =(C10-0)-(C18-C17)
-$2,724 =C45*(1-C34)+C44-(
e. Calculating the firm's 2021 EVA
After-tax cost of capital
10.5%
$15,075 =C45*(1-C34)-(C17+
f. Calculating the firm's MVA at year-end 2021
Stock price
$21
Shares outstanding
10,000
$42,416 =C105*C106-C23
Laiho Industries: Statement of Cash Flows for 2021
NOWC
2020
(in thousands of dollars)
NOWC
2021
(in thousands of dollars)
FCF
2021
(in thousands of dollars)
EVA
2021
(in thousands of dollars)
MVA
2021
(in thousands of dollars)
A
B
C
D
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
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
ber 31, 2021,
$136,667 =D21
12,500 =C65-C60
18,417
$167,584 =C21
Total Stockholders' Equity
E
F
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
e cash flow (FCF)
(-C80+C97-C96)
+C19+C23)*C101
E
F
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
Related Questions
Excel Activity: Financial Statements, Cash Flow, and Taxes
Laiho Industries's 2020 and 2021 balance sheets (in thousands of dollars) are shown.
Laiho Industries: Balance Sheets as of December 31 (thousands of dollars)
2021
2020
Cash
$
106,278
$
91,660
Accounts receivable
103,347
85,164
Inventories
38,965
35,757
Total current assets
$
248,590
$
212,581
Net fixed assets
67,963
42,749
Total assets
$
316,553
$
255,330
Accounts payable
$
30,151
$
22,600
Accruals
31,711
24,202
Notes payable
17,606
14,626
Total current liabilities
$
79,468
$
61,428
Long-term debt
77,320
64,070
Total liabilities
$
156,788
$
125,498
Common stock
100,500
88,000
Retained earnings
59,265
41,832
Total common equity
$
159,765
$
129,832
Total liabilities and equity
$
316,553
$
255,330
The data has been collected in the Microsoft Excel file below.…
arrow_forward
Laiho Industries: Balance Sheets as of December 31 (thousands of dollars)
2021
Cash
$101,426
2020
$ 89,860
Accounts receivable
101,633
83,682
Inventories
38,056
35,033
Total current assets
$241,115
$208,575
Net fixed assets
Total assets
70,997
$312,112
44,385
$252,960
Accounts payable
Accruals
Notes payable
Total current liabilities
Long-term debt
$ 32,241
29,743
16,658
$ 78,642
77,676
$156,318
$ 24,640
22,720
14,048
$ 61,408
65,276
$126,684
Total liabilities
Common stock
Retained earnings
Total common equity
Total liabilities and equity
105,500
93,000
50,294
33,276
$155,794
$126,276
$312,112
$252,960
arrow_forward
Correct answer for d e f
arrow_forward
What is Ratio Corporation's Fiscal 2021 Times Interest Earned Ratio?
1.41
2.57
4.5
1.63
arrow_forward
Pharoah Corporation’s comparative balance sheet is presented below.
PHAROAH CORPORATIONBalance SheetDecember 31
Assets
2021
2020
Cash
$12,010
$8,980
Accounts receivable
17,810
19,660
Land
16,800
21,840
Buildings
58,800
58,800
Accumulated depreciation—buildings
(12,600
)
(8,400
)
Total
$92,820
$100,880
Liabilities and Shareholders’ Equity
Accounts payable
$10,390
$26,120
Common shares
63,000
57,960
Retained earnings
19,430
16,800
Total
$92,820
$100,880
Additional information:
1.
Profit was $19,010. Dividends declared and paid were $16,380.
2.
No noncash investing and financing activities occurred during 2021.
3.
The land was sold for cash of $4,120 resulting in a loss of $920 on the sale of the land.
Prepare a cash flow statement for 2021 using the indirect method. Lu…
arrow_forward
JUST DEW IT CORPORATION
2020 and 2021 Balance Sheets
Assets
2020
2021
Current assets
Liabilities and Owners' Equity
Current liabilities
2020
2021
Cash
$12,000
$ 17,775
Accounts payable
Accounts receivable
12,750
16,425
Notes payable
$46,875 $55,575
19,125 24,750
Inventory
50,250
56,925
Total
$75,000 $91,125
Total
$66,000 $80,325
Long-term debt
$30,000 $27,000
Owners' equity
Common stock and paid-in surplus $45,000 $45,000
Retained earnings
234,000 297,675
Net plant and equipment
$
300,000
$
$ 358,875
Total
$279,000
342,675
$
$
Total assets
$375,000
Total liabilities and owners' equity
$375,000
450,000
450,000
Prepare the 2021 common-base year balance sheet for Just Dew It. (Do not round
intermediate calculations and round your answers to 4 decimal places, e.g., 32.1616.)
Assets
Current assets
Cash
Accounts receivable
Inventory
Total
Fixed assets
Net plant and equipment
Total assets
Liabilities and Owners' Equity
2020
2021
$
12,000 $
17,775
12,750
16,425
50,250
56,925
$
69
75,000 $…
arrow_forward
Ratio Analysis
Consider the following information taken from GER's financial statements:
September 30(in thousands)
2020
2019
Current assets:
Cash and cash equivalents
$1,274
$6,450
Receivables
30,071
16,548
Inventories
31,796
14,072
Other current assets
4,818
2,620
Total current assets
$67,959
$39,690
Current liabilities:
Current portion of long-term debt
$97
$3,530
Accounts payable
23,124
11,228
Accrued compensation costs
5,606
1,929
Accrued expenses
9,108
5,054
Other current liabilities
874
777
Total current liabilities
$38,809
$22,518
Also, GER's operating cash flows were $11,255 and $13,736 in 2020 and 2019, respectively.
4. Calculate the operating cash flow ratios for 2020 and 2019.
Operating Cash Flow Ratio
2020
fill in the blank 7
2019
fill in the blank 8
arrow_forward
Seminole Corporation reported the following items at December 31, 2021, and 2020:
(Click the icon to view the comparative financial information.)
Read the requirements.
Requirement 1. Compute the company's (a) quick (acid-test) ratio and (b) days' sales outstanding for 2021. Evaluate each ratio
value as strong or weak. All sales are on account with terms of net 30 days.
(a) Enter the formula and calculate the quick (acid-test) ratio for 2021. (Abbreviation used: Cash* = Cash and cash equivalents.
Round your final answer to two decimal places.)
Cash* + Short-term investments + Net current receivables + Total current liabilities = Quick (acid-test) ratio
$
Seminole's quick (acid-test) ratio is considered fairly weak.
(b) Select the formula and calculate Seminole's days' sales outstanding for 2021. (Round interim calculations to two decimal
places, XX.XX. Round the days' sales outstanding up to the next whole day.)
Accounts receivable turnover =
+
Days' sales outstanding
Seminole's days'…
arrow_forward
Suppose the following financial data were reported by 3M Company for 2019 and 2020 (dollars in millions).
3M CompanyBalance Sheets (partial)
2020
2019
Current assets
Cash and cash equivalents
$3,040
$1,908
Accounts receivable, net
3,370
3,180
Inventories
2,774
3,016
Other current assets
1,956
1,628
Total current assets
$11,140
$9,732
Current liabilities
$4,882
$5,875
Calculate the current ratio and working capital for 3M for 2019 and 2020.
arrow_forward
On January 1, 2024, the general ledger of Freedom Fireworks includes the following account balances:
Accounts
Cash
Credit
Debit
$11,200
Accounts Receivable
34,000
Allowance for Uncollectible Accounts
$1,800
Inventory
152,000
Land
67,300
Buildings
120,000
Accumulated Depreciation
Accounts Payable
9,600
17,700
Common Stock
200,000
Retained Earnings
Totals
$ 384,500
155,400
$384,500
During January 2024, the following transactions occur:
January 1 Borrow $100,000 from Captive Credit Corporation. The installment note bears interest at 7% annually and matures in 5 years. Payments of $1,980 are required at the end of each month for 60 months.
January 4 Receive $31,000 from customers on accounts receivable.
January 10 Pay cash on accounts payable, $11,000.
January 15 Pay cash for salaries, $28,900.
January 30 Firework sales for the month total $195,000. The cost of the units sold is $112,500.
January 31 Pay the first monthly installment of $1,980 related to the $100,000 borrowed on January 1.…
arrow_forward
Condensed balance sheet and income statement data for Coronado Corporation are presented here.
Coronado CorporationBalance SheetsDecember 31
2022
2021
2020
Cash
$ 29,700
$ 17,300
$ 17,100
Accounts receivable (net)
49,500
45,800
49,000
Other current assets
89,800
95,700
63,900
Investments
55,100
69,300
45,600
Property, plant, and equipment (net)
500,800
369,900
358,000
$724,900
$598,000
$533,600
Current liabilities
$84,500
$80,200
$69,100
Long-term debt
145,100
84,100
49,100
Common stock, $10 par
354,000
321,000
308,000
Retained earnings
141,300
112,700
107,400
$724,900
$598,000
$533,600
Coronado CorporationIncome StatementsFor the Years Ended December 31
2022
2021
Sales
$744,500
$606,300
Less: Sales returns and allowances
40,900
29,700
Net…
arrow_forward
Baghiben
arrow_forward
Suppose the following financial data were reported by 3M Company for 2021 and 2022 (dollars in millions).
Current assets
3M Company
Balance Sheets (partial)
Cash and cash equivalents
Accounts receivable, net
Inventories
Other current assets
Total current assets
Current liabilities
Screenshot
Current ratio
Working capital
2022
$
$3,180
3,600
2,738
1,932
$11,450
$4,830
2021
$1,836
3,180
3,019
1,590
Suppose that at the end of 2022, 3M management used $183 million cash to pay off $183 million of accounts payable. How would
its current ratio and working capital have changed? (Round current ratio to 2 decimal places, e.g. 1.25: 1. Enter working
capital answer to million.)
$9,625
$5,887
:1
million
Done
arrow_forward
The following data are provided for Cet Company:
December 31
2021
2020
Cash
$ 1,500,000
$ 1,000,000
Accounts receivable (net)
1,600,000
1,200,000
Inventories
2,600,000
2,200,000
Plant assets (net)
7,000,000
6,500,000
Accounts payable
Income taxes payable
1,100,000
800,000
200,000
100,000
Bonds payable
10% Preferred stock, $50 par
1,400,000
1,400,000
2,000,000
2,000,000
Common stock, $10 par
Paid-in capital in excess of par
Retained earnings
2,400,000
1,800,000
1,600,000
1,300,000
4,000,000
3,500,000
What is Cet's current ratio for 2021?
arrow_forward
Laiho Industries's 2020 and 2021 balance sheets (in thousands of dollars) are shown.
Laiho Industries: Balance Sheets as of December 31 (thousands of dollars)
2021
2020
Cash
$
104,140
$
88,830
Accounts receivable
104,298
84,488
Inventories
36,610
33,119
Total current assets
$
245,048
$
206,437
Net fixed assets
69,336
43,335
Total assets
$
314,384
$
249,772
Accounts payable
$
30,991
$
23,310
Accruals
31,054
22,280
Notes payable
14,963
12,603
Total current liabilities
$
77,008
$
58,193
Long-term debt
77,100
63,050
Total liabilities
$
154,108
$
121,243
Common stock
100,500
88,000
Retained earnings
59,776
40,529
Total common equity
$
160,276
$
128,529
Total liabilities and equity
$
314,384
$
249,772
The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis…
arrow_forward
Font
The 2021 balance sheet for Hallbrook Industries, Inc., is shown below.
HALLBROOK INDUSTRIES, INC.
Balance Sheet
December 31, 2021
($ in thousands)
Assets
280
230
Cash
Short-term investmentS
Accounts receivable
Inventory
Property, plant, and equipment (net)
280
310
1,800
$ 2,900
Total assets
Liabilities and Shareholders' Equity
$4
480
Current liabilities
Long-term liabilities
Paid-in capital
Retained earnings
430
1,150
840
Total liabilities and shareholders' equity
$ 2,900
The company's 2021 income statement reported the following amounts ($ in thousands):
$5,400
70
Net sales
Interest expense
Income tax expense
Net income
180
240
Required:
1. Calculate the current ratio. (Round your answer to 2 decimal places.)
2. Calculate the acid-test ratio. (Round your answer to 3 decimal places.)
3. Calculate the debt to equity ratio. (Round your answer to 2 decimal places.)
4. Calculate the times interest earned ratio. (Round your answer to 1 decimal place.)
1. Current ratio
2. Acid-test…
arrow_forward
Condensed balance sheet and income statement data for Jergan Corporation are presented here.
Jergan CorporationBalance SheetsDecember 31
2020
2019
2018
Cash
$ 30,800
$ 17,600
$ 18,700
Accounts receivable (net)
50,500
44,200
47,100
Other current assets
89,600
94,900
63,900
Investments
55,300
71,000
45,100
Plant and equipment (net)
500,500
370,000
358,500
$726,700
$597,700
$533,300
Current liabilities
$85,500
$79,800
$69,400
Long-term debt
144,300
84,100
50,300
Common stock, $10 par
348,000
316,000
304,000
Retained earnings
148,900
117,800
109,600
$726,700
$597,700
$533,300
Jergan CorporationIncome StatementFor the Years Ended December 31
2020
2019
Sales revenue
$738,000
$605,500
Less: Sales returns and allowances
39,100
29,900
Net sales…
arrow_forward
Marina Company Statement of Financial Position June 30, 2020
AssetsCurrent Assets Cash P 21,000.00 Accounts Receivables 160,000.00 Merchandise Inventory 300,000.00 Prepaid Expenses 9,000.00Total Current Assets P 490,000.00Property, Plant and Equipment 810,000.00Total Assets P 1,300,000.00
Liabilities and EquityLiabilities: Current Liabilities P 200,000.00 Bonds Payable, 10% 300,000.00Total Liabilities P 500,000.00Equity:…
arrow_forward
Condensed balance sheet and income statement data for Jergan Corporation are presented here.
Jergan CorporationBalance SheetsDecember 31
2020
2019
2018
Cash
$ 29,600
$ 17,000
$ 17,600
Accounts receivable (net)
50,600
44,300
48,300
Other current assets
90,300
94,500
64,500
Investments
55,000
70,000
44,700
Plant and equipment (net)
500,400
370,600
357,400
$725,900
$596,400
$532,500
Current liabilities
$85,400
$79,800
$69,900
Long-term debt
144,900
84,300
50,900
Common stock, $10 par
351,000
310,000
300,000
Retained earnings
144,600
122,300
111,700
$725,900
$596,400
$532,500
Jergan CorporationIncome StatementFor the Years Ended December 31
2020
2019
Sales revenue
$737,000
$605,800
Less: Sales returns and allowances
39,700
30,300
Net sales
697,300
575,500…
arrow_forward
Condensed balance sheet and income statement data for Jergan Corporation are presented here.
Jergan CorporationBalance SheetsDecember 31
2020
2019
2018
Cash
$ 29,600
$ 17,000
$ 17,600
Accounts receivable (net)
50,600
44,300
48,300
Other current assets
90,300
94,500
64,500
Investments
55,000
70,000
44,700
Plant and equipment (net)
500,400
370,600
357,400
$ 725,900
$ 596,400
$ 532,500
Current liabilities
$ 85,400
$ 79,800
$ 69,900
Long-term debt
144,900
84,300
50,900
Common stock, $10 par
351,000
310,000
300,000
Retained earnings
144,600
122,300
111,700
$ 725,900
$ 596,400
$ 532,500
Jergan CorporationIncome StatementFor the Years Ended December 31
2020
2019
Sales revenue
$ 737,000
$ 605,800
Less: Sales returns and allowances
39,700
30,300…
arrow_forward
Oriole Company
Balance Sheets
December 31
Assets
Cash
Receivables (net)
Other current assets
2022
2021
$28,400
$20,800
77,000
61,500
67,100
53,700
Long-term investments
62,200
61,000
Property, plant, and equipment (net)
610,000
488,000
Total assets
$844,700
685,000
Liabilities and Stockholders' Equity.
Current liabilities
$75,000 $68,000
Long-term liabilities
84,500
96,000
Common stock
333,000
298,500
Retained earnings
352,200
222,500
Total liabilities and stockholders' equity
$844,700
$685,000
Oriole Company
Income Statements
For the Years Ended December 31
2022
2021
Sales revenue
$775,940 $674,200
Cost of goods sold
448,000
401,000
Operating expenses (including income taxes)
256,000
218,000
Net income
$71,940
$55,200
Additional information:
Net cash provided by operating activities
$88,400 $60,000
Cash used for capital expenditures
$39,500 $41,000
Dividends paid
$30,000 $13,000
Weighted-average common shares outstanding
33,000
30,000
Compute these values and ratios for 2021 and 2022…
arrow_forward
Carla Vista Co. has these comparative balance sheet data:
CARLA VISTA CO.Balance SheetsDecember 31
2020
2019
Cash
$ 16,140
$ 32,280
Accounts receivable (net)
75,320
64,560
Inventory
64,560
53,800
Plant assets (net)
215,200
193,680
$371,220
$344,320
Accounts payable
$ 53,800
$ 64,560
Mortgage payable (15%)
107,600
107,600
Common stock, $10 par
150,640
129,120
Retained earnings
59,180
43,040
$371,220
$344,320
Additional information for 2020:
1.
Net income was $32,500.
2.
Sales on account were $392,900. Sales returns and allowances amounted to $27,300.
3.
Cost of goods sold was $217,300.
4.
Net cash provided by operating activities was $57,200.
5.
Capital expenditures were $30,000, and cash dividends were $19,000.
Compute the following ratios at December 31, 2020. (Round current ratio and inventory turnover to 2 decimal places, e.g. 1.83…
arrow_forward
Use the balance sheet and income statement below:
CLANCY’S DOG BISCUIT CORPORATION
Balance Sheet as of December 31, 2021 and 2020
(in millions of dollars)
Assets
2021
2020
Liabilities and Equity
2021
2020
Current assets:
Current liabilities:
Cash and marketable securities
$
10
$
10
Accrued wages and taxes
$
18
$
12
Accounts receivable
27
23
Accounts payable
22
20
Inventory
33
28
Notes payable
22
18
Total
$
70
$
61
Total
$
62
$
50
Fixed assets:
Long-term debt
$
27
$
29
Gross plant and equipment
$
97
$
76
Stockholders’ equity:
Less: Accumulated depreciation
24
18
Preferred stock (2 million shares)
$
2
$
2
Net plant and equipment
$
73
$
58
Common stock and paid-in-surplus (5 million shares)
11
11
Other long-term assets
21
21
Retained earnings
62
48…
arrow_forward
Sandhill Co. has these comparative balance sheet data:
SANDHILL CO.Balance SheetsDecember 31
2020
2019
Cash
$ 29,205
$ 58,410
Accounts receivable (net)
136,290
116,820
Inventory
116,820
97,350
Plant assets (net)
389,400
350,460
$671,715
$623,040
Accounts payable
$ 97,350
$ 116,820
Mortgage payable (15%)
194,700
194,700
Common stock, $10 par
272,580
233,640
Retained earnings
107,085
77,880
$671,715
$623,040
Additional information for 2020:
1.
Net income was $34,900.
2.
Sales on account were $378,200. Sales returns and allowances amounted to $29,600.
3.
Cost of goods sold was $204,700.
4.
Net cash provided by operating activities was $57,300.
5.
Capital expenditures were $28,200, and cash dividends were $13,800.
Compute the following ratios at December 31, 2020. (Round current ratio and inventory turnover to 2 decimal places, e.g. 1.83…
arrow_forward
Sandhill Co. has these comparative balance sheet data:
SANDHILL CO.Balance SheetsDecember 31
2020
2019
Cash
$ 29,205
$ 58,410
Accounts receivable (net)
136,290
116,820
Inventory
116,820
97,350
Plant assets (net)
389,400
350,460
$671,715
$623,040
Accounts payable
$ 97,350
$ 116,820
Mortgage payable (15%)
194,700
194,700
Common stock, $10 par
272,580
233,640
Retained earnings
107,085
77,880
$671,715
$623,040
Additional information for 2020:
1.
Net income was $34,900.
2.
Sales on account were $378,200. Sales returns and allowances amounted to $29,600.
3.
Cost of goods sold was $204,700.
4.
Net cash provided by operating activities was $57,300.
5.
Capital expenditures were $28,200, and cash dividends were $13,800.
Only the first 3 were answered the last time, I need all of these answered now.
Compute the following ratios at December 31,…
arrow_forward
Suppose the following financial data were reported by 3M Company for 2019 and 2020 (dollars in millions).
3M CompanyBalance Sheets (partial)
2020
2019
Current assets
Cash and cash equivalents
$3,200
$1,881
Accounts receivable, net
3,500
3,175
Inventories
2,702
3,044
Other current assets
1,896
1,582
Total current assets
$11,298
$9,682
Current liabilities
$4,791
$5,869
1.Calculate the current ratio and working capital for 3M for 2019 and 2020.
2.Suppose that at the end of 2020, 3M management used $198 million cash to pay off $198 million of accounts payable. How would its current ratio and working capital have changed?
arrow_forward
Vishnu
arrow_forward
Assets
Current assets
Cash
Accounts receivable
Inventory
Total
Total assets
Sales
Cost of goods sold
Depreciation
Taxable income
Taxes (23%)
Earnings before interest and
taxes
Interest paid
Net income
SMOLIRA GOLF CORPORATION
2021 Income Statement
Dividends
Retained earnings
Fixed assets
Net plant and equipment $465,700 $ 521,583 Total
Cash, beginning of the year
Operating activities
2020
$35,685 $39,032
28.936
43,152
$58,136 $111,120
Net cash from operating activities
Investment activities
SMOLIRA GOLF CORPORATION
2020 and 2021 Balance Sheets
2021
18,451
4,000
Cash, end of year
Net cash from investment activities
Financing activities
Net cash from financing activities
SMOLIRA GOLF CORPORATION
Statement of Cash Flows
For 2021
$ 523,836 $ 632,703 Total liabilities and owners' equity
Liabilities and Owners' Equity
Current liabilities
$ 24,000
39,144
Accounts payable
Notes payable
Other
Long-term debt
Owners' equity
Common stock and paid-in surplus
Accumulated retained earnings
Prepare…
arrow_forward
Just Dew It Corporation
2018 and 2019 Balance Sheets
Assets
Liabilities and Owner’s Equity
2018
2019
2018
2019
Current Assets
Current Liabilities
Cash
$11,135
$13,407
Accounts payable
$45,166
$48,185
Accounts Receivable
28,419
30,915
Notes payable
17,773
18,257
Inventory
51,163
56,295
Total
$62,939
$66,442
Total
$90,717
$100,617
Long term debt
$44,000
$39,000
Owners’ equity
Net plant and equipment
$326,456
$357,560
Common stock and paid-in surplus
$50,000
$50,000
Retained earnings
260,234
302,735
Total
$310,234
$352,735
Total assets
$417,173
$458,177
Total liabilities and owners’ equity
$417,173
$458,177
Prepare the 2019 common-base year balance sheet for Just Dew It.
arrow_forward
Just Dew It Corporation
2018 and 2019 Balance Sheets
Assets
Liabilities and Owner’s Equity
2018
2019
2018
2019
Current Assets
Current Liabilities
Cash
$11,135
$13,407
Accounts payable
$45,166
$48,185
Accounts Receivable
28,419
30,915
Notes payable
17,773
18,257
Inventory
51,163
56,295
Total
$62,939
$66,442
Total
$90,717
$100,617
Long term debt
$44,000
$39,000
Owners’ equity
Net plant and equipment
$326,456
$357,560
Common stock and paid-in surplus
$50,000
$50,000
Retained earnings
260,234
302,735
Total
$310,234
$352,735
Total assets
$417,173
$458,177
Total liabilities and owners’ equity
$417,173
$458,177
For each account on this company’s balance sheet, show the change in the account during 2019 and note…
arrow_forward
Just Dew It Corporation
2018 and 2019 Balance Sheets
Assets
Liabilities and Owner’s Equity
2018
2019
2018
2019
Current Assets
Current Liabilities
Cash
$11,135
$13,407
Accounts payable
$45,166
$48,185
Accounts Receivable
28,419
30,915
Notes payable
17,773
18,257
Inventory
51,163
56,295
Total
$62,939
$66,442
Total
$90,717
$100,617
Long term debt
$44,000
$39,000
Owners’ equity
Net plant and equipment
$326,456
$357,560
Common stock and paid-in surplus
$50,000
$50,000
Retained earnings
260,234
302,735
Total
$310,234
$352,735
Total assets
$417,173
$458,177
Total liabilities and owners’ equity
$417,173
$458,177
Debt–equity ratio and equity multiplier.
Total debt ratio and long-term debt ratio.
arrow_forward
Laiho Industries's 2020 and 2021 balance sheets (in thousands of dollars) are shown.
Laiho Industries: Balance Sheets as of December 31 (thousands of dollars)
2021
2020
Cash
$
102,785
$
89,530
Accounts receivable
103,454
85,552
Inventories
39,771
36,287
Total current assets
$
246,010
$
211,369
Net fixed assets
63,528
40,673
Total assets
$
309,538
$
252,042
Accounts payable
$
32,604
$
24,450
Accruals
29,905
21,470
Notes payable
16,454
13,454
Total current liabilities
$
78,963
$
59,374
Long-term debt
76,373
65,273
Total liabilities
$
155,336
$
124,647
Common stock
105,000
95,000
Retained earnings
49,202
32,395
Total common equity
$
154,202
$
127,395
Total liabilities and equity
$
309,538
$
252,042
The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis…
arrow_forward
Avery Corporation
Balance Sheet
For year ending December 31
2019
2020
2021
ssets
Cash & securities
17,643.813
132,468.629
22,281.616
115,121.68
27,594.924
ccounts receivable
112,479.309
100,955.129
10,947.986
251,977.349
ventories
78,867.845
90,512.493
10,222.209
239,202.497
repaid expenses
10,426.653
otal current assets
238,342.442
Flant property and equipment
Lcumulated depreciation
let property plant and equipment
531,554.881
510,906.018
536,451.319
87,197.29
128,069.772
170,985.877
444,357.591
382,836.246
365,465.442
Other assets
10,222.209
15,639.98
16,421.979
otal Assets
693,782.297
636,818.669
633,864.769
iabilities & Shareholders'Equity
ccounts payable
ank Loan
axes Payable
ccrued expenses
54,080.808
31,297.644
27,599.965
45,191.687
112,482.797
26,066.634
15,639.98
37,773.252
150,798.301
27,369.965
26,577.744
139,556.161
32,843.958
248,785.476
otal current liabilities
199,381.098
ong term debt
95,000
55,000
30,000
Common stock
300,000
200,000
150,000
Eetained earnings
Total…
arrow_forward
You have compiled the following information on Winslow, Inc.:
2019 2020
Assets
Cash $ 298 $ 306
Accounts receivable 3,006 3,422
Inventory 5,210 5,650
Net fixed assets 32,780 36,400
Total assets $ 41,294 $ 45,778
Liabilities and Equity
Accounts payable $ 6,219 $ 6,184
Other current liabilities 1,880 1,625
Long-term debt 17,951 21,991
Stockholders’ equity 15,244 15,978
Total liabilities and equity $ 41,294 $ 45,778
Sales $ 11,418
Cost of goods sold 6,320
General and administrative 2,419
Depreciation 967
EBIT $ 1,712
Interest 230
EBT $ 1,482
Taxes 519
Net income $ 963
What is the cash flow to creditors for 2020?
arrow_forward
Bethesda Mining Company reports the following balance sheet information for 2021 and 2022:
Assets
Current assets
BETHESDA MINING COMPANY
Balance Sheets as of December 31, 2021 and 2022
2021
2022
Cash
Accounts receivable
Inventory
$ 34,678
59,281
130,795
$ 224,754
$ 44,680
Total
79,639
197,317
$ 321,636
Liabilities and Owners' Equity
Current liabilities
Accounts payable
Notes payable
Total
Long-term debt
Owners' equity
Common stock and paid-in surplus
Accumulated retained earnings
Total
2021
$ 192,922
88,020
$ 280,942
$243,000
Fixed assets
$ 212,000
146,359
Net plant and equipment
Total assets
$ 657,547
$882,301
$589,378
$ 911,014
Total liabilities and owners' equity
$ 358,359
$882,301
2022
$ 200,611
139,588
$ 340,199
$ 179,750
$ 212,000
179,065
$ 391,065
$ 911,014
Based on the balance sheets given, calculate the following financial ratios for each year:
Calculate the following financial ratios for each year.
a. Current ratio.
Note: Do not round intermediate calculations and round your…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Related Questions
- Excel Activity: Financial Statements, Cash Flow, and Taxes Laiho Industries's 2020 and 2021 balance sheets (in thousands of dollars) are shown. Laiho Industries: Balance Sheets as of December 31 (thousands of dollars) 2021 2020 Cash $ 106,278 $ 91,660 Accounts receivable 103,347 85,164 Inventories 38,965 35,757 Total current assets $ 248,590 $ 212,581 Net fixed assets 67,963 42,749 Total assets $ 316,553 $ 255,330 Accounts payable $ 30,151 $ 22,600 Accruals 31,711 24,202 Notes payable 17,606 14,626 Total current liabilities $ 79,468 $ 61,428 Long-term debt 77,320 64,070 Total liabilities $ 156,788 $ 125,498 Common stock 100,500 88,000 Retained earnings 59,265 41,832 Total common equity $ 159,765 $ 129,832 Total liabilities and equity $ 316,553 $ 255,330 The data has been collected in the Microsoft Excel file below.…arrow_forwardLaiho Industries: Balance Sheets as of December 31 (thousands of dollars) 2021 Cash $101,426 2020 $ 89,860 Accounts receivable 101,633 83,682 Inventories 38,056 35,033 Total current assets $241,115 $208,575 Net fixed assets Total assets 70,997 $312,112 44,385 $252,960 Accounts payable Accruals Notes payable Total current liabilities Long-term debt $ 32,241 29,743 16,658 $ 78,642 77,676 $156,318 $ 24,640 22,720 14,048 $ 61,408 65,276 $126,684 Total liabilities Common stock Retained earnings Total common equity Total liabilities and equity 105,500 93,000 50,294 33,276 $155,794 $126,276 $312,112 $252,960arrow_forwardCorrect answer for d e farrow_forward
- What is Ratio Corporation's Fiscal 2021 Times Interest Earned Ratio? 1.41 2.57 4.5 1.63arrow_forwardPharoah Corporation’s comparative balance sheet is presented below. PHAROAH CORPORATIONBalance SheetDecember 31 Assets 2021 2020 Cash $12,010 $8,980 Accounts receivable 17,810 19,660 Land 16,800 21,840 Buildings 58,800 58,800 Accumulated depreciation—buildings (12,600 ) (8,400 ) Total $92,820 $100,880 Liabilities and Shareholders’ Equity Accounts payable $10,390 $26,120 Common shares 63,000 57,960 Retained earnings 19,430 16,800 Total $92,820 $100,880 Additional information: 1. Profit was $19,010. Dividends declared and paid were $16,380. 2. No noncash investing and financing activities occurred during 2021. 3. The land was sold for cash of $4,120 resulting in a loss of $920 on the sale of the land. Prepare a cash flow statement for 2021 using the indirect method. Lu…arrow_forwardJUST DEW IT CORPORATION 2020 and 2021 Balance Sheets Assets 2020 2021 Current assets Liabilities and Owners' Equity Current liabilities 2020 2021 Cash $12,000 $ 17,775 Accounts payable Accounts receivable 12,750 16,425 Notes payable $46,875 $55,575 19,125 24,750 Inventory 50,250 56,925 Total $75,000 $91,125 Total $66,000 $80,325 Long-term debt $30,000 $27,000 Owners' equity Common stock and paid-in surplus $45,000 $45,000 Retained earnings 234,000 297,675 Net plant and equipment $ 300,000 $ $ 358,875 Total $279,000 342,675 $ $ Total assets $375,000 Total liabilities and owners' equity $375,000 450,000 450,000 Prepare the 2021 common-base year balance sheet for Just Dew It. (Do not round intermediate calculations and round your answers to 4 decimal places, e.g., 32.1616.) Assets Current assets Cash Accounts receivable Inventory Total Fixed assets Net plant and equipment Total assets Liabilities and Owners' Equity 2020 2021 $ 12,000 $ 17,775 12,750 16,425 50,250 56,925 $ 69 75,000 $…arrow_forward
- Ratio Analysis Consider the following information taken from GER's financial statements: September 30(in thousands) 2020 2019 Current assets: Cash and cash equivalents $1,274 $6,450 Receivables 30,071 16,548 Inventories 31,796 14,072 Other current assets 4,818 2,620 Total current assets $67,959 $39,690 Current liabilities: Current portion of long-term debt $97 $3,530 Accounts payable 23,124 11,228 Accrued compensation costs 5,606 1,929 Accrued expenses 9,108 5,054 Other current liabilities 874 777 Total current liabilities $38,809 $22,518 Also, GER's operating cash flows were $11,255 and $13,736 in 2020 and 2019, respectively. 4. Calculate the operating cash flow ratios for 2020 and 2019. Operating Cash Flow Ratio 2020 fill in the blank 7 2019 fill in the blank 8arrow_forwardSeminole Corporation reported the following items at December 31, 2021, and 2020: (Click the icon to view the comparative financial information.) Read the requirements. Requirement 1. Compute the company's (a) quick (acid-test) ratio and (b) days' sales outstanding for 2021. Evaluate each ratio value as strong or weak. All sales are on account with terms of net 30 days. (a) Enter the formula and calculate the quick (acid-test) ratio for 2021. (Abbreviation used: Cash* = Cash and cash equivalents. Round your final answer to two decimal places.) Cash* + Short-term investments + Net current receivables + Total current liabilities = Quick (acid-test) ratio $ Seminole's quick (acid-test) ratio is considered fairly weak. (b) Select the formula and calculate Seminole's days' sales outstanding for 2021. (Round interim calculations to two decimal places, XX.XX. Round the days' sales outstanding up to the next whole day.) Accounts receivable turnover = + Days' sales outstanding Seminole's days'…arrow_forwardSuppose the following financial data were reported by 3M Company for 2019 and 2020 (dollars in millions). 3M CompanyBalance Sheets (partial) 2020 2019 Current assets Cash and cash equivalents $3,040 $1,908 Accounts receivable, net 3,370 3,180 Inventories 2,774 3,016 Other current assets 1,956 1,628 Total current assets $11,140 $9,732 Current liabilities $4,882 $5,875 Calculate the current ratio and working capital for 3M for 2019 and 2020.arrow_forward
- On January 1, 2024, the general ledger of Freedom Fireworks includes the following account balances: Accounts Cash Credit Debit $11,200 Accounts Receivable 34,000 Allowance for Uncollectible Accounts $1,800 Inventory 152,000 Land 67,300 Buildings 120,000 Accumulated Depreciation Accounts Payable 9,600 17,700 Common Stock 200,000 Retained Earnings Totals $ 384,500 155,400 $384,500 During January 2024, the following transactions occur: January 1 Borrow $100,000 from Captive Credit Corporation. The installment note bears interest at 7% annually and matures in 5 years. Payments of $1,980 are required at the end of each month for 60 months. January 4 Receive $31,000 from customers on accounts receivable. January 10 Pay cash on accounts payable, $11,000. January 15 Pay cash for salaries, $28,900. January 30 Firework sales for the month total $195,000. The cost of the units sold is $112,500. January 31 Pay the first monthly installment of $1,980 related to the $100,000 borrowed on January 1.…arrow_forwardCondensed balance sheet and income statement data for Coronado Corporation are presented here. Coronado CorporationBalance SheetsDecember 31 2022 2021 2020 Cash $ 29,700 $ 17,300 $ 17,100 Accounts receivable (net) 49,500 45,800 49,000 Other current assets 89,800 95,700 63,900 Investments 55,100 69,300 45,600 Property, plant, and equipment (net) 500,800 369,900 358,000 $724,900 $598,000 $533,600 Current liabilities $84,500 $80,200 $69,100 Long-term debt 145,100 84,100 49,100 Common stock, $10 par 354,000 321,000 308,000 Retained earnings 141,300 112,700 107,400 $724,900 $598,000 $533,600 Coronado CorporationIncome StatementsFor the Years Ended December 31 2022 2021 Sales $744,500 $606,300 Less: Sales returns and allowances 40,900 29,700 Net…arrow_forwardBaghibenarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Fundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning