I need help with this, and I cant figure it out.

chapter 5 Q v Search Sheet Home Insert Page Layout Formulas Data Review View L Share Cut Calibri (Body) * 11 A- A Wrap Text General _ AutoSum Copy Ap . Q . Paste BI UV - A. Fill Format |Merge & Center $ ~ % 2 08 08 Conditional Format Cell Insert Delete Format Sort & Find & Formatting as Table Styles Clear Filter Select x View Only Your account agibbs_4986@email.ric.edu doesn't allow editing on a Mac. To learn more, contact your admin about your Office plan. Use Another Account A1 4 X V fx B E G H K M N 0 P Q R S T U V W 3 Please complete the classifed balance sheet based on the following trial balance 4 Debit Credit 5 Cash $ 167,000.00 6 Sales Revenue $ 1,500,000.00 7 Debt Investments (trading) at cost $120,000 160,000.00 8 Cost of Goods Sold 500,000.00 9 Debt Investments (long term) 550,000.00 10 Equity Investment (long term) 300,000.00 11 Notes Payable (short Term) $ 300,000.00 12 Accounts Payable 700,000.00 Investment Revenue 30,000.00 14 Selling Expense 200,000.00 15 Buildings 1,200,000.00 16 Land 500,000.00 17 Dividends Payable $ 210,000.00 18 Accrued Liabilities S 350,000.00 19 Accounts Recievable $ 500,000.00 20 Allowance for Doubtful Accounts S 50,000.00 21 Accumulated Depreciation -Building S 300,000.00 22 Administrative Expense 100,000.00 Interest Expense 50,000.00 24 Gain $ 70,000.00 25 Inventory 625,000.00 26 Notes Payable (long-term) $ 600,000.00 27 Bonds Payable 900,000.00 28 Equipment S 680,000.00 29 Accumulated Depreciation - Equipment S 260,000.00 30 Common Stock ($4 par) S 400,000.00 31 Franchises 240,000.00 32 Treasury Stock 138,000.00 33 Patents 160,000.00 34 Retained Earnings 35 Paid-in-Capital in Excess of Par $ 400,000.00 36 Total 37 $ 6,070,000.00 $ 6,070,000.00 38 39 40 Put these numbers into the classifed balance sheet format similar to exercise 5-12 and Illustation 5-16 on page 5-15 41 42 43 Sheet1 + Edit + 100%