Excel A1 File 2 8 0 9 McGraw Hill Excel Question - Saved Home...

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

Revenues Consulting Revenue Total Revenue Expenses Rent Expenses Salaries Expenses Telep... View the full answer