Question

In: Finance

Cash Flow Flag INCOME STATEMENT Fiscal year ends in December. USD in millions except per share...

Cash Flow Flag INCOME STATEMENT

Fiscal year ends in December. USD in millions except per share data.

2013-12

2014-12

2015-12

2016-12

2017-12

TTM

Revenue

220156

200494

129925

110215

134674

154945

Cost of revenue

148882

136464

90788

78778

95114

110718

Gross profit

71274

64030

39137

31437

39560

44227

Costs and expenses

Sales, General and administrative

4510

4494

4443

4684

4448

4358

Interest expense

201

307

731

Other operating expenses

30859

28334

29852

28712

25584

21980

Total costs and expenses

35369

32828

34295

33597

30339

27069

Income before income taxes

35905

31202

4842

-2160

9221

17158

Provision for income taxes

14308

11892

132

-1729

-48

2903

Net income from continuing operations

21597

19310

4710

-431

9269

14255

Other

-174

-69

-123

-66

-74

-50

Net income

21423

19241

4587

-497

9195

14205

Net income available to common shareholders

21423

19241

4587

-497

9195

14205

Earnings per share

Basic

11.18

10.21

2.46

-0.27

4.88

7.49

Diluted

11.09

10.14

2.45

-0.27

4.85

7.43

Weighted average shares outstanding

Basic

1916

1884

1868

1872

1883

1897

Diluted

1932

1898

1875

1873

1898

1914

EBITDA

41399

36519

17327

17498

28877

36791

Write one-page of text that discusses the overall trend assessment regarding positive and negative values of this company’s Statement of Cash Flows for the last three years minimum. According to the Statement of Cash Flows, is this corporation performing well? Why or why not? Also discuss the trends of this company's Free Cash Flow.

Solutions

Expert Solution

The above statement tells us about the cash flow position of company for past 5 years from which it can be said

  • Net income till 4 years is decreasing compared to 1 year which is due to fall in companies sales revenue that is revenue decreased from 220156 to 134674 and than increased to 154945
  • Expenses are in line with revenues they are also decreasing as revenue is decreasing .
  • company started to increase its net income from 5 year which is due to increase in revenue and decrease in operating expenses.
  • Negative net income in 4th year is due to cost been more than revenue.
  • company has also involved in some loan or funding activity as it shows interest expenses are paid.
  • Company has approx equal no of shares both in form of basic and convertible to equity shares.

Free cash flow means amount available after payment of capital expenditures and operating expenses from cash flow from operations it is calculated as

CASH FLOW FROM OPERATIONS - CAPITAL EXPENDITURES

OR

NET INCOME+NON CASH EXPENSES- INCREASE IN WORKING CAPITAL- CAPITAL EXPENDITURES.

So as there are no capital expenditures in 5 years so free cash flow available is equal to net income for all the years.

Still it can not be perfectly commented for free cash flow as there is no balance sheet available  and we do not know about capital expenditures as interest is also paid

The company was not performing good till 4 years but from 5 year there is boost in the revenues and also positive net income.


Related Solutions

Perform a horizontal analysis of the Balance Sheet. Fiscal year ends in June. USD in millions...
Perform a horizontal analysis of the Balance Sheet. Fiscal year ends in June. USD in millions except per share data. 2016-06 2017-06 2018-06 Assets 193,694 241,086 258,848 Current assets 139,660 159,851 169,662 Cash 113,240 132,981 133,768 Cash and cash equivalents 6,510 7,663 11,946 Short-term investments 106,730 125,318 121,822 Total cash 113,240 132,981 133,768 Receivables 18,277 19,792 26,481 Inventories 2,251 2,181 2,662 Deferred income taxes Other current assets 5,892 4,897 6,751 Total current assets 139,660 159,851 169,662 Non-current assets Property, plant...
Income Statement for Fiscal Years Endings (in Millions, except per share amounts) Report Date 06/30/2019 06/30/2018...
Income Statement for Fiscal Years Endings (in Millions, except per share amounts) Report Date 06/30/2019 06/30/2018 06/30/2017 Net sales $67,684 $66,832 $65,058 Cost of products sold 34,768 34,268 32,535 Gross profit $32,916 $32,564 $32,523 Selling, general & administrative expense 19,084 18,853 18,568 Goodwill & indefinite lived intangible asset impairment charges 8,345 0.00 0.00 Operating income $5,487 $13,711 $13,955 Interest expense 509 506 465 Interest income 220 247 171 Other non-operating income (expense), net 871 -126 -404 Earnings from continuing operations...
Selected information about income statement accounts for the Reed Company is presented below (the company’s fiscal year ends on December 31).
Selected information about income statement accounts for the Reed Company is presented below (the company’s fiscal year ends on December 31). On July 1, 2021, the company adopted a plan to discontinue a division that qualifies as a component of an entity as defined by GAAP. The assets of the component were sold on September 30, 2021, for $48,000 less than their book value. Results of operations for the component (included in the above account balances) were as follows: In...
MCDONALDS balance sheet. Fiscal year is January-December. All values USD millions. 2014 2015 2016 2017 2018...
MCDONALDS balance sheet. Fiscal year is January-December. All values USD millions. 2014 2015 2016 2017 2018 5-year trend Cash & Short Term Investments 2.08B 7.69B 1.22B 2.46B 866M Cash Only 2.08B 7.69B 1.22B 2.46B 866M Short-Term Investments - - - - - Total Accounts Receivable 1.21B 1.3B 1.47B 1.98B 2.44B Accounts Receivables, Net 1.21B 1.3B 1.47B 1.98B 2.44B Accounts Receivables, Gross 1.21B 1.3B 1.47B 1.98B 2.44B Bad Debt/Doubtful Accounts - - - - - Other Receivables - - - -...
Dominos balance sheet Fiscal year is January-December. All values USD millions. 2014 2015 2016 2017 2018...
Dominos balance sheet Fiscal year is January-December. All values USD millions. 2014 2015 2016 2017 2018 5-year trend Cash & Short Term Investments 151.81M 314.39M 169.31M 227.53M 237.42M Cash Only 151.81M 314.39M 169.31M 227.53M 237.42M Short-Term Investments - - - - - Total Accounts Receivable 118.4M 131.58M 150.37M 173.68M 190.09M Accounts Receivables, Net 118.4M 131.58M 150.37M 173.68M 190.09M Accounts Receivables, Gross 121.76M 134.24M 152.71M 175.1M 191.97M Bad Debt/Doubtful Accounts (3.36M) (2.66M) (2.34M) (1.42M) (1.88M) Other Receivables - - - -...
Project Cash Flow Today (millions) Cash Flow in One Year (millions) A -$10 $20 B $6...
Project Cash Flow Today (millions) Cash Flow in One Year (millions) A -$10 $20 B $6 $4 C $18 -$12 Suppose all cash flows are certain and the​ risk-free interest rate is 5%. a. What is the NPV of each​ project? b. If the firm can choose only one of these​ projects, which should it​ choose? c. If the firm can choose any two of these​ projects, which should it​ choose?
Southwest Airlines Company Consolidated Statement of Income - USD ($) $ in Millions 12 Months Ended...
Southwest Airlines Company Consolidated Statement of Income - USD ($) $ in Millions 12 Months Ended 12/31/15 12/31/2014 12/31/2013 Please tell me Excel formula for %s in column below in BOLD!!!! OPERATING REVENUES: Passenger $ 18,299 $ 17,658 $ 16,721 103.6% 105.6% Freight 179 175 164 102.3% Special revenue adjustment 172 0 0 Other 1,170 772 814 151.6% Total operating revenues 19,820 18,605 17,699 106.5% OPERATING EXPENSES: Salaries, wages, and benefits 6,383 5,434 5,035 117.5% Fuel and oil 3,616 5,293...
Cash flow series Annual Cash Flow ($ per year) Annual Cash Flow ($ per year) Annual...
Cash flow series Annual Cash Flow ($ per year) Annual Cash Flow ($ per year) Annual Cash Flow ($ per year) Year Prob = 0.3 Prob = 0.22 Prob = 0.48 0 –5000 –6000 –4000 1 1000 500 3100 2 1000 1500 1200 3 1000 2000 100 Determine the expected present worth of the following cash flow series if each series may be realized with the probability shown at the head of each column. Let i = 20% per year....
The following financial information (in millions except for per share amounts) is for two major corporations...
The following financial information (in millions except for per share amounts) is for two major corporations for the three fiscal years ended December 31 as follows: Canadian Pacific Railway Limited 2017 2016 2015 Weighted average number of common shares 145.9 149.6 159.7 Profit $2,405 $1,599 $1,352 Dividends $319 $274 $221 Market price per share (December 31) $229.66 $191.56 $176.73 Canadian National Railway Company 2017 2016 2015 Weighted average number of common shares 753.6 776.0 800.7 Profit $5,484 $3,640 $3,538 Dividends...
($ in millions except share data) 2021 2020 Sales $ 9,843 $ 10,934 Net income $...
($ in millions except share data) 2021 2020 Sales $ 9,843 $ 10,934 Net income $ 280 $ 798 Stockholders' equity $ 1,710 $ 2,290 Average Shares outstanding (in millions) 665 - Dividends per share $ 0.38 - Stock price $ 8.50 - Choose numerator / Choose denominator Return on equity Dividend Yield Earnings per share price earning ratio
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT