please help me out! this has now become very urgent!!!

Data for adjusting the accounts are as follows: (a) Factory overhead to be applied to work in process ending inventory (b) Estimate of this year's sales that will be returned next year (c) Cost of goods expected to be returned (d) Interest receivable (e) Interest payable (f) Estimate of uncollectible accounts, based on an aging of accounts receivable (g) Office supplies consumed (h) Factory supplies consumed (i) Factory building depreciation (j) Factory equipment depreciation (k) Overapplied factory overhead (I) Provision for corporate income taxes $3,100700330756102,9302,9003,3005,0004,0001,4706,100 (m) Physical counts of the inventories agreed with the amounts in the books Additional information needed to prepare the financial statements is as follows: Beginning inventories: Finished goods, January 1 Work in process, January 1 Materials inventory, January 1 Materials purchases for the year Direct labor Actual factory overhead Indirect materials charged to production $18,0007,3009,50051,50060,00090,9303,400 Required 1. Prepare a 6-column spreadsheet. 2. Prepare the following financial statements and schedule: a. income statement b. schedule of cost of goods manufactured c. statement of retained earnings d. balance sheet Data for adjusting the accounts are as follows: (a) Factory overhead to be applied to work in process ending inventory (b) Estimate of this year's sales that will be returned next year (c) Cost of goods expected to be returned (d) Interest receivable (e) Interest payable (f) Estimate of uncollectible accounts, based on an aging of accounts receivable (g) Office supplies consumed (h) Factory supplies consumed (i) Factory building depreciation (j) Factory equipment depreciation (k) Overapplied factory overhead (I) Provision for corporate income taxes $3,100700330756102,9302,9003,3005,0004,0001,4706,100 (m) Physical counts of the inventories agreed with the amounts in the books Additional information needed to prepare the financial statements is as follows: Beginning inventories: Finished goods, January 1 Work in process, January 1 Materials inventory, January 1 Materials purchases for the year Direct labor Actual factory overhead Indirect materials charged to production $18,0007,3009,50051,50060,00090,9303,400 Required 1. Prepare a 6-column spreadsheet. 2. Prepare the following financial statements and schedule: a. income statement b. schedule of cost of goods manufactured c. statement of retained earnings d. balance sheet