Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need some help finishing the income statement as well as step 2 and 3. Credits Account Titles Cash Accounts Receivable Inventory Prepaid Rent Debits

I need some help finishing the income statement as well as step 2 and 3.

image text in transcribed

image text in transcribed

image text in transcribedimage text in transcribed

image text in transcribed

Credits Account Titles Cash Accounts Receivable Inventory Prepaid Rent Debits $37,500 28,600 43,300 2,000 48,300 Land 8,800 20,000 75,000 31,800 175,500 Accounts Payable Notes Payable Common Stock Retained Earnings, January 1, 20X1 Sales Revenue Sales Returns and Allowances Sales Discounts Cost of Goods Sold Salaries and Wages Expense Utility Expense Rent Expense Interest Expense Income Tax Expense Totals 4,700 6,000 67,700 25,900 13,800 24,000 1,600 7,700 $311,100 $311,100 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. Use the Excel IF function to label cell A51 as either "Net Income" or "Net Loss" as appropriate based on the value calculated in cell B51. NOODLES UNLIMITED, INC. Income Statement For the Year Ended December 31, 20X1 Sales Revenue $175,500 Less: 6,000 4,700 164,800 67,700 97,100 Sales Discount Sales Returns and Allowances Net Sales Cost of Goods Sold Gross Margin Expenses: Salaries and Wages Expense Rent Expense Utility Expense Income from Operations 25,900 24,000 13,800 33,400 Income before Income Tax Expense 3. Compute the gross margin percentage. Note: Make sure to include *100 at the end of your formula in order to convert the decimal to a percentage. Gross Margin Percentage percent For the Year Ended December 31, 20X1 36 Sales Revenue $175,500 37 Less: 38 Sales Discount 6,000 39 Sales Returns and Allowances 4,700 40 Net Sales 164,800 Cost of Goods Sold 67,700 42 Gross Margin 97,100 43 Expenses: 44 Salaries and Wages Expense 25,900 Rent Expense 24,000 46 Utility Expense 13,800 47 Income from Operations 33,400 49 Income before Income Tax Expense 53 3. Compute the gross margin percentage. 54 Note: Make sure to include *100 at the end of your formula 55 in order to convert the decimal to a percentage. 56 Gross Margin Percentage percent

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Handbook On Energy Conservation And Energy Auditing A Practical Guide For Energy Management

Authors: Divyabharathi R., Subramanian P.

1st Edition

B0CH25MFSP, 978-6206755623

More Books

Students also viewed these Accounting questions

Question

Develop a program for effectively managing diversity. page 303

Answered: 1 week ago

Question

List the common methods used in selecting human resources. page 239

Answered: 1 week ago