Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Village Markets, Inc. Statement of Cash Flows Refer to the attached 2016 financial statements of Village Markets, Inc. Conceptual questions: 1. What information does the

Village Markets, Inc.

Statement of Cash Flows

Refer to the attached 2016 financial statements of Village Markets, Inc.

Conceptual questions:

1. What information does the statement of cash flows provide? How is this different from the information contained in the income statement?

2. What are the three sections of the statement of cash flows? How do each of the three sections of the statement of cash flows relate to the Balance Sheet?

3. The balance sheet includes an item called Cash and cash equivalents. What are cash equivalents?

4. Net income is determined on an accrual basis. Yet, net income is the first item on the statement of cash flows. Explain this apparent inconsistency.

Process question:

5. Prepare a 2016 statement of cash flows for Village Markets using the indirect method. Please use the template provided on page 13 to present your statement of cash flows.

Recall that the change in cash (i.e., the statement of cash flows) is algebraically related to the balance sheet as follows:

Cash = Liabilities + Owners Equity All Other Assets

Thus, if you can explain the change in each of the non-cash balance sheet accounts (and only those accounts), you will have generated a statement of cash flows.

Use a set of T-accounts for the balance sheet accounts (T-account templates are included on pages 8 through 10 of the case). For each balance sheet, consider what transactions and activities explain the change in the account. Classify each transaction and activity as operating, investing or financing to prepare the statement of cash flows for Village Markets. Please be sure to turn in your t-accounts with this case.

The following five items provide additional information to help you prepare the statement of cash flows. All dollar amounts are in thousands.

a. Note 4 to Village Markets 2016 financial statements reveals the following:

(4) Property and Equipment

Property and equipment, as of December 31, 2016 and December 31, 2015, consisted of:

(dollars in thousands)

Useful Life (in years)

2016

2015

Land

$84,094

$84,094

Buildings and Improvements

10-60

406,164

391,357

Equipment

3-12

608,458

585,213

Leasehold Improvements

5-20

130,978

121,263

Total, at cost

1,229,694

1,181,927

Less accumulated depreciation and amortization

730,238

689,384

Property and equipment, net

$499,456

$492,543

In 2016, depreciation and amortization expense on property and equipment was $49,290. In April, 2016, the company purchased $67,748 of new property, plant, and equipment. The company used cash to fund 30% of the total cost property and equipment and financed the balance with a note to Fourth Bank & Trust (see item (d) below for details of the new loan). The company sold property and equipment for $9,620 in cash during 2016. No other property and equipment was acquired or sold in 2016.

5(a) continued.

Activities in the fixed asset accounts affect the statement of cash flows in four ways. Determine each of the four items, i through iv, below. To do this, create two T-accounts, one for property and equipment at cost and another for accumulated depreciation and amortization. Use the information from Village Markets Note 4 to analyze the activity in both accounts during the year.

i. Depreciation and amortization expense is included in the operating section of the statement of cash flows. Explain why. Does depreciation expense actually generate cash for Weis Markets?

ii. Capital expenditures (i.e. cash used to purchase new property and equipment) are included in the investing section of the statement of cash flows as a use of cash.

iii. Cash proceeds from the disposal of property and equipment are included in the investing section as a source of cash.

iv. Gains and losses on disposals of fixed assets are included in the operating section of the statement of cash flows.

b. Village Markets did not purchase any new intangible assets in 2016. Amortization expense for the year was directly credited to the Intangible assets account. Analyze the activity in the Intangible and other assets, net account during 2016 using the t-account worksheet provided.

c. Short-term investments at December 31, 2016 consist solely of investments in 1-year certificates of deposit with a maturity date of September 1, 2017. There were no outstanding investments at December 31, 2015. No sales or maturities of investment securities occurred during fiscal 2016. Analyze the activity in the Short-term Investment account during 2016 using the t-account worksheet provided.

5 d. On April 1, 2016, the company borrowed $47,424 from Fourth Bank & Trust to help fund the purchase of property and equipment (see item (a) above). Details of the outstanding note are as follows:

December 31

2016

2015

6% note payable to Fourth Bank & Trust, issued on April 1, 2016, requiring quarterly principal payments of $1,248, plus interest beginning on July 1, 2016 through December, 2025.

$44,928

$ 0

Less current portion

(4,992)

(0)

Long-term portion of notes payable

$39,936

$ 0

Analyze the activity in the note payable account during 2016 using the t-account worksheet provided. Note: it is easiest to combine the current and long-term note payable accounts when analyzing the activity.

Analysis questions:

6. Use the 2016 statement of cash flows you constructed, the statements of cash flow for 2015 and 2014, and the statements of income for 2014 through 2016, to evaluate Village Markets profitability and ability to generate cash. Comment on the nature of the differences between net income and cash from operations in each year.

7. Refer to the companys statements of cash flows for 2014 through 2016. Has Village Markets maintained its productive capacity, expanded it or decreased it over the last three years? Explain.

8. Consider the following January 15, 2017 press release by Village Markets relating to planned capital expenditures:

(Chicago, IL) -- Village Markets, Inc.s Vice Chairman Jonathan Weisman today said his company would invest $90 million in its growth over the next twelve months. Mr. Weisman made the announcement at his companys annual shareholder meeting, which was held in Chicago earlier today.

For the coming year, we plan to invest nearly $90 million in our growth. We will target three quarters of this budget to our store base, said Mr. Weisman. We currently have 19 major projects in various stages of planning, including three new stores, two replacement units, nine additions and five remodels.

Mr. Weisman noted this is nearly a 33% increase over 2016, when his company made $67.7 million in capital expenditures.

Discuss Village Markets capacity for increasing its capital expenditures. What are the likely sources of cash to fund the increased level of investment in property and equipment?

The T-accounts for all the balance sheet accounts are as follows:

Cash and cash equivalents

Opening Balance

65,708

Operating activities

Net Income

Investing activities

Financing activities

Closing Balance

53,566

T-accounts for all the balance sheet accounts (continued):

Short-term investments

Accounts receivable

Inventory

Prepaid expenses

Property and equipment, gross

Accumulated depreciation

Goodwill

Intangibles and

other assets, net

Accounts payable

Accrued salaries

Dividends payable

Income taxes payable

Other accrued expenses

Long-term notes payable

(incl. current portion)

Common stock

Retained earnings

VILLAGE MARKETS, INC.

CONSOLIDATED BALANCE SHEETS

(dollars in thousands)

December 31

2016

2015

Assets

Current:

Cash and cash equivalents

$

53,566

$

65,708

Short-term investments

19,256

0

Accounts receivable

48,246

41,885

Inventories

189,223

189,468

Prepaid expenses

3,144

3,932

Total current assets

313,435

300,993

Property and equipment, net

499,456

492,543

Goodwill

15,722

15,722

Intangible and other assets, net

4,322

4,804

Total assets

$

832,935

$

814,062

Liabilities

Current:

Accounts payable

$

70,892

$

105,859

Current portion of long-term debt

4,992

--

Accrued salaries

16,759

22,307

Dividends payable

7,202

6,912

Income taxes payable

16,187

22,778

Other accrued expenses

26,043

33,127

Total current liabilities

142,075

190.983

Long-term debt

39,936

--

Total liabilities

182,011

190,983

Shareholders' Equity

Common stock, no par value, 100,800,000 shares authorized, 33,044,357 and 33,009,046 shares issued, respectively

10,040

8,595

Retained earnings

640,884

614,484

Total shareholders' equity

650,924

623,079

Total liabilities and shareholders' equity

$

832,935

$

814,062

See accompanying notes to consolidated financial statements.

VILLAGE MARKETS, INC.

CONSOLIDATED STATEMENTS OF INCOME

(dollars in thousands, except shares and per share amounts)

For the Fiscal Years Ended December 31,

2016

2015

2014

Net sales

$2,318,551

$2,244,512

$2,222,598

Cost of sales, including warehousing and distribution expenses

1,716,424

1,647,233

1,634,874

Gross profit on sales

602,127

597,279

587,724

Operating, general and administrative expenses

527,378

515,675

491,499

Income from operations

74,749

81,604

96,225

Investment income

3,010

4,484

3,081

Income before provision for income taxes

77,759

86,088

99,306

Provision for income taxes

26,769

30,078

35,885

Net income

$ 50,990

$ 56,010

$ 63,421

Weighted-average shares outstanding, basic

26,987,786

27,016,877

27,026,748

Weighted-average shares outstanding, diluted

26,993,997

27,027,198

27,033,789

Cash dividends per share

$ 1.16

$ 1.16

$ 1.12

Basic and diluted earnings per share

$ 1.89

$ 2.07

$ 2.35

See accompanying notes to consolidated financial statements.

VILLAGE MARKETS, INC.

CONSOLIDATED STATEMENTS OF CASH FLOWS

(dollars in thousands)

For the Fiscal Years Ended December 31

2016

2015

2014

Cash flows from operating activities:

Net income

$

$ 56,010

$ 63,421

Adjustments to reconcile net income to

net cash provided by operating activities:

Depreciation and amortization of property and equipment

50,288

49,215

Amortization of intangible assets

732

891

(Gain) loss on disposition of fixed assets

974

519

(Gain) loss on sale of short-term investments

431

(422

)

Changes in operating assets and liabilities:

Accounts receivable

(10,086

)

(8,338

)

Inventories

(1,365

)

(3,424

)

Prepaid expenses

1,592

1,729

Accounts payable

10,277

7,636

Accrued salaries

8,429

(5,291

)

Income taxes payable

(5,762

)

(2,845

)

Other accrued expenses

1,125

1,311

Net cash provided by operating activities

112,645

104,402

Cash flows from investing activities:

Purchase of property and equipment

(59,975

)

(55,468

)

Proceeds from the sale of property and equipment

2,696

291

Purchase of short-term investments

(33,020

)

(8,248

)

Proceeds from the sale of short-term investments

554

902

Net cash used in investing activities

(89,745

)

(62,523

)

Cash flows from financing activities:

Proceeds from issuance of common stock

224

172

Dividends paid

(25,344

)

(30,270

)

Proceeds from issuance of note payable

--

--

Payments on notes payable

(1,372

)

(715

)

Net cash provided by (used in) financing activities

(26,492

)

(30,813

)

Net increase (decrease) in cash and cash equivalents

(3,592

)

11,066

Cash and cash equivalents at beginning of year

69,300

58,234

Cash and cash equivalents at end of year

$

$ 65,708

$ 69,300

See accompanying notes to consolidated financial statements.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Labor Economics

Authors: Campbell McConnell, Stanley Brue, David Macpherson

9th Edition

0073375950, 9780073375953

More Books

Students also viewed these Accounting questions

Question

Able to describe variations in rewards practices.

Answered: 1 week ago