From Data to Decisions: Leveraging Your Total Portfolio View

In recent articles, we’ve examined why delivering an effective Total Portfolio View (TPV) is difficult, the data obstacles firms face, and why an Investment Book of Record (IBOR) often plays a key component in constructing your TPV. I’d like to step back and consider the utility a TPV delivers. It is not simply the accumulation of data; rather, it is the analytics it provisions.   

Winston Churchill once said, « To build may have to be the slow and laborious task of years. To destroy can be the thoughtless act of a single day. » In the rush to execute, we risk losing sight of the vision that gives our effort meaning. Put another way, building the Total Portfolio View is meaningless if we cannot use it for its intended purposes. 

Conversations with our clients and with other industry participants frequently come back to a common refrain:  

“When I managed a portfolio of publicly traded equities or fixed income instruments, I had access to up to date, accurate market data, portfolio modelling tools and more that allowed me to efficiently manage my portfolio. Now that as the Chief Investment Officer, the Head of Risk, or any one of many other roles, I would like the same capabilities for the whole portfolio: A Total Portfolio View and effective analytics tools.”   

Assuming we’ve overcome the significant hurdle of constructing the data set that hydrates the Total Portfolio View, what capabilities do we need to enable? Thinking like the end user, we can suggest the following: 

Positions, Exposure, and Risk

At the simplest level, I need to understand what I own and what exposure that creates. How does that compare to the policy that is feeding into my risk system? How are different assets contributing to the overall portfolio risk? Does the volatility of pension assets and liabilities create surplus risk? 

This becomes challenging in a TPV environment. Volatility between pension assets and liabilities creates surplus risk. Overlay programs, for example, inflation hedges, require simulation of existing portfolios and macroeconomic conditions. The question becomes: what factors should I control versus vary, and within what bands?

Cash Ladder and Liquidity  

I need the ability to track and predict cash, one day, two days, one week, one month, three months out. While some cash flows are highly predictable, such as fund liabilities and public instrument income streams, others, like private investment capital calls or returns of capital, are less certain. I should be able to assign and manage confidence levels to each potential cash flow and generate cash ladders and projections based on that data.

Portfolio Modelling and “What If”  

Going beyond simple cash management, I need to be able to interact with the tool.  If, for example, I’ve got a large capital call going out, is this going to put me over or under weight?  I need to generate that funding – from existing cash, by selling assets, or generating new leverage. Maybe I would like to both sell some of my fixed-income program and simultaneously generate some leverage from my securities lending business. But those are potentially in conflict; if I sell off treasuries, I no longer have them to lend. What happens to my funding ratio? Am I still within permissible limits? Would that trigger a glide path change and, if so, what policy shifts follow? Much of this is currently managed inside people’s heads, or in ad hoc tools and Excel. As program sizes increase, this is neither robust nor scalable. 

Workflow 

In an ideal world, modelling decisions should automatically generate corresponding orders out of the system, or at least set up instructions, and have them routed to the appropriate teams. If approvals are needed, they should happen within the system and workflows, not through disconnected emails or spreadsheets.

The Ideal System 

In summary, our ideal system includes multiple, interrelated capabilities: 

• Integrated portfolio management tools to view portfolio positioning, compare it to policy, assess risk, and perform what-if scenario testing. 

• Access to a reliable cash ladder and forward-looking cash flow forecasts.  

• Manage leverage program complexity across multiple channels with trade-offs, requiring sophisticated tools to evaluate and execute decisions.  

• Execution through system workflows, order queues, and digital approvals.  

• An easy-to-navigate GUI, from the CIO with a rolled-up view to other personas needing to drill down through multiple levels, with the ability to perform flexible slicing and dicing.  

An effective Total Portfolio View requires more than connected data; it demands connected thinking.  

Firms must integrate exposures, liquidity, and decision workflows into a unified view. Each capability depends on the others, and success lies in designing systems that enable action, not just observation.

Conclusion 

Building a Total Portfolio View is an achievement, but it’s only the beginning. The real value emerges when firms use that foundation to make faster, smarter, and more confident decisions. 

As Churchill suggested, the act of building requires discipline and persistence; the same holds true for transforming how data supports investment decisions. Firms that stop at integration risk, creating static dashboards rather than dynamic insights. A TPV should do more than aggregate data; it should enable action.

Why Meradia? 

At Meradia, we help firms move from building the Total Portfolio View to putting it to work. Our consultants understand both the technology and the operating models behind complex, multi-asset portfolios. We design frameworks that not only connect systems but also connect decisions, bridging exposure, liquidity, and execution into one coherent view.

We’ve guided leading asset owners, managers, and service providers through the same challenge: turning fragmented data into a strategic advantage. Our clients trust us because we don’t just define the end state, we architect the path to get there.

Because in the end, a Total Portfolio View isn’t about having all the data. It’s about having the confidence to act on it.

Download Thought Leadership ArticleServices: Process Design and Change, Strategy and RoadmapExpertises: All Meradia, Front Office & Portfolio ManagementClients: Asset Owner, InsuranceAuthors: Mick Cartwright