Question

The trial balance of the Liban Ahmed Company as of December 31, 2019 is presented below. Prepare a multiple step income state
1 Name: 2 Your score: Office salaries expense 28 Insurance expense Rent expense - Store Rent expense office Store supplies ex
1 Name: 2 Your score: Liban Ahmed 37 Liban Ahmed Company Income Statement For Year Ended December 31, 2019 Sales Sales discou

*** PLEASE READ ***

this is the 3rd time posting

I dont know how to use excel they need a FORMULA like A2+C1= x to get the answer
so please im begging you can you add the formula when answer the below part thank you !
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Income Statement Particulars Amount Amount Cell reference Sno 1 Sales 383000 2 Sales Discount 6000 3 Sales return and allowan

Add a comment
Know the answer?
Add Answer to:
*** PLEASE READ *** this is the 3rd time posting I dont know how to use...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • need help with this finding the answer and I have to plug in a formula with...

    need help with this finding the answer and I have to plug in a formula with excel to get the answer thanks to anyone who helps I posted this but the other user didnt give me a good formula that works to get the answer thanks Name Liban Ahmed Your score The trial balance of the Liban Ahmed Company as of December 31, 2019 is presented below. Prepare a multiple step income statement for the year ended (date of) December...

  • please if someone can help me out with this I would be very grateful I am...

    please if someone can help me out with this I would be very grateful I am not so good with excel and need this extra credit to pass the class thank you so much to anyone who helps Click on the "Multi-Step" tab and enter your name in Cell C1. If Cell Cl is left blank, you will not be able to see your score Each graded cell is highlighted in yellow. Select all account titles/labels using dropdowns. Enter formulas...

  • need help finding the answers and using the formula to plug in thanks Name Liban Ahmed...

    need help finding the answers and using the formula to plug in thanks Name Liban Ahmed Your score The trial balance of the Liban Ahmed Company as of December 31, 2019 is presented below. Calculate the totals on the trial balance. Prepare an income statement, statement of retained earnings and a balance sheet for the year ended (date of) December 31, 2019. Every yellow cell requires either an account title or a dollar amount. Use the dropdown list to select...

  • Use the information below and prepare the Multi-Step Income Statement for Hot Place on August 31....

    Use the information below and prepare the Multi-Step Income Statement for Hot Place on August 31. Sales $1,200,000 Interest Revenue 15 Sales Discounts 15,000 Sales Returns and Allowances 35,000 Cost of Goods Sold 790,000 Delivery Expense 1,500 Sales Salaries Expense 110,000 Office Supplies Expense 4,400 Store Supplies Expense 725 Admin Salaries Expense Depreciation Expense - Store Trucks 500 Depreciation Expense - Office Equipment 550 Rent Expense - Selling 500 Rent Expense - Office 2,100 Interest Expense Office Insurance Expense 300...

  • Multi-step Income Statements The adjusted trial balance of Mally Distributors on December 31 is shown below....

    Multi-step Income Statements The adjusted trial balance of Mally Distributors on December 31 is shown below. MOLLY DISTRIBUTORS Adjusted Trial Balance December 31 Debit Credit $30,200 Cash Accounts Receivable 110,200 94,000 2,400 6,400 85,000 Inventory Prepaid Insurance Supplies Delivery Equipment Accumulated Depreciation Accounts Payable Common Stock $35,000 100,000 105,000 22,800 791,000 Retained Earnings Sales Revenue 513,400 123,000 40,000 6,400 4,000 16,000 6,800 16,000 $1,053,800 $1.053,800 Cost of Goods Sold Salaries Expense Rent Expense Supplies Expense Utilities Expense Depreciation Expense Insurance...

  • The following amounts appeared on Plymouth Electronics’ adjusted trial balance as of December 31, 2020. Debit Credi...

    The following amounts appeared on Plymouth Electronics’ adjusted trial balance as of December 31, 2020. Debit Credit Merchandise inventory $ 19,200 Other assets 484,785 Liabilities $ 309,370 Celine Plymouth, capital 245,790 Celine Plymouth, withdrawals 66,700 Sales    939,000 Sales discounts 14,280 Sales returns and allowances 5,415 Interest income 690 Cost of goods sold 717,500 Sales salaries expense 78,900 Office salaries expense 56,200 Rent expense, selling space 32,700 Rent expense, office space 2,700 Store supplies expense 1,590 Office supplies expense 720...

  • $3,300 2,700 12,800 89,700 Cost of Goods Sold, Income Statement, and Statement of Comprehensive Income Gaskin...

    $3,300 2,700 12,800 89,700 Cost of Goods Sold, Income Statement, and Statement of Comprehensive Income Gaskin Company derives the following items from its adjusted trial balance as of December 31, 2019: Sales $142,000 Interest revenue Purchases returns 5,200 Purchases discounts taken Gain on sale of equipment (pretax) 3,800 Inventory, January 1, 2019 Freight-in 3,400 Purchases Selling expenses 15,600 Administrative expenses Unrealized increase in fair value of Loss from truck accident (pretax) 2,400 available-for-sale securities The following additional information is also...

  • Exercise 4-15 Preparing a multi-step income statement LO P4 Fit-for-Life Foods reports the following income statement...

    Exercise 4-15 Preparing a multi-step income statement LO P4 Fit-for-Life Foods reports the following income statement accounts for the year ended December 31. $ Gain on sale of equipment office supplies expense Insurance expense Sales office salaries expense Rent expense-Selling space Sales staff wages $ 6,240 Depreciation expense-office copier 750 sales discounts 1,270 Sales returns and allowances 227.000 TV advertising expense 33.000 Interest revenue 11.400 cost of goods sold 23.800 Sales commission expense 560 15,700 4.000 3.800 91.000 13, 200...

  • 3 The adjusted trial balance data given below is from the Morgan Company's worksheet for the...

    3 The adjusted trial balance data given below is from the Morgan Company's worksheet for the year ended December 31, 2019. The expense accounts numbered 611-615 represent selling expenses, and those numbered 621-631 represent general and administrative expenses. ACCT. NO. 399 401 451 491 501 502 503 504 611 613 615 621 623 ACCOUNT NAME Income Summary Sales Sales Returns and allowances Interest Income Purchases Freight In Purchases Returns and Allowances Purchases Discounts Sales Salaries Expense Advertising Expense Travel Expense...

  • The worksheet of Bridget's Office Supplies contains the following revenue, cost, and expense accounts. The merchandise...

    The worksheet of Bridget's Office Supplies contains the following revenue, cost, and expense accounts. The merchandise inventory amounted to $58,275 on January 1, 2019, and $51,225 on December 31, 2019. The expense accounts numbered 611 through 617 represent selling expenses, and those numbered 631 through 646 represent general and administrative expenses. Accounts 401 Sales 451 Sales Returns and Allowances 491 Miscellaneous Income 501 Purchases S02 Freight In 583 Purchases Returns and Allowances 584 Purchases Discounts 611 Salaries Expense-Sales 614 Store...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT