Cash Flow from Operations Formula Examples and Templates

What Is Cash Flow from Operations?

Cash flow from operations (CFO) measures the cash a business generates from its core activities – selling products, delivering services, and managing day‑to‑day operations. It excludes financing and investing cash flows, focusing solely on the cash that powers the engine of the company.

Why CFO Matters for Investors and Managers

• Shows the real liquidity of the business.
• Highlights the ability to pay suppliers, employees, and taxes.
• Helps investors assess the sustainability of earnings.
• Guides management in budgeting and cash‑management decisions.

Two Methods to Calculate Cash Flow from Operations

The two accepted methods are the indirect method and the direct method. The indirect method starts with net income and adjusts for non‑cash items, while the direct method lists actual cash receipts and payments.

Indirect Method – Step‑by‑Step Formula

This is the most commonly used approach because it links the income statement to the balance sheet.

1. Start with Net Income.
2. Add back all non‑cash expenses (depreciation, amortisation, stock‑based compensation).
3. Subtract gains that did not generate cash (e.g., gain on sale of equipment).
4. Adjust for changes in working‑capital accounts:
   • Increase in Accounts Receivable → subtract.
   • Decrease in Accounts Receivable → add.
   • Increase in Inventory → subtract.
   • Decrease in Inventory → add.
   • Increase in Accounts Payable → add.
   • Decrease in Accounts Payable → subtract.
5. Result = Cash Flow from Operations.

Direct Method – Quick Overview

The direct method reports cash receipts from customers and cash payments to suppliers, employees, and taxes. It provides a clearer picture of cash movements but requires detailed cash‑transaction tracking.

• Cash received from customers
• Cash paid to suppliers
• Cash paid to employees
• Cash paid for interest and taxes

The net of these items equals cash flow from operations.

Cash Flow from Operations Template – Downloadable Excel

Save time and avoid errors with a ready‑made spreadsheet that follows the indirect method step‑by‑step.

Download the free Cash Flow from Operations Excel template and start populating your numbers today.

Industry‑Specific Examples

Below are two quick examples that show how the same formula works for very different businesses.

Restaurant Example (Small Business)

Item	Amount ($)
Net Income	45,000
+ Increase in Accounts Receivable	(10,000)
+ Decrease in Supplies	2,000
+ Decrease in Pre‑paid Rent	5,000
Cash Flow from Operations	48,000

This simple layout shows how a restaurant can quickly see the cash generated from its daily sales.

Manufacturing Example

Assume a manufacturer reports:

• Net Income: $120,000
• Depreciation: $25,000 (add back)
• Increase in Inventory: $15,000 (subtract)
• Decrease in Accounts Payable: $8,000 (subtract)

Cash Flow from Operations = 120,000 + 25,000 – 15,000 – 8,000 = $122,000.

Step‑by‑Step Checklist to Prepare Your Cash Flow Statement

1. Gather the latest income statement and balance sheet.
2. Identify non‑cash charges (depreciation, amortisation).
3. Collect all working‑capital account balances.
4. Calculate the change (increase/decrease) for each balance‑sheet item.
5. Apply the indirect‑method formula.
6. Validate the result against the cash balance on the statement of cash flows.
7. Upload the completed template to your accounting system.

Simple HTML Table Template You Can Copy

Copy the code below into any HTML‑enabled document (Word, Google Docs, website) and replace the placeholder numbers with your own data.

<table border="1" cellpadding="5" cellspacing="0">
  <tr><th>Component</th><th>Amount ($)</th></tr>
  <tr><td>Net Income</td><td>0</td></tr>
  <tr><td>+ Depreciation & Amortisation</td><td>0</td></tr>
  <tr><td>- Increase in Inventory</td><td>0</td></tr>
  <tr><td>+ Decrease in Accounts Payable</td><td>0</td></tr>
  <tr><td><strong>Cash Flow from Operations</strong></td><td><strong>0</strong></td></tr>
</table>

Next Steps – Automate and Visualise Your Cash Flow

Once you have the raw numbers, consider using a dynamic dashboard to monitor trends month‑over‑month.

• Automated Excel Financials Toolkit – turn the template into a live model that updates with your accounting data.
• Business Plan Template – embed the CFO results into a full financial forecast for investors.

Download the Cash Flow from Operations Workbook

Ready to put the formula to work? Grab the complete workbook that includes the template, industry examples, and checklist.

Get the Cash Flow from Operations Workbook now.

Image