Hello I am struggling with some accounting excel problems here and hope a tutor can assist me in explaining what I need to do, I appreciate it a lot!

One asks to prep a classified balance sheet from T accounts

Another asks to solve for the missing amounts and understand how the financial statements are linked

Last one asks to prep an income statement from a list of accounts.
I appreciate all the help I can get, again thank you again for your time and energy (:

Image transcription text

1. Prepare a classified balance sheet from T accounts. Preparing a classified balance sheet - Excel ? X ILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 - A" A" % Paste BIU - . . A . Alignment Number Conditional Format as Cell Cells Editing Formatting Table * Styles Clipboard Font Styles A X V The following transactions occurred for Lantana Company during its first month A B DEF G H 1 The following transactions occurred for Lantana Company during its first month of operations 2 and have been recorded in the T-accounts below. 4 a. Received $50,000 cash from Lantana, the sole proprietor. 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 ). 9 10 Cash Supplies 11 a. 50,000 5,000 b . C . 900 12 10,000 d. 13 500 e. 14 bal. 34,500 bal. 900 15 16 Land Equipment 17 b . 20,000 d. 10,000 18 19 bal . 20,000 bal. 10,000 20 21 Accounts Payable Note Payable 22 e. 500 900 C. 15,000 b. 23 24 Ann 1 Sheet1 + READY - + 100% 

Image transcription text

1. Solve for the missing amounts and understand how the financial statements are linked. XI H 6 - 9 . 3. Relationships among Financial Statements - Excel ? - X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 - A A % Paste BIU - - - A . Alignment Number Conditional Format as Cell Cells Editing Formatting Table * Styles Clipboard Font Styles Al x v fx Presented below are incomplete financial statements for Marta Communications B D 1 Presented below are incomplete financial statements for Marta Communications IN w Required: 4 Solve for the missing amounts. NOTE: When an amount on one financial statement is again shown on 5 another statement, you MUST reference the cell from the earlier statement rather than calculate the amount, thus 6 indicating the relationship between the two statements. MARTA COMMUNICATIONS Income Statement 10 For the Month Ended March 31, 20X1 11 Sales Revenue $34,500 12 Expenses: 13 Rent Expense 2,600 14 Wages Expense 15 Utilities Expense 4.800 16 Advertising Expense 800 17 Net income $4,100 18 19 20 MARTA COMMUNICATIONS 21 Statement of Owner's Equity 22 For the Month Ended March 31, 20X1 23 Marta, Capital, March 1, 20X1 $0 24 Add: Net income Sheet1 ... + 4 READY - + 100% Attempt(s) 

Image transcription text

1. Prepare an income statement from a list of accounts. Preparing an income statement - Excel X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri - 11 - A" A % Paste BIU - B - LA. Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Clipboard Font Styles Al X The list below shows select accounts for Reading Readiness Company as of A B C D E F 1 The list below shows select accounts for Reading Readiness Company as of January 31, 20X1. (Accounts are in alphabetical order.) W N Accounts Payable $ 8,088 Accounts Receivable 6,960 Cash 13,445 Equipment 4.800 Insurance Expense 1,350 Operating Expense 1,800 Other Expenses 3,482 Other Revenues 6,050 12 Rent Expense 4,800 13 Salaries Expense 6,882 14 Short-term Notes Payable 17,200 15 Test Prep Revenue 15,400 16 Tutoring Revenue 9,100 17 Unearned Revenue 1,046 18 19 Required: 20 1. Prepare an Income Statement for the month ended January 31, 20X1. Use cell references 21 to select account titles and amounts to be included on the income statement. 22 Note: List revenues and expenses in order of largest to smallest dollar amounts. 23 24 2. After entering the formula in cell C42, use the Excel IF function to label cell B42 as either "Net Income" or Sheet1 1 ... + READY 100%
 
 

Transcribed Image Text:

1. Prepare a classified balance sheet from T accounts. Preparing a classified balance sheet - Excel ? REVIEW VIEW FILE HOME INSERT PAGE LAYOUT FORMULAS DATA Calibri 11 AA % Paste B I U - Alignment Number Conditional Format as Cell Formatting Table Styles Cells Editing Styles Clipboard 17 A1 A V B Font fx C E Sign In The following transactions occurred for Lantana Company during its first month DEF G 1 The following transactions occurred for Lantana Company during its first month of operations 2 and have been recorded in the T-accounts below. 3 4 a. Received $50,000 cash from Lantana, the sole proprietor. 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 9 10 e. Paid $500 on account for supplies purchased in transaction (c). Supplies 11 a. Cash 50,000 5,000 b. 10,000 d. C. 900 500 e. bal. 900 Equipment 12 13 14 bal. 34,500 15 16 Land 17 b. 20,000 18 19 bal. 20,000 20 21 22 e. Accounts Payable 500 23 24 READY Sheet1 900 C. d. bal. 100 L-1 4 10,000 10.000 H Note Payable 15,000 b. I 15 000 L-1 + 100% 1. Prepare a classified balance sheet from T accounts. Preparing a classified balance sheet - Excel ? REVIEW VIEW FILE HOME INSERT PAGE LAYOUT FORMULAS DATA Calibri 11 AA % Paste B I U - Alignment Number Conditional Format as Cell Formatting Table Styles Cells Editing Styles Clipboard 17 A1 A V B Font fx C E Sign In The following transactions occurred for Lantana Company during its first month DEF G 1 The following transactions occurred for Lantana Company during its first month of operations 2 and have been recorded in the T-accounts below. 3 4 a. Received $50,000 cash from Lantana, the sole proprietor. 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 9 10 e. Paid $500 on account for supplies purchased in transaction (c). Supplies 11 a. Cash 50,000 5,000 b. 10,000 d. C. 900 500 e. bal. 900 Equipment 12 13 14 bal. 34,500 15 16 Land 17 b. 20,000 18 19 bal. 20,000 20 21 22 e. Accounts Payable 500 23 24 READY Sheet1 900 C. d. bal. 100 L-1 4 10,000 10.000 H Note Payable 15,000 b. I 15 000 L-1 + 100%