Hello I really need some help creating a statement of cashfl

Hello, I really need some help creating a statement of cashflows. I have two balance sheets, one from February and one from March, and I\'m having difficulty creating a statement of cash flows for the business, Grandpa\'s Cough Inc..

The Balance Sheet for February:

Assets: Cash (16684), Accounts Receivable (20,000), Allowance for Doubtful Accounts (-4,000), Inventory (50,000), Prepaid Insurance (1,400), Prepaid Rent (3,300), Office Equipment (2,400), Mixing Barrels (7,200), Factory Equipment (21,600), Less: Accumulated Depreciation (-8,940)

Liabilities: Accounts Payable (20,000), Income Taxes Payable (12,000), Interest Payable (44), Current Portion of Long-Term Debt (1,600), Notes payable (16,000), Retained Earnings (40,000), Common Stock (20,000)

The Balance Sheet for March:

Assets: Cash (70,129), Accounts Receivable (75,000), Allowance for Doubtful Accounts (-15,000), Inventory (74,400), Prepaid Insurance (8,750), Prepaid Rent (4,450), Prepaid Advertising - this is a new account - (9,000), Office Equipment (8,160), Mixing Barrels (10,200), Factory Equipment (25,200), Less: Accumulated Depreciation (-9,895)

Liabilities: Accounts Payable (72,000), Income Taxes Payable (32,384), Interest Payable (88), Current Portion of Long-Term Debt (0), Notes Payable (17,600), Retained Earnings (87,562), Common Stock (50,760).

Other possibly important accounts: Net Income for March (47, 562), Depreciation Expense (955), Bad debt expense (26, 000).

There was no sale of any assets during the period!

Thank you, in advance, for your help. :)

Solution

Statement of Cash Flows Particulars March Cash flows from operating activities Profit before taxation        47,562 Adjustments for: Depreciation             955 Working capital changes: (Increase) / Decrease in trade and other receivables      (44,000) (Increase) / Decrease in prepaid insurance        (7,350) (Increase) / Decrease in prepaid rent        (1,150) (Increase) / Decrease in prepaid advertising        (9,000) (Increase) / (Decrease) in inventories      (24,400) Increase / (Decrease) in trade payables        52,000 Increase / (Decrease) in income tax payable        20,384 Increase / (Decrease) in interest payable               44 Cash generated from operations        35,045 Interest paid Income taxes paid Dividends paid Net cash from operating activities        35,045 Cash flows from investing activities Business acquisitions, net of cash acquired               -   Purchase of property, plant and equipment      (12,360) Proceeds from sale of equipment               -   Acquisition of portfolio investments               -   Investment income               -   Net cash used in investing activities      (12,360) Cash flows from financing activities Proceeds from issue of share capital        30,760 Proceeds from long-term borrowings          1,600 Payment of long-term borrowings        (1,600) Net cash from financing activities        30,760 Net increase in cash and cash equivalents        53,445 Cash and cash equivalents at beginning of period        16,684 Cash and cash equivalents at end of period        70,129
Hello, I really need some help creating a statement of cashflows. I have two balance sheets, one from February and one from March, and I\'m having difficulty cr

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site