 |
| Free Cash Flow Statement Template in Excel |
Download Free Cash Flow Statement Template in Excel
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. Year In Year Out figures are the expected annual figures for your farm business on the assumption that normal seasonal conditions occur, long-term average commodity prices are achieved and any forecast productivity enhancements to be funded via your loan application are achieved. We encourage you to discuss the YIYO with the RIC on 1800 875 675.
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