Can you do it within 36 hours

profileNikku
financial_analysis.doc

Financial Analysis Report On Honeywell Vs. Boeing 1

Financial Analysis Report On Honeywell Vs. Boeing 35

[Type the company name]

Research Report On A Financial Analysis of Honeywell International Incorporation a Comparison Analysis against Major Competitor- The Boeing Company

[Type the document subtitle]

[Type the author name]

6/22/2014

Table of Contents

Synopsis of the two companies 4

4 Honeywell International, Inc

4 The Boeing Company

Summary of Latest Financial Statement 5

Ratio Analysis 11

Comparative Analysis with Major Competitor and Industry 17

Analysis of Key Statistics 19

Historical Stock Price Analysis 20

Relevant Information Analysis 22

Recommendation & Justification 23

References 24

Appendix 25-35

List of Figures

Figure No

Name of the Figure

Page No

Figure 1

Income Statement of Honeywell as on December 31, 2013

5

Figure 2

Balance Sheet of Honeywell as on December 31, 2013

7

Figure 3

Cash Flow Statement of Honeywell as on December 31, 2013

9

Figure 4

Owner’s Equity Statement of Honeywell as on December 31, 2013

10

Figure 5

Comparative Analysis with Industry, in 2013

17

Figure 6

Comparative Analysis with major competitor, in 2013

18

Figure 7

Key Statistics in 2013

20

List of Charts

Chart No

Title of the Chart

Page No

Chart 1

Liquidity Position of Honeywell for the last five years

12

Chart 2

Long term debt paying ability of Honeywell for the last five years

13

Chart 3

Profitability of Honeywell for the last five years

14

Chart 4

Asset Utilization ratio of Honeywell for the last five years

15

Chart 5

Market measures of Honeywell for the last five years

16

Chart 6

Forecasted future price of Honeywell

21

Synopsis of the two companies

Honeywell International, Inc.

Honeywell International, Inc. is a multinational conglomerate company based on USA. It produces variety of products which include aerospace systems, engineering products and services. Its consumers are from individual customers to various large corporations and also governments. Honeywell was listed in Dow Jones Industrial Average Index from December 7, 1925, until February 9, 2008. It’s headquarter is located in Morristown, New Jersey. The workforce of Honeywell includes 130,000 employees and 58,000 of whom are employed in the United States. It is a Fortune 100 company. In 2012 it became listed in the fortune 500 America’s ranking. The current CEO of Honeywell is chief executive officer is David M. Cote. Honeywell was founded by Mark C. Honeywell in 1906 in Wabash, Indiana as Honeywell Heating Specialty Co., Inc. In 1927 it merged with Minneapolis Heat Regulator Company. The major products of Honeywell is Aerospace which includes environmental control systems, Electric Power systems, Engine systems accessories, Avionics, displays, flight guidance and flight management systems, Radios, radar, navigation communication, data link safety systems, Aircraft lighting, Inertial sensor, Control products, Space products and subsystems, Management and technical services etc. It also provides Performance Materials and Technologies and Transportation Systems. It covers the U.S., Mexico, Canada, Brazil, China, India, Australia, Malaysia, Europe, Middle East and Africa (Honeywell, 2014).

The Boeing Company

The Boeing Company is a multinational company based on USA. It produces variety of products which include aerospace systems, engineering products and services. Its consumers are from individual customers to various large corporations and also governments. It is listed in Dow Jones Industrial Average Index. Its head quarter is located in Chicago. It [produces fixed-wing aircraft, rotorcraft, rockets and satellites. It also offers leasing and product support services. James McNerney is the chairman and CEO of Boeing (Boeing, 2014).

Summary of Latest Financial Statement

Honeywell’s Income statement shows the net income of Honeywell. It is the net balance of all the revenue and expense items. Honeywell’s gross profit for the year of 2014 is $10,691 million that is 27.37% of the Total Revenue. It incurs $5198 million as total operating expense for the same year. Total operating expense includes Research and development costs, selling, general and administrative expenses and non-recurring expenses. After deducting total operating expenses from Gross Profit, we get Total Operating Income that is $5,493 million. It is 14.06% of the Total Revenue. After adding the other income, we get Earnings before Interest and taxes, which is $5,739 million. EBIT is 53.68% of Total Revenue. Honeywell incurs interest expense of $327 million and paid income tax of $1,450 million. After deducting the expenses from the EBIT, we get the Net Income to Common shares, which is $3,962million.Net Income is 10.14% of Total Revenue. The following table shows the income statement for the period from 01 January 2013 to 31 December 2013of Honeywell International Incorporation:

Figure 1: Income Statement of Honeywell as on December 31, 2013

Income Statement (USD $ in millions)

Honeywell

Period Ending

Dec 31, 2013

Total Revenue

39,055

Cost of Revenue

28,364

Gross Profit

10,691

Research Development

-

Selling General and Administrative

5,190

Non Recurring

8

Total Operating Expenses

5,198

Operating Income or Loss

5,493

Total Other Income/Expenses Net

246

Earnings Before Interest And Taxes

5,739

Interest Expense

327

Income Before Tax

5,412

Income Tax Expense

1,450

Net Income

3,962

Net Income To Common Shares

3,962

Source: (Honeywell, Annual Report, 2013)

A Balance sheet resembles the status of the company’s financial and capital composition. Honeywell has current assets of $21,164 million as of 31st December, 2013. The items under current assets are cash & cash equivalents assets, short-term investments, net receivables, inventory and other current assets. Total assets of this company are $45,435 million as of 31st December 2013. Long-term asset consists of $393 million of long-term investments, $5,278 million of PPP, $13,046 million of goodwill, $2,514 million of Intangible assets and $3,040 million of other assets. Honeywell has $14,181 million of current liabilities as of 31st December 2013. It comprises of $5,174 of Accounts payable, $2,028 million of current portion of long-term debt and $6,979 million of other liabilities. Honeywell has the stockholders equity of $17,467 million. Retained earnings are of $20,383 million. The organization has common stock of $958 million.

The following table shows the balance sheet of Honeywell International Incorporation as of December 31, 2013:

Figure 2: Balance Sheet of Honeywell as on December 31, 2013

Balance Sheet (USD $ in millions)

Honeywell

Period Ending

Dec 31, 2013

Cash And Cash Equivalents

6,422

Short Term Investments

1,671

Net Receivables

7,909

Inventory

4,293

Other Current Assets

869

Total Current Assets

21,164

Long Term Investments

393

Property Plant and Equipment

5,278

Goodwill

13,046

Intangible Assets

2,514

Other Assets

3,040

Deferred Long Term Asset Charges

-

Total Assets

45,435

Accounts Payable

5,174

Short/Current Long Term Debt

2,028

Other Current Liabilities

6,979

Total Current Liabilities

14,181

Long Term Debt

6,801

Other Liabilities

6,182

Deferred Long Term Liability Charges

804

Total Liabilities

27,968

Stockholders' Equity

Common Stock

958

Retained Earnings

20,383

Other Stockholder Equity

(3,874)

Total Stockholder Equity

17,467

Source: Form 10-k of Honeywell International Incorporation

Honeywell’s Cash flow statement represents the net cash position and net changes in cash flow as of 31 July 2014. Honeywell’s Cash flow statement shows the total cash flow from operating activities is $4,335 million, total cash flow from investing activities is $(1,959) million and total cash flow from financing activities is $(433) million. The exchange rate effect is amounted to $(155) million. The following table shows the cash flow statement of Honeywell as of 31 December 2013:

Figure 3: Cash Flow Statement of Honeywell as on December 31, 2013

Cash Flow (USD $ in millions)

Honeywell

Period Ending

Dec 31, 2013

Net Income

3,962

Depreciation

989

Total Cash Flow From Operating Activities

4,335

Capital Expenditures

(947)

Investments

(1,012)

Total Cash Flows From Investing Activities

(1,959)

Dividends Paid

(1,353)

Total Cash Flows From Financing Activities

(433)

Effect Of Exchange Rate Changes

(155)

Change In Cash and Cash Equivalents

1,788

Source: Form 10-k of Honeywell International Incorporation

In the Honeywell’s statement of owner’s equity the ending balance of common stock is $5,640 million. The beginning balance of retained earnings is $17,799 million, comprehensive Net Income is $3,924 million and ending balance of Retained Earnings is $20,383 million. The total stockholder’s equity is $17,579 million that also includes the changes caused by treasury stock, accumulated other comprehensive loss and non-controlling interest. The following table represents the changes in common stock and retained earnings of the company for the period 2012 to 2013:

Figure 4: Owner’s Equity Statement of Honeywell as on December 31, 2013

Owner's Equity Statement (USD $ in millions)

Honeywell

Common stock and paid-in capital

Common Stock

958

Additional Paid-in Capital

4,682

Balance, end of period

5,640

Retained earnings (deficit)

Balance, beginning of period

17,799

Comprehensive Net income

3,924

Others

(1,340)

Balance, end of period

20,383

Treasury Stock

-9374

Accumulated Other Comprehensive Loss

818

Non-controlling Interest

112

Total stockholders’ equity

17,579

Source: (Honeywell, Annual Report, 2013)

Ratio Analysis

In this section the current ratio, cash ratio and quick ratio of Honeywell for the last five years have been calculated. Current ratio determines the firm’s capability to pay its short-term obligations with existing short-term assets (Horrigan, 1978). It is calculated by dividing total current assets by total current liabilities. The current ratio of Honeywell in December 2013, December 2012, December 2011, December 2010 and December 2009 is 1.5, 1.3, 1.3, 1.3 and 1.3 respectively. Quick ratio determines the firm’s capability to pay its short-term obligations with existing assets that are more liquid compared to that of current ratio. The denominator of quick ratio is summation of cash & cash equivalents with short term investment and account receivables and the numerator is current liabilities. The quick ratio of Honeywell in December 2013, December 2012, December 2011, December 2010 and December 2009 is 1.1, 1.0, 0.9, 0.8 and 0.8 respectively. The cash ratio determines how quickly the company can meet its obligations. The denominator of Cash ratio is summation of cash & cash equivalents and short term investment and the numerator is total current liabilities. The Cash ratio of Honeywell in December 2013, December 2012, December 2011, December 2010 and December 2009 is 0.6, 0.4, 0.3, 0.3 and 0.3respectively.We can conclude from these ratios that Honeywell’s capability to meet its obligations are not up to the mark. But, as the ratios are in an increasing trend we can expect that it will reach to a satisfactory level of ability to pay short-term liability. The trend of its liquidity ratios are given below in a chart:

Chart 1: Liquidity Position of Honeywell for the last five years

image1.png

In this section the Debt ratio, Debt to Equity ratio and Times Interest Earned ratio of Honeywell for the last five years have been calculated. The debt ratio represents the state of a company’s leverage (Nissim, 2001). It is calculated by dividing total liabilities by total assets. The Debt ratio of Honeywell in December 2013, December 2012, December 2011, December 2010 and December 2009 is 0.62, 0.69, 0.73, 0.72 and 0.75 respectively. The debt-equity ratio represents the proportion of debt and equity that are used to finance the assets. It is calculated by dividing total liabilities with total stockholders’ equity. The Debt-equity ratio of Honeywell in December 2013, December 2012, December 2011, December 2010 and December 2009 is 160%, 223%, 268%, 255% and 306% respectively. The times interest earned measures the company’s ability to pay its interest .It is calculated by dividing the interest expense with net income. The times interest earned ratio of Honeywell in December 2013, December 2012, December 2011, December 2010 and December 2009 is 0.083, 0.120, 0.202, 0.197 and 0.3.respectively. We can conclude from these ratios that Honeywell’s capability to meet its long-term debt obligations is in an increasing trend .The trend of its debt ratios are given below in a chart:

Chart 2: Long term debt paying ability of Honeywell for the last five years

image2.png

In this section the profitability ratios of Honeywell for the last five years have been calculated. Profitability ratio measures a company’s capability to generate revenues in comparison with its costs and other expenses that are incurred in a period of time. (Morley, 1984). I have estimated the profit margin ratio, return on asset and return on equity ratio .The profit margin ratio assesses how much of each dollar the company retains in its earnings from its sales. It is calculated by dividing net income with total revenues. The Profit margin ratio of Honeywell in December 2013, December 2012, December 2011, December 2010 and December 2009 is 10%, 8%, 5%, 6% and 5% respectively. The return on assets (ROA) assesses how efficiently the management is utilizing the company’s assets to generate earnings. It is calculated by dividing net income with total assets. The ROA ratio of Honeywell in December 2013, December 2012, December 2011, December 2010 and December 2009 is 9%, 7%, 5%, 5% and 4% respectively. The return on equity (ROE) assesses the firm’s profitability by finding out how much earnings the company is generating with the money invested by equity holders. It is calculated by dividing net income applicable to common stockholders’ with the total stockholders’ equity. The ROE ratio of Honeywell in December 2013, December 2012, December 2011, December 2010 and December 2009 is 23%, 23%, 17%, 18% and 17% respectively. We can conclude from these ratios that profitability is in an increasing trend and they are consistent. The trend of its profitability ratios are given below in a chart:

Chart 3: Profitability of Honeywell for the last five years

image3.png

In this section the asset utilization and management efficiency ratios of Honeywell for the last five years have been calculated. I have estimated the total asset turnover, inventory turnover and account receivable turnover. The total asset turnover measures a firm’s efficiency in generating earnings by using its assets. (Horrigan, 1967)It is calculated by dividing total revenue with average total assets. The total asset turnover of Honeywell in December 2013, December 2012, December 2011, December 2010 and December 2009 is 0.9, 0.9, 0.9, 0.9and 0.8 respectively. The inventory turnover assesses a firm’s ability to manage and maintain its inventory. It is calculated by dividing cost of revenue with the average inventory. The inventory turnover of Honeywell in December 2013, December 2012, December 2011, December 2010 and December 2009 is 7,7,7,7 and 7 respectively .The account receivable turnover assesses the firm’s efficiency in providing credit and collecting debts. It is calculated by dividing net total revenues with average account receivables. The account receivable turnover of Honeywell in December 2013, December 2012, December 2011, December 2010 and December 2009 is 5,5,5,5 and 10 respectively. These ratios are more or less consistent over the five years. So, we can conclude that the firm is showing efficiency in asset utilization and management. The trend of its efficiency ratios are given below in a chart:

Chart 4: Asset Utilization ratio of Honeywell for the last five years

image4.png

In this section the price to earnings ratio, earnings per share ratio and dividend payout ratio of Honeywell for the last five years have been calculated. The earnings multiplier assesses a firm’s current share price compared to the firm’s earning (Nissim, 2001) .It is estimated by dividing price per share with earnings per share. The price to earnings ratio of Honeywell in December 2013, December 2012, December 2011, December 2010 and December 2009 is 15,16,23,17and 17 respectively. The earning per share (EPS) is part of the company’s profit that is assigned to each outstanding share. It is estimated by dividing net income applicable to common shareholders’ with number of shares outstanding. The earnings per share ratio of Honeywell in December 2013, December 2012, December 2011, December 2010 and December 2009 is 5.05, 3.74, 2.41, 2.50and 2.0 respectively. Here we can see that the trend of EPS signifies that the organization is earning satisfactory return for its stockholders. The dividend payout ratio is a tool which determines the organization’s percentage of earnings paid to its stockholders. It is estimated by dividing dividend per share with earning per share. The dividend payout of Honeywell in December 2013, December 2012, December 2011, December 2010 and December 2009 is 1.68, 1.53, 1.37, 1.21 and 1.21 respectively (NASDAQ, 2014). The trend of its market measures are given below in a chart:

Chart 5: Market measures of Honeywell for the last five years

image5.png

Comparative Analysis with Major Competitor and Industry

In this section I have shown the multiples and different ration analysis of Honeywell and that of the respective industry. This section represents the available comparable ratios that are collected from websites cited in the references. In this section the comparable ratios and multiples of Honeywell Corporation and of the respective Business Software & Service industry is analyzed. Here I have considered available comparable ratios of the industry from the website cited in the reference page. The analysis includes P/E ratio, ROE ratio, dividend yield, debt to equity ratio, price to book value ratio, profit margin, and the market capital. The table below shows the results of each ratio of Honeywell and the respective industry:

Figure 5: Comparative Analysis with Industry, in 2013

Comparables

Industry

Honeywell

Market Capitalization:(in billions)

$8,823.0

$ 74.3

Price / Earnings:

22.7

15.38

Price / Book:

15.40

4.13

Net Profit Margin

9.5%

10.1%

Return on Equity

14.00%

23%

Total Debt / Equity

479.00

160.00

Dividend Yield

2.20%

2.50%

The above table shows that Market Capitalization of Honeywell is 0.84% of the industry. The Price/earnings ratio and Price/Book value ratio of Honeywell are lower than that of the industry average.Net profit margin of Honeywell is higher than that of the industry. Return on Equity of Honeywell is very high than that of the industry average. Debt to equity ratio is lower than that of the industry. It indicates a positive result of the company. The company is providing higher dividend yield than that of the industry.

The table below represents the comparison between the selected company and the largest competitor selected as the benchmark company:

Figure 6: Comparative Analysis with major competitor, in 2013

Financial diagnostic categories

 Chosen company      (Honeywell)

 Benchmark competitor

(Boeing)

1.)   Liquidity of short-term assets

Current ratio

1.49

Current ratio

1.26

Cash ratio

0.57

Cash ratio

0.30

Quick ratio

1.13

Quick ratio

0.42

2.)   Long-term debt-paying ability

Debt ratio

0.62

Debt ratio

0.84

Debt-equity ratio

0.39

Debt-equity ratio

0.54

3.)   Profitability

Net income/sales (profit margin)

0.10

Net income/sales (profit margin)

0.05

Net income/assets (ROA)

0.09

-Net income/assets (ROA)

0.05

Net income/shareholder equity  (ROE)

0.23

Net income/shareholder equity  (ROE)

0.31

4.)   Asset utilization/ management efficiency

Total asset turnover

0.89

Total asset turnover

0.95

Inventory turnover   measures

6.65

Inventory turnover   measures

1.82

Accounts receivable turnover

5.11

Accounts receivable turnover

14.25

5.)   Market measures

Price/earnings ratio

15.38

Price/earnings ratio

17.06

Earnings per common share

5.05

Earnings per common share

6.03

Dividend payout

0.33

Dividend payout

1.94

Honeywell has higher liquidity position than the benchmark competitor. Honeywell has lower leverage than the benchmark company. We can also see that Honeywell has better profitability status than the benchmark company. But the benchmark company has higher ROE than Honeywell. The efficiency level of both of the organizations is reasonable. The market measures of both companies are also satisfactory.

Analysis of Key Statistics

The total dollar value of all outstanding shares of Honeywell is $74.26 billion. The PEG ratio is 1.65 against its projected 5-year growth. So, it indicates a positive result. The adjusted EPS is 4.99 which is satisfactory. Beta coefficient is 1.29.It is not perfectly correlated with the market. The 52-week change and S&P 52-week change show that the share price has fluctuated slightly.50 day moving average price is $93.21 and 200-day moving average price is $91.96. The expected dividend in the current year is 1.8.The 5-year average dividend yield is 2.5% and also forward annual dividend yield is 1.9%. There is a table below which presents the key statistics of the company:

Figure 7: Key Statistics in 2013

Market Cap

74.26 B

PEG Ratio (5 yr expected):

1.65

Diluted EPS

4.99

Beta:

1.29

52-Week Change

23.71%

S&P500 52-Week Change

24.78%

50-Day Moving Average

93.21

200-Day Moving Average

91.96

Forward Annual Dividend Rate

1.8

Forward Annual Dividend Yield

1.90%

Trailing Annual Dividend Yield

1.76

Trailing Annual Dividend Yield

1.90%

5 Year Average Dividend Yield

2.50%

Payout Ratio

34.00%

Source: Yahoo Finance

Historical Stock Price Analysis

We have collected the historical monthly prices data of the 5 years starting from 2009 to 2013. The purpose of this data collection is to forecast the next year’s stock price. I have used moving average for this purpose. At first, I opened Microsoft excel software and then data analysis toolpack to estimate the moving average. From this analysis, I conclude that the stock price is $87.63 for the next year.

To decide if the corporation’s stock is a good buy or sell the historical monthly prices data of the 5 years period from January 2010 to December 2013 of Honeywell Corporation is used here. To forecast the stock price for the next year I have used the moving average technique in the excel spreadsheet from data analysis tool pack. From the moving average method, the forecasted stock price is $37.33 for the next year. There is as graph below which presents the firm’s historical share price and the trend of the forecasted value through moving average:

Chart 6: Forecasted future price of Honeywell

image6.png

The above forecast is reasonable, reliable and in line with the firm’s continuing high performance and high profitability. The dividend payment forecast is 1.9%. This is in line with the firm’s forecasted price.

Relevant Information Analysis

Honeywell’s capital structure represents that it is using 39% of equity and 61% of debt to finance its activities. Although it may seem higher but it is much lower than the industry benchmark. Again, it makes Honeywell exposed to financial risk. Honeywell’s dividend policy is motivating and attractive to investors. It shows stability and consistency during the last five years. Honeywell has low price to earnings ratio compared to that of industry average. It signifies that Honeywell is a less risky corporation to invest in. The volatility of its stock is low according to the experts’ opinion. The market information of this company is also available. The stocks are fairly valued. The bankruptcy risk is very low. It has a low-key hype condition. It almost mirrors the market. So, all these information provides a positive sign that it will provide a high performance in the long run. The Honeywell is also a great place for the employees. With its global customers, broad range of industries and combination of innovative technologies offer dynamic career opportunities to the employees. Employee review of the company showed-Honeywell is a great place to work, ensures equality, rewards better performance, provides pleasant work environment, emphasize team work and interpersonal relationship building, productive and great place for shaping future career (Employee Review, 2014). So Honeywell obviously is a great place to invest my human and intellectual capital.

Honeywell is a Fortune 100 diversified technology leader. It is also tapping natural gas and oil sector in Asia. (Press Release, 2014). The company is taking enormous forward looking initiatives to maximize the performance. They have brought huge change in the corporate ledaership. (Press Release, 2014). They have added up to dated technology for better performnece. The company’s organic segment is growing at 7% for last two years. Their pension costs are mark to the market. The company beat earnings expectations of $1 per share and saw its EPS climb 15% on 2012. (Foster, 2012) They are implenting unique strategical tactics to beat their major competitor like Boeing. So investor experienced a thriving business model of Honeywell which is an impressive feat for the future investment.

Recommendation & Justification

From above mentioned analysis it is clear to me that, the stock is a very good buy. I would definitely invest my financial capital in the Honeywell International Incorporation. I would also like to invest my human and intellectual capital in the firm as a respectable employee. On the basis of my above analysis and explanations it can be said that the company will have potential growth in the long-run. Honeywell is running its business with global presence in diversified fields for many years with high reputation. It is also entering new markets and new business fields. The performance of Honeywell aligns with the high profitability, efficiency and continuous development. The company is also competing efficiently and tactically with competitors. So adding Honeywell in my portfolio will enhance value of the portfolio manifold.

.

References

Boeing. (2014). The Boeing Company. Retrieved June 22, 2014, from Boeing.com: http://www.boeing.com/boeing

Employee Review. (2014, June). Honeywell Employer Reviews. Retrieved June 22, 2014, from Indeed: http://www.indeed.com/cmp/Honeywell/reviews

Finance, Y. (2014). Stock Market, Quotes, News. . Retrieved June 22, 2014, from Yahoo Finance: http://finance.yahoo.com

Foster, M. (2012, January 27). Do Honeywell's Bad Earnings Make it a Good Buy? Retrieved June 23, 2014, from Benzinga: http://www.benzinga.com/news/earnings/12/01/2295349

Honeywell. (2013). Annual Report. Honeywell.

Honeywell. (2014). Honeywell -Fundamentals - Trading Statistics. Retrieved June 22, 2014, from Honeywell.com: http://investor.honeywell.com/phoenix.zhtml?c=94774&p=irol-fundTrading

Horrigan, J. (1967). An evaluation of financial ratio analysis (1st ed.). Chicago: University of Chicago.

Horrigan, J. (1978). Financial ratio analysis (1st ed.). New York: Arno Press.

Morley, M. (1984). Ratio analysis (1st ed.). : Published for the Institute of Chartered Accountants of Scotland . Berkshire, England: Gee & Co.

NASDAQ. (2014). Company Performance.

Nissim, D. &. (2001). Ratio analysis and equity valuation: From research to practice. Review Of Accounting Studies , 109-154.

Press Release. (2014). Honeywell Automation, Safety Technology Selected For Third Phase Of Central Asia-to-China Natural Gas Pipeline Project. Honeywell.

Appendix

A 1: Income Statement- Honeywell International Incorporation

Income Statement (USD $ in millions)

Honeywell

Period Ending

Dec 31, 2013

Dec 31, 2012

Dec 31, 2011

Dec 31, 2010

Dec 31, 2009

Total Revenue

39,055

37,665

36,529

32,350

29,951

Cost of Revenue

28,364

28,291

28,556

24,721

23,260

Gross Profit

10,691

9,374

7,973

7,629

6,691

Research Development

-

-

-

-

-

Selling General and Administrative

5,190

5,218

5,399

4,618

4,323

Non Recurring

8

2

36

(42)

47

Total Operating Expenses

5,198

5,220

5,435

4,576

4,370

Operating Income or Loss

5,493

4,154

2,538

3,053

2,321

Total Other Income/Expenses Net

246

72

120

55

101

Earnings Before Interest And Taxes

5,739

4,226

2,658

3,108

2,422

Interest Expense

327

351

376

386

458

Income Before Tax

5,412

3,875

2,282

2,722

1,964

Income Tax Expense

1,450

944

417

765

436

Net Income

3,962

2,931

1,865

1,957

1,528

Net Income To Common Shares

3,962

2,931

1,865

1,957

1,528

EPS

5.05

3.74

2.41

2.50

2.00

Shares

784

783

775

783

764

DPS

1.68

1.53

1.37

1.21

1.21

Price per share

77.73

58.71

54.87

43.18

33.27

A 2: Balance Sheet of Honeywell International Incorporation

Balance Sheet (USD $ in millions)

Honeywell

Period Ending

Dec 31, 2013

Dec 31, 2012

Dec 31, 2011

Dec 31, 2010

Dec 31, 2009

Cash And Cash Equivalents

6,422

4,634

3,698

2,650

2,801

Short Term Investments

1,671

631

484

455

381

Net Receivables

7,909

7,376

7,228

6,841

6,274

Inventory

4,293

4,235

4,264

3,822

3,446

Other Current Assets

869

722

460

1,718

1,034

Total Current Assets

21,164

17,598

16,134

15,486

13,936

Long Term Investments

393

623

362

413

262

Property Plant and Equipment

5,278

5,001

4,804

4,724

4,847

Goodwill

13,046

12,425

11,858

11,275

10,494

Intangible Assets

2,514

2,449

2,477

2,537

2,174

Other Assets

3,040

3,757

4,041

3,196

3,963

Deferred Long Term Asset Charges

-

-

132

203

317

Total Assets

45,435

41,853

39,808

37,834

35,993

Accounts Payable

5,174

4,736

4,738

4,199

3,633

Short/Current Long Term Debt

2,028

1,101

674

889

1,361

Other Current Liabilities

6,979

7,208

6,863

6,636

6,153

Total Current Liabilities

14,181

13,045

12,275

11,724

11,147

Long Term Debt

6,801

6,395

6,881

5,755

6,246

Other Liabilities

6,182

8,810

9,170

9,053

9,197

Deferred Long Term Liability Charges

804

628

676

636

542

Total Liabilities

27,968

28,878

29,002

27,168

27,132

Stockholders' Equity

Common Stock

958

958

958

958

958

Retained Earnings

20,383

17,799

16,083

15,097

14,023

Other Stockholder Equity

(3,874)

(5,782)

(6,235)

(5,389)

(6,120)

Total Stockholder Equity

17,467

12,975

10,806

10,666

8,861

A 3: Cash Flow statement of Honeywell International Incorporation

Cash Flow (USD $ in millions)

Honeywell

Period Ending

Dec 31, 2013

Dec 31, 2012

Dec 31, 2011

Dec 31, 2010

Dec 31, 2009

Net Income

3,962

2,926

2,067

2,022

1,548

Depreciation

989

926

957

987

957

Total Cash Flow From Operating Activities

4,335

3,517

2,833

4,203

3,946

Capital Expenditures

(947)

(884)

(798)

(651)

(609)

Investments

(1,012)

(544)

187

(1,618)

(524)

Total Cash Flows From Investing Activities

(1,959)

(1,428)

(611)

(2,269)

(1,133)

Dividends Paid

(1,353)

(1,211)

(1,091)

(944)

(918)

Total Cash Flows From Financing Activities

(433)

(1,206)

(1,114)

(2,047)

(2,152)

Effect Of Exchange Rate Changes

(155)

53

(60)

(38)

75

Change In Cash and Cash Equivalents

1,788

936

1,048

(151)

736

A 4: Owners’ equity statement- Honeywell International Incorporation

Owner's Equity Statement (USD $ in millions)

Honeywell

Common stock and paid-in capital

2013

2012

2011

2010

2009

Common Stock

958

958

958

958

958

Additional Paid-in Capital

4,682

4,358

4,157

3,977

3,823

Balance, end of period

5,640

5,316

5,115

4,935

4,781

Retained earnings (deficit)

Balance, beginning of period

17,799

16,083

15,097

14,023

13,391

Comprehensive Net income

3,924

2,926

2,067

2,022

1,548

Others

(1,340)

(1,210)

(1,081)

(948)

(916)

Balance, end of period

20,383

17,799

16,083

15,097

14,023

Treasury Stock

-9374

-8801

-8948

-8299

-8955

Accumulated Other Comprehensive Loss

818

-1339

-1444

-1067

-948

Non-controlling Interest

112

90

96

121

110

Total stockholders’ equity

17,579

13,065

10,902

10,787

9,011

A 5: Income statement of The Boeing Company

Income Statement (USD $ in millions)

Boeing

Period Ending

Dec 31, 2013

Dec 31, 2012

Dec 31, 2011

Dec 31, 2010

Dec 31, 2009

Total Revenue

86,623

81,698

68,735

64,306

68,281

Cost of Revenue

73,268

68,644

55,867

51,843

56,540

Gross Profit

13,355

13,054

12,868

12,463

11,741

Research Development

3,071

3,298

3,918

4,121

6,506

Selling General and Administrative

3,956

3,717

3,408

3,644

3,364

Total Operating Expenses

7,027

7,015

7,326

7,765

9,870

Operating Income or Loss

6,328

6,039

5,542

4,698

1,871

Total Other Income/Expenses Net

299

337

348

326

201

Earnings Before Interest And Taxes

6,627

6,376

5,890

5,024

2,072

Interest Expense

386

463

498

516

339

Income Before Tax

6,241

5,913

5,392

4,508

1,733

Income Tax Expense

1,646

2,007

1,382

1,196

396

Discontinued Operations

1

3

(7)

4

23

Net Income

4,596

3,909

4,003

3,316

1,360

Net Income To Common Shares

4,596

3,909

4,003

3,316

1,360

EPS

6.03

5.15

5.38

4.50

1.89

Shares

762

759

744

737

720

DPS

1.94

1.76

1.68

1.68

1.68

Price Per Share

102.8966667

70.2533333

66.5025

60.26

39.78583333

A 6: Balance sheet of The Boeing Company

Balance Sheet (USD $ in millions)

Boeing

Period Ending

Dec 31, 2013

Dec 31, 2012

Dec 31, 2011

Dec 31, 2010

Dec 31, 2009

Cash And Cash Equivalents

9,088

10,341

10,049

5,359

9,215

Short Term Investments

6,170

3,217

1,223

5,158

2,008

Net Receivables

6,546

5,608

5,793

5,422

5,785

Inventory

42,912

37,751

32,240

24,317

16,933

Other Current Assets

358

392

505

316

1,334

Total Current Assets

65,074

57,309

49,810

40,572

35,275

Long Term Investments

1,204

1,180

1,043

1,111

1,030

Property Plant and Equipment

10,224

9,660

9,313

8,931

8,784

Goodwill

5,043

5,035

4,945

4,937

4,319

Intangible Assets

3,052

3,111

3,044

2,979

2,877

Other Assets

5,127

5,848

5,939

6,004

6,706

Deferred Long Term Asset Charges

2,939

6,753

5,892

4,031

3,062

Total Assets

92,663

88,896

79,986

68,565

62,053

Accounts Payable

9,498

9,394

8,406

7,715

7,096

Short/Current Long Term Debt

1,563

1,436

2,353

948

707

Other Current Liabilities

40,425

34,152

30,515

26,732

25,080

Total Current Liabilities

51,486

44,982

41,274

35,395

32,883

Long Term Debt

8,072

8,973

10,018

11,473

12,217

Other Liabilities

1,106

1,795

1,029

1,010

1,364

Deferred Long Term Liability Charges

17,002

27,179

24,057

17,825

13,364

Total Liabilities

77,666

82,929

76,378

65,703

59,828

Stockholders' Equity

Common Stock

5,061

5,061

5,061

5,061

5,061

Retained Earnings

32,964

30,037

27,524

24,784

22,746

Other Stockholder Equity

(23,028)

(29,131)

(28,977)

(26,983)

(25,582)

Total Stockholder Equity

14,997

5,967

3,608

2,862

2,225

A7: Cash Flow statement of The Boeing Company

Cash Flow (USD $ in millions)

Boeing

Period Ending

Dec 31, 2013

Dec 31, 2012

Dec 31, 2011

Dec 31, 2010

Dec 31, 2009

Net Income

4,585

3,900

4,018

3,307

1,312

Depreciation

1,844

1,811

1,675

1,746

1,678

Total Cash Flow From Operating Activities

8,179

7,508

4,023

2,952

5,603

Capital Expenditures

(2,047)

(1,606)

(1,619)

(1,062)

(1,159)

Investments

(2,941)

(2,020)

3,961

(3,123)

(1,588)

Total Cash Flows From Investing Activities

(5,154)

(3,757)

2,369

(4,831)

(3,794)

Dividends Paid

(1,467)

(1,322)

(1,244)

(1,253)

(1,220)

Total Cash Flows From Financing Activities

(4,249)

(3,477)

(1,700)

(1,962)

4,094

Effect Of Exchange Rate Changes

(29)

18

(2)

(15)

44

Change In Cash and Cash Equivalents

(1,253)

292

4,690

(3,856)

5,947

A 8: Owners’ equity statement of The Boeing Company

Owner's Equity Statement (USD $ in millions)

Boeing

Common stock and paid-in capital

2013

2012

2011

2010

2009

Common Stock

5,061

5,061

5,061

5,061

5,061

Additional Paid-in Capital

4,415

4,122

4,033

3,866

3,724

Balance, end of period

9,476

9,183

9,094

8,927

8,785

Retained earnings (deficit)

Balance, beginning of period

30,037

27,524

24,784

22,746

22,675

Comprehensive Net income

4,585

3,900

4,018

3,307

1,312

Others

(1,658)

(1,387)

(1,278)

(1,269)

(1,241)

Balance, end of period

32,964

30,037

27,524

24,784

22,746

Treasury Stock

(17,671)

(15,937)

(16,603)

(17,187)

(15,911)

Share-Value Trust

-

-

-

-

(1,615)

Accumulated Other Comprehensive Loss

(9,894)

(17,416)

(16,500)

(13,758)

(11,877)

Non-controlling Interest

122

100

93

96

97

Total stockholders’ equity

14,997

5,967

3,608

2,862

2,225

A 9: Ratios of Honeywell International Incorporation

 Chosen company      

Dec 31, 2013

Dec 31, 2012

Dec 31, 2011

Dec 31, 2010

Dec 31, 2009

-Current ratio

1.5

1.3

1.3

1.3

1.3

-Cash ratio

0.6

0.4

0.3

0.3

0.3

-Quick ratio

1.1

1.0

0.9

0.8

0.8

-Debt ratio

0.62

0.69

0.73

0.72

0.75

-Debt-equity ratio

1.60

2.23

2.68

2.55

3.06

-Times interest earned

0.083

0.120

0.202

0.197

0.300

-profit margin

10%

8%

5%

6%

5%

-ROA

9%

7%

5%

5%

4%

-ROE

23%

23%

17%

18%

17%

-Total asset turnover

0.9

0.9

0.9

0.9

0.8

-Inventory turnover

7

7

7

7

7

-Accounts receivable turnover

5

5

5

5

10

-Price/earnings ratio

15

16

23

17

17

-Earnings per common share

5.05

3.74

2.41

2.50

2.00

-Dividend payout

33%

41%

57%

48%

61%

A 10: Ratios of the Boeing Company

 Benchmark competitor

Dec 31, 2013

Dec 31, 2012

Dec 31, 2011

Dec 31, 2010

Dec 31, 2009

-Current ratio

1

1

1

1

1

-Cash ratio

0

0

0

0

0

-Quick ratio

0

0

0

0

1

-Debt ratio

84%

93%

95%

96%

96%

-Debt-equity ratio

518%

1390%

2117%

2296%

2689%

-Times interest earned

0.083986075

0.118444615

0.124406695

0.155609168

0.24926471

-profit margin

5%

5%

6%

5%

2%

-ROA

5%

4%

5%

5%

2%

-ROE

31%

66%

111%

116%

61%

-Total asset turnover

1.0

1.0

0.9

1.0

1.1

-Inventory turnover   measures

2

2

0

0

0

-Accounts receivable turnover

14

14

12

11

12

-Price/earnings ratio

17

14

12

13

21

-Earnings per common share

6.03

5.15

5.38

4.50

1.89

-Dividend payout

0.32172471

0.341747573

0.312267658

0.373333333

0.88888889

A 11: Moving Average Price Data

Date

Adj Close*

Moving Average

87.63

86.13

12/2/2013

88.48

83.45

4.8

11/1/2013

86.77

82.46

3.3

10/1/2013

83.13

81.37

5.6

9/3/2013

80.44

80.74

6.1

8/1/2013

83.8

77.20

7.2

7/1/2013

79.86

75.65

6.6

6/3/2013

78.55

72.70

7.4

5/1/2013

73.2

71.29

8.2

4/1/2013

75.2

67.78

8.2

3/1/2013

69.71

65.07

7.3

2/1/2013

68.97

62.50

5.2

1/2/2013

64.67

61.06

3.9

12/3/2012

61.56

60.04

3.7

11/1/2012

61.26

59.08

4.0

10/1/2012

60.37

57.61

4.0

9/4/2012

58.48

56.18

4.1

8/1/2012

58.4

56.88

3.3

7/2/2012

55.94

58.42

2.9

6/1/2012

54.21

60.13

3.1

5/1/2012

60.48

59.52

4.3

4/2/2012

60.57

57.76

5.9

3/1/2012

59.35

55.93

8.8

2/1/2012

58.64

53.34

8.8

1/3/2012

55.28

49.43

8.3

12/1/2011

53.88

47.38

8.1

11/1/2011

50.86

48.43

9.8

10/3/2011

43.55

53.75

10.5

9/1/2011

47.74

57.62

7.9

8/1/2011

54.01

60.18

4.9

7/1/2011

59.49

60.33

2.9

6/1/2011

59.37

59.91

4.5

5/2/2011

61.67

58.12

6.2

4/1/2011

59.96

55.97

7.8

3/1/2011

58.09

53.41

8.7

2/1/2011

56.32

50.28

9.7

1/3/2011

53.49

47.19

8.4

12/1/2010

50.41

43.58

7.0

11/1/2010

46.93

42.49

3.3

10/1/2010

44.22

40.75

4.9

9/1/2010

39.59

41.63

4.7

8/2/2010

43.66

43.01

4.9

7/1/2010

38.99

45.19

4.5

6/1/2010

42.24

44.52

4.9

5/3/2010

47.81

41.56

4.9

4/1/2010

45.51

39.59

3.9

3/1/2010

40.25

39.09

2.9

2/1/2010

38.92

38.12

2.5

1/4/2010

39.61

37.29

1.9

12/1/2009

38.75

36.59

3.3

11/2/2009

36

36.26

3.5

10/1/2009

37.11

34.42

3.8

9/1/2009

36.66

33.42

4.1

8/3/2009

35.01

32.14

5.0

7/1/2009

31.59

30.85

4.8

6/1/2009

33.65

28.42

4.3

5/1/2009

31.17

28.80

4/1/2009

27.74

30.53

3/2/2009

26.34

2/2/2009

32.32

1/2/2009

32.93