PROBLEM 1 (50 points) Below is the December 31, 2019 post-closing trial balance of Johnson Company ($ in thousands) ACCOUNT DEBIT CREDIT Cash Investments (long-term) Accounts Receivable Allowance for uncollectible accounts Prepaid Insurance Inventories Land Buildings Accumulated depreciation-buildings Equipment Accumulated depreciation-equipment Patents (unamortized balance) Accounts Payable Notes Payable (due 2019) Interest Payable Bonds Payable (due 2029) Common stock, no par, 20,000 share:s 20,500 50,000 30,000 7,500 4,500 100,000 45,000 140,000 50,000 132,500 30,000 5,000 35,500 65,000 5,000 120,000 authorized, issued and outstanding Retained Earnings 150,000 64,500 Totals DIRECTIONS: Prepare a classified balanced sheet in Excel. Pay careful attention to format, spelling, alignment, account names and double check all totals. You need to FULLY break down into categories the assets section and the liabilities section -the stockholders' equity is done the same in a classified as a non-classified balance sheet