Need some help creating a pro forma balance sheet so I can learn the process!

Use the following industry average ratios to construct a pro forma balance sheet for Carlos Menza, Inc.

Total asset turnover 1.9 times Average collection period (assume a 365-day year) 9.2 days Fixed asset turnover 4.5 times Inventory turnover (based on cost of goods sold) 2.5 times Current ratio 1.9 times Sales (all on credit) $3.94 million Cost of goods sold 75% of sales Debt ratio 55%

thank you!