use this and make a step by step way to make this in excel:

Coastal Carolina Corporation Adjusted Trial Balance December 31, 2016 Account Debit Cash 85,000 Accounts Receivable 150,000 Inventory 61,000 Prepaid Rent 4,000 Land 100,000 Equipment 170,000 Accumulated Depreciation Patents, net of amortization 40,000 Accounts Payable Wages Payable Interest Payable Note Payable (18 months) Bonds Payable (due in 2016) Common Stock Paid-in Capital in Excess of par - Common Retained Earnings, Jan. 1 Dividends 20,000 Sales Revenue Cost of Goods Sold 280,000 Salaries expense 130,000 Utilities expense 15,000 Rent Expense 55,000 Depreciation Expense 17,000 Interest Expense 3,000 $ 1,130,000 $ Credit 30,000 75,000 20,000 5,000 105,000 90,000 30,000 145,000 30,000 600,000 1,130,000