17.6: Exercises- Unit 17
- Page ID
- 26293
\( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)
\( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)
\( \newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\)
( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\)
\( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\)
\( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\)
\( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\)
\( \newcommand{\Span}{\mathrm{span}}\)
\( \newcommand{\id}{\mathrm{id}}\)
\( \newcommand{\Span}{\mathrm{span}}\)
\( \newcommand{\kernel}{\mathrm{null}\,}\)
\( \newcommand{\range}{\mathrm{range}\,}\)
\( \newcommand{\RealPart}{\mathrm{Re}}\)
\( \newcommand{\ImaginaryPart}{\mathrm{Im}}\)
\( \newcommand{\Argument}{\mathrm{Arg}}\)
\( \newcommand{\norm}[1]{\| #1 \|}\)
\( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\)
\( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\AA}{\unicode[.8,0]{x212B}}\)
\( \newcommand{\vectorA}[1]{\vec{#1}} % arrow\)
\( \newcommand{\vectorAt}[1]{\vec{\text{#1}}} % arrow\)
\( \newcommand{\vectorB}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)
\( \newcommand{\vectorC}[1]{\textbf{#1}} \)
\( \newcommand{\vectorD}[1]{\overrightarrow{#1}} \)
\( \newcommand{\vectorDt}[1]{\overrightarrow{\text{#1}}} \)
\( \newcommand{\vectE}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash{\mathbf {#1}}}} \)
\( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \)
\( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)
\(\newcommand{\avec}{\mathbf a}\) \(\newcommand{\bvec}{\mathbf b}\) \(\newcommand{\cvec}{\mathbf c}\) \(\newcommand{\dvec}{\mathbf d}\) \(\newcommand{\dtil}{\widetilde{\mathbf d}}\) \(\newcommand{\evec}{\mathbf e}\) \(\newcommand{\fvec}{\mathbf f}\) \(\newcommand{\nvec}{\mathbf n}\) \(\newcommand{\pvec}{\mathbf p}\) \(\newcommand{\qvec}{\mathbf q}\) \(\newcommand{\svec}{\mathbf s}\) \(\newcommand{\tvec}{\mathbf t}\) \(\newcommand{\uvec}{\mathbf u}\) \(\newcommand{\vvec}{\mathbf v}\) \(\newcommand{\wvec}{\mathbf w}\) \(\newcommand{\xvec}{\mathbf x}\) \(\newcommand{\yvec}{\mathbf y}\) \(\newcommand{\zvec}{\mathbf z}\) \(\newcommand{\rvec}{\mathbf r}\) \(\newcommand{\mvec}{\mathbf m}\) \(\newcommand{\zerovec}{\mathbf 0}\) \(\newcommand{\onevec}{\mathbf 1}\) \(\newcommand{\real}{\mathbb R}\) \(\newcommand{\twovec}[2]{\left[\begin{array}{r}#1 \\ #2 \end{array}\right]}\) \(\newcommand{\ctwovec}[2]{\left[\begin{array}{c}#1 \\ #2 \end{array}\right]}\) \(\newcommand{\threevec}[3]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \end{array}\right]}\) \(\newcommand{\cthreevec}[3]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \end{array}\right]}\) \(\newcommand{\fourvec}[4]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \\ #4 \end{array}\right]}\) \(\newcommand{\cfourvec}[4]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \\ #4 \end{array}\right]}\) \(\newcommand{\fivevec}[5]{\left[\begin{array}{r}#1 \\ #2 \\ #3 \\ #4 \\ #5 \\ \end{array}\right]}\) \(\newcommand{\cfivevec}[5]{\left[\begin{array}{c}#1 \\ #2 \\ #3 \\ #4 \\ #5 \\ \end{array}\right]}\) \(\newcommand{\mattwo}[4]{\left[\begin{array}{rr}#1 \amp #2 \\ #3 \amp #4 \\ \end{array}\right]}\) \(\newcommand{\laspan}[1]{\text{Span}\{#1\}}\) \(\newcommand{\bcal}{\cal B}\) \(\newcommand{\ccal}{\cal C}\) \(\newcommand{\scal}{\cal S}\) \(\newcommand{\wcal}{\cal W}\) \(\newcommand{\ecal}{\cal E}\) \(\newcommand{\coords}[2]{\left\{#1\right\}_{#2}}\) \(\newcommand{\gray}[1]{\color{gray}{#1}}\) \(\newcommand{\lgray}[1]{\color{lightgray}{#1}}\) \(\newcommand{\rank}{\operatorname{rank}}\) \(\newcommand{\row}{\text{Row}}\) \(\newcommand{\col}{\text{Col}}\) \(\renewcommand{\row}{\text{Row}}\) \(\newcommand{\nul}{\text{Nul}}\) \(\newcommand{\var}{\text{Var}}\) \(\newcommand{\corr}{\text{corr}}\) \(\newcommand{\len}[1]{\left|#1\right|}\) \(\newcommand{\bbar}{\overline{\bvec}}\) \(\newcommand{\bhat}{\widehat{\bvec}}\) \(\newcommand{\bperp}{\bvec^\perp}\) \(\newcommand{\xhat}{\widehat{\xvec}}\) \(\newcommand{\vhat}{\widehat{\vvec}}\) \(\newcommand{\uhat}{\widehat{\uvec}}\) \(\newcommand{\what}{\widehat{\wvec}}\) \(\newcommand{\Sighat}{\widehat{\Sigma}}\) \(\newcommand{\lt}{<}\) \(\newcommand{\gt}{>}\) \(\newcommand{\amp}{&}\) \(\definecolor{fillinmathshade}{gray}{0.9}\)SHORT Answer QUESTIONS, EXERCISES AND PROBLEMS
Questions
➢ What are the purposes of the statement of cash flows?
➢ What are some of the uses of the statement of cash flows?
➢ What information is contained in the statement of cash flows?
➢ Which activities are generally included in operating activities?
➢ Which activities are included in investing activities?
➢ Which activities are included in financing activities?
➢ Where should significant investing and financing activities that do not involve cash flows be reported?
➢ Explain the difference between the direct and indirect methods for computing cash flows from operating activities.
➢ What are noncash expenses? How are they treated in computing cash flows from operating activities?
➢ Describe the treatment of a gain on the sale of equipment in preparing a statement of cash flows under the indirect method.
➢ Depreciation is sometimes referred to as a source of cash. Is it a source of cash? Explain.
➢ Why is it unlikely that cash flows from operating activities will be equal to net income for the sameperiod?
➢ If the net income for a given period is $ 25,000, does this mean there is an increase in cash of the same amount? Why or why not?
➢ Why might a company have positive cash flows from operating activities even though operating at a net loss?
➢ Indicate the type of activity each of the following transactions represents (operating, investing, or financing) and whether it is an inflow or an outflow.
- Sold goods.
- Purchased building.
- Issued capital stock.
- Received cash dividends.
- Paid cash dividends.
- Purchased treasury stock.
- Sold available-for-sale securities.
- Made a loan.
- Paid interest on loan.
- Paid bond principal.
- Received proceeds of insurance settlement.
- Made contribution to charity.
Exercises
Exercise A Indicate how the following data should be reported in a statement of cash flows. A company paid $ 500,000 cash for land. A building was acquired for $ 2,500,000 by assuming a mortgage on the building.
Exercise B Cost of goods sold in the income statement for the year ended 2010 was $ 260,000. The balances in Merchandise Inventory and Accounts Payable were:
| 2010 January 1 | 2010 December 31 | |
| Merchandise inventory | $160,000 | $180,000 |
| Accounts payable | 44,000 | 36,000 |
Calculate the amount of cash paid for merchandise for 2010.
Exercise C Fill in the following chart, showing how increases and decreases in these accounts affect the conversion of accrual basis income to cash basis income:
| Add | Deduct | |
| Accounts receivable | ||
| Merchandise inventory | ||
| Prepaid expenses | ||
| Accounts payable | ||
| Accrued liabilities payable |
Exercise D The income statement of a company shows net income of $ 200,000; merchandise inventory on January 1 was $ 76,500 and on December 31 was $ 94,500; accounts payable for merchandise purchases were $ 57,000 on January 1 and $ 68,000 on December 31. Compute the cash flows from operating activities under the indirect method.
Exercise E The operating expenses and taxes (including $ 80,000 of depreciation) of a company for a given year were $ 600,000. Net income was $ 350,000. Prepaid insurance decreased from $ 18,000 to $ 14,000 during the year, while wages payable increased from $ 22,000 to $ 36,000 during the year. Compute the cash flows from operating activities under the indirect method.
Exercise F Dividends payable increased by $ 20,000 during a year in which total dividends declared were $ 120,000. What amount appears for dividends paid in the statement of cash flows?
Exercise G Following are balance sheet data for Quality Merchandise, Inc.:
| December 31 | ||
| 2011 | 2010 | |
| Cash | $ 47,000 | $ 26,000 |
| Accounts receivable, net | 141,000 | 134,000 |
| Merchandise inventory | 83,000 | 102,000 |
| Prepaid expenses | 9,000 | 11,000 |
| Plant assets (net of accumulated depreciation) | 235,000 | 230,000 |
| Accounts payable | 122,000 | 127,000 |
| Accrued liabilities payable | 40,000 | 41,000 |
| Capital stock | 300,000 | 300,000 |
| Retained earnings | 53,000 | 35,000 |
Assume that the depreciation recorded in 2011 was $ 15,000. Compute the cash spent to purchase plant assets, assuming no assets were sold or scrapped in 2011.
Exercise H Use the data in the previous exercise. Assume the net income for 2011 was $ 24,000, depreciation was $ 15,000, and dividends declared and paid were $ 6,000. The company paid interest of $ 2,000 and income taxes of $ 14,000. Prepare a statement of cash flows—indirect method. Also prepare any necessary supplemental schedule(s).
Exercise I The following data are from a company’s Automobile and the Accumulated Depreciation—Automobile accounts:
| Date | Automobile | Debit | Credit | Balance |
| Jan. 1 | Balance brought forward | 16,000 | ||
| July 1 | Traded for new auto | 16,000 | -0- | |
| New auto | 31,000 | |||
| Accumulated depreciation – | Automobile | |||
| Jan. 1 | Balance brought forward | 12,000 | ||
| July 1 | One-half year’s depreciation | 2,000 | 14,000 | |
| Auto traded | 14,000 | -0- | ||
| Dec. 31 | One-half year’s depreciation | 4,000 | 4,000 |
The old auto was traded for a new one, with the difference in values paid in cash. The income statement for the year shows a loss on the exchange of autos of $ 1,200.
Indicate the dollar amounts, the descriptions of these amounts, and their exact locations in a statement of cash flows—indirect method.
Problems
Problem A The income statement and other data of Dunbar Carpet Outlet, Inc., follow:
Dunbar Carpet Outlet, Inc.
Income statement
For the Year Ended 2010 December 31
| Sales | $920,000 | |
| Cost of goods sold | 380,000 | |
| Gross margin | $540,000 | |
| Operating expenses (other than depreciation) | $140,000 | |
| Depreciation expense | 40,000 | 180,000 |
| Net income | $360,000 |
Changes in current assets (other than cash) and current liabilities during the year were:
| Increase | Decrease | |
| Accounts receivable | $20,000 | |
| Merchandise inventory | $16,000 | |
| Prepaid insurance | 8,000 | |
| Accounts payable | 28,000 | |
| Accrued liabilities payable | 4,000 |
Depreciation was the only noncash item affecting net income.
- Prepare a working paper to calculate cash flows from operating activities under the direct method.
- Prepare the cash flows from operating activities section of the statement of cash flows under the direct method.
- Prove that the same cash flows amount will be obtained under the indirect method by preparing the cash flows from operating activities section of the statement of cash flows under the indirect method. You need not prepare a working paper.
Problem B The following comparative balance sheets and other data are for Cellular Telephone Sales, Inc.:
Cellular Telephone Sales, Inc.
Comparative balance sheets
2011 December 31 and 2010
| 2011 | 2010 | |
| Assets | ||
| Cash | $76,105 | $51,000 |
| Accounts receivable, net | 26,075 | 24,250 |
| Merchandise inventory | 30,000 | 35,000 |
| Supplies on hand | 1,750 | 2,550 |
| Prepaid expenses | 1,400 | 1,200 |
| Land | 180,000 | 142,500 |
| Equipment | 270,000 | 300,000 |
| Accumulated depreciation – equipment | (75,000) | (67,500) |
| Total assets | $510,330 | $489,000 |
| Liabilities and stockholders’ equity | ||
| Accounts payable | $ 45,330 | $ 76,300 |
| Salaries payable | 4,000 | 2,000 |
| Accrued liabilities payable | 2,000 | 8,250 |
| Long-term note payable | 150,000 | 150,000 |
| Common stock ($5 par) | 185,000 | 165,000 |
| Paid-in capital in excess of par | 32,500 | -0- |
| Retained earnings | 91,500 | 87,450 |
| Total liabilities and stockholders’ equity | $510,330 | $489,000 |
Land was bought for $ 37,500 cash. The company intends to build a building on the land. Currently the company leases a building for its operations.
Equipment costing $ 50,000 with accumulated depreciation of $ 30,000 was sold for $ 23,500 (a gain of $ 3,500), and equipment costing $ 20,000 was purchased for cash.
Depreciation expense for the year was $ 37,500.
Common stock was issued for $ 52,500 cash.
Dividends declared and paid in 2011 totaled $ 32,950.
Net income was $ 37,000.
The company paid interest of $ 3,000 and income taxes of $ 17,000.
Prepare a statement of cash flows under the indirect method. Also prepare any necessary supplemental schedule(s).
Problem C Computer Associates International, Inc., is leading business software company. The company was founded in 1977 with four employees and has grown to 18,200 employees and about 4.2 billion in revenues.
The company’s statements of cash flows for the years 2002 through 2004 follow. Then the relevant portion of Management’s Discussion and Analysis of the statement of cash flows is provided.
Consolidated statements of cash flows
| Year Ended | March 31 | ||
| Operating activities: | 2004 | 2003 | 2002 |
| (In millions) | |||
| Net (loss) income | $ (591) | $ 696 | $ 626 |
| Adjustments to reconcile net (loss) income to net cash provided by operating activities: | |||
| Depreciation and amortization | 1,110 | 594 | 325 |
| Provision for deferred income taxes (benefit) | (350) | 412 | 107 |
| Charge for purchased research and development | — | 795 | — |
| Compensation (gain) expense related to stock pension plants | (146) | 30 | 778 |
| Decrease (increase) in noncurrent installment accounts receivable, net | 956 | (1,039) | (422) |
| Decrease (increase) in deferred maintenance revenue | (3) | 113 | 43 |
| Foreign currency transaction loss – before taxes | 14 | 5 | 11 |
| Charge for investment write-off | — | 50 | — |
| Gain on sale of property and equipment | — | (5) | (14) |
| Changes in other operating assets and liabilities, net of effects of acquisitions: | |||
| Decrease (increase) in trade and installment receivables | 418 | 83 | (169) |
| Other changes in operating assets and liabilities | (25) | (168) | (18) |
| Net cash provided by operating activities | $ 1,383 | $ 1,566 | $ 1,267 |
| Investing activities: | |||
| Acquisitions, primarily purchased software, marketing rights and intangibles, net of cash acquired |
$ (174) | $ (3,049) | $ (610) |
| Settlements of purchases accounting liabilities | (367) | (429) | (57) |
| Purchases of property and equipment | (89) | (198) | (222) |
| Proceeds from sale of property and equipment | 5 | 12 | 38 |
| Disposition of businesses | 158 | — | — |
| Purchases of marketable securities | (48) | (95) | (2,703) |
| Sales of marketable securities | 40 | 189 | 2,639 |
| Increase in capitalized development costs and other | (49) | (36) | (29) |
| Net cash used in investing activities | $ (524) | $ (3,606) | $ (944) |
| Financing activities: | |||
| Dividends | $ (47) | $ (43) | $ (44) |
| Purchases of treasury stock | (449) | — | (1,090) |
| Proceeds from borrowings | 1,049 | 3,672 | 2,141 |
| Repayment of borrowings | (1,981) | (776) | (1,216) |
| Exercise of common stock options and other | 50 | 96 | 38 |
| Net cash provided by (used in) financing activities | $ (1,378) | $ 2,949 | $ (171) |
| (Decrease) Increase in cash and cash equivalents before effect of exchange rate changes on cash | $ (519) | $ 909 | $ 152 |
| Effect of exchange rate changes on cash | (25) | (1) | (4) |
| (Decrease) Increase in cash and cash equivalents | $ (544) | $ 908 | $ 148 |
| Cash and cash equivalents – Beginning of year | 1,307 | 399 | 251 |
| Cash and cash equivalents – End of the year | $ 763 | $ 1,307 | $ 399 |
Management’s discussion and analysis
Liquidity and capital resources
Cash, cash equivalents and marketable securities totaled $ 850 million at 2004 March 31, a decrease of $ 537 million from the 2003 March 31 balance of $ 1,387 million. During fiscal year 2004, the Company used cash on hand to repay over $ 900 million in debt and repurchase approximately $ 450 million in treasury stock. Cash generated from operations for fiscal year 2001 was $ 1,383 million, a decrease of $ 183 million from the prior year’s cash from operations of $ 1,566 million. Cash from operations was unfavorably impacted this current fiscal year due to higher costs associated with increased headcount and other expenses related to the Sterling acquisition.
The Company’s bank credit facilities consist of a $ 1 billion four-year revolving credit facility, a $ 2 billion four-year term loan, and a 75 million British Pound Sterling denominated 364-day term loan. During the year, the Company repaid all outstanding amounts under both its $ 1.3 billion 364-day and four-year revolving credit agreements. As a reflection of its continued reduced need for bank borrowings, emphasis on debt reduction, and overall expected ability to generate cash from operations, the Company did not renew its $ 1.3 billion 364-day revolving credit facility when it expired in May 2004.
As of 2004 March 31, $ 2 billion remained outstanding under the four-year term loan and approximately $ 124 million was outstanding under the pound sterling term loan at various interest rates. There are no drawings under the Company’s $ 1 billion four-year revolving credit facility. The interest rates on such debt are determined based on a ratings grid, which applies a margin to the prevailing London InterBank Offered Rate (“LIBOR”). In addition, the Company established a $ 1 billion US Commercial Paper (“CP”) program in the first quarter of this year to refinance some of its debt at more attractive interest levels. As of 2004 March 31, $ 340 million was outstanding under the CP program.
The Company also utilizes other financial markets in order to maintain its broad sources of liquidity. In fiscal 2002, $ 1.75 billion of unsecured Senior Notes were issued in a transaction governed by Rule 144A of the Securities Act of 1933. Amounts borrowed, rates and maturities for each issue were $ 575 million at 6.25 per cent due 2006 April 15, $ 825 million at 6.375 per cent due 2008 April 15 and $ 350 million at 6.5 per cent due 2011 April 15. As of 2004 March 31, $ 192 million was outstanding under the Company’s 6.77 per cent Senior Notes. These Notes call for annual repayment of $ 64 million each April until final maturity in 2006.
Unsecured and uncommitted multicurrency lines of credit are available to meet any short-term working capital needs for subsidiaries operating outside the US. These lines total $ 56 million, of which $ 14 million was drawn as of 2004 March 31.
Debt ratings for the Company’s senior unsecured notes and its bank credit facilities are BBB+ and Baa1 from Standard & Poor’s and Moody’s Investor Services, respectively. The Company’s Commercial Paper program is rated A-2 from Standard & Poor’s and P-2 from Moody’s. Peak borrowings under all debt facilities during fiscal year 2004 totaled approximately $ 5.4 billion with a weighted-average interest rate of 7.2 per cent.
As of 2004 March 31, the cumulative number of shares purchased under the Company’s various open market Common Stock repurchase programs, including almost 16 million shares purchased in the current fiscal year, was 166 million. The remaining number of shares authorized for repurchase is approximately 34 million.
Capital resource requirements as of 2004 March 31 consisted of lease obligations for office space, computer equipment, mortgage or loan obligations and amounts due as a result of product and company acquisitions. It is expected that existing cash, cash equivalents, marketable securities, the availability of borrowings under credit lines and cash provided from operations will be sufficient to meet ongoing cash requirements.
The Company expects its long-standing history of providing extended payment terms to customers to continue under the new business model and thus does not expect a change to its future cash flow, since customers are expected to continue to finance their purchases over the contract period.
- Explain how the company could have a net loss in 2004 and yet have a positive net cash provided by operating activities.
- What was the reason given by management for repaying all outstanding amounts under revolving credit agreements.
- What is the interest rate on borrowings?
- What information would normally appear immediately below the statement of cash flows that seems to be missing?
- Does the amount of cash provided by operating activities seem large enough to continue the present dividend payments?
- Given the following data, calculate the cash flow per share of common stock ratio, the cash flow margin ratio, and cash flow liquidity ratio.
| (in millions) | |
| Average number of shares of common stock outstanding | 583 |
| Net sales | 4,198 |
| Cash and marketable securities | 850 |
| Current liabilities | 2,286 |
Problem D Mechan Company develops, manufactures, markets, installs and supports a wide range of standards-based LAN and WAN connectivity hardware and software products. The company’s statements of cash flow for the years 2008-2010 follow. Then the relevant portion of Management’s Discussion and Analysis of the statement of cash flows is provided.
Consolidated statements of cash flows
Years ended 2010 February 29, and 2009 February 28 and 2008
(In thousands)
| 2010 | 2009 | 2008 | |
| Cash flows from operating activities: | |||
| Net income | $ 164,418 | $ 161,974 | $ 119,218 |
| Adjustments to reconcile net income to net cash provided by operating activities: | |||
| Depreciation and amortization | 32,061 | 26,832 | 17,335 |
| Provision for losses on accounts receivable | 356 | 72 | 1,734 |
| Loss on disposals of property, plant and equipment | 93 | 174 | 113 |
| Deferred taxes | (38,766) | (4,434) | (6,151) |
| Changes in assets and liabilities: | |||
| Accounts receivables | (55,101) | (27,698) | (17,707) |
| Inventories | (50,483) | (23,080) | (8,758) |
| Prepaid expenses and other assets | (18,844) | (3,123) | 1,211 |
| Accounts payable and accrued expenses | 62,908 | 11,336 | 22,003 |
| Income taxes payable | 3,705 | 10,476 | (3,924) |
| Net cash provided by operating activities | $100,347 | $152,529 | $125,074 |
| Cash flows from investing activities: | |||
| Capital expenditures | $ (65,035) | $ (63,091) | $ (39,399) |
| Purchase of available-for-sale securities | (79,427) | (71,598) | (30,097) |
| Purchase of held-to-maturity securities | (205,852) | (282,712) | (258,517) |
| Materials of marketable securities | 208,922 | 323,682 | 197,406 |
| Net cash used in investing activities | $(141,392) | $ (93,719) | $(130,607) |
| Cash flows from financing activities: | |||
| Repayment of notes receivable from stockholders | $ 174 | $ 131 | $ 66 |
| Repurchase of common stock | (1,173) | (13,070) | — |
| Tax benefit of options exercised | 7,215 | 5,712 | 6,980 |
| Common stock issued to employee stock purchase plan | 3,323 | 2,287 | 1,637 |
| Proceeds from stock option exercise | 16,021 | 4,887 | 7,185 |
| Net cash provided by (used for) financing activities | $ 25,560 | $ (53) | $ 15,868 |
| Effect of exchange rate changes on cash | $ 166 | $ 712 | $ 161 |
| Net increase (decrease) in cash and cash equivalents | $ (15,319) | $ 59,469 | $ 10,469 |
| Cash and cash equivalents, beginning of year | 114,032 | 54,563 | 44,067 |
| Cash and cash equivalents, end of year | $ 98,713 | $ 114,032 | $ 54,563 |
| Cash paid during the year for: | |||
| Income taxes | $ 105,233 | $ 68,420 | $ 67,263 |
Management’s discussion and analysis
Net cash provided by operating activities was $ 100.3 million in fiscal 2010, compared to $ 152.5 million in fiscal 2009 and $ 125.1 million in fiscal 2008.
Capital investment for fiscal 2010 of $ 65.0 million included $ 9.8 million for building costs of which $ 3.4 was for the purchase of an engineering building, $ 21.4 million for engineering computer and computer related software and equipment, $ 5.5 million for manufacturing and related equipment and $ 19.0 million for expanding global sales operations. During fiscal 2009, capital expenditures of $ 63.1 million included approximately $ 8.2 million for building costs related to expanding manufacturing and distribution capacities and enlarging worldwide sales operations, $ 12.5 million for manufacturing and manufacturing support equipment and $ 15.0 million for engineering computer and computer related equipment. Another $ 15.0 million was spent in support of expanded global sales activities. During fiscal 2008, capital expenditures of $ 39.4 million included $ 3.9 million on buildings, $ 10.1 million on engineering equipment, $ 7.8 million on manufacturing capacity expansions and $ 2.0 million to equip new sales offices.
Cash, cash equivalents and marketable securities increased during fiscal 2010 to $ 407.0 million, from $ 345.9 million in the prior fiscal year. State and local municipal bonds of approximately $ 264.2 million, maturing in approximately 1.5 years, were being held by the Company at 2010 February 29.
At 2010 February 29, the Company did not have any short or long term borrowing or any significant financial commitments outstanding, other than those required in the normal course of business.
In the opinion of management, internally generated funds from operations and existing cash, cash equivalents and marketable securities will be adequate to support the Company’s working capital and capital expenditures requirements for both short and long term needs.
- Which method did the company use in arriving at net cash flows from operating activities?
- Did current assets other than cash increase or decrease during the year ended 2010 February 29?
- Did current liabilities increase or decrease during the year ended 2010 February 29?
- What were the main investing activities during this three-year period?
- What was the main source of cash from financing activities during the three-year period?
- Did the company pay any interest expense during the year ended 2010 February 19?
- Given the following data, calculate the cash flow per share of common stock ratio, the cash flow margin ratio, and the cash flow liquidity ratio. How do these ratios compare with the ratios shown for other companies in the chapter?
| (in thousands) | |
| Average number of shares of common stock outstanding | 71,839 |
| Net sales | $ 1,069,715 |
| Cash and marketable securities | 253,540 |
| Current liabilities | 164,352 |
Problem E The following comparative balance sheets and other data are for Dayton Tent & Awning Sales, Inc.:
Dayton Tent & Awning Sales, Inc.
Comparative Balance Sheets
2011 June 30 and 2010
| 2011 | 2010 | |
| Assets | ||
| Cash | $ 441,800 | $ 332,600 |
| Accounts receivable, net | 750,750 | 432,900 |
| Merchandise inventory | 819,000 | 850,200 |
| Prepaid insurance | 3,900 | 5,850 |
| Land | 312,000 | 351,000 |
| Buildings | 2,184,000 | 1,209,000 |
| Machinery and tools | 858,000 | 468,000 |
| Accumulated depreciation – machinery and tools | (809,250) | (510,900) |
| Total assets | $ 4,560,200 | $ 3,138,650 |
| Liabilities and stockholders’ equity | ||
| Accounts payable | $ 226,750 | $ 275,500 |
| Accrued liabilities payable | 185,800 | 111,700 |
| Bank loans (due in 2009) | 56,550 | 66,300 |
| Mortgage bonds payable | 382,200 | 185,250 |
| Common stock – $100 par | 1,755,000 | 585,000 |
| Paid-in capital in excess of par | 58,500 | -0- |
| Retained earnings | 1,895,400 | 1,914,900 |
| Total liabilities and stockholders’ equity | $ 4,560,200 | $ 3,138,650 |
Net income for the year was $ 128,000.
Depreciation for the year was $ 356,850.
There was a gain of $ 7,800 on the sale of land. The land was sold for $ 46,800.
The additional mortgage bonds were issued at face value as partial payment for a building valued at $ 975,000. The amount of cash paid was $ 778,050.
Machinery and tools were purchased for $ 448,500 cash.
Fully depreciated machinery with a cost of $ 58,500 was scrapped and written off.
Additional common stock was issued at $ 105 per share. The total proceeds were $ 1,228,500.
Dividends declared and paid were $ 147,500.
A payment was made on the bank loan, $ 9,750.
The company paid interest of $ 9,000 and income taxes of $ 75,000.
- Prepare a working paper for a statement of cash flows.
- Prepare a statement of cash flows under the indirect method. Also prepare any necessary supplemental schedule(s).
Alternate problem A The following income statement and other data are for Kennesaw Auto Glass Specialists, Inc..
Kennesaw auto glass specialists, Inc.
Income Statement
For the year ended 2010 December 31
| Sales | $450,000 | |
| Cost of goods sold | 125,000 | |
| Gross margin | $325,000 | |
| Operating expenses (other than depreciation) | $60,000 | |
| Depreciation expense | 20,000 | 80,000 |
| Net income | $245,000 |
Changes in current assets (other than cash) and current liabilities during the year were:
| Increase | Decrease | |
| Accounts receivable | $15,000 | |
| Merchandise inventory | $25,000 | |
| Prepaid insurance | 8,000 | |
| Accounts payable | 15,000 | |
| Accrued liabilities payable | 4,000 |
Depreciation was the only noncash item affecting net income.
- Prepare a working paper to calculate cash flows from operating activities under the direct method.
- Prepare the cash flows from operating activities section of the statement of cash flows under the direct method.
- Prove that the same cash flows amount is obtained under the indirect method by preparing the cash flows from operating activities section of the statement of cash flows under the indirect method. You need not prepare a working paper.
Alternate problem B The following information relates to Dunwoody Nursery & Garden Center, Inc. The company leases a building adjacent to its land.
Dunwoody Nursery & Garden Center, Inc.
Comparative Balance Sheets
2011 December 31 and 2010
| 2011 | 2010 | |
| Assets | ||
| Cash | $44,500 | $ 52,000 |
| Accounts receivable, net | 59,000 | 60,000 |
| Merchandise inventory | 175,000 | 120,000 |
| Equipment | 412,500 | 315,000 |
| Accumulated depreciation – equipment | (120,000) | (105,000) |
| Land | 75,000 | 15,000 |
| Total assets | $646,000 | $457,000 |
| Liabilities and stockholders’ equity | ||
| Accounts payable | $ 43,750 | $40,750 |
| Accrued liabilities payable | 2,250 | 3,750 |
| Capital stock – common – $10 par | 375,000 | 300,000 |
| Paid-in capital in excess of par | 150,000 | 75,000 |
| Retained earnings | 75,000 | 37,500 |
| Total liabilities and stockholders’ equity | $646,000 | $457,000 |
Net income was $ 97,500 for the year.
Fully depreciated equipment costing $ 15,000 was sold for $ 3,750 (a gain of $ 3,750), and equipment costing $ 112,500 was purchased for cash.
Depreciation expense for the year was $ 30,000.
Land was purchased, $ 60,000.
An additional 7,500 shares of common stock were issued for cash at $ 20 per share (total proceeds, $ 150,000).
Cash dividends of $ 60,000 were declared and paid.
The company paid interest of $ 6,000 and income taxes of $ 65,000. Prepare a statement of cash flows under the indirect method. Also prepare any necessary supplemental schedule(s).
Alternate problem C Drexler, Inc., is an independent service organization that markets and services electronic credit card authorization and payment systems to small retail, wholesale, and professional businesses located throughout the United States. Prior to installing the company’s electronic system, most of these businesses have used manual, paper-based systems to process credit card transactions or have not accepted credit cards at all. As the use of credit cards has significantly expanded, electronic processing has proven more convenient by accelerating customer purchases, lowering processing expenses, and reducing losses from fraudulent cards.
The company’s account portfolio has grown through the purchase of account portfolios as well as through the internal development of accounts using telemarketing and field sales. With approximately 90,000 accounts at 2010 July 31, the company is one of the largest independent service organizations in the country.
The company’s statements of cash flows for the years 2008-2010 follow. Then the relevant portion of Management’s Discussion and Analysis of the statement of cash flows is provided.
| Consolidated statement of cash flows | |||
| Year ended July 31, | |||
| 2008 | 2009 | 2010 | |
| Cash flows from operating activities: | |||
| Net cash received from merchants | $ 19,657,697 | $ 34,353,326 | $ 67,313,124 |
| Cash paid to vendors and employees | (14,758,040) | (28,467,472) | (49,128,150) |
| Interest received | 22,262 | 310,136 | 1,672,714 |
| Interest paid | (268,586) | (198,485) | (505,856) |
| Income taxes paid | (994,969) | (1,600,405) | (5,630,881) |
| Net cash provided by operating activities | $ 3,658,354 | $ 4,397,100 | $ 13,720,951 |
| Cash flows from investing activities: | |||
| Purchase of merchant portfolios | $ (8,415,055) | $(24,576,426) | $(31,787,725) |
| Purchase of property and equipment | (1,465,984) | (1,917,395) | (1,777,955) |
| Net cash used in investing activities | $(9,881,039) | $(26,493,821) | $(33,565,680) |
| Cash flows from financing activities: | |||
| Proceeds from issuance of long-term debt | $ 7,650,000 | $ 16,450,000 | $ 305,000 |
| Payments on long-term debt | (1,163,170) | (12,828,503) | (16,545,500) |
| Proceeds from issuance of common stock | — | 17,098,894 | 140,963,115 |
| Payments to repurchase treasury stock | (45,000) | (32,500) | (12,000) |
| Proceeds from minority shareholder contribution | — | — | 120,000 |
| Net cash provided by financing activities | $6,441,830 | $ 20,687,891 | $124,830,615 |
| Net increase (decrease) in cash and cash equivalents | $ 219,145 | $ (1,408,830) | $(104,985,886) |
| Cash and cash equivalents at beginning of year | 1,664,830 | 1,883,975 | 475,145 |
| Cash and cash equivalents at end of year | $ 1,883,975 | $ 475,145 | $105,461,031 |
Supplemental schedule of noncash activities:
In connection with the purchase of merchant portfolios in fiscal years 2008 and 2009, the Company issued promissory notes totaling $ 5,061,804 and $ 80,500, respectively.
The company recognized a tax benefit of $ 318,517 for the year ended 2010 July 31, for the excess of the fair market value at the exercise date over that at the award date for stock options exercised.
In connection with the purchase of merchant portfolio in March 2008, the Company issued 312,500 shares of common stock.
In connection with an agreement between the Company and a processing back entered into simultaneously with the purchase of a merchant portfolio in March 2008, the Company issued warrants to purchase 120,000 shares of common stock.
| Reconciliation of net income to net cash provided by operating activities: | |||
| Net income | $2,592,444 | $3,640,155 | $ 8,625,376 |
| Martin Howe fiscal year converstion | — | — | (356,914) |
| Adjustments: | |||
| Depreciation and amortization expense | 1,648,023 | 3,517,852 | 7,509,630 |
| Provision for merchant losses | 484,993 | 483,245 | 654,705 |
| Stock award compensation and other | 239,659 | 241,477 | 120,395 |
| Deferred income taxes | (453,658) | 35,982 | (761,705) |
| Changes in assets and liabilities: | |||
| Accounts receivable | (1,562,961) | (1,459,799) | (2,125,510) |
| Inventory | (50,235) | (157,087) | (186,289) |
| Other assets | (1,716,464) | (1,895,097) | (501,353) |
| Accounts payable | 1,557,611 | 44,106 | 587,784 |
| Accrued liabilities | 975,065 | (223,411) | 210,064 |
| Deferred revenues | (56,123) | 169,677 | (55,232) |
| Net cash provided by operating activities | $ 3,658,354 | $ 4,397,100 | $ 13,720,951 |
Management’s discussion and analysis
Capital expenditures and investing activities
Capital expenditures were approximately $ 1.8 million for fiscal year 2010 as compared to $ 1.9 million for fiscal year 2009 and $ 1.5 million for fiscal year 2008. The increase in capital expenditures was primarily the result of additional expenditures related to the Company’s management information system, the purchase of additional credit card terminals, the Company’s relocation of its office facilities and the purchase of peripheral equipment for lease to merchants. In addition to the increase in capital expenditures, the Company used $ 8.4 million, $ 24.6 million and $ 31.8 million for the purchase of merchant portfolios in fiscal years 2008, 2009 and 2010, respectively. The Company purchased five merchant portfolios in fiscal 2008, nine merchant portfolios in fiscal year 2009 and five in fiscal year 2010.
Financing activities
The significant increase in cash provided by financing activities for fiscal year 2009 resulted from the consummation of the Company’s initial public offering in August 2008. Cash provided by financing activities for fiscal year 2009 was $ 20.7 million which reflects the net proceeds of the initial public offering after retirement of the Company’s outstanding indebtedness. Additionally, the Company issued $ 15.3 million of long-term debt in connection with three of the nine merchant portfolios purchased in fiscal year 2009.
The cash provided by financing activities for fiscal 2010 reflects the Company’s consummation of its second and third public offerings in October 2009 and April 2010, respectively. Net cash provided by financing activities was $ 124.8 million in fiscal 2010 which reflects the net proceeds from the offerings after retirement of the Company’s outstanding bank indebtedness.
Future capital needs
Management believes that significant expenditures for the purchase of additional merchant portfolios may be required for the Company to sustain its growth in the future. Management expects to fund such purchases primarily through cash generated from operations and additional bank borrowings. Management believes the combination of these sources will be sufficient to meet the Company’s anticipated liquidity needs and its growth plans through fiscal year 2008. The Company, however, may pursue additional expansion opportunities, including purchases of additional merchant portfolios, which may require additional capital, and the Company may incur, from time to time, additional short-term and long-term indebtedness or issue, in public or private transactions, equity or debt securities, the availability and terms of which will depend upon then prevailing market and other conditions.
The Company’s revolving credit facility was amended and restated during fiscal year 2009 to increase the line of credit to $ 17.5 million. The Company repaid all outstanding debt related to this credit facility with the proceeds from its second public offering during fiscal year 2010. The amended agreement expires 2010 November 1, with all amounts then outstanding under the agreement due on 2010 November 1, unless the agreement is extended or the outstanding amounts have been converted to a term loan requiring equal monthly payments for 48 months.
Borrowings under the amended revolving credit facility are used to finance purchases of merchant portfolios and equipment and for working capital purposes. Borrowings are secured by substantially all the Company’s assets and life insurance policies on the lives of two of the Company’s executive officers.
- Which method is the company using to determine net cash provided by operating activities?
- Why does the company show the indirect method below the statement of cash flows?
- What is the trend of net cash provided by operating activities over the three years?
- How has the company increased its merchant portfolios?
- What items of property and equipment were acquired during the three-year period?
- What was the major source of the huge increase in cash and cash equivalents over the three-year period? How were the proceeds used?
- How does the company expect to finance future expenditures to acquire additional merchant portfolios?
- How are amounts secured that are borrowed under the line of credit?
- Given the following data, calculate the cash flow per share of common stock ratio, the cash flow margin ratio, and the cash flow liquidity ratio. (Round the net cash provided from operating activities to the nearest thousand before you calculate the ratios.) How do the ratios compare with the ones for companies illustrated in the chapter?
| (in thousands) | |
| Average number of shares of common stock outstanding | 28,539 |
| Net sales | $149,840 |
| Cash and marketable securities | 105,461 |
| Current liabilities | 6,862 |
Alternate problem D Founded in 1901, The Gillette Company is the world leader in male grooming products, a category that includes blades and razors, shaving preparations and electric shavers. Gillette also holds the number one position worldwide in selected female grooming products, such as wet shaving products and hair epilation devices. The Company is the world’s top seller of writing instruments and correction products, toothbrushes and oral care appliances. In addition, the Company is the world leader in alkaline batteries.
Gillette manufacturing operations are conducted at 38 facilities in 19 countries, and products are distributed through wholesalers, retailers, and agents in over 200 countries and territories.
The company’s statements of cash flows for the years 2001-2003 follow. Then the relevant portion of Management’s Discussion and Analysis of the statement of cash flows is provided.
Consolidated statement of cash flows (millions of dollars)
| Years ended 2003,2002, 2001 December 31 | 2003 | 2002 | 2001 |
| Operating activities | |||
| Income from continuing operations | $ 832 | $1,248 | $1,073 |
| Adjustments to reconcile net income to net cash provided by operating activities: | |||
| Provision of restructuring and asset impairment | 572 | — | 440 |
| Depreciation and amortization | 535 | 464 | 421 |
| Other | 5 | (7) | (46) |
| Changes in assets and liabilities, excluding effects from acquisition and divestitures: | |||
| Accounts receivable | (100) | (48) | (442) |
| Inventories | 149 | (140) | (62) |
| Accounts payable and accrued liabilities | (45) | 65 | 72 |
| Other working capital items | (136) | 97 | (104) |
| Other noncurrent assets and liabilities | (197) | (252) | (142) |
| Funding German pension plans | — | — | (252) |
| Net cash provided by operating activities | $ 1,604 | $1,427 | $ 958 |
| Investing activities | |||
| Additions to property, plant and equipment | $ (793) | $ (889) | $ (952) |
| Disposals of property, plant and equipment | 41 | 124 | 65 |
| Acquisitions of businesses, less cash acquired | — | — | (91) |
| Sale of businesses | 539 | — | 200 |
| Other | (1) | 2 | 5 |
| Net cash used in investing act | $(214) | $ (763) | $ (773) |
| Financing activities | |||
| Purchase of treasury stock | $ (944) | $(2,021) | $(1,066) |
| Proceeds from sale of put options | 23 | 72 | 56 |
| Proceeds from exercise of stock options and purchase plans | 36 | 149 | 126 |
| Proceeds from long-term debt | 494 | 1,105 | 500 |
| Repayment of long-term debt | (365) | — | (12) |
| Increase (decrease) in loans payable | (385) | 484 | 708 |
| Dividends paid | (671) | (626) | (552) |
| Settlements of debt-related derivative contracts | 279 | 42 | 9 |
| Net cash used in financing activities | $ (1,553) | $ (795) | $ (231) |
| Effect of exchange rate changes on cash | $ (5) | $ (2) | $ (2) |
| Net cash provided by discontinued operations | 130 | 111 | 45 |
| Decrease in cash and cash equivalents | $ (18) | $ (22) | $ (3) |
| Cash and cash equivalents at beginning of year | 80 | 102 | 105 |
| Cash and cash equivalents at end of year | $ 62 | $ 80 | $ 102 |
| Supplemental disclosure of cash paid for: | |||
| Interest | $ 243 | $ 126 | $ 120 |
| Income taxes | $ 480 | $ 457 | $ 473 |
| Noncash investing and financing activities: | |||
| Acquisition of businesses | |||
| Fair value of assets acquired | $— | $— | $ 100 |
| Cash paid | — | — | 91 |
| Liabilities assumed | $ — | $ —- | $ 9 |
Management’s discussion and analysis*
Financial condition
The Company’s financial condition continued to be strong in 2003. Net debt (total debt net of associated swaps, less cash and cash equivalents) decreased $ 82 million during 2003, despite additional spending under the Company’s share repurchase program, due to improved cash flow from operations, proceeds from the sale of the Stationery Products business and the favorable exchange impact on foreign currency debt. Net debt at 2003 December 31, amounted to $ 4.45 billion, compared with $ 4.53 billion and $ 3.18 billion at 2002 December 31 and 2001, respectively. The market value of Gillette equity was $ 38 billion at the end of 2003, compared with $ 43 billion at the end of 2002. The Company’s book equity position amounted to $ 1.92 billion at the end of 2003, compared with $ 3.06 billion at the end of 2002 and $ 4.54 billion at the end of 2001. The decreases in book equity in 2003 and 2002 were due primarily to the Gillette share repurchase program, as well as to the effect of foreign currency translation.
Net cash provided by operating activities in 2003 was $ 1.60 billion, compared with $ 1.43 billion in 2002 and USD .96 billion in 2001. The current ratio of the Company was .86 for 2003, compared with ratios of 1.39 for 2002 and 1.40 for 2001. The decrease in the 2003 current ratio was primarily attributable to the Company’s reclassification of all commercial paper borrowings to short-term debt, due to the Company’s credit facility agreements expiring within 2001. Capital spending in 2003 amounted to $ 793 million, compared with $ 889 million in 2002 and $ 952 million in 2001. Spending in all three years reflected substantial investments in the blade and razor, Duracell and Braun Products segments.
In 2003, the Company sold the Stationery Products business for $ 528 million. In 2001, the Company made acquisitions in the Duracell Products segment for $ 100 million and sold the Jafra business for $ 200 million.
Share repurchase funding in 2003, net of proceeds received from the sale of put options on Company stock, amounted to $ 921 million, compared with $ 1,949 million in 2002 and $ 1,010 million in 2001.
Strong cash inflows from operations, proceeds from the sale of the Stationery Products business and alternate financing sources enabled the Company to reduce its $ 2.0 billion revolving credit facility in 2003 to $ 1.4 billion, expiring October 2004, and its $ 1.1 billion credit facility, expiring December 2004, to $ 550 million in January 2004. Both facilities are used by the Company to complement its commercial paper program.
In order to increase flexibility in sourcing short-term borrowing, the Company launched a $ 1 billion Euro commercial paper program in 2003. At year-end 2003, there was $ 586 million outstanding under this program and $ 1.45 billion outstanding under the US program, compared with $ 2.41 billion at the end of 2002 and $ 1.66 billion at the end of 2001.
During 2003, the Company issued Euro-denominated notes for $ 228 million, due December 2005, and entered into a $ 264 million Euro-denominated debt obligation, with redemption rights in December 2004. During 2002, the Company issued Euro-denominated notes for $ 343 million, due February 2007, and entered into a $ 325 million Euro-denominated debt obligation, with redemption rights in March 2005, and a $ 437 million Euro-denominated debt obligation, with redemption rights in January 2007. The net proceeds were used to refinance existing short-term debt associated with the Company’s share repurchase program.
During 2003, both Standard & Poor’s and Moody’s maintained the Company’s current credit ratings. Standard & Poor’s rates the Company’s long-term debt at AA, while Moody’s rating is Aa3. The commercial paper rating is A1+ by Standard & Poor’s and P1 by Moody’s.
Gillette will continue to have capital available for growth through both internally generated funds and significant credit resources. The Company has substantial unused lines of credit and access to worldwide financial market sources for funds.
Source: The Gillette Company’s 2000 annual report, p. 22.
- Does the company use the direct or indirect method of calculating net cash provided by operating activities?
- Determine whether each of the current assets (other than cash) and current liabilities increased or decreased during 2003.
- How is the company expanding its asset base?
- How much greater is the total market value of the company’s outstanding shares of common stock than the book equity (stockholders; equity)?
- What is the likelihood that the company will be able to pay at least the current level of dividends in the future?
- Do you expect to see purchases of treasury stock increase or decrease in the future?
- Given the following data, calculate the cash flow per share of common stock ratio, the cash flow margin ratio, and the cash flow liquidity ratio. (Round the net cash provided by operating activities to the nearest million before you calculate the ratios.) How do the ratios compare with the ones for companies illustrated in the chapter?
| (in millions) | |
| Average number of shares of common stock outstanding | 1,059 |
| Net sales | 9,295 |
| Cash and marketable securities | 62 |
| Current liabilities | 5,471 |
Alternate problem E The following information is from the accounting records of Wescott Office Supplies, Inc., for the fiscal years 2011 and 2010:
| 2011 | 2010 | |
| Assets | ||
| Cash | $ 66,250 | $ 61,000 |
| Accounts receivable, net | 84,000 | 42,000 |
| Merchandise inventory | 42,000 | 48,250 |
| Prepaid expenses | 7,875 | 12,125 |
| Land | 94,500 | 78,750 |
| Buildings | 199,500 | 147,000 |
| Accumulated depreciation – buildings | (31,500) | (26,250) |
| Equipment | 257,250 | 210,000 |
| Accumulated depreciation- equipment | (78,750) | (63,000) |
| Total assets | $641,125 | $509,875 |
| Liabilities and stockholders’ equity | ||
| Accounts payable | $73,500 | $ 47,250 |
| Accrued liabilities payable | 50,500 | 55,750 |
| Five-year note payable | 52,500 | -0- |
| Capital stock -$50 par | 420,000 | 367,500 |
| Retained earnings | 39,375 | |
| Total liabilities and stockholders’ equity | $641,125 | $509,875 |
Net income for year ended 2011 June 30, was $ 56,250.
Additional land was acquired for cash, $ 15,750.
No equipment or building retirements occurred during the year.
Equipment was purchased for cash, $ 47,250.
The five-year note for $ 52,500 was issued to pay for a building erected on land leased by the company.
Stock was issued at par for cash, $ 52,500.
Dividends declared and paid were $ 51,000.
The company paid interest of $ 10,000 and income taxes of $ 40,000.
- Prepare a working paper for a statement of cash flows.
- Prepare a statement of cash flows under the indirect method. Also prepare any necessary supplemental schedule(s).
Beyond the numbers—Critical thinking
Business decision A National Sports, Inc., is a sports equipment sales company. During 2011, the company replaced $ 18,000 of its fully depreciated equipment with new equipment costing $ 23,000. Although a midyear dividend of $ 5,000 was paid, the company found it necessary to borrow $ 5,000 from its bank on a two-year note. Further borrowing may be needed since the Cash account is dangerously low at year-end.
Following are the income statement and “cash flow statement”, as the company’s accountant calls it, for 2011.
National sports, Inc.
Income Statements
For the year ended 2011 December 31
| Sales | $195,000 | |
| Cost of goods sold | $140,000 | |
| Operating expense and taxes | 49,700 | 189,700 |
| Net income | $5,300 |
National Sports, Inc.
Cash flow Statement
For the Year ended 2011 December 31
| Cash received: | ||
| From operations: | ||
| Net income | $5,300 | |
| Depreciation | 5,000 | |
| Total cash from operations | $10,300 | |
| Note issued to back | 5,000 | |
| Mortgage note issued | 16,000 | |
| Total funds provided | $31,300 | |
| Cash paid: | ||
| New equipment | $23,000 | |
| Dividends | 5,000 | 28,000 |
| Increase in cash | $ 3,300 |
The company’s president is very concerned about what he sees in these statements and how it relates to what he knows has actually happened. He turns to you for help. Specifically, he wants to know why the cash flow statement shows an increase in cash of $ 3,300 when he knows the cash balance decreased from $ 15,000 to $ 500 during the year. Also, why is depreciation shown as providing cash?
You believe you can answer the president’s questions after receiving the following condensed balance sheet data:
National Sports, Inc.
Comparative Balance Sheets
2011 December 31, and 2010
| December 31 | ||
| 2011 | 2010 | |
| Assets | ||
| Current assets: | ||
| Cash | $ 500 | $ 15,000 |
| Accounts receivable, net | 17,800 | 13,200 |
| Merchandise inventory | 28,500 | 17,500 |
| Prepaid expenses | 700 | 300 |
| Total current assets | $ 47,500 | $ 46,000 |
| Property, plant, and equipment: | ||
| Equipment | $40,000 | $35,000 |
| Accumulated depreciation – equipment | (11,000) | (24,000) |
| Total property, plant, and equipment | $ 29,000 | $ 11,000 |
| Liabilities and stockholders’ equity | ||
| Current liabilities: | ||
| Accounts payable | $ 8,700 | $ 10,000 |
| Accrued liabilities payable | 600 | 1,100 |
| Total current liabilities | $ 9,300 | $ 11,100 |
| Long-term liabilities: | ||
| Notes payable | 5,000 | -0- |
| Mortgage note payable | 16,000 | -0- |
| Total liabilities | $ 30,300 | $ 11,100 |
| Stockholders’ equity: | ||
| Common stock | $ 40,000 | $ 40,000 |
| Retained earnings | 6,200 | 5,900 |
| Total stockholders’ equity | $ 46,200 | $ 45,900 |
| Total liabilities and stockholders’ equity | $ 76,500 | $ 57,000 |
Prepare a correct statement of cash flows using the indirect method that shows why National Sports, Inc., is having such a difficult time keeping sufficient cash on hand. Also, answer the president’s questions. The company paid interest of $ 400 and income taxes of $ 3,000.
Business decision case B Following are comparative balance sheets for Hardiplank Siding, Inc.:
Hardiplank Siding, Inc.
Comparative Balance Sheets
2011 December 31, and 2010
| 2011 | 2010 | |
| Assets | ||
| Cash | $ 80,000 | $ 57,500 |
| Accounts receivable, net | 60,000 | 45,000 |
| Merchandise inventory | 90,000 | 52,500 |
| Land | 67,500 | 60,000 |
| Buildings | 90,000 | 90,000 |
| Accumulated depreciation- buildings | (30,000) | (27,000) |
| Equipment | 285,000 | 225,000 |
| Accumulated depreciation – equipment | (52,500) | (48,000) |
| Goodwill | 120,000 | 150,000 |
| Total assets | $710,000 | $605,000 |
| Liabilities and stockholders’ equity | ||
| Accounts payable | $ 95,000 | $ 65,000 |
| Accrued liabilities payable | 30,000 | 22,500 |
| Capital stock | 315,000 | 300,000 |
| Paid-in capital – stock dividends | 75,000 | 67,500 |
| Paid-in capital – land donations | 15,000 | -0- |
| Retained earnings | 180,000 | 150,000 |
| Total liabilities and stockholders’ equity | $710,000 | $605,000 |
An analysis of the Retained Earnings account for the year reveals the following:
| Balance, 2011 January 1 | $150,000 | |
| Add: Net income for the year | 107,500 | |
| $257,500 | ||
| Less: cash dividends | $55,000 | |
| Stock dividends | 22,500 | 77,500 |
| Balance, 2011 December 31 | $180,000 |
- Equipment with a cost of $ 30,000 on which $ 27,000 of depreciation had been accumulated was sold during the year at a loss of $ 1,500. Included in net income is a gain on the sale of land of $ 9,000.
- The president of the company has set two goals for 2012: (1) increase cash by $ 40,000 and (2) increase cash dividends by $ 35,000. The company’s activities in 2012 are expected to be quite similar to those of 2011, and no new fixed assets will be acquired.
Prepare a schedule showing cash flows from operating activities under the indirect method for 2011. Can the company meet its president’s goals for 2012? Explain.
Annual report analysis C Refer to the Annual report appendix. Evaluate the ease with which The Limited will be able to maintain its dividend payments in the future at 2006 amounts. (Hint: Compare current dividend amount with net cash provided by operating activities.)
Annual report analysis D Refer to “A broader perspective: Johnson & Johnson” and answer the following questions:
- Over the last three years from which major activities (operations, investing, financing) has Johnson & Johnson received net cash inflows and on which major activities have they spent the funds?
- What relationship do you see between “Depreciation and amortization of property and intangibles” and “Additions of property, plant, and equipment”?
- What were the two major sources of cash outflows to stockholders and which was larger?
- By how much did the investments in marketable securities grow or shrink over the three-year period?
- By how much did long-term debt grow or shrink over the three-year period?
- If you were a stockholder, would you feel uncertain or confident that this company will be able to pay future dividends at the same rate as in the past?
- For what reason or reasons might the company be buying back its own stock?
- For the latest year, did the current assets (other than cash) and current liabilities go up or down?
- From the information that is available, does it appear that the company is performing well or poorly?
Group project E In groups of two or three students write a two-page, double-spaced paper on one of the following topics:
Which Is Better, the Direct or Indirect Method (of calculating net cash provided by operating activities)?
Analysis of the Johnson & Johnson Cash Flow Statement (shown in “A broader perspective” in this chapter)
Analysis of Cash Flow Statement for The Limited (shown in the Annual Report Appendix)
Your analysis should be convincing and have no spelling or grammatical errors. Your paper should be neat and the result of several drafts. The paper should have a cover page with the title and the authors’ names. Use a word processing program if possible.
Group project F In a group of one or two other students, go to the library and locate Statement of Financial Accounting Standards No. 95, “Statement of Cash Flows”, published by the Financial Accounting Standards Board. Write a report to your instructor answering the following questions:
Why did the Board settle on cash flows instead of working capital flows?
Why did the Board strongly recommend use of the direct method?
Why did some members of the Board dissent from the final statement?
Group project G In a group of one or two other students, go to the library and locate Statement of Financial Accounting Standards No. 95, “Statement of Cash Flows”, published by the Financial Accounting Standards Board. Write a report to your instructor covering the following points:
Describe the controversy over how to treat interest and dividends received.
What is the Board’s position on reporting cash flow per share? Why did they take that position?
What is the Board’s position on noncash transactions? Why did they take that position?
Using the Internet—A view of the real world
Visit the following website for the Eastman Kodak Company:
By following the instructions on the screen, locate the latest statement of cash flows and then print it. Analyze the statement and write a report to your instructor summarizing your analysis.
Visit the following website for Verizon:
By following the information on the screen, locate the latest statement of cash flows and then print it. Analyze the statement and then write a report to your instructor summarizing your analysis.
- [1]FASB, Statement of Financial Accounting Standards No. 95, “Statement of Cash Flows” (Stamford, Conn., 1987). Copyright by the Financial Accounting Standards Board, High Ridge Park, Stamford, Connecticut 06905. U.S.A. Quoted (or excerpted) with permission. Copies of the complete document are available from the FASB.
- Accounting Principles: A Business Perspective. Authored by: James Don Edwards, University of Georgia & Roger H. Hermanson, Georgia State University. Provided by: Endeavour International Corporation. Project: The Global Text Project . License: CC BY: Attribution