Question

In: Finance

​(Financial forecasting—percent of sales​) Next​ year's sales for Cumberland Mfg. are expected to be ​$21.60 million....

​(Financial

forecasting—percent

of

sales​)

Next​ year's sales for Cumberland Mfg. are expected to be

​$21.60

million. Current sales are

​$18

​million, based on current assets of

​$6.00

million and fixed assets of

​$9.00

million. The​ firm's net profit margin is

5

percent after taxes. Cumberland estimates that its current assets will rise in direct proportion to the increase in​ sales, but that its fixed assets will increase by only​ $200,000. Currently, Cumberland has

​$1.50

million in accounts payable​ (which vary directly with​ sales),

​$2

million in​ long-term debt​ (due in 10​ years), and common equity​ (including

​$3

million in retained​ earnings) totaling

​$11.50

million. Cumberland plans to pay

​$0.22

million in common stock dividends next year.

a. What are​ Cumberland's total financing needs​ (that is, total​ assets) for the coming​ year?

b. Given the​ firm's projections and dividend payment​ plans, what are its discretionary financing​ needs?

c. Based on your​ projections, and assuming that the​ $200,000 expansion in fixed assets will​ occur, what is the largest increase in sales the firm can support without having to resort to the use of discretionary sources of​ financing?

a. What are​ Cumberland's total financing needs​ (taht is, total​ assets) for the coming​ year?

million  ​(Round to two decimal​ places.)

b. Given the​ firm's projections and dividend payment​ plans, what are its discretionary financing​ needs?

million  ​(Round to two decimal​ places.)

c. Based on your​ projections, and assuming that the​ $200,000 expansion in fixed assets will​ occur, what is the largest increase in sales the firm can support without having to resort to the use of discretionary sources of​ financing?

million  ​(Round to two decimal​ places.)

Solutions

Expert Solution

a.
Sales for coming year $21,600,000
Profit after taxes $1,080,000 21600000*5%
Dividend paid $220,000
Retained balance $860,000
Calculate total financing required
Current assets $7,200,000 (6000000/18000000)*21600000
Fixed assets $9,200,000 (9000000+200000)
Total assets $16,400,000
Thus, total financing requirement or total assets for coming year is $16.40 million
Calculate discretionary financing needs as shown below:
Common equity $11,500,000
Short term payable and trade credit $1,800,000 (1.50/18)*21.6
Retained after tax earnings $860,000
Long term debt $2,000,000
Total financing available $16,160,000
Discretionary financing 16400000-16160000
Discretionary financing $240,000
Thus, discretionary financing needed is $0.24 million
Calculate maximum level of sales required where DFN is 0
DFN (6/18sales + 9.20 million) - (11.5 million + 1.5/18 sales + 0.05*Sales - 220,000 + 2,000,000)
0 (6/18sales + 9.20 million) - (13.28 million + 1.5/18 sales + 0.05*Sales)
0 (6/18sales + 9.20 million) - 13.28 million - 1.5/18 sales - 0.05*Sales
0 (4.5/18*Sales - 0.05 Sales) - 4.08 million
4.08 million 0.25Sales - 0.05 sales
4.08 million 0.20Sales
Sales 4.08 million/0.20
Sales $20.40 million
Thus, maximum sales allowed is $20.40 million

Related Solutions

​(Financial forecasting—percent of sales​) Next​ year's sales for Cumberland Mfg. are expected to be ​$16.10 million....
​(Financial forecasting—percent of sales​) Next​ year's sales for Cumberland Mfg. are expected to be ​$16.10 million. Current sales are ​$14 ​million, based on current assets of ​$4.67 million and fixed assets of ​$7.00 million. The​ firm's net profit margin is 3 percent after taxes. Cumberland estimates that its current assets will rise in direct proportion to the increase in​ sales, but that its fixed assets will increase by only​ $200,000. Currently, Cumberland has ​$1.50 million in accounts payable​ (which vary...
​(Financial forecasting—percent of sales​) Next​ year's sales for Cumberland Mfg. are expected to be ​$18.75 million....
​(Financial forecasting—percent of sales​) Next​ year's sales for Cumberland Mfg. are expected to be ​$18.75 million. Current sales are ​$15 ​million, based on current assets of ​$5.00 million and fixed assets of ​$7.50 million. The​ firm's net profit margin is 5 percent after taxes. Cumberland estimates that its current assets will rise in direct proportion to the increase in​ sales, but that its fixed assets will increase by only​ $200,000. Currently, Cumberland has ​$1.50 million in accounts payable​ (which vary...
​(Financial forecasting long dash—percent of sales​) Next​ year's sales for Cumberland Mfg. are expected to be...
​(Financial forecasting long dash—percent of sales​) Next​ year's sales for Cumberland Mfg. are expected to be ​$19.20 million. Current sales are ​$16 ​million, based on current assets of ​$5.33 million and fixed assets of ​$8.00 million. The​ firm's net profit margin is 44 percent after taxes. Cumberland estimates that its current assets will rise in direct proportion to the increase in​ sales, but that its fixed assets will increase by only​ $200,000. Currently, Cumberland has $1.50 million in accounts payable​...
(Financial forecastinglong dash—percent of sales​) Next​ year's sales for Cumberland Mfg. are expected to be ​$20.70...
(Financial forecastinglong dash—percent of sales​) Next​ year's sales for Cumberland Mfg. are expected to be ​$20.70 million. Current sales are ​$18 ​million, based on current assets of ​$6.00 million and fixed assets of ​$9.00 million. The​ firm's net profit margin is 5 percent after taxes. Cumberland estimates that its current assets will rise in direct proportion to the increase in​ sales, but that its fixed assets will increase by only​ $200,000. Currently, Cumberland has ​$1.50 million in accounts payable​ (which...
(Financial forecastinglong dash—percent of sales​) Next​ year's sales for Cumberland Mfg. are expected to be ​$22.00...
(Financial forecastinglong dash—percent of sales​) Next​ year's sales for Cumberland Mfg. are expected to be ​$22.00 million. Current sales are ​$18 ​million, based on current assets of $5.00 million and fixed assets of ​$5.00million. The​ firm's net profit margin is 5 percent after taxes. Cumberland estimates that its current assets will rise in direct proportion to the increase in​ sales, but that its fixed assets will increase by only​ $150,000. Currently, Cumberland has $2.00 million in accounts payable​ (which vary...
(Financial forecastinglong dashpercent of sales​) Next​ year's sales for Cumberland Mfg. are expected to be ​$14.95...
(Financial forecastinglong dashpercent of sales​) Next​ year's sales for Cumberland Mfg. are expected to be ​$14.95 million. Current sales are ​$13 ​million, based on current assets of ​$4.33 million and fixed assets of ​$6.50 million. The​ firm's net profit margin is 3 percent after taxes. Cumberland estimates that its current assets will rise in direct proportion to the increase in​ sales, but that its fixed assets will increase by only​ $200,000. Currently, Cumberland has ​$1.50 million in accounts payable​ (which...
​(Financial forecastinglong dashpercent of sales​) Next​ year's sales for Cumberland Mfg. are expected to be ​$15.60...
​(Financial forecastinglong dashpercent of sales​) Next​ year's sales for Cumberland Mfg. are expected to be ​$15.60 million. Current sales are ​$13 ​million, based on current assets of ​$4.33 million and fixed assets of ​$6.50 million. The​ firm's net profit margin is 5 percent after taxes. Cumberland estimates that its current assets will rise in direct proportion to the increase in​ sales, but that its fixed assets will increase by only​ $200,000. Currently, Cumberland has ​$1.50 million in accounts payable​ (which...
Financial forecasting-% of sales) Tulley Appliances Inc. projects next year's sales to be $19.6 million. Current...
Financial forecasting-% of sales) Tulley Appliances Inc. projects next year's sales to be $19.6 million. Current sales are $15.4 million, based on current assets of $5.1 million and fixed assets of $5.2 million. The firm's net profit margin is 4.9% after taxes. Tulley forecasts that its current assets will rise in direct proportion to the increase in sales, but that its fixed assets will increase by only $109,000. Currently, Tulley has $1.5 million in acct. payable (which vary directly with...
Here are next year's projections for a firm you are valuing: Sales are expected to be...
Here are next year's projections for a firm you are valuing: Sales are expected to be $100 million. Gross margin is forecasted to be 30%. COGS and SG&A are $90 million, of which depreciation is $10 million. The firm is very inefficient in collecting its bills from customers. It is expected that: Industrial customers (70% of sales) will take 100 days to pay their bills. Retail chains (30% of sales) make cash sales. The firm expects to turn over its...
Polished Marketing. is forecasting that next year’s sales of Happy-Time Vitamins will decline from $122 million...
Polished Marketing. is forecasting that next year’s sales of Happy-Time Vitamins will decline from $122 million to $106 million. Polished Marketing estimates that cash requirements will be 1% of sales, inventory will be 10% of sales, receivables will be 7% of sales, and payables will be 8% of sales. Depreciation is expected to be 8% of sales, and the tax rate is 35%. How will next year’s net working capital requirement be affected?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT