Butler Lumber Case Study Analysis Essay

Subject Butler ram CompanyProblem Whether Mr. Mark Butler should go ahead with financing from Northrop topic aver or should stay with Suburban national Bank.Options 1) Enter into a impart agreement with Northrop National Bank for USD 465,000 (Assumption The condition to sever the birth with Suburban National Bank applies to Short Term Loan only) 2) Continue unequal frontier lending relationship with Suburban National Bank for USD 250,000 and secure the smart sets give with real propertyRecommendation Given oper up to(p) data, Butler Lumber company should enter into a bring agreement with Northrop National Bank for USD 465,000 psychoanalysisOur recommendation to Mr. Mark Butler to enter into agreement with Northrop Bank for line credit of USD 465,000 is based on the following factorsExternal Financing NeedWe assessed the companys external financing need in 1991 based on the following scenariosa)The current quarter net sales of 1991 attributes 26% of annual sales of compan y in 1991, since first quarter sales of 1990 contributed 26% of total 1990 net sales and wherefore the total net sales projected for 1991 is USD 2.77 Mn. Balance Sheet and Income statement have been projected at serving of sales (Please refer to exhibit no. 1). In this scenario, we assume company doesnt 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 patoiss investigator in the case study infra(a) both the above scenarios, company would need more financing than its current lingo credit facility of USD 250,000.Under scenario (a), if the company decides non to take discounts, then it would need scam term credit facility of USD 211,000 to meet its short term uppercase requirements, however companys accounts payables would increase to USD 263,000 and its net profit allow for be USD 49,000. and so as far companys financing need is concerned it can continue its sh ort term relationship with the brisk bank. On the other hand, if the company decides to take discounts, then it would need short term lend 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, companys 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 live loan will be far from fulfilling clients 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 come down its days receivables period.Increase in ProfitabilityOption 1If the company resides with the wide awake bank loan, the total post 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 2If the company re holdings 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 over collectable 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 loanDecreasing Flexibility in Managerial DecisionsThe 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 Butlers future managerial decisions, including investments in fixed assets and limited withdrawals of funds. Because of Butlers conservative in operation(p) so far, he should be able to deal with these restrictions. Furthermore, Butler Lumbers increased sales are shielded from the general economic downturn to some degree collect to the relatively large proportion of its repair business. This will facilitate the maintenance of the net working capital correct 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 firms future. As the firm is affected by liquidity problems, the covenants on net workingcapital 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. change magnitude Flexibility in Financial OpportunitiesBecause companys 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 corset with the old bank we can observe a constant value, from 1990 to 1991, for net w orking 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 judgment of conviction 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 motorbike 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 firms liquidity. The D/E decrea ses from 1,68 to 1,62 and the interest coverage presents an acceptable value as well. inappropriate 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.AppendicesExhibit 1 projected income statement and balance sheetProjected income statement19901991USD in millions, FYE 31-DecActual% of Sales Scenario a-1Scenario a-2Scenario b Net sales12,694100.00% 2,7712,7713,600COGSBeginning Inventory326418418418Purchases2,0422,0182,0182,7462,3682,4362,4363,164Ending Inventory241815.52%430430559Total COGS21,95072.38%2,0062,0062,606GROSS PROFIT744 765765994Operating expenses365820.90%667667840Interest expenses433N.A405151Discounts 2742NET INCOME in the first place TAXES53 5874145Provision for income taxes59101437NET INCOME44 4961107Projected balance sheet19901991USD in millions, FYE 31-DecActual% of Sales Scenario a-1Scenario a-2Scenario b Cash2411.52%424255Account receivable, net231711.77%326326424Inventory418430430559 modern ASSETS776 7987981037Property, net21575.83%161161210TOTAL ASSETS933 9609601247Notes payable (bank)6233N.A247407465Notes payable (Mr. Stark)0N.A000Notes payable, trade0N.A000Accounts payable22569.50%2635575Accrued expenses39N.A393939L-t debt, current portion77N.A777CURRENT LIABILITIES535 556508586L-t debt750N.A434343TOTAL LIABILITIES585 599551629Net worth348N.A348348348Retained earnings84961107 naked as a jaybird Net Worth397409455TOTAL LIABILITIES & NET WORTH933 9969601084PLUG EFN -360162Scenarios-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 BankNotes1 Q1 1991 sales are $718m. Q1 1990 sales were 25.91% of FY 1990 sale s. We assume this ratio to be constant in scenario a. In scenario b, we hope of Northrop National banks assumption of $3,600m sales in 1991.2 Assumed to be percentage of sales.3 Operating expenses includes Mr. Butlers 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.