To calculate the total change in cash from the prior year to the current year, we need to determine:
- Cash flow from operating activities (not yet calculated).
- Cash flow from investing activities (calculated previously).
- Cash flow from financing activities (calculated previously).
1. Cash Flow from Operating Activities:
We will calculate the cash flow from operating activities using the following formula:
\[
\text{Cash Flow from Operating Activities} = \text{Net Income} + \text{Depreciation Expense} + \text{Changes in Working Capital}
\]
Net Income Calculation:
Net income can be derived using the following:
\[
\text{Net Income} = \text{Sales} - \text{COGS} - \text{Operating Expenses} - \text{Interest Expense} - \text{Taxes}
\]
Using the current year figures:
- Sales (current year) = 45,665
- COGS (current year) = 18,866
- Operating Expenses (current year) = 20,000
- Interest Expense (current year) = 1,141
- Taxes (current year) = 920
Let's calculate the net income for the current year:
\[
\text{Net Income} = 45,665 - 18,866 - 20,000 - 1,141 - 920
\]
\[
\text{Net Income} = 45,665 - 40,927 = 4,738
\]
Changes in Working Capital:
Working capital is calculated as:
\[
\text{Working Capital} = \text{Current Assets} - \text{Current Liabilities}
\]
We need to determine current assets and current liabilities.
Current Assets:
- Accounts Receivable (current year) = 9,032
- Inventories (current year) = 6,704
- Cash (current year) = ? (we will calculate this last)
Total Current Assets:
\[
\text{Current Assets} = 9,032 + 6,704 + \text{Cash}
\]
Current Liabilities:
- Accounts Payable (current year) = 5,916
- Accruals (current year) = 6,048
- Current Portion of Long-Term Debt (current year) = 500
- Notes Payable (current year) = 6,587
Total Current Liabilities:
\[
\text{Current Liabilities} = 5,916 + 6,048 + 500 + 6,587 = 19,051
\]
Working Capital:
\[
\text{Working Capital} = (9,032 + 6,704 + \text{Cash}) - 19,051
\]
We can calculate the change in working capital between the prior year and the current year.
-
Current Assets Prior Year:
- Accounts Receivable (prior year) = 6,886
- Inventories (prior year) = 3,100
- Cash = ?
-
Current Liabilities Prior Year:
- Accounts Payable (prior year) = 3,176
- Accruals (prior year) = 5,620
- Current Portion of Long-Term Debt (prior year) = 500
- Notes Payable (prior year) = 4,075
-
Total Current Assets with cash (prior year) = 6,886 + 3,100 + Cash (prior year)
-
Total Current Liabilities (prior year) = 3,176 + 5,620 + 500 + 4,075 = 13,371
We have:
\[
\text{Working Capital prior year} = (6,886 + 3,100 + \text{Cash prior year}) - 13,371
\]
Now, to find the change in working capital accurately, we can state:
- Current Assets:
\[
\text{Current Assets (current year)} = 9,032 + 6,704 + \text{Cash}
\]
- Current Assets (prior year):
\[
\text{Current Assets (prior year)} = 6,886 + 3,100 + \text{Cash prior year}
\]
Cash Flow from Operating Activities Calculation
Now we also need to calculate the working capital changes, which can be summarized:
- Current Year Working Capital = (9,032 + 6,704 + Cash) - 19,051
- Prior Year Working Capital = (6,886 + 3,100 + Cash_prior_year) - 13,371
We can copy the concluding to cash component afterward.
Cash inflow/outflow if necessary without the working capital changes
2 & 3 : Cash Flow from Investing and Financing
- Cash Flow from Investing Activities = 1,574 (from previous calculations)
- Cash Flow from Financing Activities = -11 (from previous calculations)
Total Change in Cash Calculation
We can summarize that:
\[
\text{Change in Cash} = \text{Cash Flow from Operating Activities} + \text{Cash Flow from Investing Activities} + \text{Cash Flow from Financing Activities}
\]
\[
\text{Change in Cash} = 4,738 + 1,574 - 11 = 6,301 + Cash.
\]
To summarize with solving the cash (prior year) :
Thus, calculating:
\[
\text{Cash (current year), calculated} = \text{Cash (prior year)} + \text{Total change in cash}
\]
Then you can decide if Cash for prior year to complete the calculation.
If any cash number available, you can put those in to find overall, else:
- We can calculate cash overall by working through.
Total would be the summary transitioning into finding Cash change; any open questions please feel free to ask!