Account Titles Cash Accounts Receivable Inventory Prepaid Rent Equipment Accumulated Depreciation Accounts Payable Unearned Fees Long-term Notes Payable J. Noodle, Capital Sales Revenue Sales Returns and Allowances Sales Discounts Cost of Goods Sold Salaries and Wages Expense Depreciation Expense Rent Expense Interest Expense Loss on Sale of Equipment Totals Debits 537,500 28,600 43,300 69,000 4,700 6,000 67,700 25,900 13,800 24,000 1,600 7,700 $331,800 P Credits $20,700 8,800 20,000 75,000 31,800 175,500 $331,800

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
FILE
Paste
Clipboard
A1
Ba
G
7
HOME
r
Calibri
B
Account Titles
Cash
4
READY
IU
V
INSERT
Accounts Receivable
Inventory
Prepaid Rent
6
9
Equipment
10 Accumulated Depreciation
11 Accounts Payable
12
Unearned Fees
13 Long-term Notes Payable
14 J. Noodle, Capital
Y
Font
15 Sales Revenue
16 Sales Returns and Allowances
17 Sales Discounts
18 Cost of Goods Sold
19 Salaries and Wages Expense
20 Depreciation Expense
21 Rent Expense
22
11
Merchandising operations and the multi-step income statement - Excel
PAGE LAYOUT
DATA
VIEW
A
C
1 Noodles Unlimited, Inc. sells swimming pool toys. The following adjusted trial balance
2
s for the year ended December 31, 20x1.
3
4
15
www
A A
Py
FORMULAS
E
%
Alignment Number
Debits
Conditional Format as
Cell
Formatting Table Styles-
Styles
ut fix Noodles Unlimited, Inc. sells swimming pool toys. The following adjusted trial
537,500
28,600
43,300
2,000
69,000
4,700
6,000
67,700
25,900
13,800
24,000
Credits
Interest Expense
23 Loss on Sale of Equipment
24
Totals
25
26 tequired:
27 Prepare a multisteo income statement that would be used for internal reporting purposes.
▶
Sheet1
1,600
7,700
$331,800
REVIEW
$20,700
8,800
20,000
75,000
31,800
175,500
$331,800
D
Cells
[3]
?
E
Editing
Sign In
F
+ 60%
Transcribed Image Text:FILE Paste Clipboard A1 Ba G 7 HOME r Calibri B Account Titles Cash 4 READY IU V INSERT Accounts Receivable Inventory Prepaid Rent 6 9 Equipment 10 Accumulated Depreciation 11 Accounts Payable 12 Unearned Fees 13 Long-term Notes Payable 14 J. Noodle, Capital Y Font 15 Sales Revenue 16 Sales Returns and Allowances 17 Sales Discounts 18 Cost of Goods Sold 19 Salaries and Wages Expense 20 Depreciation Expense 21 Rent Expense 22 11 Merchandising operations and the multi-step income statement - Excel PAGE LAYOUT DATA VIEW A C 1 Noodles Unlimited, Inc. sells swimming pool toys. The following adjusted trial balance 2 s for the year ended December 31, 20x1. 3 4 15 www A A Py FORMULAS E % Alignment Number Debits Conditional Format as Cell Formatting Table Styles- Styles ut fix Noodles Unlimited, Inc. sells swimming pool toys. The following adjusted trial 537,500 28,600 43,300 2,000 69,000 4,700 6,000 67,700 25,900 13,800 24,000 Credits Interest Expense 23 Loss on Sale of Equipment 24 Totals 25 26 tequired: 27 Prepare a multisteo income statement that would be used for internal reporting purposes. ▶ Sheet1 1,600 7,700 $331,800 REVIEW $20,700 8,800 20,000 75,000 31,800 175,500 $331,800 D Cells [3] ? E Editing Sign In F + 60%
A1
242428SFORMIDABBZS4=225S
41 Net Sales
A
26 Required:
27 1. Prepare a multistep income statement that would be used for internal reporting purposes.
28 Note: When more than one correct account could appear in a cell, list items in order of largest to
29 smallest dollar amounts. Use cell referencing to select account titles and values.
NOODLES UNLIMITED
Income Statement
For the Year Ended December 31, 2001
43 Gross Proalit
30 All numbers should appear as positive numbers.
31
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 B852.
32
44 Experses:
43 Income from Operations
49 Other Expenses and Losses
Noodles Unlimited, Inc. sells swimming pool toys. The follc
▶
B
54 3. Compute the gross profit percentage.
155 Nate Makes me in include 100ettheendalous formula
Sheet1
..
C
D
Transcribed Image Text:A1 242428SFORMIDABBZS4=225S 41 Net Sales A 26 Required: 27 1. Prepare a multistep income statement that would be used for internal reporting purposes. 28 Note: When more than one correct account could appear in a cell, list items in order of largest to 29 smallest dollar amounts. Use cell referencing to select account titles and values. NOODLES UNLIMITED Income Statement For the Year Ended December 31, 2001 43 Gross Proalit 30 All numbers should appear as positive numbers. 31 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 B852. 32 44 Experses: 43 Income from Operations 49 Other Expenses and Losses Noodles Unlimited, Inc. sells swimming pool toys. The follc ▶ B 54 3. Compute the gross profit percentage. 155 Nate Makes me in include 100ettheendalous formula Sheet1 .. C D
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Basic Accounting Terms
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education