Solved by Expert Tutors
Solved by Expert Tutors
Question

Hi there need to prepare cash flow statement the format is already given as excel just need to fill up missing amounts in the given excel. Balance sheet is question and the numericals are to be filled in excel.Untitled 3.png

Untitled 3.png
Prepare a cash flow statement
his task requires you to prepare a cash flow statement for Bob's Machinery for the year ended
Create a new Excel Workbook for Bob's Machinery.
Review the AASB 107 Statement of
07 Statement of Cash Flows document, as well as the balance sheet and
income statement provided to you in Bob's Machinery Information.
Save this document as Bob's Machinery Cash Flow Workbook
Balance Sheet as at 30 June 2017
30/06/2016
30/06/2017
Assets
Bank
24,000
6,00
Land
289,00
289,000
Buildings
414,000
457,000
Accumulated depreciation buildings
98,00
107,000
Plant and equipment
372,000
444,000
Accumulated depreci
189,00
Accounts receivable
166.000
04,00
Provision for doubtful debts
- 8,00
- 11,000
Inventories
231,000
197,000
1,235,000
1,290,000
Liabilities
Accounts payable
61,000
194,000
Accrued expenses
24,000
31,000
Provision for tax
52,00
61,00
Provision for dividend
50,000
50,000
8% debentures
350,000
537,000
Net assets
336,000
598,000
954,000
Equity
Share capital
584,000
809,000
General reserve
66,000
Retained profits
114,000
79,00
698,000
954,000
Income Statement for the year ended 30 June 2017
Sales Cash
72,000
Sales Credit
Cost of goods sold
2,708,000
2, 780,000
Inventories 1/7/16
Purchases
231,000
Inventories 30/6/17
1,850,000
- 197,000
1,884,00
Gross profit
896,000
Salaries
249,000
Interest on mortgage
Depreciation
46,00
Bad debts
67,000
9,000
Loss on sale of surplus plant
13,000
General expenses
345,000
Profit before income tax
729,00
Income tax expense
167,00
Profit after income tax
- 61,00C
106,00
Additional information
Plant costing $89,000 was sold for $52,000
Provision for tax was paid during the year
The dividend provided for was paid during the year
An interim dividend of $25,000 was paid on 31/12/ 16
AutoSave On
Bobs Machinery Cash Flow Template Assessment 3 - Protected View .
Home
Bishal BASNET 83 1 - 0
PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing
Share Comment
H27
Cash flows from operating activities
* | 1 M N O P Q R SC
ments to supplier
ents to employees
Payments of operating expenses
Payments of borrowing costs
t cash used in operating activities
Cash flows from investing activities
Cash for acquisition of buildings
Cash for acquisition of plant and equipment
cash used in investing ave
Cash flows from financing activities
New share capital raised
Repayment of 8% de
Net cash used in financing activities
Net increase (decrease) in cash and cash equivalents
ash equivalents at beginning of year
Cash and cash equivalents at end of year
Sheet1

Step-by-step answer

m risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce duiacinia pulvi

Bob's Machinery Cash Flow Statement.png

ng elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie cons

Bob's Machinery Cash Flow Statement.png
facilisis. Pel icitur laoreet. Nam risus ante, dapib cing elit. Nam lacinia pulvinar , dictum vi trices trices sum dolor sit amet, consectetur adipisc m risus ante, dapibus a molestie conse

Subscribe to view the full answer

Subject: Accounting, Business

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Let our 24/7 Accounting tutors help you get unstuck! Ask your first question.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes