Free Cash Flow Statement Template
Last updated: 2026-10-03
A small business cash flow statement using the indirect method: start from net income, adjust for non-cash items and working capital, then add investing and financing activities. It checks that ending cash matches your balance sheet. Have a balance sheet and P&L saved? Let the template build the whole statement for you.
- Excel with live formulas
- Build from balance sheet + P&L
- Ending cash reconciliation
- Annual, quarterly or monthly
- Free cash flow and runway
- No signup
| Line item | FY 2025 ended Dec 31 |
|---|---|
Cash flows from operating activities | |
$ | |
$ | |
$ | |
$ | |
$ | |
$ | |
$ | |
$ | |
$ | |
| Net cash provided by (used in) operating activities | – |
Cash flows from investing activities | |
$ | |
$ | |
$ | |
| Net cash provided by (used in) investing activities | – |
Cash flows from financing activities | |
$ | |
$ | |
$ | |
$ | |
$ | |
| Net cash provided by (used in) financing activities | – |
| Net increase (decrease) in cash | – |
Cash at beginning of period | $ |
| Cash at end of period | – |
Cash per balance sheet / bank, end of period (optional) | $ |
| Check: calculated − actual ending cash (should be 0) | ✓ 0 |
Saved automatically in this browser only. Nothing is uploaded. Click next to a line to see what belongs there.
Automatic checks
- Enter your figures, pull them from your saved statements, or load the example to run the checks.
Key ratios (per column)
Operating cash flow
- —
Net cash from operating activities
Free cash flow
- —
Operating cash flow − purchases of property and equipment
Cash conversion of profit
- —
Operating cash flow ÷ net income
Cash runway
- —
Ending cash ÷ average monthly negative free cash flow
How to prepare a cash flow statement (indirect method), step by step
- Gather three things: your P&L for the period, and balance sheets at the start and end of the period. (The fastest route: fill in the balance sheet with both dates and the P&L, then click Build from my balance sheet + P&L here.)
- Start with net income from the bottom of the P&L, and add back depreciation and amortization.
- Adjust for working capital. For each current asset and current liability, take the change between the two balance sheets and apply the signs in the cheat sheet below.
- Investing: cash paid for equipment, vehicles or property (outflow) and cash received from selling them (inflow).
- Financing: new loans (inflow), principal repaid (outflow), owner contributions (inflow) and owner draws or distributions (outflow).
- Reconcile. Enter beginning cash and the actual ending cash from your balance sheet. The template flags any difference so you can find the missing or misclassified item.
Cheat sheet: plus or minus?
| Between the two balance sheets… | Enter as | Why |
|---|---|---|
| Accounts receivable went up | Negative | You booked sales you haven't collected yet |
| Accounts receivable went down | Positive | You collected old invoices |
| Inventory went up | Negative | Cash turned into stock on the shelf |
| Prepaid expenses went up | Negative | You paid ahead for future months |
| Accounts payable went up | Positive | You received goods but haven't paid yet |
| Accrued wages / taxes went up | Positive | Expenses recorded but not yet paid |
| Customer deposits went up | Positive | Cash received before the revenue was earned |
| Depreciation and amortization | Positive (add back) | An expense that used no cash this period |
Equipment purchases, loan repayments and owner draws are entered as positive amounts on their “outflow” lines. The template subtracts them.
Worked example: profitable, but cash went down
The same fictional Maple Street Bakery LLC from the P&L and balance sheet templates. Every figure below can be calculated from those two statements.
FY 2025 ended Dec 31 | |
|---|---|
| Cash flows from operating activities | |
| Net income (loss) | 48,000 |
| Depreciation and amortization | 18,000 |
| (Increase) decrease in accounts receivable | (3,200) |
| (Increase) decrease in inventory | (1,500) |
| (Increase) decrease in prepaid expenses and other current assets | 300 |
| Increase (decrease) in accounts payable | 2,600 |
| Increase (decrease) in accrued expenses and other current liabilities | 1,000 |
| Increase (decrease) in customer deposits and unearned revenue | 1,100 |
| Net cash provided by (used in) operating activities | 66,300 |
| Cash flows from investing activities | |
| Purchases of property and equipment | (26,000) |
| Net cash provided by (used in) investing activities | (26,000) |
| Cash flows from financing activities | |
| Repayments of loan principal | (14,000) |
| Owner draws, distributions and dividends paid | (30,000) |
| Net cash provided by (used in) financing activities | (44,000) |
| Net increase (decrease) in cash | (3,700) |
| Cash at beginning of period | 38,400 |
| Cash at end of period | 34,700 |
Fictional company for illustration. Click “Load example” in the template above to explore these figures, then open the other two templates to see the same company's statements.
What it says: operations generated $66,300, more than net income of $48,000, mainly because $18,000 of depreciation is added back. Higher payables, accruals and customer deposits roughly offset the cash tied up in higher receivables and inventory. Free cash flow (operating cash flow minus $26,000 of equipment) was $40,300. Financing used $44,000: loan principal plus $30,000 of distributions. The net result was a $3,700 decrease in cash, and ending cash of $34,700 matches the balance sheet.
Common cash flow statement mistakes
- Getting the working-capital signs backwards. An increase in receivables or inventory reduces cash. See the cheat sheet.
- Forgetting to add back depreciation, or adding it back twice when it's already in a working-capital line.
- Putting loan principal in operating activities. Principal is financing. Only interest is part of net income.
- Counting financed equipment as a cash outflow when the lender paid the seller directly. That's a non-cash transaction. Disclose it in a note instead.
- Beginning cash that doesn't match last period's ending cash. In monthly and quarterly views the template links them automatically.
- Skipping the reconciliation. If calculated ending cash doesn't equal the balance sheet, something is missing.
How the balance sheet, P&L and cash flow statement connect
The three statements describe the same business from different angles. The profit and loss statement covers a period: did you make money? The balance sheet is a snapshot at the end of the period: what do you own and owe? The cash flow statement explains why cash changed between two balance sheets. Here's how the example bakery's 2025 figures flow between them:
| Figure | Shows up in | Example |
|---|---|---|
| P&L: net income | Cash flow: first line of operating activities | $48,000 |
| P&L: net income | Balance sheet: equity (current-period net income) | $48,000 |
| P&L: depreciation | Cash flow: added back (non-cash). Balance sheet: accumulated depreciation rises by the same amount | $18,000 |
| Cash flow: ending cash | Balance sheet: cash and cash equivalents | $34,700 |
| Cash flow: loan principal repaid | Balance sheet: total loan balances fall | $91,500 → $77,500 |
| Cash flow: owner distributions | Balance sheet: subtracted in equity (never an expense on the P&L) | $30,000 |
The bakery earned $48,000 in 2025, yet its cash fell from $38,400 to $34,700. Operations brought in $66,300, but it spent $26,000 on kitchen equipment and a delivery van, repaid loan principal and paid its owners $30,000. Profit and cash are different things, and you need all three statements to see both.
Shortcut: save your balance sheet (with a prior-date column) and your P&L, then click Build from my balance sheet + P&L on the cash flow template. It calculates every operating, investing and financing line for you.
What banks and SBA lenders ask for
- Three years of history plus a current interim statement. SBA's lending rules for 7(a) loans base repayment analysis, for existing businesses, on “the three most recent years of historical financial information (tax returns or balance sheet with debt schedule and income statement) plus an interim financial statement.” Interim financial statements “must be dated within 120 days of submission to SBA.” (SBA SOP 50 10 8.1, effective Oct. 1, 2026)
- Balance sheet and P&L dated the same day. SBA's 7(a) submission checklist asks for a “Current Income Statement and Balance Sheet – (both must be dated as of the same date within 120 days of submission to SBA).” Set the balance sheet date and the P&L period end to the same date. (SBA 7(a) Loan Submission Checklist, May 2024)
- Ratios lenders calculate. The SOP lists current ratio, debt to tangible net worth and debt service coverage among the benchmark ratios. Debt service coverage is EBITDA divided by required principal and interest payments on all business debt. Standard 7(a) loans need at least 1.15:1 and 7(a) Small Loans at least 1.10:1. The balance sheet and P&L templates calculate all three.
- Projections for new businesses. The checklist asks for “Cash Flow Projections with supporting assumptions which reflect positive cash flow within two years” for all new businesses. SBA's business-plan guidance says that if a business is already established, the plan should include “income statements, balance sheets, and cash flow statements for the last three to five years.” (SBA: Plan your business)
- A personal financial statement from owners. For 7(a) loans, SBA Form 413 is completed by each proprietor, general partner, LLC managing member, owner of 20% or more, and guarantor. That form is separate from the business statements on this page. (SBA Form 413)
Your lender decides the exact document list. SBA's 7(a) page notes the contents of a loan application “vary depending on the size of the loan and the lender's processing method.” Statements you prepare yourself are normally labeled unaudited. Use the footnote field to say so.
Frequently asked questions
What is a cash flow statement?
What's the difference between the direct and indirect method?
Why did my cash go down even though I made a profit?
How do I calculate the changes in working capital?
Can I create a cash flow statement from a balance sheet and income statement?
Is this a cash flow statement or a cash flow projection?
Where do interest, owner draws and loan payments go?
What is free cash flow?
Is there a free cash flow statement template in Excel?
Is my data stored or shared?
Official Sources
Figures checked against these sources on 2026-10-03- SEC: Beginners' Guide to Financial Statements — assets = liabilities + equity; the three cash flow sections; ratio definitions
- IRS Publication 583, Starting a Business and Keeping Records — income statements, balance sheets and supporting records
- IRS: How long should I keep records? — 3, 6, 7 years or indefinitely depending on the situation
- SBA SOP 50 10 8.1 (effective Oct. 1, 2026) — historical statements, 120-day interim rule, ratio benchmarks, debt service coverage
- SBA 7(a) Loan Submission Checklist (May 2024) — same-date income statement and balance sheet; projections for new businesses
- SBA: Plan your business (financial projections) — 3 to 5 years of statements for established businesses
- SBA Form 413, Personal Financial Statement — form version 05-24, OMB expiration 08/31/2027
- SCORE Financial Management Workbook — current, quick and debt-to-equity ratio guidance (pp. 53–54)
- Deloitte DART: ASC 230, form and content of the statement of cash flows — direct method encouraged; many entities apply the indirect method
- IFRS Foundation: IAS 7 Statement of Cash Flows — direct or indirect method permitted
Related Resources on This Site
Related by industry
Helpful guides
- Estimated Taxesquarterly estimated taxes — when and how to pay
- Income Taxstate income tax rates and brackets
- Deductionsbusiness tax deductions checklist
- 1099 vs W-21099 vs W-2 — when to use each