Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

find bet income using trial balance. answer is between 145000 and 175000 just need answer doesnt matter if statement is used AutoSave OFF A5 a

find bet income using trial balance. answer is between 145000 and 175000 image text in transcribed
image text in transcribed
image text in transcribed
just need answer doesnt matter if statement is used
AutoSave OFF A5 a . Home Insert Draw Page Layout Comments Excel_Module_06 Chart_of_Accounts Formulas Data Tell me Share Conditional Formatting 7 Formatos Table Cells Editing 2 Cell Styles M L' A. % O. 8 Clipboard Font Alignment Number ideas Sansit G17 TIL B D E Credit Debit $ $ $ $ 1 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Account # 1060 1200 1250 1725 1820 2100 2150 2160 2180 2310 3350 3560 4020 5020 5615 5660 5685 5770 5775 5900 7900 Account Cash Accounts Receivable Inventory Equipment Accumulated Depreciation Accounts Payable Salaries Payable Income Tax Payable Interest Payable Note Payable Common Stock Retained Earnings Sales Revenue Cost of Goods sold Advertising Expense Depreciation Expense Insurance Expense Salaries Expense Supplies Expense Interest Expense Income Tax Expense Debit 92,625 344,216 125,205 428,154 $ $ S $ S S $ $ $ 1,235,834 34,963 15,082 4,426 1,220,541 64,915 162 79,434 3,645,557 $ 71,415 50,091 20,000 79,434 162 213,080 140,000 177,716 2,893,659 $ Ain $ $ S S $ $ 23 3,645,557 S 24 25 26 27 28 Journal Entries Hours Times Characters Expenses Trial Balance Ready DI! 150% MacBook 1 attempt left Take Now Attempt History Results Points Score Attempt 1 O of 5 0% Your Answers: 1 0/5 points Two Attempts Solve for Net Income using an IF Statement Open the Chart of Accounts.xlsx workbook and go to the Trial_Balance worksheet Use an IF statement to populate the cells E2:F22 for Income Statement accounts, Calculate the Net Income (no commas); X 476,604 Feedback Based on answering incorrectly Answer should be between 145,000 - 175,000 MacBook Module_06_Exercise_02 Return Submit Module_06_Exercise_02 1 5 points Two Attempts Solve for Net Income using an IF Statement Open the Chart of Accounts.xlsx workbook and go to the Trial_Balance worksheet (last tab) Use an IF statement to populate the cells E2:F22 for Income Statement accounts. Calculate the Net Income (no commas): 145,677 Submit

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

Financial Accounting An Introduction

Authors: Pauline Weetman

7th Edition

1292086696, 978-1292086699

More Books

Students also viewed these Accounting questions

Question

Be honest, starting with your application and rsum.

Answered: 1 week ago