Cash flow statement template

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 Statement

For the period ending [Enter Date Range]

Month 1Month 2Month 3Month 4Month 5Month 6Month 7Month 8Month 9Month 10Month 11Month 12Total
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:

  1. Fill out the Income Statement section with revenues and expenses for the period.
  2. Fill out the Balance Sheet section with assets, liabilities, and equity amounts as of the last day of the period.
  3. The Cash Flow Statement will automatically calculate based on the information entered in the other two sections.

Income Statement:

RevenueAmount
[Revenue 1][Amount]
[Revenue 2][Amount]
[Revenue 3][Amount]
Total Revenue[Amount]
ExpenseAmount
[Expense 1][Amount]
[Expense 2][Amount]
[Expense 3][Amount]
Total Expense[Amount]

| Net Income | [Revenue – Expense] |

Balance Sheet:

AssetsAmount
[Asset 1][Amount]
[Asset 2][Amount]
[Asset 3][Amount]
Total Assets[Amount]
LiabilitiesAmount
[Liability 1][Amount]
[Liability 2][Amount]
[Liability 3][Amount]
Total Liabilities[Amount]
EquityAmount
[Equity 1][Amount]
[Equity 2][Amount]
[Equity 3][Amount]
Total Equity[Amount]

| Total Liabilities and Equity | [Total Liabilities + Total Equity] |

Cash Flow Statement:

Cash FlowAmount
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 InflowsAmount
Sales/Revenue[Amount]
Accounts Receivable Collections[Amount]
Other Inflows[Amount]
Total Cash Inflows[Sum of all inflows]
Cash OutflowsAmount
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 IncomeAmount
Rent Received from Tenants[Amount]
Late Fees[Amount]
Other Rental Income[Amount]
Total Rental Income[Sum of all rental income]
Operating ExpensesAmount
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 ServiceAmount
Mortgage Payment[Amount]
Interest[Amount]
Total Debt Service[Sum of all debt service]

| Cash Flow Before Taxes (CFBT) | [NOI – Debt Service] |

TaxesAmount
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 InflowsAmount
Equity Investment[Amount]
Loans Received[Amount]
Sales/Revenue[Amount]
Other Inflows[Amount]
Total Cash Inflows[Sum of all inflows]
Cash OutflowsAmount
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] |

Leave a Reply

Your email address will not be published. Required fields are marked *