12 Month Cash Flow Statement Template Excel |
12 Month Cash Flow Statement Template Excel - Free Download
A cash flow statement is a financial statement that summarizes the amount of cash and cash equivalents entering and leaving a company. The cash flow statement measures how well a company manages its cash position, meaning how well the company generates cash to pay its debt obligations and fund its operating expenses.
Using this Cash Flow Statement Template
This cash flow statement contains a list of suggested profit items and expenses a typical business may have. You can edit these items by removing or adding rows and typing in your own items. To get started enter the financial year at the top of the sheet and enter your opening balance figure in the first column.
Please note: This statement assumes all figures are GST inclusive.
Formulas:
When you enter your figures, the sheet will automatically calculate your totals and net profit at the bottom. If you are adding or removing rows please double-check your figures to ensure the calculations have been preserved.
Calculations:
👉Gross profit/net sales equals Sales minus cost of goods sold minus any other expenses related to the production of a good or service.
👉Net profit equals Gross profit/net sales minus Total expenses.
This Cash Flow statement is intended as a GUIDE ONLY and DOES NOT constitute financial advice, please verify and discuss your financial statements with a qualified accountant, solicitor or financial advisor.
Download also:
Post a Comment