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

  Foreign company acquisition

Acquisition by a foreign company and the effects of that decision and the results of foreign exchange in Euro and the exchange rate differences.

  Financial management for profit and non profit organizations

In this essay, we are going to discuss the issues of financial management in a non-profit organisation.

  Method for estimating a venture''s value

Evaluate venture's present value, cash and surplus cash and basic venture capital.

  Replacement analysis

This document show the Replacement Analysis of modling machine. Is replacement give profit to company or not?

  Business finance task - capital budgeting

Your company is considering using the payback period for capital-budgeting. Discuss the advantages and disadvantages of this technique.

  Analysis of the investment

In this project, you will focus on one of these: the additional cost resulting from the purchase of an apple press (a piece of equipment required to manufacture apple juice).

  Conduct a what-if analysis

Review the readings and media for this unit, including the Anthony's Orchard case study media. Familiarise yourself with the Anthony's Orchard company and its current situation.

  Determine operational expenditures

Organisations' behaviour is guided by financial data. In the short term, such data will help determine operational expenditures; in the long term, historical data may help generate forecasts aimed at determining strategic plans. In both instances.

  Personal financial management

How much will you have left over each half year if you adopt the latter course of action?

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  Long term financial planning

This assignment is designed for analyze Long term financial planning begins with the sales forecast and the key input in the long term fincial planning.

  Explain the role of fincial manager

This assignment explain the role of fincial manager, function of manger. And what are the motives of financial manager.

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