Advance Auto Financial Statements Trends

AAP -- USA Stock  

USD 139.07  0.43  0.31%

This module enables investors to look at Advance Auto 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 491.1 M, Cost of Revenue of 5.6 B or Earning Before Interest and Taxes EBIT of 851.1 M, but also many exotic indicators such as Interest Coverage of 14.853, Long Term Debt to Equity of 0.58 or Calculated Tax Rate of 43.6734. This module is a perfect complement to use when analyzing Advance Auto Valuation or Volatility. It can also complement various Advance Auto Technical models. Check also analysis of Advance Auto Correlation with competitors.

Balance Sheet

Current ValueLast YearHistorical Average 10 Year Trend
Accumulated Other Comprehensive Income(44.1 M)(39.7 M)(16.4 M)
Decreasing
Slightly volatile
Total Assets2 B8.3 B5.1 B
Increasing
Slightly volatile
Current Assets1.2 B5.2 B3.2 B
Increasing
Slightly volatile
Assets Non Current3.3 B3.1 B2.1 B
Increasing
Slightly volatile
Cash and Equivalents639.1 M135.2 M202.5 M
Increasing
Slightly volatile
Cash and Equivalents USD118.9 M135.2 M162.4 M
Increasing
Stable
Total Debt1 B1 B886.7 M
Increasing
Slightly volatile
Debt Current475.8 K306 K8.4 M
Decreasing
Slightly volatile
Debt Non Current1.2 B1 B889.4 M
Increasing
Slightly volatile
Total Debt USD1.2 B1 B897.8 M
Increasing
Slightly volatile
Shareholders Equity2.8 B2.9 B1.7 B
Increasing
Slightly volatile
Shareholders Equity USD2.8 B2.9 B1.7 B
Increasing
Slightly volatile
Goodwill and Intangible Assets1.7 B1.6 B833.7 M
Increasing
Slightly volatile
Inventory4.5 B4.3 B2.9 B
Increasing
Slightly volatile
Total Liabilities5.8 B5.4 B3.9 B
Increasing
Slightly volatile
Current Liabilities722.6 M3.7 B2.4 B
Increasing
Slightly volatile
Liabilities Non Current1.9 B1.7 B1.3 B
Increasing
Slightly volatile
Trade and Non Trade Payables3.3 B3.1 B2.1 B
Increasing
Slightly volatile
Property Plant and Equipment Net1.5 B1.4 B1.3 B
Increasing
Slightly volatile
Trade and Non Trade Receivables652.1 M641.3 M355 M
Increasing
Slightly volatile
Accumulated Retained Earnings Deficit2.4 B2.5 B1.6 B
Increasing
Slightly volatile
Tax Liabilities467.5 M454.3 M439.6 M
Increasing
Slightly volatile

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Consolidated Income491.1 M459.6 M366.3 M
Increasing
Slightly volatile
Cost of Revenue5.6 B5.3 B3.9 B
Increasing
Slightly volatile
Earning Before Interest and Taxes EBIT851.1 M798.7 M634.7 M
Increasing
Slightly volatile
Earning Before Interest and Taxes USD851.1 M798.7 M634.7 M
Increasing
Slightly volatile
Gross Profit4.1 B4.3 B3.4 B
Increasing
Slightly volatile
Interest Expense66 M59.9 M49.6 M
Increasing
Slightly volatile
Net Income504.3 M459.6 M367.3 M
Increasing
Slightly volatile
Net Income Common Stock491.1 M459.6 M366.3 M
Increasing
Slightly volatile
Net Income Common Stock USD491.1 M459.6 M366.3 M
Increasing
Slightly volatile
Net Income from Discontinued Operations45.9 K39 K63.6 K
Decreasing
Slightly volatile
Operating Expenses3.7 B3.5 B2.8 B
Increasing
Slightly volatile
Operating Income849.1 M787.6 M633.2 M
Increasing
Slightly volatile
Revenues9.4 B9.6 B7.3 B
Increasing
Slightly volatile
Revenues USD10.2 B9.6 B7.3 B
Increasing
Slightly volatile
Selling General and Administrative Expense3.7 B3.5 B2.8 B
Increasing
Slightly volatile
Weighted Average Shares74 M73.6 M80.5 M
Decreasing
Slightly volatile
Weighted Average Shares Diluted77.7 M73.9 M81.3 M
Decreasing
Slightly volatile
Income Tax Expense294.1 M279.2 M218.9 M
Increasing
Slightly volatile

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(258.9 M)(257.3 M)(209.8 M)
Decreasing
Slightly volatile
Depreciation Amortization and Accretion277.8 M258.4 M207.5 M
Increasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents16.1 M44.4 M(103.4 M)
Decreasing
Stable
Net Cash Flow Business Acquisitions and Disposals(12.4 M)(4.7 M)(371.9 M)
Decreasing
Very volatile
Issuance Purchase of Equity Shares(8.1 M)(13.9 M)(133.3 M)
Increasing
Slightly volatile
Issuance Repayment of Debt Securities (311.5 M)(165.6 M)59.8 M
Decreasing
Stable
Payment of Dividends and Other Cash Distributions (18.6 M)(17.7 M)(19.4 M)
Increasing
Slightly volatile
Net Cash Flow from Financing(337.2 M)(194.7 M)(106.9 M)
Decreasing
Very volatile
Net Cash Flow from Investing(271.3 M)(262 M)(575.1 M)
Decreasing
Stable
Net Cash Flow from Operations526.8 M500.9 M572.1 M
Increasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (2.1 M)257 K(3.5 M)
Increasing
Slightly volatile
Share Based Compensation11.6 M(2 M)9.3 M
Decreasing
Stable
Cash Beginning of Year123.1 M104.7 M269 M
Increasing
Stable
Cash End of Year106.8 M90.8 M154.4 M
Increasing
Very volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Asset Turnover1.22791.1391.4351
Decreasing
Slightly volatile
Book Value per Share38.511139.58122.3839
Increasing
Slightly volatile
Current Ratio1.611.4071.3486
Increasing
Stable
Debt to Equity Ratio29.41.8514.6333
Increasing
Slightly volatile
Share Dilution Ratio1.05971.00611.0098
Increasing
Slightly volatile
Dividend Yield0.00160.0010.0035
Decreasing
Slightly volatile
Dividends per Basic Common Share0.28240.240.2433
Increasing
Slightly volatile
EBITDA Margin0.11680.110.113
Increasing
Slightly volatile
Earnings per Basic Share6.66846.224.7406
Increasing
Slightly volatile
Earnings per Diluted Share6.86.24.7185
Increasing
Slightly volatile
EPS Diluted Growth(0.0369)(0.0239)0.1534
Decreasing
Slightly volatile
EPS Growth(0.0359)(0.0237)0.1528
Decreasing
Slightly volatile
Earnings per Basic Share USD6.66846.224.7406
Increasing
Slightly volatile
Enterprise Value over EBIT15.789516.012.1377
Increasing
Slightly volatile
Enterprise Value over EBITDA12.5712.6579.5598
Increasing
Slightly volatile
Free Cash Flow per Share8.643.314.9708
Increasing
Slightly volatile
Gross Margin0.47320.4450.4678
Decreasing
Stable
Financial Leverage0.9710.92480.91
Increasing
Slightly volatile
Leverage Ratio3.61443.36223.444
Increasing
Slightly volatile
NCFO Growth(0.0629)(0.0922)0.0898
Decreasing
Slightly volatile
Net Income Growth(0.0325)(0.0205)0.1266
Decreasing
Slightly volatile
Profit Margin0.05390.0480.0483
Increasing
Slightly volatile
Payout Ratio0.040.0390.0588
Decreasing
Slightly volatile
Price to Book Value2.914.2714.5206
Decreasing
Very volatile
Price to Earnings Ratio20.5127.1927.5126
Decreasing
Slightly volatile
Price to Sales Ratio1.11.30.9814
Increasing
Slightly volatile
Revenue Growth(0.0181)(0.0236)0.0657
Decreasing
Very volatile
Return on Average Assets0.04990.0550.0685
Decreasing
Stable
Return on Average Equity0.15350.1650.233
Decreasing
Very volatile
Return on Invested Capital0.21790.2030.2303
Increasing
Very volatile
Return on Sales0.08790.0830.0846
Increasing
Slightly volatile
Weighted Average Share Growth0.00390.0038(0.0264)
Increasing
Slightly volatile
Sales per Share13813094.9747
Increasing
Slightly volatile
Tax Efficiency0.66220.62930.6249
Increasing
Slightly volatile
Tangible Assets Book Value per Share94.091190.71162.413
Increasing
Slightly volatile
Total Assets Per Share13111174.8086
Increasing
Slightly volatile
Cash Flow Per Share11.06679.40678.2618
Increasing
Slightly volatile
Return on Investment26.564922.580129.4949
Decreasing
Slightly volatile
Operating Margin9.878.48088.966
Increasing
Stable
Calculated Tax Rate43.673437.122437.8214
Increasing
Slightly volatile
Receivables Turnover19.508616.582335.646
Decreasing
Slightly volatile
Inventory Turnover1.54151.31031.5535
Decreasing
Slightly volatile
PPandE Turnover8.01426.81215.9691
Increasing
Slightly volatile
Cash and Equivalents Turnover11899.9091114
Decreasing
Slightly volatile
Accounts Payable Turnover3.6473.14.2392
Decreasing
Slightly volatile
Accrued Expenses Turnover21.393918.184817.3211
Increasing
Slightly volatile
Interest Coverage14.85312.625114.8657
Decreasing
Stable
Long Term Debt to Equity0.580.4930.5127
Increasing
Slightly volatile
Quick Ratio0.21090.17930.1677
Increasing
Slightly volatile
Net Current Assets as percentage of Total Assets16.534714.054513.5982
Increasing
Very volatile
Revenue to Assets1.40821.1971.4655
Decreasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Average Assets8.7 B8.4 B5.6 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA923.3 M1.1 B826.4 M
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization USD1.1 B1.1 B842.2 M
Increasing
Slightly volatile
Earnings before Tax785.1 M738.8 M585.1 M
Increasing
Slightly volatile
Average Equity2.7 B2.8 B1.6 B
Increasing
Slightly volatile
Enterprise Value10.6 B13.4 B8.4 B
Increasing
Slightly volatile
Free Cash Flow367.7 M243.5 M370 M
Increasing
Stable
Invested Capital4.1 B4 B2.7 B
Increasing
Slightly volatile
Invested Capital Average4.1 B3.9 B2.9 B
Increasing
Slightly volatile
Market Capitalization10.3 B12.5 B7.7 B
Increasing
Slightly volatile
Tangible Asset Value6.9 B6.7 B4.8 B
Increasing
Slightly volatile
Working Capital462.9 M1.5 B779.1 M
Increasing
Slightly volatile
Revenue Per Employee157.4 K133.8 K121.7 K
Increasing
Slightly volatile
Net Income Per Employee7.7 K6.5 K6.2 K
Increasing
Slightly volatile

Thematic Opportunities

Explore Investment Opportunities
Build portfolios using Macroaxis predefined set of investing ideas. Many of Macroaxis investing ideas can easily outperform a given market. Ideas can also be optimized per your risk profile before portfolio origination is invoked.
Explore Thematic Ideas
Explore Investing Ideas  

Upcoming Events

Advance Auto Upcoming Company Events
Upcoming Quarterly ReportMay 18, 2017
Next Earnings ReportAugust 15, 2017
Check also analysis of Advance Auto Correlation with competitors. Please also try Content Syndication module to quickly integrate customizable finance content to your own investment portal.