Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
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 for all dollar amounts The formula must only contain cell addresses Each correct formula will begin with , The basic mathematical operators are, and Addition: To add the values in cells Al and B4, the formula is A1+34 8 Subtraction: To subtract the value in cell B4 from the value in cell A1, the formula is A1-84 9 Multiplication: To multiply the values in cells A1 and 34, the formula is 1954 10 Division to divide the value in cell Al by the value in all the formula 1/ 4 Instructions Mustep Type here to search 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 15 Liban Ahmed Company Trial Balance December 31, 2019 Debit Cash $12,500 Accounts receivable 24,000 Merchandise inventory 65.500 Store succes 2.500 Store Equipment 68.000 Accumulated depreciation Accounts payable Salarios payable Common Stock Dividends 32,000 Sales Sales discounts 6.000 Sales returns and allowances 19 200 Cost of goods sold 134,000 Decreciation expense Store quo 10.000 Sales was expense 25 Ofice salaries expense 35.100 Insurance expense 12100 Rent expense Store 18.100 Rent expense office 8.100 Store supplies expense 8.900 Advertising expense 32,500 Totals $513.400 $20,000 19.000 8,000 83,400 19 383.000 27 5513 400 Prepare a multiple step income statement for Liban Ahmed Company for the year anded December 31, 2019 Remember that selling expenses target the customer and are expected to generate additional sales Administrative Type here to search 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 Operating expenses Seng expenses Total selling expense Geneland nativen Total general and administrative expenses Total operating expenses m eton Multi-step Type here to search

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

Understand Accounting

Authors: Claude Hitching, Derek Stone

1st Edition

0273018833, 978-0273018834

More Books

Students also viewed these Accounting questions

Question

Explain how religious attitudes affect firm behavior.

Answered: 1 week ago