Please do this in excel ignore the google forms statement. Thank you! :)

Cambridge Business Publishers Chapter 4 Balance Sheet and Financial Reporting The following accounts are taken from the general ledger of Spice Corp. on December 31, 2020, its annual year-end. $ 20,000 37,000 $ 54,000 56,000 40,000 35,000 1,000 Cash.. Accounts receivable Short-term investment (cost which approximates market) Inventory. Prepaid expense (current) Bond sinking fund (to pay bonds at maturity) Advances to suppliers (current) Cash dividends declared during 2020 Supplies Investment in stock (at fair value). . Unamortized discount on bonds payable... Note receivable (long-term) Land (building site in use). . Building. Equipment Franchise (used in operations). Total debits. Mortgage payable (long term) Accounts payable.. Dividends (cash) payable (payable March 1, 2021) Deferred revenue Interest payable Accumulated depreciation, building Accumulated depreciation, equipment Allowance for doubtful accounts. Bonds payable (maturity 2025). Common stock, $4 par (50,000 shares issued and outstanding). Preferred stock, $10 par (8,000 es, issued and outstanding) Additional paid-in capitalpreferred stock.. Retained earnings, December 31, 2019... Net income for 2020 Total credits 10,000 3,000 4,000 210,000 20,000 2,000 102,000 35,000 4,000 10,000 2,000 22,000 200,000 80,000 4,000 25,000 30,000 450,000 120,000 16,000 $851,000 16,000 6,000 88,000 $851,000 Required a. Prepare a classified balance sheet in good form. b. Answer the following questions related to the information above. 1. By what percentage was the building depreciated? 2. Provide the entry that was made to record the 2020 dividend declaration. 3. Provide the entry that was made for the advances to suppliers. Assume cash transactions. 4. Compute working capital on December 31, 2020. Required a. Prepare a classified balance sheet in good form. b. Answer the following questions related to the information above. 1. By what percentage was the building depreciated? 2. Provide the entry that was made to record the 2020 dividend declaration. 3. Provide the entry that was made for the advances to suppliers. Assume cash transactions. 4. Compute working capital on December 31, 2020