Online College Courses for Credit

+
2 Tutorials that teach Preparing an Expanded Income Statement
Take your pick:
Preparing an Expanded Income Statement

Preparing an Expanded Income Statement

Rating:
(0)
Author: Sophia Tutorial
Description:

Calculate the total cost of goods sold from an expanded income statement.

(more)
See More
Fast, Free College Credit

Developing Effective Teams

Let's Ride
*No strings attached. This college course is 100% free and is worth 1 semester credit.

47 Sophia partners guarantee credit transfer.

299 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 33 of Sophia’s online courses. Many different colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial
what's covered
This tutorial will cover how to prepare an expanded income statement.

Our discussion breaks down as follows:

  1. Expanded Income Statement: A Review
  2. Expanded Sales Calculation
  3. Expanded Cost of Goods Sold Calculation
  4. Expanded Cost of Goods Sold Calculation: Example


1. Expanded Income Statement: A Review

In review, the expanded income statement starts with sales minus cost of goods sold equals gross profit. We then subtract out operating expenses to arrive at income from operations. Finally, we add other revenues or subtract other expenses to equal net income.

We can further break down the expanded income statement by taking the sales piece and looking at gross sales and net sales, separately calculating net sales.

We can also break down the cost of goods sold piece. Cost of goods sold is a component of cost of goods purchased, which is going to give us goods available for sale. Then, we can calculate the cost of goods sold figure. Therefore, the whole process is made up of a few different calculations.


2. Expanded Sales Calculation

Now we're going to break down our sales, looking at gross sales and calculating our net sales, through the expanded sales calculation.

Starting with gross sales, we subtract out sales returns and allowances, and subtract out discounts, to equal net sales.

  • Gross sales are the total sales earned--total cash and total credit sales.
  • Sales returns and allowances is a contra-revenue account, meaning it reduces sales. It is tracked separately from sales to preserve our analysis capabilities, so we can compare our sales returns and allowances to our total sales to see what percentage they are, and perform additional analysis.
  • Discounts is also a contra-revenue account, meaning it reduces our sales. It's an incentive which can be offered to improve prompt payment or improve total sales. It is also tracked separately.

Again, the expanded sales calculation is gross sales minus sales return and allowances, minus discounts, equals net sales.

formula
Expanded Sales Calculation

G r o s s space S a l e s minus S a l e s space R e t u r n s space a n d space A l l o w a n c e s minus D i s c o u n t s equals N e t space S a l e s


3. Expanded Cost of Goods Sold Calculation

We can also expand the cost of goods sold calculation. Starting with our beginning inventory, we add cost of goods purchased to give us the goods available for sale. From there, we subtract out ending inventory to provide the cost of goods sold.

However, we can go even further by breaking down the cost of goods purchased piece of the calculation, starting with purchases, minus discounts, minus purchase returns and allowances to equal net purchases. Next, we would add freight-in, which is the shipping cost to bring the inventory to us, to give us the total cost of goods purchased. This is how we calculate cost of goods purchased, which we can now plug into the cost of goods sold calculation.


4. Calculating Cost of Goods Sold: Example

Now that we have discussed the formulas and calculations involved, let's look at an example of calculating cost of goods sold, as well as cost of goods purchased.

File:8628-cogs1.png

As you can see, we start at the top with beginning inventory, $500,000, which we would pull from our accounting information.

To this beginning inventory, we add cost of goods purchased. Well, how do we figure out cost of goods purchased? We have to go down to the cost of goods purchased calculation.

File:8629-cogs2.png

Starting with our purchases, we subtract out purchase returns and allowances, and subtract out purchase discounts, which provides us with net purchases. Then, once we have our net purchases, we add freight-in, or those shipping costs that we incurred getting the merchandise to us, to give us the total cost of goods purchased, $181,000.

Now we can take the cost of goods purchased, that $181,000, and bring it up to the cost of goods sold calculation. We input it into the cost of goods sold purchased, then we can add our beginning inventory.

File:8630-cogs3.png

This sum equals our goods available for sale: beginning inventory plus cost of goods purchased equals goods available for sale.

Finally, we subtract out our ending inventory--what we have left on hand--to equal the cost of goods sold.

File:8631-cogs4.png

big idea
Again, beginning inventory plus cost of goods purchased equals goods available for sale; subtract ending inventory to provide cost of goods sold.


summary
Today we reviewed the expanded income statement. Within the expanded income statement, we examined the expanded income statement calculations, including the expanded sales calculation, the expanded cost of goods sold calculation, and the cost of goods purchased calculation within that cost of goods sold. Lastly, we walked through an example of an expanded cost of goods sold calculation.

Source: Adapted from Sophia instructor Evan McLaughlin.