Sheet 1: Monthly Cashflow Statement

	
	
	
	

		
CASH FLOW STATEMENT
		
	

		
Actual for past 12 months
		
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		
Month 1
		
Month 2
		
Month 3
		
Month 4
		
Month 5
		
Month 6
		
Month 7
		
Month 8
		
Month 9
		
Month 10
		
Month 11
		
Month 12
	
	

		
Beginning Cash Balance
		


		


		
 -   
		
#NAME?
		
#NAME?
		
#NAME?
		
#NAME?
		
#NAME?
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
	
	

		
Cash Inflows (Income):
		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Cash Collections
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Credit Collections
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Investment Income
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Other:
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
   Total Cash Inflows
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
	
	

		
Available Cash Balance
		


		
 -   
		
 -   
		
#NAME?
		
#NAME?
		
#NAME?
		
#NAME?
		
#NAME?
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
	
	

		
Cash Outflows (Expenses):
		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Advertising
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Bank Service Charges
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Insurance
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Interest
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Inventory Purchases
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Maintenance & Repairs
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Operating Supplies
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Payroll
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Payroll Expenses
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Sales Commissions
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Professional Fees
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Communications Equip.
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Rent
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Office Supplies
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Permits & Licenses
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Utilities & Telephone
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Travel
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Taxes
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Other:
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
   Subtotal
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
	
	

		
Other Cash Out Flows:
		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Capital Purchases
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Loan Principal
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Owner's Draw
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Other:
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
   Subtotal
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
	
	

		


		
   Total Cash Outflows
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
		
 -   
	
	

		
Ending Cash Balance
		


		
 -   
		
 -   
		
#NAME?
		
#NAME?
		
#NAME?
		
#NAME?
		
#NAME?
		
 -   
		
 -   
		
 -   
		
 -   
		
 -