Chapter 6
Discussion Questions
6-1.
Explain how rapidly expanding sales can drain the cash resources of a firm.
Rapidly expanding sales will require a buildup in assets to support the growth,In particular,more and more of the increase in current assets will be permanent in nature,A nonliquidating aggregate stock of current assets will be necessary to allow for floor displays,multiple items for selection,and other purposes,All of these "asset" investments can drain the cash resources of the firm.
6-2.
Discuss the relative volatility of short- and long-term interest rates.
Figure 6-10 shows the long-run view of short- and long-term interest rates,Normally,short-term rates are much more volatile than long-term rates.
6-3.
What is the significance to working capital management of matching sales and production?
If sales and production can be matched,the level of inventory and the amount of current assets needed can be kept to a minimum; therefore,lower financing costs will be incurred,Matching sales and production has the advantage of maintaining smaller amounts of current assets than level production,and therefore less financing costs are incurred,However,if sales are seasonal or cyclical,workers will be laid off in a declining sales climate and machinery (fixed assets) will be idle,Here lies the tradeoff between level and seasonal production,Full utilization of fixed assets with skilled workers and more financing of current assets versus unused capacity,training and retraining workers,with lower financing for current assets.
6-4.
How is a cash budget used to help manage current assets?
A cash budget helps minimize current assets by providing a forecast of inflows and outflows of cash,It also encourages the development of a schedule as to when inventory is produced and maintained for sales (production schedule),and accounts receivables are collected,The cash budget allows us to forecast the level of each current asset and the timing of the buildup and reduction of each.
6-5.
"The most appropriate financing pattern would be one in which asset buildup and length of financing terms are perfectly matched." Discuss the difficulty involved in achieving this financing pattern.
Only a financial manager with unusual insight and timing could design a plan in which asset buildup and the length of financing terms are perfectly matched,One would need to know exactly what part of current assets are temporary and what part are permanent,Furthermore,one is never quite sure how much short-term or long-term financing is available at all times,Even if this were known,it would be difficult to change the financing mix on a continual basis.
6-6.
By using long-term financing to finance part of temporary current assts,a firm may have less risk but lower returns than a firm with a normal financing plan,Explain the significance of this statement.
By establishing a long-term financing arrangement for temporary current assets,a firm is assured of having necessary funding in good times as well as bad,thus we say there is low risk,However,long-term financing is generally more expensive than short-term financing and profits may be lower than those which could be achieved with a synchronized or normal financing arrangement for temporary current assets.
6-7.
A firm that uses short-term financing methods for a portion of permanent current assets is assuming more risk but expects higher returns than a firm with a normal financing plan,Explain.
By financing a portion of permanent current assets on a short-term basis,we run the risk of inadequate financing in tight money periods,However,since short-term financing is less expensive than long-term funds,a firm tends to increase its profitability over the long run (assuming it survives),In answer to the preceding question,we stressed less risk and less return; here the emphasis is on risk and high return.
6-8.
What does the term structure of interest rates indicate?
The term structure of interest rates shows the relative level of short-term and long-term interest rates at a point in time,It is often referred to as a yield curve.
6-9.
What are three theories for describing the shape of the term structure of interest rates (the yield curve)? Briefly describe each theory.
Liquidity premium theory,the market segmentation theory,and the expectations theory.
The liquidity premium theory indicates that long-term rates should be higher than short-term rates,This premium of long-term rates over short-term rates exists because short-term securities have greater liquidity,and therefore higher rates have to be offered to potential long-term bond buyer to entice them to hold these less liquid and more price sensitive securities.
The market segmentation theory states that Treasury securities are divided into market segments by the various financial institutions investing in the market,The changing needs,desires,and strategies of these investors tend to strongly influence the nature and relationship of short- and long-term rates.
The expectations hypothesis maintains that the yields on long-term securities are a function of short-term rates,The result of the hypothesis is that when long-term rates are much higher than short-term rates,the market is saying that is expects short-term rates to rise,Conversely,when long-term rates are lower than short-term rates,the market is expecting short-term rates to fall.
6-10.
Since the middle 1960s,corporate liquidity has been declining,What reasons can you give for this trend?
The decrease is liquidity can be traced in part to more efficient inventory management such as just-in-time inventory and point of sales terminals that provide better inventory control,The decline in working capital can also be attributed to electronic cash flow transfer systems,and the ability to sell accounts receivables through securitization of assets (this is more fully explained in the next chapter),It might also be that management is simply willing to take more liquidity risk as interest rates declined.
Problems
6-1.
Gary’s Pipe and Steel company expects sales next year to be $800,000 if the economy is strong,$500,000 if the economy is steady,and $350,000 if the economy is weak,Gary believes there is a 20 percent probability the economy will be strong,a 50 percent probability of a steady economy,and a 30 percent probability of a weak economy,What is the expected level of sales for next year?
Solution:
Gary’s Pipe and Steel Company
State of Economy
Sales
Probability
Expected Outcome
Strong
$800,000
.20
$160,000
Steady
500,000
.50
250,000
Weak
350,000
.30
105,000
Expected level of sales =
$515,000
6-2.
Tobin Supplies Company expects sales next year to be $500,000,Inventory and accounts receivable will have to be increased by $90,000 to accommodate this sales level,The company has a steady profit margin of 12 percent with a 40 percent dividend payout,How much external financing will Tobin Supplies Company have to seek? Assume there is no increase in liabilities other than that which will occur with the external financing.
Solution:
Tobin Supplies Company
$500,000
Sales
,12
Profit margin
60,000
Net income
– 24,000
Dividends (40%)
$ 36,000
Increase in retained earnings
$ 90,000
Increase in assets
– 36,000
Increase in retained earnings
$ 54,000
External funds needed
6-3.
Shamrock Diamonds expects sales next year to be $3,000,000,Inventory and accounts receivable will increase $420,000 to accommodate this sales level,The company has a steady profit margin of 10 percent with a 25 percent dividend payout,How much external financing will the firm have to seek? Assume there is no increase in liabilities other than that which will occur with the external financing.
Solution:
Shamrock Diamonds
$3,000,000 Sales
,10 Profit margin
300,000 Net income
75,000 Dividends (25%)
$ 225,000 Increase in retained earnings
420,000 Increase in assets
–225,000 Increase in retained earnings
$195,000 External funds needed
6-4.
Madonna’s Clothiers sells scarves that are very popular in the fall-winter season,Units sold are anticipated as:
October 2,000
November 4,000
December 8,000
January 6,000
20,000 units
If seasonal production is used,it is assumed that inventory buildup will directly match sales for each month and there will be no inventory buildup.
The production manager thinks the above assumption is too optimistic and decides to go with level production to avoid being out of merchandise,He will produce the 20,000 units over 4 months at a level of 5,000 per month.
a. What is the ending inventory at the end of each month? Compare the units produced to the units sold and keep a running total.
b. If the inventory costs $7 per unit and will be financed at the bank at a cost of 8%,what is the monthly financing cost and the total for the 4 months?
6-4,Continued
Solution:
Madonna’s Clothiers
a.
Units Produced
Units Sold
Change in inventory
Ending Inventory
October
5,000
2,000
+3,000
3,000
November
5,000
4,000
+1,000
4,000
December
5,000
8,000
–3,000
1,000
January
5,000
6,000
–1,000
0
b.
Ending Inventory
Cost per Unit ($7)
Inventory
Financing Cost
October
$3,000
$21,000
$1,680
November
4,000
28,000
2,240
December
1,000
7,000
560
January
0
0
0
$4,480
6-5.
Procter Micro-Computers,Inc,requires $1,200,000 in financing over the next two years,The firm can borrow the funds for two years at 9.5 percent interest per year,Mr,Procter decides to do economic forecasting and determines that if he utilizes short-term financing instead,he will pay 6.55 percent interest in the first year and 10.95 percent interest in the second year,Determine the total two-year interest cost under each plan,Which plan is less costly?
Solution:
Procter-Mini-Computers,Inc.
Cost of Two Year Fixed Cost Financing
$1,200,000 borrowed x 9.5% per annum x 2 years = $228,000 interest cost
Cost of Two Year Variable Short-term Financing
1st year $1,200,000 x 6.55% per annum = $ 78,600 interest cost
2nd year $1,200,000 x 10.95% per annum = $131,400 interest cost
$210,000 two-year total
The short-term plan is less costly.
6-6.
Sauer Food Company has decided to buy a new computer system with an expected life of three years,The cost is $150,000,The company can borrow $150,000 for three years at 10 percent annual interest or for one year at 8 percent annual interest.
How much would Sauer Food Company save in interest over the three-year life of the computer system if the one-year loan is utilized and the loan is rolled over (reborrowed) each year at the same 8 percent rate? Compare this to the 10 percent three-year loan,What if interest rates on the 8 percent loan go up to 13 percent in year 2 and 18 percent in year 3? What is the total interest cost now compared to the 10 percent,three-year loan?
Solution:
Sauer Food Company
If Rates Are Constant
$150,000 borrowed x 8% per annum x 3 years =
$36,000 interest cost
$150,000 borrowed x 10% per annum x 3 years =
$45,000 interest cost
$45,000 – $36,000 = $9,000 interest savings borrowing
short-term
If Short-term Rates Change
1st year
$150,000 x,08 = $12,000
$150,000 x,13 = $19,500
$150,000 x,18 = $27,000
2nd year
3rd year
Total = $58,500
$58,500 – $45,000 = $13,500 extra interest costs borrowing short-term.
6-7.
Assume Stratton Health Clubs,Inc.,has $3,000,000 in assets,If it goes with a low liquidity plan for the assets,it can earn a return of 20 percent,but with a high liquidity plan,the return will be 13 percent,If the firm goes with a short-term financing plan,the financing costs on the $3,000,000 will be 10 percent,and with a long-term financing plan,the financing costs on the $3,000,000 will be 12 percent,(Review Table 6-11 for parts a,b,and c of this problem.)
a. Compute the anticipated return after financing costs on the most aggressive asset-financing mix.
b. Compute the anticipated return after financing costs on the most conservative asset-financing mix.
c. Compute the anticipated return after financing costs on the two moderate approaches to the asset-financing mix.
d. Would you necessarily accept the plan with the highest return after financing costs? Briefly explain.
6-7,Continued
Solution:
Stratton Health Clubs,Inc.
a. Most aggressive
Low liquidity/high return
$3,000,000 x 20% =
$600,000
Short-term financing
–3,000,000 x 10% =
–300,000
Anticipated return
$300,000
b. Most conservative
High liquidity/low return
$3,000,000 x 13% =
$390,000
Long-term financing
–3,000,000 x 12% =
–360,000
Anticipated return
$?30,000
c. Moderate approach
Low liquidity
$3,000,000 x 20% =
$600,000
Long-term financing
–3,000,000 x 12% =
–360,000
$240,000
Or
High liquidity
$3,000,000 x 13% =
$390,000
Short-term financing
–3,000,000 x 10% =
–300,000
$?90,000
d. You may not necessarily select the plan with the highest return,You must also consider the risk inherent in the plan,Of course,some firms are better able to take risks than others,The ultimate concern must be for maximizing the overall valuation of the firm through a judicious consideration of risk-return options.
6-8.
Colter Steel has $4,200,000 in assets.
Temporary current assets
$1,000,000
Permanent current assets
2,000,000
Fixed assets
1,200,000
Total assets
$4,200,000
Short-term rates are 8 percent,Long-term rates are 13 percent,Earnings before interest and taxes are $996,000,The tax rate is 40 percent.
If long-term financing is perfectly matched (synchronized) with long-term asset needs,and the same is true of short-term financing,what will earnings after taxes be? For an example of perfectly matched plans,see Figure 6-5.
Solution:
Colter Steel
Long-term financing equals:
Permanent current assets
$2,000,000
Fixed assets
1,200,000
$3,200,000
Short-term financing equals:
Temporary current assets
$1,000,000
Long-term interest expense = 13% x $3,200,000 =
$ 416,000
Short-term interest expense = 8% x 1,000,000 =
80,000
Total interest expense
$?496,000
Earnings before interest and taxes
$? 996,000
Interest expense
496,000
Earnings before taxes
$? 500,000
Taxes (40%)
200,000
Earnings after taxes
$? 300,000
6-9.
In problem 8,assume the term structure of interest rates becomes inverted,with short-term rates going to 11 percent and long-term rates 4 percentage points lower than short-term rates.
If all other factors in the problem remain unchanged,what will earnings after taxes be?
Solution:
Colter Steel (Continued)
Long-term interest expense = 7% x $3,200,000 = $224,000
Short-term interest expense = 11% x 1,000,000 = 110,000
Total interest expense $334,000
Earnings before interest and taxes $996,000
Interest expense 334,000
Earnings before taxes $662,000
Taxes (40%) 264,800
Earnings after taxes $397,200
6-10.
Guardian,Inc.,is trying to develop an asset-financing plan,The firm has $400,000 in temporary current assets and $300,000 in permanent current assets,Guardian also has $500,000 in fixed assets,Assume a tax rate of 40 percent.
a. Construct two alternative financing plans for Guardian,One of the plans should be conservative,with 75 percent of assets financed by long-term sources,and the other should be aggressive,with only 56.25 percent of assets financed by long-term sources,The current interest rate is 15 percent on long-term funds and 10 percent on short-term financing.
b. Given that Guardian’s earnings before interest and taxes are $200,000,calculate earnings after taxes for each of your alternatives.
c. What would happen if the short- and long-term rates were reversed?
6-10,Continued
Solution:
Guardian,Inc.
a. Temporary current assets $ 400,000
Permanent current assets 300,000
Fixed assets 500,000
Total assets $1,200,000
Conservative
% of Interest Interest
Amount Total Rate Expense
$1,200,000 x,75 = $900,000 x,15 = $135,000 Long-term
$1,200,000 x,25 = $300,000 x,10 = 30,000 Short-term
Total interest charge $165,000
Aggressive
$1,200,000 x,5625 = $675,000 x,15 = $101,250 Long-term
$1,200,000 x,4375 = $525,000 x,10 = 52,500 Short-term
Total interest charge $153,750
b.
Conservative
Aggressive
EBIT
$200,000
$200,000
–Int
165,000
153,750
EBT
35,000
46,250
Tax 40%
14,000
18,500
EAT
$ 21,000
$ 27,750
6-10,Continued
c,Reversed:
Conservative
$1,200,000 x,75 = $900,000 x,10 = $90,000 Long-term
$1,200,000 x,25 = $300,000 x,15 = 45,000 Short-term
Total interest charge $135,000
Aggressive
$1,200,000 x,5625 = $675,000 x,10 = $67,500 Long-term
$1,200,000 x,4375 = $525,000 x,15 = 78,750 Short-term
Total interest charge $146,250
Reversed
Conservative
Aggressive
EBIT
$200,000
$200,000
–Int
135,000
146,250
EBT
65,000
53,750
Tax 40%
26,000
21,500
EAT
$ 39,000
$ 32,250
6-11.
Lear,Inc.,has $800,000 in current assets,$350,000 of which are considered permanent current assets,In addition,the firm has $600,000 invested in fixed assets.
a. Lear wishes to finance all fixed assets and half of its permanent current assets with long-term financing costing 10 percent,Short-term financing currently costs 5 percent,Lear's earnings before interest and taxes are $200,000,Determine Lear's earnings after taxes under this financing plan,The tax rate is 30 percent.
b. As an alternative,Lear might wish to finance all fixed assets and permanent current assets plus half of its temporary current assets with long-term financing,The same interest rates apply as in part a,Earnings before interest and taxes will be $200,000,What will be Lear's earnings after taxes? The tax rate is 30 percent.
c. What are some of the risks and cost considerations associated with each of these alternative financing strategies?
6-11,Continued
Solution:
Lear,Inc.
a. Current assets – permanent current assets = temporary current assets
$800,000 – $350,000 = $450,000
Short-term interest expense = 5% [$450,000 +? ($350,000)]
= 5% ($625,000)
= $31,250
Long-term interest expense = 10% [$600,000 +? ($350,000)]
= 10% ($775,000)
= $77,500
Total interest expense = $31,250 + $77,500
= $108,750
Earnings before interest and taxes $200,000
Interest expense 108,750
Earnings before taxes $ 91,250
Taxes (30%) 27,375
Earnings after taxes $ 63,875
6-11,Continued
b. Alternative financing plan
Short-term interest expense = 5% [? ($450,000)]
= 5% (225,000)
= $11,250
Long-term interest expense = 10% [$600,000 + $350,000
+? ($450,000)]
= 10% ($1,175,000)
= $117,500
Total interest expense = $11,250 + $117,500
= $128,750
Earnings before interest and taxes $200,000
Interest 128,750
Earnings before taxes $ 71,250
Taxes (30%) 21,375
Earnings after taxes $ 49,875
c. The alternative financing plan which calls for more financing by high-cost debt is more expensive and reduces aftertax income by $14,000,However,we must not automatically reject this plan because of its higher cost since it has less risk,The alternative provides the firm with long-term capital which at times will be in excess of its needs and invested in marketable securities,It will not be forced to pay higher short-term rates on a large portion of its debt when short-term rates rise and will not be faced with the possibility of no short-term financing for a portion of its permanent current assets when it is time to renew the short-term loan.
6-12.
Using the expectations hypothesis theory for the term structure of interest rates,determine the expected return for securities with maturities of two,three,and four years based on the following data,Do an analysis similar to that in the right-hand portion of Table 6-6.
1-year T-bill at beginning of year 1 6%
1-year T-bill at beginning of year 2 7%
1-year T-bill at beginning of year 3 9%
1-year T-bill at beginning of year 4 11%
Solution:
2 year security (6% + 7%)/2 = 6.5%
3 year security (6% + 7% + 9%)/3 = 7.33%
4 year security (6% + 7% + 9% + 11%)/4 = 8.25%
6-13.
Modern Tombstones has estimated monthly financing requirements for the next six months as follows:
January $20,000
April $10,000
February 6,000
May 22,000
March 8,000
June 12,000
Short-term financing will be utilized for the next six months,Projected annual interest rates are:
January 9.0%
April 15.0%
February 8.0%
May 12.0%
March 12.0%
June 9.0%
a. Compute total dollar interest payments for the six months,To convert an annual rate to a monthly rate,divide by 12,
b. If long-term financing at 12 percent had been utilized throughout the six months,would the total-dollar interest payments be larger or smaller?
6-13,Continued
Solution:
Modern Tombstones
a. Short-term financing
Month
Rate
On Monthly Basis
Amount
Actual Interest
January
9%
.75%
$20,000
$150.00
February
8%
.67%
$ 6,000
$ 40.20
March
12%
1.00%
$ 8,000
$ 80.00
April
15%
1.25%
$10,000
$125.00
May
12%
1.00%
$22,000
$220.00
June
9%
.75%
$12,000
$ 90.00
$705.20
b. Long-term financing
Month
Rate
On Monthly Basis
Amount
Actual Interest
January
12%
1%
$20,000
$200.00
February
12%
1%
$ 6,000
$ 60.00
March
12%
1%
$ 8,000
$ 80.00
April
12%
1%
$10,000
$100.00
May
12%
1%
$22,000
$220.00
June
12%
1%
$12,000
$120.00
$780.00
Total dollar interest payments would be larger under the long-term financing plan.
6-14.
In problem 13,what long-term interest rate would represent a break-even point between using short-term financing as described in part a and long-term financing? Hint,Divide the interest payments in 9a by the amount of total funds provided for the six months and multiply by 12.
Solution:
Divide the total interest payments in part (a) of $705.20 by the total amount of funds extended $78,000 ($20,000 + 6,000 + 8,000 + 10,000 + 22,000 + 12,000) and multiply by 12.
12 x,904% = 10.848% annual rate
6-15.
Sherwin Paperboard Company expects to sell 600 units in January,700 units in February,and 1,200 units in March,January's beginning inventory is 800 units,Expected sales for the whole year are 12,000 units,Sherwin has decided on a level monthly production schedule of 1,000 units (12,000 units/12 months = 1,000 units per month),What is the expected end-of-month inventory for January,February,and March? Show the beginning inventory,production,and sales for each month to arrive at ending inventory.
Beginning inventory + Production (level) – Sales = Ending inventory
Solution:
Sherwin Paperboard Company
Beginning Production Ending
Inventory + (level) – Sales = Inventory
January
800
1,000
600
1,200
February
1,200
1,000
700
1,500
March
1,500
1,000
1,200
1,300
6-16.
Sharpe Computer Graphics Corporation has forecasted the following monthly sales:
January $80,000
July $ 30,000
February 70,000
August 31,000
March 10,000
September 40,000
April 10,000
October 70,000
May 15,000
November 90,000
June 20,000
December 110,000
Total annual sales = $576,000
The firm sells its graphic forms for $5 per unit,and the cost to produce the forms is $2 per unit,A level production policy is followed,Each month's production is equal to annual sales (in units) divided by 12.
Of each month's sales,30 percent are for cash and 70 percent are on account,All accounts receivable are collected in the month after the sale is made.
a. Construct a monthly production and inventory schedule in units,Beginning inventory in January is 15,000 units,(Note,To do part a,you should work in terms of units of production and units of sales.)
b. Prepare a monthly schedule of cash receipts,Sales in the month of December before the planning year are $90,000,Work part b using dollars.
c. Determine a cash payments schedule for January through December,The production costs of $2 per unit are paid for in the month in which they occur,Other cash payments,besides those for production costs,are $30,000 per month.
d. Prepare a monthly cash budget for January through December,The beginning cash balance is $5,000 and that is also the minimum desired.
6-16,Continued
Solution:
Sharpe Computer Graphics Corporation
Production and inventory schedule in units
Beginning
Inventory
+Production1
–Sales2
= Ending Inventory
January
15,000
9,600
16,000
8,600
February
8,600
9,600
14,000
4,200
March
4,200
9,600
2,000
11,800
April
11,800
9,600
2,000
19,400
May
19,400
9,600
3,000
26,000
June
26,000
9,600
4,000
31,600
July
31,600
9,600
6,000
35,200
August
35,200
9,600
6,200
38,600
September
38,600
9,600
8,000
40,200
October
40,200
9,600
14,000
35,800
November
35,800
9,600
18,000
27,400
December
27,400
9,600
22,000
15,000
1 Total annual sales = $576,000
$576,000/$5 per unit = 115,200 units
115,200 units/12 months = 9,600 per month
2 Monthly dollar sales/$5 price = unit sales
6-16,Continued
b.
Cash Receipts Schedule
Jan.
Feb.
Mar.
Apr.
May
June
Sales (in dollars)
$80,000
$70,000
$10,000
$10,000
$15,000
$20,000
30% Cash sales
24,000
21,000
3,000
3,000
4,500
6,000
70% Prior month's sales
63,000*
56,000
49,000
7,000
7,000
10,500
Total cash receipts
$87,000
$77,000
$52,000
$10,000
$11,500
$16,500
*based on December sales of $90,000
July
Aug.
Sept.
Oct.
Nov.
Dec.
Sales (in dollars)
$30,000
$31,000
$40,000
$70,000
$90,000
$110,000
30% Cash sales
9,000
9,300
12,000
21,000
27,000
33,000
70% Prior month's sales
14,000
21,000
21,700
28,000
49,000
63,000
Total cash receipts
$23,000
$30,300
$33,700
$49,000
$76,000
$ 96,000
Copyright? 2005 by The McGraw-Hill Companies,Inc.
6-16,Continued
c.
Cash Payments Schedule
Constant production
Jan.
Feb.
Mar.
Apr.
May
June
9,600 units x $2
$19,200
$19,200
$19,200
$19,200
$19,200
$19,200
Other cash payments
30,000
30,000
30,000
30,000
30,000
30,000
Total cash payments
$49,200
$49,200
$49,200
$49,200
$49,200
$49,200
July
Aug.
Sept.
Oct.
Nov.
Dec.
9,600 units x $2
$19,200
$19,200
$19,200
$19,200
$19,200
$19,200
Other cash payments
30,000
30,000
30,000
30,000
30,000
30,000
Total cash payments
$49,200
$49,200
$49,200
$49,200
$49,200
$49,200
Copyright? 2005 by The McGraw-Hill Companies,Inc.
6-16,Continued
d.
Cash Budget
Jan.
Feb.
Mar.
Apr.
May
June
Net cash flow
$37,800
$27,800
$ 2,800
($39,200)
($37,700)
($32,700)
Beginning cash
5,000
42,800
70,600
73,400
34,200
5,000
Cumulative cash balance
42,800
70,600
73,400
34,200
(3,500)
(27,700)
Monthly loan or (repayment)
-0-
-0-
-0-
-0-
8,500
32,700
Cumulative loan
-0-
-0-
-0-
-0-
8,500
41,200
Ending cash balance
42,800
70,600
73,400
34,200
5,000
5,000
July
Aug.
Sept.
Oct.
Nov.
Dec.
Net cash flow
($26,200)
($18,900)
($15,500)
($200)
$26,800
$46,800
Beginning cash
5,000
5,000
5,000
5,000
5,000
5,000
Cumulative cash balance
(21,200)
(13,900)
(10,500)
4,800
31,800
51,800
Monthly loan or (repayment)
26,200
18,900
15,500
200
(26,800)
(46,800)
Cumulative loan
67,400
86,300
101,800
102,000
75,200
28,400
Ending cash balance
5,000
5,000
5,000
5,000
5,000
5,000
Copyright? 2005 by The McGraw-Hill Companies,Inc.
6-17.
Seasonal Products Corporation expects the following monthly sales:
January $20,000
May $ 1,000
September $20,000
February 15,000
June 3,000
October 25,000
March 5,000
July 10,000
November 30,000
April 3,000
August 14,000
December 22,000
Total sales = $168,000
Sales are 20 percent for cash in a given month,with the remainder going into accounts receivable,All 80 percent of the credit sales are collected in the month following the sale,Seasonal Products uses level production,and average monthly production is equal to annual production divided by 12.
a. Generate a monthly production and inventory schedule in units,Beginning inventory in January is 5,000 units,(Note,To do part a,you should work in terms of units of production and units of sales.)
b. Determine a cash receipts schedule for January through December,Assume that dollar sales in the prior December were $15,000,Work part b using dollars.
c. Determine a cash payments schedule for January through December,The production costs ($1 per unit produced) are paid for in the month in which they occur,Other cash payments,besides those for production costs,are $6,000 per month.
d. Construct a cash budget for January through December,The beginning cash balance is $1,000,and that is also the required minimum.
e. Determine total current assets for each month,(Note,Accounts receivable equal sales minus 20 percent of sales for a given month.)
6-17,Continued
Solution:
Seasonal Products Corporation
a. Production and inventory schedule in units
Beginning
Inventory
+Production1
(level)
–Sales2
= Ending Inventory
($1 per unit)
January
5,000
7,000
10,000
2,000
February
2,000
7,000
7,500
1,500
March
1,500
7,000
2,500
6,000
April
6,000
7,000
1,500
11,500
May
11,500
7,000
500
18,000
June
18,000
7,000
1,500
23,500
July
23,500
7,000
5,000
25,500
August
25,500
7,000
7,000
25,500
September
25,500
7,000
10,000
22,500
October
22,500
7,000
12,500
17,000
November
17,000
7,000
15,000
9,000
December
9,000
7,000
11,000
5,000
1 $168,000 sales/$2 price = 84,000 units
84,000 units/12 months = 7,000 units per month
2 Monthly dollar sales/$2 = number of units
6-17,Continued
b.
Cash Receipts Schedule (take dollar values from problem statement)
Jan.
Feb.
Mar.
Apr.
May
June
Sales
$20,000
$15,000
$ 5,000
$3,000
$1,000
$3,000
20% Cash sales
4,000
3,000
1,000
600
200
600
80% Prior month's sales
12,000*
16,000
12,000
4,000
2,400
800
Total receipts
$16,000
$19,000
$13,000
$4,600
$2,600
$1,400
*based on December sales of $15,000
July
Aug.
Sept.
Oct.
Nov.
Dec.
Sales
$10,000
$14,000
$20,000
$25,000
$30,000
$22,000
20% Cash sales
2,000
2,800
4,000
5,000
6,000
4,400
80% Prior month's sales
2,400
8,000
11,200
16,000
20,000
24,000
Total receipts
$ 4,400
$10,800
$15,200
$21,000
$26,000
$28,400
Copyright? 2005 by The McGraw-Hill Companies,Inc.
6-17,Continued
c.
Cash Payments Schedule
Constant production
Jan.
Feb.
Mar.
Apr.
May
June
7,000 units x $1
$ 7,000
$ 7,000
$ 7,000
$ 7,000
$ 7,000
$ 7,000
Other cash payments
6,000
6,000
6,000
6,000
6,000
6,000
Total payments
$13,000
$13,000
$13,000
$13,000
$13,000
$13,000
July
Aug.
Sept.
Oct.
Nov.
Dec.
7,000 units x $1
$ 7,000
$ 7,000
$ 7,000
$ 7,000
$ 7,000
$ 7,000
Other cash payments
6,000
6,000
6,000
6,000
6,000
6,000
Total cash payments
$13,000
$13,000
$13,000
$13,000
$13,000
$13,000
Copyright? 2005 by The McGraw-Hill Companies,Inc.
6-17,Continued
d.
Cash Budget
Jan.
Feb.
Mar.
Apr.
May
June
Cash flow
$3,000
$ 6,000
-0-
($ 8,400)
($10,400)
($11,600)
Beginning cash
1,000
4,000
10,000
10,000
1,600
1,000
Cumulative cash balance
4,000
10,000
10,000
1,600
(8,800)
(10,600)
Monthly loan or (repayment)
-0-
-0-
-0-
-0-
9,800
11,600
Cumulative loan
-0-
-0-
-0-
-0-
9,800
21,400
Ending cash balance
$4,000
$10,000
$10,000
$ 1,600
$ 1,000
$ 1,000
July
Aug.
Sept.
Oct.
Nov.
Dec.
Cash flow
($ 8,600)
($2,200)
$ 2,200
$ 8,000
$13,000
$15,400
Beginning cash
1,000
1,000
1,000
1,000
1,000
1,000
Cumulative cash balance
(7,600)
(1,200)
3,200
9,000
14,000
16,400
Monthly loan or (repayment)
8,600
2,200
(2,200)
(8,000)
(13,000)
(9,000)
Cumulative loan
30,000
32,200
30,000
22,000
9,000
-0-
Ending cash balance
$ 1,000
$ 1,000
$ 1,000
$ 1,000
$ 1,000
$ 7,400
Copyright? 2005 by The McGraw-Hill Companies,Inc.
6-17,Continued
e. Assets
Cash
Accounts Receivable
Inventory
Total Current
January
$ 4,000
$16,000
$ 2,000
$22,000
February
10,000
12,000
1,500
23,500
March
10,000
4,000
6,000
20,000
April
1,600
2,400
11,500
15,500
May
1,000
800
18,000
19,800
June
1,000
2,400
23,500
26,900
July
1,000
8,000
25,500
34,500
August
1,000
11,200
25,500
37,700
September
1,000
16,000
22,500
39,500
October
1,000
20,000
17,000
38,000
November
1,000
24,000
9,000
34,000
December
7,400
17,600
5,000
30,000
The instructor may wish to relate this table to the case budget to show how the buildup in current assets is financed,Also,the table shows how the assets build up from the least liquid current asset (inventory) to the next liquid asset (accounts receivables),and finally by December,the cycle is ready to start over with the flow into the cash balance when the firm eliminates its final loan balance.
Discussion Questions
6-1.
Explain how rapidly expanding sales can drain the cash resources of a firm.
Rapidly expanding sales will require a buildup in assets to support the growth,In particular,more and more of the increase in current assets will be permanent in nature,A nonliquidating aggregate stock of current assets will be necessary to allow for floor displays,multiple items for selection,and other purposes,All of these "asset" investments can drain the cash resources of the firm.
6-2.
Discuss the relative volatility of short- and long-term interest rates.
Figure 6-10 shows the long-run view of short- and long-term interest rates,Normally,short-term rates are much more volatile than long-term rates.
6-3.
What is the significance to working capital management of matching sales and production?
If sales and production can be matched,the level of inventory and the amount of current assets needed can be kept to a minimum; therefore,lower financing costs will be incurred,Matching sales and production has the advantage of maintaining smaller amounts of current assets than level production,and therefore less financing costs are incurred,However,if sales are seasonal or cyclical,workers will be laid off in a declining sales climate and machinery (fixed assets) will be idle,Here lies the tradeoff between level and seasonal production,Full utilization of fixed assets with skilled workers and more financing of current assets versus unused capacity,training and retraining workers,with lower financing for current assets.
6-4.
How is a cash budget used to help manage current assets?
A cash budget helps minimize current assets by providing a forecast of inflows and outflows of cash,It also encourages the development of a schedule as to when inventory is produced and maintained for sales (production schedule),and accounts receivables are collected,The cash budget allows us to forecast the level of each current asset and the timing of the buildup and reduction of each.
6-5.
"The most appropriate financing pattern would be one in which asset buildup and length of financing terms are perfectly matched." Discuss the difficulty involved in achieving this financing pattern.
Only a financial manager with unusual insight and timing could design a plan in which asset buildup and the length of financing terms are perfectly matched,One would need to know exactly what part of current assets are temporary and what part are permanent,Furthermore,one is never quite sure how much short-term or long-term financing is available at all times,Even if this were known,it would be difficult to change the financing mix on a continual basis.
6-6.
By using long-term financing to finance part of temporary current assts,a firm may have less risk but lower returns than a firm with a normal financing plan,Explain the significance of this statement.
By establishing a long-term financing arrangement for temporary current assets,a firm is assured of having necessary funding in good times as well as bad,thus we say there is low risk,However,long-term financing is generally more expensive than short-term financing and profits may be lower than those which could be achieved with a synchronized or normal financing arrangement for temporary current assets.
6-7.
A firm that uses short-term financing methods for a portion of permanent current assets is assuming more risk but expects higher returns than a firm with a normal financing plan,Explain.
By financing a portion of permanent current assets on a short-term basis,we run the risk of inadequate financing in tight money periods,However,since short-term financing is less expensive than long-term funds,a firm tends to increase its profitability over the long run (assuming it survives),In answer to the preceding question,we stressed less risk and less return; here the emphasis is on risk and high return.
6-8.
What does the term structure of interest rates indicate?
The term structure of interest rates shows the relative level of short-term and long-term interest rates at a point in time,It is often referred to as a yield curve.
6-9.
What are three theories for describing the shape of the term structure of interest rates (the yield curve)? Briefly describe each theory.
Liquidity premium theory,the market segmentation theory,and the expectations theory.
The liquidity premium theory indicates that long-term rates should be higher than short-term rates,This premium of long-term rates over short-term rates exists because short-term securities have greater liquidity,and therefore higher rates have to be offered to potential long-term bond buyer to entice them to hold these less liquid and more price sensitive securities.
The market segmentation theory states that Treasury securities are divided into market segments by the various financial institutions investing in the market,The changing needs,desires,and strategies of these investors tend to strongly influence the nature and relationship of short- and long-term rates.
The expectations hypothesis maintains that the yields on long-term securities are a function of short-term rates,The result of the hypothesis is that when long-term rates are much higher than short-term rates,the market is saying that is expects short-term rates to rise,Conversely,when long-term rates are lower than short-term rates,the market is expecting short-term rates to fall.
6-10.
Since the middle 1960s,corporate liquidity has been declining,What reasons can you give for this trend?
The decrease is liquidity can be traced in part to more efficient inventory management such as just-in-time inventory and point of sales terminals that provide better inventory control,The decline in working capital can also be attributed to electronic cash flow transfer systems,and the ability to sell accounts receivables through securitization of assets (this is more fully explained in the next chapter),It might also be that management is simply willing to take more liquidity risk as interest rates declined.
Problems
6-1.
Gary’s Pipe and Steel company expects sales next year to be $800,000 if the economy is strong,$500,000 if the economy is steady,and $350,000 if the economy is weak,Gary believes there is a 20 percent probability the economy will be strong,a 50 percent probability of a steady economy,and a 30 percent probability of a weak economy,What is the expected level of sales for next year?
Solution:
Gary’s Pipe and Steel Company
State of Economy
Sales
Probability
Expected Outcome
Strong
$800,000
.20
$160,000
Steady
500,000
.50
250,000
Weak
350,000
.30
105,000
Expected level of sales =
$515,000
6-2.
Tobin Supplies Company expects sales next year to be $500,000,Inventory and accounts receivable will have to be increased by $90,000 to accommodate this sales level,The company has a steady profit margin of 12 percent with a 40 percent dividend payout,How much external financing will Tobin Supplies Company have to seek? Assume there is no increase in liabilities other than that which will occur with the external financing.
Solution:
Tobin Supplies Company
$500,000
Sales
,12
Profit margin
60,000
Net income
– 24,000
Dividends (40%)
$ 36,000
Increase in retained earnings
$ 90,000
Increase in assets
– 36,000
Increase in retained earnings
$ 54,000
External funds needed
6-3.
Shamrock Diamonds expects sales next year to be $3,000,000,Inventory and accounts receivable will increase $420,000 to accommodate this sales level,The company has a steady profit margin of 10 percent with a 25 percent dividend payout,How much external financing will the firm have to seek? Assume there is no increase in liabilities other than that which will occur with the external financing.
Solution:
Shamrock Diamonds
$3,000,000 Sales
,10 Profit margin
300,000 Net income
75,000 Dividends (25%)
$ 225,000 Increase in retained earnings
420,000 Increase in assets
–225,000 Increase in retained earnings
$195,000 External funds needed
6-4.
Madonna’s Clothiers sells scarves that are very popular in the fall-winter season,Units sold are anticipated as:
October 2,000
November 4,000
December 8,000
January 6,000
20,000 units
If seasonal production is used,it is assumed that inventory buildup will directly match sales for each month and there will be no inventory buildup.
The production manager thinks the above assumption is too optimistic and decides to go with level production to avoid being out of merchandise,He will produce the 20,000 units over 4 months at a level of 5,000 per month.
a. What is the ending inventory at the end of each month? Compare the units produced to the units sold and keep a running total.
b. If the inventory costs $7 per unit and will be financed at the bank at a cost of 8%,what is the monthly financing cost and the total for the 4 months?
6-4,Continued
Solution:
Madonna’s Clothiers
a.
Units Produced
Units Sold
Change in inventory
Ending Inventory
October
5,000
2,000
+3,000
3,000
November
5,000
4,000
+1,000
4,000
December
5,000
8,000
–3,000
1,000
January
5,000
6,000
–1,000
0
b.
Ending Inventory
Cost per Unit ($7)
Inventory
Financing Cost
October
$3,000
$21,000
$1,680
November
4,000
28,000
2,240
December
1,000
7,000
560
January
0
0
0
$4,480
6-5.
Procter Micro-Computers,Inc,requires $1,200,000 in financing over the next two years,The firm can borrow the funds for two years at 9.5 percent interest per year,Mr,Procter decides to do economic forecasting and determines that if he utilizes short-term financing instead,he will pay 6.55 percent interest in the first year and 10.95 percent interest in the second year,Determine the total two-year interest cost under each plan,Which plan is less costly?
Solution:
Procter-Mini-Computers,Inc.
Cost of Two Year Fixed Cost Financing
$1,200,000 borrowed x 9.5% per annum x 2 years = $228,000 interest cost
Cost of Two Year Variable Short-term Financing
1st year $1,200,000 x 6.55% per annum = $ 78,600 interest cost
2nd year $1,200,000 x 10.95% per annum = $131,400 interest cost
$210,000 two-year total
The short-term plan is less costly.
6-6.
Sauer Food Company has decided to buy a new computer system with an expected life of three years,The cost is $150,000,The company can borrow $150,000 for three years at 10 percent annual interest or for one year at 8 percent annual interest.
How much would Sauer Food Company save in interest over the three-year life of the computer system if the one-year loan is utilized and the loan is rolled over (reborrowed) each year at the same 8 percent rate? Compare this to the 10 percent three-year loan,What if interest rates on the 8 percent loan go up to 13 percent in year 2 and 18 percent in year 3? What is the total interest cost now compared to the 10 percent,three-year loan?
Solution:
Sauer Food Company
If Rates Are Constant
$150,000 borrowed x 8% per annum x 3 years =
$36,000 interest cost
$150,000 borrowed x 10% per annum x 3 years =
$45,000 interest cost
$45,000 – $36,000 = $9,000 interest savings borrowing
short-term
If Short-term Rates Change
1st year
$150,000 x,08 = $12,000
$150,000 x,13 = $19,500
$150,000 x,18 = $27,000
2nd year
3rd year
Total = $58,500
$58,500 – $45,000 = $13,500 extra interest costs borrowing short-term.
6-7.
Assume Stratton Health Clubs,Inc.,has $3,000,000 in assets,If it goes with a low liquidity plan for the assets,it can earn a return of 20 percent,but with a high liquidity plan,the return will be 13 percent,If the firm goes with a short-term financing plan,the financing costs on the $3,000,000 will be 10 percent,and with a long-term financing plan,the financing costs on the $3,000,000 will be 12 percent,(Review Table 6-11 for parts a,b,and c of this problem.)
a. Compute the anticipated return after financing costs on the most aggressive asset-financing mix.
b. Compute the anticipated return after financing costs on the most conservative asset-financing mix.
c. Compute the anticipated return after financing costs on the two moderate approaches to the asset-financing mix.
d. Would you necessarily accept the plan with the highest return after financing costs? Briefly explain.
6-7,Continued
Solution:
Stratton Health Clubs,Inc.
a. Most aggressive
Low liquidity/high return
$3,000,000 x 20% =
$600,000
Short-term financing
–3,000,000 x 10% =
–300,000
Anticipated return
$300,000
b. Most conservative
High liquidity/low return
$3,000,000 x 13% =
$390,000
Long-term financing
–3,000,000 x 12% =
–360,000
Anticipated return
$?30,000
c. Moderate approach
Low liquidity
$3,000,000 x 20% =
$600,000
Long-term financing
–3,000,000 x 12% =
–360,000
$240,000
Or
High liquidity
$3,000,000 x 13% =
$390,000
Short-term financing
–3,000,000 x 10% =
–300,000
$?90,000
d. You may not necessarily select the plan with the highest return,You must also consider the risk inherent in the plan,Of course,some firms are better able to take risks than others,The ultimate concern must be for maximizing the overall valuation of the firm through a judicious consideration of risk-return options.
6-8.
Colter Steel has $4,200,000 in assets.
Temporary current assets
$1,000,000
Permanent current assets
2,000,000
Fixed assets
1,200,000
Total assets
$4,200,000
Short-term rates are 8 percent,Long-term rates are 13 percent,Earnings before interest and taxes are $996,000,The tax rate is 40 percent.
If long-term financing is perfectly matched (synchronized) with long-term asset needs,and the same is true of short-term financing,what will earnings after taxes be? For an example of perfectly matched plans,see Figure 6-5.
Solution:
Colter Steel
Long-term financing equals:
Permanent current assets
$2,000,000
Fixed assets
1,200,000
$3,200,000
Short-term financing equals:
Temporary current assets
$1,000,000
Long-term interest expense = 13% x $3,200,000 =
$ 416,000
Short-term interest expense = 8% x 1,000,000 =
80,000
Total interest expense
$?496,000
Earnings before interest and taxes
$? 996,000
Interest expense
496,000
Earnings before taxes
$? 500,000
Taxes (40%)
200,000
Earnings after taxes
$? 300,000
6-9.
In problem 8,assume the term structure of interest rates becomes inverted,with short-term rates going to 11 percent and long-term rates 4 percentage points lower than short-term rates.
If all other factors in the problem remain unchanged,what will earnings after taxes be?
Solution:
Colter Steel (Continued)
Long-term interest expense = 7% x $3,200,000 = $224,000
Short-term interest expense = 11% x 1,000,000 = 110,000
Total interest expense $334,000
Earnings before interest and taxes $996,000
Interest expense 334,000
Earnings before taxes $662,000
Taxes (40%) 264,800
Earnings after taxes $397,200
6-10.
Guardian,Inc.,is trying to develop an asset-financing plan,The firm has $400,000 in temporary current assets and $300,000 in permanent current assets,Guardian also has $500,000 in fixed assets,Assume a tax rate of 40 percent.
a. Construct two alternative financing plans for Guardian,One of the plans should be conservative,with 75 percent of assets financed by long-term sources,and the other should be aggressive,with only 56.25 percent of assets financed by long-term sources,The current interest rate is 15 percent on long-term funds and 10 percent on short-term financing.
b. Given that Guardian’s earnings before interest and taxes are $200,000,calculate earnings after taxes for each of your alternatives.
c. What would happen if the short- and long-term rates were reversed?
6-10,Continued
Solution:
Guardian,Inc.
a. Temporary current assets $ 400,000
Permanent current assets 300,000
Fixed assets 500,000
Total assets $1,200,000
Conservative
% of Interest Interest
Amount Total Rate Expense
$1,200,000 x,75 = $900,000 x,15 = $135,000 Long-term
$1,200,000 x,25 = $300,000 x,10 = 30,000 Short-term
Total interest charge $165,000
Aggressive
$1,200,000 x,5625 = $675,000 x,15 = $101,250 Long-term
$1,200,000 x,4375 = $525,000 x,10 = 52,500 Short-term
Total interest charge $153,750
b.
Conservative
Aggressive
EBIT
$200,000
$200,000
–Int
165,000
153,750
EBT
35,000
46,250
Tax 40%
14,000
18,500
EAT
$ 21,000
$ 27,750
6-10,Continued
c,Reversed:
Conservative
$1,200,000 x,75 = $900,000 x,10 = $90,000 Long-term
$1,200,000 x,25 = $300,000 x,15 = 45,000 Short-term
Total interest charge $135,000
Aggressive
$1,200,000 x,5625 = $675,000 x,10 = $67,500 Long-term
$1,200,000 x,4375 = $525,000 x,15 = 78,750 Short-term
Total interest charge $146,250
Reversed
Conservative
Aggressive
EBIT
$200,000
$200,000
–Int
135,000
146,250
EBT
65,000
53,750
Tax 40%
26,000
21,500
EAT
$ 39,000
$ 32,250
6-11.
Lear,Inc.,has $800,000 in current assets,$350,000 of which are considered permanent current assets,In addition,the firm has $600,000 invested in fixed assets.
a. Lear wishes to finance all fixed assets and half of its permanent current assets with long-term financing costing 10 percent,Short-term financing currently costs 5 percent,Lear's earnings before interest and taxes are $200,000,Determine Lear's earnings after taxes under this financing plan,The tax rate is 30 percent.
b. As an alternative,Lear might wish to finance all fixed assets and permanent current assets plus half of its temporary current assets with long-term financing,The same interest rates apply as in part a,Earnings before interest and taxes will be $200,000,What will be Lear's earnings after taxes? The tax rate is 30 percent.
c. What are some of the risks and cost considerations associated with each of these alternative financing strategies?
6-11,Continued
Solution:
Lear,Inc.
a. Current assets – permanent current assets = temporary current assets
$800,000 – $350,000 = $450,000
Short-term interest expense = 5% [$450,000 +? ($350,000)]
= 5% ($625,000)
= $31,250
Long-term interest expense = 10% [$600,000 +? ($350,000)]
= 10% ($775,000)
= $77,500
Total interest expense = $31,250 + $77,500
= $108,750
Earnings before interest and taxes $200,000
Interest expense 108,750
Earnings before taxes $ 91,250
Taxes (30%) 27,375
Earnings after taxes $ 63,875
6-11,Continued
b. Alternative financing plan
Short-term interest expense = 5% [? ($450,000)]
= 5% (225,000)
= $11,250
Long-term interest expense = 10% [$600,000 + $350,000
+? ($450,000)]
= 10% ($1,175,000)
= $117,500
Total interest expense = $11,250 + $117,500
= $128,750
Earnings before interest and taxes $200,000
Interest 128,750
Earnings before taxes $ 71,250
Taxes (30%) 21,375
Earnings after taxes $ 49,875
c. The alternative financing plan which calls for more financing by high-cost debt is more expensive and reduces aftertax income by $14,000,However,we must not automatically reject this plan because of its higher cost since it has less risk,The alternative provides the firm with long-term capital which at times will be in excess of its needs and invested in marketable securities,It will not be forced to pay higher short-term rates on a large portion of its debt when short-term rates rise and will not be faced with the possibility of no short-term financing for a portion of its permanent current assets when it is time to renew the short-term loan.
6-12.
Using the expectations hypothesis theory for the term structure of interest rates,determine the expected return for securities with maturities of two,three,and four years based on the following data,Do an analysis similar to that in the right-hand portion of Table 6-6.
1-year T-bill at beginning of year 1 6%
1-year T-bill at beginning of year 2 7%
1-year T-bill at beginning of year 3 9%
1-year T-bill at beginning of year 4 11%
Solution:
2 year security (6% + 7%)/2 = 6.5%
3 year security (6% + 7% + 9%)/3 = 7.33%
4 year security (6% + 7% + 9% + 11%)/4 = 8.25%
6-13.
Modern Tombstones has estimated monthly financing requirements for the next six months as follows:
January $20,000
April $10,000
February 6,000
May 22,000
March 8,000
June 12,000
Short-term financing will be utilized for the next six months,Projected annual interest rates are:
January 9.0%
April 15.0%
February 8.0%
May 12.0%
March 12.0%
June 9.0%
a. Compute total dollar interest payments for the six months,To convert an annual rate to a monthly rate,divide by 12,
b. If long-term financing at 12 percent had been utilized throughout the six months,would the total-dollar interest payments be larger or smaller?
6-13,Continued
Solution:
Modern Tombstones
a. Short-term financing
Month
Rate
On Monthly Basis
Amount
Actual Interest
January
9%
.75%
$20,000
$150.00
February
8%
.67%
$ 6,000
$ 40.20
March
12%
1.00%
$ 8,000
$ 80.00
April
15%
1.25%
$10,000
$125.00
May
12%
1.00%
$22,000
$220.00
June
9%
.75%
$12,000
$ 90.00
$705.20
b. Long-term financing
Month
Rate
On Monthly Basis
Amount
Actual Interest
January
12%
1%
$20,000
$200.00
February
12%
1%
$ 6,000
$ 60.00
March
12%
1%
$ 8,000
$ 80.00
April
12%
1%
$10,000
$100.00
May
12%
1%
$22,000
$220.00
June
12%
1%
$12,000
$120.00
$780.00
Total dollar interest payments would be larger under the long-term financing plan.
6-14.
In problem 13,what long-term interest rate would represent a break-even point between using short-term financing as described in part a and long-term financing? Hint,Divide the interest payments in 9a by the amount of total funds provided for the six months and multiply by 12.
Solution:
Divide the total interest payments in part (a) of $705.20 by the total amount of funds extended $78,000 ($20,000 + 6,000 + 8,000 + 10,000 + 22,000 + 12,000) and multiply by 12.
12 x,904% = 10.848% annual rate
6-15.
Sherwin Paperboard Company expects to sell 600 units in January,700 units in February,and 1,200 units in March,January's beginning inventory is 800 units,Expected sales for the whole year are 12,000 units,Sherwin has decided on a level monthly production schedule of 1,000 units (12,000 units/12 months = 1,000 units per month),What is the expected end-of-month inventory for January,February,and March? Show the beginning inventory,production,and sales for each month to arrive at ending inventory.
Beginning inventory + Production (level) – Sales = Ending inventory
Solution:
Sherwin Paperboard Company
Beginning Production Ending
Inventory + (level) – Sales = Inventory
January
800
1,000
600
1,200
February
1,200
1,000
700
1,500
March
1,500
1,000
1,200
1,300
6-16.
Sharpe Computer Graphics Corporation has forecasted the following monthly sales:
January $80,000
July $ 30,000
February 70,000
August 31,000
March 10,000
September 40,000
April 10,000
October 70,000
May 15,000
November 90,000
June 20,000
December 110,000
Total annual sales = $576,000
The firm sells its graphic forms for $5 per unit,and the cost to produce the forms is $2 per unit,A level production policy is followed,Each month's production is equal to annual sales (in units) divided by 12.
Of each month's sales,30 percent are for cash and 70 percent are on account,All accounts receivable are collected in the month after the sale is made.
a. Construct a monthly production and inventory schedule in units,Beginning inventory in January is 15,000 units,(Note,To do part a,you should work in terms of units of production and units of sales.)
b. Prepare a monthly schedule of cash receipts,Sales in the month of December before the planning year are $90,000,Work part b using dollars.
c. Determine a cash payments schedule for January through December,The production costs of $2 per unit are paid for in the month in which they occur,Other cash payments,besides those for production costs,are $30,000 per month.
d. Prepare a monthly cash budget for January through December,The beginning cash balance is $5,000 and that is also the minimum desired.
6-16,Continued
Solution:
Sharpe Computer Graphics Corporation
Production and inventory schedule in units
Beginning
Inventory
+Production1
–Sales2
= Ending Inventory
January
15,000
9,600
16,000
8,600
February
8,600
9,600
14,000
4,200
March
4,200
9,600
2,000
11,800
April
11,800
9,600
2,000
19,400
May
19,400
9,600
3,000
26,000
June
26,000
9,600
4,000
31,600
July
31,600
9,600
6,000
35,200
August
35,200
9,600
6,200
38,600
September
38,600
9,600
8,000
40,200
October
40,200
9,600
14,000
35,800
November
35,800
9,600
18,000
27,400
December
27,400
9,600
22,000
15,000
1 Total annual sales = $576,000
$576,000/$5 per unit = 115,200 units
115,200 units/12 months = 9,600 per month
2 Monthly dollar sales/$5 price = unit sales
6-16,Continued
b.
Cash Receipts Schedule
Jan.
Feb.
Mar.
Apr.
May
June
Sales (in dollars)
$80,000
$70,000
$10,000
$10,000
$15,000
$20,000
30% Cash sales
24,000
21,000
3,000
3,000
4,500
6,000
70% Prior month's sales
63,000*
56,000
49,000
7,000
7,000
10,500
Total cash receipts
$87,000
$77,000
$52,000
$10,000
$11,500
$16,500
*based on December sales of $90,000
July
Aug.
Sept.
Oct.
Nov.
Dec.
Sales (in dollars)
$30,000
$31,000
$40,000
$70,000
$90,000
$110,000
30% Cash sales
9,000
9,300
12,000
21,000
27,000
33,000
70% Prior month's sales
14,000
21,000
21,700
28,000
49,000
63,000
Total cash receipts
$23,000
$30,300
$33,700
$49,000
$76,000
$ 96,000
Copyright? 2005 by The McGraw-Hill Companies,Inc.
6-16,Continued
c.
Cash Payments Schedule
Constant production
Jan.
Feb.
Mar.
Apr.
May
June
9,600 units x $2
$19,200
$19,200
$19,200
$19,200
$19,200
$19,200
Other cash payments
30,000
30,000
30,000
30,000
30,000
30,000
Total cash payments
$49,200
$49,200
$49,200
$49,200
$49,200
$49,200
July
Aug.
Sept.
Oct.
Nov.
Dec.
9,600 units x $2
$19,200
$19,200
$19,200
$19,200
$19,200
$19,200
Other cash payments
30,000
30,000
30,000
30,000
30,000
30,000
Total cash payments
$49,200
$49,200
$49,200
$49,200
$49,200
$49,200
Copyright? 2005 by The McGraw-Hill Companies,Inc.
6-16,Continued
d.
Cash Budget
Jan.
Feb.
Mar.
Apr.
May
June
Net cash flow
$37,800
$27,800
$ 2,800
($39,200)
($37,700)
($32,700)
Beginning cash
5,000
42,800
70,600
73,400
34,200
5,000
Cumulative cash balance
42,800
70,600
73,400
34,200
(3,500)
(27,700)
Monthly loan or (repayment)
-0-
-0-
-0-
-0-
8,500
32,700
Cumulative loan
-0-
-0-
-0-
-0-
8,500
41,200
Ending cash balance
42,800
70,600
73,400
34,200
5,000
5,000
July
Aug.
Sept.
Oct.
Nov.
Dec.
Net cash flow
($26,200)
($18,900)
($15,500)
($200)
$26,800
$46,800
Beginning cash
5,000
5,000
5,000
5,000
5,000
5,000
Cumulative cash balance
(21,200)
(13,900)
(10,500)
4,800
31,800
51,800
Monthly loan or (repayment)
26,200
18,900
15,500
200
(26,800)
(46,800)
Cumulative loan
67,400
86,300
101,800
102,000
75,200
28,400
Ending cash balance
5,000
5,000
5,000
5,000
5,000
5,000
Copyright? 2005 by The McGraw-Hill Companies,Inc.
6-17.
Seasonal Products Corporation expects the following monthly sales:
January $20,000
May $ 1,000
September $20,000
February 15,000
June 3,000
October 25,000
March 5,000
July 10,000
November 30,000
April 3,000
August 14,000
December 22,000
Total sales = $168,000
Sales are 20 percent for cash in a given month,with the remainder going into accounts receivable,All 80 percent of the credit sales are collected in the month following the sale,Seasonal Products uses level production,and average monthly production is equal to annual production divided by 12.
a. Generate a monthly production and inventory schedule in units,Beginning inventory in January is 5,000 units,(Note,To do part a,you should work in terms of units of production and units of sales.)
b. Determine a cash receipts schedule for January through December,Assume that dollar sales in the prior December were $15,000,Work part b using dollars.
c. Determine a cash payments schedule for January through December,The production costs ($1 per unit produced) are paid for in the month in which they occur,Other cash payments,besides those for production costs,are $6,000 per month.
d. Construct a cash budget for January through December,The beginning cash balance is $1,000,and that is also the required minimum.
e. Determine total current assets for each month,(Note,Accounts receivable equal sales minus 20 percent of sales for a given month.)
6-17,Continued
Solution:
Seasonal Products Corporation
a. Production and inventory schedule in units
Beginning
Inventory
+Production1
(level)
–Sales2
= Ending Inventory
($1 per unit)
January
5,000
7,000
10,000
2,000
February
2,000
7,000
7,500
1,500
March
1,500
7,000
2,500
6,000
April
6,000
7,000
1,500
11,500
May
11,500
7,000
500
18,000
June
18,000
7,000
1,500
23,500
July
23,500
7,000
5,000
25,500
August
25,500
7,000
7,000
25,500
September
25,500
7,000
10,000
22,500
October
22,500
7,000
12,500
17,000
November
17,000
7,000
15,000
9,000
December
9,000
7,000
11,000
5,000
1 $168,000 sales/$2 price = 84,000 units
84,000 units/12 months = 7,000 units per month
2 Monthly dollar sales/$2 = number of units
6-17,Continued
b.
Cash Receipts Schedule (take dollar values from problem statement)
Jan.
Feb.
Mar.
Apr.
May
June
Sales
$20,000
$15,000
$ 5,000
$3,000
$1,000
$3,000
20% Cash sales
4,000
3,000
1,000
600
200
600
80% Prior month's sales
12,000*
16,000
12,000
4,000
2,400
800
Total receipts
$16,000
$19,000
$13,000
$4,600
$2,600
$1,400
*based on December sales of $15,000
July
Aug.
Sept.
Oct.
Nov.
Dec.
Sales
$10,000
$14,000
$20,000
$25,000
$30,000
$22,000
20% Cash sales
2,000
2,800
4,000
5,000
6,000
4,400
80% Prior month's sales
2,400
8,000
11,200
16,000
20,000
24,000
Total receipts
$ 4,400
$10,800
$15,200
$21,000
$26,000
$28,400
Copyright? 2005 by The McGraw-Hill Companies,Inc.
6-17,Continued
c.
Cash Payments Schedule
Constant production
Jan.
Feb.
Mar.
Apr.
May
June
7,000 units x $1
$ 7,000
$ 7,000
$ 7,000
$ 7,000
$ 7,000
$ 7,000
Other cash payments
6,000
6,000
6,000
6,000
6,000
6,000
Total payments
$13,000
$13,000
$13,000
$13,000
$13,000
$13,000
July
Aug.
Sept.
Oct.
Nov.
Dec.
7,000 units x $1
$ 7,000
$ 7,000
$ 7,000
$ 7,000
$ 7,000
$ 7,000
Other cash payments
6,000
6,000
6,000
6,000
6,000
6,000
Total cash payments
$13,000
$13,000
$13,000
$13,000
$13,000
$13,000
Copyright? 2005 by The McGraw-Hill Companies,Inc.
6-17,Continued
d.
Cash Budget
Jan.
Feb.
Mar.
Apr.
May
June
Cash flow
$3,000
$ 6,000
-0-
($ 8,400)
($10,400)
($11,600)
Beginning cash
1,000
4,000
10,000
10,000
1,600
1,000
Cumulative cash balance
4,000
10,000
10,000
1,600
(8,800)
(10,600)
Monthly loan or (repayment)
-0-
-0-
-0-
-0-
9,800
11,600
Cumulative loan
-0-
-0-
-0-
-0-
9,800
21,400
Ending cash balance
$4,000
$10,000
$10,000
$ 1,600
$ 1,000
$ 1,000
July
Aug.
Sept.
Oct.
Nov.
Dec.
Cash flow
($ 8,600)
($2,200)
$ 2,200
$ 8,000
$13,000
$15,400
Beginning cash
1,000
1,000
1,000
1,000
1,000
1,000
Cumulative cash balance
(7,600)
(1,200)
3,200
9,000
14,000
16,400
Monthly loan or (repayment)
8,600
2,200
(2,200)
(8,000)
(13,000)
(9,000)
Cumulative loan
30,000
32,200
30,000
22,000
9,000
-0-
Ending cash balance
$ 1,000
$ 1,000
$ 1,000
$ 1,000
$ 1,000
$ 7,400
Copyright? 2005 by The McGraw-Hill Companies,Inc.
6-17,Continued
e. Assets
Cash
Accounts Receivable
Inventory
Total Current
January
$ 4,000
$16,000
$ 2,000
$22,000
February
10,000
12,000
1,500
23,500
March
10,000
4,000
6,000
20,000
April
1,600
2,400
11,500
15,500
May
1,000
800
18,000
19,800
June
1,000
2,400
23,500
26,900
July
1,000
8,000
25,500
34,500
August
1,000
11,200
25,500
37,700
September
1,000
16,000
22,500
39,500
October
1,000
20,000
17,000
38,000
November
1,000
24,000
9,000
34,000
December
7,400
17,600
5,000
30,000
The instructor may wish to relate this table to the case budget to show how the buildup in current assets is financed,Also,the table shows how the assets build up from the least liquid current asset (inventory) to the next liquid asset (accounts receivables),and finally by December,the cycle is ready to start over with the flow into the cash balance when the firm eliminates its final loan balance.
