Please type in an excel formula format

D EF 1 The following transactions occurred for Lantana Company during its first month of operations 2 and have been recorded in the T-accounts below. a. Received $50,000 cash from owners in exchange for common stock. b. Purchased land for $20,000, paid $5,000 in cash and signed a 2-year note for the remainder. c. Bought $900 of supplies on account d. Purchased $10,000 of equipment, paying cash e. Paid $500 on account for supplies purchased in transaction ( c) 4 5 6 7 8 Cash Supplies 10 50,000 5,000 b.c. 10,000 d 12 13 14 bal 15 500 e. bal 34,500 Land Equipment 10,000 20,000 bal 19 bal 20,000 10,000 20 Accounts Payable Note Payable 500 22 e 900c 400 bal 15,000 bal 24 25 26 27 28 29 Common Stock 50,000 a 50 D EF 30 31 Required: 32 Using the T-account BALANCES and the information in the transactions, 33 prepare a classified balance sheet for Lantana Company. 34 Note: Use cell references to the T-account titles to complete columns B and G. Use cell references to the 35 T-account balances and formulas to complete columns C and H. List long-term assets in alphabetical order. 36 37 38 39 40 41 Current Assets 42 43 4 Total Current Assets 45 46 Long-term Assets 47 48 49 Total Long-term Assets COMPANY Balance Sheet At December 31,2016 Assets Liabilities and Stockholders' Equity urrent Liabilities otal Current Liabilities ong-term Liabilities otal Long-term Liabilities otal Liabilities 51 52 53 54 Stockholders' Equity Retained Earnings otal Stockholders' Equity 0 otal Liabilities 56 57 Total Assets 58 59 and Stockholders' Equity 61