directions

I just need the "Income Statement" done and the "statement of retained Earnings"

Prepare financial statements for the year ended as of December 31, 20xx. You are only responsible for preparing the income Statement, Statement of Retained Earnings and a Classified Balance Sheet. Complete Case # 3 in this Excel Workbook on template provided on the right. ABC Corporation Adjusted Trial Balance December 31, 20xx Debit Credit 110 Cash 1,660,691 120 Accounts Receivable 3,261,879 125 Allowance for Doubtful Accounts 100,800 130 Inventory 620,187 140 Other Current Assets 479,580 150 Land 950,868 160 Equipment 2,545,131 161 Accumulated Depreciation - Equipment 588,550 170 Intangible Assets 7,370,924 210 Accounts Payable 616,365 220 Unearned Revenue 1,631,578 230 Wages Payable 178,372 310 Common Stock, $1 par (1,000,000 shares authorized, 504,000 Shares Issued) 500,000 311 Additional Paid In Capital (Excess of Issue over Par-CIS) 1,613,146 320 Retained Earnings 5,595,149 330 Treasury Stock (4,000 shares purchased for $25/share) 100,000 340 Cash Dividends 2,292,807 410 Sales 14,969,106 510 Cost of Goods Sold 8,371,002 520 Wages Expense 1,907,873 530 Rent Exp 959,213 540 Depreciation Exp - Equipment 313,907 550 Utilities Exp 169,428 560 Misc. Exp 770,136 570 Interest Expense 19,440 Total 25,793,066 25,793,066 ABC Corporation Income Statement For the year ended December 31, 20XX Additional Instructions Enter data in shaded cells only XXXX Do not reformat sheet (i.e.inserting rows, etc.) Accounting period is January - December Reporting period is January - December Show Negative numbers in brackets() Income Statement: (Multi-Step Presentation) Do not separate Selling and Administrative Exp See Chapter 6 + ABC Corporation Statement of Retained Earnings For the year ended December 31, 20XX Statement of Retaining Earnings See Chapter 13 Balance Sheet: (Classified) Show contra acct balances in brackets") Stockholder's Equity (Use Method 2 from text See Chapter 6 8 13 Increase in retained earnings