Answer all the questions. Your work must be printed. Exercise The Skywalker Industries has incorporated and started operations I ; it went public in with a common stock Offering. The following financial information has been gathered on the last day of the year, December

 

  Sales  Cost Of Goods Sold  of Sales  SG&A   Short term Notes Debt long term issues borrowed Interest Rate short and long term  issued shared price  Share Issued  Receivable Inventory  Property, Payables PPE  depreciation   current taxes paid  dividend paid  

 

 You will find it better to do this exercise in Excel. The data and the initial model financial statements are provided in an Excel file. The model has a lot of missing components, you need to complete it while you add the data. Prepare the Rogue Industries financial statements. The balance sheet basic structure and a partial income statement are given in Excel file. You need to finish the income statement to obtain the  retained earnings. Similarly, you need the cash flow statement to get the  cash level.Interest in short term debt is the same as for long term debt.