Advance Auto Financial Statements Trends

Advance Auto Parts Inc -- USA Stock  

USD 89.27  2.16  2.36%

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 12.7513, Long Term Debt to Equity of 0.6895 or Calculated Tax Rate of 38.9076. 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)(14.5 M)
Decreasing
Slightly volatile
Total Assets2 B8.3 B4.8 B
Increasing
Slightly volatile
Current Assets1.2 B5.2 B3 B
Increasing
Slightly volatile
Assets Non Current3.3 B3.1 B2 B
Increasing
Slightly volatile
Cash and Equivalents257.2 M135.2 M176.2 M
Increasing
Stable
Cash and Equivalents USD118.9 M135.2 M164.7 M
Increasing
Stable
Total Debt1 B1 B873.6 M
Increasing
Slightly volatile
Debt Current475.8 K306 K9 M
Decreasing
Slightly volatile
Debt Non Current1.2 B1 B876.6 M
Increasing
Slightly volatile
Total Debt USD1.2 B1 B885.7 M
Increasing
Slightly volatile
Shareholders Equity2.8 B2.9 B1.6 B
Increasing
Slightly volatile
Shareholders Equity USD2.8 B2.9 B1.6 B
Increasing
Slightly volatile
Goodwill and Intangible Assets1.7 B1.6 B767.2 M
Increasing
Slightly volatile
Inventory4.5 B4.3 B2.8 B
Increasing
Slightly volatile
Total Liabilities5.8 B5.4 B3.8 B
Increasing
Slightly volatile
Current Liabilities722.6 M3.7 B2.3 B
Increasing
Slightly volatile
Liabilities Non Current1.9 B1.7 B1.2 B
Increasing
Slightly volatile
Trade and Non Trade Payables3.3 B3.1 B2 B
Increasing
Slightly volatile
Property Plant and Equipment Net1.5 B1.4 B1.2 B
Increasing
Slightly volatile
Trade and Non Trade Receivables652.1 M641.3 M331.1 M
Increasing
Slightly volatile
Accumulated Retained Earnings Deficit2.4 B2.5 B1.5 B
Increasing
Slightly volatile
Tax Liabilities467.5 M454.3 M438.4 M
Increasing
Slightly volatile

Income Statement

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

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(258.9 M)(257.3 M)(205.8 M)
Decreasing
Slightly volatile
Depreciation Amortization and Accretion277.8 M258.4 M203.2 M
Increasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents16.1 M44.4 M(115.7 M)
Decreasing
Stable
Net Cash Flow Business Acquisitions and Disposals(12.4 M)(4.7 M)(402.5 M)
Decreasing
Stable
Issuance Purchase of Equity Shares(8.1 M)(13.9 M)(143.2 M)
Increasing
Stable
Issuance Repayment of Debt Securities (311.5 M)(165.6 M)78.6 M
Decreasing
Stable
Payment of Dividends and Other Cash Distributions (18.6 M)(17.7 M)(19.6 M)
Increasing
Slightly volatile
Net Cash Flow from Financing(337.2 M)(194.7 M)(99.6 M)
Increasing
Very volatile
Net Cash Flow from Investing(271.3 M)(262 M)(601.2 M)
Decreasing
Stable
Net Cash Flow from Operations559.8 M500.9 M580.8 M
Increasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (2.1 M)257 K(3.9 M)
Increasing
Slightly volatile
Share Based Compensation11.6 M(2 M)10.3 M
Decreasing
Very volatile
Cash Beginning of Year640.6 M104.7 M325.8 M
Increasing
Slightly volatile
Cash End of Year102.9 M90.8 M159.4 M
Increasing
Stable

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Asset Turnover1.22791.1391.4598
Decreasing
Slightly volatile
Book Value per Share38.511139.58120.9508
Increasing
Slightly volatile
Current Ratio1.481.4071.3329
Decreasing
Very volatile
Debt to Equity Ratio33.31.8515.1902
Increasing
Slightly volatile
Share Dilution Ratio1.05971.00611.0101
Increasing
Slightly volatile
Dividend Yield0.00160.0010.0037
Decreasing
Slightly volatile
Dividends per Basic Common Share0.28240.240.2435
Increasing
Slightly volatile
EBITDA Margin0.11680.110.1132
Increasing
Slightly volatile
Earnings per Basic Share6.66846.224.6174
Increasing
Slightly volatile
Earnings per Diluted Share5.016.24.4458
Increasing
Slightly volatile
EPS Diluted Growth(0.0369)(0.0239)0.1682
Decreasing
Slightly volatile
EPS Growth(0.0359)(0.0237)0.1675
Decreasing
Slightly volatile
Earnings per Basic Share USD6.66846.224.6174
Increasing
Slightly volatile
Enterprise Value over EBIT15.789516.011.8158
Increasing
Slightly volatile
Enterprise Value over EBITDA12.5712.6579.3018
Increasing
Slightly volatile
Free Cash Flow per Share3.483.314.6793
Increasing
Slightly volatile
Gross Margin0.47320.4450.4697
Decreasing
Stable
Financial Leverage0.9710.92480.9088
Increasing
Slightly volatile
Leverage Ratio3.61443.36223.4508
Increasing
Slightly volatile
NCFO Growth(0.0629)(0.0922)0.105
Decreasing
Slightly volatile
Net Income Growth(0.0325)(0.0205)0.1388
Decreasing
Slightly volatile
Profit Margin0.03910.0480.0471
Increasing
Slightly volatile
Payout Ratio0.040.0390.0604
Decreasing
Slightly volatile
Price to Book Value2.114.2714.4748
Decreasing
Very volatile
Price to Earnings Ratio17.8227.1927.3153
Decreasing
Slightly volatile
Price to Sales Ratio0.71.30.9215
Increasing
Slightly volatile
Revenue Growth(0.0181)(0.0236)0.0731
Increasing
Very volatile
Return on Average Assets0.05230.0550.0698
Decreasing
Very volatile
Return on Average Equity0.12630.1650.2364
Decreasing
Very volatile
Return on Invested Capital0.21790.2030.2326
Increasing
Stable
Return on Sales0.08790.0830.0847
Increasing
Slightly volatile
Weighted Average Share Growth0.00390.0038(0.0289)
Increasing
Slightly volatile
Sales per Share13813092.0507
Increasing
Slightly volatile
Tax Efficiency0.66220.62930.6245
Increasing
Slightly volatile
Tangible Assets Book Value per Share94.091190.71160.0548
Increasing
Slightly volatile
Total Assets Per Share11611170.5639
Increasing
Slightly volatile
Cash Flow Per Share10.05749.40678.0823
Increasing
Slightly volatile
Return on Investment26.322222.580130.0509
Decreasing
Stable
Operating Margin7.448.48088.8039
Decreasing
Very volatile
Calculated Tax Rate38.907637.122437.4825
Increasing
Very volatile
Receivables Turnover20.617116.582337.327
Decreasing
Slightly volatile
Inventory Turnover1.56341.31031.5756
Decreasing
Slightly volatile
PPandE Turnover7.33886.81215.8426
Increasing
Slightly volatile
Cash and Equivalents Turnover60.959499.9091110
Decreasing
Slightly volatile
Accounts Payable Turnover3.56383.14.3272
Decreasing
Slightly volatile
Accrued Expenses Turnover20.309818.184817.1588
Increasing
Slightly volatile
Interest Coverage12.751312.625114.8773
Decreasing
Stable
Long Term Debt to Equity0.68950.4930.5234
Increasing
Slightly volatile
Quick Ratio0.18950.17930.1649
Increasing
Slightly volatile
Net Current Assets as percentage of Total Assets13.993714.054513.3484
Decreasing
Very volatile
Revenue to Assets1.28071.1971.4772
Decreasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Average Assets8.7 B8.4 B5.3 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA960.5 M1.1 B810.2 M
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization USD1.1 B1.1 B824.2 M
Increasing
Slightly volatile
Earnings before Tax785.1 M738.8 M572.3 M
Increasing
Slightly volatile
Average Equity2.7 B2.8 B1.5 B
Increasing
Slightly volatile
Enterprise Value7.4 B13.4 B7.7 B
Increasing
Slightly volatile
Free Cash Flow367.7 M243.5 M380.5 M
Increasing
Slightly volatile
Invested Capital4.1 B4 B2.6 B
Increasing
Slightly volatile
Invested Capital Average4.1 B3.9 B2.8 B
Increasing
Slightly volatile
Market Capitalization6.6 B12.5 B7 B
Increasing
Slightly volatile
Tangible Asset Value6.9 B6.7 B4.6 B
Increasing
Slightly volatile
Working Capital462.9 M1.5 B719.3 M
Increasing
Slightly volatile
Revenue Per Employee140.2 K133.8 K119.2 K
Increasing
Slightly volatile
Net Income Per Employee6.9 K6.5 K6.1 K
Increasing
Slightly volatile