IS 5 2.000 Student Name Ora Industries Andment Trans Below are the two most recent balance sheets and most recent income statement for rea Industries Create & complete a cash flow worksheet (NOT the actual Statement of Cash Flow)!! Type in your name in the blue Highlighted area shove You MUST cell references for your answers and format all currency as US S with zero decimal places. There should be NO numbers simply typed in! Une coloshading & borders to make your spreadsheet look esthetically pleasing. Be sure to show your subcons & change in cash in the yellow highlighted cells below You must also name your worksheet on the bottom tab (where it says Sheett) that indicates its purpose to someone outside of this class Gradies Rubries Posts Mathematical Acer Use of Cell References Cerret Ferming Use of Shading Cler/Borders Student Name is typed in Label Sheet Bottom Tab OverNets & Layout Total plants Additional Input Data for 2014 Effective Taxe 15 DON Stock dividends paid Depreciation Tapete OUTPUT 4.000 Balance Sheet Ats 2014 2013 ounge Source Use 3 10.000 000 Accounts Receivable 5 6.000 $ Inventory 5 3.000 $ 10.000 Net Property, Pant & Equiment 5 8.000 $ 9.000 Total Assets $ 2000$ 26 500 biles & Stockholders feuille Accounts Payable $ 4.500 5 S. Accrued Cup 5 1,000 S 2.000 Long-term Note Pay 5 10.000 Total Debt 15,000 $ 17.800 Preferred track S 800 700 Common och 10.000 $ 5.000 Retained Caming 5.2005 1300 Totales Stockholders'uty 2.000 216.100 Income Statement CFO 2014 135.000 Cost of Goods Sold $ 10.000 Gross Profit 5 27.000 Operating Expenses finding depreciation 5 11.000 3.000 50 2.800 5,200 IS 5 2.000 Student Name Ora Industries Andment Trans Below are the two most recent balance sheets and most recent income statement for rea Industries Create & complete a cash flow worksheet (NOT the actual Statement of Cash Flow)!! Type in your name in the blue Highlighted area shove You MUST cell references for your answers and format all currency as US S with zero decimal places. There should be NO numbers simply typed in! Une coloshading & borders to make your spreadsheet look esthetically pleasing. Be sure to show your subcons & change in cash in the yellow highlighted cells below You must also name your worksheet on the bottom tab (where it says Sheett) that indicates its purpose to someone outside of this class Gradies Rubries Posts Mathematical Acer Use of Cell References Cerret Ferming Use of Shading Cler/Borders Student Name is typed in Label Sheet Bottom Tab OverNets & Layout Total plants Additional Input Data for 2014 Effective Taxe 15 DON Stock dividends paid Depreciation Tapete OUTPUT 4.000 Balance Sheet Ats 2014 2013 ounge Source Use 3 10.000 000 Accounts Receivable 5 6.000 $ Inventory 5 3.000 $ 10.000 Net Property, Pant & Equiment 5 8.000 $ 9.000 Total Assets $ 2000$ 26 500 biles & Stockholders feuille Accounts Payable $ 4.500 5 S. Accrued Cup 5 1,000 S 2.000 Long-term Note Pay 5 10.000 Total Debt 15,000 $ 17.800 Preferred track S 800 700 Common och 10.000 $ 5.000 Retained Caming 5.2005 1300 Totales Stockholders'uty 2.000 216.100 Income Statement CFO 2014 135.000 Cost of Goods Sold $ 10.000 Gross Profit 5 27.000 Operating Expenses finding depreciation 5 11.000 3.000 50 2.800 5,200
