In: Finance
. In the last month, Cash Is King, Inc. had net income of $10,000, an increase in a/r of $5,000, a decrease in a/p of $5,000, their inventories rose by $7500, they purchased computers worth $10,000, sold stock worth $100,000, and paid down their bank loans by $50,000. What was their cash flow from each of the following areas:
a. Operations
b. Investing Activities
c. Financing Activities
d. What was their total cash flow for the period?
A | B | C | D | E | F | G | H | I | J |
2 | a) | ||||||||
3 | The operating section shows the cash receipt and payment for the normal course of business. | ||||||||
4 | Increase in current assets decreases the cash in hand and increase in liabilities increases the cash in hand. | ||||||||
5 | Cash Flows from operating activities | ||||||||
6 | Net Income | $10,000 | |||||||
7 | Adjustments to reconcile Net Income to Net cash provided by the operating activities | ||||||||
8 | (Increase) decrease in accounts receivable | ($5,000) | |||||||
9 | (Increase) decrease in Inventories | ($7,500) | |||||||
10 | Increase (decrease) in Accounts Payables | ($5,000) | |||||||
11 | Net cash provided by operating activity | ($7,500) | =E6+SUM(D8:D10) | ||||||
12 | |||||||||
13 | Hence Cash Flow from Operations | ($7,500) | |||||||
14 | |||||||||
15 | b) | ||||||||
16 | Investing section includes the effect of purchase and disposal of long-term fixed asset and investments. | ||||||||
17 | Cash Flows from investing activities | ||||||||
18 | Purchase of Equipment using Cash | ($10,000) | |||||||
19 | Net cash provided by investing activity | ($10,000) | |||||||
20 | |||||||||
21 | Hence Cash Flow from investing activities | ($10,000) | |||||||
22 | |||||||||
23 | c) | ||||||||
24 | |||||||||
25 | Financing section records the cash receipt or disbursement due to financial activities | ||||||||
26 | such as stocks issue, dividend payment, Bond issue, Bond payment etc. | ||||||||
27 | Cash Flows from financing activities | ||||||||
28 | Proceeds from issue of shares | $100,000 | |||||||
29 | Repayment of loan | ($50,000) | |||||||
30 | Net cash provided by Financing Activity | $50,000 | |||||||
31 | |||||||||
32 | Hence Cash Flow from financing activities | $50,000 | |||||||
33 | |||||||||
34 | d) | ||||||||
35 | Total Cash Flow for the period | =Sum of Cash Flows from Operating, Investing and financing activities | |||||||
36 | =-$7,500-$10,000+$50,000 | ||||||||
37 | $32,500 | =D13+D21+E30 | |||||||
38 | |||||||||
39 | Total Cash Flow for the period | $32,500 | |||||||
40 |