Everything needs to be in formula. Im having trouble with that.

All answers must be entered as a formula. Click OK to begin. OK Preparing a classified balance sheet-Exce HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In B 1 u . E. ?_a. Alignment Number Conditional Form atasCell Cells Editing l Paste Formating" Table Styles - Clipboard | | A | | The following transactions occurred for Lantana Company during its first month A1 v 1A transactions occurred for Lantana Company during its first month of operations 2 Ind have been recorded in the T-accounts below 4 .Received $50,000 cash from owners in exchange for common stock S . Purchased land for $20,000, paid $5,000 in cash and signed a 2-year note for the remainder 6Bought $900 of supplies on account 7 1. Purchased $10,000 of equipment, paying cash. 8 . Paid $500 on account for supplies purchased in transaction (c). 10 Supplies 50,000 5,000 b. 10,000 d 500 e .-i 13 14 al 15 16 17 bal Land ent 20,000 10,000 19 al. 20 bal. Accounts Payable Note Payable 500 900 C 15,000 b Sheet1 1 A Alignment Number Conditional Format as Cell Cells Editing at lipboard Formatting" Table" Styles Font | | | The following transactions occurred for Lantana Company during its first month , | X 500 900 15,000 b 15,000 bal. 24 25 26 27 Common Stock 50,000 a bal. 30 31 Required: 32 Using the Taccount 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 tities to complete columns B and G. Use cell references to the s T-account balances and formulas to complete columns C and H. List long-term assets in oiphabeticol order LANTANA COMPANY 39 At December 31, 2016 Assets Liabilities and Stockholders' Equity 1 Current Assets Current Liabilities 4 Total Current Assets 5 Total Current Liabilities Sheetl astBI A Alignment Number Conditional Format as Cell Cells Editing Formatting Table" Styles Styles Clipboard -| | f. | | The following transactions occurred for Lantana Company during its first month A1 x v LANTANA COMPANY Balance Sheet At December 31, 2016 37 39 40 41 Current Assets 42 43 44 Total Current Assets 45 46 Long-term Assets 47 Assets Liabilities and Stockholders' Equity Current Liabilities Total Current Liabilities Long-term Liabilities Total Long-term Liabilities 49 Total Long-term Assetsl 50 51 52 53 54 Total Liabilities Stockholders Equity Total Stockholders Equity Retained Earnings 56 57 Total Assets Total Liabilities and Stockholders Equity 59