Finance Brain
Sign in
← Back to decks
Sign in to save your progress.Sign in

Finding Cash Amounts from Account Changes

Cash flow questions often hide a cash figure inside an income statement amount and a couple of balance sheet changes. This lesson shows how to work back to cash collected, cash paid and sale proceeds by rolling accounts forward, the analysis the direct method relies on.

10 cards
Study this deck

Finding Cash Amounts from Account Changes

In this lesson · 4 sections
Show one section at a time

Terms you'll meet

Tap a card to see what it means.

Cash flow questions often hide a cash figure inside an income statement amount and a couple of balance sheet changes. This lesson shows how to work back to cash collected, cash paid and sale proceeds by rolling accounts forward, the analysis the direct method relies on.

The method

Every operating cash amount starts from a revenue or expense and is adjusted for the balance sheet accounts that sit between the accrual and the cash. Write the account's rollforward (opening balance, plus increases, less decreases, equals closing balance) and solve for the one unknown, which is usually the cash.

Cash amountStart withThen adjust for
Collected from customersSalesChange in gross receivables; write-offs; change in unearned revenue
Paid to suppliersCost of goods soldChange in inventory (gives purchases); change in trade payables
Paid for other operating costsThe expense, less noncash parts such as depreciationChange in prepaid expenses; change in accrued liabilities
Interest paidInterest expenseDiscount or premium amortization; change in interest payable
Income taxes paidIncome tax expenseDeferred tax expense or benefit; change in taxes payable

Directions follow from the rollforward. A receivable that grows means sales exceeded collections. Inventory that grows means purchases exceeded cost of goods sold. A payable or accrual that grows means less was paid than was incurred, and a prepaid balance that grows means more was paid. Write-offs reduce gross receivables without any cash, so they come out of collections too. Recoveries of accounts written off earlier work the other way: they reinstate the receivable and are then collected in cash, so they add to collections. If a question gives net receivables and credit loss expense instead, use those together: sales, less credit loss expense, less the increase in net receivables gives the same collections.

Worked example

A logistics company's interest expense is 64,000, including 4,000 of discount amortization on its bonds, and interest payable rose by 3,000.

  • Interest paid = 64,000 - 4,000 - 3,000 = 57,000.

Its income tax expense is 120,000, of which 15,000 is deferred tax expense from a rise in its deferred tax liability; income taxes payable fell by 8,000.

  • Current tax expense = 120,000 - 15,000 = 105,000.
  • Income taxes paid = 105,000 + 8,000 = 113,000, because paying down the payable took more cash than this year's current tax.

Its selling and administrative expenses are 410,000, including 36,000 of depreciation. Prepaid insurance rose by 5,000 and accrued salaries fell by 7,000.

  • Cash paid for these costs = 410,000 - 36,000 + 5,000 + 7,000 = 386,000: depreciation used no cash, while building up the prepayment and paying down the accrual both took extra cash.

Plant asset and equity accounts

Sale proceeds and dividends paid come from the same kind of analysis applied to balance sheet accounts:

  • Proceeds from selling equipment. The cost rollforward (opening cost, plus purchases, less closing cost) gives the cost of the assets sold. The accumulated depreciation rollforward (opening balance, plus depreciation expense, less closing balance) gives the depreciation removed with them. Their difference is the carrying amount sold; add the gain or subtract the loss to reach the cash received.
  • Dividends paid. The retained earnings rollforward gives the dividends declared, once you take out anything else that moved retained earnings, such as a stock dividend, which reduces retained earnings without cash. Then adjust for the change in dividends payable.

The results feed both methods. The direct method reports these cash amounts as its lines, and the investing and financing sections report the proceeds and the dividends under either method.

On the exam

Write the rollforward and solve for the cash. Increases in assets mean more cash went out (or less came in); increases in liabilities mean less cash went out. Strip noncash pieces such as depreciation, write-offs, amortization, deferred taxes and stock dividends before you finish.

Independent exam-prep material. Not affiliated with the AICPA, NASBA, CFA Institute or CFP Board. Not financial advice. Learn more

Quiz me on this
Cash collected from customers (from accrual figures)
Save
Cash paid to inventory suppliers (from accrual figures)
Save
Interest paid (from interest expense)
Save
Proceeds from selling equipment (from rollforwards)
Save
Cash dividends paid (from retained earnings)
Save