Forecasting using ratio analysis

Ratio analysis compares two related financial figures to reveal underlying business dynamics. When the same relationship has persisted over several periods, analysts assume it will continue, allowing them to extend the ratio into the future. This approach is especially useful when detailed market forecasts are unavailable, as it relies on the firm’s own historical performance.

In the Indian context, SEBI‑registered research analysts often start with a trend in sales or revenue, then apply stable ratios such as net profit margin, asset turnover, or debt‑to‑equity to estimate earnings, asset requirements, and financing needs. The process creates a pro‑forma financial statement that can be stress‑tested against macro‑economic assumptions.

For the NISM exam, candidates must be able to (i) compute the growth rate, (ii) project the primary line item (usually sales), and (iii) use the derived ratios to fill out the rest of the statement. Questions frequently present a three‑year historical data set and ask for a five‑year forecast, so mastery of each step is essential.

• Ratio‑based forecasting bridges past performance with future expectations.
• It is a quantitative tool that complements qualitative industry analysis.

Net Profit Margin – Net Income divided by Sales. It shows how much profit is generated per rupee of revenue and is used to project future earnings once sales are forecasted.

Asset Turnover Ratio – Sales divided by Total Assets. This ratio helps estimate the asset base required to support projected sales, ensuring the balance sheet stays balanced.

Current Ratio – Current Assets over Current Liabilities. Analysts often keep this ratio stable to forecast working‑capital needs, especially for short‑term liquidity planning.

Other ratios such as Debt‑to‑Equity, Return on Equity (ROE) and Operating Margin are also employed depending on the sector and the analyst’s focus. The exam may test any of these, so be comfortable with their definitions and typical usage.

CAGR smooths out year‑to‑year volatility and provides a single annual growth rate that, when compounded, reproduces the observed change. The NISM syllabus emphasizes CAGR because it is the preferred metric for projecting sales, earnings and cash flows over a multi‑year horizon.

Unlike a simple average, CAGR respects the time value of money by compounding the growth factor each year. This is crucial when the exam asks for a five‑year forecast based on three years of historical data.

Remember to express the final answer as a percentage (e.g., 16.96%). Many candidates lose marks by leaving the result in decimal form or by forgetting to convert the percentage.

Once the future sales figure is obtained, analysts use stable profit‑related ratios to estimate earnings. For example, if the historic net profit margin is 12%, the projected net income equals 12% of the forecasted sales.

Similarly, asset turnover can be applied to determine the total assets needed to support the projected sales level. This ensures that the pro‑forma balance sheet remains realistic and complies with the accounting identity: Assets = Liabilities + Equity.

In the exam, you may be given the historic margin and asked to compute the projected net profit directly. Keep the margin in decimal form (12% → 0.12) to avoid arithmetic errors.

The ratio‑based projection method assumes that the relationship between two items (e.g., Net Income and Sales) remains unchanged. The formula is straightforward: multiply the historical amount by the ratio of projected to historical sales.

This technique is versatile. It can be used to forecast operating expenses, working‑capital components, or even dividend payouts, provided the underlying ratio has shown stability over the observed periods.

Exam‑writers often test this concept by giving you a historical figure (say, depreciation expense) and asking you to compute its future value after you have already projected sales. Remember to keep the units consistent – all amounts should be in the same currency and scale (e.g., lakh rupees).

1. Gather at least three years of consistent financial data for the company.

2. Compute the CAGR for the primary driver, usually sales or revenue, using the formula provided.

3. Project the primary driver for the desired forecast horizon by applying the CAGR.

4. Identify stable ratios (net profit margin, asset turnover, current ratio, etc.) from the historical period.

5. Apply each ratio to the projected primary driver to estimate the corresponding line items (e.g., Net Income = Sales × Net Profit Margin).

6. Ensure the balance sheet balances by checking that projected assets equal projected liabilities plus equity. Adjust any out‑of‑balance items using reasonable assumptions.

Ratio‑based forecasting assumes that past relationships will persist, which may not hold during structural industry changes, regulatory shifts, or macro‑economic shocks. Analysts must therefore supplement the quantitative forecast with qualitative judgments.

Adjustments are often required for items that are not directly linked to sales, such as one‑time gains, tax reforms, or changes in capital structure. The NISM syllabus expects you to mention these caveats when answering descriptive questions.

Finally, always cross‑verify the projected statements for internal consistency. A mismatch between projected assets and the sum of liabilities and equity is a red flag that will attract marks deduction in the exam.