Sprouts financial statement assignment
I CAN PROVIDE THE REST OF THE DUCUMENT IF NEED BE
1. (3 points) As of 12/29/2019, How many shares of common stock are:
a. Authorized?
b. Issued?
c. Outstanding?
2. (1 point) What is the par value of the common stock?
3. (1 point) Did the company pay a cash dividend in the most recent year? If so, how much?
4. (1 point) If a company does not pay dividends, what might the reason be?
5. (1 point) Why would people invest in a company that did not pay dividends?
6. (2 points) Did the company repurchase treasury stock during the most recent year? If so, how many shares?
7. (2 points) What is the companys current, Basic EPS? Did EPS vary more than 10% from prior year?
8. (9 points) Calculate the following liquidity ratios for the current year and give a one sentence description of each result. (Assume that all sales are on credit.)
(For example:
Current Ratio $1,020,000 current assets
344,500 current liabilities
= 2.96 : 1
For every dollar in current liabilities, the company owns $2.96 in current assets to pay for them.)
- Current Ratio
- Accounts Receivables Turnover Ratio
- Inventory Turnover
9. (9 points) Calculate the following profitability ratios for the current year and give a one sentence description of each result.
a. Profit Margin Ratio
b. Rate of return on Total Assets
c. Return on Common Stockholders Equity (ROE)
10. (6 points) Calculate the following solvency ratios for the current year and give a one sentence description of each result.
a. Debt to assets ratio
b. Debt to Equity ratio (total liabilities / total equity)
b. Times Interest Earned Ratio
11. (2 points) Calculate the free cash flow of the company for the most current year (Hint: use the formula given in the book on page 17-17)
FOR QUESTIONS 13 15: LOOK AT THE NOTES TO THE FINANCIAL STATEMENTS (beginning on page 6)
13. (1 Point) In what state did Sprouts Farmers Market, Inc. incorporate?
14. (1 Point) For 2019, what percentage of the companys sales were from Perishables?
15. (1 Point) What does the company estimate for the useful life of its buildings for depreciation purposes?
16. (10 points) Prepare a horizontal analysis of the Income Statement for the most current year. (See the bottom of page 18-11 for the proper format Illustration 18.10) Note you MUST USE EXCEL to create the horizontal analysis. An excel file MUST BE TURNED IN with the project to earn points for this question.
FINACIAL STATEMENTS FOLLOW:
KIES RMERS MAI CONSOLIDATED BALANCE SHEETS (IN THOUSANDS, EXCEPT SHARE AND PER SHARE AMOUNTS) December 29, 2019 December 30, 2018 S 85,314 15,713 275,979 10.833 387,839 741,508 1,028,436 185,395 368,078 11,727 2,722,983 1,588 40,564 264,366 27,323 333,841 766,429 194,803 368,078 12,463 1,675,614 $ S 261,326 48,579 253,969 48,603 7,428 ASSETS Current assets: Cash and cash equivalents Accounts receivable, net Inventories Prepaid expenses and other current assets Total current assets Property and equipment, net of accumulated depreciation Operating lease assets, net Intangible assets, net of accumulated amortization Goodwill Other assets Total assets LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Accounts payable and accrued liabilities Accrued salaries and benefits Current portion of capital and financing lease obligations Current portion of operating lease liabilities Current portion of finance lease liabilities Total current liabilities Long-term capital and financing lease obligations Long-term operating lease liabilities Long-term debt and finance lease liabilities Other long-term liabilities Deferred income tax liability Total liabilities Commitments and contingencies (Note 19) Stockholders' equity: Undesignated preferred stock; $0.001 par value; 10,000,000 shares authorized, no shares issued and outstanding Common stock, $0.001 par value; 200,000,000 shares authorized, 117,543,668 shares issued and outstanding, December 29, 2019; 124,975,691 shares issued and outstanding, December 30, 2018 Additional paid-in capital Accumulated other comprehensive income (loss) Accumulated deficit Total stockholders' equity Total liabilities and stockholders' equity 106,153 754 416,812 310.000 119,642 1,078,927 549,419 41,517 54,356 2,141,031 453,000 153,377 50,399 1,086,418 117 670,966 (4,682) (84,449) 581,952 2.722,983 124 657,140 1,134 (69,202) 589,196 1,675,614 $ $ SPROUTS FARMERS MARKET, INC. AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF INCOME (IN THOUSANDS, EXCEPT PER SHARE AMOUNTS) Net sales Cost of sales Gross profit Selling, general and administrative expenses Depreciation and amortization (exclusive of depreciation included in cost of sales) Store closure and other costs Income from operations Interest expense, net Other income Income before income taxes Income tax provision Net income Net income per share: Basic Diluted Weighted average shares outstanding: Basic Diluted Year Ended December 29, December 30, 2019 2018 $ 5,634,835 $ 5,207,336 3,740,017 3,459,861 1,894,818 1,747,475 1,549,707 1,404,443 120,491 108,045 7,260 12,076 217,360 222,911 21,192 27.435 320 196,168 195,796 46,539 37,260 $ 149,629 $ 158,536 December 31, 2017 $ 4,664,612 3,097,582 1,567.030 1,245,640 94,194 1.126 226,070 21,177 625 205,518 47,078 158,440 $ $ 1.25 1.25 $ $ 1.23 1.22 $ $ 1.17 1.15 119,368 119,742 128,827 129,776 135,169 137,884 SPROUTS FARMERS MARKET, INC. AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (IN THOUSANDS) December 29 2019 $ 149,629 Year Ended December 30, 2018 $ 158,536 December 31, 2017 $ 158,440 Net income Other comprehensive income (loss), net of tax Unrealized gain (losses) on cash flow hedging activities, net of income tax of ($2,012), $663, and ($271) Total other comprehensive income (loss) Comprehensive income (5,816) (5,816 1,918 1,918 (784) (784 $ $ 143,813 $ 160,454 157,656 SPROUTS FARMERS MARKET, INC. AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF STOCKHOLDERS' EQUITY (IN THOUSANDS, EXCEPT SHARE AMOUNTS) Additional Paid in Capital Accumulated Other Comprehensive Income (Loss) (Accumulated Deficit) Retained Earnings Common Stock Total Stockholders' Equity Shares 140,002,242 S 140 $ 597,269 $ 75,500 5 158.440 672,909 158,440 (784) (784) 2.144,669 2 9,298 9,300 (9.696.819) (10) (203,382) 14,221 (203,392) 14.221 132.450 092 S 132 $ 620,788 $ 30,558 158,536 (784) $ 650,694 158,536 1,918 1,918 3.227.693 3 Balances at January 1, 2017 Net income Other comprehensive income (loss) Issuance of shares understock plans Repurchase and retirement of common stock Share-based compensation Balances at December 31, 2017 Net income Other comprehensive income (loss) Issuance of shares under stock plans Repurchase and retirement of common stock Share-based compensation Balances at December 30, 2018 Net income Other comprehensive income (loss) Issuance of shares under stock plans Repurchase and retirement of common stock Share-based compensation Impact of adoption of ASC 842 related to leases Balances at December 29, 2019 21,840 - 21,843 (11,096,595) (258,295) (258,307) 14,512 14,512 124,581,190 S 124 $ 657,140 $ 1,134 (69.202) S 149.629 589, 196 149,629 (5,816) (5,816) 822.586 1 4,877 4,878 (7.950,858) (8) (176,302) (176,310) 8,949 8,949 11,426 11,426 117.452.918 $ 117 $ 670,966 $ (84,449) S (4,682) $ 581,962 CONSOLIDATED STATEMENTS OF CASH FLOWS (IN THOUSANDS) December 29, 2019 Year Ended December 30, 2018 December 31, 2017 149,629 $ 158,536 158,440 110.749 96,987 122,804 81.842 4,113 8.949 (216) 4,136 4,115 14,512 23,333 1.482 14,221 7.803 2,086 36,062 (11.612) 19,20B (1.275) 28.699 295 (88.002) 578 355 210 (7.666) (34,824) (2.908) (5.086) 4,366 3.039 (4,920) (25,079) (2,733) (114) 39,244 12,764 24.731 294,379 10,868 309,567 Cash flows from operating activities Net income Adjustments to reconcile net income to net cash provided by operating activities Depreciation and amortization expense Operating lease asset amortization Store closure and other costs Share-based compensation Deferred income taxes Other non-cash items Changes in operating assets and liabilities: Accounts receivable Inventories Prepaid expenses and other current assets Other assets Accounts payable and other accrued liabilities Accrued salaries and benefits Operating lease liabilities Other long-term liabilities Cash flows from operating activities Cash flows from investing activities Purchases of property and equipment Proceeds from sale of property and equipment Cash flows used in investing activities Cash flows from financing activities Proceeds from revolving credit facilities Payments on revolving credit facilities Payments on capital and financing lease obligations Payments on finance lease liabilities Payments of deferred financing costs Cash from landlord related to capital and financing lease obligations Repurchase of common stock Proceeds from exercise of stock options Other Cash flows used in financing activities Increase / (Decrease) in cash, cash equivalents, and restricted cash Cash, cash equivalents, and restricted cash at beginning of the period Cash, cash equivalents, and restricted cash at the end of the period Supplemental disclosure of cash flow information Cash paid for interest Cash paid for income taxes (183,232) (177,083) (198,624) 30 (198,594 (183.232 (177.082) 265,405 (180,405) 233.000 (128,000) (4,517) 153,000 (60,000) (4,192) (690) 1,325 (203,392) 9,300 (176,310) 4,878 (319) (87.441) 84.537 2.248 86.785 (2.131) 3.643 (258,307) 21,843 (59) (134,528) (17.231) 19,479 2.248 (103,959 7,014 12,465 19,479 $ S S $ 20.293 44,837 27.086 15,527 20,759 33,475 Supplemental disclosure of non-cash investing and financing activities Property and equipment in accounts payable Property acquired through capital and financing lease obligations 18.515 $ 12.001 9.081 17,869 23,882 KIES RMERS MAI CONSOLIDATED BALANCE SHEETS (IN THOUSANDS, EXCEPT SHARE AND PER SHARE AMOUNTS) December 29, 2019 December 30, 2018 S 85,314 15,713 275,979 10.833 387,839 741,508 1,028,436 185,395 368,078 11,727 2,722,983 1,588 40,564 264,366 27,323 333,841 766,429 194,803 368,078 12,463 1,675,614 $ S 261,326 48,579 253,969 48,603 7,428 ASSETS Current assets: Cash and cash equivalents Accounts receivable, net Inventories Prepaid expenses and other current assets Total current assets Property and equipment, net of accumulated depreciation Operating lease assets, net Intangible assets, net of accumulated amortization Goodwill Other assets Total assets LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Accounts payable and accrued liabilities Accrued salaries and benefits Current portion of capital and financing lease obligations Current portion of operating lease liabilities Current portion of finance lease liabilities Total current liabilities Long-term capital and financing lease obligations Long-term operating lease liabilities Long-term debt and finance lease liabilities Other long-term liabilities Deferred income tax liability Total liabilities Commitments and contingencies (Note 19) Stockholders' equity: Undesignated preferred stock; $0.001 par value; 10,000,000 shares authorized, no shares issued and outstanding Common stock, $0.001 par value; 200,000,000 shares authorized, 117,543,668 shares issued and outstanding, December 29, 2019; 124,975,691 shares issued and outstanding, December 30, 2018 Additional paid-in capital Accumulated other comprehensive income (loss) Accumulated deficit Total stockholders' equity Total liabilities and stockholders' equity 106,153 754 416,812 310.000 119,642 1,078,927 549,419 41,517 54,356 2,141,031 453,000 153,377 50,399 1,086,418 117 670,966 (4,682) (84,449) 581,952 2.722,983 124 657,140 1,134 (69,202) 589,196 1,675,614 $ $ SPROUTS FARMERS MARKET, INC. AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF INCOME (IN THOUSANDS, EXCEPT PER SHARE AMOUNTS) Net sales Cost of sales Gross profit Selling, general and administrative expenses Depreciation and amortization (exclusive of depreciation included in cost of sales) Store closure and other costs Income from operations Interest expense, net Other income Income before income taxes Income tax provision Net income Net income per share: Basic Diluted Weighted average shares outstanding: Basic Diluted Year Ended December 29, December 30, 2019 2018 $ 5,634,835 $ 5,207,336 3,740,017 3,459,861 1,894,818 1,747,475 1,549,707 1,404,443 120,491 108,045 7,260 12,076 217,360 222,911 21,192 27.435 320 196,168 195,796 46,539 37,260 $ 149,629 $ 158,536 December 31, 2017 $ 4,664,612 3,097,582 1,567.030 1,245,640 94,194 1.126 226,070 21,177 625 205,518 47,078 158,440 $ $ 1.25 1.25 $ $ 1.23 1.22 $ $ 1.17 1.15 119,368 119,742 128,827 129,776 135,169 137,884 SPROUTS FARMERS MARKET, INC. AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (IN THOUSANDS) December 29 2019 $ 149,629 Year Ended December 30, 2018 $ 158,536 December 31, 2017 $ 158,440 Net income Other comprehensive income (loss), net of tax Unrealized gain (losses) on cash flow hedging activities, net of income tax of ($2,012), $663, and ($271) Total other comprehensive income (loss) Comprehensive income (5,816) (5,816 1,918 1,918 (784) (784 $ $ 143,813 $ 160,454 157,656 SPROUTS FARMERS MARKET, INC. AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF STOCKHOLDERS' EQUITY (IN THOUSANDS, EXCEPT SHARE AMOUNTS) Additional Paid in Capital Accumulated Other Comprehensive Income (Loss) (Accumulated Deficit) Retained Earnings Common Stock Total Stockholders' Equity Shares 140,002,242 S 140 $ 597,269 $ 75,500 5 158.440 672,909 158,440 (784) (784) 2.144,669 2 9,298 9,300 (9.696.819) (10) (203,382) 14,221 (203,392) 14.221 132.450 092 S 132 $ 620,788 $ 30,558 158,536 (784) $ 650,694 158,536 1,918 1,918 3.227.693 3 Balances at January 1, 2017 Net income Other comprehensive income (loss) Issuance of shares understock plans Repurchase and retirement of common stock Share-based compensation Balances at December 31, 2017 Net income Other comprehensive income (loss) Issuance of shares under stock plans Repurchase and retirement of common stock Share-based compensation Balances at December 30, 2018 Net income Other comprehensive income (loss) Issuance of shares under stock plans Repurchase and retirement of common stock Share-based compensation Impact of adoption of ASC 842 related to leases Balances at December 29, 2019 21,840 - 21,843 (11,096,595) (258,295) (258,307) 14,512 14,512 124,581,190 S 124 $ 657,140 $ 1,134 (69.202) S 149.629 589, 196 149,629 (5,816) (5,816) 822.586 1 4,877 4,878 (7.950,858) (8) (176,302) (176,310) 8,949 8,949 11,426 11,426 117.452.918 $ 117 $ 670,966 $ (84,449) S (4,682) $ 581,962 CONSOLIDATED STATEMENTS OF CASH FLOWS (IN THOUSANDS) December 29, 2019 Year Ended December 30, 2018 December 31, 2017 149,629 $ 158,536 158,440 110.749 96,987 122,804 81.842 4,113 8.949 (216) 4,136 4,115 14,512 23,333 1.482 14,221 7.803 2,086 36,062 (11.612) 19,20B (1.275) 28.699 295 (88.002) 578 355 210 (7.666) (34,824) (2.908) (5.086) 4,366 3.039 (4,920) (25,079) (2,733) (114) 39,244 12,764 24.731 294,379 10,868 309,567 Cash flows from operating activities Net income Adjustments to reconcile net income to net cash provided by operating activities Depreciation and amortization expense Operating lease asset amortization Store closure and other costs Share-based compensation Deferred income taxes Other non-cash items Changes in operating assets and liabilities: Accounts receivable Inventories Prepaid expenses and other current assets Other assets Accounts payable and other accrued liabilities Accrued salaries and benefits Operating lease liabilities Other long-term liabilities Cash flows from operating activities Cash flows from investing activities Purchases of property and equipment Proceeds from sale of property and equipment Cash flows used in investing activities Cash flows from financing activities Proceeds from revolving credit facilities Payments on revolving credit facilities Payments on capital and financing lease obligations Payments on finance lease liabilities Payments of deferred financing costs Cash from landlord related to capital and financing lease obligations Repurchase of common stock Proceeds from exercise of stock options Other Cash flows used in financing activities Increase / (Decrease) in cash, cash equivalents, and restricted cash Cash, cash equivalents, and restricted cash at beginning of the period Cash, cash equivalents, and restricted cash at the end of the period Supplemental disclosure of cash flow information Cash paid for interest Cash paid for income taxes (183,232) (177,083) (198,624) 30 (198,594 (183.232 (177.082) 265,405 (180,405) 233.000 (128,000) (4,517) 153,000 (60,000) (4,192) (690) 1,325 (203,392) 9,300 (176,310) 4,878 (319) (87.441) 84.537 2.248 86.785 (2.131) 3.643 (258,307) 21,843 (59) (134,528) (17.231) 19,479 2.248 (103,959 7,014 12,465 19,479 $ S S $ 20.293 44,837 27.086 15,527 20,759 33,475 Supplemental disclosure of non-cash investing and financing activities Property and equipment in accounts payable Property acquired through capital and financing lease obligations 18.515 $ 12.001 9.081 17,869 23,882
