Excel A1 File 2 8 0 9 McGraw Hill Excel Question - Saved Home...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Answer rating: 100% (QA)
Revenues Consulting Revenue Total Revenue Expenses Rent Expenses Salaries Expenses Telep... View the full answer
Related Book For
Financial and Managerial Accounting
ISBN: 978-0132497978
3rd Edition
Authors: Horngren, Harrison, Oliver
Posted Date:
Students also viewed these accounting questions
-
The contribution margin income statement of Delectable Donuts for August 2012 follows: Delectable sells four dozen plain donuts for every dozen custard-filled donuts. A dozen plain donuts sells for...
-
The contribution margin income statement of Dandy Donuts for May 2012 follows: Dandy sells three dozen plain donuts for every dozen custard-filled donuts. A dozen plain donuts sells for $6, with a...
-
The contribution margin income statement of Morgantown Coffee for October follows: Morgantown Coffee sells three small coffees for every large coffee. A small coffee sells for $2.00, with a variable...
-
Segment (Division) Evaluation In this assignment you will analyze the performance of PepsiCo's divisions. SFAS 131 requires publicly traded companies to disclose division information in the notes to...
-
A $1000, 6.75% coupon, 25-year Government of Canada bond was issued on March 15, 1971. At what flat price did it trade on July 4, 1981, when the markets required return was 17% compounded...
-
A ferry is moving due east and encounters a southwest wind of speed \(v_{W}=10 \mathrm{~m} / \mathrm{s}\) as shown. The experienced ferry captain wishes to minimize the effects of the wind on the...
-
The tube shown in Figure 9.8 is subjected to an internal pressure, \(p=5 \mathrm{MPa}\), instead of a torque. Neglecting the stress along the longitudinal axis of the tube, and assuming that the mode...
-
A major industrialized state has a state corporate tax rate of 9.6% of taxable income. If a corporation has a state taxable income of $150,000, what is the total state and federal income tax it must...
-
Mastery Problem: CVP and the Contribution Margin Income Statement For planning and control purposes, managers have a powerful tool known as cost-volume-profit (CVP) analysis. CVP shows how revenues,...
-
Pineda State College, a public college, receives notification prior to the start of the fiscal year that it will receive $1,400,000 in appropriations from the state. The appropriations are...
-
ACTIVITY Consumer Skills http://bizklde.com/wp/wp-content/uploads/Jump Start_Chapter 7.pdf Even though you have a great plan to save money every month, there will often be a new Item that you...
-
Clad corporation and Stellar corporation both report on a calendar year basis. Clad merged into Stellar on June 30 Year N. Clad had an allowable net operating loss carryover of $270,000. Stellar's...
-
1. Solve each equation. Where appropriate, state any restrictions and identify any extraneous roots. For any trigonometric equations, solve for all x [0, 27). [14K] a. 1 + 2i + 5 = i +7 [3K]
-
What Construction Management would entail when building truss Systems for larger projects?
-
You invest $100 in stock. The share price at the end of each year is recorded as follows. $106, $90, $95. A $4 dividend is paid each year. What is the arithmetic return and the geometric return of...
-
Describe the goal of Total Quality Control in construction management. Please explain in detail and add reliable source. The course focuses on construction management in real estate.?
-
Explain why the engineer in the following scenario should not have chosen to build a prototype, and recommend the action he should have taken. Ian has been asked to complete a new drone that can fit...
-
Cornell and Roberts are partners who agree to admit Stanley to their partnership. Cornell has a capital balance of $80,000 and Roberts has a capital balance of $120,000. Cornell and Roberts share net...
-
This problem continues the Draper Consulting, Inc., situation from Problem 18-37 of Chapter 18. Draper Consulting provides consulting service at an average price of $175 per hour and incurs variable...
-
Use Amazon.coms balance sheet and the Note 1 data on Allowance for doubtful accounts in Appendix A at the end of this book. Requirements 1. Do accounts receivable appear to be an important asset for...
-
Refer to the data in Short Exercise 3-10. Requirement 1. Compute Famous Cuts net income for the year ended December 31, 2012.
-
Vertical analysis would rarely be performed on which of the following statements or schedules? a. Income statement b. Adjusting entry worksheet c. Balance sheet d. All of the above are common targets...
-
A statement that lists the assets, liabilities, and stockholders equity of a company in percentages only with no dollar amounts is a a. common-size income statement. b. benchmarking analysis. c....
-
In vertical analysis, the base used for comparison on the income statement is a. total expenses. b. total assets. c. net sales. d. gross profit.
Study smarter with the SolutionInn App