Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
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 31, 2019. Every yellow cell requires either an account title or a dollar amount. Use the dropdown list to select the proper account titles. Enter a formula for all dollar amounts Credit Liban Ahmed Company Trial Balance December 31, 2019 Debit Cash $12,500 Accounts receivable 24,000 Merchandise inventory 65,500 Store supplies 2,600 Store Equipment 68,000 Accumulated depreciation Accounts payable Salamies payable Common Stock Dividends 32.000 Sales Sales discounts 6,000 Sales returns and allowances 19 200 Cost of goods sold 134.000 Depreciation expense Store equip. 10.000 Sales salaris expense 26 800 to see 16 Instructions Multi-Step $20,000 19.000 8.000 83.400 383.000 Type here to search oo D F G Liban Ahmed 21 1 Name: 2 Your score Sales salaries expense Office salaries expense 28 Insurance expense Rent expense - Store Rent expense office 31 Store supplies expense Advertising expense 33 Totals 29 30 26,800 35,100 12.100 18,100 8,100 6.900 32.500 $513.400 $513.400 Prepare a multiple-step income statement for Liban Ahmed Company for the year ended December 31, 2019. Remember that selling expenses target the customer, and are expected to generate additional sales Administrative expenses are not expected to generate additional sales. Liban Ahmed Company Income Statement For Year Ended December 31, 2019 Sales Sales discounts Sales returns and allowances Not sales Operating expenses Selling expenses Instructions Multi-Step Type here to search esc WERTY 1 Name: Liban Ahmed 2. Your score: 1296 Liban Ahmed Company Income Statement For Year Ended December 31, 2019 Sales Sales discounts Sales returns and allowances Net sales Operating expenses Selling expenses Total selling expenses General and administrative expenses Total general and administrative expenses Total operating expenses 60 instructions Multi-step 8 P Type here to search W

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Global Financial Accounting And Reporting Principles And Analysis

Authors: Peter Walton, Walter Aerts

4th Edition

1473729521, 9781473729520

More Books

Students also viewed these Accounting questions