Miller-Orr model

The Miller-Orr model model is used in management to make sure a company maintains an appropriate level of cash. While too much cash is expensive because of the opportunity cost of holding cash (interest can be earned by buying short-term securities), having too little cash is risky.

Thus, CFOs should be able to determine a minimum and maximum cash balance. If the amount of cash drops below this minimum, the company should sell short-term securities. Similarly, excess cash should be invested in short-term securities to earn additional income.

On this page, we define the Miller and Orr model of cash management, discuss the Miller-Orr formula and finally conclude with a Miller-Orr model example. The spreadsheet used to create the example can be downloaded at the bottom of the page.

Miller-Orr model formula

Let’s start by looking at the Miller-Orr model derivation. There are a number of statistics we need to calculate. First, we need to calculate the spread

The spread is defined as

    $$ \textrm{spread} = 3 \cdot [\frac{3/4 \cdot \textrm{transaction cost} \cdot \textrm{variance cash flows}}{\textrm{interest rate/365}}]^{1/3} $$

where the transaction cost is the average cost from buying and selling short-term securities, variance of the cash flow is the volatility (in currency) of the cash flows, and the interest rate is the annual interest rate. Once we have the spread, we can use the minimum cash limit, called the safety net, and add the spread to calculate the upper limit (h)

    $$ \textrm{upper limit} = \textrm{safety net} + \textrm{spread} $$

Finally, we have the target cash level (Z)

    $$\textrm{target cash level} = \textrm{safety net} + (1/3 \cdot \textrm{spread}) $$

Miller-Orr calculator example

Let’s implement the above formulas and apply them to a numerical example. The following table reports the results of the exercise. 

Miller-Orr-Model

The Excel file used to create the example can be downloaded at the bottom of the page.

Summary

We discussed a very popular model of cash management. Using the formulas discussed above, treasury managers can manage the amount of cash in a company by selling short-term securities when cash is too low and buying securities when cash is too high.

The above topic is related to the following set of topics:

Download the Excel spreadsheet

Want to have an implementation in Excel? Download the Excel file: Miller-Orr template