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

$2022$Sales $9,000,000$ Cost Of Goods Sold $-\%$ of Sales $60\%$ SG&A $1,500,000$ Short term Notes $150,000,$Debt $($long term$)$ issues $($borrowed$)850,000,$ Interest Rate short and lomg term $20\%$ Iissued shared price $40\mathrm{.}00,$ Share Issued $50,000,$ Receivable $2,000,000,000,$Inventory $1,250,000$ Property, Payables $1,400,000,-$PPE $3,000,000,$ depreciation $25\%,$ current taxes paid $75,000,$ dividend paid $25,000$

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 $2022$ retained earnings. Similarly, you need the cash flow statement to get the $2022$ cash level $.$ Interest in short term debt is the same as for long term debt.