Case Study $3$

One of the corporate clients, Bronco Ltd$,$ provided you with the attached Cash Book extract $($see below$).$ As they are not too familiar with the AASB $107$ Statement of Cash Flows, they have requested you to prepare the Statement to comply with the requirements.

Cash Book of Bronco Ltd for the year ended $20$X$8.$

Opening balance $65,000$ Accounts payable $242,000$

Accounts receivable $622,000$ Bills payable $($suppliers$)15,000$

Commission received $3,000$ Motor vehicles $80,000$

Plant & equipment $9,000$ Salaries & wages $220,000$

Share capital $150,000$ Taxation payable $28,000$

Office furniture $12,000$ Provision for annual leave $13,000$

Bills receivable $($customers$)10,000$ Petty Cash $500$

Interest income $1,500$ Other operating expenses $126,000$

Deposits at call $50,000$

Dividend payable $25,500$

Closing balance $72,500$

$$872,500$ $$872,500$

Additional Information:

The petty cash float was $$1,500$ on $1$ July $20$X$7.$ There were no deposits at call on $1$ July $20$X$7.$

Required:

In accordance with the accounting standard AASB $107,$ prepare a cashflow statement including a note for the reconciliation of cash $($Note $2)$ for Bronco Limited for the period ended $30$ June $20$X$8$ Casestudy$3$:$$Cash Flow Statement

Format adapted from textbook Chapter $7-$ Page $258$

$****$ Modify contents as required $*****$

Bronco Limited

Statement of Cash Flows

For Financial Year Ended $30$ June $20$X$8$

Inflows $/($Outflows$)$ Inflows $/($Outflows$)$

Cash flows from operating activities

Receipts from customers

Payments to suppliers

Payments to employees

Interest received

Interest paid

Dividends received

Operating expenses paid

Income tax paid

GST Collected

Net cash from operating activities $($Note $1)$ XXX

Cash flows from investing activities

Payment for purchase of plant and equipment

Proceeds from sale of plant & equipment

Purchase of equity investments

Net cash used in investing activities XXX

Cash flows from financing activities

Proceeds from borrowings

Repayments of borrowings

Proceeds from issue of shares

Payments under share buybacks

Equity dividends paid

Net Cash provided by financing activities XXX

Net increase $($decrease$)$ in cash and cash equivalent XXXX

Cash and cash equivalents at beginning of the year XXXX

Cash and cash equivalents at the end of the year $($Note $2)$ XXXXX

Note $2-$ Reconciliation of cash and cash equivalent

Cash at bank

Deposits at call

Petty cash on hand

Cash and cash equivalents at the end of the year XXXXX if you can break it down clearly and show me where each number goes in tha exact table format that would be awesome