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.
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).
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
Measure
Value
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
Enter the opening and closing balance sheets, the income statement and the note data in the yellow cells of Inputs.
Enter the cash entries summed by tag (operating, investing or financing) in columns G to K of Inputs.
Read the Worksheet: every row must leave a residual of zero.
Read the Indirect tab and compare its operating total with the Direct tab; the two must agree to the dollar.
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.
LCR and NSFR calculatorLiquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculatorStandardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard modelA points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysisList price to pocket price for one account and a whole company: nine leakages, ranked and added up.