with formula please!

? 5 1 Sign In Paste 11 a. 5 Preparing a classified balance sheet - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW X Calibri 11 HA %6 Mt BIU A : Alignment Number Conditional Format as Cell Cells Editing Formatting Table - Styles Clipboard Font Styles The following transactions occurred for Lantana Company during its first month A B DEF G H 1 7 d. Purchased $10,000 of equipment, paying cash. 8 c. Paid $500 on account for supplies purchased in transaction (c). 9 10 Cash Supplies 50,000 5,000 b. c. 900 12 10,000 d. 13 500 e. 34.500 bal 2001 15 16 Land Equipment 17 b. 20,000 10,000 18 20,000 bal. 10.000 20 21 Accounts Payable Note Payable 22 e. 500 900 c. 15,000 b. 23 24 400 bal. 15.000 bal 25 26 Common Stock 27 50,000 . 28 29 50.000 bal. 14 bal. d . 19 bal 98410888 a. - I B DEF G H LANTANA COMPANY Balance Sheet At December 31, 2016 Liabilities and Stockholders' Equity Current Liabilities Total Current Liabilities Long-term Liabilities Assets 1 Current Assets 2 3 4 Total Current Assets 15 6 Long term Assets 7 8 19 Total Long-term Assets 80 $1 2 53 54 55 56 57 Total Assets 58 Total Long-term Liabilities Total Liabilities Stockholders' Equity AWN 0 Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity