Excel McGraw Hill Excel Question - Saved Search (Alt+Q) File Home Insert Draw Formulas Data Review...

Transcribed Image Text:

Excel McGraw Hill Excel Question - Saved Search (Alt+Q) File Home Insert Draw Formulas Data Review View Help Editing v Calibri B *** A1 Mergev General 00 Accessibility tab summary: The transactions for Lantana Company are listed in rows 5 to 9. The T-accounts are presented in cells A11 to 130. A A B DEF G H 1 2 The following transactions occurred for Lantana Company during its first month of operations and have been recorded in the T-accounts 3 below. 4 5 a. Received $50,000 cash from owners in exchange for common stock. 6 b. Purchased land for $20,000, paid $5,000 in cash and signed a 2-year note for the remainder. 7 c. Bought $900 of supplies on account. 8 d. Purchased $10,000 of equipment, paying cash. 9 e. Paid $500 on account for supplies purchased in transaction (c). 10 11 12 a Cash 50,000 Supplies 13 5,000 b. 10,000 d. C. 900 14 500 e. 15 bal. 34,500 bal. 16 900 17 Land 18 b. 20,000 d. 19 Equipment 10,000 20 bal. 21 22 20,000 bal. Accounts Payable =Graded Worksheet + 10,000 Note Payable Calculation Mode: Automatic Workbook Statistics K Excel McGraw Hill Excel Question - Saved Search (Alt+Q) File Home Insert Draw Formulas Data Review View Help Editing v Calibri B *** A1 Mergev General 00 Accessibility tab summary: The transactions for Lantana Company are listed in rows 5 to 9. The T-accounts are presented in cells A11 to 130. A A B DEF G H 1 2 The following transactions occurred for Lantana Company during its first month of operations and have been recorded in the T-accounts 3 below. 4 5 a. Received $50,000 cash from owners in exchange for common stock. 6 b. Purchased land for $20,000, paid $5,000 in cash and signed a 2-year note for the remainder. 7 c. Bought $900 of supplies on account. 8 d. Purchased $10,000 of equipment, paying cash. 9 e. Paid $500 on account for supplies purchased in transaction (c). 10 11 12 a Cash 50,000 Supplies 13 5,000 b. 10,000 d. C. 900 14 500 e. 15 bal. 34,500 bal. 16 900 17 Land 18 b. 20,000 d. 19 Equipment 10,000 20 bal. 21 22 20,000 bal. Accounts Payable =Graded Worksheet + 10,000 Note Payable Calculation Mode: Automatic Workbook Statistics K