QUESTION FOUR [25]
Study the Statement of Cash Flows provided below and answer the following questions:
4.1 Calculate the:
4.1.1 Dividends paid. (3)
4.1.2 Cash balance on 31 December 2016. Is the balance favourable or unfavourable? (4)
4.2 Did the company increase its loan or did it make a loan repayment?
Show your calculations. (4)
4.3 Of what significance are the details of Cable Limited’s investing activities to potential
investors? (5)
4.4 Provide an interpretation of the Statement of Cash Flows of Cable Limited. (9) Information
The Statement of Cash Flows of Cable Limited for the year ended 31 December 2017 appears below:
CABLE LIMITED STATEMENT CASH FLOWS OF FOR THE YEAR ENDED 31 DECEMBER 2017
|
R |
|
|
Cash flows from operating activities |
(200 000) |
|
Operating profit |
800 000 |
|
Non-cash flow adjustment: |
|
|
Depreciation |
300 000 |
|
Profit before working capital changes |
1 100 000 |
|
Working capital changes |
(600 000) |
|
Increase in inventory |
(500 000) |
|
Increase in receivables |
(400 000) |
|
Increase in payables |
300 000 |
|
Cash generated from operations |
500 000 |
|
Interest paid |
(50 000) |
|
Dividends paid |
? |
|
Income tax paid |
(250 000) |
|
Cash flows from investing activities |
100 000 |
|
Disposal of plant and equipment |
100 000 |
|
Cash flows from financing activities |
? |
|
Increase/Decrease in loan |
? |
|
Net increase (decrease) in cash |
50 000 |
|
Cash balance (31 December 2016) |
? |
|
Cash balance (31 December 2017) |
(30 000) |
END
Cash balance as on 31 December 2016 = -$30000 - $50000 = ($80000) (unfavorable)
Cash From Operating Activities = ($200000)
Cash From Operating Activities = Cash Generated from Operations
- Interest Paid - Income Tax - Dividend
($200000) = $500000 - $50000 - $250000 - Dividend
Therefore Dividend Paid = $400000
Net Increase in Cash = Cash from Operating Activities + Cash
from Investing Activities + Cash from Financing Activities
$50000 = ($200000) + $100000 + Cash From Financing Activities
Therefore Cash from financing Activites = $150000
Which means increase in Loan = $150000
Investing activities are important for investors as it shows whether company is investing in growth of business or selling assets for liquidity.
Interpretation is that, despite good profits company is not able to convert it into cash.
Statement of Cash Flows Month Ended December 31, 2015 Cash flows from Operating activities Receipts: Collections from customers 5100 Payments. For rent -1500 For salanes -1500 For utilities -300 -330D Net cash provided (used) by operating activities 1800 Cash flows from investing activities Acquisition of Land -20000 Net cash provided (used) by investing activities Cash flows from financing activities Owner contribution 81000 Owner withdrawal Net cash provided (used) by financing activities Net increase (decrease in cash Cash balance, December 1,...
Cash and cash equivalents balance, December 31, 2016 Cash and cash equivalents balance, December 31, 2017 Cash received as interest Cash paid for salaries Bonds payable retired by issuing common stock (no gain or loss on retirement) Cash paid to retire long-term notes payable Cash received from sale of equipment Cash received in exchange for six-month note payable Land purchased by issuing long-term note payable Cash paid for store equipment Cash dividends paid Cash paid for other expenses Cash received...
Sunland Corporation had the following activities in
2017.
Concord Company’s income
statement for the year ended December 31, 2017, contained the
following condensed information.
Service revenue
$843,000
Operating expenses (excluding
depreciation)
$622,000
Depreciation expense
60,000
Loss on sale of
equipment
26,000
708,000
Income before income
taxes
135,000
Income tax expense
40,000
Net income
$95,000
Concord’s balance sheet contained the following comparative data at
December 31.
2017
2016
Accounts receivable
$36,000
$55,000
Accounts payable
43,000
33,000
Income taxes payable
4,200
8,200...
Following are a statement of cash flows (indirect method) for
Harris, Inc., for the year ended December 31, 2017, and the firm’s
balance sheet at December 31, 2016:
HARRIS, INC.
Statement of Cash Flows
For the year Ended December 31, 2017
Cash Flows from Operating Activities:
Net income
$
13,600
Add (deduct) items not affecting cash:
Depreciation expense
32,000
Increase in accounts receivable
(7,000
)
Decrease in merchandise inventory
32,800
Increase in accounts payable
4,900
Net cash provided by operating...
The
2017 comparative balance sheet and income statement of Summer Time
Hardware Corp. follow. Summer Time had no non-cash investing and
financing transactions during 2017. During the year, there were no
sales of land or equipment, no issuance of notes payable, and no
repurchase of shares transactions.
The 2017 comparative balance sheet and income statement of Summer Time Hardware Corp. follow. Summer Time had no non-cash investing and financing transactions during 2017. During the year, there were no sales of...
Use the following information of VPI Co. to prepare a statement of cash flows for the year ended December 31 using the indirect method. (Amounts to be deducted should be indicated by a minus sign.) Gain on sale of machinery Cash received from sale of machinery Increase in accounts payable Net income Decrease in accounts receivable $ 2,600 Cash balance at prior year-end Increase in inventory Depreciation expense Cash received from issuing stock Cash paid for dividends $42, 400 7,400...
Question 2 (30 marks) Unit 9 - Statement of Cash Flow As the accountant for Awesome Foods Incorporated, you are responsible for preparing the cash flow statement. You have decided to prepare the statement using the indirect method and have gathered the following data from the accounting records: Principal payments on non-current debt$ 50,000 Collections on accounts receivable287,500 Increase in accounts payable24,300 Acquisition of equipment by issuing non-current note payable70,000 Depreciation expense71,300 Collection of loan principal58,000 Proceeds from sale of...
The 2017 comparative balance sheet and income statement of Summer Time Hardware Corp. follow. Summer Time had no non-cash investing and financing transactions during 2017. During the year, there were no sales of land or equipment, no issuance of notes payable, and no repurchase of shares transactions. E (Click the icon to view the comparative balance sheet.) | (Click the icon to view the income statement.) Requirements 1. Prepare the 2017 statement of cash flows, formatting operating activities by using...
As the accountant for Awesome Foods Incorporated, you are responsible for preparing the cash flow statement. You have decided to prepare the statement using the indirect method and have gathered the following data from the accounting records: Principal payments on non-current debt $ 50,000 Collections on accounts receivable 287,500 Increase in accounts payable 25,300 Acquisition of equipment by issuing non-current note payable 70,000 Depreciation expense 71,500 Collection of loan principal 58,000 Proceeds from sale of investments, not including $5,100 gain ...
Heads Up Company was started several years ago by two hockey Instructors. The company's comparative balance sheets and income statement are provided below. along with additional information 2017 2016 Balance Sheet at December 31 Cash Accounts Receivable Equipment Less! Accumulated Depreciation $ 6,000 1.000 5,500 (1,500) $ 4,000 1,750 5,000 (1,250) $ 9,500 -ok $ 11,000 Accounts Payable Wages Payable Long-Term Bank Loan Payable Contributed capital Retained Earnings 500 500 1,500 5,000 3,500 $1,000 750 500 5.000 2,250 ences $...