Question

In: Accounting

Account June 30 2020 June 30 2019 $ $ Cash and cash equivalents 95,800 64,000 Debtors...

Account

June 30 2020

June 30 2019

$

$

Cash and cash equivalents

95,800

64,000

Debtors

231,600

157,200

Inventory

96,720

104,400

Plant and equipment

100,000

75,000

Accumulated depreciation – plant and equipment

(40,000)

(29,000)

Total assets

484 120

371,600

Creditors

71,000

74,400

Accrued expenses

30,000

33,000

Long-term loan

100,000

50,000

Capital and reserves

283,120

214,200

Total liabilities and owners equity

484 120

371,600

Sales

440,000

Less: Cost of goods sold

296,000

Gross profit

144,000

Operating expenses (including depreciation)

84,000

Net profit

60,000

Note: 1. No plant and equipment was sold during the year.

2. Dividends of $20,000 in cash were paid during the year.

3. All sales are on credit.

REQUIRED:

Prepare a statement of cash flows for the year ended 30 June 2020 using the direct method.

Triple Threat

Statement of Cash Flows for the year ended 30 June 2020

Cash flows from operating activities

Cash flows from investing activities

Cash flows from financing activities

Cash at end of the year

Solutions

Expert Solution

Cash flow statement : This statement is prepared by an organisation to evaluate fluctuation of cash in organisation, which will be done by two types

1.Cash inflow.

2.Cash outflow.

Whenever cash comes in organisation it is called Cash inflow alternatively Cash outflow means outgoing of cash from the organisation.

Cash flow statement can be prepared by two methods-

1. Direct method - Relates to business of orgainsation

2. Indirect methods - calculation will be done by using non business transaction.

Further we can devide cash flow statement into three sub categories as follows

1. Cash flow from operating activities

2. Cash flow from Investing activities

3. Cash flow from Financing activities

Step by step guide for preparation of cash flow statement :

Step:1 First Calculate Net profit before interest and tax and extra-ordinary items(if any)

Step:2 Calculate cash flow from operating activities and add it to net profit calculated above.

Step:3 Do adjustment for tax paid and interset(on short term borrowing) and deduct from cash flow from operating activities calculated above.

Step:4 Calculate cash flow from investing activities i.e. change in assets of organisation ( purchase of a asset to be deducted and sale of a asset to be added)

Step:5 Calculate Cash flow from financing activities i,e, change in liability side of balance sheet.

Step:5 Add all activities and this is Cash flow from all activities

Step:6 Add cash balance in the beginning of financial year.

Step:7 Check if the addition of step 5 and step 6 match with Closing balnace at the end of the financial year.

Now coming to the answer of your question

Cash flow statement for the year ending 30 june 2020

Notes to accounts :

1. Calculation of collection from debtors

Opening balance 157200

Add: Sales 440000

Less: Closing balance (231600)

Collection from debtors 365600

2.Calculation of  Payment to Creditors

Purchase = Closing stock + Cost of goods sold - opening stock

Purchase = 104400+296000-96720 = 303680

Opening balance of Creditors 74400

Add: Purchases   303680

Less Closing balance of Creditors (71000)

Payment to Creditors 307080

3.Calculation of depreciation of current year

Closing balance of accumulated depreciation 40000

Opening balance of accumulated depreciation(29000)

Depreciation of current year 11000

4. Calculation of Cash Operating expenses of current year

Total operating expenses 84000

Less : Depreciation of current year (11000)

Cash operating expenses 73000

5. Calculation of operating expenses paid during the year

Opening balance of operating exps. 33000

Add: Cash operating expenses current year   73000

Less: Closing balance of operating exps (30000)

Operating expenses paid during the year 76000

Particulars

Amount

Amount

(A) Cash flow from Operating Activities

Net Profit before tax and extra ordinary items

Adjustment For Business transactions

Collection from Debtors

Payment to Creditors

Payment of operating expenses

60000

365600

(307080)

(76000)

Net Cash Generated from operating activities

42520

42520

(B) Cash flow from Investing Activities

Purchase of plant and machinery (75000-10000) – (29000-40000)

(14000)

Net Cash Generated from Investing activities

(14000)

(14000)

(C) Cash flow from financing Activities

Long term loan taken (50000-100000)

Dividend paid

Issue of shares

50000

(20000)

(26720)

Net Cash Generated from Financing activities

3280

Net Cash Generated from all activities

31800

Add: Cash in the beginning

64000

Cash at the end

95800


Related Solutions

The balances in the accounts of Maybe Ltd at 30 June 2019 and 30 June 2020...
The balances in the accounts of Maybe Ltd at 30 June 2019 and 30 June 2020 are: 30th June 2020 ‘000 30th June 2019 ‘000 Sales (all on credit) 300 420 Cost of Goods Sold 156 132 Doubtful Debts expense 30 36 Interest Expense 24 36 Salaries 36 30 Depreciation 12 18 Cash 172.80 166.80 Inventory 216 192 Accounts Receivable 324 300 Allowance for Doubtful Debts 36 42 Land 180 180 Plant 120 108 Accumulated Depreciation 24 36 Bank Overdraft...
The balances in the accounts of Maybe Ltd at 30 June 2019 and 30 June 2020...
The balances in the accounts of Maybe Ltd at 30 June 2019 and 30 June 2020 are: 2020 ‘000 2019 ‘000 Sales (all on credit) 300 420 Cost of Goods Sold 156 132 Doubtful Debts expense 30 36 Interest Expense 24 36 Salaries 36 30 Depreciation 12 18 Cash 172.80 166.80 Inventory 216 192 Accounts Receivable 324 300 Allowance for Doubtful Debts 36 42 Land 180 180 Plant 120 108 Accumulated Depreciation 24 36 Bank Overdraft 24 22.80 Accounts Payable...
The balances in the accounts of Maybe Ltd at 30 June 2019 and 30 June 2020...
The balances in the accounts of Maybe Ltd at 30 June 2019 and 30 June 2020 are: 30th JUNE 2020 ‘000 30th JUNE 2019 ‘000 Sales (all on credit) 300 420 Cost of Goods Sold 156 132 Doubtful Debts expense 30 36 Interest Expense 24 36 Salaries 36 30 Depreciation 12 18 Cash 172.80 166.80 Inventory 216 192 Accounts Receivable 324 300 Allowance for Doubtful Debts 36 42 Land 180 180 Plant 120 108 Accumulated Depreciation 24 36 Bank Overdraft...
The cash account of Concord Corporation shows a ledger balance of $3,968.70 on June 30, 2020....
The cash account of Concord Corporation shows a ledger balance of $3,968.70 on June 30, 2020. The bank statement as at that date shows a balance of $4,128. When the statement was compared with the cash records, the following facts were determined: 1. There were bank service charges for June of $30. 2. A bank memo stated that a note from Bao Dai for $880 and interest of $34 had been collected on June 29, and the bank had made...
Simmons Corp Balance Sheet As of December 31, 2019 and June 30, 2020 Assets 2019 2020...
Simmons Corp Balance Sheet As of December 31, 2019 and June 30, 2020 Assets 2019 2020 Liabilities 2019 2020 Cash $700 Accounts payable $550 Accounts receivable 50 Salaries payable 50 Total current assets 750 Interest payable 0 Equipment 500 Total current liabs 600 Acc. depreciation (100) Notes payable 100 Equity Common stock 100 Retained earnings 350 Total assets $1,150 Total liabs and eq $1,150 During 2020 to date (June 30, 2020), Simmons had the following transactions: Provided services to customers...
Balance Sheets (in millions of dollars) 2020 2019 Assets Cash and cash equivalents $600 $495 Accounts...
Balance Sheets (in millions of dollars) 2020 2019 Assets Cash and cash equivalents $600 $495 Accounts receivable $626 $525 Inventories $285 $240 Total current assets $1,511 $1,260 Net fixed assets $1,590 $1,470 Total assets $3,101 $2,730 Liabilities and equity Accounts payable $248 $195 Accruals $195 $180 Notes payable $189 $195 Total current liabilities $632 $570 Long-term debt $356 $300 Total liabilities $987 $870 Common stock $570 $570 Retained Earnings $1,544 $1,290 Total common equity $2,114 $1,860 Total liabilities and equity...
Create Journal entries for the following: Account Balances June 30, 2016 June 30, 2017 Debits Cash...
Create Journal entries for the following: Account Balances June 30, 2016 June 30, 2017 Debits Cash $       361,700 $       880,550 Accounts Receivable           100,000           125,000 Marketable Securities (at cost)              11,700              13,000 Allowance for Change in Value                1,500                1,800 Construction in Process           168,750           405,000 Prepaid Expenses              45,000              10,000 Investments (long-term)                        -                13,500 Leased Equipment                        -                20,000 Building              30,000                        -   Deferred tax asset                5,375                2,200...
Assets 2019 2018 Amount Cash & equivalents $20,000.00 Cash & equivalents $10,000.00 Accounts Receivable $15,000.00 Accounts...
Assets 2019 2018 Amount Cash & equivalents $20,000.00 Cash & equivalents $10,000.00 Accounts Receivable $15,000.00 Accounts Receivable $25,000.00 Inventory $10,000.00 Inventory $15,000.00 Total current assets $45,000.00 Total current assets $50,000.00 Net Plant and equipment $50,000.00 Net Plant and equipment $60,000.00 Total assets $95,000.00 Total assets $110,000.00 Liabilities and equity Liabilities and equity Accounts payable $5,000.00 Accounts payable $7,000.00 Accruals $2,000.00 Accruals $3,000.00 Notes payable $10,000.00 Notes payable $5,000.00 Total current liabilities $17,000.00 Total current liabilities $15,000.00 Long term debts $25,000.00...
Epicenter Laundry UNADJUSTED TRIAL BALANCE June 30, 2019 ACCOUNT TITLE DEBIT CREDIT 1 Cash 11,000.00 2...
Epicenter Laundry UNADJUSTED TRIAL BALANCE June 30, 2019 ACCOUNT TITLE DEBIT CREDIT 1 Cash 11,000.00 2 Laundry Supplies 21,500.00 3 Prepaid Insurance 9,600.00 4 Laundry Equipment 232,600.00 5 Accumulated Depreciation 125,400.00 6 Accounts Payable 11,800.00 7 Sophie Perez, Capital 105,600.00 8 Sophie Perez, Drawing 10,000.00 9 Laundry Revenue 232,200.00 10 Wages Expense 125,200.00 11 Rent Expense 40,000.00 12 Utilities Expense 19,700.00 13 Miscellaneous Expense 5,400.00 14 Totals 475,000.00 475,000.00 The data needed to determine year-end adjustments are as follows: •...
The inventory ledger account balance on June 30, 2019, was $7,650, and net realisable value for...
The inventory ledger account balance on June 30, 2019, was $7,650, and net realisable value for each product line exceeded the cost. The cost of inventory on hand June 30, 2019, was determined by physical count, however, it was only $7,578. In investigating the reasons for the discrepancy, Beyer Ltd discovered the following. Goods costing $87 were sold for $110 (GST Inclusive) on June 26, 2019, on FOB destination (seller pays shipping) shipping terms. The goods were in transit on...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT