Adding Value with Quantrix Modeler Skills

I’ve spoken with many finance executives over the years and a question often comes up – how do I motivate the spreadsheet gurus in our company to embrace a different tool for financial modeling?

This kind of question is not unique to Quantrix; it is often the case in any implementation of new software that people express some reluctance to taking the time to learn a new skill.

One of the reasons in our particular domain is that many individuals who have gained mastery in spreadsheets feel that part of the value they provide to their company is being the “go-to” person whenever anyone has a question about how to do something. They have spent many years learning how to make spreadsheets do things they weren’t necessarily designed to do.

However, in my experience, most of these spreadsheet gurus catch on to Quantrix Modeler in very short order. When they begin to use Quantrix, a light often goes off in their heads with the realization that they can do their tasks with much more speed, nimbleness and accuracy than they could have with the spreadsheet.  In a real and tangible way, they are able to take their financial modeling skills to a new level and offer even greater value to their organization.  That is a great motivating factor!

On an organizational level, this is a major benefit to finance executives who are asked to make their teams more productive with fewer resources and is one of the key reasons they come to Quantrix.  On an individual level, proficiency in Quantrix Modeler is a desired skill in the marketplace. Quantrix has over 1000 customers in 50 countries and we are often asked to refer individuals to employers who are looking for talent.  So, investing the time to develop Quantrix skills will pay dividends in one’s career.

For those who use LinkedIn, I highly recommend adding Quantrix Modeler to your skills in your profile. Simply log in to LinkedIn, go to Profile|Edit Profile, scroll down to Skills and Expertise, click Edit (blue pen icon), and type “Quantrix Modeler”.  Then hit the Add button. You never know where your Quantrix Modeler skills will take you!

David Phillips

Scenario Planning and Quantrix Modeler

Talking about scenario planning is tricky as it means so many different things in different companies. In many cases, the need for strategic scenario planning is prompted by big changes or potential future changes in the economic environment within which an organization operates. These changes may be due to new competitors and technologies, regulatory constraints, fluctuating commodity prices or funding priorities in the public sector.

In such periods of major change, when the final outcome and effect of the changes are uncertain, the more common methods of forecasting and planning break down, because:

a. historical trends and rates are much less reliable as the basis of forecasting
b. there is so much uncertainty that no one set of assumptions is going to be a certain enough basis on which to plan
c. The organization’s plans need to anticipate a wide range of alternative feasible future circumstances, to ensure that it is not blind-sided by events and can survive and prosper, irrespective of the final circumstances

For some organizations and industries, such conditions only occur at certain times in their lives, so much of the time they may not really need scenario planning and can plan on historic trends and rates and use a bit of “what-iffing” in their budgets and 3 year plans. In other industries, for example in Oil&Gas and Telecomms, the huge impact and unpredictability of oil price in one case and competitors’ technological innovations in the other, mean that these companies should probably benefit from doing full scenario-based planning routinely.

The value of Quantrix Modeler within scenario-based planning is due to its ability to easily vary driver/assumption values, but also because structural changes, that may be anticipated by different scenarios, are also so much easier to make than with spreadsheet models.

John Taylor
Planning Models Ltd.