1. What was Advance Auto Parts' return on assets (ROA) for FY17? Input your answer as a...
Fantastic news! We've Found the answer you've been seeking!
Question:
1. What was Advance Auto Parts' return on assets (ROA) for FY17? Input your answer as a percent with one decimal place (e.g., "7.9%").
2. What was Advance Auto Parts' profit margin (PM) for FY17? Input your answer as a percent with one decimal place (e.g., "7.9%").
3. What was Advance Auto Parts' asset turnover (AT) for FY17? Input your answer as a number with one decimal place (e.g., "7.9").
| NAME: | ADVANCE AUTO PARTS INC | ||||||||
| TICKER SYMBOL: | AAP | ||||||||
| PRIMARY SIC CODE: | 5531 | ||||||||
| STOCK EXCHANGE: | 11 | New York Stock Exchange | |||||||
| CUSIP: | 00751Y | ||||||||
| $ in millions | |||||||||
| STATEMENT OF FINANCIAL POSITION | |||||||||
| Fiscal Year: | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | |
| (FYR Ending): | (31DEC2010 ) | (31DEC2011 ) | (31DEC2012 ) | (31DEC2013 ) | (31DEC2014 ) | (31DEC2015 ) | (31DEC2016 ) | (31DEC2017 ) | |
| ASSETS | |||||||||
| Cash & Equivalents | 59.209 | 57.901 | 598.111 | 1,112.471 | 104.671 | 90.782 | 135.178 | 546.937 | |
| Receivables - Total (Net) | 124.227 | 140.007 | 229.866 | 277.595 | 579.825 | 597.788 | 641.252 | 606.357 | |
| Inventories - Total | 1,863.870 | 2,043.158 | 2,308.609 | 2,556.557 | 3,936.955 | 4,174.768 | 4,325.868 | 4,168.492 | |
| Prepaid Expenses | .000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | |
| Current Assets - Other | 76.965 | 52.754 | 47.614 | 42.761 | 119.589 | 77.408 | 70.466 | 105.106 | |
| Current Assets - Total | 2,124.271 | 2,293.820 | 3,184.200 | 3,989.384 | 4,741.040 | 4,940.746 | 5,172.764 | 5,426.892 | |
| Plant, Property & Equip (Gross) | 2,070.734 | 2,206.721 | 2,393.906 | 2,539.444 | 2,804.389 | 2,924.343 | 3,106.988 | 3,177.521 | |
| Accumulated Depreciation | 927.564 | 983.622 | 1,102.147 | 1,255.474 | 1,372.359 | 1,489.766 | 1,660.648 | 1,783.383 | |
| Plant, Property & Equip (Net) | 1,143.170 | 1,223.099 | 1,291.759 | 1,283.970 | 1,432.030 | 1,434.577 | 1,446.340 | 1,394.138 | |
| Investments at Equity | .000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | |
| Investments and Advances - Other | .000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | |
| Intangibles | 59.747 | 107.769 | 105.234 | 249.707 | 1,743.551 | 1,676.609 | 1,631.780 | 1,591.967 | |
| Deferred Charges | .000 | .000 | .000 | ||||||
| Assets - Other | 27.029 | 31.066 | 32.621 | 41.713 | 45.737 | 82.633 | 64.149 | 69.304 | |
| TOTAL ASSETS | 3,354.217 | 3,655.754 | 4,613.814 | 5,564.774 | 7,962.358 | 8,134.565 | 8,315.033 | 8,482.301 | |
| LIABILITIES | |||||||||
| Accounts Payable | 1,292.113 | 1,653.183 | 2,029.814 | 2,180.614 | 3,095.365 | 3,203.922 | 3,086.177 | 2,894.582 | |
| Notes Payable | 31.648 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | |
| Accrued Expenses | 301.646 | 283.454 | 261.157 | 300.942 | 374.301 | 399.236 | 373.794 | 355.155 | |
| Taxes Payable | 55.662 | 52.480 | 73.158 | 82.179 | 87.473 | 96.098 | 121.860 | 112.930 | |
| Debt (Long-Term) Due In One Year | .973 | .848 | .627 | .916 | .582 | .598 | .306 | .350 | |
| Other Current Liabilities | 166.007 | 197.910 | 194.882 | 200.134 | 185.345 | 97.623 | 93.909 | 117.080 | |
| Total Current Liabilities | 1,848.049 | 2,187.875 | 2,559.638 | 2,764.785 | 3,743.066 | 3,797.477 | 3,676.046 | 3,480.097 | |
| Long Term Debt | 300.851 | 415.136 | 604.461 | 1,052.668 | 1,636.311 | 1,213.161 | 1,042.949 | 1,044.327 | |
| Deferred Taxes (Balance Sheet) | 51.117 | 73.165 | 100.235 | 91.957 | 360.903 | 433.925 | 454.282 | 303.620 | |
| Investment Tax Credit | .000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | |
| Liabilities - Other | 114.826 | 131.664 | 138.786 | 139.159 | 219.166 | 229.354 | 225.564 | 239.061 | |
| Noncontrolling Interest - Redeemable | .000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | |
| TOTAL LIABILITIES | 2,314.843 | 2,807.840 | 3,403.120 | 4,048.569 | 5,959.446 | 5,673.917 | 5,398.841 | 5,067.105 | |
| SHAREHOLDERS' EQUITY | |||||||||
| Preferred Stock | .000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | |
| Common Stock | .011 | .011 | .007 | .007 | .007 | .007 | .008 | .008 | |
| Capital Surplus | 456.645 | 500.237 | 520.215 | 531.293 | 562.945 | 603.332 | 631.052 | 664.646 | |
| Retained Earnings (Net Other) | 1,611.330 | 1,992.433 | 717.567 | 1,092.795 | 1,553.004 | 1,977.018 | 2,423.234 | 2,895.142 | |
| Less: Treasury Stock | 1,028.612 | 1,644.767 | 27.095 | 107.890 | 113.044 | 119.709 | 138.102 | 144.600 | |
| Shareholders Equity - Parent | 1,039.374 | 847.914 | 1,210.694 | 1,516.205 | 2,002.912 | 2,460.648 | 2,916.192 | 3,415.196 | |
| Noncontrolling Interest - Nonredeemable | .000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | |
| TOTAL SHAREHOLDERS EQUITY | 1,039.374 | 847.914 | 1,210.694 | 1,516.205 | 2,002.912 | 2,460.648 | 2,916.192 | 3,415.196 | |
| TOTAL LIABILITIES AND EQUITY | 3,354.217 | 3,655.754 | 4,613.814 | 5,564.774 | 7,962.358 | 8,134.565 | 8,315.033 | 8,482.301 | |
| INCOME STATEMENT | |||||||||
| Fiscal Year: | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | |
| (FYR Ending): | (31DEC2010 ) | (31DEC2011 ) | (31DEC2012 ) | (31DEC2013 ) | (31DEC2014 ) | (31DEC2015 ) | (31DEC2016 ) | (31DEC2017 ) | |
| Sales (Net) | 5,925.203 | 6,170.462 | 6,205.003 | 6,493.814 | 9,843.861 | 9,737.018 | 9,567.679 | 9,373.784 | |
| Cost of Goods Sold | 2,799.451 | 2,925.223 | 2,917.423 | 3,033.873 | 5,098.709 | 5,037.462 | 5,047.763 | 5,034.435 | |
| Gross Profit | 3,125.752 | 3,245.239 | 3,287.580 | 3,459.941 | 4,745.152 | 4,699.556 | 4,519.916 | 4,339.349 | |
| Selling, General, & Admin Expenses | 2,376.382 | 2,404.648 | 2,440.721 | 2,558.841 | 3,519.669 | 3,469.933 | 3,395.489 | 3,430.305 | |
| Operating Income Before Depreciation | 749.370 | 840.591 | 846.859 | 901.100 | 1,225.483 | 1,229.623 | 1,124.427 | 909.044 | |
| Depreciation, Depletion, & Amortiz | 164.437 | 175.949 | 189.544 | 207.795 | 291.539 | 276.784 | 264.001 | 254.300 | |
| Operating Income After Depreciation | 584.933 | 664.642 | 657.315 | 693.305 | 933.944 | 952.839 | 860.426 | 654.744 | |
| Interest Expense | 26.861 | 30.949 | 33.841 | 34.631 | 73.408 | 65.408 | 59.910 | 58.801 | |
| Non-Operating Income/Expense | -1.017 | -.457 | .600 | 2.698 | 3.092 | -7.484 | 11.147 | -.030 | |
| Special Items | .000 | .000 | .000 | -34.974 | -82.234 | -127.059 | -72.828 | -75.654 | |
| Pretax Income | 557.055 | 633.236 | 624.074 | 626.398 | 781.394 | 752.888 | 738.835 | 520.259 | |
| Income Taxes - Total | 211.002 | 238.554 | 236.404 | 234.640 | 287.569 | 279.490 | 279.213 | 44.754 | |
| Minority Interest | .000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | |
| Income Before EI&DO | 346.053 | 394.682 | 387.670 | 391.758 | 493.825 | 473.398 | 459.622 | 475.505 | |
| Extraordinary Items | .000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | |
| Discontinued Operations | .000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | |
| Net Income (Loss) | 346.053 | 394.682 | 387.670 | 391.758 | 493.825 | 473.398 | 459.622 | 475.505 | |
| Income Before EI&DO | 346.053 | 394.682 | 387.670 | 391.758 | 493.825 | 473.398 | 459.622 | 475.505 | |
| Preferred Dividends | .000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | |
| Available for Common Before EI&DO | 346.053 | 394.682 | 387.670 | 391.758 | 493.825 | 473.398 | 459.622 | 475.505 | |
| Common Stock Equivalents - Savings | -1.552 | -1.055 | -.870 | -.895 | -1.555 | -1.653 | -1.945 | .000 | |
| Adjusted Available for Common | 344.501 | 393.627 | 386.800 | 390.863 | 492.270 | 471.745 | 457.677 | 475.505 | |
| EARNINGS PER SHARE | |||||||||
| EPS - Primary, Excluding EI&DO | 4.000 | 5.210 | 5.290 | 5.360 | 6.750 | 6.450 | 6.220 | 6.440 | |
| EPS - Primary, Including EI&DO | 4.000 | 5.210 | 5.290 | 5.360 | 6.750 | 6.450 | 6.220 | 6.440 | |
| EPS - Fully Diluted, Excluding EI&DO | 3.950 | 5.110 | 5.220 | 5.320 | 6.710 | 6.400 | 6.200 | 6.420 | |
| EPS - Fully Diluted, Including EI&DO | 3.950 | 5.110 | 5.220 | 5.320 | 6.710 | 6.400 | 6.200 | 6.420 | |
| COMMON SHARES | |||||||||
| Common Shares for Primary EPS Calculation | 86.082 | 75.620 | 73.091 | 72.930 | 72.932 | 73.190 | 73.562 | 73.846 | |
| Common Shares for Fully Diluted EPS Calc. | 87.155 | 77.071 | 74.062 | 73.414 | 73.414 | 73.733 | 73.856 | 74.110 | |
| Common Shares Outstanding at Fiscal Yr End | 81.956 | 72.799 | 73.383 | 72.840 | 73.074 | 73.314 | 73.749 | 73.936 | |
| STATEMENT OF RETAINED EARNINGS | |||||||||
| Fiscal Year: | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | |
| (FYR Ending): | (31DEC2010 ) | (31DEC2011 ) | (31DEC2012 ) | (31DEC2013 ) | (31DEC2014 ) | (31DEC2015 ) | (31DEC2016 ) | (31DEC2017 ) | |
| Retained Rearnings - Beginning Balance | 1,280.569 | 1,611.330 | 1,992.433 | 717.567 | 1,092.795 | 1,553.004 | 1,977.018 | 2,423.234 | |
| Net Income | 346.053 | 394.682 | 387.670 | 391.758 | 493.825 | 473.398 | 459.622 | 475.505 | |
| Cash Dividends | 21.051 | 18.554 | 17.596 | 17.574 | 17.580 | 17.649 | 17.738 | 17.854 | |
| Retained Earnings After Dividends | 1,605.571 | 1,987.458 | 2,362.507 | 1,091.751 | 1,569.040 | 2,008.753 | 2,418.902 | 2,880.885 | |
| Change - Foreign Currency Translation | -4.000 | ||||||||
| Adj. to Long-Term Marketable Securities | .000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | |
| Other CMP Adj,(Stock Splits/Retirement) | -1.597 | 2.804 | 2.667 | 3.683 | 2.931 | 2.486 | 1.952 | 1.758 | |
| Non-Compustat Adjustments (Plug Calculation) | 7.356 | 2.171 | -1,647.607 | -2.639 | -18.967 | -34.221 | 2.380 | 16.499 | |
| Retained Earnings - Ending Balance | 1,611.330 | 1,992.433 | 717.567 | 1,092.795 | 1,553.004 | 1,977.018 | 2,423.234 | 2,895.142 | |
| Retroactive Adjustments (Acct'g Chgs) | .000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | |
| Retained Earnings - After Adjustments | 1,611.330 | 1,992.433 | 717.567 | 1,092.795 | 1,553.004 | 1,977.018 | 2,423.234 | 2,895.142 | |
| STATEMENT OF CASH FLOWS | |||||||||
| Fiscal Year: | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | |
| (FYR Ending): | (31DEC2010 ) | (31DEC2011 ) | (31DEC2012 ) | (31DEC2013 ) | (31DEC2014 ) | (31DEC2015 ) | (31DEC2016 ) | (31DEC2017 ) | |
| INDIRECT OPERATING ACTIVITIES | |||||||||
| Income Before Extraordinary Items | 346.053 | 394.682 | 387.670 | 391.758 | 493.825 | 473.398 | 459.622 | 475.505 | |
| Depreciation and Amortizations | 164.437 | 175.949 | 189.544 | 207.795 | 284.693 | 269.476 | 258.387 | 249.260 | |
| Extraordinary Items and Disc. Operations | .000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | |
| Deferred Taxes | 40.503 | 53.037 | 26.893 | -2.237 | 48.468 | -9.219 | 20.213 | -151.263 | |
| Equity in Net Loss (Earnings) | .000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | |
| Sale of PPEq and Investments - Loss (Gain) | 6.534 | 5.228 | 2.699 | 1.599 | 13.281 | 12.882 | 5.999 | ||
| Funds from Operations - Other | 16.157 | 10.988 | -6.281 | -1.450 | 13.849 | 26.587 | -4.016 | 55.496 | |
| Receivables - Decrease (Increase) | -31.667 | -15.372 | -89.482 | -32.428 | -48.209 | -21.476 | -41.642 | 36.047 | |
| Inventory - Decrease (Increase) | -232.003 | -179.288 | -260.298 | -203.513 | -227.657 | -244.096 | -144.603 | 167.548 | |
| Accounts/P and Accrued Liabs - Inc(Dec) | 364.554 | 344.777 | 417.567 | 176.843 | 187.550 | 154.267 | -69.984 | -210.463 | |
| Income Taxes - Accrued - Increase(Decrease) | |||||||||
| Other Assets and Liabilities - Net Change | -8.409 | 38.848 | 16.969 | 6.883 | -56.809 | 27.823 | 16.898 | -21.325 | |
| Operating Actiities - Net Cash Flow | 666.159 | 828.849 | 685.281 | 545.250 | 708.991 | 689.642 | 500.874 | 600.805 | |
| INVESTING ACTIVITIES | |||||||||
| Investments - Increase | .000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | |
| Sale of Investments | .000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | |
| Short term Investments - Change | .000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | |
| Capital Expenditures | 199.585 | 268.129 | 271.182 | 195.757 | 228.446 | 234.747 | 259.559 | 189.758 | |
| Sale of Property Plant and Equipment | .235 | 1.288 | 6.573 | .745 | .992 | .270 | 2.212 | 11.099 | |
| Acquisitions | .000 | 23.133 | 8.369 | 186.137 | 2,060.783 | 18.889 | 4.697 | .000 | |
| Investing Activities - Other | .000 | .000 | .000 | 19.042 | .000 | .000 | .000 | .020 | |
| Investing Activites - Net Cash Flow | -199.350 | -289.974 | -272.978 | -362.107 | -2,288.237 | -253.366 | -262.044 | -178.639 | |
| FINANCING ACTIVITIES | |||||||||
| Sale of Common and Preferred Stock | 36.113 | 14.474 | 8.495 | 3.611 | 6.578 | 5.174 | 4.532 | 4.076 | |
| Purchase of Common and Preferred Stock | 622.442 | 631.149 | 53.772 | 102.651 | 12.256 | 19.777 | 37.951 | 13.029 | |
| Cash Dividends | 21.051 | 18.554 | 17.596 | 17.574 | 17.580 | 17.649 | 17.738 | 17.854 | |
| Long Term Debt - Issuance | 373.761 | 1,435.200 | 358.404 | 448.605 | 2,238.200 | 618.300 | 799.600 | 534.400 | |
| Long Term Debt - Reduction | 275.704 | 1,320.200 | 173.500 | .000 | 1,654.800 | 1,041.700 | 959.600 | 534.400 | |
| Current Debt - Changes | -.416 | -25.023 | -7.459 | -2.926 | 16.219 | -2.922 | -5.573 | 14.004 | |
| Financing Activities - Other | -5.139 | -4.594 | -9.764 | -14.168 | -10.937 | -.380 | -.390 | -2.069 | |
| Financing Activities - Net Cash Flow | -507.618 | -540.183 | 127.907 | 331.217 | 575.911 | -445.952 | -194.691 | -14.872 | |
| Exchange Rate Effect | .000 | .000 | .000 | .000 | -4.465 | -4.213 | .257 | 4.465 | |
| Cash and Cash Equivalents - Change | -40.809 | -1.308 | 540.210 | 514.360 | -1,007.800 | -13.889 | 44.396 | 411.759 | |
| OTHER INFORMATION | |||||||||
| Interest Paid - Net< | 15.782 | 35.030 | 27.250 | 34.735 | 71.109 | 62.371 | 55.457 | 53.509 | |
| Income Taxes Paid | 164.987 | 170.541 | 162.677 | 219.424 | 268.624 | 254.408 | 225.327 | 192.116 |
Expert Answer:
Related Book For 
Financial Accounting
ISBN: 9781618533111
6th Edition
Authors: Michelle L. Hanlon, Robert P. Magee, Glenn M. Pfeiffer, Thomas R. Dyckman
Posted Date:
