Build operating, investing, and financing cash flow statements with waterfall charts and free cash flow calculation.
Separate cash movements by why cash changed, then review both a statement and a visual bridge. The builder totals entries assigned to operating, investing, and financing activities, combines those section totals into net cash movement, plots their contributions in a waterfall chart, and calculates free cash flow from operating cash flow and capital spending. It records cash activity, not profit-and-loss entries. A common mistake is including depreciation or another noncash charge as though cash moved, which distorts the totals.
A concrete input and expected output from the current implementation.
Input
Operating: Customer receipts: $8,000 Supplier payments: -$5,000 Investing: Equipment purchase: -$2,000 Financing: Loan proceeds: $1,000
Expected output
Operating cash flow: $3,000 Investing cash flow: -$2,000 Financing cash flow: $1,000 Net change in cash: $2,000 Free cash flow: $1,000 Waterfall: +$3,000, then -$2,000, then +$1,000, ending at +$2,000
Operating cash flow is $8,000 - $5,000 = $3,000. The three sections reconcile to $3,000 - $2,000 + $1,000 = $2,000, while free cash flow is $3,000 of operating cash flow less $2,000 of capital expenditure.
Add each receipt or payment to the section that explains its source: day-to-day operations, purchases or sales of long-lived assets and investments, or funding from owners and lenders. Within each section, inflows add and outflows subtract. The operating, investing, and financing subtotals therefore preserve both the amount and direction of each cash movement.
Net cash movement is the arithmetic sum of the three section subtotals. The waterfall chart presents the same progression, allowing each section's contribution to be checked visually against the statement. Free cash flow is operating cash flow less capital expenditures, so it can differ from net cash movement because financing and other investing flows are outside that calculation.
No. Loan proceeds belong in financing activity and increase net cash movement, but they do not increase free cash flow under the operating-cash-flow-less-capital-expenditures calculation. Conversely, an equipment purchase reduces free cash flow as capital expenditure. Do not assume every investing outflow is capital expenditure, since acquisitions and investment purchases can represent different activities.
No. The builder organizes and totals the entries supplied, but it cannot establish whether transactions are complete, correctly classified, or presented under the reporting framework applicable to the entity. Use it for drafting and reconciliation. Published financial statements may also require comparative periods, accounting policy disclosures, and separate disclosure of material noncash investing and financing transactions.
The example and behavioral notes were checked against the browser implementation. Standards and primary references below define the relevant format, formula, or platform behavior.
Calculate gross, operating, and net profit margins from cost and revenue with breakeven analysis.
Convert between annual salary and hourly rate with adjustments for work hours, overtime, and benefits.
Calculate sales tax amounts, tax-inclusive and tax-exclusive prices for any tax rate or jurisdiction.
Calculate return on investment from initial cost and final value with annualized ROI and comparison tables.
Convert between markup and margin percentages, calculate selling price, and compare pricing strategies.
Convert numeric amounts to written words for invoices, checks, and legal documents in multiple currencies.