Answered step by step
Verified Expert Solution
Link Copied!

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


On December 1, Jasmin Ernst organized Ernst Consulting. On December 3 , the owner contributed ( $ 84,000 ) in assets in ex

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... 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 and Managerial Accounting

Authors: Horngren, Harrison, Oliver

3rd Edition

978-0132497992, 132913771, 132497972, 132497999, 9780132913775, 978-0132497978

More Books

Students also viewed these Accounting questions

Question

why you want to attend graduate school in general;

Answered: 1 week ago