#Cashflow statement template password

The additional information section requires users to specify whether any business acquisitions, disposals of property, plant and equipment or intangibles and raising of long term finance occurred during the current and previous financial periods.

All the other cells in this template that contain references to the reporting periods will automatically be amended. The default reporting periods can be amended by simply entering a new year in cell B2.

#Cashflow statement template password

You will then be required to enter and to confirm a user defined password (all input cells have already been unlocked in order to allow user input). The Protect Sheet feature can be accessed by selecting the Review tab on the ribbon and selecting the Protect Sheet option from the Changes section of the ribbon. Only valid input cells will then be available for user input. If you are concerned about replacing the formulas in the cells that do not require user input, we recommend that you protect the sheet with a user defined password. Cells that don't have a yellow or green colour next to them contain formulas and should be left unchanged. The cells which are indicated in yellow require positive values to be entered, while the cells which are indicated in green require negative values to be entered. No user input is required on this sheet.Īll the cells on the Input sheet which require user input are indicated by a yellow or green cell background in the column to the right of the appropriate input cell. Indirect - this sheet contains a cash flow statement based on the indirect method which is automatically calculated from the information entered on the Input sheet. User input consists of an income statement and a balance sheet section as well as some additional information which is required in order to produce a cash flow statement.ĭirect - this sheet contains a cash flow statement based on the direct method which is automatically calculated from the information entered on the Input sheet. Input - this sheet includes all the input cells used in compiling the cash flow statement. The following sheets are included in this template: The template includes statements of cash flow that have been compiled based on both the direct and indirect methods. The template includes a current and comparative financial period and detailed instructions on the calculation of the line items which are included on the cash flow statement. This template enables users to automatically compile a complete cash flow statement by simply entering basic income statement and balance sheet information.