Blueprint Problem: Statement of Cash Flows

Blueprint Problem: Statement of Cash Flows

Statement of Cash Flows and Business Activities

The statement of cash flows provides information about the cash inflows and cash outflows for a company. It is considered to be a complement to the other three financial statements. A company’s cash flows are generated from operating, investing, and financing activities. (Click on the activity name in the image for definitions.)

In the table below, review the transaction and select the appropriate type of activity and cash flow.

TransactionActivity and flow
Paying commissions to sales forceSelectFinancing, inflowInvesting, inflowOperating, inflowFinancing, outflowInvesting, outflowOperating, outflowCorrect 1 of Item 1
Selling goods to customersSelectFinancing, inflowInvesting, inflowOperating, inflowFinancing, outflowInvesting, outflowOperating, outflowCorrect 2 of Item 1
Buying equipment for use in manufacturingSelectFinancing, inflowInvesting, inflowOperating, inflowFinancing, outflowInvesting, outflowOperating, outflowCorrect 3 of Item 1
Selling common stock to an investorSelectFinancing, inflowInvesting, inflowOperating, inflowFinancing, outflowInvesting, outflowOperating, outflowCorrect 4 of Item 1
Borrowing cash from a bankSelectFinancing, inflowInvesting, inflowOperating, inflowFinancing, outflowInvesting, outflowOperating, outflowCorrect 5 of Item 1
Selling equipment used in the company’s manufacturingSelectFinancing, inflowInvesting, inflowOperating, inflowFinancing, outflowInvesting, outflowOperating, outflowCorrect 6 of Item 1
Purchasing goods to sell to customersSelectFinancing, inflowInvesting, inflowOperating, inflowFinancing, outflowInvesting, outflowOperating, outflowCorrect 7 of Item 1
Buying land for a future plant siteSelectFinancing, inflowInvesting, inflowOperating, inflowFinancing, outflowInvesting, outflowOperating, outflowCorrect 8 of Item 1
Paying back the principal of a loanSelectFinancing, inflowInvesting, inflowOperating, inflowFinancing, outflowInvesting, outflowOperating, outflowCorrect 9 of Item 1
Paying utility billsSelectFinancing, inflowInvesting, inflowOperating, inflowFinancing, outflowInvesting, outflowOperating, outflowCorrect 10 of Item 1
Paying dividends to ownersSelectFinancing, inflowInvesting, inflowOperating, inflowFinancing, outflowInvesting, outflowOperating, outflowCorrect 11 of Item 1
Buying a display case for items to be soldSelectFinancing, inflowInvesting, inflowOperating, inflowFinancing, outflowInvesting, outflowOperating, outflowCorrect 12 of Item 1

Hide FeedbackShow All Feedback

Check My Work Feedback

Post Submission Feedback

Solution

Operating Activities and the Indirect Method

The first section of the statement of cash flows is the operating activities section. There are two methods to prepare this section: the direct method and the indirect method. Both methods calculate the same result. Under the indirect method, net income is adjusted to determine cash flows from operating activities.

Why is net income not equal to the increase in cash? Recall that under GAAP, net income is calculated on Selectan accruala cashCorrect 1 of Item 2 basis.

There are four types of adjustments to net income:

1.Non-cash effects on net income:Non-cash expenses are Selectadded tosubtracted fromCorrect 2 of Item 2 net income and
non-cash revenues are Selectadded tosubtracted fromCorrect 3 of Item 2 net income.
2.Gains and losses from investing or financing activities:Gains are Selectadded tosubtracted fromCorrect 4 of Item 2 net income and
losses are Selectadded tosubtracted fromCorrect 5 of Item 2 net income.
3.Changes in current assets:Increases in current assets are Selectadded tosubtracted fromCorrect 6 of Item 2 net income and
decreases in current assets are Selectadded tosubtracted fromCorrect 7 of Item 2 net income.
4.Changes in current liabilitiesIncreases in current liabilities are Selectadded tosubtracted fromCorrect 8 of Item 2 net income and
decreases in current liabilities are Selectadded tosubtracted fromCorrect 9 of Item 2 net income.

Hide FeedbackShow All Feedback

Check My Work Feedback

Post Submission Feedback

Solution

HideAPPLY THE CONCEPTS: Prepare the operating activities sectionThe income statement and comparative balance sheets for Leonardo Inc. can be viewed by clicking on the links below. No depreciable assets were purchased or sold during the period; therefore, the increase in Accumulated Depreciation is due to depreciation expense for the period. Complete the operating activities section of the statement of cash flows. Use a minus sign (-) to indicate an outflow of cash. No sign is needed to indicate an inflow of cash.+ Income StatementLeonardo Inc.Income StatementFor the Year Ended December 31, 2013Sales$244,800Cost of merchandise sold127,296Gross profit$117,504Operating expenses:Depreciation expense$2,560Other operating expenses80,672Total operating expenses83,232Income from operations$34,272Other revenue and expenses:Interest revenue$480Gain on sale of land2,2402,720Income before taxes$36,992Income taxes9,792Net income$27,200+ Comparative Balance SheetLeonardo Inc.Balance SheetsDecember 31, 201320132012AssetsCash$28,800$20,800Accounts receivable (net)7,20010,400Inventories76,32072,800Current assets$112,320$104,000Note Receivable135,52059,200Land47,04088,800Equipment192,400192,400Less: Accumulated depreciation46,96044,400Total assets$440,320$400,000LiabilitiesAccounts payable$4,480$8,800Wages payable20,64017,600Current liabilities$25,120$26,400Note payable61,60061,600Total liabilities$86,720$88,000Stockholders’ EquityCommon stock$68,800$62,400Additional paid-in capital153,200140,400Retained earnings131,600109,200Total equity$353,600$312,000Total liabilities and equity$440,320$400,000Leonardo Inc.Statement of Cash FlowsFor the Year Ended December 31, 2013Cash flows from operating activities:Accounts ReceivableGross profitSalesNet incomeCorrect 5 of Item 3$Correct 6 of Item 3Adjustments to net income:Common StockDepreciation expenseInterest RevenueOther Operating ExpensesCorrect 8 of Item 3Correct 9 of Item 3Additional paid-in capitalCommon StockGain on sale of landLandCorrect 10 of Item 3Correct 11 of Item 3Increase in Interest RevenueIncrease in Accounts ReceivableDecrease in InventoryDecrease in Accounts ReceivableCorrect 12 of Item 3Correct 13 of Item 3Increase in Retained EarningsIncrease in Accounts ReceivableDecrease in InventoryIncrease in InventoryCorrect 14 of Item 3Correct 15 of Item 3Increase in Income TaxesIncrease in Accounts PayableDecrease in Wages PayableIncrease in Wages PayableCorrect 16 of Item 3Correct 17 of Item 3Increase in Common StockIncrease in Accounts PayableDecrease in Wages PayableDecrease in Accounts PayableCorrect 18 of Item 3Correct 19 of Item 3Net cash provided by operating activitiesNet cash used by operating activitiesCorrect 20 of Item 3$Correct 21 of Item 3

Hide FeedbackShow All Feedback

Check My Work Feedback

Post Submission Feedback

Solution

HideAPPLY THE CONCEPTS: Prepare the investing activities sectionInvesting ActivitiesInvesting activities include inflows and outflows of cash related to noncurrent assets. Additional data related to noncurrent assets and liabilities may need to be collected to correctly calculate the cash flows from investing activities. Inflows of cash from investing activities may include a gain or loss in the sale of a noncurrent asset.Additional information for investing activities:
1. One of Leonardo’s suppliers experienced a devastating loss due to a tornado. Leonardo loaned the company $76,320 cash to help restore its operations. The loan is interest-free.
2. Leonardo sold one of its parcels of land for $44,000.Use a minus sign (A????1) to indicate an outflow of cash. No sign is needed to indicate an inflow of cash.Cash flows from investing activities:Cash received from principal of loanCash received from sale of landCash received from accounts receivableCash received from common stockCorrect 5 of Item 4$Correct 6 of Item 4Cash loaned to supplierCash paid for cost of merchandise soldCash paid for operating expensesCash paid for common stockCorrect 7 of Item 4Correct 8 of Item 4Net cash provided by investing activitiesNet cash used by investing activitiesCorrect 9 of Item 4Correct 10 of Item 4

Hide FeedbackShow All Feedback

Check My Work Feedback

Post Submission Feedback

Solution

HideFinancing ActivitiesFinancing activities include inflows and outflows of cash from transactions that either generate capital or repay capital provided to the company. As with investing activities, you must review the changes to equity accounts and noncurrent liabilities as well as collect any additional data related to equity accounts and noncurrent liabilities to correctly calculate the cash flows from financing activities.APPLY THE CONCEPTS: Prepare the financing activities sectionAdditional financing activities data:1. On February 1, 2013, Leonardo Inc. issued 6,400 shares of its $1 par value stock. The company received the par value for the shares and $12,800 in excess of par value.
2. Leonardo paid dividends of $4,800 to its stockholders on June 30, 2013.Use a minus sign (A????1) to indicate an outflow of cash. No sign is needed to indicate an inflow of cash.Cash flows from financing activities:Cash received from salesCash received from interest revenueCash received from issuance of stockCash paid for issuance of stockCorrect 5 of Item 5$Correct 6 of Item 5Cash paid for merchandise soldCash paid for dividendsCash paid for operating expensesCash paid for income taxesCorrect 7 of Item 5Correct 8 of Item 5Net cash provided by financing activitiesNet cash used by financing activitiesCorrect 9 of Item 5Correct 10 of Item 5

Hide FeedbackShow All Feedback

Check My Work Feedback

Post Submission Feedback

Solution

HideComplete the Statement of Cash FlowsAfter determining the cash flows from the operating, investing, and financing activities, the net change in cash can be calculated by totaling the cash flows from each of the activities. The net change in Cash is added to the Cash balance at the beginning of the period. The sum should be equal to the balance in Cash at the end of the year.APPLY THE CONCEPTS: Complete the statement of cash flowsUse a minus sign (A????1) to indicate an outflow of cash. No sign is needed to indicate an inflow of cash.Net decrease in cashNet increase in cashCorrect 4 of Item 6$Correct 5 of Item 6Cash, beginning of the yearCash, end of the yearCorrect 6 of Item 6Correct 7 of Item 6Cash, beginning of the yearCash, end of the yearCorrect 8 of Item 6$Correct 9 of Item 6

Hide FeedbackShow All Feedback

Check My Work Feedback

Post Submission Feedback

Solution

Additional Disclosures

Often a company will engage in significant investing or financing transactions that involve no cash flow. For example, a company may sign a long-term note payable in exchange for an asset, such as a building or equipment. Or, perhaps common stock is issued to retire bonds. These activities are not reported on the statement of cash flows because there is no cash flow in the current period.

These transactions should be Selectdisclosed in a separate schedule.ignored because there is no current cash flow.removed from the balance sheet to prevent confusion.Correct 1 of Item 7 Reporting significant noncash investing and financing activities follows the Selectfull-disclosurematchinghistorical costCorrect 2 of Item 7 principle.

Suppose the same facts as above, except that Kimberly-Clark incurred legal fees resulting from the execution of the lease of $5,000, and received a lease incentive from Sheffield to enter the lease of $1,000. How would the initial measurement of the lease liability and right-of-use asset be affected under this situation?

Exercise 21A-4 a-dAssume that on December 31, 2016, Kimberly-Clark Corp. signs a 10-year, non-cancelable lease agreement to lease a storage building from Sheffield Storage Company. The following information pertains to this lease agreement.
1.The agreement requires equal rental payments of $66,599 beginning on December 31, 2016.2.The fair value of the building on December 31, 2016 is $487,267.3.The building has an estimated economic life of 12 years, a guaranteed residual value of $10,000, and an expected residual value of $7,500. Kimberly-Clark depreciates similar buildings on the straight-line method.4.The lease is nonrenewable. At the termination of the lease, the building reverts to the lessor.5.Kimberly-Clark’s incremental borrowing rate is 8% per year. The lessor’s implicit rate is not known by Kimberly-Clark.
Click here to view the factor table. (For calculation purposes, use 5 decimal places as displayed in the factor table provided.)
Prepare the journal entries on the lessee’s books to reflect the signing of the lease agreement and to record the payments and expenses related to this lease for the years 2016, 2017, and 2018. Kimberly-Clark’s fiscal year-end is December 31. (Credit account titles are automatically indented when amount is entered. Do not indent manually. Round answers to 0 decimal places e.g. 5,275.)
DateAccount Titles and ExplanationDebitCredit12/31/16(To record the lease)(To record first lease payment)12/31/17(To record amortization of the right-of-use asset)(To record interest expense)12/31/18(To record amortization of the right-of-use asset)(To record interest expense)
Suppose the same facts as above, except that Kimberly-Clark incurred legal fees resulting from the execution of the lease of $5,000, and received a lease incentive from Sheffield to enter the lease of $1,000. How would the initial measurement of the lease liability and right-of-use asset be affected under this situation?
Right-of-use asset$
Suppose that in addition to the $66,599 annual rental payments, Kimberly-Clark is also required to pay $5,000 for insurance costs each year on the building directly to the lessor, Sheffield Storage. How would this executory cost affect the initial measurement of the lease liability and right-of-use asset?(Round answer to 0 decimal places, e.g. 5,275.)
Lease liability$
Now suppose that, at the end of the lease term, Kimberly-Clark took good care of the asset and Sheffield agrees that the fair value of the asset is actually $10,000. Record the entry for Kimberly-Clark at the end of the lease to return control of the storage building to Sheffield (assuming the accrual of interest on the lease liability has already been made). (Credit account titles are automatically indented when the amount is entered. Do not indent manually.)
Account Titles and ExplanationDebitCreditClick if you would like to Show Work for this question:Open Show Work

Does a rights offering cause share prices to decrease? How are existing shareholders affected by a rights offering?

The Rights Offerings Puzzle

In the United States, firms use general cash offers much more often than rights offerings. IN Table 16.10, of the 578 total issues represented, about 94 (or 16 percent) were rights offers. This reliance on general cash offers in the United States is something of a mystery because rights offerings are usually much cheaper in terms of flotation costs.

Cash Offers
CompensationOtherTotal Cost as
as aExpenses asa Percentage
Size of Issue ($ in millions)Percentage of Proceedsa Percentage of Proceedsof Proceeds
Number
Under 0.500
.50– 0.9966.96%6.78%13.74%
1.00– 1.991810.404.8915.29
2.00– 4.99616.592.879.47
5.00– 9.99665.501.537.03
10.00– 19.99914.84.715.55
20.00– 49.991564.30.374.67
50.00– 99.99703.97.214.18
100.00–500.00163.81.143.95
Total/average4845.02%1.15%6.17%
Rights with Standby UnderwritingPure Rights
Compensationas aPercentageof ProceedsOtherPercentageof Proceeds
Total Cost asTotal Cost as
a Percentagea Percentage
Numberof ProceedsNumberof Proceeds
038.99%
23.43%4.80%8.24%24.59
56.364.1510.51%54.90
95.202.858.0672.85
43.922.186.1061.39
104.141.215.353.72
123.84.904.741.52
93.96.744.702.21
53.50.504.009.13
564.32%1.73%6.05%382.45%

To give an idea of the relative flotation costs, Table 16.10 shows these costs from one study expressed as a percentage of the amount raised for different issue sizes and selling procedures. Overall, general cash offers had average flotation costs equal to 6.17 percent of the amount raised. For rights offerings with standby underwriting, total costs were 6.05 percent. For pure rights offerings (those involving no underwriter), these costs were only 2.45 percent of the amount raised, representing a significant savings. Overall, Table 16.10 suggests that pure rights offerings have a pronounced cost advantage. Furthermore, rights offerings protect the proportionate interest of existing shareholders. No one knows why rights offerings are not used more often, and it is an intriguing anomaly. Various arguments in favor of general cash offers with underwriting have been put forth:

1. Underwriters increase the stock price. This is supposedly accomplished because of the selling effort of the underwriting group.

2. Underwriters provide insurance against a failed offering. This is true. If the market price goes below the offer price, the firm does not lose, because the underwriter has bought the shares at an agreed-upon price. However, this insurance cannot be worth much, because the offer price is not set (in most cases) until within 24 hours of the offering, when the final arrangements are made and underwriters have made a careful assessment of the market for the shares.

3. Other arguments include the following: (a) the proceeds of underwritten issues are available sooner than those of a rights offer, (b) underwriters provide a wider distribution of ownership than would be possible with a rights offering, and (c) consulting advice from investment bankers may be beneficial. All of the preceding arguments are pieces of the puzzle, but none seems very convincing. One study found that firms making underwritten rights offers suffered substantially larger price drops than did firms making underwritten cash offers.9 This is a hidden cost, and it may be part of the reason that underwritten rights offers are uncommon in the United States.

C O N C E P T Q U E S T I O N S

a How does a rights offering work?

b What are the questions that financial management must answer in a rights offering?

c How is the value of a right determined?

d When does a rights offering affect the value of a company’s shares?

e Does a rights offering cause share prices to decrease? How are existing shareholders affected by a rights offering?

Business Analysis and Valuation: Using Financial Statements, Text and Cases

Text book [Palepu, K., Healy, P., (2013) Business Analysis and Valuation: Using Financial Statements, Text and Cases (5th ed) ]

Use the sample templates in Tables 4-1, 4-2, and 4-3 as a reference to recast the financial statements for Amazon.com below. Step 1 is to classify the lines appropriately, then step 2 is to aggregate like items to produce the standardized

Helpful Notes: (a) fulfillment costs Ac€?o these are viewed as cost of sales for most retailers; (b) stock option costs Ac€?o these are probably for senior management and hence should probably be classified as SG&A; and (c) in the cash flow statement gains and losses on currency translations (shown at the end of the statement are shown as operating factors that imply that cash from operations in the standardized format does not equate to that reported by the firm.

Income Statement

Classifications200220012000
          Net sales$3,932,936$3,122,433$2,761,983
          Cost of sales2,940,3182,323,8752,106,206
          Gross profit992,618798,558655,777
          Operating expenses:
               Fulfillment392,467374,250414,509
               Marketing125,383138,283179,980
               Technology and content215,617241,165269,326
               General and administrative79,04989,862108,962
               Stock-based compensation68,9274,63724,797
               Amortization of goodwill and other intangibles5,478181,033321,772
               Restructuring-related and other41,573181,585200,311
Total operating expenses$928,494$1,210,815$1,519,657
Income (loss) from operations64,124-412,257-863,880
               Interest income23,68729,10340,821
               Interest expense-142,925-139,232-130,921
               Other income (expense), net5,623-1,900-10,058
               Other gains (losses), net-96,273-2,141-142,639
          Total non-operating expenses, net($209,888)($114,170)($242,797)
Loss before equity in losses of equity-method investees-145,764-526,427-1,106,677
          Equity in losses of equity-method investees, net-4,169-30,327-304,596
Loss before change in accounting principle($149,933)($556,754)($1,411,273)
Cumulative effect of change in accounting principle801-10,523
Net loss($149,132)($567,277)($1,411,273)

Balance Sheet

ClassificationsYear Beginning January 1, ($000’s)20032002
     Current assets:
          Cash and cash equivalents$738,254$540,282
          Marketable securities562,715456,303
          Inventories202,425143,722
          Accounts receivable, net & other current assets112,28267,613
Total current assets$1,615,676$1,207,920
     Fixed assets, net239,398271,751
     Goodwill, net70,81145,367
     Other intangibles, net3,46034,382
     Other equity investments15,44228,359
     Other assets45,66249,768
Total assets$1,990,449$1,637,547
LIABILITIES AND STOCKHOLDERS’ DEFICIT
     Current liabilities:
          Accounts payable618,128444,748
          Accrued expenses and other current liabilities314,935305,064
          Unearned revenue47,91687,978
          Interest payable71,66168,632
          Current portion of long-term debt and other13,31814,992
Total current liabilities$1,065,958$921,414
     Long-term debt and other2,277,3052,156,133
      ShareholdersAc€?c deficit
Common stock, $0.01 par value: Authorized shares 5,000,000 Issued and outstanding shares — 387,906 and 373,218 shares, respectively3,8793,732
               Additional paid-in capital$1,649,946$1,462,769
               Deferred stock-based compensation-6,591-9,853
               Accumulated other comprehensive income (loss)9,662-36,070
               Accumulated deficit-3,009,710-2,860,578
          Total stockholders’ deficit($1,352,814)($1,440,000)
Total liabilities and stockholders’ deficit1,990,4491,637,547

Cash Flow Statement

ClassificationsYear Ended December 31, ($000’s)200220012000
OPERATING ACTIVITIES:
     Net loss($149,132)($567,277)($1,411,273)
Adjustments to reconcile net loss to net cash provided by (used in) operating activities:
     Depreciation of fixed assets and other amortization82,27484,70984,460
      Stock-based compensation68,9274,63724,797
      Equity in losses of equity-method investees4,16930,327304,596
      Amortization of goodwill and other intangibles5,478181,033321,772
      Non-cash restructuring-related and other3,47073,293200,311
      Gain on sale of marketable securities, net-5,700-1,335-280
      Other losses (gains), net96,2732,141142,639
      Non-cash interest expense and other29,58626,62924,766
       Cumulative effect of change in accounting principle-80110,523
     Changes in operating assets and liabilities:
          Inventories-51,30330,62846,083
          Accounts receivable, net and other cur. assets-32,94820,732-8,585
          Accounts payable156,542-44,43822,357
          Accrued expenses and other current liabilities4,49150,03193,967
          Unearned revenue95,404114,73897,818
          Amortization of previously unearned revenue-135,466-135,808-108,211
          Interest payable3,027-34534,341
Net cash provided by (used in) operating activities$174,291($119,782)($130,442)
Year Ended December 31, ($000’s)200220012000
INVESTING ACTIVITIES:
Sales/maturities of marketable securities and investments553,289370,377545,724
Purchases of marketable securities-635,810-567,152-184,455
Purchases of fixed assets, including internal-use software-39,163-50,321-134,758
Investments (including in equity-method investees)-6,198-62,533
Net cash provided by (used in) investing activities($121,684)($253,294)$163,978
FINANCING ACTIVITIES:
Proceeds from exercise of stock options and other121,68916,62544,697
Proceeds from issuance of common stock, net of issue costs99,831
Proceeds from long-term debt and other10,000681,499
Repayment of capital lease obligations and other-14,795-19,575-16,927
   Financing costs-16,122
Net cash provided by financing activities$106,894$106,881$693,147
Effect of exchange-rate changes on cash and cash equivalents38,471-15,958-37,557
Net increase (decrease) in cash and cash equivalents$197,972($282,153)$689,126