Complete a Income statement worksheet using the data provided in the pictures

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Topic Video
Question

Complete a Income statement worksheet using the data provided in the pictures.

Step #1- Complete the Income Statement heading.
Download the Income Statement and create a heading for Ted's Beds for the year ended December 31, 20XX.
Step #2-Complete the revenue section.
Complete the revenue section of the income statement using the data below.
Account
Amount
Sales
$456,000.00
Sales Discount
$575.00
Sales Retums and Allawances
$3,200.00
Step #3-Complete the cost of merchandise sold section and find gross profit on sales.
Complete the cost of merchandise sold section and find gross profit an sales using the data below. Remember that you
must compute to find Net Purchases, Total Cost of Merchandise Available for Sale. Cast af Merchandise Sold, and Grass
Profit on Sales.
Account
Amount
Merchandise Inventory, January 1, 20XX
$176,000.00
Purchases
$220,000.00
Purchases Discount
$1,300.00
Purchases Retums and Allowances
$2,000.00
Merchandise Inventory. December 31, 20XX $165,000.00
Step #4-Complete the expenses section and find net income or net loss.
Income Statement file complete the expenses section and find net income or net loss using the data below.
Account
Amount
Advertising Expense
$4,000.00
Cash Short and Over
$1.00
Credit Card Fee Expense
$5,000.00
Depreciation Expense-Office Equipment
$2,000.00
Depreciation Expense-Store Equipment
$3,000.00
Transcribed Image Text:Step #1- Complete the Income Statement heading. Download the Income Statement and create a heading for Ted's Beds for the year ended December 31, 20XX. Step #2-Complete the revenue section. Complete the revenue section of the income statement using the data below. Account Amount Sales $456,000.00 Sales Discount $575.00 Sales Retums and Allawances $3,200.00 Step #3-Complete the cost of merchandise sold section and find gross profit on sales. Complete the cost of merchandise sold section and find gross profit an sales using the data below. Remember that you must compute to find Net Purchases, Total Cost of Merchandise Available for Sale. Cast af Merchandise Sold, and Grass Profit on Sales. Account Amount Merchandise Inventory, January 1, 20XX $176,000.00 Purchases $220,000.00 Purchases Discount $1,300.00 Purchases Retums and Allowances $2,000.00 Merchandise Inventory. December 31, 20XX $165,000.00 Step #4-Complete the expenses section and find net income or net loss. Income Statement file complete the expenses section and find net income or net loss using the data below. Account Amount Advertising Expense $4,000.00 Cash Short and Over $1.00 Credit Card Fee Expense $5,000.00 Depreciation Expense-Office Equipment $2,000.00 Depreciation Expense-Store Equipment $3,000.00
Insurance Expense
$3,500.00
Miscellaneous Expense
S800.00
Payrall Taxes Expense
$a,000.00
Rent Expense
$12,000.00
Salary Expense
$85,000.00
Supplies Expense-Office
$2,300.00
Supplies Expense-Store
$3,200.00
Uncollectible Accounts Expense
$1,300.00
Utilities Expense
$4,000.00
Step #5-Complete the income statement and find net income after federal income tax.
Complete the income statement using the data below.
Account
Amount
Federal Income Tax Expense $22.000.00
Step #6-Complete the % of Net Sales
Finally, complete the % af Net Sales column by calculating the component percentages for Cost of Merchandise Sold,
Gross Profit on Sales, Total Expenses and Net Income after Federal Income Tax.
Component percentages are calculated by taking the specific income statement item and dividing that amaunt by the
amount for net sales.
Congratulations, you're done!
Before you submit:
"Did you complete all of the sections?
"Did you find net sales?
"Did you calculate cost of merchandise sold?
"Did you find gross profit an sales?
"Did you find net income before federal income tax?
"Did you complete your component percentages in the % of Net Sales column?
If you can answer yes to these questions then you are at the right place to submit your work for credit.
Transcribed Image Text:Insurance Expense $3,500.00 Miscellaneous Expense S800.00 Payrall Taxes Expense $a,000.00 Rent Expense $12,000.00 Salary Expense $85,000.00 Supplies Expense-Office $2,300.00 Supplies Expense-Store $3,200.00 Uncollectible Accounts Expense $1,300.00 Utilities Expense $4,000.00 Step #5-Complete the income statement and find net income after federal income tax. Complete the income statement using the data below. Account Amount Federal Income Tax Expense $22.000.00 Step #6-Complete the % of Net Sales Finally, complete the % af Net Sales column by calculating the component percentages for Cost of Merchandise Sold, Gross Profit on Sales, Total Expenses and Net Income after Federal Income Tax. Component percentages are calculated by taking the specific income statement item and dividing that amaunt by the amount for net sales. Congratulations, you're done! Before you submit: "Did you complete all of the sections? "Did you find net sales? "Did you calculate cost of merchandise sold? "Did you find gross profit an sales? "Did you find net income before federal income tax? "Did you complete your component percentages in the % of Net Sales column? If you can answer yes to these questions then you are at the right place to submit your work for credit.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 7 steps

Blurred answer
Knowledge Booster
Financial Statements
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.
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