complete the following 5 exercises below in either Excel or a word document (but must be single document). You must show your work where appropriate (leaving the calculations within Excel cells is acceptable).
1. Critical Thinking Question:
Answer the following questions:
Why are noncash transactions, such as the exchange of common stock for a building for example, included on a statement of cash flows? How are these noncash transactions disclosed?
2. Classification of activities
Classify each of the following transactions as arising from an operating (O), investing (I), financing (F), or noncash investing/financing (N) activity.
a. ________ Received $80,000 from the sale of land.
b. ________ Received $3,200 from cash sales.
c. ________ Paid a $5,000 dividend.
d. ________ Purchased $8,800 of merchandise for cash.
e. ________ Received $100,000 from the issuance of common stock.
f. ________ Paid $1,200 of interest on a note payable.
g. ________ Acquired a new laser printer by paying $650.
h. ________ Acquired a $400,000 building by signing a $400,000 mortgage note.
3. Overview of direct and indirect methods
Evaluate the comments that follow as being True or False. If the comment is false, briefly explain why.
a. Both the direct and indirect methods will produce the same cash flow from operating activities.
b. Depreciation expense is added back to net income when the indirect method is used.
c. One of the advantages of using the direct method rather than the indirect method is that larger cash flows from financing activities will be reported.
d. The cash paid to suppliers is normally disclosed on the statement of cash flows when the indirect method of statement preparation is employed.
e. The dollar change in the Merchandise Inventory account appears on the statement of cash flows only when the direct method of statement preparation is used.
4. Equipment transaction and cash flow reporting
Dec. 31, 20X4 Dec. 31, 20X3
Property, Plant & Equipment:
Land
$94,000
$94,000
Equipment 652,000 527,000
Less: Accumulated depreciation -316,000 -341,000
New equipment purchased during 20x4 totaled $280,000. The 20x4 income statement disclosed equipment depreciation expense of $41,000 and a $9,000 loss on the sale of equipment.
a. Determine the cost and accumulated depreciation of the equipment sold during 20X4.
b. Determine the selling price of the equipment sold.
c. Show how the sale of equipment would appear on a statement of cash flows prepared by using the indirect method.
5. Cash flow information: Direct and indirect methods
The comparative year-end balance sheets of Sign Graphics, Inc., revealed the following activity in the company's current accounts:
20X5 20X4 Increase / Decrease)
Current assets
Cash $55,400 $35,200 $20,200
Accounts receivable (net) 83,800 88,000 -4,200
Inventory 243,400 233,800 9,600
Prepaid expenses 25,400 24,200 1,200
Current liabilities
Accounts payable $123,600 $140,600 ($17,000)
Taxes payable 43,600 49,200 -5,600
Interest payable 9,000 6,400 2,600
Accrued liabilities 38,800 60,400 -21,600
Note payable 44,000 - 44,000
The accounts payable were for the purchase of merchandise. Prepaid expenses and accrued liabilities relate to the firm's selling and administrative expenses. The company's condensed income statement follows.
SIGN GRAPHICS INC.
Income Statement
for the Year Ended December 31, 20x5
Sales $713,800
Less: Cost of goods sold 323,000
Gross profit $390,800
Less: Selling & administrative expenses $186,000
Depreciation expense 17,000
Interest expense 27,000 230,000
Add: gain on sale of land $160,800
21,800
Income before taxes $182,600
Income taxes 36,800
Net income $145,800
Other data:
1. Long-term investments were purchased for cash at a cost of $74,600.
2. Cash proceeds from the sale of land totaled $76,200.
3. Store equipment of $44,000 was purchased by signing a short-term note payable. Also, a $150,000 telecommunications system was acquired by issuing 3,000 shares of preferred stock.
4. A long-term note of $49,400 was repaid.
5. Twenty thousand shares of common stock were issued at $5.19 per share.
6. The company paid cash dividends amounting to $128,600.
Instructions:
a. Prepare the operating activities section of the company's statement of cash flows, assuming use of:
1. The direct method.
2. The indirect method.
b. Prepare the investing and financing activities sections of the statement of cash flows.