No-Heir Estate Planning

Expanding Options for Marriage, Defense, Medical Marijuana, Amateur Athletes and Rail Workers

Understanding the Weighted Average Cost (WAC) Method for Inventory Valuation

tranche contributes to the overall valuation of its cost of goods sold (COGS) and inventory. Recognized by both GAAP and IFRS, it’s determined by taking the cost of goods available for sale and dividing it by the quantity of inventory ready to be sold. It’s important to note that while WAC is a generally accepted accounting principle, it’s not as precise as FIFO or LIFO; however, it is effective at assigning average cost of production to a given product.

It’s done primarily for types of inventories where parts are so intertwined that it makes it problematic to attribute clear-cut expenditures to a particular part. This often happens when stockpiles of parts are indistinguishable from each other. It also accounts for businesses offering their inventory for sale all at once. Here’s a visual representation of the formula: 

Weighted Average Cost (WAC) Method Formula

WAC per unit = Cost of goods available for sale / Units available for sale

Costs of goods available for sale is determined by adding new purchases of inventory to the value of what the business already had in its existing stock. Units available for sale is how many saleable items the company possesses. Its value is assessed per item and encompasses starting inventory and additional purchases.

When it comes to calculating WAC, there are two different types of inventory analysis systems: periodic and perpetual.

Periodic Inventory System

In this system, the business tallies its inventory at the end of the accounting period – be it a quarter, half or fiscal year – and analyzes how much the inventory costs. This then determines the value of the remaining inventory. The COGS is then calculated by adding how much starting, final, and additional inventory within the accounting period cost.

Perpetual Inventory System

This system puts a bigger emphasis on more real-time management of its stock levels. The trade-off for such real-time tracking of inventory requires more company financial resources. Looking at an example of how a company began its fiscal year with the following inventory can illustrate how it works.

At the beginning of the year, a company had 1,000 units, costing $50 per unit. It also made three additional inventory purchases going forward.

Jan 20: 75 units costing $100 = $7,500

Feb 17: 150 units costing $150 = $22,500

March 18: 300 units costing $200 = $60,000

During the fiscal year, the business sold:

235 units sold during the last week of February

325 units sold during the last week of March

Looking at the Periodic Inventory System, for the first three months of its fiscal year, the company can determine its COGS and the number of items ready to be sold over the first three months of its fiscal year.

WAC per item – ($50,000 + $7,500 + $22,500 + $60,000) / 1,525 = $91.80

Based on this method, the WAC per unit would be multiplied by the number of units sold during the accounting period, therefore:

560 units x $91.80 = $51,408 (inventory sold)

To calculate the final inventory value, we take the entire purchase cost and subtract the remaining inventory to arrive at the valuation:

$140,000 – $51,408 = $88,592

Perpetual Inventory System

Unlike the periodic inventory system, this looks at determining the mean prior to the transaction of items:

This would calculate the average before the 235 units were sold during the last week of February:

WAC for each item: ($50,000 + $7,500 + $22,500) / 1,225 = $65.31

Looking at the 235 units sold during the last week of February, it’s calculated as follows:

235 x $65.31 = $15,347.85 (inventory sold)

$80,000 – $15,347.85 = $64,652.15 (remaining inventory value)

Before calculating for the 325 units sold the last week of March, the unit valuation per WAC is: ($64,652.15 + $60,000) / (1225 – 235 + 300) = 1290 = $96.63

Looking at the 325 units sold during the last week of March is calculated as follows:

325 x $96.63 = $31,404.75 (inventory sold)

$124,652.15 – $31,404.75 = $93,247.40 (remaining inventory)

Based on these options, businesses have the choice, along with LIFO and FIFO, to decide how they want to vary it based on their own business needs.

The IRS Versus the Taxpayer

What is Datafication, and Should Business Leaders Take Notice?

Your Year-End Financial Checklist

free, downloadable template to get you started on your 2023 plan. 

Rethink Your Savings

If you already have a healthy amount in savings, congrats. Make sure it’s an account that’s interest-bearing and you have the best rate. However, if you had to dip into your emergency savings, then chart a course to replenish it. If you don’t have an emergency fund, it makes good sense to start one. A smart rule to consider is having six months of income saved up, should your heater go out, you experience a sudden job loss, or suffer unforeseen medical expenses that your insurance doesn’t cover. A no-nonsense way to begin is to automate a certain amount each month that will be deducted from your paycheck. You’ll begin to accumulate money in no time. Best of all, you’ll never miss it.

Evaluate Your Debt

Have you made progress in paying it down? Or have you gone the other way?  If you’ve eliminated your debt, once again, congrats. If you’ve increased your debt, don’t despair because there are some easy ways to cut expenses. Slow down on eating out. Review your subscriptions and see which ones you really need. Here’s a list of more areas to consider. Another way to get rid of the shackles of debt is to apply for a consolidation loan. You might also use the debt snowball method—starting with the smallest debt and working your way up to the largest. Or the inverse, the debt avalanche, where you pay off high-interest rate balances first.

Contribute to Your 401(k) by Dec. 31

You still have time to do this, but make sure it happens before the clock strikes midnight on Dec. 31. If you’re fortunate enough to receive a year-end bonus, you might want to put as much of it as you can toward your 401(k) plan. For the New Year, increase the amount you’re contributing. Just one or more percentage points higher can make a big difference. Finally, if your company offers a match that you have yet to take advantage of (read: max out), do so before it’s too late.

Consider a Roth Conversion

If you’ve experienced a loss of income this year, you may be in a lower tax bracket. This means you can take advantage of your situation by converting some of your pre-tax assets like a Traditional IRA into a Roth IRA. If you’ve earned too much to convert to a Roth IRA, a back-door Roth IRA contribution might be the way to go. Here’s how you do it: Deposit money into a non-deductible Traditional IRA, then convert that IRA into a Roth IRA. But before you do anything at all, consult your tax advisor, as there are potential costs and tax liabilities that might come up.

Check your FSA Balance

An FSA (Flexible Spending Account) is a great benefit if your employer offers it. However, check your balance to see how much you have left because the rule is: Use it or lose it. That said, many companies offer a grace period until mid-March to spend what you have left, though not all do. Make sure to inquire about the rules of your account before the New Year.

Get a Free Credit Report

When was the last time you checked your credit? If you haven’t done so, now’s a good time because looking back can help you plan ahead. Here’s a great place to get a free report. If you notice any errors or discover any identity theft, you can immediately take steps to correct them and start with a clean slate for 2023.

While taking care of financial matters at the end of the year can be a love/hate kind of thing to do, if you spend a little time now, the coming days might be substantially merrier and bright.

Sources

https://www.bankrate.com/personal-finance/end-of-year-financial-checklist/

https://www.fundingcloudnine.com/budget-cut/

https://www.bankrate.com/retirement/what-is-a-backdoor-roth-ira/

Inventory Valuation: How Companies Can Calculate It

referred to as LIFO – or Last In, First Out. This means that businesses sell what they’ve produced first, then move on to the older inventory. If any inventory is left at the end of the accounting time-frame, it’s accounted for accordingly. Assuming the same 500 widgets were sold in the particular accounting period, the time-frame’s COGS would be $2.50 per widget, with the 500 widgets left over in inventory valued at the $2 per widget cost.  

One important caveat to this type of valuation is with regard to inventory that’s perishable or becomes obsolete quickly (cell phones, televisions, etc.). It is not an effective method because the product will either spoil or become worth next to nothing due to highly competitive industries. For this approach, using the most recently produced goods first would lend their COGS basis to be higher. In one respect, the higher COGS basis can lower profits, but can also offset taxes due to the same effect. The third type of inventory valuation is referred to as Average Cost. This method is a way to blend LIFO and FIFO, which takes the average of inventory across all production and storage timelines. This approach averages costs in proportion to the amount of widgets produced in each run, then calculates the mean cost to determine the ending inventory and COGS figures.

[(500 x $2) + (500 x $2.50)]/1,000 = ($1,000 + $1,250)/1,000 = $2,250/1,000 = $2.25

Therefore, the average cost for inventory using this method would be $2.25 per widget.

With different types of inventory valuation explained, there are considerations that businesses should be mindful for each approach. This can make a difference to those running the company and for potential investors and lenders contemplating investing in or loaning the company money.

Retirement Tax Planning For 2023

Improving Federal Hiring Processes, Foreign Election Influence and Natural Disaster Protections

Defining and Calculating Amortization

noticeable differences for each method, including how to salvage value is considered, whether accelerated expensing is allowed, and how each type is expressed on financial statements.

Amortization

Amortization is an accounting practice of spreading the cost of an intangible asset over its useful life. Examples of intangible assets, according to the Internal Revenue Service’s “Section 197 Intangibles,” include goodwill, intellectual property such as trademarks, patents, and government or agency-granted permits or licenses. These are all assets that must be amortized over 15 years.

Based on IRS regulations, when it comes to determining how an asset is expensed over its useful life, amortization is most similar to the straight-line basis method of depreciation. 

It’s important to note that the timeframe of amortization is subject to interpretation. Examples, according to the IRS, include a 36-month amortization timeline for computer software because it’s not categorized as an asset under the same IRS Section. Other examples not mandated to be amortized under a 15-year time frame include interests to land, business partnerships, financial contracts (such as interest rate swaps) or creation of media. 

Depreciation

One of the main differences when it comes to depreciation is that it focuses on tangible or fixed assets and requires a certain percentage of its useful life to be allocated each year. Examples of assets that can be expensed include trucks for service calls, computers, printers, equipment for production, etc. Another important difference is that the asset’s salvage value is deducted from the asset’s starting cost. The remaining balance (original cost – salvage cost) determines annual expensing amounts, which is divided by the asset’s years of useful life.

Along with the above method of depreciation, also called “Straight-Line Method,” there are other ways depreciation can determine how much is expensed annually and over the asset’s useful life. For example, Declining Balance or Double Declining Balance methods are alternate ways businesses can depreciate their assets – some frontload the amounts to take advantage of accounting/tax rules to reduce their tax liabilities. Another way is to depreciate via Units of Production. This method pro-rates the level of an asset’s expected use within a particular accounting period, on a per-unit basis, to determine how much the company can expense during a particular accounting timeframe.

When it comes to accounting for goodwill, according to a November 2020 electronic survey of CFA charter holders by the CFA Institute, respondents found that investors who see amortization used by companies still require investors’ due diligence. Sixty-one percent of respondents said there need to be alternate ways to figure out if management is effective or not, and 63 percent said that amortization “distorts financial metrics.”

When it comes to understanding and navigating the differences between amortization and depreciation, business owners and investors need to be well-versed in performing due diligence to ensure compliance.

Sources

https://www.irs.gov/pub/irs-pdf/p535.pdf

https://www.cfainstitute.org/en/research/survey-reports/goodwill-investor-perspectives