Question

Student Name Orca Industries Assignment Instructions: Below are the two most recent balance sheets and most recent income statement for Orca Industries. Create & complete a cash flow worksheet (NOT the actual Statement of Cash Flow)!! Type in your name in the blue highlighted area above. You MUST use cell references for your answers and format all currency as US $ with zero decimal places. There should be NO numbers simply type Use color/shading & borders to make your spreadsheet look aesthetically pleasing. Be sure to show your subtotals & change in cash in the yellow hig You must also name your worksheet on the bottom tab (where it says Sheet!) that indicates its purpose to someone outside of this class, Grading Rubrics Points Mathematical Acccuracy Use of Cell References Correct Formatting Use of Shading/Color/Borders Student Name is typed in Label Sheet on Bottom Tab Overall Neatness & Layout 100 30 20 20 15 5 5 5

Answer 1

Assets	2014	2013	Change	Source	Use		Operating	Investing	Financing
Cash	10000	6000	4000	Change in Cash Flow
Account Receivables	6000	1500	4500	Increse in AR results in Stock of Cash	Less from Opening Cashflow		-4,500
Inventory	8000	10000	2000	Decrese in Inventory results in Release of Cash	Add		2,000
Net Property Plant & Equipemnt	8000	9000	-3000	Opening less Dep. Of 4,000 less Closing balance gives us investment in PPE	Less in Investing Activities			-3,000
Total Assets (A)	32000	26500
Liabilities & Share Holders Equity
Account Payables	4000	5800	1800	Spent of Cash to Clear the Dues	Less from Opening Cashflow		-1,800
Accured Exp.	1000	2000	1000	Spent of Cash to Clear the Dues	Less from Opening Cashflow		-1,000
Long term Note Payable	10000	10000	0		No change
Total Debt	15000	17800
Preferred Stock	800	700	-100	Receipt of Financing	Add				100
Common Stock	10000	5000	-5000	Increse in Stock implies Cash from Sh	Add				5,000
Retained Earning	6200	3000	-3200
Payment of Stock Dividens				Payment to Stock Holders	Less				-2,000
Interest Expense After Tax				Payment to Stock Holders	Less				-1,950
Total Liabilities (B)	32000	26500
			Change in Cash			-5,300	-3,000	1,150
Cash Flow Statement
Particulars		Amount	Amount
Opening Balance of Cash	A		6000
Net Profit After Tax		5200
Add : Dep.		4000
Add : Interest Expenses after Tax		1950
Total	B	11150	11150
Operating Activiies	C		-5,300
investing Actitivities	D		-3,000
Financing Activities	E		1,150
Changes in Cash			4,000
Closing Cash Balance			10,000