Please show work in excel.

3 E5-12 (Preparation of a Balance Sheet) Presented below is the trial balance of Scott Butler Corporation at December 31, 2014. Debit Credit $ 197,000 $ 8,100,000 153,000 4,800,000 299,000 277,000 90,000 455,000 2,000,000 63,000 Cash Sales Revenue Debt Investments (trading) (at cost, $145,000) Cost of Goods Sold Debt Investments (long-term) Equity Investments (long-term) Notes Payable (short-term) Accounts Payable Selling Expenses Investment Revenue Land Buildings Dividends Payable Accrued Liabilities Accounts Receivable Accumulated Depreciation Buildings Allowance for Doubtful Accounts Administrative Expenses Interest Expense Inventory Gain (extraordinary) Notes Payable (long-term) 260,000 1,040,000 136.000 96,000 435,000 152,000 25,000 900,000 211,000 597,000 80,000 900,000 600,000 1,000,000 60,000 160,000 1,000,000 Equipment Bonds Payable Accumulated Depreciation Equipment Franchises Common Stock ($5 par) Treasury Stock Patents Retained Earnings Paid-in Capital in Excess of Par Totals 191,000 195,000 78,000 80,000 $12,315,000 $12,315,000 Instructions Prepare a balance sheet at December 31, 2014, for Scott Butler Corporation. (Ignore income taxes.)