All projects Project 02

Smart Tagging System for Investments

Built and implemented a risk, liquidity and cost-tagging system for 100s of instruments across multiple portfolios which helped reduce costs, improve asset allocation and manage cash flow.

70–80%
Faster reporting
60%
Faster cash mobilization
2 weeks
Time to completion

01 Context

The company manages several family portfolios containing hundreds of financial instruments. Each instrument has different risk, liquidity and cost-tax features. Family members have varied risk preferences and cash needs.

02 Problem

  • Without clear risk classes and liquidity labels, portfolio-level metrics were unreliable, transparency suffered, and investor updates became slow and confusing.
  • Portfolios drifted into concentration or overly conservative holdings, which hurt returns, increased volatility, and made asset allocation ineffective.
  • No liquidity buckets meant manager couldn’t quickly raise cash for urgent capital calls or stress scenarios, leading to funding gaps.
  • The lack of cost-tax classification and rebalancing rules drove up transaction fees and unnecessary tax payouts.

03 Solutions

Risk–Liquidity Matrix

Built a matrix defining risk levels (by number of risk factors and their likelihood) and liquidity levels (by liquidation cost, time and price volatility).

Asset-Class Coverage

Applied this matrix across all asset classes—fixed income, equity, alternatives and cash—and across strategies and allocations.

New-Instrument Tags

Developed a tagging system for new instruments or strategies, assigning risk and liquidity labels.

Cost & Tax Tags

Added cost tags based on brokerage, STT and other transaction fees plus each instrument’s effective tax rate.

04 Outcomes

  • Faster, more accurate cash flow planning and stress testing, average time to raise INR 1 crore cash went from 5 days to 2 days.
  • Clearer risk measurement and smarter asset allocation, 5% of instruments were sold and reinvested due to unfavourable risk/reward.
  • Data-driven rebalancing, lower transaction costs and reduced tax outflows, costs came down by >50%.
  • Greater transparency and better portfolio reports for investors.

05 Reflection

Clear and logical classification is not just optional but critical in shaping analysis and portfolio decision-making. Create a sense of trust with investors while keeping communication simple. Tax-efficiency as a tag would have increased the effectiveness of the classification system and enabled better tax-adjusted returns.

06 Skills Acquired

Problem SolvingData AnalysisOrganisation