Principles of Finance

# 18.5Forecasting Cash Flow and Assessing the Value of Growth

Principles of Finance18.5 Forecasting Cash Flow and Assessing the Value of Growth

## Learning Outcomes

By the end of this section, you will be able to:

• Generate a cash flow forecast.
• Assess a cash flow forecast to determine future cash funding needs.
• Use pro forma financial statements and cash flow forecasts to assess the value of growth to the firm.

In this section of the chapter, we will use the forecasted income statement, forecasted balance sheet, and other information we know about the firm’s policies and goals for the coming year to generate and assess a cash flow forecast.

## Create a Cash Flow Forecast

A cash flow forecast isn’t overly complex, yet it is not easy to assemble because it requires making many assumptions about the future. A cash forecast begins with the beginning cash balance, adds anticipated cash inflows, and deducts anticipated cash outflows. This identifies cash surpluses and shortages.

For Clear Lake Sporting Goods, for example, we see in Figure 18.15 that the company begins with cash of $42,581,000 in January of the new year. Next, it lists the cash inflows, or cash received from customers. Given the assumption that customers pay in 90-day terms, the cash flow is filled in by plugging in the sales forecast for the three prior months. For example, the cash flow from customers of$10,508 for June is the same as the net sales forecast for March (see Figure 18.13).

Figure 18.15 Forecasted Cash Inflows

## Scenarios in Forecasting

Forecasting is almost never a linear process. In other words, we don’t do one forecast and call it good. The first draft is completed using historical data, and then changes are made a bit at a time as all potential variables are assessed for their impact on the forecast. It’s quite common to then use the work-in-progress forecast to complete scenario analysis. This is particularly true when the forecast is completed in Excel or other budgeting or forecasting software. Elements of the forecast can be changed to see what the overall impact would be to the firm. Assuming the forecast is set up using formulas in Excel or other software, a change to one figure or one variable would then “ripple” through the forecast to reflect the overall impact.

Often, a firm may complete an initial forecast (scenario) under the assumption that the economy is in a “normal state.” The firm can then alter the initial forecast for different scenarios, such as the economy in a recession or the economy in a state of expansion. This helps the firm understand different possible future states and highlights how changes in the economy such as inflation may cause revenue and expenses to increase.

Assume that Clear Lake’s initial forecast is created under the assumption that the economy will remain average. Management also wants to know the worst-case scenario. What will their financial results look like if the economy were in a recession, for example? If management assumes their sales would drop to only 60% of the prior year sales in a recessionary economy, they could alter the formula in Excel driving their sales and variable costs, resulting in a new pro forma income statement. In Figure 18.18, we can see that net income would drop to $16,391 under this assumption, compared to the net income of$47,653 forecasted under average economy assumptions in Figure 18.13.

Figure 18.18 Forecasted Cash Surplus or Deficit

Though creating a full forecast in Excel can be a bit complex, it is a powerful tool that is useful for analysis. Elements can be used to vary just about anything, from something small such as a 1% increase in the cost of a product to a company-wide increase in salaries, the introduction of an entire new product line, or the purchase of a new production machine, among other possibilities.

For example, assume that Clear Lake has completed a first pass at its forecast and is reviewing the forecasted profit for the next 12 months. Managers feel the profit is currently low, as they always want to target a certain percentage. They might tinker with variables in the forecast file to see the impact on profits of potential changes they are considering. They may reduce the new salaries package by a percentage point to see if it gets them closer to their goal. They may adjust cost of goods sold by a certain percentage if they feel they can negotiate with vendors to work down their costs. They may adjust rent and see if they can find a better retail location to either reduce costs or increase sales due to increased foot traffic in a new location. They may save an entirely new version of the forecast and change it drastically to see what investing in opening a second retail location would do.

As you can see, the list of possibilities is endless. Though the main goal of financial managers may be cash planning, the power of a well-developed forecast is tremendous. It can help assess potential growth, new opportunities, and even small changes in the business as well.

## Sensitivity Analysis in Forecasting

Sensitivity analysis will often look at the change in just one variable rather than the entire scenario. It examines how sensitive a particular output (commonly net income) will be to a change in a particular underlying input (sales or costs, for example). What if sales are 10% more or less than forecasted? What if the prices the firm can charge its customers are 10% more or less? What if the cost of goods sold increases by 10%? The purpose is to see which variables are crucial to “get right.” It isn’t worth spending a lot of research dollars to make sure you are accurately predicting a variable if that variable won’t notably change the outcome. However, a slight change in other variables may have significant impact.

Using pro forma financial statements created in Excel allows management to quickly generate new pro forma financials and see the impact that each possible variable might have on the overall financial results.