*** PLEASE READ *** this is the 3rd time posting I dont know how to use...
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 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 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. 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. 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 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 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 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 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 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...