Cashflow inclass exercise Jan 31
xlsx
keyboard_arrow_up
School
Willamette University *
*We aren’t endorsed by this school
Course
GSM5112
Subject
Finance
Date
Feb 20, 2024
Type
xlsx
Pages
14
Uploaded by DrCranePerson1079
Fiscal Year End (YYYY-MM-DD)
2019/01/31
Income Statement (in 000s at most recent fiscal year end) Sales (Net)
25,625,043 Cost of Goods Sold
17,821,173 Gross Profit
7,803,870 R&D Expense
0 SG&A Expense
5,687,564 EBITDA
2,116,306 Depreciation
0 EBIT
2,116,306 Net Interest Expense
99,871 Non-Operating Income (Loss)
0 Taxable Income
2,016,435 Taxes
426,963 Net Income
1,589,472 Common Dividends
306,523 Balance Sheet (in 000s at most recent fiscal year end) Operating Cash and Market. Sec.
235,487 Receivables
0 Inventories
4,097,004 Other Current Assets
330,529 Total Current Assets
4,663,020 PP&E (Net)
2,970,806 Investments
0 Intangibles
5,538,806 Other Fixed Assets
31,406 Total Fixed assets
93,437 Total Assets
4,756,457 Current Debt
1,950 Accounts Payable
2,385,469 Income Taxes Payable
10,033 Other Current Liabilities
618,405 Total Current Liabilities
3,015,857 Total Long-Term Debt
3,161,101 Other liability
0 Total Liabilities
6,786,645 Preferred Stock
0 Common stock and capital surplus (Excluding treasury stock)
3,476,286 (5,506,474)
Accumulated Retained earnings and gains and losses not affecting retained earnings
Total Liabilities and Equity
4,756,457 Q 1 what is this company's CF(A) in the last 4 years?
Operating cash flow
2019
Earnings before interest and taxes
Depreciation
- taxes
Operating cash flow (OCF)
Net capital spending (not available for the first year)
Ending fixed assets
-Beginning fixed assets
Depreciation
Net capital spending (NCS)
Net working capital cash flow (not available for the first year)
Ending NWC (Current assets - Current liability)
Beginning NWC (Current assets - Current liability)
NWC cash flow (
NWC)
△
Cash flow from assets
OCF
-Net capital spending
-Change in NWC
Cash flow from assets (CF(A))
Q 2 Should the shareholders be concerned? Or should they be pleased with the firm’s st
This had a negative amount of free cash flow in recent years primarily due to its
and net working capital. A negative cash flow from assets means that the amou
equity would have increased
Q 3 what is this company's CF(B) and CF(S) in the last 5 years?
Cash flow to creditors (not available for the first year)
Beginning long-term debt
-Ending long-term debt
Interest
Cash flow to creditors (CF(B))
Cash flow to stockholders
Begining. common stock, Capital Surplus & (-)Treasury stock
-Ending. common stock, Capital Surplus & (-) Treasury stock
Dividends
Cash flow to stockholders (CF(S))
CF(B)+CF(S)
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
2020/01/30
2021/01/31
2022/01/31
2023/01/31
27,753,973 33,746,839 34,220,449 37,844,863 19,264,912 23,027,977 23,407,443 26,024,765 8,489,061 10,718,862 10,813,006 11,820,098 0 0 0 0 6,186,757 7,164,097 7,592,331 8,491,796 2,302,304 3,554,765 3,220,675 3,328,302 0 0 0 0 2,302,304 3,554,765 3,220,675 3,328,302 100,574 150,385 157,526 211,273 0 0 0 (415)
2,201,730 3,404,380 3,063,149 3,116,614 489,175 749,330 663,917 700,625 1,712,555 2,655,050 2,399,232 2,415,989 327,568 355,926 392,188 493,726 240,320 1,376,577 344,829 381,576 0 0 0 0 4,676,848 5,247,477 5,614,325 6,760,733 260,700 290,165 344,689 438,700 5,177,868 6,914,219 6,303,843 7,581,009 3,278,359 3,899,997 4,346,127 5,236,309 0 0 0 0 5,538,595 5,538,459 5,538,339 5,538,289 8,830,262 9,509,949 10,139,062 10,727,760 10,297,529 14,019,078 17,518,643 21,502,358 15,475,397 20,933,297 23,822,486 29,083,367 0 0 0 0 2,860,682 3,614,089 3,738,604 3,552,991 8,362 16,063 8,055 8,919 1,673,961 2,080,631 2,232,698 2,325,858 4,543,005 5,710,783 5,979,357 5,887,768 10,904,352 12,780,054 13,260,774 16,592,921 0 0 0 0 16,122,584 19,201,386 20,065,385 23,541,595 0 0 0 0 3,539,840 3,655,136 3,787,987 3,885,632 3,162,660 3,006,102 2,473,999 1,656,140
15,475,397 20,933,297 23,822,486 29,083,367 2020
2021
2022
2023
$ 2,302,304 $ 3,554,765 $ 3,220,675 $ 3,328,302 $ - $ - $ - $ - $ 489,175 $ 749,330 $ 663,917 $ 700,625 $ 1,813,129 $ 2,805,435 $ 2,556,758 $ 2,627,677 $ 10,297,529 $ 14,019,078 $ 17,518,643 $ 21,502,358 $ 93,437 $ 10,297,529 $ 14,019,078 $ 17,518,643 $ - $ - $ - $ - $ 10,204,092 $ 3,721,549 $ 3,499,565 $ 3,983,715 $ 634,863 $ 1,203,436 $ 324,486 $ 1,693,241 $ 1,647,163 $ 634,863 $ 1,203,436 $ 324,486 $ (1,012,300)
$ 568,573 $ (878,950) $ 1,368,755 $ 1,813,129 $ 2,805,435 $ 2,556,758 $ 2,627,677 $ 10,204,092 $ 3,721,549 $ 3,499,565 $ 3,983,715 $ (1,012,300)
$ 568,573 $ (878,950) $ 1,368,755 $ (7,378,663) $ (1,484,687) $ (63,857)
$ (2,724,793)
table earnings (NI)? Please explain your answer. s increase in net capital spending unt of net new borrowing and
$ 3,161,101 $ 10,904,352 $ 12,780,054 $ 13,260,774 $ 10,904,352 $ 12,780,054 $ 13,260,774 $ 16,592,921 $ 100,574 $ 150,385 $ 157,526 $ 211,273 $ (7,642,677) $ (1,725,317) $ (323,194)
$ (3,120,874)
$ 3,476,286 $ 3,539,840 $ 3,655,136 $ 3,787,987 $ 3,539,840 $ 3,655,136 $ 3,787,987 $ 3,885,632 $ 327,568 $ 355,926 $ 392,188 $ 493,726 $ 264,014 $ 240,630 $ 259,337 $ 396,081
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
Fiscal Year End (YYYY-MM-DD)
2019/01/31
Income Statement (in 000s at most recent fiscal year end) Sales (Net)
25,625,043 Cost of Goods Sold
17,821,173 Gross Profit
7,803,870 R&D Expense
0 SG&A Expense
5,687,564 EBITDA
2,116,306 Depreciation
0 EBIT
2,116,306 Net Interest Expense
99,871 Non-Operating Income (Loss)
0 Taxable Income
2,016,435 Taxes
426,963 Net Income
1,589,472 Common Dividends
306,523 Balance Sheet (in 000s at most recent fiscal year end) Operating Cash and Market. Sec.
235,487 Receivables
0 Inventories
4,097,004 Other Current Assets
330,529 Total Current Assets
4,663,020 PP&E (Net)
2,970,806 Investments
0 Intangibles
5,538,806 Other Fixed Assets
31,406 Total Fixed assets
93,437 Total Assets
4,756,457 Current Debt
1,950 Accounts Payable
2,385,469 Income Taxes Payable
10,033 Other Current Liabilities
618,405 Total Current Liabilities
3,015,857 Long-Term Debt
3,161,101 Other Liabilities
0 Total Liabilities
6,786,645 Preferred Stock
0 Common stock and capital surplus (Excluding treasury stock)
3,476,286 (5,506,474)
Accumulated Retained earnings and gains and losses not affecting retained earnings
Total Liabilities and Equity
4,756,457 Q 1 what is this company's CF(A) in the last 4 years?
Operating cash flow
Earnings before interest and taxes
$ 2,116,306 Depreciation
$ - - taxes
$ 426,963 Operating cash flow (OCF)
$ 1,689,343 Net capital spending (not available for the first year)
Ending fixed assets
-Beginning fixed assets
Depreciation
Net capital spending (NCS)
Net working capital cash flow (not available for the first year)
Ending NWC (Current assets - Current liability)
Beginning NWC (Current assets - Current liability)
NWC cash flow (
NWC)
△
Cash flow from assets
OCF
-Net capital spending
-Change in NWC
Cash flow from assets (CF(A))
Q 2 Should the shareholders be concerned? Or should they be pleased with the firm’s st
This had a negative amount of free cash flow in recent years primarily due to its
and net working capital. A negative cash flow from assets means that the amou
would have increased. (See the calculations below)
The shareholders probably should be concerned about the significant drop in th
cash flow is usually an early warning signal. The company’s managers should ta
alleviate the resulting deterioration of the firm’s cash flows.
Q 3 what is this company's CF(B) and CF(S) in the last 5 years?
Cash flow to creditors (not available for the first year)
Beginning long-term debt
-Ending long-term debt
Interest
Cash flow to creditors (CF(B))
Cash flow to stockholders
Begining. common stock, Capital Surplus & (-)Treasury stock
-Ending. common stock, Capital Surplus & (-) Treasury stock
Dividends
Cash flow to stockholders (CF(S))
CF(B)+CF(S)
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
2020/01/30
2021/01/31
2022/01/31
2023/01/31
27,753,973 33,746,839 34,220,449 37,844,863 19,264,912 23,027,977 23,407,443 26,024,765 8,489,061 10,718,862 10,813,006 11,820,098 0 0 0 0 6,186,757 7,164,097 7,592,331 8,491,796 2,302,304 3,554,765 3,220,675 3,328,302 0 0 0 0 2,302,304 3,554,765 3,220,675 3,328,302 100,574 150,385 157,526 211,273 0 0 0 (415)
2,201,730 3,404,380 3,063,149 3,116,614 489,175 749,330 663,917 700,625 1,712,555 2,655,050 2,399,232 2,415,989 327,568 355,926 392,188 493,726 240,320 1,376,577 344,829 381,576 0 0 0 0 4,676,848 5,247,477 5,614,325 6,760,733 260,700 290,165 344,689 438,700 5,177,868 6,914,219 6,303,843 7,581,009 3,278,359 3,899,997 4,346,127 5,236,309 0 0 0 0 5,538,595 5,538,459 5,538,339 5,538,289 8,830,262 9,509,949 10,139,062 10,727,760 10,297,529 14,019,078 17,518,643 21,502,358 15,475,397 20,933,297 23,822,486 29,083,367 0 0 0 0 2,860,682 3,614,089 3,738,604 3,552,991 8,362 16,063 8,055 8,919 1,673,961 2,080,631 2,232,698 2,325,858 4,543,005 5,710,783 5,979,357 5,887,768 10,904,352 12,780,054 13,260,774 16,592,921 0 0 0 0 16,122,584 19,201,386 20,065,385 23,541,595 0 0 0 0 3,539,840 3,655,136 3,787,987 3,885,632 3,162,660 3,006,102 2,473,999 1,656,140
15,475,397 20,933,297 23,822,486 29,083,367 $ 2,302,304 $ 3,554,765 $ 3,220,675 $ 3,328,302 =G12
$ - $ - $ - $ - =G11
$ 489,175 $ 749,330 $ 663,917 $ 700,625 =G16
$ 1,813,129 $ 2,805,435 $ 2,556,758 $ 2,627,677 =G50+G51-G
$ 10,297,529 $ 14,019,078 $ 17,518,643 $ 21,502,358 =G31
$ 93,437 $ 10,297,529 $ 14,019,078 $ 17,518,643 =F31
$ - $ - $ - $ - =G11
$ 10,204,092 $ 3,721,549 $ 3,499,565 $ 3,983,715 =G56-G57+G
$ 634,863 $ 1,203,436 $ 324,486 $ 1,693,241 =G26-G38
$ 1,647,163 $ 634,863 $ 1,203,436 $ 324,486 =F26-F38
$ (1,012,300)
$ 568,573 $ (878,950) $ 1,368,755 =G63-G64
$ 1,813,129 $ 2,805,435 $ 2,556,758 $ 2,627,677 =G53
$ 10,204,092 $ 3,721,549 $ 3,499,565 $ 3,983,715 =G59
$ (1,012,300)
$ 568,573 $ (878,950) $ 1,368,755 =G65
$ (7,378,663) $ (1,484,687) $ (63,857)
$ (2,724,793)
=G68-G69-G
table earnings (NI)? Please explain your answer. s increase in net capital spending unt of net new borrowing and equity he firm’s cash flows. The decline in ake the necessary steps to
$ 3,161,101 $ 10,904,352 $ 12,780,054 $ 13,260,774 =F39
$ 10,904,352 $ 12,780,054 $ 13,260,774 $ 16,592,921 =G39
$ 100,574 $ 150,385 $ 157,526 $ 211,273 =G13
$ (7,642,677) $ (1,725,317) $ (323,194)
$ (3,120,874)
=G93-G94+G
$ 3,476,286 $ 3,539,840 $ 3,655,136 $ 3,787,987 =F43
$ 3,539,840 $ 3,655,136 $ 3,787,987 $ 3,885,632 =G43
$ 327,568 $ 355,926 $ 392,188 $ 493,726 =G18
$ 264,014 $ 240,630 $ 259,337 $ 396,081 =G99-G100+
$ (7,378,663) $ (1,484,687) $ (63,857) $ (2,724,793)
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
G52
G58
G70
G95
+G101
Related Documents
Related Questions
Profit and Loss Account for the year ended 31st December 2021 (Figures are in £000)
Particulars
XYZ
ABC
Sales
3,690
4,586
Less: Cost of Goods Sold (Including purchases)
(2,146)
(2,690)
Gross Profit
1,544
1,896
Less: Selling & Distribution Expenses
Less: Depreciation
(1,103)
(1,253)
Earnings before Interest & Tax or Operating Profit
441
643
Less: Interest
(225)
(192)
Earnings before Tax
216
451
Less: Taxes
(86)
(180)
Earnings after Tax or Net Profit
130
271
Balance Sheet as at31st December 2021 (Figures are in £000)
Assets
XYZ
ABC
Fixed Assets
4,542
4,790
Current Assets
Account Receivables
274
313
Inventory
654
702
Cash
140
163
Total Current Assets
1,068
1,178
Total Assets
5,610
5,968
Liabilities
Capital
3,824
4,310
Long Term Debt
883
760
Current Liabilities
Account Payables…
arrow_forward
Good Truck Berhad
Income Statement for The Year ending 31 Dec 2019
(RM in millions)
Net sales
8,450
Less: Cost of goods sold
7,240
Less: Depreciation
400
Earnings before interest and taxes
810
Less: Interest paid
70
Taxable Income
740
Less: Taxes
259
Net income
481
Good Truck Berhad
Balance Sheets as at 31 December 2019
(RM in millions)
Assets
Liabilities and Equities
Cash
140
Accounts payable
1,120
Accounts rec.
780
Long-term debt
1,210
Inventory
1,520
Common stock
3,000
Total
2,440
Net fixed assets
3,600
Retained earnings
710
Total assets
6,040
Total liabilities & equity
6,040…
arrow_forward
Billingham Industries, Inc.
Comparative Income Statement
For the years ended December 31, 2021 and 202
Particulars
Amount (2021)
Amount (2020)
Amount (Increase/Decrease)
Percentage Change
Sales
$1,280,000
$1,180,000
$100,000
8.47%
Cost of goods sold
644,800
613,600
31,200
5.08%
Gross profit
635,200
566,400
68,800
12.15%
Selling expenses
230,500
188,800
41,700
22.09%
Administrative expenses
182,500
177,000
5,500
3.10%
Total operating expenses
413,000
365,800
47,200
12.90%
Income from operations
222,200
200,600
21,600
10.77%
Other income
77,000
70,800
6,200
8.757%
Income before income tax
299,200
271,400
27,800
10.243%
Income tax expense
121,600
106,200
15,400
14.500%
Net income
$177,600
$165,200
$12,400
7.506%
1. Perform a vertical analysis using the form provided below: (Enter as a formula computing % of sales)1. Perform a vertical analysis using the form provided below: (Enter as a formula computing % of sales)
arrow_forward
Lancer Company's preliminary income statement for 2021 and its reported income statement for 2020 are given below.
2021
2020
1,350,000
(648,0001
702,000
(172,500)
(162.000
367.500
Sales Revenues
1,320,000
(630.000
690,000
Cost of Goods Sold
Gross Profit
Depreciation
Other Expenses
(172,500)
(153.000
364.500
Net Income
Lancer's records reveal the following information:
(1) Lancer neglected to record S8,000 of supplies expense at the end of 2020, so the supplies inventory was overstated at the end of 2020.
Consequently, the supplies expense computed for 2021 included the additional amount of supplies used in 2020.
(2) On 1/1/19, Lancer purchased a machine for $120,000. Although the machine was expected to have an eight-year life, it was erroneously
expensed in recording the purchase. The appropriate depreciation method for this machine is double-declining-balance with no residual.
(3) At the end of 2021, Lancer decided to change its inventory costing method from the FIFO costing method…
arrow_forward
A firm has been experiencing low profitability in recent years. Perform an analysis of the firm's financial position using the DuPont equation. The firm has no lease payments but has a $3 million sinking fund payment on its debt. The
most recent industry average ratios and the firm's financial statements are as follows:
Industry Average Ratios
Current ratio
Debt-to-capital ratio
Times interest earned
EBITDA coverage
Inventory turnover
Cash and equivalents
Accounts receivables
Inventories
Total current assets
2x
17%
3 x
6 x
11 x
Days sales
outstandinga
Calculation is based on a 365-day year.
Balance Sheet as of December 31, 2021 (millions of dollars)
$78
Accounts payable
Other current liabilities
51
125
Notes payable
$ 254
Total current liabilities
Long-term debt
Total liabilities
Common stock
Retained earnings
Total stockholders' equity
Total liabilities and equity
Gross fixed assets
Less depreciation
Net fixed assets
Total assets
15 days
Fixed assets turnover
Total assets turnover…
arrow_forward
Atlantic Corporation reported the following financial statements:
E (Click the icon to view the financial statements.)
The company has 2,200 shares of common stock outstanding. What is Atlantic's earnings per share? (Round the earnings per share to two decimal places, X.XX.
O A. $1.90
Financial Statements
O B. $3.58
OC. $2.49
O D. 3.19 times
Atlantic Corporation
Comparative Balance Sheet
December 31, 2019 and 2018
2019
2018
Assets
Current Assets:
Cash and Cash Equivalents
2,052 $
1,655
Accounts Receivable
1,951
1,731
Merchandise Inventory
1,342
1,094
1,615
1,817
Prepaid Expenses
Total Current Assets
6,960
6,297
18,240
16,174
Other Assets
2$
25,200 $
22,471
Total Assets
Liabilities
Current Liabilities
24
7.087 $
8,158
4,698
3,844
Long-term Liabilities
Total Liabilities
11,785
12,002
Stockholders' Equity
Common Stock, no par
7,015
4,169
6,400
6,300
Retained Earnings
Click to select your an
Total Stockholders' Equity
13,415
10,469
24
25,200 $
22,471
Clear Al
All parts showing
Total…
arrow_forward
Please help me
arrow_forward
Some recent financial statements for Smolira Golf, Inc., follow.
SMOLIRA GOLF, INC.
Balance Sheets as of December 31, 2018 and 2019
2018
2019
2018
2019
Assets
Liabilities and Owners' Equity
Current assets
Current liabilities
$ 3,271 $ 3,457
4,782
5,811
13,812
12,418
Accounts payable
Notes payable
$ 2,138 $ 2,570
2,086
104
Cash
Accounts receivable
1,735
Inventory
Other
87
Total
$ 20,471 $23,080
Total
$ 3,960 $ 4,760
$ 13,700 $16,460
Long-term debt
Owners' equity
Common stock
36,500
and paid-in surplus
$36,500 $
Accumulated retained
38,893
Fixed assets
15,639
earnings
75,393
Net plant and
equipment
$ 52,139 $
$49,328 $73,533
Total
Total liabilities and owners'
Total assets
$69,799 $ 96,613
$ 69,799 $96,613
equity
arrow_forward
Which of the following statements is TRUE about Verizon's fınancial statements?
verizon
Consolidated Balance Sheets (In millions of dollars)
As of
As of
Dec 31, 2020
$ 22,171
Dec 31, 2019
$ 2,594
ASSETS
Cash and cash equivalents
Accounts receivable
23,917
25,429
Inventories
1,796
1,422
Prepaid expenses and other current assets
6,710
8,028
Total current assets
54,594
37,473
Property and equipment, net
94,833
91,915
Intangible assets
152,814
151,640
Other long-term assets
10,699
$ 291,727
14,240
Total assets
$ 316,481
LIABILITIES & EQUITY
Debt maturing within one year
$ 5,889
$ 10,777
Accounts payable and accrued liabilities
20,658
21,806
Other current liabilities
13,113
12,285
Total current liabilities
39,660
44,868
Long-term debt
123,173
100,712
Other long-term liabilities
84,376
83,312
Total liabilities
247,209
228,892
Common stock and additional paid in capital
13,833
13,858
Retained earnings
60,464
53,147
Accumulated other comprehensive income
(5,025)
(4,170)
Total shareholders'…
arrow_forward
subject; accounting
arrow_forward
Module pute Net Operating Profit after Tax
Refer to the balance sheet information below for Home Depot.
Feb. 3, 2019 Jan. 28, 2018
$35,891
$34,794
1,511
3,056
$37,402
$37,850
$14,177
$13,640
24,822
22,974
$38,999
$36,614
Operating assets
Nonoperating assets
Total assets
$ millions
Operating liabilities
Nonoperating liabilities
Total liabilities
Net sales
Operating expense before tax
Net operating profit before tax (NOPBT)
Other expense
Income before tax
Tax expense
Net income
Assume a statutory tax rate of 22%.
a. Compute NOPAT for the year ended Feb. 3, 2019 using the formula: NOPAT = Net income + NNE
Net income
NNE
NOPAT
$
9,453 $
$
$91,973
78,772
13,201
828
12,373
2,920
$9,453
7,361 * $
16814
b. Compute NOPAT for the year ended Feb. 3, 2019 using the formula: NOPAT = NOPBT - Tax on operating profit
NOPBT Tax on operating profit
7,361 * $
10,296.78 x $
NOPAT
-2936
arrow_forward
The following information is available for Sunland Corporation for the year ended December 31, 2022: sales revenue $840,000, other
revenues and gains $91,000, operating expenses $101,000, cost of goods sold $466,000, other expenses and losses $30,500, and
preferred stock dividends $40,950. The company's tax rate was 20%, and it had 70,000 common shares outstanding during the entire
year.
(a)
Your Answer Correct Answer
Your answer is partially correct.
Prepare a corporate income statement. (List other revenues before other expenses.)
arrow_forward
Consolidated Statements of Income
Years Ended December ($ millions)
July 27, 2019
July 28, 2018
Revenue
Product
$39,005
$36,709
Service
12,899
12,621
Total revenue
51,904
49,330
Cost of sales
Product
14,863
14,427
Service
4,375
4,297
Total cost of sales
19,238
18,724
Gross margin
32,666
30,606
Operating expenses
Research and development
6,577
6,332
Sales and marketing
9,571
9,242
General and administrative
1,827
2,144
Amortization of purchased intangible assets
150
221
Restructuring and other charges
322
358
Total operating expenses
18,447
18,297
Operating income
14,219
12,309
Interest income
1,308
1,508
Interest expense
(859)
(943)
Other income (loss), net
(97)
165
Interest and other income (loss), net
352
730
Income before provision for income taxes
14,571
13,039
Provision for income taxes
2,950
12,929
Net income
$11,621
$110
Cisco Systems Inc.Consolidated Balance Sheets
In millions, except par value
July 27,…
arrow_forward
Financial statement analysis The financial statements of Zach Industries for the year ended December 31, 2019, follow .
a. Use the financial statements to complete the following table E. Assume the industry averages given in the table are applicable for both 2018 and 2019.
b. Analyze Zach Industries' financial condition as it is related to (1) liquidity, (2) activity, (3) debt, (4) profitability, and (5) market. Summarize the company's overall financial condition.
.....
a. The current ratio is 1.04. (Round to two decimal places.)
The quick ratio is .38. (Round to two decimal places.)
The inventory turnover is 2.32. (Round to two decimal places.)
The average collection period is 56.1 days. (Round to one decimal place.)
The debt ratio is 61.7 %. (Round to one decimal place.)
The times interest earned ratio is
|. (Round to one decimal place.)
arrow_forward
Days Sales in Inventory
Accounts Receivable Turnover
Calcute each ratio from the data for 2019 and 2020
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
Assets
Current assets
Net fixed assets
INCOME STATEMENT, 2022
(Figures in $ millions)
Revenue
Cost of goods sold
Depreciation
Interest expense
2021
$ 101
2022
$ 195
910 1,010
$ 2,005
1,085
405
251
Req A and B Req C and D
BALANCE SHEET AT END OF YEAR
(Figures in $ millions)
Liabilities and Shareholders' Equity
Current liabilities
Long-term debt
Req E
Complete this question by entering your answers in the tabs below.
a&b. What is shareholders' equity in 2021 and 2022?
c&d. What is net working capital in 2021 and 2022?
e. What are taxes paid in 2022? Assume the firm pays taxes equal to 21% of taxable income.
f. What is cash provided by operations during 2022?
g.Net fixed assets increased from $910 million to $1,010 million during 2022. What must have been South Sea's gross investment in
fixed assets during 2022?
Answer is complete but not entirely correct.
h. If South Sea reduced its outstanding accounts payable by $46 million during the year, what must have happened to its other current…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Related Questions
- Profit and Loss Account for the year ended 31st December 2021 (Figures are in £000) Particulars XYZ ABC Sales 3,690 4,586 Less: Cost of Goods Sold (Including purchases) (2,146) (2,690) Gross Profit 1,544 1,896 Less: Selling & Distribution Expenses Less: Depreciation (1,103) (1,253) Earnings before Interest & Tax or Operating Profit 441 643 Less: Interest (225) (192) Earnings before Tax 216 451 Less: Taxes (86) (180) Earnings after Tax or Net Profit 130 271 Balance Sheet as at31st December 2021 (Figures are in £000) Assets XYZ ABC Fixed Assets 4,542 4,790 Current Assets Account Receivables 274 313 Inventory 654 702 Cash 140 163 Total Current Assets 1,068 1,178 Total Assets 5,610 5,968 Liabilities Capital 3,824 4,310 Long Term Debt 883 760 Current Liabilities Account Payables…arrow_forwardGood Truck Berhad Income Statement for The Year ending 31 Dec 2019 (RM in millions) Net sales 8,450 Less: Cost of goods sold 7,240 Less: Depreciation 400 Earnings before interest and taxes 810 Less: Interest paid 70 Taxable Income 740 Less: Taxes 259 Net income 481 Good Truck Berhad Balance Sheets as at 31 December 2019 (RM in millions) Assets Liabilities and Equities Cash 140 Accounts payable 1,120 Accounts rec. 780 Long-term debt 1,210 Inventory 1,520 Common stock 3,000 Total 2,440 Net fixed assets 3,600 Retained earnings 710 Total assets 6,040 Total liabilities & equity 6,040…arrow_forwardBillingham Industries, Inc. Comparative Income Statement For the years ended December 31, 2021 and 202 Particulars Amount (2021) Amount (2020) Amount (Increase/Decrease) Percentage Change Sales $1,280,000 $1,180,000 $100,000 8.47% Cost of goods sold 644,800 613,600 31,200 5.08% Gross profit 635,200 566,400 68,800 12.15% Selling expenses 230,500 188,800 41,700 22.09% Administrative expenses 182,500 177,000 5,500 3.10% Total operating expenses 413,000 365,800 47,200 12.90% Income from operations 222,200 200,600 21,600 10.77% Other income 77,000 70,800 6,200 8.757% Income before income tax 299,200 271,400 27,800 10.243% Income tax expense 121,600 106,200 15,400 14.500% Net income $177,600 $165,200 $12,400 7.506% 1. Perform a vertical analysis using the form provided below: (Enter as a formula computing % of sales)1. Perform a vertical analysis using the form provided below: (Enter as a formula computing % of sales)arrow_forward
- Lancer Company's preliminary income statement for 2021 and its reported income statement for 2020 are given below. 2021 2020 1,350,000 (648,0001 702,000 (172,500) (162.000 367.500 Sales Revenues 1,320,000 (630.000 690,000 Cost of Goods Sold Gross Profit Depreciation Other Expenses (172,500) (153.000 364.500 Net Income Lancer's records reveal the following information: (1) Lancer neglected to record S8,000 of supplies expense at the end of 2020, so the supplies inventory was overstated at the end of 2020. Consequently, the supplies expense computed for 2021 included the additional amount of supplies used in 2020. (2) On 1/1/19, Lancer purchased a machine for $120,000. Although the machine was expected to have an eight-year life, it was erroneously expensed in recording the purchase. The appropriate depreciation method for this machine is double-declining-balance with no residual. (3) At the end of 2021, Lancer decided to change its inventory costing method from the FIFO costing method…arrow_forwardA firm has been experiencing low profitability in recent years. Perform an analysis of the firm's financial position using the DuPont equation. The firm has no lease payments but has a $3 million sinking fund payment on its debt. The most recent industry average ratios and the firm's financial statements are as follows: Industry Average Ratios Current ratio Debt-to-capital ratio Times interest earned EBITDA coverage Inventory turnover Cash and equivalents Accounts receivables Inventories Total current assets 2x 17% 3 x 6 x 11 x Days sales outstandinga Calculation is based on a 365-day year. Balance Sheet as of December 31, 2021 (millions of dollars) $78 Accounts payable Other current liabilities 51 125 Notes payable $ 254 Total current liabilities Long-term debt Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and equity Gross fixed assets Less depreciation Net fixed assets Total assets 15 days Fixed assets turnover Total assets turnover…arrow_forwardAtlantic Corporation reported the following financial statements: E (Click the icon to view the financial statements.) The company has 2,200 shares of common stock outstanding. What is Atlantic's earnings per share? (Round the earnings per share to two decimal places, X.XX. O A. $1.90 Financial Statements O B. $3.58 OC. $2.49 O D. 3.19 times Atlantic Corporation Comparative Balance Sheet December 31, 2019 and 2018 2019 2018 Assets Current Assets: Cash and Cash Equivalents 2,052 $ 1,655 Accounts Receivable 1,951 1,731 Merchandise Inventory 1,342 1,094 1,615 1,817 Prepaid Expenses Total Current Assets 6,960 6,297 18,240 16,174 Other Assets 2$ 25,200 $ 22,471 Total Assets Liabilities Current Liabilities 24 7.087 $ 8,158 4,698 3,844 Long-term Liabilities Total Liabilities 11,785 12,002 Stockholders' Equity Common Stock, no par 7,015 4,169 6,400 6,300 Retained Earnings Click to select your an Total Stockholders' Equity 13,415 10,469 24 25,200 $ 22,471 Clear Al All parts showing Total…arrow_forward
- Please help mearrow_forwardSome recent financial statements for Smolira Golf, Inc., follow. SMOLIRA GOLF, INC. Balance Sheets as of December 31, 2018 and 2019 2018 2019 2018 2019 Assets Liabilities and Owners' Equity Current assets Current liabilities $ 3,271 $ 3,457 4,782 5,811 13,812 12,418 Accounts payable Notes payable $ 2,138 $ 2,570 2,086 104 Cash Accounts receivable 1,735 Inventory Other 87 Total $ 20,471 $23,080 Total $ 3,960 $ 4,760 $ 13,700 $16,460 Long-term debt Owners' equity Common stock 36,500 and paid-in surplus $36,500 $ Accumulated retained 38,893 Fixed assets 15,639 earnings 75,393 Net plant and equipment $ 52,139 $ $49,328 $73,533 Total Total liabilities and owners' Total assets $69,799 $ 96,613 $ 69,799 $96,613 equityarrow_forwardWhich of the following statements is TRUE about Verizon's fınancial statements? verizon Consolidated Balance Sheets (In millions of dollars) As of As of Dec 31, 2020 $ 22,171 Dec 31, 2019 $ 2,594 ASSETS Cash and cash equivalents Accounts receivable 23,917 25,429 Inventories 1,796 1,422 Prepaid expenses and other current assets 6,710 8,028 Total current assets 54,594 37,473 Property and equipment, net 94,833 91,915 Intangible assets 152,814 151,640 Other long-term assets 10,699 $ 291,727 14,240 Total assets $ 316,481 LIABILITIES & EQUITY Debt maturing within one year $ 5,889 $ 10,777 Accounts payable and accrued liabilities 20,658 21,806 Other current liabilities 13,113 12,285 Total current liabilities 39,660 44,868 Long-term debt 123,173 100,712 Other long-term liabilities 84,376 83,312 Total liabilities 247,209 228,892 Common stock and additional paid in capital 13,833 13,858 Retained earnings 60,464 53,147 Accumulated other comprehensive income (5,025) (4,170) Total shareholders'…arrow_forward
- subject; accountingarrow_forwardModule pute Net Operating Profit after Tax Refer to the balance sheet information below for Home Depot. Feb. 3, 2019 Jan. 28, 2018 $35,891 $34,794 1,511 3,056 $37,402 $37,850 $14,177 $13,640 24,822 22,974 $38,999 $36,614 Operating assets Nonoperating assets Total assets $ millions Operating liabilities Nonoperating liabilities Total liabilities Net sales Operating expense before tax Net operating profit before tax (NOPBT) Other expense Income before tax Tax expense Net income Assume a statutory tax rate of 22%. a. Compute NOPAT for the year ended Feb. 3, 2019 using the formula: NOPAT = Net income + NNE Net income NNE NOPAT $ 9,453 $ $ $91,973 78,772 13,201 828 12,373 2,920 $9,453 7,361 * $ 16814 b. Compute NOPAT for the year ended Feb. 3, 2019 using the formula: NOPAT = NOPBT - Tax on operating profit NOPBT Tax on operating profit 7,361 * $ 10,296.78 x $ NOPAT -2936arrow_forwardThe following information is available for Sunland Corporation for the year ended December 31, 2022: sales revenue $840,000, other revenues and gains $91,000, operating expenses $101,000, cost of goods sold $466,000, other expenses and losses $30,500, and preferred stock dividends $40,950. The company's tax rate was 20%, and it had 70,000 common shares outstanding during the entire year. (a) Your Answer Correct Answer Your answer is partially correct. Prepare a corporate income statement. (List other revenues before other expenses.)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning

Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning