Using the Weighted Average Profit Method for Share Valuation

When you’re trying to figure out what a company’s shares are really worth, simply averaging past profits might not tell the whole story. What if the company performed exceptionally well in recent years but struggled earlier? Or what if there was a one-time windfall that skews the numbers? This is where the Weighted Average Profit Method comes into play – a sophisticated approach that gives more importance to recent performance while still considering historical data to arrive at a fair share valuation.

What makes the weighted average profit method special? 🔗

The Weighted Average Profit Method is like giving different years of a company’s performance different “votes” when determining share value. Instead of treating a profit from five years ago the same as last year’s profit, this method recognizes that recent performance is typically more indicative of future prospects.

Think of it this way: if you were hiring someone for a job, would you give equal weight to their performance from five years ago versus their recent achievements? Probably not. Similarly, when valuing shares, investors and analysts often find that recent profits provide better insights into a company’s current trajectory and future potential.

The method works by assigning numerical weights to profits from different years, with higher weights typically given to more recent years. These weighted profits are then averaged to create a more representative picture of the company’s earning capacity, which forms the basis for share valuation.

How does weighting work in practice? 🔗

The weighting system is surprisingly straightforward once you understand the logic. Let’s say you’re analyzing a company’s last five years of performance. You might assign weights like this:

Most recent year: Weight of 5
Second most recent year: Weight of 4
Third year back: Weight of 3
Fourth year back: Weight of 2
Oldest year: Weight of 1

This weighting scheme reflects the belief that the most recent year’s performance is five times more relevant than the oldest year’s performance. However, these weights aren’t set in stone – they can be adjusted based on the specific circumstances of the company or industry.

For instance, if a company operates in a rapidly evolving tech sector, you might assign even higher weights to recent years. Conversely, for a stable utility company, the weights might be more evenly distributed since performance tends to be more consistent over time.

Step-by-step calculation process 🔗

Let’s walk through a practical example to see how this method works. Imagine ABC Manufacturing Company with the following profit data over five years:

Year 1 (oldest): ₹2,00,000
Year 2: ₹2,50,000
Year 3: ₹3,00,000
Year 4: ₹3,50,000
Year 5 (most recent): ₹4,00,000

Using our earlier weighting system (1, 2, 3, 4, 5), here’s how we calculate the weighted average profit:

Step 1: Calculate weighted profits 🔗

Year 1: ₹2,00,000 × 1 = ₹2,00,000
Year 2: ₹2,50,000 × 2 = ₹5,00,000
Year 3: ₹3,00,000 × 3 = ₹9,00,000
Year 4: ₹3,50,000 × 4 = ₹14,00,000
Year 5: ₹4,00,000 × 5 = ₹20,00,000

Step 2: Sum up weighted profits and weights 🔗

Total weighted profits: ₹2,00,000 + ₹5,00,000 + ₹9,00,000 + ₹14,00,000 + ₹20,00,000 = ₹50,00,000
Total weights: 1 + 2 + 3 + 4 + 5 = 15

Step 3: Calculate weighted average profit 🔗

Weighted Average Profit = Total Weighted Profits ÷ Total Weights
Weighted Average Profit = ₹50,00,000 ÷ 15 = ₹3,33,333

Notice how this weighted average of ₹3,33,333 is higher than the simple average of ₹3,00,000 (sum of all profits divided by 5). This reflects the company’s improving trend, which the weighted method captures more effectively.

Converting weighted average profit to share value 🔗

Once you have the weighted average profit, the next step is converting it into a per-share value. This involves determining an appropriate capitalization rate or price-to-earnings ratio based on the company’s risk profile, industry standards, and market conditions.

Let’s continue with our ABC Manufacturing example. Suppose the appropriate capitalization rate for this company is 12% (meaning investors expect a 12% return). The share value calculation would be:

Share Value = Weighted Average Profit ÷ Capitalization Rate
Share Value = ₹3,33,333 ÷ 0.12 = ₹27,77,775

If ABC Manufacturing has 10,000 outstanding shares, then:

Value per Share = Total Share Value ÷ Number of Shares
Value per Share = ₹27,77,775 ÷ 10,000 = ₹277.78

Advantages of the weighted average method 🔗

This method offers several compelling benefits over simpler valuation approaches. Trend recognition is perhaps the most significant advantage – it automatically accounts for improving or declining performance patterns. A company showing consistent growth will have a higher valuation than one with the same average profit but erratic performance.

Reduced impact of outliers is another key benefit. If a company had one exceptionally good or bad year, the weighted method prevents that single year from disproportionately affecting the valuation. The weighting system naturally dampens the effect of unusual years, especially if they occurred further in the past.

The method also provides greater flexibility in reflecting different business contexts. For rapidly changing industries, weights can be heavily skewed toward recent years. For stable businesses, weights can be more evenly distributed.

When to use this method 🔗

The Weighted Average Profit Method works best in specific scenarios. It’s particularly valuable for companies with clear performance trends – whether improving or declining. If a business has been consistently growing its profits or facing steady decline, this method will capture that trajectory better than simple averaging.

It’s also excellent for businesses in dynamic industries where recent performance is more predictive of future results. Technology companies, fashion retailers, or any business heavily influenced by changing consumer preferences benefit from this approach.

However, the method is less suitable for highly cyclical businesses where profits naturally fluctuate in predictable patterns. For such companies, it might be better to use cycle-adjusted averages or other specialized methods.

Limitations to keep in mind 🔗

Like any valuation method, the Weighted Average Profit Method has its limitations. The choice of weights is somewhat subjective – there’s no universal formula for determining the “correct” weights. Different analysts might reasonably choose different weighting schemes, leading to varying valuations.

The method also assumes that trends will continue, which isn’t always the case. A company might be improving now but face challenges that will reverse this trend. The weighted average might overvalue such a company.

Additionally, this method focuses solely on historical profits and doesn’t directly incorporate forward-looking factors like new products, market expansion plans, or changing competitive dynamics.

Comparing with other methods 🔗

To truly appreciate the Weighted Average Profit Method, it’s helpful to see how it compares with alternatives. The simple average method treats all years equally, which might not reflect current business realities. The super profit method focuses on excess returns over normal profits, which can be useful but requires determining a “normal” profit rate.

Asset-based methods look at the company’s balance sheet rather than income statement, which might miss the value of intangible assets or ongoing business operations. Each method has its place, and sophisticated valuations often use multiple approaches to triangulate a fair value range.

The weighted average method strikes a balance between simplicity and sophistication. It’s more nuanced than simple averaging but less complex than discounted cash flow models that require detailed future projections.

What do you think? How would you decide on the appropriate weights for different years when valuing a company you’re familiar with? What factors would influence your weighting decisions?