HI is anyone here who can help me with this

thank you

Section 4: Financial Stmts for Earthshine, Inc. a) Given the CSV trial balance shown on the worksheet, use Text to Columns to break out the data in Column A into Columns C, D, and E of the Accounting Worksheet. b) Complete the accounting worksheet using Columns F and G to record cost of goods sold and adjust inventory. A physical count of inventory taken at 12/31/2112 was $8,000. c) After you complete the worksheet through Column I, prepare a properly formatted income statement, statement of retained earnings, and balance sheet. The statements are for a single year only, i.e., not comparative. d) Prepare your income statement starting in cell K1, your statement of retained earnings under your income statement, and your balance sheet starting in Cell N1. Present statements using one only column for your numbers. e) You must show a calculation of net sales, either in the income statement or in a separate schedule. f) You must show calculation of cost goods sold (CGS). You may show the calculation as part of the income statement or in a separate schedule that supports your CGS figure. g) The note receivable matures in 2115, unearned revenue will be earned in 2113, the loan payable is due in 2113, and the mortgage payable is due in 2120. h) Miscellaneous income, interest expense and miscellaneous expense are nonoperating items and should be presented below operating income. i) Follow the formatting and presentation guidelines presented in the video lectures. j) Be sure you present your work neatly and using proper formatting to avoid losing points for this section. OS and Adjust Inventory Dr Cr Adjusted Balance Dr Cr Unadjusted Balance Dr Cr 25 000 125.000 75,000 - 5,000 3,500 18,000 17.500 - 3,500 175.000 17,500 25,000 7,000 - - - sunt Description,Dr.Cr th.25000,0 t-Term Investments, 125000,0 punts Receivable, 75000,0 wance for Doubtful Accounts, 0,5000 maid Insurance, 3500,0 mtory, 18000,0 pment, 17500,0 pment - AVD.0,3500 Hing, 175000,0 Sing - AD.0.17500 ,25000,0 Receivable 7000,0 unts Payable,0,32000 ries and Wages Payable,0, 12000 oll Tax Payable,0,1200 merty Tax Payable 0,3500 arned Revenue, 0,5000 Payable,0,8000 gage Payable,0,135000 rred Tax Liability,0,6000 mon Stock 0,10000 tional Paid-In Capital,0,40000 ained Earnings 0,85000 dends, 20000,0 s Revenue,0,1525000 s Discounts, 10000.0 s Returns and Allowances, 7000,0 cellaneous Income,0,3500 chases,613000,0 chases Discounts 0,7000 hases Returns and Allowances 0,2000 asht-In, 19600,0 of goods sold,0,0 ries and Wages Expense,591185,0 oll Tax Expense 45800,0 Expense 24000,0 rance Expense, 9000,0 ght-Out 6750,0 - merty Tax Expense 3500,0 ce Supplies Expense 2750,0 tenance and Repairs Expense,3750,0 Debt Expense,23750,0 reciation Exponse, 7500,0 est Expense 4050,0 Dellaneous Expense,1750,0 me Tax Expense, 36915,0 32,000 12,000 1,200 3,500 5,000 8,000 135,000 6,000 10,000 40,000 85,000 - Account Description Cash Short-Term Investments Accounts Receivable Allowance for Doubtful Accounts Prepaid Insurance Inventory Equipment Equipment - AVD Building Building - AJD Land Note Receivable Accounts Payable Salaries and Wages Payable Payroll Tax Payable Property Tax Payable Unearned Revenue Loan Payable Mortgage Payable Deferred Tax Liability Common Stock Additional Paid In Capital Retained Earnings Dividends Sales Revenue Sales Discounts Sales Returns and Allowances Miscellaneous Income Purchases Purchases Discounts Purchases Returns and Allowances Freight-In Cost of goods sold Salaries and Wages Expense Payroll Tax Expense Rent Expense Insurance Expense Freight-Out Property Tax Expense Office Supplies Expense Maintenance and Repairs Expense Bad Debt Expense Depreciation Expense Interest Expense Miscellaneous Expense Income Tax Expense Totals 20,000 1,525,000 10,000 7,000 3,500 613,000 - 7,000 2,000 19,500 - - - - 591 185 45,800 24,000 9.000 6,750 3,500 2.750 3,750 23.750 7,500 4,050 1.750 36.915 1,901,200 - - 1,901,200 Section 4: Financial Stmts for Earthshine, Inc. a) Given the CSV trial balance shown on the worksheet, use Text to Columns to break out the data in Column A into Columns C, D, and E of the Accounting Worksheet. b) Complete the accounting worksheet using Columns F and G to record cost of goods sold and adjust inventory. A physical count of inventory taken at 12/31/2112 was $8,000. c) After you complete the worksheet through Column I, prepare a properly formatted income statement, statement of retained earnings, and balance sheet. The statements are for a single year only, i.e., not comparative. d) Prepare your income statement starting in cell K1, your statement of retained earnings under your income statement, and your balance sheet starting in Cell N1. Present statements using one only column for your numbers. e) You must show a calculation of net sales, either in the income statement or in a separate schedule. f) You must show calculation of cost goods sold (CGS). You may show the calculation as part of the income statement or in a separate schedule that supports your CGS figure. g) The note receivable matures in 2115, unearned revenue will be earned in 2113, the loan payable is due in 2113, and the mortgage payable is due in 2120. h) Miscellaneous income, interest expense and miscellaneous expense are nonoperating items and should be presented below operating income. i) Follow the formatting and presentation guidelines presented in the video lectures. j) Be sure you present your work neatly and using proper formatting to avoid losing points for this section. OS and Adjust Inventory Dr Cr Adjusted Balance Dr Cr Unadjusted Balance Dr Cr 25 000 125.000 75,000 - 5,000 3,500 18,000 17.500 - 3,500 175.000 17,500 25,000 7,000 - - - sunt Description,Dr.Cr th.25000,0 t-Term Investments, 125000,0 punts Receivable, 75000,0 wance for Doubtful Accounts, 0,5000 maid Insurance, 3500,0 mtory, 18000,0 pment, 17500,0 pment - AVD.0,3500 Hing, 175000,0 Sing - AD.0.17500 ,25000,0 Receivable 7000,0 unts Payable,0,32000 ries and Wages Payable,0, 12000 oll Tax Payable,0,1200 merty Tax Payable 0,3500 arned Revenue, 0,5000 Payable,0,8000 gage Payable,0,135000 rred Tax Liability,0,6000 mon Stock 0,10000 tional Paid-In Capital,0,40000 ained Earnings 0,85000 dends, 20000,0 s Revenue,0,1525000 s Discounts, 10000.0 s Returns and Allowances, 7000,0 cellaneous Income,0,3500 chases,613000,0 chases Discounts 0,7000 hases Returns and Allowances 0,2000 asht-In, 19600,0 of goods sold,0,0 ries and Wages Expense,591185,0 oll Tax Expense 45800,0 Expense 24000,0 rance Expense, 9000,0 ght-Out 6750,0 - merty Tax Expense 3500,0 ce Supplies Expense 2750,0 tenance and Repairs Expense,3750,0 Debt Expense,23750,0 reciation Exponse, 7500,0 est Expense 4050,0 Dellaneous Expense,1750,0 me Tax Expense, 36915,0 32,000 12,000 1,200 3,500 5,000 8,000 135,000 6,000 10,000 40,000 85,000 - Account Description Cash Short-Term Investments Accounts Receivable Allowance for Doubtful Accounts Prepaid Insurance Inventory Equipment Equipment - AVD Building Building - AJD Land Note Receivable Accounts Payable Salaries and Wages Payable Payroll Tax Payable Property Tax Payable Unearned Revenue Loan Payable Mortgage Payable Deferred Tax Liability Common Stock Additional Paid In Capital Retained Earnings Dividends Sales Revenue Sales Discounts Sales Returns and Allowances Miscellaneous Income Purchases Purchases Discounts Purchases Returns and Allowances Freight-In Cost of goods sold Salaries and Wages Expense Payroll Tax Expense Rent Expense Insurance Expense Freight-Out Property Tax Expense Office Supplies Expense Maintenance and Repairs Expense Bad Debt Expense Depreciation Expense Interest Expense Miscellaneous Expense Income Tax Expense Totals 20,000 1,525,000 10,000 7,000 3,500 613,000 - 7,000 2,000 19,500 - - - - 591 185 45,800 24,000 9.000 6,750 3,500 2.750 3,750 23.750 7,500 4,050 1.750 36.915 1,901,200 - - 1,901,200