cash flow statement preparation

bkaneh
Mod_04_Assignment_Template.xlsx
Home>Business & Finance homework help>Accounting homework help>cash flow statement preparation

M4

Module 4 :
Amy's Fashions ended the year 20XX with the following balance:
Amy's Fashions Amy's Fashions
Comparative Balance Sheet Comparative Income Statement
December 31, 20XX For the Year Ended 20XX
20XX 20WW Increase (Decrease) 20XX
ASSETS Revenues:
Current Assets: sales 1,100,000
Cash and cash equivalents 140,350 95,900 44,450 Cost of Goods Sold 710,000
Accounts receivable 95,300 102,300 -7,000 Gross Profit 390,000
Inventory 165,200 157,900 7,300 Operating Expenses:
Prepaid expenses 6,240 5,860 380 Depreciation 23,500
Investments (long term) 35,700 84,700 -49,000 Patent Amortization 7,000
Plant Assets: Other operating expenses 196,000
Land 75,000 90,000 -15,000 Total Operating Expenses: 226,500
Buildings (net) 303,700 201,700 102,000 Income from operations 163,500
Equipment, net 279,800 290,300 -10,500 Other Income:
Patents 58,000 65,000 -7,000 Gain on sale of investments 11,000
Total Assets 1,159,290 1,093,660 65,630 Other Expenses:
Interest Expense 26,000 -15,000
LIABILITIES Income before income tax 148,500
Current Liabilities: Income tax expense 50,000
Accounts Payable 43,500 46,700 -3,200 Net Income 98,500
Accrued Liabilities 14,000 12,500 1,500
Income Taxes Payable 7,900 8,400 -500
Dividends Payable 14,000 10,000 4,000
Long Term Liabilities: 0
Mortgage note payable 40,000 40,000
Bonds Payable 150,000 250,000 -100,000
Total Liabilities 269,400 327,600 -58,200
STOCKHOLDER'S EQUITY 0
Common Stock 450,000 375,000 75,000
Additional paid in capital-common 66,250 41,250 25,000
Retained Earnings 373,640 349,810 23,830
Total Stockholders' Equity 889,890 766,060 123,830
Total Liabilities and Stockholders' Equity 1,159,290 1,093,660 65,630
An examination of the accounting records revealed the following for 2010:
Land costing $15,000 was sold for $15,000
A mortgage note was issued for $40,000
A building costing $115,000 was constructed
2,500 shares of common stock were issued at 40 in exchange for the bonds payable
Cash dividends declared were $74,670
1 Using the indirect method, prepare the statement of cash flows for Amy's Fashions for the year ended 20XX.
Amy's Fashions
Statement of Cash Flows-Indirect Method
For the Year Ended 20XX
Cash Flows From Operating Activities:
Cash Flows From Investing Activities:
Cash Flows From Financing Activities:
Schedule of noncash investing and financing activities:

worksheet

20WW Debit Credit 20XX
ASSETS
Cash and cash equivalents 95,900 140,350
Accounts receivable 102,300 95,300
Inventory 157,900 165,200
Prepaid expenses 5,860 6,240
Investments (long term) 84,700 35,700
Land 90,000 75,000
Buildings (net) 201,700 303,700
Equipment, net 290,300 279,800
Patents 65,000 58,000
Total Assets 1,093,660 1,159,290
LIABILITIES
Accounts Payable 46,700 43,500
Accrued Liabilities 12,500 14,000
Income Taxes Payable 8,400 7,900
Dividends Payable 10,000 14,000
Mortgage note payable 40,000
Bonds Payable 250,000 150,000
Total Liabilities 327,600 269,400
STOCKHOLDER'S EQUITY
Common Stock 375,000 450,000
Additional paid in capital-common 41,250 66,250
Retained Earnings 349,810 373,640
1,093,660 1,159,290
Cash Flows From Operating Activities:
Net Income
Depreciation
Amortization
Gain on sale of investments
Decrease in A/R
Increase in Inventory
Increase in PPD Expenses
Decrease in A/P
Increase in Accrued Expenses
Decrease in Taxes Payable
Cash Flows From Investing Activities:
Sale of Investments
Sale of Land
cash paid for construction on building
Cash Flows From Financing Activities:
Cash received from issuing mortgage note payable
cash paid for dividends
Noncash investing and financing activities:
issue common stock to retire bonds
Increases in cash