=SUM(B2:B7) Apply similarly for Investing ( =SUM(B11:B12) ) and Financing ( =SUM(B16:B19) ). This formula links the three sections.
=B8+B13+B20 Add the beginning cash balance to the net change.
Open Excel, type the format above, enter your numbers, and watch your cash position reveal itself instantly.
=B22+B23 If you add a "Cash Flow Margin" ratio (Net Cash from Ops / Revenue), prevent #DIV/0! errors when revenue is zero.
