What does the cash budget show regarding target cash level

Assignment Help Financial Management
Reference no: EM132028638

CASE Karen Johnson, CFO for Raucous Roasters (RR), a specialty coffee manufacturer, is rethinking her company’s working capital policy in light of a recent scare she faced when RR’s corporate banker, citing a nationwide credit crunch, balked at renewing RR’s line of credit. Had the line of credit not been renewed, RR would not have been able to make payroll, potentially forcing the company out of business. Although the line of credit was ultimately renewed, the scare has forced Johnson to examine carefully each component of RR’s working capital to make sure it is needed, with the goal of determining whether the line of credit can be eliminated entirely. In addition to (possibly) freeing RR from the need for a line of credit, Johnson is well aware that reducing working capital will improve free cash flow. Historically, RR has done little to examine working capital, mainly because of poor communication among business functions. In the past, the production manager resisted Johnson’s efforts to question his holdings of raw materials, the marketing manager resisted questions about finished goods, the sales staff resisted questions about credit policy (which affects accounts receivable), and the treasurer did not want to talk about the cash and securities balances. However, with the recent credit scare, this resistance has become unacceptable and Johnson has undertaken a company-wide examination of cash, marketable securities, inventory, and accounts receivable levels. Johnson also knows that decisions about working capital cannot be made in a vacuum. For example, if inventories could be lowered without adversely affecting operations, then less capital would be required, and free cash flow would increase. However, lower raw materials inventories might lead to production slowdowns and higher costs, and lower finished goods inventories might lead to stockouts and loss of sales. So, before inventories are changed, it will be necessary to study operating as well as financial effects. The situation is the same with regard to cash and receivables. Johnson has begun her investigation by collecting the ratios shown here. (The partial cash budget shown after the ratios is used later in this mini case.)

RR Industry   

Current 1.75 2.25

Quick 0.92 1.16

Total liabilities/assets 58.76% 50.00%

Turnover of cash and securities 16.67 22.22

Days sales outstanding (365-day basis) 45.63 32.00

Inventory turnover 10.80 20.00

Fixed assets turnover 7.75 13.22

Total assets turnover 2.60 3.00

Profit margin on sales 2.07% 3.50%

Return on equity (ROE) 10.45% 21.00%

Payables deferral period 30.00 33.00

Cash Budget (Thousands of Dollars) Nov Dec Jan Feb Mar Apr

(1) Sales Forecast (1) Sales (gross) $71,218.00 $68,212.00 $65,213.00 $52,475.00 $42,909.00 $30,524.00

(2) Collections (2) During month of sale: (0.2)(0.98)(month’s sales) 12,781.75 10,285.10

(3) During first month after sale: (0.7)(previous month’s sales) 47,748.40 45,649.10

(4) During second month after sale: (0.1)(sales 2 months ago) 7,121.80 6,821.20

(5) Total collections (Lines 2 3 4) $67,651.95 $62,755.40 Purchases

(6) (0.85)(forecasted sales 2 months from now) $44,603.75 $36,472.65 $25,945.40 Payments

(7) Payments (1-month lag) 44,603.75 36,472.65

(8) Wages and salaries 6,690.56 5,470.90

(9) Rent 2,500.00 2,500.00

(10) Taxes

(11) Total payments $53,794.31 $44,443.55 NCFs

(12) Cash on hand at start of forecast $3,000.00

(13) NCF: Collections Payments Line 5 Line 11 $13,857.64 $18,311.85

(14) NCF: Prior this mos. NCF $16,857.64 $35169.49

(15) Target cash balance 1,500.00 1,500.00

(16) Surplus cash or loan needed $15,357.64 $33,669.49

a. Johnson plans to use the preceding ratios as the starting point for discussions with RR’s operating team. Based on the data, does RR seem to be following a relaxed, moderate, or restricted current asset usage policy?

b. How can one distinguish between a relaxed but rational working capital policy and a situation in which a firm simply has excessive current assets because it is inefficient? Does RR’s working capital policy seem appropriate?

c. Calculate the firm’s cash conversion cycle given that annual sales are $660,000 and cost of goods sold represents 90% of sales. Assume a 365-day year. d. Is there any reason to think that RR may be holding too much inventory?

e. If RR reduces its inventory without adversely affecting sales, what effect should this have on free cash flow: (1) in the short run and (2) in the long run?

f. Johnson knows that RR sells on the same credit terms as other firms in its industry. Use the ratios presented earlier to explain whether RR’s customers pay more or less promptly than those of its competitors. If there are differences, does that suggest RR should tighten or loosen its credit policy? What four variables make up a firm’s credit policy, and in what direction should each be changed by RR?

g. Does RR face any risks if it tightens its credit policy?

h. If the company reduces its DSO without seriously affecting sales, what effect would this have on free cash flow: (1) in the short run and (2) in the long run?

i. What is the impact of higher levels of accruals, such as accrued wages or accrued taxes? Is it likely that RR could make changes to accruals?

j. Assume that RR purchases $200,000 (net of discounts) of materials on terms of 1 10, net 30, but that it can get away with paying on the 40th day if it chooses not to take discounts. How much free trade credit can the company get from its equipment supplier, how much costly trade credit can it get, and what is the nominal annual interest rate of the costly credit? Should RR take discounts?

k. Cash doesn’t earn interest, so why would a company have a positive target cash balance?

l. What might RR do to reduce its target cash balance without harming operations?

m. RR tries to match the maturity of its assets and liabilities. Describe how RR could adopt either a more aggressive or a more conservative financing policy.

n. What are the advantages and disadvantages of using short-term debt as a source of financing?

o. Would it be feasible for RR to finance with commercial paper?

p. In an attempt to better understand RR’s cash position, Johnson developed a cash budget for the first 2 months of the year. She has the figures for the other months, but they are not shown. After looking at the cash budget, answer the following questions.

1. What does the cash budget show regarding the target cash level?

2. Should depreciation expense be explicitly included in the cash budget? Why or why not?

3. What are some other potential cash inflows besides collections?

4. How can interest earned or paid on short-term securities or loans be incorporated in the cash budget? 5. In her preliminary cash budget, Johnson has assumed that all sales are

5. In her preliminary cash budget, Johnson has assumed that all sales are collected and thus that RR has no bad debts. Is this realistic? If not, how would bad debts be dealt with in a cash budgeting sense? (Hint: Bad debts will affect collections but not purchases.)

Reference no: EM132028638

Questions Cloud

Describes after-tax cash flow and loan cash flow : Which of the following describes loan cash flow (LCF)? Which of the following describes after-tax cash flow (ATCF)?
Investment can be undertaken within the bounds of assumption : How much investment can be undertaken within the bounds of this assumption?
The expected market value of the firm common equity : If the market is in equilibrium, what is the expected market value of the firm’s common equity (1 million shares outstanding)?
Determine the annual cost of purchasing the new technology : Determine the annual cost of purchasing the new technology. Determine the annual cost of continuing with the manual mixing.
What does the cash budget show regarding target cash level : What does the cash budget show regarding the target cash level? What are some other potential cash inflows besides collections?
Comment on the extent of the risk : calculate the amount that will still be owing on the property at the end of the 5th year and comment on the extent of the risk.
Firm is considering five year capital project : A firm is considering a five year capital project which is expected to have cash inflows of $50,000 per year. What is the net present value of the project?
Manufacturing corporation with annual sales revenues : You are the Chief Financial Officer of a large publically traded U.S. based manufacturing corporation with annual sales revenues of over $2 billion.
How much would the time period of the mortgage shorten : Calculate the size of the payments. how much would the time period of the mortgage shorten?

Reviews

Write a Review

Financial Management Questions & Answers

  The bonds make annual payments

The bonds make annual payments. If the YTM on these bonds is 10 percent, what is the current bond price?

  What is portfolio weight of stock

You own the following portfolio of stocks. What is the portfolio weight of stock C?

  Decide between two different conveyor belt systems

Lang Industrial Systems Company (LISC) is trying to decide between two different conveyor belt systems. System A costs $220,000, has a four-year life, and requires $70,000 in pretax annual operating costs. System B costs $312,000, has a six-year life..

  Calculate the ratio of internal capital recovery

Calculate the present value if the MARR is 10% annual compound. Calculate the ratio of internal capital recovery.

  What should be paid for overland common stock

Which of the following amounts is closest to what should be paid for Overland common stock? Overland has just paid a dividend of $2.25. These dividends are expected to grow at a rate of 5% in the foreseeable future. The required rate of return is 11%..

  Operating margin ratio measures

Operating margin ratio measures:

  What is the present value of this investment

You win a scratch off lottery ticket that promises to pay an initial payment of 10,000 this year, what is the present value of this investment?

  Construct a blended payment repayment schedule

What is the monthly rate of interest? Construct a blended payment repayment schedule. What are the total interest charges?

  What is the standard deviation of the bond fund returns

There are three states of the economy: Low, Medium, and High, with probabilities 25%(Low), What is the standard deviation of the bond fund's returns?

  Preferred stock expected return

You are planning to purchase 200 shares of preferred stock and must choose between Stock A and Stock B. What is the expected return of Stock? A?

  Calculate the time required to repay the loan

Calculate the time required to repay the loan, in years and months (at the new interest rate) if the loan instalment remains unaltered ($4,510.11). (g) In part (f), what will be the amount of the final monthly repayment?

  Financially beneficial for the investor to refinance

Explain whether or not it would be financially beneficial for the investor to refinance, if the plan is to own the property for the remaining loan term. Assume that the investor refinances an amount equal to the outstanding balance of the loan. Us..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd