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 You MUST use cell references for your answers and format all currency as US S with zero decimal places. There should be NO numbers simply typed in! Use color/shading & borders to make your spreadsheet look aesthetically pleasing. Be sure to show your subtotals & change in cash in the yellow highlighted cells belo 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 Rubrics Points Mathematical Acecuracy 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.00N Stock dividends paid S 2,000 Depreciation Expense OUTPUT $ 4,000 Balance Sheet Assets 2014 2013 Change Source Use Operating Investing Financing Cash $ 10,000 $ 6,000 Accounts Receivable $ 6,000 $ 1,500 Inventory $ 8,000 $ 10,000 Net Property, Plant & Equipment $ 8,000 $ 9.000 Total Assets $ 32,000 $ 26,500 Liabilities & Stockholders' Equity Accounts Payable $ 4,000 5,800 Accrued Expenses 5 1,000 $ 2.000 Long-term Note Payable 10,000 $ 10,000 Total Debt 15,000 $ 17,800 $ Preferred Stock 700 800S 10.000 $ 5.000 Common Stock 6.2005 3,000 Retained Earnings $ 32,000 $ 26,500 Total Liabilities & Stockholders' Equity CFI CFF change in cash Income Statement - CFO Macbook 8,000 $ 8,000 $ 32,000 $ 10,000 9,000 26,500 Inventory Net Property, Plant & Equipment Total Assets Liabilities & Stockholders' Equity Accounts Payable $ Accrued Expenses $ Long-term Note Payable S Total Debt $ Preferred Stock S Common Stock $ Retained Earnings $ Total Liabilities & Stockholders' Equity $ Income Statement 2014 Sales $ Cost of Goods Sold Gross Profit $ Operating Expenses (including depreciation) $ EBIT S $ Interest Expense EBT $ $ Tax $ 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 135,000 108,000 27,000 16,000 11,000 3,000 8,000 2,800 5,200
