Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

what is missing from my multistep income sheet Aules (@CH H 5 ACC 2001 Project Excel File (2) Excel Brittany Konkle File Home Insert Draw

what is missing from my multistep income sheet

image text in transcribedimage text in transcribed

Aules (@CH H 5 ACC 2001 Project Excel File (2) Excel Brittany Konkle File Home Insert Draw Page Layout Formulas Data Review View Help Search Share F32 X f A D E F G H J J 1 L M N P B S 1 1 2 3 3 B Dress Right Clothing Adjusted Trial Balance December 31, 2020 4 Credits Debits $49,000 12,400 1,200 10,000 48,500 120.000 Current Year Change $ $44,350 (1,500) 400 1,000 9,600 $71,400 40,000 5 6 Account Title 7 Cash B Accounts Receivable 9 Supplies 10 Prepaid Rent 11 Inventory 12 Equipment 13 Accumulated Depreciation - Equipment 14 Long Term Investments 15 Accounts Payable 16 Deferred Revenue 17 Salaries Payable 18 Interest Payable 19 Notes Payable due in 3 years 20 Commen Stock 21 Retained Carnings 22 Dividends 23 Sales Revenue 24 Interest Ravenue 25 Cost at Goods Sold 26 Salaries Expense 27 Supplies Expense 29 Rent Expense 29 Depreciation Expense 30 Interest Expense 31 Income Tax Expense 32 33 34,600 7,800 500 400 40,000 60,000 14,800 4,000 5,400 3,700 12,500) 14,150) 400 (30,000) 36,200 19,900 938,860 5,600 540,600 175,260 8,500 120,000 4,000 3,600 21,000 *-Beginning of year balance minus end of the year balance. To be used for the Statement of Cash Flows $1,173,960 $1,173,960 35 Adj Trial Balance income Statement Statement of SHE Balance Sheet Statement of Cash Flows + O Type here to search x ? RR ) 1:50 PM 9/18/2020 AutoSave CH H5 ACC 2001 Project 3 Excel File (2) - Excel Brittany Konkle File Home Insert Draw Page Layout Formulas Data Review View Help Search Share G14 c. D E G H 1 K L M N P R S 1 2 3 3 A B Dress Right Clothing Income Statement For the Year Ended December 31, 2020 4 $938,860 540,600 $298,260 4,000 120,000 175,260 299,260 5 6 Revenues: 7 Sales Revenue 6 Cost of Goods Sold 9 Gross Profit 10 11 Operating Expenses: 12 Depreciation Expense 13 Rent Expense 14 Salaries Expanse 15 16 Total Operating Expenses 17 Operating Income 18 19 Other Income & Expenses: 20 Interest Revenue 21 Interest Expense 22 Net Other Income & Expenses 23 24 25 Net Income 26 27 28 29 30 5,600 -3,600 2,000 31 32 33 34 35 Adj Trial Balance Income Statement Statement of SHE Balance Sheet Statement of Cash Flows + O Type here to search Ei x 2 (9) 10:07 AM 9/20/2020

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

The Employers Guide To Surviving Payroll And Human Resources Audits 2019

Authors: Paul E Love

1st Edition

1073422771, 978-1073422777

More Books

Students also viewed these Accounting questions