Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Prepare the cash flow statement in both indirect and direct methods. Make sure all the boxes are filled. Thank you! Statement of Cash Flows Direct
Prepare the cash flow statement in both indirect and direct methods. Make sure all the boxes are filled. Thank you!
Statement of Cash Flows Direct Method Student Name: 12/31/2015, Cash Balance Cash from Operations: Cash from customers Total Cash Received from Operation Cash Used for Inventory purchase Cash Paid for Wages Cash Paid for rent Cash Paid for other operating Cash Paid for taxes Cash Paid for Interest on N/P Total Cash Used in Operations Net cash from Operations Cash for Investing Cash from Selling AFS Investment Cash from Selling P P & E Total Cash Received Investing Cash Used to Purchase AFS Cash Used to Purchase PP& E Total Cash Used in Investing Net cash to Investing Cash from financing: Cash recieved issuing common stock Total Cash received from Financing Cash used to Pay N/P principal Cash used to Pay dividend Cash to purchase treasury stock Total Cash Used Financing Net cash From Financing 938.70 (470.20) (195.00) (83.10) (11.80) (55.00) (2.00) 29.00 115.00 (0.00) (550.00) 265.00 (8.00) (2.00) (5.80) 12/31/2016, Cash Balance Working Cash receipts from customers Sales revenue Add : Beginning Net Account Recievable Less :Ending Net Account Recievable Less : Bad Debt Expenses Cash receipts from customers Cash paid to suppliers 970.00 113.80 140.10 5.00 938.70 Cost of Goods Sold Add: Ending Inventory Add : Beginning Account Payable Less :Ending Account payable Cash Used for Inventory purchase 439.00 113.50 90.10 462.40 60.40 52.60 470.20 Cash Payment of Wages Wages Add : Beginning Salary Payable Less :Ending Salary Payable Cash Payment of Wages 200.50 22.80 28.30 195.00 Cash Payment of Rent Rent Add : Ending Prepaid Rent Less :Beginning Prepaid Rent Cash Payment of Rent 118.60 45.60 81.10 83.10 Less : Beginning Inventory Purchases Cash Payment of Other Operating Other Operating Expenses Add : Beginning other Operating Payable Less :Ending other Operating Payable Cash Payment of Other Operating 12.90 4.00 5.10 11.80 Cash Payment of Tax Tax expense Add: Beginning Deferred tax Liability Less: Ending Deferred tax Liability Current Tax Liability Add : Beginning Tax Payable Less :Ending Tax Payable Cash Payment ofTax 40.00 14.00 4.00 50.00 5.00 55.00 Payment of Dividend Beginning Retained Earning Add: Net Income Less: Ending Retained Earning Payment of Dividend Cash from Selling AFS Investment Gain on Sale of AFS Less : Unrealised Gain on AFS Add: Cost of AFS 600.00 86.00 684.00 2.00 9.00 6.00 3.00 26.00 Cash from Selling AFS Investment Cash from Selling P P & E Cost of PP E Sold Less : Accumulated Depreciation of Equipment sold (800+100-660) Book Value of PP & E sold Add: Gain on Sale of Plant Cash from Selling P P & E Cash Used to Purchase PP& E Ending Cost of PP& E Add: Cost of P P & E Less : PPE Purchase using common stock Less : Beginning Cost of PP & E Cash Used to Purchase PP& E Cash used to Pay N/P principal Beginning N/P Less: Ending N/P Cash used to Pay N/P principal Cash recieved issuing common stock Ending Common Stock Add : Ending APIC Less : Beginning Common Stock Less : Beginning APIC Less : Common Stock issued for PP & E Cash recieved issuing common stock Statement of Cash Flows Indirect Method Student Name: 2016 Net Income Cash from Operations: Depreciation Expenses Gain on Sale of PP& E Gain on Sale of AFS Changes in Operating Asset Increase in Account Receivable Increase in Inventory Decrease in prepaid Rent Changes in operating Liability Decrease in Accounts Payable Increase in Wages Payable Increase in Operating Payable Decrease in tax payable 29.00 330.00 240.00 90.00 25.00 115.00 2,000.00 330.00 130.00 1,650.00 550.00 40.00 32.00 8.00 91.00 875.40 50.00 521.40 130.00 265.00 100.00 35.50 5.50 1.10 Decrease in deferred tax liability Total Increase in Cash Total Decrease in cash Net cash from Operations 228.10 162.60 938.70 (817.10) 121.60 144.00 (550.00) (406.00) 265.00 (15.80) 249.20 127.40 86.00 (25.00) (9.00) (26.30) (23.40) (7.80) (5.00) (10.00) (106.50) 121.60 Statement of Cash Flows Direct Method Student Name: 12/31/2015, Cash Balance Cash from Operations: Cash from customers Total Cash Received from Operation Cash Used for Inventory purchase Cash Paid for Wages Cash Paid for rent Cash Paid for other operating Cash Paid for taxes Cash Paid for Interest on N/P Total Cash Used in Operations Net cash from Operations Cash for Investing Cash from Selling AFS Investment Cash from Selling P P & E Total Cash Received Investing Cash Used to Purchase AFS Cash Used to Purchase PP& E Total Cash Used in Investing Net cash to Investing Cash from financing: Cash recieved issuing common stock Total Cash received from Financing Cash used to Pay N/P principal Cash used to Pay dividend Cash to purchase treasury stock Total Cash Used Financing Net cash From Financing 938.70 (470.20) (195.00) (83.10) (11.80) (55.00) (2.00) 29.00 115.00 (0.00) (550.00) 265.00 (8.00) (2.00) (5.80) 12/31/2016, Cash Balance Working Cash receipts from customers Sales revenue Add : Beginning Net Account Recievable Less :Ending Net Account Recievable Less : Bad Debt Expenses Cash receipts from customers Cash paid to suppliers 970.00 113.80 140.10 5.00 938.70 Cost of Goods Sold Add: Ending Inventory Add : Beginning Account Payable Less :Ending Account payable Cash Used for Inventory purchase 439.00 113.50 90.10 462.40 60.40 52.60 470.20 Cash Payment of Wages Wages Add : Beginning Salary Payable Less :Ending Salary Payable Cash Payment of Wages 200.50 22.80 28.30 195.00 Cash Payment of Rent Rent Add : Ending Prepaid Rent Less :Beginning Prepaid Rent Cash Payment of Rent 118.60 45.60 81.10 83.10 Less : Beginning Inventory Purchases Cash Payment of Other Operating Other Operating Expenses Add : Beginning other Operating Payable Less :Ending other Operating Payable Cash Payment of Other Operating 12.90 4.00 5.10 11.80 Cash Payment of Tax Tax expense Add: Beginning Deferred tax Liability Less: Ending Deferred tax Liability Current Tax Liability Add : Beginning Tax Payable Less :Ending Tax Payable Cash Payment ofTax 40.00 14.00 4.00 50.00 5.00 55.00 Payment of Dividend Beginning Retained Earning Add: Net Income Less: Ending Retained Earning Payment of Dividend Cash from Selling AFS Investment Gain on Sale of AFS Less : Unrealised Gain on AFS Add: Cost of AFS 600.00 86.00 684.00 2.00 9.00 6.00 3.00 26.00 Cash from Selling AFS Investment Cash from Selling P P & E Cost of PP E Sold Less : Accumulated Depreciation of Equipment sold (800+100-660) Book Value of PP & E sold Add: Gain on Sale of Plant Cash from Selling P P & E Cash Used to Purchase PP& E Ending Cost of PP& E Add: Cost of P P & E Less : PPE Purchase using common stock Less : Beginning Cost of PP & E Cash Used to Purchase PP& E Cash used to Pay N/P principal Beginning N/P Less: Ending N/P Cash used to Pay N/P principal Cash recieved issuing common stock Ending Common Stock Add : Ending APIC Less : Beginning Common Stock Less : Beginning APIC Less : Common Stock issued for PP & E Cash recieved issuing common stock Statement of Cash Flows Indirect Method Student Name: 2016 Net Income Cash from Operations: Depreciation Expenses Gain on Sale of PP& E Gain on Sale of AFS Changes in Operating Asset Increase in Account Receivable Increase in Inventory Decrease in prepaid Rent Changes in operating Liability Decrease in Accounts Payable Increase in Wages Payable Increase in Operating Payable Decrease in tax payable 29.00 330.00 240.00 90.00 25.00 115.00 2,000.00 330.00 130.00 1,650.00 550.00 40.00 32.00 8.00 91.00 875.40 50.00 521.40 130.00 265.00 100.00 35.50 5.50 1.10 Decrease in deferred tax liability Total Increase in Cash Total Decrease in cash Net cash from Operations 228.10 162.60 938.70 (817.10) 121.60 144.00 (550.00) (406.00) 265.00 (15.80) 249.20 127.40 86.00 (25.00) (9.00) (26.30) (23.40) (7.80) (5.00) (10.00) (106.50) 121.60Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started