Question

Noodles Unlimited, Inc. sells swimming pool toys. The following adjusted trail balance is for the year ended December 31, 20X1.

XU ? pl Merchandising operations and the multi-step income statement - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOURequired: 1. Prepare a multistep income statement that would be used for internal reporting purposes. Note: When more than on

33 34 NOODLES UNLIMITED, INC. Income Statement For the Year Ended December 31, 20X1 35 36 37 Less: 38 39 40 Net Sales 41 42 G

53 3. Compute the gross margin percentage. 54 Note: Make sure to include *100 at the end of your formula 55 in order to conve

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer 1 2 3 below

NOODLE UNLIMITED INC
Income Statement [Partial]
For the Year ended Dcember 31
Particulars Amount
Sales 175500
Sales Return 4700
Sale Dicount 6000
Net Sales 164800
COGS 67700
Gross margin 97100
Expenses:
salary And Wages 25900
Utilities 13800
Rent 24000
Internet 1600
Operating Profit 31800
Incoem Tax Exp 7700
Net Income 24100 Profit
=IF(M20>0,"Profit","Loss")
Gross margin % 55.33
Add a comment
Know the answer?
Add Answer to:
Noodles Unlimited, Inc. sells swimming pool toys. The following adjusted trail balance is for the year...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • fill out excel Noodles Unlimited, Inc. sells swimming pool toys. The following adjusted trial A1 A...

    fill out excel Noodles Unlimited, Inc. sells swimming pool toys. The following adjusted trial A1 A C D 1 Noodles Unlimited, Inc. sells swimming pool toys. The following adjusted trial balance 2 is for the year ended December 31, 20X1. 4 Debits Credits Account Titles $37,500 5 Cash Accounts Receivable 28,600 43,300 7 Inventory Prepaid Rent 2,000 69,000 9 Equipment 10 Accumulated Depreciation Accounts Payable 12 Notes Payable 13 Common Stock $20,700 8,800 20,000 75,000 11 14 Retained Earnings, January...

  • 1 Noodles Unlimited, Inc. sells swimming pool toys. The following adjusted trial balance 2 is for...

    1 Noodles Unlimited, Inc. sells swimming pool toys. The following adjusted trial balance 2 is for the year ended December 31, 20X1. Credits Debits $37,500 28,600 43,300 2,000 69,000 4 Account Titles Cash 6 Accounts Receivable 7 Inventory Prepaid Rent 9 Equipment 10 Accumulated Depreciation 11 Accounts Payable 12 Unearned Fees 13 Long-term Notes Payable 14 J. Noodle, Capital 15 Sales Revenue 16 Sales Returns and Allowances 17 Sales Discounts 18 Cost of Goods Sold 19 Salaries and Wages Expense...

  • 1 Noodles Unlimited, Inc. sells swimming pool toys. The following adjusted trial balance 2 is for...

    1 Noodles Unlimited, Inc. sells swimming pool toys. The following adjusted trial balance 2 is for the year ended December 31, 20X1. Credits Debits $37,500 28,600 43,300 2,000 69,000 4 Account Titles 5 Cash Accounts Receivable 7 Inventory Prepaid Rent Equipment 10 Accumulated Depreciation Accounts Payable 12 Unearned Fees Long-term Notes Payable 14 J. Noodle, Capital Sales Revenue 16 Sales Returns and Allowances 17 Sales Discounts 18 Cost of Goods Sold 19 Salaries and Wages Expense Depreciation Expense Rent Expense...

  • PLEASE USE EXCEL Formula example =A1+B2 PLEASE USE EXCEL Formula example =A1+B2 fic Noodles Unlimited, Inc....

    PLEASE USE EXCEL Formula example =A1+B2 PLEASE USE EXCEL Formula example =A1+B2 fic Noodles Unlimited, Inc. sells swimming pool toys. The following adjusted trial B C 1 Noodles Unlimited, Inc. sells swimming pool toys. The following adjusted trial balance 2 is for the year ended December 31, 20X1. Credits 6 Debits $37,500 28,600 43,300 2,000 69,000 9 13 4 Account Titles Cash Accounts Receivable Inventory 8 Prepaid Rent Equipment 10 Accumulated Depreciation 11 Accounts Payable 12 Unearned Fees Long-term Notes...

  • $175,500 6,000 4.700 32 33. NOODLES UNLIMITED, INC. Income Statement For the Year Ended December 31,...

    $175,500 6,000 4.700 32 33. NOODLES UNLIMITED, INC. Income Statement For the Year Ended December 31, 20 Sales Revenue 37 Less: 38 Sales Discount Sales Returns and Allowances 40 Net Sales 41 Cost of Goods Sold 42 Gross Margin 43 Expenses: 44 Salaries and Wages Expense 45 Rent Expense 46 Utility Expense 47 Income from Operations 48 Interest Expense 49 Income before Income Tax Expense Income Tax Expense 164,800 67,700 97,100 25,900 24,000 13,800 33,400 1,600 31,800 7,700 30 2....

  • Excel SIM: Merchandising operations and the multi-step income statement 1. Prepare and analyze a merchandiser's multi-step...

    Excel SIM: Merchandising operations and the multi-step income statement 1. Prepare and analyze a merchandiser's multi-step income statement. ? X - Sign In FILE HOME Calibri BLU Paste Merchandising operations and the multi-step income statement - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW 11 AA = E -2 A Alignment Number Conditional Format as Cell Cells Formatting Table Styles Font Styles x for A Clipboard A1 is for the year ended December 31, 20X1. Credits Debits Debits $37,500 28,600...

  • 1. Prepare and analyzed merchandisers multi-step Income statement. ? X XHH FILE - HOME Merchandising operations...

    1. Prepare and analyzed merchandisers multi-step Income statement. ? X XHH FILE - HOME Merchandising operations and the multi-step income statement - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW - Sign In INSERT Paste B I U - - A - - Font Alignment Number - Editing Conditional Format as Cell Formatting Table Styles Styles Cells - Clipboard A37 Account Titles Credits Debits $37,500 28,6001 43,300 2,000 69,000 Cash Accounts Receivable Inventory Prepaid Rent Equipment Accumulated Depreciation Accounts Payable Unearned...

  • ML INFL.com - Official Site of th Dallas CowboysOfficial Graw Hill Canned Deep McGraw Hill Come...

    ML INFL.com - Official Site of th Dallas CowboysOfficial Graw Hill Canned Deep McGraw Hill Come Deep 03 Ad Learning GN X https://newconnecteducation.com low correcthtml h 3 Adl Learning - GM and Excel is calls dining Paster mood Number - Condtonal Forrest an cat Forg Tle Styles Styles 0 2. Use the Excel IF function to label cell ASI as either "Net Income" or "Netloss" as 31 appropriate based on the value calculated in cell 51. Sales Discount 4,700 References...

  • Toys for Big Boys, Inc.'s classified balance sheet and multistep income statement as of and for the year ended January 31, 2018 follow:

    Toys for Big Boys, Inc.'s classified balance sheet and multistep income statement as of and for the year ended January 31, 2018 follow: Calculate the gross profit percentage and the net income percentage for Toys for Big Boys, Inc, for 2018 Start by calculating the gross profit percentage for 2018. Select the formula and then complete the calculation. (Round to the nearest one-hundredth of a percent, XXXS) 

  • Pool Corporation, Inc., is the world's largest wholesale distributor of swimming pool supplies and equipment. It...

    Pool Corporation, Inc., is the world's largest wholesale distributor of swimming pool supplies and equipment. It is a publicly traded corporation that trades on the NASDAQ exchange under the symbol POOL. It sells these products to swimming pool repair and service businesses like Penny's Pool Service & Supply, Inc., swimming pool builders, and retail swimming pool stores. The majority of these customers are small, family-owned businesses like Penny's. Its trial balance and additional information adapted from a recent year ended...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT