Cash Flow Statement Template in Excel

Description
As noted in the short description, in this cash flow statement you will find a suggested list of expenses and profit items you may find within a typical business. All of these items can be modified by adding or removing rows and inputting your own items.To start, input the financial year at the top and in the first column enter your opening balance figure.

You should note that this particular statement assumes all figures are GST inclusive.

Formulas

After you've entered your figures, the sheet automatically calculates your net profit and totals at the bottom. If you're removing or adding rows, you should double-check your numbers to make sure the calculations have been maintained.

Calculations

Gross profit ÷ net sales = sales - cost of goods sold -any other expenses related to the production of a good or service.

Net profit = Gross profit ÷ net sales - Total expenses.

This cash flow statement is intended to be solely a guide and does not constitute as financial advice. You shold discuss and verify your financial statements with a financial advisor, qualified accountant, or a solicitor.

*Originally found on business.gov.au*