use cell references for answers

MINH PHUN FE HOME Sign in 37 Calibri B I INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW 11 AA = F ) . B. . A Alignment Number Conditional Format as Cell Formatting Table Styles" Font Styles V Cells ints Editing Paste Clipboard Skipped The following transactions occurred for Lantana Company during its first month H eBook DEF 1 The following transactions occurred for Lantana Company during its first month of operations 2 and have been recorded in the T-accounts below. References 4 Received $50,000 cash from owners in exchange for common stock 5 b. Purchased land for $20,000, paid $5,000 in cash and signed a 2.year note for the remainder. 6 c. Bought $900 of supplies on account 7 d. Purchased $10,000 of equipment, paying cash. 8 e. Paid $500 on account for supplies purchased in transaction (c). Cash 50.000 Supplies op c. 5.000 10.000 500 b. d. e 34.500 200 Land 20.000 Equipment 10.000 d. 20.000 bal 10.000 Accounts Payable Note Payable SOO 15.000 Sheet1 READY rrey LA PLE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri B T U Paste Clipboard Al -11 AA = FE - A. Alignment Number Conditional Formatas Cell Cells Editing Formatting Table Styles Font Styles X f The following transactions occurred for Lantana Company during its first month I C D E F G Cash 50.000 c. Supplies 900 5.000 10,000 500 b. d. e. 2 34 SCO 200 Land 20,000 Equipment 10,000 . 20.000 10,000 3 Note Payable Accounts Payable sool 900 15.000 b. 400 bal 15.000 bal. Common Stock 50.000 a 50.0.00 bal. 31 Required: 32 Using the T-account BALANCES and the information in the transactions, Sheet1 READY (Prey 1 of 12 !!! Next > Cipuaru Styles A1 X fx The following transactions occurred for Lantana Company during DEF 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 tities to complete columns B and G. Use cell references to the 35 T-account balances and formulas to complete columns C and H. Last long-term assets in alphabetical order. 36 LANTANA COMPANY Balance Sheet At December 31, 2016 Assets Liabilities and Stockholders' Equity 41 Current Assets Current Liabilities 44 Total Current Assets Total Current Liabilities 46 Long-term Assets Long-term Liabilities 49 Total Long-term Assets Total Long-term Liabilities Total Liabilities Stockholders' Equity Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity 57 Total Assets Sheet1 heet READY