Goodwill - Liquidity

08.07.2019

Factor “Liquidity” is 1 out of 8 factors that GMC simulator uses to calculate the company's Goodwill value. Below are presented parameters from decision and management report that are most correlated with Goodwill factor “Liquidity” when calculating the company's Goodwill value. Parameters include direct and inverse correlation:

  1. Liquidity of company: 1.00
  2. Net cash flow: 0.70
  3. Less closing inventory values: -0,69
  4. Trading payments: -0,69
  5. Bank overdraft: -0.67

 

Liquidity of company in this case is calculated as:

(Cash + Cash equivalents - Bank overdraft - Term loans) / Net assets

 

As can be seen from the list of parameters, Liquidity of company has the greatest direct correlation (1.00), i.e. the more cash (including deposits), the greater the Goodwill factor “Liquidity”. Other parameters are likely to affect only indirectly, since they are somehow related to Liquidity of company parameter, namely:

  1. Positive net cash flow increases the company's Liquidity and vice versa.
  2. Less closing inventory values freeze cash in products and raw materials and reduce the company's Liquidity.
  3. Operating fees reduce Net cash flow.
  4. Bank overdraft from the point of view of GMC simulator is the same Liquidity, but only negative.

 

Thus, for the purpose of analyzing Goodwill factor “Liquidity”, we will consider only parameters Liquidity and bank overdraft (including other borrowed funds).

In old version of GMC simulator for many seasons, there was very popular strategy in last period to take loan. Company received additional Liquidity, and Goodwill with company's share price increased accordingly. Later, this bug was fixed, eliminating amount of borrowed funds from the calculation, for example: if loan is 200 and cash is 250, then from the point of view of calculating Goodwill, liquid funds are 250 - 200 = 50, i.e. as if you did not decide to take loan.

Diagram below shows dependence of Goodwill factor “Liquidity” on Liquidity of company for scenarios 12C1, 12C3, 14C1 and 14C3 in 1 period. The upper limit of the company's Liquidity, after which factor does not increase, is on average 15% (1.162). The lower limit is on average -55% (0.866).

 

Hints:

  1. Goodwill factor “Liquidity” can vary between 0.866 - 1.162.
  2. Value of Goodwill factor “Liquidity” does not depend on value in previous period or on decisions of competitors in the group.
  3. Optimal strategy in last period, the company's Liquidity should be at least 15% (1.162).
  4. Free cash over 15% of the company's Liquidity can be spent on paying dividends and increasing other Goodwill factors to maximize Investment performance.

 

Automatic forecast of Goodwill and Investment performance is built into the Calculation model, which can be purchased in our store.