business plan

3-cash-flow-statement.xlsx

CashFlowStatement

	[Company Name]
	Cash Flow Statement
		For the Year Ending	12/31/15
		Cash at Beginning of Year	15,700
	Operations
	Cash receipts from
		Customers	693,200
		Other Operations
	Cash paid for
		Inventory purchases	(264,000)
		General operating and administrative expenses	(112,000)
		Wage expenses	(123,000)
		Interest	(13,500)
		Income taxes	(32,800)
	Net Cash Flow from Operations		147,900
[42]	Investing Activities
	Cash receipts from
		Sale of property and equipment	33,600
		Collection of principal on loans
		Sale of investment securities
	Cash paid for
		Purchase of property and equipment	(75,000)
		Making loans to other entities
		Purchase of investment securities
	Net Cash Flow from Investing Activities		(41,400)
	Financing Activities
	Cash receipts from
		Issuance of stock
		Borrowing
	Cash paid for
		Repurchase of stock (treasury stock)
		Repayment of loans	(34,000)
		Dividends	(53,000)
	Net Cash Flow from Financing Activities		(87,000)
	Net Increase in Cash		19,500
		Cash at End of Year	35,200

	[Company Name]
	3-Year Cash Flow
		For the Year Ending	12/31/14	12/31/15	12/31/16
		Cash at Beginning of Year	15,700	35,200	56,650
		Cash at End of Year	35,200	56,650	80,245
	Operations		2014	2015	2016
	Cash receipts from
		Customers	693,200	762,520	838,772
		Other operations
	Cash paid for
		Inventory purchases	(264,000)	(290,400)	(319,440)
		General operating and administrative expenses	(112,000)	(123,200)	(135,520)
		Wage expenses	(123,000)	(135,300)	(148,830)
		Interest	(13,500)	(14,850)	(16,335)
		Income taxes	(32,800)	(36,080)	(39,688)
	Net Cash Flow from Operations		147,900	162,690	178,959
[42]	Investing Activities
	Cash receipts from
		Sale of property and equipment	33,600	36,960	40,656
		Collection of principal on loans
		Sale of investment securities
	Cash paid for
		Purchase of property and equipment	(75,000)	(82,500)	(90,750)
		Making loans to other entities
		Purchase of investment securities
	Net Cash Flow from Investing Activities		(41,400)	(45,540)	(50,094)
	Financing Activities
	Cash receipts from
		Issuance of stock
		Borrowing
	Cash paid for
		Repurchase of stock (treasury stock)
		Repayment of loans	(34,000)	(37,400)	(41,140)
		Dividends	(53,000)	(58,300)	(64,130)
	Net Cash Flow from Financing Activities		(87,000)	(95,700)	(105,270)
	Net Cash Flow		19,500	21,450	23,595

	[Company Name]
	12-Month Cash Flow
		Period Beginning	1/1/14	2/1/14	3/1/14	4/1/14	5/1/14	6/1/14	7/1/14	8/1/14	9/1/14	10/1/14	11/1/14	12/1/14
		Period Ending	1/31/14	2/28/14	3/31/14	4/30/14	5/31/14	6/30/14	7/31/14	8/31/14	9/30/14	10/31/14	11/30/14	12/31/14
		Cash at Beginning of Period	15,700	17,325	17,325	17,325	17,325	17,325	17,325	17,325	17,325	17,325	17,325	17,325
		Cash at End of Period	17,325	17,325	17,325	17,325	17,325	17,325	17,325	17,325	17,325	17,325	17,325	17,325
	Operations		41640.0	41671.0	41699.0	41730.0	41760.0	41791.0	41821.0	41852.0	41883.0	41913.0	41944.0	41974.0
	Cash receipts from
		Customers	57,767
		Other operations
	Cash paid for
		Inventory purchases	(22,000)
		General operating and admin expenses	(9,333)
		Wage expenses	(10,250)
		Interest	(1,125)
		Income taxes	(2,733)
	Net Cash Flow from Operations		12,325	0	0	0	0	0	0	0	0	0	0	0
[42]	Investing Activities
	Cash receipts from
		Sale of property and equipment	2,800
		Collection of principal on loans
		Sale of investment securities
	Cash paid for
		Purchase of property and equipment	(6,250)
		Making loans to other entities
		Purchase of investment securities
	Net Cash Flow from Investing Activities		(3,450)	0	0	0	0	0	0	0	0	0	0	0
	Financing Activities
	Cash receipts from
		Issuance of stock
		Borrowing
	Cash paid for
		Repurchase of stock (treasury stock)
		Repayment of loans	(2,833)
		Dividends	(4,417)
	Net Cash Flow from Financing Activities		(7,250)	0	0	0	0	0	0	0	0	0	0	0
	Net Cash Flow		1,625	0	0	0	0	0	0	0	0	0	0	0