Cash Flow Tracker
Dark gray cells will be calculated for you. You do not need to enter anything into them. Initial Cash Balance Cash flow summary Initial cash balance Final cash balance $ $ 78,925.34 403,473.34
Operating cash flow
Operating income Customer receipts Miscellaneous receipts Total operating income Operating expenses Inventory costs Insurance Lease Advertising Payroll Other Interest paid Taxes Total operating expenses $ 16,528.00 8,213.00 16,528.00 8,213.00 239,257.00 7,458.00 1,112.00 7,458.00 304,767.00 $ $ 416,528.00 8,213.00 424,741.00
$ Op
$
119,974.00
Investment cash flow
Investment income Sale of property Liquidation of investments Total investment income Investment expenses Payments Capital expenditures Purchases Other Total investment expenses
$ $ $
216,528.00 8,213.00 224,741.00 5,528.00 8,213.00 6,528.00 8,213.00 28,482.00 196,259.00
Financing cash flow
Financing income New borrowing Stock issuance Capital contributions Total financing income Financing expenses Loan repayments Dividends paid Other distributions Total financing expenses
$ $
$
$ $
16,528.00 8,213.00 16,528.00 41,269.00 8,213.00 16,528.00 8,213.00 32,954.00
$
$
8,315.00
Cash Flow by Category
Financing cash flow $8,315.00 2%
Initial cash balance $78,925.34 20%
Investment cash flow $196,259.00 48% Operating cash flow $119,974.00 30%