Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A list of accounts and balances below are ending December 31, 2019, from Wesley's Machining & Welding, Inc. (WMW). Using these account balances, complete a

A list of accounts and balances below are ending December 31, 2019, from Wesley's Machining & Welding, Inc. (WMW). Using these account balances, complete a cost of goods sold (COGS) worksheet. Then construct the income statement for the period ending December 31, 2019. Use the balance from the COGS worksheet for COGS on the income statement. Separate operating expenses from the non-operating expenses to sum operating income as EBITD (earnings before interest, taxes, depreciation). Then subtract non-operating expenses and add in non-operating income to determine net income.

Use the associated Excel spreadsheet to complete the assignment. Note, some of the income statement line items are already completed. Fill in the remaining account names and totals in the fields highlighted in the spreadsheet. Formulas have been pre-set for your convenience to use if you want.

image text in transcribed

image text in transcribed

Account Balance Beginning inventory (January 1, 2019) $22,000 Depreciation expenses $12,000 Ending inventory (December 31, 2019) $16,000 Income tax expenses $5,700 Insurance expense $2,500 Interest expenses $3,000 Interest revenue $500 Marketing expenses $7,000 Office supplies expenses $1,800 Purchase discounts (for inventory) $2,000 Purchases (inventory) $100,000 Sales commission expenses (20%) $50,000 Total revenue for the year ending December 31, 2019 $260,000 Transportation in (inventory) $4,500 Utilities expense $13,000 Wages expenses $52,000 a) WMW COGS Worksheet Cost of Goods Sold Worksheet Inventory Purchases Less: Purchase discounts (2%) Net Purchases Add: Transportation-in Net cost of purchases Cost of goods available for sale Less: Inventory Cost of goods sold $ b) WMW Incomee Statemt Wesley's Machining & Welding, Inc. Income Statement Operating Revenue Total Revenue Gross Margin Operating Expenses Sales commissions Total operating expenses Income from operations (EBITDA) Non-operating Expenses Non-operating Revenue NET INCOME $

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

Information Systems Control And Audit

Authors: Ron Weber

1st Edition

0139478701, 978-0139478703

More Books

Students also viewed these Accounting questions

Question

Describe the five elements of the listening process.

Answered: 1 week ago