It is a Cash Flow Statement question

Cash Flow Statement
1. Using the following information for 2023, calculate the net cash provided by
Operating Activities.
Net income
Depreciation & amortization expense
Increase in Accts Receivable
Increase in Inventory
Decrease in Office Supplies
Decrease in Other ST Liabilities
Increase in Accts Payable
$
$
$
$
$
$
$
225,000 add
60,000 add
30,000
40,000
25,000
15,000
45,000
2. Using the following information for 2023, calculate the net cash provided by
Investing Activities.
Purchase of building
Purchase of land
Purchase of equipment
Proceeds from sale of computers
Proceeds from sale of vehicles
Purchase of LT investments
Proceeds from sale of trademark
$
$
$
$
$
$
$
1,200,000
800,000
255,000
15,000
25,000
80,000
190,000
3. Using the following information for 2023, calculate the net cash provided by
Financing Activities.
Proceeds from issuance of LT mortgage payable
Payment on LT mortgage payable
Proceeds from issuance of preferred stock
Payment of dividends on preferred stock
$
$
$
$
1,500,000
5,000
800,000
15,000
4. Using the info from the above 3 problems, create a Cash Flow Statement
for the year ended 12/31/23 in proper format.
Beginning cash on 1/1/23 was $500,000.
1-2
LO9
Statement of Cash Flows
(p.335)
Provides relevant information about the cash
receipts and cash payments of an enterprise
during a period. This statement shows why cash
and cash equivalents changed during the period
by reporting net cash provided or (used by) . . .
Œ

Ž
Operating
Activities
Investing
Activities
Financing
Activities
McGraw-Hill/Irwin
2 9-2
© 2008 The McGraw-Hill Companies, Inc., All Rights Reserved.
1-3
LO9
Cash Inflows and Outflows
Operating Activities
Investing Activities
Financing Activities
Cash received
from revenues
Sale of operational assets
Sale of investments
Collections of loans
Issuance of stock
Issuance of bonds
and notes
Enterprise
Cash paid for
expenses
Purchase of operational assets
Purchase of investments
Loans to others
Payment of dividends
Repurchase of stock
Repayment of debt
Cash Outflows
McGraw-Hill/Irwin
9-3
© 2008 The McGraw-Hill Companies, Inc., All Rights Reserved.
1-4
L O 10
Cash Flows from
Operating Activities
1. Operating activities relate primarily to the receipt
of cash for general sales or operating revenues
(what the entity is in business to sell)
2. Operating activities also relate primarily to the
disbursement of cash for general operating
expenses (day to day business expenses)
3. Transactions: ST Assets & ST Liabilities (accounts
receivable, inventory, supplies, ST investments,
accounts payable, wages payable, interest payable,
taxes payable, ST notes payable, etc.)
McGraw-Hill/Irwin
9-4
© 2008 The McGraw-Hill Companies, Inc., All Rights Reserved.
1-5
L O 10
Cash Flows from
Investing Activities
1. Investing activities relate primarily to the purchase
and sale of noncurrent assets (land, buildings,
equipment, etc)
2. Investments in debt or equity securities of other
entities & lending of money and subsequent
collection of loans are considered investing
activities as well (LT Investments, LT Notes Rec)
3. Transactions: LT Assets (land, building, equipment,
furniture, software, computers, vehicles, intangible
assets, natural resources, LT investments, etc)
McGraw-Hill/Irwin
9-5
© 2008 The McGraw-Hill Companies, Inc., All Rights Reserved.
1-6
L O 10
Cash Flows from
Financing Activities
1. Financing activities relate to the issuance of stock
(common stock preferred stock, treasury stock)
2. Financing activities also relate to the issuance of
long-term debt (bonds payable or notes payable)
3. Transactions: LT Liabilities & Stockholders Equity
(LT debt, LT notes payable, LT bond payable,
common stock, preferred stock, dividends, treasury
stock, etc.)
McGraw-Hill/Irwin
9-6
© 2008 The McGraw-Hill Companies, Inc., All Rights Reserved.
1-7
Cash Flows from
Operating Activities:
n Start with Net income (add)
n Add back non-cash items:
n Depreciation/amortization/depletion expense
n Increase in ST assets
n Increase in inventory, accounts receivable
n Decrease in ST assets
n Decrease in inventory, accounts receivable
(cont’dà)
McGraw-Hill/Irwin
7
© 2008 The McGraw-Hill Companies, Inc., All Rights Reserved.
1-8
Cash Flows from Operating
Activities (cont’d):
n Increase in ST liabilities
n Increase in accounts payable, wages payable
n Decrease in ST liabilities
n Decrease in accounts payable, wages payable
n Net cash provided by (used in) operating
activities
McGraw-Hill/Irwin
8
© 2008 The McGraw-Hill Companies, Inc., All Rights Reserved.
1-9
Cash Flows from Investing
Activities:
n Increase in LT assets
n Purchase of land, buildings, equipment, etc.
n Decrease in LT assets
n Proceeds from sale of land, buildings, etc.
n Net cash provided by (used in) investing
activities
McGraw-Hill/Irwin
9
© 2008 The McGraw-Hill Companies, Inc., All Rights Reserved.
1-10
Cash Flows from
Financing Activities:
Increase in LT liabilities
n Proceeds from issuance of LT debt, bonds pay
n Decrease in LT liabilities
n Payment on LT debt, bonds payable
n Increase in equity
n Proceeds from issuance of common stock
n Decrease in equity
n Purchase of treasury stock
n Payment of dividends on common stock
n Net cash provided by (used in) financing activities
n
McGraw-Hill/Irwin
10
© 2008 The McGraw-Hill Companies, Inc., All Rights Reserved.
1-11
Cash Flow Statement
n For each item listed on the Cash Flow
Statement, ask yourself:
n How does this transaction affect my cash?
n Change in assets have the opposite effect
on cash
n Change in liabilities have the same effect
on cash
n Change in equity has the same effect on
cash
McGraw-Hill/Irwin
11
© 2008 The McGraw-Hill Companies, Inc., All Rights Reserved.
1-12
Cash Flow Statement
n Assets:
n Increase in assets à decrease in cash
n Decrease in assets à increase in cash
n Change in assets à opposite effect on cash
n Examples:
n Increase in inventory à decrease in cash
n Decrease in inventory àincrease in cash
n Increase in ST investment à decrease in cash
n Decrease in Accts. Rec. à increase in cash
McGraw-Hill/Irwin
12
© 2008 The McGraw-Hill Companies, Inc., All Rights Reserved.
1-13
Cash Flow Statement
Liabilities:
n Increase in liabilities à increase in cash
n Decrease in liabilities à decrease in cash
n Change in liabilities à same effect on cash
n Examples:
n Increase in ST notes pay à increase in cash
n Decrease in Accts Pay à decrease in cash
n Increase in ST bonds pay à increase in cash
n Decrease in wages pay à decrease in cash
McGraw-Hill/Irwin
13
© 2008 The McGraw-Hill Companies, Inc., All Rights Reserved.
1-14
Cash Flow Statement
Equity:
n Increase in equity à increase in cash
n Decrease in equity à decrease in cash
n Change in equity à same effect on cash
n Examples:
n Issuance/sale of common or preferred stock
(increase in equity)à increase in cash
n Purchase of treasury stock (decrease of common
stock)à decrease in cash
n Payment of dividends (decrease of retained
earnings & equity) à decrease in cash
McGraw-Hill/Irwin
14
© 2008 The McGraw-Hill Companies, Inc., All Rights Reserved.
1-15
CFS Summary:
n Operating Activities – increase/decrease in
n ST Assets – opposite effect on cash
n ST Liabilities – same effect on cash
n Investing Activities – increase/decrease in
n LT Assets – opposite effect on cash
n Financing Activities – increase/decrease in
n LT Liabilities – same effect on cash
n Equity – same effect on cash
n See example on p. 335 – indirect method
McGraw-Hill/Irwin
15
© 2008 The McGraw-Hill Companies, Inc., All Rights Reserved.
1-16
L O 11
Interpreting the Statement
of Cash Flows
A business entity should have positive cash flows
from Operating Activities. If operating activities do
not generate cash, the entity must look to outside
parties for funds to meet its day-to-day activities.
This could include selling off assets (Investing
Activities) or issuing new debt or issuing new
stock (Financing Activities) to obtain cash to pay
for day to day activities of the organization.
McGraw-Hill/Irwin
16 9-16
© 2008 The McGraw-Hill Companies, Inc., All Rights Reserved.
1 Using the following information for 2020, calculate the net cash provided by
Operating Activities.
Net income
Depreciation & amortization expense
Decrease in Accts Receivable
Decrease in Inventory
Increase in Office Supplies
Increase in Other ST Liabilities
Decrease in Accts Payable
$
$
$
$
$
$
$
300,000
85,000
25,000
65,000
40,000
35,000
70,000
ANSWER:
Net income
Depreciation & amortization expense
Decrease in Accts Receivable
Decrease in Inventory
Increase in Office Supplies
Increase in Other ST Liabilities
Decrease in Accts Payable
$
$
$
$
$
$
$
300,000
85,000
25,000
65,000
(40,000)
35,000
(70,000)
Net cash provided by Oper. Act.
$
400,000
2 Using the following information for 2020, calculate the net cash provided by
Investing Activities.
Purchase of land
Purchase of equipment
Proceeds from sale of building
Purchase of vehicles
Purchase of computers
Proceeds from sale of LT investments
Proceeds from sale of natural resources
$
$
$
$
$
$
$
1,000,000
250,000
4,000,000
150,000
30,000
920,000
160,000
ANSWER:
Purchase of land
Purchase of equipment
Proceeds from sale of building
Purchase of vehicles
Purchase of computers
Proceeds from sale of LT investments
Proceeds from sale of natural resources
$
$
$
$
$
$
$
(1,000,000)
(250,000)
4,000,000
(150,000)
(30,000)
920,000
160,000
Net cash provided by Investing Act.
$
3,650,000
3 Using the following information for 2020, calculate the net cash provided by
Financing Activities.
Proceeds from issuance of LT bonds payable
$
4,000,000
Payment on LT bonds payable
Proceeds from issuance of LT notes payable
Payment on LT notes payable
Proceeds from issuance of com. stock
Purchase of treasury stock
Payment of dividends on com stock
$
$
$
$
$
$
250,000
3,000,000
375,000
2,000,000
500,000
300,000
ANSWER:
Proceeds from issuance of LT bonds payable
Payment on LT bonds payable
Proceeds from issuance of LT notes payable
Payment on LT notes payable
Proceeds from issuance of com. stock
Purchase of treasury stock
Payment of dividends on com stock
$
$
$
$
$
$
$
4,000,000
(250,000)
3,000,000
(375,000)
2,000,000
(500,000)
(300,000)
Net cash provided by Financing Act.
$
7,575,000
4 Using the info from the above 3 problems, create a Cash Flow Statement
for the year ended 12/31/20. Beginning cash on 1/1/20 was $4,375,000.
ANSWER:
Cash Flows from Operating Activities:
Net income
Depreciation & amortization expense
Decrease in Accts Receivable
Decrease in Inventory
Increase in Office Supplies
Increase in Other ST Liabilities
Decrease in Accts Payable
$
$
$
$
$
$
$
300,000
85,000
25,000
65,000
(40,000)
35,000
(70,000)
Net cash provided by Oper. Act.
$
400,000
Cash Flows from Investing Activities:
Purchase of land
Purchase of equipment
Proceeds from sale of building
Purchase of vehicles
Purchase of computers
Proceeds from sale of LT investments
Proceeds from sale of natural resources
$
$
$
$
$
$
$
(1,000,000)
(250,000)
4,000,000
(150,000)
(30,000)
920,000
160,000
Net cash provided by Investing Act.
$
3,650,000
Cash Flows from Financing Activities:
Proceeds from issuance of LT bonds payable
Payment on LT bonds payable
$
$
4,000,000
(250,000)
Proceeds from issuance of LT notes payable
Payment on LT notes payable
Proceeds from issuance of com. stock
Purchase of treasury stock
Payment of dividends on com stock
$
$
$
$
$
3,000,000
(375,000)
2,000,000
(500,000)
(300,000)
Net cash provided by Financing Act.
$
7,575,000
Increase (decrease) in Cash
Beg. Cash Balance 1/1/20
End. Cash Balance 12/31/20
$
$
$
11,625,000
4,375,000
16,000,000