Question

In: Finance

HBM, Inc. had sales of $9 million and a net profit margin of 10 percent in...

HBM, Inc. had sales of $9 million and a net profit margin of 10 percent in 20X0. Management expects sales to grow to $10.8 million and $12.6 million in 20X1 and 20X2, respectively. Management wants to know if additional funds will be necessary to finance this anticipated growth. Currently, the firm is not operating at full capacity and should be able to sustain a 25 percent increase in sales. However, further increases in sales will require $3 million in plant and equipment for every $5 million increase in sales. (Note that even if sales increase by less than $5 million, the total amount of $3 million investment in plant and equipment is still required.) The firm's balance sheet is as follows:

HBM, Incorporated Balance Sheet as of 12/31/X0
Assets Liabilities and Equity
Cash $ 1,170,000 Accruals $ 1,800,000
Accounts receivable 2,520,000 Accounts payable 450,000
Inventory 900,000 Notes payable 340,000
Plant and equipment 1,500,000 Long-term debt 1,500,000
Equity 2,000,000
$ 6,090,000 $ 6,090,000

Management has followed a policy of distributing at least 70 percent of earnings as dividends. Management believes that the percent of sales method of forecasting is sufficient to answer the question, "Will outside funding be necessary?" To use this technique, management has assumed that accounts receivable, inventory, accruals, and accounts payable will vary with the level of sales. Cash will not change.

  1. Prepare projected balance sheets for 20X1 and 20X2 that incorporate any necessary outside financing. Any short-term funds that are required should be obtained through a loan from the bank, and any excess short-term funds should be appropriately invested. Any long-term financing that is needed should be obtained through long-term debt. Round your answers to the nearest dollar.

    HBM, Incorporated Balance Sheet as of 12/31/X1
    Assets Liabilities and Equity
    Cash $    Accruals $
    Marketable securities    Accounts payable   
    Accounts receivable    Notes payable   
    Inventory    Long-term debt   
    Plant and equipment    Equity   
    $    $   
    HBM, Incorporated Balance Sheet as of 12/31/X2
    Assets Liabilities and Equity
    Cash $    Accruals $
    Marketable securities    Accounts payable   
    Accounts receivable    Notes payable   
    Inventory    Long-term debt   
    Plant and equipment    Equity   
    $    $   
  2. If the firm did not distribute 70 percent of its earnings, could it sustain the expansion without issuing additional long-term debt? Round your answer to the nearest dollar.

    If the firm did not distribute 70 percent of its earnings, the maximum possible retained earnings would be $_____. A change in the dividend policy -Select- would or would not cover the expansion in plant and equipment.

  3. If the firm's creditors in part a require a current ratio of 3:1, would that affect the firm's financing in 20X1 and 20X2? If so, what additional actions could the firm take? Round your answers to two decimal places.

    According to the forecast in part a, the current ratios in 20X1 and 20X2 are ___ :1 and ____ :1, respectively. If the firm's creditors require a current ratio of 3:1, the firm -Select- will or will not meet the current ratio requirement and -Select- should or should not take additional actions to low current ratio.

  4. If the percent of sales forecasts are replaced with the following regression equations:

    Accounts receivable = $100,000 + 0.12 Sales,
    Inventory = $250,000 + 0.20 Sales,
    Accruals = $150,000 + 0.07 Sales,
    Accounts payable = $250,000 + 0.11 Sales,

    what is the firm's need for outside funding (if any) in 20X1 and 20X2? Round your answers to the nearest dollar. Enter your answers as positive values.

    In 20X1 the firm -Select- will need external or will have excess funds of $____ .
    In 20X2 the firm -Select- will need external or will have excess funds of $ ____

  5. If the firm's creditors in part d required a current ratio of 3:1, would that affect the firm's financing in 20X1 and 20X2? If so, what additional actions could the firm take? Round your answers to the nearest dollar.

    If the firm's creditors in part d required a current ratio of 3:1, the maximum amount of current liabilities in 20X1 is $ ____ . The forecast indicates that the firm -Select-would or would not meet the current ratio requirement.

    If the firm's creditors in part d required a current ratio of 3:1, the maximum amount of current liabilities in 20X2 is $ ____ . The forecast indicates that the firm -Select-would or would not meet the current ratio requirement.

Solutions

Expert Solution



Related Solutions

Kaleb’s Karate Supply had a profit margin of 11 percent, sales of $21.4 million, and total...
Kaleb’s Karate Supply had a profit margin of 11 percent, sales of $21.4 million, and total assets of $9.4 million. What was the total asset turnover? If management set a goal of increasing total asset turnover to 2.75 times, what would the new sales figure need to be, assuming no increase in total assets?
Coconut, Inc. has sales of $610,400, total equity of $170,000, a profit margin of 10 percent...
Coconut, Inc. has sales of $610,400, total equity of $170,000, a profit margin of 10 percent and a debt-equity ratio of 0.8. What is the return on assets? 23.70 percent 21.34 percent 19.95 percent 25.50 percent 4 points    QUESTION 22 Blueberry, Inc. has total assets of $642,000. There are 60,000 shares of stock outstanding with a market value of $42 a share. The firm has a profit margin of 7 percent and a total asset turnover of 1.36. What...
Company V earned a net profit margin of 25% on sales of $25 million in its...
Company V earned a net profit margin of 25% on sales of $25 million in its most recently ended fiscal year. Capital investment was $2.5 million and depreciation was $3 million. Investment in working capital is 10% of sales every year. Assume the following: Sales, net income, cap ex, depreciation and interest expense are expected to grow 10% every year for the next five years After five years sales, net income, cap ex, depreciation and interest expense will decline to...
Honey Ltd had a total net profit of $9 million this year and 5 million common...
Honey Ltd had a total net profit of $9 million this year and 5 million common shares outstanding. It’s ordinary share is currently trading at $33. Honey Ltd has recently declared an 10% share bonus. a. Show the impact of this share bonus on the outstanding shares and current market share price. b. If instead of a share bonus, the management announces a 7 to 5 share spit. Demonstrate the impact of share split on the outstanding shares and current...
Nerk pharm. net profit margin was 10% on sales of $2,000,000. Debt to assets was 40%...
Nerk pharm. net profit margin was 10% on sales of $2,000,000. Debt to assets was 40% with total liabilities of $500,000. How much was the Return on Assets?
(Efficiency analysis) The Brenmar Sales Company had a gross profit margin​ (gross profits÷​sales) of 34 percent...
(Efficiency analysis) The Brenmar Sales Company had a gross profit margin​ (gross profits÷​sales) of 34 percent and sales of $9.3 million last year. 76 percent of the​ firm's sales are on​ credit, and the remainder are cash sales. ​ Brenmar's current assets equal $1.7 million, its current liabilities equal $299,200​, and it has $102,800 in cash plus marketable securities. a. If​ Brenmar's accounts receivable equal $562,300​, what is its average collection​ period? b. If Brenmar reduces its average collection period...
The Brenmar Sales Company had a gross profit margin (gross profit/sales) of 28% and sales of...
The Brenmar Sales Company had a gross profit margin (gross profit/sales) of 28% and sales of $8.6 million last year. 70% of the firm’s sales are in credit, and the remainder are cash sales. Brenmar’s current assets equal $1.4 million, its current liabilities equal $299,000, and it has $106,000 in cash plus marketable securities. A. If Brenmar’s accounts receivable equal $562,600, what is its average collection period? B. If Brenmar reduces its average collection period is 25 days, what will...
A firm has Net income- $195,000 Profit Margin- 10.0% Accounts Receivable- $100,000 Percent of Sales On...
A firm has Net income- $195,000 Profit Margin- 10.0% Accounts Receivable- $100,000 Percent of Sales On Credit- 85% Fill out the rest of the information below, show all work and calculations Sales-? Credit Sales-? Receivables Turnover- ? Times Days sales in Receivables- ? Days
Elsee, Inc., has net sales of $16 million, and 75 percent of these are credit sales....
Elsee, Inc., has net sales of $16 million, and 75 percent of these are credit sales. Its cost of goods sold is 65 percent of annual net sales. The firm’s cash conversion cycle is 58.0 days. The inventory balance at the firm is $1,842,000, while its accounts payable balance is $2,387,000. What is the firm’s accounts receivable balance? (Round intermediate calculations to 1 decimal places, e.g. 15.1. and final answer to nearest whole dollar, e.g. 5,275.) The firm’s accounts receivables...
Elsee, Inc., has net sales of $15 million, and 75 percent of these are credit sales....
Elsee, Inc., has net sales of $15 million, and 75 percent of these are credit sales. Its cost of goods sold is 65 percent of annual net sales. The firm’s cash conversion cycle is 56.0 days. The inventory balance at the firm is $1,591,000, while its accounts payable balance is $2,068,000. What is the firm’s accounts receivable balance? (Round intermediate calculations to 1 decimal places, e.g. 15.1. and final answer to nearest whole dollar, e.g. 5,275.)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT