Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Excel A1 File 2 8 0 9 McGraw Hill Excel Question - Saved Home Insert Draw X A < Cash Accounts receivable Office supplies
Excel A1 File 2 8 0 9 McGraw Hill Excel Question - Saved Home Insert Draw X A < Cash Accounts receivable Office supplies Office equipment 10 Land 11 Accounts payable 12 Common stock 13 Cash dividends 14 Consulting revenue 15 Rent expense 16 Salaries expense Calibri 17 Telephone expense 18 Miscellaneous expenses 19 Formulas Data 1 2 On December 1, Jasmin Ernst organized Ernst Consulting. On December 3, the owner contributed $84,000 in 3 assets in exchange for its common stock to launch the business. On December 31, the company's records 4 show the following items and amounts. 5 6 7 $11,360 14,000 3,250 18,000 Search (Option + Q) V11 B 20 | Ev v Ov|. fx Accessibility tab summary: Financial records of Ernst Consulting are presented in rows 6 to 18. A statement of requirement is presented in rows 20 to 23 and the income statement for B 0 D G E H I J L M P S N R e 46,000 8,500 84,000 2,000 Review View 14,000 3,550 7,000 760 580 Help F Editing General 20 Required: 21 Using the above information prepare a December income statement for the business. 22 23 (Use cells A6 to B18 from the given information to complete this question. All formulas must return positive values.) Graded Worksheet + Comments
Step by Step Solution
★★★★★
3.47 Rating (157 Votes )
There are 3 Steps involved in it
Step: 1
Revenues Consulting Revenue Total Revenue Expenses Rent Expenses Salaries Expenses Telep...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started