sample
Haven't found the Essay You Want?
GET YOUR CUSTOM ESSAY SAMPLE
For Only $12.90/page

Butler Lumber Case Study Analysis Essay

Subject: Butler Lumber Company

Problem: Whether Mr. Mark Butler should go ahead with financing from Northrop National Bank or should stay with Suburban National Bank.

Options: 1) Enter into a loan agreement with Northrop National Bank for USD 465,000 (Assumption: The condition to sever the relationship with Suburban National Bank applies to Short Term Loan only) 2) Continue short term lending relationship with Suburban National Bank for USD 250,000 and secure the company’s loan with real property

Recommendation: Given available data, Butler Lumber company should enter into a loan agreement with Northrop National Bank for USD 465,000

Analysis:

Our recommendation to Mr. Mark Butler to enter into agreement with Northrop Bank for line credit of USD 465,000 is based on the following factors:

External Financing Need

We assessed the company’s external financing need in 1991 based on the following scenarios:

a)The current quarter net sales of 1991 attributes 26% of annual sales of company in 1991, since first quarter sales of 1990 contributed 26% of total 1990 net sales and hence the total net sales projected for 1991 is USD 2.77 Mn. Balance Sheet and Income statement have been projected at percentage of sales (Please refer to exhibit no. 1). In this scenario, we assume company doesn’t opt to take discounts on its purchases b)Net Sales of USD 2.77Mn, company opts to take discounts on its purchases c)Net sales in 1991 of USD 3.6Mn as indicated by bank’s investigator in the case study

Under both the above scenarios, company would need more financing than its current bank credit facility of USD 250,000.

Under scenario (a), if the company decides not to take discounts, then it would need short term credit facility of USD 211,000 to meet its short term capital requirements, however company’s accounts payables would increase to USD 263,000 and its net profit will be USD 49,000. Hence as far company’s financing need is concerned it can continue its short term relationship with the existing bank. On the other hand, if the company decides to take discounts, then it would need short term loan of USD 407,000 to meets its working capital requirements and hence would have to go into agreement with the new bank. Under this scenario, company’s accounts payables would amount to USD 55,000 and net profit would be USD 61,000.

Under scenario no (b), Butler Lumber total assets are projected to outpace total liabilities (excluding short term loan) by USD 628, 000, hence the existing loan will be far from fulfilling client’s working capital needs and the loan from Northrop Bank will be able to bridge USD 465,000 of the gap, however company would still be needing USD 162,000 under current mode of operation. We recommend that apart from getting new line of credit from Northrop Bank, company should reduce its days receivables period.

Increase in Profitability

Option 1:
If the company remains with the existing bank loan, the total interest expenses are projected to increase by USD 7,000 in 1991 and resulting into after-tax net profit USD 49,000 with loan from existing bank. The effective rate of interest expense is 13.2% with existing loan. (Please refer to exhibit _____)

Compared to 1990, ROA will remain the same at 5% and ROE will remain at 13%.

Option 2:
If the company replaces its short term line of credit from its existing bank to new bank, the total interest expenses are projected to increase by USD 11,000 in 1991, however company will be able to earn discounts of USD 27,000, resulting into after-tax net profit of USD 61,000 with new loan as compared to after-tax net profit of USD 49,000 with loan from existing bank. The effective rate of interest expense with new loan, after taking effect of discount income, is 5.0% compared to 13.2% with existing loan. (Please refer to exhibit _____)

Compared to 1990, ROA will increase to 6% while ROE will increase to 17%. These profitability ratios indicate a better result by taking up the new loan than staying with the old bank. By Dupont analysis (Please see exhibit___), the main drivers for the higher ROE for new loan is due to higher profit margin which offset the lower equity multiplier. The effect of the discount income has driven the profitability, which in turn reflected also in the ROE and ROA ratios.

Changes in Flexibility with the new loan

Decreasing Flexibility in Managerial Decisions:

The company becomes less flexible in its managerial decisions by taking up the new loan. It would be bounded by the negative covenants imposed by the new bank. These negative covenants place clear restrictions to Butler’s future managerial decisions, including investments in fixed assets and limited withdrawals of funds. Because of Butler’s conservative operating so far, he should be able to deal with these restrictions. Furthermore, Butler Lumber’s increased sales are shielded from the general economic downturn to some degree due to the relatively large proportion of its repair business. This will facilitate the maintenance of the net working capital even in a general economic downturn stage.

As additional part of the covenants the bank placed importance on the net working capital. This could have positive impact to the firm’s future. As the firm is affected by liquidity problems, the covenants on net working capital will make Butler to be more mindful about firm liquidity in midst of sales expansion. Thus, it could reduce the chance of Butler ending back with a situation of liquidity issues.

Increasing Flexibility in Financial Opportunities:

Because company’s business is seasonal, the financial opportunities by the new loan offer scope to balance seasonal variations. Another point is the now possible use of discounts provided by suppliers (see Increase in Profitability section).

Ratios (please refer to exhibit ___)
Option 1: If Butler Lumber stays with the old bank we can observe a constant value, from 1990 to 1991, for net working capital, current and quick ratio. At first glance, seems that the firm is able to cover current liabilities with current assets, but, without the inventory (which takes more time to convert into cash), the situation is completely different. The D/E increases from 1,68 to 1,72, while the interest coverage presents a value, that, even if lower, is acceptable. With regard to the profitability, the ROA and the ROE remain constant. The cash cycle increases from 64 to 72: this is due to an increase to both inventory and receivables period, even if we can observe an increase in the payable as well.

Option 2: Taking the new loan lead to an increase in net working capital, mainly due to the reduction of current liabilities (in fact, despite the increase in notes payable, there is a drastic reduction in accounts payable, in order to get the discount). In this scenario both current and quick ratio improve, indicating an improvement in firm’s liquidity. The D/E decreases from 1,68 to 1,62 and the interest coverage presents an acceptable value as well. Unlike scenario (a), profitability improves in a consistent way: ROA increases to 6% and ROE increases to 16%. The cash cycle rises significantly due to the combined effect of increase in inventory and receivables period and decrease in payable.

Appendices

Exhibit 1: projected income statement and balance sheet

Projected income statement
19901991
USD in millions, FYE 31-DecActual% of Sales Scenario a-1Scenario a-2Scenario b Net sales12,694100.00% 2,7712,7713,600
COGS
Beginning Inventory326418418418
Purchases2,0422,0182,0182,746
2,3682,4362,4363,164
Ending Inventory241815.52%430430559
Total COGS21,95072.38%2,0062,0062,606
GROSS PROFIT744 765765994
Operating expenses365820.90%667667840
Interest expenses433N.A405151
Discounts 2742
NET INCOME BEFORE TAXES53 5874145
Provision for income taxes59101437
NET INCOME44 4961107

Projected balance sheet
19901991
USD in millions, FYE 31-DecActual% of Sales Scenario a-1Scenario a-2Scenario b Cash2411.52%424255
Account receivable, net231711.77%326326424
Inventory418430430559
CURRENT ASSETS776 7987981037
Property, net21575.83%161161210
TOTAL ASSETS933 9609601247

Notes payable (bank)6233N.A247407465
Notes payable (Mr. Stark)0N.A000
Notes payable, trade0N.A000
Accounts payable22569.50%2635575
Accrued expenses39N.A393939
L-t debt, current portion77N.A777
CURRENT LIABILITIES535 556508586
L-t debt750N.A434343
TOTAL LIABILITIES585 599551629
Net worth348N.A348348348
Retained earnings84961107
New Net Worth397409455
TOTAL LIABILITIES & NET WORTH933 9969601084

PLUG EFN -360162

Scenarios:
-a-1 refers to projected sales of $2,771m in 1991 and a continuing relationship with Suburban National Bank -a-2 refers to projected sales of $2,771m in 1991 and a new relationship with Northrop National Bank -b refers to projected sales of $3,600m in 1991 and a new relationship with Northrop National Bank

Notes:
1 Q1 1991 sales are $718m. Q1 1990 sales were 25.91% of FY 1990 sales. We assume this ratio to be constant in scenario a. In scenario b, we rely of Northrop National bank’s assumption of $3,600m sales in 1991.

2 Assumed to be percentage of sales.

3 Operating expenses includes Mr. Butler’s salary. Operating expenses are projected by decreasing operating expenses of 1990 by $95K (salary) and applying percentage of sales to the operating expenses without salary, then adding back $88K (annualised Q1 1991 salary) to get the operating expenses of 1991.

4 : As a corporation, Butler is taxed @15% on its first $50,000 sales, @25% on the next $25,000, and @34% on all additional income above $75,000.


Essay Topics:


Sorry, but copying text is forbidden on this website. If you need this or any other sample, we can send it to you via email. Please, specify your valid email address

We can't stand spam as much as you do No, thanks. I prefer suffering on my own