Free Excel templates

Indirect Method Cash Flow Statement Template

Two balance sheets, an income statement and the notes in; the indirect statement of cash flows out, proved against a direct build and a Checks tab.

Type two balance sheets, an income statement and the note data once, and the workbook prepares the statement of cash flows by the indirect method: a worksheet that sends every balance sheet change to one destination, working capital lines bridged through acquisitions, translation and noncash items, investing and financing tied to the notes, and a direct build summed from tagged cash entries that must agree to the dollar. The worked case starts from net income of $11,042,775 for 2026.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 147 free models.

Statement_of_Cash_Flows_Model.xlsx (46 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This model goes with The Statement of Cash Flows Handbook, which explains the method behind it, chapter by chapter.

Get the PDF edition → See the book

Want every model at once?

The Financial Model Library: all 148 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).

Get the Library, $79 →

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

What is in the file

9 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.

Inputs
Balance sheets, income statements, exchange rates, note data and the cash entries summed by tag, in yellow cells; the true-up switch in column D.
Worksheet
Every balance sheet change spread across operating, investing, financing, noncash, acquisition and translation, with a residual that must read zero.
Indirect
The statement by the indirect method: net income, noncash items, working capital lines, investing, financing and the cash roll.
Direct
The operating, investing and financing lines summed from the tagged cash entries, with a second build of each operating line.
Bridges
Each working capital line from the balance sheet change to the statement line; the acquisition note; the property and equipment roll-forward.
ASU 2016-15
One block per classification issue: prepayment costs, zero-coupon settlement, contingent consideration, insurance proceeds, life insurance, equity method distributions, beneficial interests.
FX
Translation of the euro subsidiary and the effect of exchange rate changes on cash, by component and by difference.
Noncash and disclosures
Cash reconciliation to the balance sheet, noncash investing and financing activities, interest and income taxes paid, supplier finance roll-forward.
Checks
Direct equals indirect, the cash roll, the bridges and the disclosures, with an overall status.

What the worked case returns

MeasureValue
Net income 2026$11,042,775
Subtotal before working capital$19,755,875
Total working capital changes$3,221,400
Net cash from operating activities, indirect$22,977,275
Net cash from operating activities, direct$22,977,275
Net cash used in investing activities (outflow, $)25,215,000
Net cash from financing activities$11,586,800
Total cash at year end, including restricted cash$19,291,788

The accounts receivable line is not the balance sheet change. Receivables rose by $592,000 on the balance sheet, but $3,200,000 came in with an acquisition and translation of a euro subsidiary took $253,000 off the balance; what is left is a decrease, so the statement shows an inflow of $2,355,000.

How to use it on your own case

  1. Enter the opening and closing balance sheets, the income statement and the note data in the yellow cells of Inputs.
  2. Enter the cash entries summed by tag (operating, investing or financing) in columns G to K of Inputs.
  3. Read the Worksheet: every row must leave a residual of zero.
  4. Read the Indirect tab and compare its operating total with the Direct tab; the two must agree to the dollar.
  5. Check that the Checks tab reads ALL PASS before you take any figure into a statement or a memo.

Questions people ask about it

Why does the indirect method not just use the change in each balance?

Because part of the change did not come from operations: balances acquired with a business, translation of a foreign subsidiary and noncash items such as capital expenditure payables. In the case, the receivables line is $2,355,000, not the balance sheet change of $592,000.

How do I know the statement is right?

Build it a second way. The Direct tab sums the cash entries tagged when they were posted and must give the same operating total as the indirect build: $22,977,275 in the case. Then tie total cash to the balance sheet, cash and cash equivalents plus restricted cash.

Does the template work for an investment fund?

It is built for an operating company that prepares a classified statement under ASC 230. Investment companies that meet the conditions to omit the statement, or that present it differently, are outside its scope.

Go further

The free workbooks of The Statement of Cash Flows Handbook go further: the full companion set, blank models and the worked cases of the book.

See the book and its free files →

Other free templates

This template goes with The Statement of Cash Flows Handbook. See the book.