Anya's Bookstore Year 4 - Cash Flow Statement (Direct Method) Cash Received from Customers Cash Paid to Suppliers Cash paid for Taxes Cash paid for Interest Total Cash Flow From Operations (Direct Method) Total Cash Flow From Investments Total Cash Flow From Financing Activities Starting Cash Ending Cash Total Cash Flow Total Cash Flow (Check) * Total Inventory is the sum of the Anya's purchased Inventory PLUS all the Raw Material, Work-In-Process and Finished goods i.e. her Manufacturing inventory Anya's Bookstore Year 4 - Cash Flow Statement (Indirect Method) Net Profit Adjustments for Non-Cash Items Add Back Depreciation Expense Add Back Loss on Sale of Non-Current Asset Deduct Increases in Current Assets Raw Materials Work-In-Process Finished Goods Add Decreases in Current Assets Inventory (Stock) Prepayments Subtract Decreases in Current Liabilities Unearned Revenue Add Increases in Current Liabilities Trade Creditors Total Cash Flow From Operations (Indirect Method) Proceeds from sale of Non-Current Asset Total Cash Flow From Investments Total Cash Flow From Financing Activities Starting Cash Ending Cash 26 Total Cash Flow Total Cash Flow (Check) Anya's Bookstore Year 4 - Worksheet (Assets) Assets Transaction Details Tran, No. Trans. Date Cash Inventory Raw (Stocks) Materials Work- In- Process Finished Goods Accounts Receivable Proper. Plan & Prepayments Equip. Accrued Income Opening balance Purchase 1 Direct Labour 2 Manufacturing Overhead 3 Pay employee 4 Van depreciation 5 Loss on sale of Van 5 Sell book-bags 6 Sell book-bags 6 Subscription revenue earned 7 Subscription cost of sales 7 Stock-take 8 Furniture depreciation 9 Interest Expense 10 Shop insurance 11 Transfer to Retained Earnings Closing Closing Balances Apr-15 May-15 May-30 Jun-15 Jun-30 Jun-30 Jul-20 Jul-20 Nov-01 Nov-01 Dec-31 Dec-31 Dec-31 Dec-31 19 R/E Anya's Bookstore Year 4 - Worksheet (Liabilities & Equity) Liabilities S/H Funds Tran Trans. Dividend Transaction Details Tax Accounts Bank Accrued Unearned Salary Share P&L No Date Payable Payable Payable Loan liability Revenue Payable Capital Account Opening balance Purchase 1 Apr-15 Direct Labour 2 May-15 Manufacturing Overhead 3 May-30 Pay employee 4 Jun-15 Van depreciation 5 Jun-30 Loss on sale of Van 5 Jun-30 Sell book-bags 6 6 Jul-20 Sell book-bags 6 Jul-20 Subscription revenue earned 7 Nov-01 Subscription cost of sales 7 Nov-01 Stock-take 8 Dec-31 Furniture depreciation 9 Dec-31 Interest Expense 10 Dec-31 Shop insurance 11 Dec-31 Transfer to RE Closing Closing Balances Anya's Bookstore Part D-Year 4 of Operations During the 4"year (2018) of operation, Anya plans to start manufacturing her own range of re-usable book bags which she plans to start selling. The bookstore has the following transactions: 1. April 15th: Purchased 2,000 of raw material on account, to manufacture re- usable book bags to sell. 2. May 15th. A new staff member sewed together the book bags. The employee is owed 1,500. 3. May 30th: Paid 750 cash on direct manufacturing overheads (e.g. utilities) required for making the book bags. 4. June 15th Paid the employee the 1,500 owed for making the book bags. 5. June 30th Anya decides to sell the delivery van-receiving 10,000 in cash. The depreciation charge for the six-months of June is 750. The delivery van had a total accumulated depreciation of 2,250 at the time of its sale. 6. July 20th: Sold 10 book bags for 15 cash each. The cost of manufacturing the book bags was 6 each. 7. 31st October: Anya has completed the subscription service from November 1st Year 3 8. December 31st: A physical count of the manufacturing inventory indicates that Anya has 600 of raw material on hand, 500 of work-in-process and has completed manufacturing 3,090 worth of book bags. 9. December 31st: Provide depreciation 1,000 on storage furniture 10. December 31st: Paid interest on the bank loan of 3,000 11. December 31st: Record the portion of the prepaid shop building insurance used in Year 4 (paid July 1st Year 3) Record these transactions in the Year 4 worksheet provided below. Prepare the income statement, balance sheet and cash flow statement. Anya's Bookstore Year 4 - Cash Flow Statement (Direct Method) Cash Received from Customers Cash Paid to Suppliers Cash paid for Taxes Cash paid for Interest Total Cash Flow From Operations (Direct Method) Total Cash Flow From Investments Total Cash Flow From Financing Activities Starting Cash Ending Cash Total Cash Flow Total Cash Flow (Check) * Total Inventory is the sum of the Anya's purchased Inventory PLUS all the Raw Material, Work-In-Process and Finished goods i.e. her Manufacturing inventory Anya's Bookstore Year 4 - Cash Flow Statement (Indirect Method) Net Profit Adjustments for Non-Cash Items Add Back Depreciation Expense Add Back Loss on Sale of Non-Current Asset Deduct Increases in Current Assets Raw Materials Work-In-Process Finished Goods Add Decreases in Current Assets Inventory (Stock) Prepayments Subtract Decreases in Current Liabilities Unearned Revenue Add Increases in Current Liabilities Trade Creditors Total Cash Flow From Operations (Indirect Method) Proceeds from sale of Non-Current Asset Total Cash Flow From Investments Total Cash Flow From Financing Activities Starting Cash Ending Cash 26 Total Cash Flow Total Cash Flow (Check) Anya's Bookstore Year 4 - Worksheet (Assets) Assets Transaction Details Tran, No. Trans. Date Cash Inventory Raw (Stocks) Materials Work- In- Process Finished Goods Accounts Receivable Proper. Plan & Prepayments Equip. Accrued Income Opening balance Purchase 1 Direct Labour 2 Manufacturing Overhead 3 Pay employee 4 Van depreciation 5 Loss on sale of Van 5 Sell book-bags 6 Sell book-bags 6 Subscription revenue earned 7 Subscription cost of sales 7 Stock-take 8 Furniture depreciation 9 Interest Expense 10 Shop insurance 11 Transfer to Retained Earnings Closing Closing Balances Apr-15 May-15 May-30 Jun-15 Jun-30 Jun-30 Jul-20 Jul-20 Nov-01 Nov-01 Dec-31 Dec-31 Dec-31 Dec-31 19 R/E Anya's Bookstore Year 4 - Worksheet (Liabilities & Equity) Liabilities S/H Funds Tran Trans. Dividend Transaction Details Tax Accounts Bank Accrued Unearned Salary Share P&L No Date Payable Payable Payable Loan liability Revenue Payable Capital Account Opening balance Purchase 1 Apr-15 Direct Labour 2 May-15 Manufacturing Overhead 3 May-30 Pay employee 4 Jun-15 Van depreciation 5 Jun-30 Loss on sale of Van 5 Jun-30 Sell book-bags 6 6 Jul-20 Sell book-bags 6 Jul-20 Subscription revenue earned 7 Nov-01 Subscription cost of sales 7 Nov-01 Stock-take 8 Dec-31 Furniture depreciation 9 Dec-31 Interest Expense 10 Dec-31 Shop insurance 11 Dec-31 Transfer to RE Closing Closing Balances Anya's Bookstore Part D-Year 4 of Operations During the 4"year (2018) of operation, Anya plans to start manufacturing her own range of re-usable book bags which she plans to start selling. The bookstore has the following transactions: 1. April 15th: Purchased 2,000 of raw material on account, to manufacture re- usable book bags to sell. 2. May 15th. A new staff member sewed together the book bags. The employee is owed 1,500. 3. May 30th: Paid 750 cash on direct manufacturing overheads (e.g. utilities) required for making the book bags. 4. June 15th Paid the employee the 1,500 owed for making the book bags. 5. June 30th Anya decides to sell the delivery van-receiving 10,000 in cash. The depreciation charge for the six-months of June is 750. The delivery van had a total accumulated depreciation of 2,250 at the time of its sale. 6. July 20th: Sold 10 book bags for 15 cash each. The cost of manufacturing the book bags was 6 each. 7. 31st October: Anya has completed the subscription service from November 1st Year 3 8. December 31st: A physical count of the manufacturing inventory indicates that Anya has 600 of raw material on hand, 500 of work-in-process and has completed manufacturing 3,090 worth of book bags. 9. December 31st: Provide depreciation 1,000 on storage furniture 10. December 31st: Paid interest on the bank loan of 3,000 11. December 31st: Record the portion of the prepaid shop building insurance used in Year 4 (paid July 1st Year 3) Record these transactions in the Year 4 worksheet provided below. Prepare the income statement, balance sheet and cash flow statement