An Investment Risk Register for Indian Equity Portfolios (Free Template)
A practical risk-register framework for PMS, family-office and research teams: define the risk, evidence, threshold, owner, review cadence and escalation before markets force the discussion.
An investment risk register turns “we should keep an eye on this” into a repeatable portfolio-governance process. For every material risk, it records what could go wrong, which evidence would reveal it, when the team will review it, who owns the review and what happens when a threshold is crossed.
That sounds simple. It is also the difference between remembering a concern in an investment committee meeting and actually monitoring it six months later.
Download the investment risk register template. It is deliberately a plain CSV: open it in Excel, change every field and verify the process yourself.
What belongs in the register?
A useful register is not a list of everything that could possibly happen. It covers risks that are material to the thesis or portfolio and can be connected to observable evidence.
| Field | The question it answers |
|---|---|
| Risk statement | What could invalidate or materially weaken the thesis? |
| Category | Is it business, balance-sheet, governance, valuation, liquidity, macro or portfolio risk? |
| Leading indicator | What would deteriorate before the headline problem becomes obvious? |
| Threshold | What observable condition forces a fresh review? |
| Source and date | Which filing, transcript or dataset supports the current state? |
| Cadence | Is this reviewed on an event, monthly, quarterly or annually? |
| Owner | Who must update it rather than assuming someone else will? |
| Decision rule | What review or escalation follows a breach? |
The register should sit beside the original investment thesis. A risk without a thesis link becomes generic anxiety; a thesis without monitored risks becomes a static memo.
Seven risk categories for an Indian equity portfolio
1. Business and operating risk
Start with the engine that is supposed to create value: volumes, pricing, distribution, utilisation, customer additions or another company-specific KPI. “Revenue may slow” is too broad. “Dealer additions fail to produce same-store growth” is monitorable.
2. Balance-sheet and cash-flow risk
Profit can grow while cash conversion worsens. Record the relevant leverage, interest coverage, receivable, inventory or asset-quality measure and the accounting basis. For banks and NBFCs, use sector-appropriate measures rather than forcing industrial-company ratios onto a lender.
3. Governance and disclosure risk
Related-party transactions, promoter pledging, auditor changes and repeated delays in disclosures deserve explicit ownership. A register should not label a company “good” or “bad”; it should preserve the event, source and reason it matters.
4. Valuation risk
Valuation is a risk when the market price requires an operating outcome that has not yet arrived. Record the assumption embedded in the model—not merely “P/E is high”—and define which earnings, cash-flow or capital-efficiency outcome would make the valuation harder to defend.
5. Liquidity and implementation risk
Position size can exceed the ability to change the position without moving the market, especially in smaller companies. Track ownership concentration, typical trading liquidity and the portfolio’s own exit assumptions. These figures describe implementation risk; they do not predict the stock.
6. Macro and policy risk
USD/INR, crude oil, rates, duties and regulation matter only through a company’s actual exposure. Write the transmission path: imported input cost, foreign-currency borrowing, regulated price or export realisation. “Rupee risk” without a mapped exposure is not analysis.
7. Portfolio construction risk
Five individually sensible positions can express the same hidden bet. A lender, housing company and real-estate developer may all load onto rates and credit conditions. Record common factors and correlated exposures at the portfolio level.
The threshold is a review trigger, not an automatic sell rule
A threshold should be specific enough to wake the process and modest enough to avoid false precision. Examples include:
- cash-conversion cycle above a defined level for two reporting periods;
- management missing a measurable guidance range by more than a chosen tolerance;
- promoter pledge increasing beyond the committee’s limit;
- a position crossing an agreed share of realistically tradable volume;
- valuation leaving the range supported by the team’s base-case assumptions.
Crossing one of these conditions should normally trigger a source review, model refresh and named escalation. It should not silently place a trade. Data can be restated, definitions can change and temporary effects can be economically rational. Human judgement owns the decision.
A worked fictional example
Assume a team owns a consumer company because distribution expansion should produce double-digit volume growth without weakening working capital.
| Register item | Entry |
|---|---|
| Thesis driver | Productive distribution expansion |
| Risk | New outlets add inventory but not sell-through |
| Leading evidence | Volume growth, receivable days, inventory days |
| Trigger | Volume below 7% and inventory days above 80 for two quarters |
| Sources | Results filing, annual-report notes, concall transcript |
| Owner | Covering analyst |
| Escalation | Rebuild volume and cash-flow assumptions; present to IC |
The value is not in choosing 7% or 80 as universally correct numbers. The value is deciding in advance what the team believes, making the evidence comparable through time and preserving why a review happened.
A monthly and quarterly operating rhythm
At the monthly review, update market-sensitive and portfolio-level fields: valuation, position weight, liquidity and material exchange filings. At the quarterly review, update reported KPIs, guidance delivery, balance-sheet evidence and the model. On any material event, record the new source before changing the state.
Every update needs an as of date. Without it, today’s clean database can accidentally rewrite what a past investment committee could have known. This is why point-in-time data matters when teams review earlier decisions or test rules.
How Altys fits
Altys is designed to connect source-linked Indian company evidence, deterministic metrics, scorecards, portfolio context and monitoring rules. A team can define the trigger, inspect the supporting filing or dataset, and export the relevant scorecard, report, GenGrid result or alert workflow to Excel for independent verification.
That exportability is important. AI can help find and organise evidence, but the research process should not become an opaque answer box. The investment team should be able to inspect what the software did, challenge it in a spreadsheet and retain the final decision.
The objective is not to eliminate surprises. It is to ensure that the risks the team already understood have owners, evidence and an operating process before the next surprise arrives.
This article is educational and does not constitute investment advice. Example companies and thresholds are fictional.
Frequently asked questions
What is an investment risk register?
It is a living table that records each material portfolio risk, the evidence used to monitor it, a review threshold, an owner and the action required when the threshold is crossed.
How is a risk register different from a risk score?
A score compresses several signals into one number. A register preserves the specific risk, source, threshold, ownership and response, so an investment committee can see why a position needs attention.
Should a threshold automatically trigger a trade?
Usually no. A threshold should trigger a defined review or escalation. The portfolio manager remains responsible for interpreting the evidence and deciding whether to hold, resize or exit.
Can I download an investment risk register template?
Yes. This guide includes a free CSV template that can be opened and verified in Excel or any spreadsheet application.