A cash flow statement template is a tool used by businesses to present information about their cash inflows and outflows over a specific period of time.
The template typically includes three main sections: operating activities, investing activities, and financing activities.
The operating activities section shows the cash generated or used by the company’s core business operations, such as sales and production.
This section usually includes adjustments for items like depreciation and changes in working capital.
The investing activities section shows the cash used for investing in new assets or selling existing ones. This can include purchases of property, plant, and equipment, as well as proceeds from the sale of these assets.
The financing activities section shows the cash received or paid out for financing the business, such as issuing debt or repurchasing stock.
This section also includes dividends paid to shareholders.
The net change in cash and cash equivalents over the reporting period is calculated by subtracting the cash used in investing and financing activities from the cash generated by operating activities.
The beginning and ending cash balances are also shown.
A cash flow statement template can vary depending on the company’s needs and the industry it operates in, but the basic structure remains the same.
12 month cash flow statement template excel
Here’s an example of a 12-month cash flow statement template in Excel:
[Enter Company Name] Cash Flow StatementFor the period ending [Enter Date Range]
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Total Operating Activities Net income Depreciation and amortization Changes in working capital Increase (decrease) in A/R Increase (decrease) in Inventory Increase (decrease) in A/P Other adjustments Net cash provided by operating activities Investing Activities Purchase of PPE Proceeds from sale of PPE Purchases of investments Sales of investments Other investing activities Net cash used in investing activities Financing Activities Proceeds from issuance of debt Repayment of debt Issuance of equity Repurchase of equity Dividends paid Other financing activities
Balance sheet cash flow income statement template
Here is a basic template for a balance sheet, cash flow statement and income statement:
[Balance sheet] [Insert name of company] As of [Insert date]Assets: Current assets: Cash and cash equivalents: $________
Accounts receivable: $________
Inventory: $________
Other current assets: $________
Total current assets: $________
Long-term assets: Property, plant, and equipment: $________
Investments: $________
Goodwill: $________
Other long-term assets: $________
Total long-term assets: $________
Total assets: $________
Liabilities and Shareholders’ Equity: Current liabilities: Accounts payable: $________
Short-term debt: $________
Accrued expenses: $________
Other current liabilities: $________
Total current liabilities: $________
Long-term liabilities: Long-term debt: $________
Other long-term liabilities: $________
Total long-term liabilities: $________
Shareholders’ equity: Common stock: $________
Retained earnings: $________
Other equity: $________
Total shareholders’ equity: $________
Total liabilities and shareholders’ equity: $________
[Income statement] [Insert name of company] For the period [Insert time frame]Revenue: $________
Cost of goods sold: $________
Gross profit: $________
Operating expenses: Sales and marketing: $________
General and administrative: $________
Research and development: $________
Total operating expenses: $________
Operating income: $________
Other income (expense): Interest expense: $________
Interest income: $________
Other income (expense): $________
Total other income (expense): $________
Net income before taxes: $________
Income tax expense: $________
Net income: $________
[Cash flow statement] [Insert name of company] For the period [Insert time frame]Operating Activities: Net income: $________
Depreciation and amortization: $________
Changes in working capital: Increase (decrease) in accounts receivable: $________
Increase (decrease) in inventory: $________
Increase (decrease) in accounts payable: $________
Net cash provided by operating activities: $________
Investing Activities: Purchase of property, plant, and equipment: $________
Proceeds from sale of property, plant, and equipment: $________
Net cash used in investing activities: $________
Financing Activities: Proceeds from issuance of debt: $________
Repayment of debt: $________
Issuance of common stock: $________
Repurchase of common stock: $________
Dividends paid: $________
Net cash provided by (used in) financing activities: $________
Net increase (decrease) in cash and cash equivalents: $________
Beginning cash and cash equivalents: $________
Ending cash and cash equivalents: $________
Basic cash flow statement template
here’s a basic cash flow statement template:
[Cash flow statement] [Insert name of company] For the period [Insert time frame]Operating Activities:
Net income: $________
Depreciation and amortization: $________
Changes in working capital: Increase (decrease) in accounts receivable: $________
Increase (decrease) in inventory: $________
Increase (decrease) in accounts payable: $________
Net cash provided by operating activities: $________
Investing Activities: Purchase of property, plant, and equipment: $________
Proceeds from sale of property, plant, and equipment: $________
Net cash used in investing activities: $________
Financing Activities: Proceeds from issuance of debt: $________
Repayment of debt: $________
Issuance of common stock: $________
Repurchase of common stock: $________
Dividends paid: $________
Net cash provided by (used in) financing activities: $________
Net increase (decrease) in cash and cash equivalents: $________
Beginning cash and cash equivalents: $________
Ending cash and cash equivalents: $________
Blank cash flow statement template
here’s a blank cash flow statement template:
[Cash flow statement] [Insert name of company] For the period [Insert time frame]Operating Activities: Net income: $________
Depreciation and amortization: $________
Changes in working capital: Increase (decrease) in accounts receivable: $________
Increase (decrease) in inventory: $________
Increase (decrease) in accounts payable: $________
Other adjustments: $________
Net cash provided by operating activities: $________
Investing Activities: Purchase of property, plant, and equipment: $________
Proceeds from sale of property, plant, and equipment: $________
Purchases of investments: $________
Sales of investments: $________
Other investing activities: $________
Net cash used in investing activities: $________
Financing Activities: Proceeds from issuance of debt: $________
Repayment of debt: $________
Issuance of equity: $________
Repurchase of equity: $________
Dividends paid: $________
Other financing activities: $________
Net cash provided by (used in) financing activities: $________
Net increase (decrease) in cash and cash equivalents: $________
Beginning cash and cash equivalents: $________
Ending cash and cash equivalents: $________
Business cash flow statement template
Here is a basic template for a business cash flow statement:
[Company Name]Cash Flow Statement
For the period ended [Date]
Operating Activities:
Net Income: [Insert Net Income]
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization: [Insert Depreciation and Amortization Amount]
Changes in working capital accounts:
Accounts receivable: [Insert Accounts Receivable Amount]
Inventory: [Insert Inventory Amount]
Accounts payable: [Insert Accounts Payable Amount]
Other current assets/liabilities: [Insert Other Current Assets/Liabilities Amount]
Net Cash Provided by Operating Activities: [Insert Net Cash Provided by Operating Activities]
Investing Activities:
Purchase of property, plant, and equipment: [Insert Purchase of Property, Plant, and Equipment Amount] Proceeds from sale of property, plant, and equipment: [Insert Proceeds from Sale of Property, Plant, and Equipment Amount]
Net Cash Used in Investing Activities: [Insert Net Cash Used in Investing Activities]
Financing Activities:
Proceeds from long-term debt: [Insert Proceeds from Long-Term Debt Amount]
Repayment of long-term debt: [Insert Repayment of Long-Term Debt Amount]
Issuance of common stock: [Insert Issuance of Common Stock Amount]
Dividends paid: [Insert Dividends Paid Amount]
Net Cash Used in Financing Activities: [Insert Net Cash Used in Financing Activities]
Net Increase (Decrease) in Cash: [Insert Net Increase (Decrease) in Cash]
Cash at Beginning of Period: [Insert Cash at Beginning of Period]
Cash at End of Period: [Insert Cash at End of Period]
Direct cash flow statement template
Here is a template for a direct cash flow statement:
[Company Name] Direct Cash Flow Statement For the period ended [Date]Cash Flows from Operating Activities:
Cash received from customers: [Insert Cash Received from Customers Amount]
Cash paid to suppliers and employees: [Insert Cash Paid to Suppliers and Employees Amount]
Interest received: [Insert Interest Received Amount]
Interest paid: [Insert Interest Paid Amount]
Income taxes paid: [Insert Income Taxes Paid Amount]
Net Cash Provided by (Used in) Operating Activities: [Insert Net Cash Provided by (Used in) Operating Activities]
Cash Flows from Investing Activities: Purchase of property, plant, and equipment: [Insert Purchase of Property, Plant, and Equipment Amount]
Proceeds from sale of property, plant, and equipment: [Insert Proceeds from Sale of Property, Plant, and Equipment Amount]
Net Cash Used in Investing Activities: [Insert Net Cash Used in Investing Activities]
Cash Flows from Financing Activities:
Proceeds from issuance of long-term debt: [Insert Proceeds from Issuance of Long-Term Debt Amount] Repayment of long-term debt: [Insert Repayment of Long-Term Debt Amount]
Proceeds from issuance of common stock: [Insert Proceeds from Issuance of Common Stock Amount] Dividends paid: [Insert Dividends Paid Amount]
Net Cash Provided by (Used in) Financing Activities: [Insert Net Cash Provided by (Used in) Financing Activities]
Net Increase (Decrease) in Cash:
Net increase (decrease) in cash and cash equivalents: [Insert Net Increase (Decrease) in Cash and Cash Equivalents]
Cash and cash equivalents at beginning of period: [Insert Cash and Cash Equivalents at Beginning of Period]
Cash and cash equivalents at end of period: [Insert Cash and Cash Equivalents at End of Period]
Household cash flow statement template
Here’s a basic household cash flow statement template that you can use:
Household Cash Flow Statement for [Month/Year]
Income:
- Salary/Wages: [amount]
- Rental Income: [amount]
- Investments/Dividends: [amount]
- Other Income: [amount]
Total Income: [sum of all income sources]
Expenses:
- Rent/Mortgage Payment: [amount]
- Utilities (Electricity, Water, Gas, etc.): [amount]
- Groceries/Food: [amount]
- Transportation (Gas, Maintenance, Insurance, etc.): [amount]
- Entertainment/Leisure: [amount]
- Debt Payments (Credit Cards, Loans, etc.): [amount]
- Other Expenses: [amount]
Total Expenses: [sum of all expenses]
Net Cash Flow: [Total Income – Total Expenses]
Income statement balance sheet cash flow excel template
Here’s a template that includes all three financial statements (income statement, balance sheet, and cash flow statement) in Excel format:
Income Statement, Balance Sheet, and Cash Flow Statement Template
Instructions:
- Fill out the Income Statement section with revenues and expenses for the period.
- Fill out the Balance Sheet section with assets, liabilities, and equity amounts as of the last day of the period.
- The Cash Flow Statement will automatically calculate based on the information entered in the other two sections.
Income Statement:
Revenue | Amount |
---|---|
[Revenue 1] | [Amount] |
[Revenue 2] | [Amount] |
[Revenue 3] | [Amount] |
Total Revenue | [Amount] |
Expense | Amount |
---|---|
[Expense 1] | [Amount] |
[Expense 2] | [Amount] |
[Expense 3] | [Amount] |
Total Expense | [Amount] |
| Net Income | [Revenue – Expense] |
Balance Sheet:
Assets | Amount |
---|---|
[Asset 1] | [Amount] |
[Asset 2] | [Amount] |
[Asset 3] | [Amount] |
Total Assets | [Amount] |
Liabilities | Amount |
---|---|
[Liability 1] | [Amount] |
[Liability 2] | [Amount] |
[Liability 3] | [Amount] |
Total Liabilities | [Amount] |
Equity | Amount |
---|---|
[Equity 1] | [Amount] |
[Equity 2] | [Amount] |
[Equity 3] | [Amount] |
Total Equity | [Amount] |
| Total Liabilities and Equity | [Total Liabilities + Total Equity] |
Cash Flow Statement:
Cash Flow | Amount |
---|---|
Cash Flow from Operating Activities | [Amount] |
Cash Flow from Investing Activities | [Amount] |
Cash Flow from Financing Activities | [Amount] |
Net Change in Cash and Cash Equivalents | [Amount] |
Projected cash flow statement template
Here’s a basic projected cash flow statement template:
Projected Cash Flow Statement for [Period]
Cash Inflows | Amount |
---|---|
Sales/Revenue | [Amount] |
Accounts Receivable Collections | [Amount] |
Other Inflows | [Amount] |
Total Cash Inflows | [Sum of all inflows] |
Cash Outflows | Amount |
---|---|
Cost of Goods Sold (COGS) | [Amount] |
Operating Expenses | [Amount] |
Taxes | [Amount] |
Interest Payments | [Amount] |
Capital Expenditures | [Amount] |
Loan Payments | [Amount] |
Other Outflows | [Amount] |
Total Cash Outflows | [Sum of all outflows] |
| Net Cash Flow | [Cash Inflows – Cash Outflows] |
Rental property cash flow statement template
Here’s a basic rental property cash flow statement template:
Rental Property Cash Flow Statement for [Period]
Rental Income | Amount |
---|---|
Rent Received from Tenants | [Amount] |
Late Fees | [Amount] |
Other Rental Income | [Amount] |
Total Rental Income | [Sum of all rental income] |
Operating Expenses | Amount |
---|---|
Property Management Fees | [Amount] |
Repairs and Maintenance | [Amount] |
Insurance | [Amount] |
Property Taxes | [Amount] |
Utilities | [Amount] |
HOA Fees | [Amount] |
Advertising | [Amount] |
Office and Legal | [Amount] |
Other Expenses | [Amount] |
Total Operating Expenses | [Sum of all operating expenses] |
| Net Operating Income (NOI) | [Rental Income – Operating Expenses] |
Debt Service | Amount |
---|---|
Mortgage Payment | [Amount] |
Interest | [Amount] |
Total Debt Service | [Sum of all debt service] |
| Cash Flow Before Taxes (CFBT) | [NOI – Debt Service] |
Taxes | Amount |
---|---|
Federal Income Tax | [Amount] |
State/Local Income Tax | [Amount] |
Property Tax | [Amount] |
Total Taxes | [Sum of all taxes] |
| Net Cash Flow | [CFBT – Total Taxes] |
Startup cash flow statement template
Here’s a basic startup cash flow statement template:
Startup Cash Flow Statement for [Period]
Cash Inflows | Amount |
---|---|
Equity Investment | [Amount] |
Loans Received | [Amount] |
Sales/Revenue | [Amount] |
Other Inflows | [Amount] |
Total Cash Inflows | [Sum of all inflows] |
Cash Outflows | Amount |
---|---|
Rent/Lease Payments | [Amount] |
Salaries and Wages | [Amount] |
Inventory Purchases | [Amount] |
Marketing and Advertising | [Amount] |
Professional Fees (Legal, Accounting, etc.) | [Amount] |
Insurance | [Amount] |
Equipment and Supplies | [Amount] |
Interest Payments | [Amount] |
Loan Repayments | [Amount] |
Other Outflows | [Amount] |
Total Cash Outflows | [Sum of all outflows] |
| Net Cash Flow | [Cash Inflows – Cash Outflows] |