Chapter 14 - TM

Identify the following forecasting horizons. Used by financial institutions and rating agencies for credit analysis

Long-term

Identify the following forecasting horizons. Used as a benchmark to compare actual to projected cash flows on the cash budget

Medium-term

Identify the following forecasting horizons. Used to establish and manage target balances for bank compensation

Short-term

Identify the following forecasting horizons. Used to determine the company's need for short-term credit or availability of funds for short-term investing

Medium-term

1.Forecast ___________. 2.Calculate projected ending cash balance by projecting [step 1] cash impact. 3.Compare projected ending and target __________ and adjust pro forma statement to show fund source for shortfall or investment of surplus. A. 1. income statement and balance sheet; 3. cash balance B. 1. cash flow statement; 3. cash balance C. 1. income statement and balance sheet; 3. profit D. 1. cash flow statement; 3. profit

A. 1. income statement and balance sheet; 3. cash balance

MCA, Inc. upgraded the treasury workstation that had been in place for two years and used data from that 24-month period to develop a new short-term forecast. A trend factor was applied to controlled disbursements of 97% on a month-by-month basis and the variance to actual disbursements is less than 1%. Which of the following model validation techniques was utilized? A. In-sample validation B. Documentation validation C. Ongoing validation D. Comparison validation

A. In-sample validation

Company R has an AR collection pattern of 8% in the current month, 47% in the first month, 30% in the second month, 10% in the third month, and 5% in the fourth month. If AR for July is $598,000, what amount of cash do they expect to collect in October? A. $281,060 B. $59,800 C. $179,400 D. $47,840

B. $59,800

Which validation method tests a forecast using data that were not used to develop it, i.e., using 30 months of data for the forecast and the last 6 months of a three-year period to test? A. In-sample validation B. Out-of-sample validation C. Ongoing validation D. Documentation of the process

B. Out-of-sample validation

An analyst for a landscaping company wants to adjust her cash-flow forecast to account for the seasonality of outflows. How can this be accomplished? A. Simple moving average B. Regression analysis C. Accounts receivable balance pattern D. Contingency forecasting

B. Regression analysis

Which is a step in arriving at the projected closing cash position? A. Start with the next period's closing available bank balance. B. Deduct the expected settlements in collection and concentration accounts. C. Deduct projected disbursement totals. D. Find historical data on clearings of disbursements from non-controlled disbursement accounts.

C. Deduct projected disbursement totals.

The treasury manager of a chain of clothing stores wants to develop a medium-term forecast. Management plans to open two new stores, and anticipates same-store sales to increase by 15%. Which of the following items can be predicted with the highest degree of certainty? A. Taxes on stock options B. New product sales C. Fixed bond interest payment D. Refranchising proceeds

C. Fixed bond interest payment

What is another of these best practices? A. If a sophisticated treasury forecasting system exists, use it for all forecasts. B. Allow each business unit to develop terminology and expectations. C. Accuracy is always more important than timeliness. D. Disclose assumptions

D. Disclose assumptions

A daily short-term forecast and variance analysis for LMN, Inc. is updated with relevant trends and actual data every Monday. Upon review, the treasurer assessed that sales were higher than forecasted, inventory was up and yields being earned on excess cash were lower. The MOST important reason for this cash forecast process is: A. Financial control B. Managing costs C. Capital budgeting D. Liquidity management

D. Liquidity management