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 Statement Template

Excel Cash Flow Template

Description:Excel template for a Cash Flow Statement, with formulas to calculate totals for user-supplied figures
Versions:Excel 2010 and later

Download Now

Functions Used in the Excel Cash Flow Statement Template

The Excel functions and operators used in the above Cash Flow spreadsheet are:

Sum functionUsed to calculate the totals for each category of cash flows.
+ operator

The addition operator is used to calculate:

Net increase (decrease) in cash & cash equivalents=Net cash from operating activities +
Net cash from investing activities +
Net cash from financing activities +
Effect of exchange rate fluctuations on cash & cash equivalents
Cash & cash equivalents, end of period=Net increase (decrease) in cash & cash equivalents
+ Cash & cash equivalents, start of period

See also:     Excel Balance Sheet template  >>
Excel Profit and Loss template  >>