International Business Financial Statements Trends

This module enables investors to look at International Business various fundamental indicators over time in order to gain insight into the company future performance. Macroaxis historical fundamental analysis tools allow evaluation of not only typical financial statement drivers such as Consolidated Income of 13.2 B, Cost of Revenue of 43.5 B or Earning Before Interest and Taxes EBIT of 15.4 B, but also many exotic indicators such as Interest Coverage of 31.5157, Long Term Debt to Equity of 2.2332 or Calculated Tax Rate of 10.436. This module is a perfect complement to use when analyzing International Business Valuation or Volatility. It can also complement various International Business Technical models. Please also check Risk vs Return Analysis.

Balance Sheet

Current ValueLast YearHistorical Average 10 Year Trend
Accumulated Other Comprehensive Income(31.1 B)(29.4 B)(21.8 B)
Decreasing
Slightly volatile
Total Assets110.5 B117.5 B113.7 B
Increasing
Slightly volatile
Current Assets42.5 B43.9 B47.2 B
Decreasing
Slightly volatile
Assets Non Current74.5 B73.6 B67 B
Increasing
Slightly volatile
Cash and Equivalents12.6 B7.8 B10.3 B
Decreasing
Stable
Cash and Equivalents USD8.2 B7.8 B10 B
Decreasing
Slightly volatile
Total Debt46.8 B42.2 B35.9 B
Increasing
Slightly volatile
Debt Current7.4 B7.5 B8.1 B
Decreasing
Slightly volatile
Debt Non Current35.8 B34.7 B27.6 B
Increasing
Slightly volatile
Total Debt USD43.2 B42.2 B35.7 B
Increasing
Slightly volatile
Deferred Revenue15.5 B14.6 B14.7 B
Increasing
Slightly volatile
Shareholders Equity17.1 B18.2 B19.4 B
Decreasing
Slightly volatile
Shareholders Equity USD17.1 B18.2 B19.4 B
Decreasing
Slightly volatile
Goodwill and Intangible Assets40.2 B40.9 B29.4 B
Increasing
Slightly volatile
Inventory1.6 B1.6 B2.3 B
Decreasing
Slightly volatile
Investments5.8 B5.3 B5.8 B
Decreasing
Slightly volatile
Investments Current636.3 M701 M692.6 M
Decreasing
Very volatile
Investments Non Current5.1 B4.6 B5.2 B
Decreasing
Slightly volatile
Total Liabilities102.7 B99.1 B94.9 B
Increasing
Slightly volatile
Current Liabilities34.3 B36.3 B38.8 B
Decreasing
Slightly volatile
Liabilities Non Current65.6 B62.8 B55.8 B
Increasing
Slightly volatile
Trade and Non Trade Payables6.4 B6.2 B7.2 B
Decreasing
Slightly volatile
Property Plant and Equipment Net11.3 B10.8 B13.1 B
Decreasing
Slightly volatile
Trade and Non Trade Receivables40.4 B38.3 B40.1 B
Increasing
Very volatile
Accumulated Retained Earnings Deficit157.3 B152.8 B110.3 B
Increasing
Slightly volatile
Tax Assets5.3 B5.2 B5.2 B
Increasing
Stable
Tax Liabilities3.2 B3.2 B3.8 B
Decreasing
Stable

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Consolidated Income13.2 B11.9 B13.1 B
Increasing
Stable
Cost of Revenue43.5 B41.6 B49.6 B
Decreasing
Slightly volatile
Earning Before Interest and Taxes EBIT15.4 B13 B17 B
Decreasing
Very volatile
Earning Before Interest and Taxes USD15.4 B13 B17 B
Decreasing
Very volatile
Gross Profit38.3 B38.3 B43.1 B
Decreasing
Very volatile
Interest Expense577.9 M630 M488.5 M
Increasing
Slightly volatile
Net Income5.8 B11.9 B12.5 B
Decreasing
Very volatile
Net Income Common Stock13.2 B11.9 B13.1 B
Increasing
Stable
Net Income Common Stock USD13.2 B11.9 B13.1 B
Increasing
Stable
Net Income from Discontinued Operations96.3 M9 M2.5 B
Decreasing
Slightly volatile
Operating Expenses26.1 B25.3 B26 B
Increasing
Stable
Operating Income15.5 B13 B17.4 B
Decreasing
Very volatile
Preferred Dividends Income Statement Impact11.8 M10 M10.1 M
Increasing
Slightly volatile
Revenues79.1 B79.9 B92.5 B
Decreasing
Slightly volatile
Revenues USD85.1 B79.9 B93 B
Decreasing
Slightly volatile
Research and Development Expense4.6 B4.1 B4.6 B
Decreasing
Stable
Selling General and Administrative Expense21.8 B21.1 B21.8 B
Increasing
Stable
Weighted Average Shares925.8 M955.4 M1.2 B
Decreasing
Slightly volatile
Weighted Average Shares Diluted1 B958.7 M1.2 B
Decreasing
Slightly volatile
Income Tax Expense1.6 B449 M3.4 B
Decreasing
Slightly volatile

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(4 B)(3.7 B)(4.1 B)
Increasing
Slightly volatile
Depreciation Amortization and Accretion4.3 B4.4 B4.7 B
Decreasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents(342.1 M)140 M182.2 M
Decreasing
Slightly volatile
Net Cash Flow Business Acquisitions and Disposals(5.2 B)(6.1 B)(3.2 B)
Decreasing
Slightly volatile
Issuance Purchase of Equity Shares(4 B)(3.3 B)(8.1 B)
Increasing
Slightly volatile
Issuance Repayment of Debt Securities 66.8 M26 M(99.3 M)
Decreasing
Very volatile
Payment of Dividends and Other Cash Distributions (5.3 B)(5.3 B)(3.7 B)
Decreasing
Slightly volatile
Net Cash Flow from Financing(7.9 B)(5.8 B)(9.9 B)
Increasing
Very volatile
Net Cash Flow from Investing(10.1 B)(11 B)(7.6 B)
Decreasing
Slightly volatile
Net Cash Flow Investment Acquisitions and Disposals(918.4 M)(1.1 B)(308.9 M)
Decreasing
Slightly volatile
Net Cash Flow from Operations8.6 B17 B17.1 B
Decreasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (275.8 M)(51 M)(142.7 M)
Decreasing
Slightly volatile
Share Based Compensation532.6 M544 M630.9 M
Decreasing
Slightly volatile
Cash Beginning of Year8.5 B7.7 B10.2 B
Decreasing
Slightly volatile
Cash End of Year8.2 B7.8 B10.7 B
Decreasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Asset Turnover0.74580.680.8368
Decreasing
Slightly volatile
Book Value per Share17.865319.23516.7328
Increasing
Stable
Current Ratio1.331.211.2244
Increasing
Stable
Debt to Equity Ratio2645.4325.0863
Increasing
Slightly volatile
Share Dilution Ratio1.18121.0041.0238
Increasing
Slightly volatile
Dividend Yield0.03630.0330.0225
Increasing
Slightly volatile
Dividends per Basic Common Share5.52635.53.4059
Increasing
Slightly volatile
EBITDA Margin0.24370.2170.2329
Increasing
Slightly volatile
Earnings per Basic Share13.636812.4311.4874
Increasing
Slightly volatile
Earnings per Diluted Share6.1412.3810.8085
Increasing
Slightly volatile
EPS Diluted Growth0.15030.12770.184
Decreasing
Slightly volatile
EPS Growth0.14840.12610.1826
Decreasing
Slightly volatile
Earnings per Basic Share USD13.636812.4311.4874
Increasing
Slightly volatile
Enterprise Value over EBIT12.631614.011.587
Increasing
Very volatile
Enterprise Value over EBITDA10.095811.0369.3748
Increasing
Very volatile
Free Cash Flow per Share13.6113.84911.9581
Increasing
Slightly volatile
Gross Margin0.51420.4790.4684
Increasing
Slightly volatile
Financial Leverage1.14260.97120.9864
Increasing
Slightly volatile
Leverage Ratio9.78348.31596.446
Increasing
Slightly volatile
NCFO Growth0.00980.00830.0183
Decreasing
Slightly volatile
Net Income Growth0.11430.09720.1413
Decreasing
Slightly volatile
Profit Margin0.07270.1490.1342
Increasing
Stable
Payout Ratio0.42790.4420.2844
Increasing
Slightly volatile
Price to Book Value8.218.659.0345
Increasing
Stable
Price to Earnings Ratio25.4613.35414.7821
Decreasing
Very volatile
Price to Sales Ratio1.831.9841.8722
Increasing
Very volatile
Revenue Growth(0.1401)(0.1191)(0.0285)
Decreasing
Slightly volatile
Return on Average Assets0.06070.1010.1123
Decreasing
Stable
Return on Average Equity0.31890.720.6647
Increasing
Slightly volatile
Return on Invested Capital0.20680.1710.2428
Decreasing
Stable
Return on Sales0.190.1620.1824
Increasing
Stable
Weighted Average Share Growth(0.0299)(0.0254)(0.0388)
Decreasing
Very volatile
Sales per Share87.981183.64880.2915
Increasing
Slightly volatile
Tax Efficiency0.98390.83630.7815
Increasing
Slightly volatile
Tangible Assets Book Value per Share83.196380.73374.3775
Increasing
Slightly volatile
Total Assets Per Share126124105
Increasing
Slightly volatile
Cash Flow Per Share18.705317.928516.115
Increasing
Slightly volatile
Return on Investment25.331220.030629.479
Decreasing
Stable
Operating Margin20.6514.35717.1493
Increasing
Slightly volatile
Calculated Tax Rate10.4363.641519.4268
Decreasing
Slightly volatile
Receivables Turnover2.87642.75793.254
Decreasing
Slightly volatile
Inventory Turnover25.943526.820222.7069
Increasing
Slightly volatile
PPandE Turnover7.89427.39447.2568
Increasing
Slightly volatile
Cash and Equivalents Turnover10.732210.2769.2588
Increasing
Slightly volatile
Accounts Payable Turnover13.5313.026212.9744
Increasing
Stable
Accrued Expenses Turnover11.889912.058511.6039
Decreasing
Stable
Interest Coverage31.515721.980884.9955
Decreasing
Slightly volatile
Long Term Debt to Equity2.23321.89931.5696
Increasing
Slightly volatile
Quick Ratio1.11241.04131.0301
Increasing
Slightly volatile
Net Current Assets as percentage of Total Assets7.33356.48087.4349
Decreasing
Stable
Revenue to Assets0.74740.68030.8129
Decreasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Average Assets120.2 B117.5 B112.2 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA16.3 B17.3 B21.4 B
Decreasing
Stable
Earnings Before Interest Taxes and Depreciation Amortization USD19.7 B17.3 B21.7 B
Decreasing
Stable
Earnings before Tax14.8 B12.3 B16.5 B
Decreasing
Stable
Average Equity15.7 B16.5 B19.2 B
Decreasing
Slightly volatile
Enterprise Value178.5 B191.3 B196.7 B
Decreasing
Very volatile
Free Cash Flow13.9 B13.2 B13.7 B
Increasing
Stable
Invested Capital85.8 B72.9 B72.5 B
Increasing
Stable
Invested Capital Average78.2 B75.5 B71.6 B
Increasing
Slightly volatile
Market Capitalization144.6 B157.8 B170.3 B
Decreasing
Stable
Tangible Asset Value79.8 B76.6 B85.4 B
Decreasing
Slightly volatile
Working Capital8.2 B7.6 B8.4 B
Decreasing
Very volatile
Revenue Per Employee224.2 K209.6 K228.7 K
Decreasing
Slightly volatile
Net Income Per Employee34.8 K31.1 K32.2 K
Increasing
Slightly volatile