Create a cash flow statement table for a fictional company called 1 2

Fantastic news! We've Found the answer you've been seeking!

Question:

Create a cash flow statement table for a fictional company called $" 1 2 3$ organization $"$ based on the provided data. You have been provided with the following data for $1 2 3$ organization for the year ending December $3 1, 2 0$ XX:

$3 .$ Cash Flow Statement Data:

$*$ Cash from Operations: Calculate the cash from operations using the direct method.

$*$ Cash from Investing: Assume $ $10, 000$ was spent on purchasing PPE and $ $5, 000$ was received from selling an old asset.

$*$ Cash from Financing: Assume $ $20, 000$ was borrowed $($ long $-$ term debt $)$ and $ $10, 000$ was repaid $($ short $-$ term debt $) .$

$*$ Net Cash Flow: Calculate the net cash flow for the year.

Cash Flow Statement:

$1 .$ Create a Excel worksheet with the headers: "Item," "Amount," and "Notes."

$2 .$ Input the cash flow statement items $($ e $.$ g $.,$ Cash from Operations, Cash from Investing, Cash from Financing, Net Cash Flow $)$ in the "Item" column.

$3 .$ Input the respective values for each item in the "Amount" column.

$4 .$ Use Excel formulas to calculate Cash from Operations and Net Cash Flow based on the provided data.