Statement Format In Excel With Formula Free Download: Cash Flow

=B8+B13+B20 Add the beginning cash balance to the net change.

=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

=B22+B23 If you add a "Cash Flow Margin" ratio (Net Cash from Ops / Revenue), prevent #DIV/0! errors when revenue is zero. =B8+B13+B20 Add the beginning cash balance to the net change