Lesson 4.5: Inventory Valuation and the Extended Trial Balance
Introduction
Welcome to Lesson 4.5 of Foundation Accounting, students! In this lesson, we will explore two important topics: Inventory Valuation and the Extended Trial Balance. By the end of this lesson, you will:
- Understand how to value closing inventory at the lower of cost and net realisable value, and why the principle of prudence requires this.
- Learn how opening and closing inventory affects the cost of sales and profit.
- Get familiar with different cost formulas like FIFO and AVCO, and understand their impact on inventory valuation.
- Discover how to compile an extended trial balance, bringing all adjustments together.
- Connect the extended trial balance to financial statements.
Inventory Valuation
What is Inventory Valuation?
Inventory valuation refers to the method a business uses to value its closing inventory. It is crucial to ensure that inventory is accurately reflected on the balance sheet since it can significantly impact a company's financial performance.
Lower of Cost and Net Realisable Value
One fundamental principle of inventory valuation is to record inventory at the lower of cost or net realisable value (NRV). This principle is based on the concept of prudence, which aims to prevent businesses from overstating their assets.
Cost
The cost of inventory includes all expenses incurred in bringing the inventory to its present location and condition. Costs might include:
- Purchase price
- Import duties
- Transport costs
- Handling fees
Let's say a store bought 100 shirts at $10 each. The total cost for the shirts would be:
$$
$\text{Total Cost}$ = \text{Number of Shirts} $\times$ $\text{Cost per Shirt}$ = $100 \times 10$ = 1000 \text{ dollars}
$$
Net Realisable Value (NRV)
Net realisable value is the estimated selling price of inventory in the ordinary course of business minus any estimated costs to complete the sale. For example, if those same shirts can be sold for $15 each, but it will cost $2 in handling for each shirt, the NRV calculation would be:
$$
$\text{NRV}$ = \text{Selling Price} - $\text{Costs to Sell}$ = 15 - 2 = 13 \text{ dollars per shirt}
$$
For 100 shirts, the total NRV would be:
$$
$\text{Total NRV}$ = \text{Number of Shirts} $\times$ $\text{NRV per Shirt}$ = $100 \times 13$ = 1300 \text{ dollars}
$$
Valuation Decision
In this case, the cost of inventory is $1000, and the NRV is $1300. Since $1000 is lower than $1300, the closing inventory should be recorded at 1000.
Impact of Inventory on Cost of Sales and Profit
The closing inventory value affects the cost of sales, which in turn affects profit. The formula for cost of sales is:
$$
\text{Cost of Sales} = \text{Opening Inventory} + \text{Purchases} - \text{Closing Inventory}
$$
For example, if the opening inventory is $500, purchases during the period are 2000, and the closing inventory is 1000, the calculation would be:
$$
\text{Cost of Sales} = 500 + 2000 - 1000 = 1500 \text{ dollars}
$$
This means that the cost of sales for this period is 1500. Understanding this relationship helps businesses analyze their profits, as profit is defined as:
$$
\text{Profit} = $\text{Sales}$ - \text{Cost of Sales}
$$
So, if total sales were 3000, the profit would be:
$$
\text{Profit} = 3000 - 1500 = 1500 \text{ dollars}
$$
Cost Formulas: FIFO and AVCO
FIFO (First In, First Out)
FIFO is a method where the oldest inventory items are sold first. This method is commonly used when it’s more likely that older inventory will be sold before newer stock. For instance, if you purchased 100 items at $10 each and then 100 more at $12 each, under FIFO, the cost of goods sold (COGS) would first account for the earlier $10 items, which can affect the overall profit margins.
AVCO (Average Cost)
The average cost method calculates the cost of inventory based on the average cost of all inventory items. This is useful for large quantities of similar items. The average cost can be calculated as:
$$
\text{Average Cost} = \frac{\text{Total Cost of Inventory}}{\text{Total Number of Items}}
$$
If 100 items are purchased at $10 each and 100 at $12 each, the calculation of the average cost would be:
$$
\text{Average Cost} = $\frac{(100 \times 10) + (100 \times 12)}{200}$ = $\frac{1000 + 1200}{200}$ = 11 \text{ dollars}
$$
This average cost affects the valuation of the closing inventory and ultimately influences net profit.
The Extended Trial Balance
What is an Extended Trial Balance?
The extended trial balance is a detailed report that includes all account balances, including adjustments. It helps ensure that debits equal credits before transferring totals to financial statements.
Compiling the Extended Trial Balance
To create an extended trial balance, follow these steps:
- Gather your unadjusted trial balance.
- Make adjusting entries for items such as accrued expenses, prepayments, and inventory adjustments.
- Update the trial balance with adjustments.
- Total debits and credits to ensure they equal.
Transitioning to Financial Statements
Once you have a balanced extended trial balance, you can seamlessly transition to preparing the financial statements. The balance sheet and income statement depend on the figures from the extended trial balance, such as total assets, liabilities, and equity.
Conclusion
In this lesson, students, you learned about the importance of inventory valuation under the lower of cost and NRV principle and its effects on cost of sales and profit. You also discovered inventory costing methods like FIFO and AVCO and their implications. Lastly, you explored the extended trial balance and how it connects to financial statements. Understanding these concepts is critical for effective financial management.
Study Notes
- Inventory valuation is crucial for accurate financial reporting.
- Value closing inventory at the lower of cost and net realisable value.
- Cost formulas: FIFO (oldest first) and AVCO (average cost).
- The cost of sales affects net profit.
- Extended trial balance helps ensure debits equal credits before financial reporting.