please show work!!

12. (24 pts) Using the ratios as a basis for planning for next year, forecast the Balance Sheet for the Lilac Company using the projected information below. Round to the nearest dollar. Fill in all blanks and show all work. Sales Cash Accruals Gross margin DSO Inventory turnover (Based on COGS) Total Asset turnover Current ratio Debt: Equity $20,000,000 $750,000 $60,000 40% 44 days 6.0X 1.35X 2.5 1:4 BALANCE SHEET Next Year ASSETS Cash Accounts receivable Inventory Current Assets Net fixed assets Total Assets LIABILITIES & EQUITY Accounts payable Accruals Current Liabilities Long-Term Debt Equity Total Liabilities & Equity