can you do this in excel?

E F G H 1 JX B C D 5 Balance Sheet 6 Cash 7 Short-Term investments 8 Net Receivables 9 Inventory 10 Prepaid expenses 11 Total Current Assets 12 Total Current Liabilities 13 14 Income Statements 15 Net credit Sales 16 Cost of Goods Sold 17 18 19 a Current Ratio 20 21 b) Acid-Test Ratio 22 23 C) Inventory Turnover 15,000 11,000 54,000 77,000 15,000 172,000 133,000 20,000 27,000 73,000 69,000 9,000 198,000 93,000 462,000 315,000 Current Asset/Current Liabilites Cash+Short Term Inventory/Current Liabilities Cost of Goods Sold/Average Inventory)= Days in inventory 385/Inventory Tumover 25 d) 26 27 261) 29 30 31 Gross Profit percentage Net credit sales Cost of Goods sold Net credit sales