Noodles Unlimited, Inc. sells swimming pool toys. The following adjusted trial balance is for the year...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Noodles Unlimited, Inc. sells swimming pool toys. The following adjusted trial balance is for the year ended December 31, 20X1, Account Titles Cash Debits $37,500 28,600 43,300 2,000 69,000 Credits Accounts Receivable Inventory Prepaid Rent Equipment D Accumulated Depreciation Accounts Payable 2 Notes Payable 3 Common Stock 4Retained Earnings, January 1, 20X1 5 Sales Revenue 6 Sales Returns and Allowances 7 Sales Discounts 8 Cost of Goods Sold 9 Salaries and Wages Expense 0Depreciation Expense Rent Expense 2 Interest Expense 3 Income Tax Expense -4 $20,700 8,800 20,000 75,000 31,800 175,500 4,700 6,000 67.700 25,900 13,800 24,000 1,600 7,700 $331 800 Totals $331,800 Cheet Required: 1. Prepare a multistep income statement that would be used for internal reporting purposes. Note: When more than one correct account could appear in a cell, list items in order of largest to smallest dollar amounts. Use cell referencing to select account titles and values. All numbers should appear as positive numbers. 2. After entering the formula in cell B52, use the Excel IF function to label cell A52 as either "Net Income" or "Net Loss" as appropriate based on the value calculated in cell B52. NOODLES UNLIMITED, INC. Income Statement For the Year Ended December 31, 20X1 Sales Revenue Less: $175.500 Net Sales Cost of Goods Sold Gross Profit - Expenses: 5 Salaries and Wages Expense 5 Rent Expense 67,700 25,900 24,000 B Income from Operations Interest Expense 1,600 B. Net Sales Cost of Goods Sold Gross Profit Expenses: Salaries and Wages Expense -Rent Expense 67,700 25,900 24,000 s Income from Operations P Interest Expense Income before Income Tax Expense 1,600 43. Compute the gross profit percentage. S Note: Make sure to include *100 at the end of your formula 6 in order to convert the decimal to a percentage. 7 Gross Profit Percentage percent Noodles Unlimited, Inc. sells swimming pool toys. The following adjusted trial balance is for the year ended December 31, 20X1, Account Titles Cash Debits $37,500 28,600 43,300 2,000 69,000 Credits Accounts Receivable Inventory Prepaid Rent Equipment D Accumulated Depreciation Accounts Payable 2 Notes Payable 3 Common Stock 4Retained Earnings, January 1, 20X1 5 Sales Revenue 6 Sales Returns and Allowances 7 Sales Discounts 8 Cost of Goods Sold 9 Salaries and Wages Expense 0Depreciation Expense Rent Expense 2 Interest Expense 3 Income Tax Expense -4 $20,700 8,800 20,000 75,000 31,800 175,500 4,700 6,000 67.700 25,900 13,800 24,000 1,600 7,700 $331 800 Totals $331,800 Cheet Required: 1. Prepare a multistep income statement that would be used for internal reporting purposes. Note: When more than one correct account could appear in a cell, list items in order of largest to smallest dollar amounts. Use cell referencing to select account titles and values. All numbers should appear as positive numbers. 2. After entering the formula in cell B52, use the Excel IF function to label cell A52 as either "Net Income" or "Net Loss" as appropriate based on the value calculated in cell B52. NOODLES UNLIMITED, INC. Income Statement For the Year Ended December 31, 20X1 Sales Revenue Less: $175.500 Net Sales Cost of Goods Sold Gross Profit - Expenses: 5 Salaries and Wages Expense 5 Rent Expense 67,700 25,900 24,000 B Income from Operations Interest Expense 1,600 B. Net Sales Cost of Goods Sold Gross Profit Expenses: Salaries and Wages Expense -Rent Expense 67,700 25,900 24,000 s Income from Operations P Interest Expense Income before Income Tax Expense 1,600 43. Compute the gross profit percentage. S Note: Make sure to include *100 at the end of your formula 6 in order to convert the decimal to a percentage. 7 Gross Profit Percentage percent
Expert Answer:
Answer rating: 100% (QA)
Income Statement Sales Revenue 17550000 Less Sales Returns and Allowances 470000 Sales Di... View the full answer
Related Book For
Financial Accounting
ISBN: 9781618533111
6th Edition
Authors: Michelle L. Hanlon, Robert P. Magee, Glenn M. Pfeiffer, Thomas R. Dyckman
Posted Date:
Students also viewed these accounting questions
-
The following adjusted trial balance is for True man Consulting Inc. at December 31, 2018. The company had no stock issuances or repurchases during 2018. REQUIRED a. Prepare its income statement and...
-
The following unadjusted trial balance is for the year ended 30 June 2019: BILLY GOAT LTD Unadjusted Trial Balance as at 30 June 2019 Debit Credit Bank overdraft Vehicle rental expenses Cash at bank...
-
The Sky Blue Corporation has the following adjusted trial balance at December 31. Prepare an income statement for the year ended December 31. How much net income did the Sky Blue Corporation generate...
-
Figure shows three rotating, uniform disks that are coupled by belts. One belt runs around the rims of disks A and C. Another belt runs around a central hub on disk A and the rim of disk B. The belts...
-
In a Consumer Reports Research Center Telephone survey of 427 women, 38% said that they purchased clothing online. a. What is the exact value that is 38% of 427? b. Could the result from part (a) be...
-
Read NASW Code of Ethics Sections 1,2,5,& 6 and the Delaware Lawyer's Rules of Professional Conduct., 1.2, 1.6,.1.7,.1.10 & 1.13. In 2/3 pages, compare any two sections of the NASW Code with any two...
-
A marketed asset's price \(x\) is governed by the mean reverting process where \(\eta, \theta\), and \(\sigma\) are positive constants and \(z\) is a Wiener process. (a) Let \(V(x, t)\) be a given...
-
Predecting sales and variable costs using contribution margin Bloom company management predicts that it will incur fixed costs of $160,000 and earn protax income of $164,000 in the next period. Its...
-
A girl delivering newspapers covers her route by traveling 8.66 blocks north, 3.28 blocks west, and 4.00 blocks south. Find the angle (a positive value in , between 0 and 360) of her resultant...
-
Using a linear programming framework and the data from case Exhibit 1, formulate and solve the problem of finding the cost-minimizing set of bids that meet Mars' business requirements and determines...
-
Use the three-step approach to analyze the following ethics-related issues using APES 110 and Corporations Act 2001. An audit senior, John Smith, is in the engagement team of ABC Bank, and he also...
-
Consider hosts X, Y, Z, W and learning bridges B1, B2, B3, with initially empty forwarding tables, as in Figure 3.48. (a) Suppose X sends to Z. Which bridges learn where X is? Does Ys network...
-
Given the extended LAN shown in Figure 3.46, assume that bridge B1 suffers catastrophic failure. Indicate which ports are not selected by the spanning tree algorithm after the recovery process and a...
-
Consider an ARQ algorithm running over a 20-km point-to-point fiber link. (a) Compute the propagation delay for this link, assuming that the speed of light is 2 10 8 m/s in the fiber. (b) Suggest a...
-
IP hosts that are not designated routers are required to drop packets misaddressed to them, even if they would otherwise be able to forward them correctly. In the absence of this requirement, what...
-
Suppose two TCP connections share a path through a router R. The routers queue size is six segments; each connection has a stable congestion window of three segments. No congestion control is used by...
-
Gearty and Fox organized Ace Corp., which issued voting common stock with a fair market value of $120,000. They each transferred property in exchange for stock as follows: Property: Gearty: Building;...
-
On March 31, 2018, Gardner Corporation received authorization to issue $30,000 of 9 percent, 30-year bonds payable. The bonds pay interest on March 31 and September 30. The entire issue was dated...
-
On December 31, 2018, Kasznik, Inc., issued $720,000 of 11%, 10-year bonds for $678,708, yielding an effective interest rate of 12%. Semiannual interest is payable on June 30 and December 31 each...
-
Market-Probe, a market research firm, had the following transactions in June 2019, its first month of operations. June 1 B. May invested $24,000 cash in the ti.m1 in exchange for common stock. 1. The...
-
Siemens AG reports the following basic and diluted earnings per share in its 2018 annual report. a. Describe the accounting definitions for basic and diluted earnings per share. b. Identify the...
-
Consider absence from work as an example of organizational behaviour. What are some of the factors that might predict who is likely to be absent from work? How might you explain absence from work?...
-
Do you think that organizations should base their hiring decisions on applicants personalities? What are the advantages and disadvantages of doing this? If an organization were to do this, what...
-
Use the contingency approach to describe a task or an organizational department where a more classical management style might be effective. Then do the same for a task or department where the human...
Study smarter with the SolutionInn App