Excel Cash Flow Statement Template
The following Excel spreadsheet provides a template of a typical Cash Flow statement, which may be useful for your small business accounts.
The fields in the tan colored cells of the spreadsheet are left blank for you to enter your own figures, and you can also change labels for these rows to reflect your own categories of cash flows. You can also insert further rows into the Cash Flow template, but if you do, it is advised that you check the formulas (in the grey cells), to ensure that they include the figures from any newly inserted rows.
|
Excel Cash Flow Template
|
Functions Used in the Excel Cash Flow Statement Template
The Excel functions and operators used in the above Cash Flow spreadsheet are:
| Sum function | Used to calculate the totals for each category of cash flows. | ||||||
| + operator |
The addition operator is used to calculate:
|