ZDOM + 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 typed in! Use color/shading & borders to make your spreadsheet look esthetically pleasing. Be sure to show your subtotals & change in cash in the yellow highlighted cells below You must also name your worksheet on the bottom tab (where it says Sheetl) that indicates its purpose to someone outside of this class Grading Rubries Plats Mathematical Accuracy 30 Use of Cell References 20 Correct Formatting 20 Use of Shading Color/Borders 15 Student Name is typed in 5 Label Sheet on Bottom Tab 5 Overall Neatness & Layout 5 Total points 100 Additional Input Data for 2014 Effective Tax rate 35.00 Stock dividends paid S 2.000 Depreciation Expense 4.000 Balance Sheet Assets 2014 2013 Change Source Use Operating Investing Financing 5 10,000 6,000 Accounts Receivable 5 1,500 Inventory $ 10.000 Net Property. Plant & Equipment $ 3,0005 9,000 Total Assets 5 32.000 26,500 OUTPUT 35.00% 2,000 4,000 OUTPUT Source Use Operating Investing Financing 2014 10,000 $ 6,000 $ 8,000 $ 8,000 $ 32,000 $ 2013 Change 6,000 1,500 10,000 9,000 26,500 Effective Tax rate Stock dividends paid $ Depreciation Expense $ Balance Sheet Assets Cash Accounts Receivable Inventory Net Property, Plant & Equipment Total Assets Liabilities & Stockholders' Equity Accounts Payable Accrued Expenses Long-term Note Payable Total Debt Preferred Stock Common Stock Retained Earnings Total Liabilities & Stockholders' Equity $ Income Statement 2014 Sales $ Cost of Goods Sold 5 Gross Profit $ Operating Expenses (including depreciation) $ EBIT $ Interest Expense s EBT $ $ Net income from continuing operations 4,000 $ 1,000 $ 10,000 $ 15,000 $ 800 $ 10,000 $ 6,200 $ 32,000 $ 5.800 2,000 10,000 17,800 700 5,000 3.000 26 500 change in cash CFO CHI CFF 5 135.000 100.000 27,000 16.000 11.000 3.000 8.000 2,800 5,200 ZDOM + 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 typed in! Use color/shading & borders to make your spreadsheet look esthetically pleasing. Be sure to show your subtotals & change in cash in the yellow highlighted cells below You must also name your worksheet on the bottom tab (where it says Sheetl) that indicates its purpose to someone outside of this class Grading Rubries Plats Mathematical Accuracy 30 Use of Cell References 20 Correct Formatting 20 Use of Shading Color/Borders 15 Student Name is typed in 5 Label Sheet on Bottom Tab 5 Overall Neatness & Layout 5 Total points 100 Additional Input Data for 2014 Effective Tax rate 35.00 Stock dividends paid S 2.000 Depreciation Expense 4.000 Balance Sheet Assets 2014 2013 Change Source Use Operating Investing Financing 5 10,000 6,000 Accounts Receivable 5 1,500 Inventory $ 10.000 Net Property. Plant & Equipment $ 3,0005 9,000 Total Assets 5 32.000 26,500 OUTPUT 35.00% 2,000 4,000 OUTPUT Source Use Operating Investing Financing 2014 10,000 $ 6,000 $ 8,000 $ 8,000 $ 32,000 $ 2013 Change 6,000 1,500 10,000 9,000 26,500 Effective Tax rate Stock dividends paid $ Depreciation Expense $ Balance Sheet Assets Cash Accounts Receivable Inventory Net Property, Plant & Equipment Total Assets Liabilities & Stockholders' Equity Accounts Payable Accrued Expenses Long-term Note Payable Total Debt Preferred Stock Common Stock Retained Earnings Total Liabilities & Stockholders' Equity $ Income Statement 2014 Sales $ Cost of Goods Sold 5 Gross Profit $ Operating Expenses (including depreciation) $ EBIT $ Interest Expense s EBT $ $ Net income from continuing operations 4,000 $ 1,000 $ 10,000 $ 15,000 $ 800 $ 10,000 $ 6,200 $ 32,000 $ 5.800 2,000 10,000 17,800 700 5,000 3.000 26 500 change in cash CFO CHI CFF 5 135.000 100.000 27,000 16.000 11.000 3.000 8.000 2,800 5,200
