Instructions: Below are the two most recent balance sheets and most recent income statement for Orca Industries. Create & complete a cash flow worksheet (the section below labeled OLIPUT) >Type in your name in the area 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! >Be creative! Examples: Change the font size/style, use additional color and or shading & borders; make your spreadsheet look aesthetically pleasing. >You must also give a descriptive title to your worksheet on the bottom tab (where it says Sheetl) that indicates its purpose to someone outside of this class. Do not use your name as the title. Grading Rubrks Points 1 Mathematical Acccuracy 30 2 Use of Cell References 20 3 Correct Formatting 4 Creativity: Use of Shading Color/Borders Student Name is typed in 6 Label Sheet on Bottom Tab 7 Overall Neatness & Layout 5 Total points 100 20 15 5 5 35.00 $ 0 1 Additional Input Data for 2019: 2 Effective Tax rate 3 Stock dividends paid 4 Depreciation Expense 5 Balance Sheet 7 Assets 2.000 4.000 OUTPUT Source Use Operating Investing Financing $ $ $ $ $ 2019 10,000 $ 6,000 $ 8,000 $ 8,000 $ 32.000 $ 2018 Change 6,000 1 500 10,000 9,000 26,500 Accounts Receivable 0 Inventory 1 Net Property, Plant & Equipment 2 Total Assets 3 4 Uabilities & Stockholders' Equity s Accounts Payable 6 Accrued Expenses 7 Long term Note Payable 3 Total Debt 9 Preferred Stock 0 Common Stock 1 Retained Earnings 2 Total abilities & Stockholders' Equity 5,800 2,000 10,000 17,800 $ $ $ $ $ $ $ $ 4,000 $ 1,000 $ 10,000 $ 15,000 $ 800 $ 10,000 $ 6,200 $ 32.000 $ 700 5.000 3,000 26,500 change in cash OFO OFI OFF 4 Income Statement 2019 6 Sales 7 Cost of Good Sold 8 Gross Profit 9 Operating Expenses linduding depreciation) O EBIT 1 Interest Expense 2 EBT 3 Tax 4 Net Income from continuing operations $ $ $ $ $ $ $ $ 135.000 108.000 27,000 16,000 11 000 3,000 8,000 2.800 5,200 $