Cash Flow Worksheet

Cash Flow Worksheet 

By: Abu Dhabi SME Hub
Accounting, Financial Planning

The cash flow is determined by looking at three components by which cash enters and leaves a company: core operations, investing, and financing.

The cash flow statement provides aggregate data regarding all cash inflows and outflows of a company.

It allows investors to understand how a company's operations are running, where its money is coming from, and how it is being spent. The cash flow statement is distinct from the income statement and balance sheet because it does not include the amount of future incoming and outgoing cash that has been recorded on credit. Therefore, cash is not the same as net income.

The Cash Flow Worksheet template in the file you can download below was designed to make it easy for you to calculate your cash flow. It is intended to be a simple and practical tool to be adjusted and used by SMEs working in all sectors. You may adapt it to reflect your business needs, type of clientele, products, and services you offer. It provides the minimum information required by financial institutions for assessing loan applications, tax authorities, and potential investors.

Start with filling in your beginning cash balance for month 1 in cell C5. Then fill in your cash inflows and outflows as applicable for each month. Totals will be calculated automatically.

 

File Description: the file contains a Microsoft Excel spreadsheet template.

You might also like