Answer the Question Below as TYPED or in Excel please Not as pictures Hand Writing

B- On 30/11/2012 of the ABC Company had the following account balances in its adjusted trial balance. ABC Company uses a periodic system. On 30/11/2012 merchandise inventory is $52,600.(4 marks) Freight-in Inventory Purchases Purchase Discounts Purchase Returns and Allowances Sales Revenue Sales Returns and Allowances $ 7,500 40,000 585,000 6,300 2,700 1,000,000 20,000 Required: On 30/11/2012, prepare an income statement of the ABC Company through gross profit