{"id":22840,"date":"2012-06-30T10:00:32","date_gmt":"2012-06-30T15:00:32","guid":{"rendered":"https:\/\/blog.planview.com\/keeping-things-simple-preventing-your-portfolio-management-software-from-taking-over\/"},"modified":"2023-07-21T12:39:51","modified_gmt":"2023-07-21T17:39:51","slug":"keeping-things-simple-preventing-your-portfolio-management-software-from-taking-over","status":"publish","type":"post","link":"https:\/\/blog.planview.com\/keeping-things-simple-preventing-your-portfolio-management-software-from-taking-over\/","title":{"rendered":"Keeping Things Simple: Preventing Your Portfolio Management Software From Taking Over – Enrich Consulting"},"content":{"rendered":"
<\/figure>\n

Detailed project valuations are often requested by executives, the basis being they will feel more confident in their decision making process if the accuracy of the forecasts is increased They might believe that adding detail to their valuations can accomplish this; however, this is inevitably not the case (All the NPVs are wrong, can we talk about the portfolio now?<\/a>).  Excessive levels of detail often lead to poorer valuations because analysts spend less time on each input and are loathe to revisiting them when assumptions change.<\/p>\n

Our most successful clients are the ones who keep things simple and manage to spend most of their time generating analysis and insights rather than inputting data. Almost all of them, however, begin with overly complicated models before scaling back to an optimal level of detail.
\n<\/span><\/p>\n

\n
\n
\n
\n
\"<\/a><\/p>\n

Silver lining: One good thing about a complex model is that you can use the benefit of hindsight to simplify it. The lithe new model compares favorably with the albatross it replaced.<\/p>\n<\/div>\n

In one instance a client ended up with a model that was so complex that very few people could explain the mechanics, and it required the constant assistance of the consulting firm who had built it. Entering data was very time consuming and explaining the outputs was even more so. One analyst took it upon himself to attempt to streamline the model by using only key valuation drivers and some rules of thumb.  As a result, he was able to cut 80% of the model\u2019s inputs.  The results showed that the streamlined model generated the same numbers as before within + or -5%.<\/p>\n

This analysis took only several weeks to complete and was compelling enough to convince management to go with the simplified model. An online version of the new streamlined model has since replaced the original spreadsheet and analysts now spend less time inputting data or explaining numbers and more time focusing on what really matters \u2013 generating more meaningful portfolio analysis.<\/p>\n

We have seen other models where excessive detail is driven by too much granularity or unnecessary complexity in the calculations. Here are some examples:<\/p>\n