Explore Advisory with Furqan, live · Mon 2 Nov, 6 PMSave my seat
uraan logo

Forecasting Results!

Published December 8, 2025

14:37

A Practical Guide to Demand and Cost Analysis for Company Profitability

What This Analysis Covers

When you're evaluating a company's financial health, you really need to look at three things: the demand analysis for the company's products, the cost analysis of what goes into making those products, and the difference between the two — which is essentially your margin picture. That's exactly what we're going to walk through in this guide, step by step.

If you're interested in picking stocks more effectively, you can also use a free stock picker tool to screen for opportunities. But for now, let's focus on the analytical framework itself.

What Are Trackable Anchor Companies?

Before we dive into the numbers, it's worth understanding a key concept: trackable anchor companies. These are companies whose raw material costs you can monitor directly because the underlying commodities have publicly available prices. That transparency makes your cost analysis far more reliable.

Type 1: Companies with Tied Raw Material Prices

The first type of trackable company has raw materials whose prices are directly available in the market. For example:

  • Cement companies — their fuel and power costs are heavily tied to coal prices, which you can track on the international market.
  • Chemical companies
  • Pharma companies
  • Car manufacturers
  • Consumer goods companies

If you can track the raw material price, you can build a much sharper picture of what the company's future costs will look like.

Type 2: Companies Supplying Raw Materials

The second type includes companies that themselves make or supply raw materials, but whose supplier may not have publicly listed prices. For instance, think of a company that sells parts — like a motorcycle components business. Those companies don't always give you a clean, public price signal to anchor your analysis on. They're harder to track, which makes your demand and cost analysis less precise.

Step 1: Pulling the Financial Data

Here's where the real work begins. Start by heading over to a good financial data source — in this case, you can use askanalyst.com.pk. Here's how it works:

  1. Go to the Companies section
  2. Navigate to the Data Load area
  3. Open the Income Statement
  4. Download the Annual Data

For example, you might start with the fiscal year ending March 2021. This gives you the baseline numbers you'll need for everything that follows.

Step 2: Calculating the Key Ratios

Once you have the data downloaded, you can start crunching the numbers. There are several key calculations you'll want to run.

Sales Growth

The first thing to check is how the company's top line has been performing. You calculate sales growth by taking the latest sales number, dividing it by the prior period's number, and subtracting one. That gives you the percentage change in revenue over the last couple of years.

If the company has been growing consistently, that's a good sign. If not, you'll want to dig into why.

Gross Profit Margin

Next up is the gross profit. This is the difference between what the company sells its products for and what it costs to make them. You'll see this clearly laid out in the income statement. A healthy gross margin means the company has pricing power and can control its cost of goods sold.

Operating Expenses

Now look at the operating expenses — specifically, admin expenses. The calculation is simple: take the admin expenses and divide them by net sales. This tells you how efficiently the company is running its day-to-day operations relative to its revenue.

Net Profit Margin

From there, you work your way down the income statement. Take profit before tax, and go one step further to profit after tax. When you express profit after tax as a percentage of sales, that's your net profit margin. This is ultimately what the shareholders get to keep.

Payout Ratio

Finally, check the payout ratio. You calculate this by dividing the dividend per share by the earnings per share (EPS). This tells you what portion of the profits the company is returning to shareholders versus retaining for reinvestment.

Step 3: Quarterly Seasonality

Annual numbers tell you a story, but they can hide important seasonal patterns. That's why you need to look at the quarterly data too. For each fiscal year, compare quarters — March versus June, June versus September, September versus December.

Some businesses are naturally seasonal. The percentage of sales in one quarter versus another can vary significantly year over year. When you're building your forecast, you should look at the average of what those quarterly changes have been over the last five years, and compare against the same period last year. This gives you a much better sense of what the next quarter might look like.

Forecasting Future Performance

Now let's put this into practice with a real example — say, a pharma company like Helion.

Revenue Growth Assumptions

For pharma companies, you need to think about how price increases are regulated. Essential products may have strict price increase limits tied to inflation, while non-essential products might allow more flexibility. Volume growth also matters.

A twenty percent top-line growth assumption is reasonable for this kind of business, though you could argue for higher or lower depending on the product mix and market conditions. Let's start with twenty percent as our base case going forward. But if there's no strong trend in the historical data, you can safely assume a similar growth rate going into the next year.

Projecting Margins and Costs

For the gross margin, look at what the company has delivered historically. You can safely assume something in the range of thirty-eight to forty percent. Let's go with thirty-eight percent as the base case.

Working down the income statement:

  • Selling and distribution expenses — these have historically been around thirteen percent of sales, so hold that constant.
  • Admin expenses — calculate these as a percentage of sales, then project them forward based on the revenue forecast.
  • Depreciation and amortization — these relate to EBITDA, so factor them in based on the company's existing asset base.

Fine-Tuning the Bottom Line

Financial charges are usually straightforward to estimate — you can assume they'll stay roughly in line with the prior year. For other income or other charges, take the average of the last few years since the amounts are typically small.

Put it all together and you get your projected profit after tax. Here's the sequence:

  1. Start with projected sales
  2. Subtract cost of goods sold to get gross profit
  3. Subtract operating expenses to get operating profit
  4. Adjust for financial charges, other income, or other charges
  5. Apply the tax rate to get profit after tax
  6. Divide profit after tax by the number of shares outstanding to get EPS

For example, if profit after tax comes to 9.6 billion and the company has roughly 117.5 million shares, that works out to about 83 rupees per share in EPS. Compare that with last year's figure to see the projected earnings growth.

Now, these numbers are just estimates — they're not guarantees. But the point of the exercise is that they reflect a well-reasoned set of assumptions based on the company's actual historical performance, the market conditions, and the cost dynamics of their raw materials.

Wrap-Up

That's the two-part framework in a nutshell: number one, demand and product analysis; number two, cost analysis. By tracking both sides and understanding the gap between them — the margin — you get a much clearer picture of a company's profitability and where it's heading. Combine that with a solid awareness of the raw material price signals from trackable anchor companies, and you're well equipped to make smarter investment decisions.

8.7KViews
359Likes
29Comments
@ShahzaibKhan-rn8kg
@ShahzaibKhan-rn8kg10mo ago

This is Sadqa-e-Jariya brother.

3
@osafuddin9457
@osafuddin945710mo ago

video is very excellent But does'not understant 6.30 to 8.00 mins on video because your picture was hide all data in quarter report, so i don't understand how your create T2, U2 and V2 Cell If you can please clear or make another video on this , so it's really helpful. Thanks

1
@zubair531
@zubair53110mo ago

Furqan bhai bohat he acha samjhaya. Yeh excel sheet wala kaam bohat acha hai... Allah Pak apko salamat rakhay..

0
@Owais-Mehboob
@Owais-Mehboob10mo ago

"Your teaching style makes even difficult topics easy. Thank you!" "Perfect explanation! You are a blessing for students." "Your concepts are crystal clear. Best teacher ever!" "You explain everything so clearly. Truly the best teacher on YouTube!" 💯🌟 👏🎉

0
@muhammadjunaidikhlaq2925
@muhammadjunaidikhlaq292510mo ago

Allah khush rakhy apko! Bht zabardast learning opportunity hain ap! i have been watching you for over an year. Started in mutual funds, now heading to stock picking..! :)

0
Do you need some help?!