Answered step by step
Verified Expert Solution
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.
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 percentStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started