Cash Flow With Solutions
Cash Flow With Solutions
Cash Flow With Solutions
The Statement of
Cash Flows
Purposeofas
tat
ementofcashflows:
To provide information about the cash inflows and outflows of an entity
during a period.
To summarize the operating, investing, and financing activities of the
business.
Revi
ew oft
erms
Cash and cash equivalents
It is a short-term, highly liquid investment.
It must be readily convertible to cash and it must be so near to maturity that
there is insignificant risks of changes in value due to changes in interest rate.
Noncashrevenuesandexpenses
Net income includes items that were neither cash inflow nor cash outflows:
Depreciation expense
Accretion expense on asset retirement obligation
Amortization of intangibles
Impairment loss on goodwill and intangibles
Earnings of affiliated companies accounted for using the equity method
Impairment losses on other noncurrent assets
Compensation expense related to stock options
Net income also includes gains and losses from investing and financing activities
Gain ≠ cash received (unless carrying value was zero)
Even when there is a loss, cash might have been received
Net income must be adjusted for these items to get the cash provided by operations – part of the reconciling
schedule or “indirect method”
For other items, there are revenues/expenses as well as cash flows but the amounts are different:
Bond interest expense ≠ bond interest paid (if bonds were sold at premium or discount)
Sales were not all collected in cash (bad debts, other changes in Accounts Receivable)
Purchases were not necessarily paid for during period (change in Accounts Payable)
Income tax expense ≠ income taxes paid due to deferred tax assets/liabilities as well as income taxes
refunds receivable or unpaid taxes owed
Outflows:
To suppliers for inventory and other materials
To employees for services
To other entities for services (insurance, etc.)
To government for taxes
To lenders for interest
To purchase trading securities
Interest expense is an operating item! Investment earnings (dividends & interest) is an operating item!
Buying and selling trading securities are operating activities! These things may not make sense to you – so
“memorize.”
I
nves
tingAct
ivi
ties
Inflows:
*except investments classified as trading securities which are included in operating activities
Fi
nanci
ngAct
ivi
ties
(Usually associated with long-term liability and equity items)
Inflows:
To stockholders as dividends
To repay or retire long-term debt, including capital leases
for lessee (interest on leases is classified as operating)
To reacquire capital stock (treasury stock)
An“
anomal
y”onSCF
Dividends are paid to stockholders and interest is paid to
bondholders.
Dividends paid are shown as outflows under financing
activities
However, FASB defined interest expense to be an operating
activity
Interest & dividend revenue are defined to be operating
activities, too.
Di
rectvers
usI
ndi
rectPresent
ati
ons
FASB Statement No. 95 allows two ways to calculate and
report a company’s net cash flow from operating activities on
its statement of cash flows.
TheDi
rectMet
hod
Under the direct method, operating cash outflows are
deducted from operating cash inflows to determine the net
cash flow from operating activities.
If you choose the direct method, a reconciliation of cash provided by
operations to net income is a required disclosure.
This is the same schedule that appears in a statement prepared using the
indirect method
The required information items on a direct method statement of cash flow (per
FASB)
Operating Inflows
Cash collected from customers (including lessees, tenants, licensees,
and the like)
Interest and dividends received
Other operating cash receipts, if any
Operating outflows
Cash paid to employees and other suppliers of goods or services
(including insurance, advertising and the like)
Interest paid
Income taxes paid
Other operating cash payments, if any
TheI
ndi
rectMet
hod
Under the indirect method, net income is adjusted for
noncash items related to operations to compute the net cash
flow from operating activities.
If you choose to use the indirect method, you must also disclose interest paid
and income taxes paid during the year.
NoncashI
tems
Some financing and investing activities do not affect an
entity’s cash flow.
Examples:
Trade common stock for land
Issue bonds in exchange for a building
Convertible bonds converted to common stock
Significant transactions should be disclosed separately.
The disclosure of significant noncash financing and investing
activities are required under both methods (direct & indirect)
The disclosure can be on face of the statement or in the
notes to the financial statements.
Theor
eti
calCons
ider
ati
ons
The direct method has the advantage of reporting operating cash inflows separately from
operating cash outflows, which may be useful in estimating future cash flows.
The direct method is more meaningful to most financial statement users and the “tie in” to net
income is also provided in a separate schedule which is the same as the indirect method
presentation.
Under the indirect method, adjustments are made to net income to arrive at cash flow from
operating activities. Thus, cash from operating activities is “tied” to net income.
An advantage of the indirect method is that income flows are converted from an accrual basis to
a cash flow basis. In this manner, the indirect method shows the “quality of earnings” by
providing information about intervals of leads and lags between income flows and operating cash
flows.
Investing Activities
Financing Activities
Noncash Financing/Investing
Additional information:
a. Wrote off $500 accounts receivable as uncollectible d. Sold land for $30,000 that had been acquired for $10,000
b. Sold operational assets for $4,000 cash that had cost e. Paid a $10,000 long-term note installment
$17,000 and had a book value of $8,000 f. Purchase plant, property & equipment for $48,000 cash.
c. Declared a cash dividend of $13,000 g. Issued common stock for $45,000 cash.
Investing Activities
Financing Activities
Noncash Financing/Investing
Additional information:
a. Wrote off $500 accounts receivable as uncollectible d. Sold land for $30,000 that had been acquired for $10,000
b. Sold operational assets for $4,000 cash that had cost e. Paid a $10,000 long-term note installment
$17,000 and had a book value of $8,000 f. Purchase plant, property & equipment for $48,000 cash.
Investing Activities
Financing Activities
Noncash Financing/Investing
CHANGE IN CASH
Totals
Additional Information
a. Wrote off $500 accounts receivable as uncollectible d. Issued common stock for $36,000 cash
b. Sold operational assets for $4,000 cash e. Paid a $20,000 long-term note installment
(cost $15,000, acc'd depreciation $9,000) f. Purchased operational assets, $39,000 cash
c. Declared and paid a cash dividend, $5,000 g. Acquired land in exchange for 1,000 shares of
common stock worth $45 each
Example 2
Moscow Moving & Storage
Statement of Cash Flow Worksheet
Reconciliation Schedule (Indirect method) Ref
Net income
Example 3
Avery Slings & Arrows, Inc.
Avery Slings & Arrows
Income Statement
For year ending 12/31/04
Sales 6,600,000
Earnings of affiliates (equity method) 150,000
Realized loss on sale of equipment (65,000)
Realized gain on sale of investments 53,000
Interest and dividend revenue 15,000
Total revenues 6,753,000
Prepare a statement of cash flows (direct method) including the required reconciling schedule and any other required
disclosures for Avery Slings & Arrows, Inc. Information from the balance sheet and income statement have been
entered into a worksheet for your convenience. In addition to completing the worksheet, you MUST prepare a formal
statement with headings, subtotals, etc. for full credit.
ADDITIONAL INFORMATION
a. During the year, ASA paid $2,767,000 in cash for land, building, and equipment.
b. On August 5, 2004, ASA issued 25,000 shares of common stock for $42 per share.
c. ASA purchased $273,000 in marketable securities during the year.
d. Equipment costing $500,000 was sold during the year for $59,000. The book value was $124,000.
e. During the year, AAS declared cash dividends in the amount of $203,000.
f. On April 1, 2004, the holders of $1,500,000 in convertible bonds elected to convert their bonds to common
stock. The conversion ratio was 25 shares of common stock for each share $1,000 face value bond.
g. The noncurrent investment represents 30% of the outstanding securities of the investee. This investment is
accounted for on the equity method. During 2004, ASA received $29,000 in dividends from the investment.
h. On May 1, 2004, ASA acquired equipment under a capital lease. At the inception of the lease, the present
value of the minimum lease payments was $648,000.
i. ASA acquired a patent on a new process for $500,000 on October 15, 2004.
j. During 2004, ASA sold marketable securities which it had acquired for $222,000 for $275,000.
k. In February, ASA issued 150,000 shares of common stock in a 50% stock dividend.
l. ASA issued $3,000,000 in bonds at face value on August 1, 2004.
m. ASA sold 500 shares of treasury stock which it had acquired for $20 per share for $46 per share on January 18,
2004.
n. In October, ASA acquired 1,000 shares of treasury stock at $38 per share.
o. Bad debts in the amount of $33,000 were written off during the year.
Current Liabilities
Accounts Payable 347,000 650,000
Salaries Payable 18,000 21,000
Interest payable 156,000 55,000
Income Taxes Payable 45,000 32,000
Dividends Payable 128,000 60,000
694,000 818,000
Noncurrent Liabilities
Bonds Payable 7,000,000 4,000,000
Premium/Discount on Bonds Payable 642,000 656,000
Convertible Bonds Payable 1,500,000 3,000,000
Lease obligation 2,108,000 1,825,000
Asset retirement obligation 275,000 250,000
Deferred Income Taxes 122,000 75,000
Other long term liabilities 590,000 2,590,000
12,237,000 12,396,000
Stockholder's Equity
Common stock, $10 par 5,125,000 3,000,000
Additional paid in capital - common 3,525,000 1,600,000
Other paid in capital 13,000 0
Unrealized (gain)/loss AFS invest 27,000 (80,000)
Treasury stock (at cost) (38,000) (10,000)
Retained Earnings 4,712,000 6,149,000
13,364,000 10,659,000
Investments in affiliated
2,000,000 2,121,000 121,000
companies (equity method)
(Premium)/Discount on Bonds
(656,000) (642,000) 14,000
Payable
(23,873,000) (26,295,000)
Reconciling schedule:
Net income 266,000
Investing Activities 0
Financing Activities 0
Noncash Financing/Investing
Noncurrent Assets
Investments (equity method) 3,097,000 3,000,000
Plant, property & equipment 16,420,000 10,800,000
Accumulated Depreciation (829,000) (600,000)
Intangible Assets 71,500 128,000
TOTAL ASSETS 24,847,600 18,205,000
Current Liabilities
Accounts Payable 880,000 750,000
Salaries Payable 20,000 15,000
Income Taxes Payable 13,400 27,000
Dividends Payable 35,000 60,000
Current portion long term debt 29,000 21,000
977,400 873,000
Noncurrent Liabilities
Bonds Payable 10,000,000 5,000,000
Discount on Bonds (247,000) (270,000)
Deferred Income Taxes 180,000 88,000
Other long term liabilities 562,000 3,000,000
10,495,000 7,818,000
Stockholder's Equity
Convertible preferred, $100 par 500,000 2,000,000
Common stock, $10 par 3,100,000 1,500,000
Additional paid in capital 3,950,000 1,200,000
Unrealized (gain)/loss investments 27,000 78,000
Retained Earnings 5,798,200 4,736,000
13,375,200 9,514,000
Total liabilities and equity 24,847,600 18,205,000
Sales 6,200,000
Earnings of affiliated company (equity method) 115,000
Gain/(loss) on sale of PP&E (40,000)
Realized gain/(loss) on investments 108,000
Realized gain on sale of patent 950,000
Interest and dividend revenue 13,000
Total revenues 7,346,000
Additional information:
a. On February 25, WWW sold an internally developed patent for $1,000,000. The patent was carried on the
books at unamortized legal fees amounting to $50,000 at date of sale.
b. On March 31, WWW issued $5,000,000 in bonds at face value. The semi-annual bonds have a coupon rate
of 10% per annum.
c. During the year, WWW disposed of various items of equipment with a total book value of $65,000 and
original cost of $80,000. The amount received was $25,000 in cash.
d. During the third quarter, shareholders holding 15,000 shares of the preferred stock converted them into
common stock. The conversion ratio was 6 shares of common for each share of preferred.
e. On July 20, WWW sold 50,000 shares of its common stock for $41 per share.
f. By the end of the year, WWW had written off as uncollectible a total of $28,000 in accounts receivable.
g. An existing factory with equipment was acquired during the year. The acquisition cost was allocated as
follows: $772,000 to land, $3,450,000 to building and 678,000 to equipment.
h. WWW acquired a parcel of land adjoining the new factory by giving the owner 20,000 shares of its
common stock. At the date of the transaction, the market value of the stock was $40 per share.
i. During the year WWW purchased $875,000 in marketable securities and sold securities which had cost
$584,000. The market value of the portfolio at the end of the year was $390,000.
j. WWW owns 30% of a company which manufactures parts that WWW uses in its production process.
WWW received $18,000 in dividends from this partially owned company during 1996.
k. Dividends declared during the year totaled $50,000.
18,205,00 24,847,60
0 0
Accounts Payable (750,000) (880,000) (130,000)
Investing Activities
Financing Activities
Noncash Financing/Investing
St
atementofCashFl
ow –Eas
yPract
iceProbl
ems5& 6
5. Ulliman Company
Prepare a statement of cash flow – direct method including the reconciliation schedule. Most
information is provided on the attached workpaper.
Additional information:
a. Dividends declared and paid totaled $700.
b. On January 1, 1999 the 10% convertible bonds that had originally been issued at face value
were converted into 500 shares of common stock. The book value method was used to
account for the conversion.
c. Long-term nonmarketable investments that cost $1,600 were sold for $2,300.
d. The long-term note payable was paid by issuing 250 shares of common stock at the
beginning of the year.
e. Equipment with a cost of $2,000 and a book value of $300 was sold for $100.
f. Equipment was purchased at a cost of $16,200.
g. The 12% bonds payable were issued on September 1, 1999 at 97. They mature on
September 1, 2009. The company uses the straight-line method to amortize the discount.
h. Taxable income was less than pretax accounting income, resulting in a $396 increase in
deferred taxes payable.
i. Short-term marketable securities were purchased at a cost of $1,300. The portfolio was
increased by $300 to a $3,800 fair value at year end by adjusting the related allowance
account.
6. Driskoll Company
Prepare a statement of cash flow – direct method including the reconciliation schedule. Most
information is provided on the attached workpaper.
Additional information:
a. Dividends were declared in the amount of $2,100.
b. Bonds payable with a face value, book value, and market value of $14,000 were retired on
June 30, 1999.
c. Bonds payable with a face value of $8,000 were issued at 90.25 on July 31, 1999, They
mature on July 31, 2004. The company uses the straight-line method to amortize the bond
discount.
d. Equipment with a cost of $4,000 and a book value of $1,400 was exchanged for an acre of
land valued at $2,700. No cash was exchanged. The transaction was properly considered to
be a dissimilar asset exchange.
e. Long-term investments in bonds being held to maturity with a cost of $1,000 were sold for
$800.
f. Sixty-five shares of common stock were exchanged for a patent. The common stock was
selling for $20 per share at the time of the exchange.
g. A tornado completely destroyed a small building that had an original cost of $8,000 and a
book value of $4,800. Settlement with the insurance company resulted in after-tax proceeds
of $2,200 and an extraordinary loss (net of income taxes) of $2,600.
Reconciliation Schedule:
Investing Activities
Financing Activities
Noncash Financing/Investing
CHANGE IN CASH
Totals
Reconciliation Schedule:
Investing Activities
Financing Activities
Noncash Financing/Investing
CHANGE IN CASH
Totals
4,178,000 6,244,800
Accounts Payable (350,000) (413,000) (63,000)
Salaries Payable (8,500) (7,200) 1,300
Income Taxes Payable (27,000) (23,500) 3,500
Dividends Payable (25,000) 0 25,000
Bonds Payable (1,000,000) (1,000,000) 0
Premium/Discount on Bonds Payable (124,000) (118,000) 6,000
Deferred Income Taxes (88,000) (103,700) (15,700)
Common stock, $10 par (1,000,000) (1,510,000) (510,000)
Closing entry for 1997 Rev/(Exp) Ref Debit Ref Credit Receipt/(Disb)
Sales 3,600,000
Gain/(loss) on sale of PP&E (30,000)
Interest and dividend revenue 15,000
Cost of goods sold (2,100,000)
7. Albion Altimeters
Statement of Cash Flows INFLOWS OUTFLOWS (Subtotals)
Operating Activities
Investing Activities
Financing Activities
Noncash Financing/Investing
Albion Altimeters
Statement of Cash Flow
For year ended 12-31-97
Albion Altimeters
Statement of Cash Flow
For year ended 12-31-97
Reconciling schedule
Notes:
Acct315-St
atementofCashFl
ow
HomeworkProblem #8
Instructions:
Prepare the statement of cash flow for Endicott Engines Inc. (attached) using the direct method.
Show all your work on clearly labeled and well-organized worksheet (provided) or equivalent
printout. Label your work and answers clearly. You must submit a worksheet if you want me to
be able to follow your thought process (in case your answer is wrong). If the problem doesn’t
“balance”, you may “plug” something (clearly labeled as a plug) and still obtain most of the
available points. If you are using spreadsheet software, please explain your computations since I
cannot tell what formulas you incorporated into the cells from looking at the printout. The Excel
worksheet is available on the course web page: http://www.academic.uidaho.edu/Acct301.
NOTE: For full credit, you must prepare the statement of cash flow in good form (direct
method) with all necessary disclosures including a reconciling schedule and disclosures about
noncash financing and investing activities.
Sales 6,500,000
Earnings of affiliated companies (equity method) 125,000
Gain/(loss) on sale of PP&E (30,000)
Realized gain/(loss) on investments 192,000
Realized gain on sale of patent 450,000
Interest and dividend revenue 15,000
Total revenues 7,252,000
Additional information:
Current Assets
Cash 1,308,200 1,500,000
Securities Available for Sale 536,000 300,000
Accounts Receivable 2,145,000 2,000,000
Allowance for doubtful accounts (122,200) (110,000)
Merchandise Inventory 1,165,000 975,000
Prepaid Operating Expenses 63,000 50,000
5,095,000 4,715,000
Noncurrent Assets
Investments (partially owned companies) 2,605,000 2,500,000
Plant, property & equipment 17,142,000 10,700,000
Accumulated Depreciation (934,000) (700,000)
Intangible Assets 93,000 150,000
TOTAL ASSETS 24,001,000 17,365,000
Current Liabilities
Accounts Payable 1,050,000 800,000
Salaries Payable 43,000 18,000
Income Taxes Payable 24,000 35,000
Dividends Payable 85,000 60,000
1,202,000 913,000
Noncurrent Liabilities
Bonds Payable 11,000,000 5,000,000
Discount on Bonds (277,000) (300,000)
Deferred Income Taxes 142,000 90,000
Lease obligations 749,000 323,000
Other long term liabilities 570,000 3,000,000
12,184,000 8,113,000
Stockholder's Equity
Convertible preferred, $100 par 1,000,000 2,000,000
Common stock, $10 par 2,150,000 1,000,000
Additional paid in capital 2,575,000 1,200,000
Unrealized (gain)/loss investments 27,000 91,000
Retained Earnings 4,863,000 4,048,000
10,615,000 8,339,000
Total liabilities and equity 24,001,000 17,365,000
17,365,000 24,001,000
Accounts Payable (800,000) (1,050,000) (250,000)
0 (17,365,000) (24,001,000)
Closing entry for 2002: Rev/(Exp) Receipt/(Disb)
Sales 6,500,000
Investing Activities
Noncash Financing/Investing
Investing Activities
Sold equipment b 4,000
Sold land d 30,000
Purchase PP&E f 48,000
Financing Activities
Dividends paid c 5,000
Payment on LT debt e 10,000
Issued common stock g 45,000
Noncash Financing/Investing
Investing Activities
Sold operational assets b 4,000 (35,000)
Purchased operational assets f 39,000
g 648,000
Accumulated Depreciation (1,800,000) d 376,000 p 757,000 (2,181,000) (381,000)
Intangible Assets 73,000 I 500,000 p 5,000 568,000 495,000
Total assets 23,873,000 26,295,000
Reconciling schedule:
Net income 266,000
Depreciation 757,000
Amortization & impairment of 5,000
intangibles
Accretion expense 25,000
Bond premiums/discounts (14,000)
Realized gains/losses PP&E 65,000
Realized gain/loss investments (53,000)
Equity method investments (121,000)
Deferred income taxes 47,000
Change in working capital:
Net accounts receivable (47,000)
Merchandise Inventory 298,000
Prepaid Expenses 46,000
Accounts Payable (303,000)
Salaries Payable (3,000)
Interest payable 101,000
Income Taxes Payable 13,000
Noncash Financing/Investing
Bonds converted into stock f 1,500,000 f 1,500,000
Capital lease h 648,000 648,000
Stock dividend K
Solution
Example 4- Acct 315
Worksheet Year ending Year ending
Wenatchee Whirlpool World 12/31/95 Ref Debit Ref Credit 12/31/96 Target
Cash 2,000,000 X 837,600 2,837,600 837,600
o 51,000
Securities Available for Sale (at market) 150,000 I 875,000 I 584,000 390,000 240,000
p 120,000
Accounts Receivable 1,900,000 f 28,000 1,752,000 (148,000)
Allowance for doubtful accounts (110,000) f 28,000 m 38,500 (120,500) (10,500)
Merchandise Inventory 875,000 p 270,000 1,145,000 270,000
Prepaid Operating Expenses 62,000 p 22,000 84,000 22,000
Investments (equity method) 3,000,000 l 115,000 j 18,000 3,097,000 97,000
h 800,000
Plant, property & equipment 10,800,000 g 4,900,000 c 80,000 16,420,000 5,620,000
Accumulated Depreciation (600,000) c 15,000 n 244,000 (829,000) (229,000)
n 6,500
Intangible Assets 128,000 a 50,000 71,500 (56,500)
18,205,000 24,847,600
Accounts Payable (750,000) p 130,000 (880,000) (130,000)
Salaries Payable (15,000) p 5,000 (20,000) (5,000)
Income Taxes Payable (27,000) q 13,600 (13,400) 13,600
Dividends Payable (60,000) k 75,000 k 50,000 (35,000) 25,000
Current portion long term debt (21,000) s 8,000 (29,000) (8,000)
Bonds Payable (5,000,000) b 5,000,000 (10,000,000) (5,000,000)
Premium/Discount on Bonds Payable 270,000 r 23,000 247,000 (23,000)
Deferred Income Taxes (88,000) q 92,000 (180,000) (92,000)
s 2,430,000
Other long term liabilities (3,000,000) s 8,000 (562,000) 2,438,000
12/31/95 ref Debit ref Credit 12/31/96 Target
Convertible preferred, $100 par (2,000,000) d 1,500,000 (500,000) 1,500,000
h 200,000
e 500,000
Common stock, $10 par (1,500,000) d 900,000 (3,100,000) (1,600,000)
h 600,000
e 1,550,000
Additional paid in capital (1,200,000) d 600,000 (3,950,000) (2,750,000)
Unrealized (gain)/loss investments (78,000) o 51,000 (27,000) 51,000
Retained Earnings (4,736,000) k 50,000 X 1,112,200 (5,798,200) (1,062,200)
0 (18,205,000) (24,847,600)
Reconciling schedule:
Net Income 1,112,200
Depreciation & amortization 250,500
Bond premiums/discounts 23,000
Realized gains/losses PP&E 40,000
Realized gain/loss investments (108,000)
Gain on sale of patent (950,000)
Undistributed Earnings of Investees (97,000)
Deferred income taxes 92,000
Change in working capital accounts:
Net accounts receivable 158,500
Merchandise Inventory (270,000)
Prepaid Operating Expenses (22,000)
Accounts Payable 130,000
Salaries Payable 5,000
Income Taxes Payable (13,600)
Cash provided by operations: 350,600
Investing Activities
Sale of patent a 1,000,000
Sale of equipment c 25,000
Purchase factory g 4,900,000
Purchase investment securities I 875,000
Sold investment securities I 692,000
Financing Activities
Issued bonds b 5,000,000
Issued common stock e 2,050,000
Dividends paid k 75,000
Long-term debt repaid s 2,430,000
Noncash Financing/Investing
Preferred converted to common stock d 1,500,000 d 1,500,000
Swap common stock for land h 800,000 h 800,000
Solution
Working through the additional items of information:
a. On February 25, WWW sold an internally developed patent for $1,000,000. The patent was carried on the
books at unamortized legal fees amounting to $50,000 at date of sale.
h. WWW acquired a parcel of land adjoining the new factory by giving the owner 20,000 shares of its common
stock. At the date of the transaction, the market value of the stock was $40 per share. The value of the land
is $800,000 (20,000 * 40).
l. No deposit was made for share of earnings of partially owned companies. Therefore, this
account needs to be zeroed out by re-constructing the entry that recorded the share of
earnings.
m. No check was written for bad debt expense. Therefore, this account needs to be zeroed out by
re-constructing the entry that recorded bad debt expense for the year (the credit is always to
allowance for doubtful accounts.
Starting through the balance sheet to investigate accounts not yet balanced:
o. Securities available for sale (at market) doesn’t balance by $51,000. However, this amount
appears in the owners’ equity section as the change in Unrealized (gain)/loss on investments.
Therefore, this amount must have been the adjusting entry for the “allowance for change in
value” account.
p. The remaining difference in accounts receivable ($120,000) is the adjustment to sales to get
from accrual basis to cash basis. The difference in Merchandise Inventory is an adjustment to
cost of goods sold. The difference in prepaid operating expenses is an adjustment to other
operating expenses. The change in accounts payable would mostly be related to cost of goods
sold. The change in salaries payable affects salaries and wages expense.
Sales 120,000
Accounts receivable 120,000
Merchandise inventory 270,000
Cost of goods sold 270,000
Prepaid operating expenses 22,000
Other operating expenses 22,000
Accounts payable 130,000
Cost of goods sold 130,000
Salaries payable 5,000
Salaries and wages 5,000
q. Income tax expense is affected by two accounts on the balance sheet - income taxes payable
and deferred income taxes.
s. Long-term debt is presented in two numbers on balance sheet - current and noncurrent. These
accounts need to be combined to find out how much was borrowed or repaid during the year.
Take the change in one account to the other. The remaining “amount to balance” will be the
cash inflow or outflow.
After this entry, the number necessary to balance other long-term debt is $2,430,000 which must
be the amount of long-term debt repaid during the year.
** This is the easiest way to handle bad debts: just enter change in NET A/R:
Change in Accounts Receivable 148,000
Change in Allowance for Doubtful Accounts 10,500
158,500
This is the more difficult alternate:
Adjustment to sales (to get cash collected from 120,000
customers)
Bad debt expense 38,500
158,500
What does not work is to include bad debt expense +
change in Accounts Receivable and change in Allowance!
Ulliman Company
Statement of Cash Flows INFLOWS OUTFLOWS Subtotals
Operating Activities xx 7,100 7,100
Reconciliation Schedule:
Net Income 4,800
Loss on sale of equipment 200 f
Gain on sale of investments (700) d
Depreciation expense 2,100 k
Bond discount amortization 10 s
Deferred income taxes 396 i
Change in WC accounts:
Accounts receivable (net) 110
Merchandise Inventory 190
Prepaid Expenses (410)
Accounts Payable 350
Income Taxes Payable 104
Wages payable (450)
Interest payable 400
7,100
Noncash Financing/Investing
LT debt retired by issue of common stock e
conversion of bonds to stock c
Ulliman Company
Statement of Cash Flows
For year ended December 31, 1999
Driskoll Company
Statement of Cash Flows INFLOWS OUTFLOWS Subtotals
Operating Activities xx 6,700 6,700
Reconciliation Schedule:
Net income (1,400)
Depreciation 5,800 g
amortization 815 h
Extraordinary loss (net of taxes) 2,600
Gain/(loss) on exchange of assets (1,300)
Realized gain/(loss) on investments 200
Amort of Bond Discount 65 o
change in WC accounts:
Accounts receivable (net) (315) i
Inventories (230) j
Prepaid Expenses 400 k
Accounts Payable 295 L
Interest payable (330) m
Wages payable 100 n
6,700
Noncash Financing/Investing
Exchanged equipment for land d
Exchanged stock for patent f
Driskoll Company
Statement of Cash Flows
For year ended December 31, 1998
Year
Worksheet Year ending ending
Albion Altimeters Inc. 12/31/96 Ref Debit Ref Credit 12/31/97
Cash 400,000 89,800 310,200
Securities Available for Sale (at r, 27,000
market) 500,000 f 585,000 1,112,000
J 11,000
Accounts Receivable 900,000 e 108,000 781,000
Allowance for doubtful accounts (27,000) e 11,000 i 17,200 (33,200)
Merchandise Inventory 850,000 k 21,000 829,000
Prepaid Operating Expenses 25,000 m 13,800 38,800
g, 32,000
Plant, property & equipment 1,880,000 c 1,740,000 b 90,000 3,562,000
Accumulated Depreciation (350,000) b 25,000 h 30,000 (355,000)
4,178,000 6,244,800
Accounts Payable (350,000) l 63,000 (413,000)
Salaries Payable (8,500) n 1,300 (7,200)
Income Taxes Payable (27,000) o 3,500 (23,500)
Dividends Payable (25,000) A 100,000 a 75,000 0
Bonds Payable (1,000,000) (1,000,000)
Premium/Discount on Bonds
Payable (124,000) p 6,000 (118,000)
Deferred Income Taxes (88,000) q 15,700 (103,700)
G 10,000
Common stock, $10 par (1,000,000) d 500,000 (1,510,000)
G 22,000
Additional paid in capital (700,000) d 1,250,000 (1,972,000)
Acc'd other comprehensive income 14,000 r 27,000 (13,000)
Retained Earnings (869,500) a 75,000 x 289,900 (1,084,400)
0 (4,178,000) (6,244,800)
Albion Altimeters
1997 1997
Receipt/
Closing entry for 1997 Rev/(Exp) Ref Debit Ref Credit (Disb)
Sales 3,600,000 j 108,000 3,708,000
Gain/(loss) on sale of PP&E (30,000) b 30,000 0
Interest and dividend revenue 15,000 15,000
k 21,000
Cost of goods sold (2,100,000) l 63,000 (2,016,000)
Salaries and wages (650,000) n 1,300 (651,300)
Other operating expenses (230,000) m 13,800 (243,800)
Bad debt expense (17,200) I 17,200 0
Depreciation expense (30,000) H 30,000 0
Interest expense (87,700) p 6,000 (93,700)
Income taxes expense (180,200) Q 15,700 o 3,500 (168,000)
Net income (accrual basis) 289,900 X 289,900 X 550,200 550,200
OUTFLO (Subtotals
Statement of Cash Flows INFLOWS WS )
Operating Activities X 550,200 550,200
Net income 289,900 X
Add depreciation expense 30,000 H
Add loss on sale of equipment 30,000 B
Amortization of discount on B/P (6,000) P
Deferred Income Taxes 15,700 Q
Change in working capital accounts:
Accounts Receivable 119,000
Allowance for doubtful accounts 6,200
Merchandise Inventory 21,000
Prepaid Operating Expenses (13,800)
Accounts Payable 63,000
Salaries Payable (1,300)
Income Taxes Payable (3,500)
550,200
Investing Activities (2,290,000)
Proceeds from sale of equipment b 35,000
Purchase building & equipment c 1,740,000
Purchase marketable securities f 585,000
Noncash Financing/Investing
Exchange common stock for land valued
at $32,000
CHANGE IN CASH 89,800
Totals 5,619,400 5,619,400 (89,800)
0
Additional information:
Camperdown Company a. During the year, Camperdown Corporation paid quarterly dividends in
the total amount of $86,000.
Income Statement b. The preferred stock is convertible into 6 shares of common stock at the
For year ending 12/31/02 discretion of the stockholder. During the year, 5,000 shares of
preferred stock were converted into common stock.
Sales 10,000,000 c. Camperdown Corporation received $27,000 in dividends from Edible
Investment income 50,000 Oils Inc (equity method investment). The securities held in the
Gain/(loss) on sale of PP&E (45,000) available for sale portfolio paid no cash dividends during the year.
Realized gain/(loss) on d. During the year, Camperdown Corporation sold a piece of equipment
investments 10,000 for $25,000. The historical cost of the asset was $100,000 and the
book value was $70,000 at the date of sale.
Total revenues 10,015,000
e. On April 30, Camperdown Corporation issued 10,000 shares of
common stock for $60 per share.
Cost of goods sold 6,000,000 f. Camperdown Corporation acquired a new processing plant for a total
Salaries and wages 600,000 cost of $2,450,000. $2,000,000 was attributed to the building and the
Other operating expenses 250,000 remainder was attributed to the cost of the land.
Bad debt expense 21,000 g. Camperdown Corporation wrote off $5,000 in bad debts during the
Depreciation & amortization year.
expense 1,077,000 h. Camperdown Corporation sold marketable securities that had cost
Interest expense 565,000 $90,000 for $100,000.
Income taxes expense 551,000 9,064,000 i. Camperdown Corporation entered into a new capital lease
arrangement to obtain manufacturing equipment needed for the new
Net income 951,000 facility. The present value of the minimum lease payments was
$358,000 at the inception of the lease.
j. Half of the 1,000 shares of treasury stock were sold for
$64 per share. Camperdown Corporation uses the cost
method. The treasury stock on hand at the beginning of
the year was carried at $52 per share.
Sales 10,000,000
Camperdown Company
Investing Activities
Financing Activities
Camperdown Company
Noncash Financing/Investing
Camperdown Corporation
Statement of Cash Flow
For year ended 12-31-02
Camperdown Corporation
Statement of Cash Flow
For year ended 12-31-02
Reconciling schedule
Notes