Free Essay

Butler Lumber Case

In: Business and Management

Submitted By jrevay
Words 620
Pages 3
Management Accounting

Case (1) Financial Planning: Butler Lumber Valuation

1. Although Mr Butler has seen an increase in his sales for the last few years, there are a few reasons why he needed a loan from the bank to keep his operations going.

1) Shortage of Cash: Despite good profits, Mr. Butler had experienced a shortage of cash from 1988 to 1990. During this period of time, there was a decrease in cash reserves, as well as in inventory turnover, indicating that Mr. Butler’s money had been tied up in his inventory. This can be resolved by working on his receivables turnover ratio, which decreased from 1988 to 1990, as seen in Appendix A. 2) Debt Consolidation: In late 1988, Mr. Butler took a loan of $70,000 that carried an interest rate of 11%. The annual interest payable to the bank compounded to his cash shortage problem. 3) Expansion of operational business: Additional investments in working capital and inventory purchases will be required to keep up with the company’s increasing sales volume.

2. As illustrated in Appendix B, assuming that 1991 sales volume will be $3.6 million, Butler Lumber will only need a loan of roughly $333,600.00 to finance the expected expansion in sales. The company’s estimate of the loan requirements is inaccurate.

3. In the first quarter of 1990, sales were $698,000, approximately 25.91% of the yearly revenue. Based on this ratio, we estimate that Butler Lumber Company will generate approximately yearly revenue of 2.8 million in 1991, which is 800,000 less of what the bank forecasted. With the projected yearly revenue, the company will only need a loan of $288,000 for 1991. However, Butler Lumber has good credit reports from suppliers, also, as mentioned in question 1; the company can easily improve the cash flow of the company by improving their receivables turnover ratio. Since this is a request for a revolving line of credit up to $465,000 and not the entire sum up in one instance, we will approve the company’s revolving credit line, but with the following conditions: • BLC shall fulfill its loan obligation to Suburban National bank making Northrop National Bank the primary creditor to Butler Lumber. As primary creditor Northrop Bank will have the 1st right to the Butler’s total assets in the event of loan default. • BLC shall review its credit terms with their customers to help improve their cash flow. Furthermore BLC shall maintain a healthy cash flow greater than 75,000 starting at the beginning of the 4th quarter for 1991. • BLC shall make a diligent effort to fulfill at least 25% their purchase accounts payable within 10 days of invoice to obtain the 2% discount for the 1991 year. Further after, BLC shall maintain the 25% and continue to fulfill an additional 10% each year thereafter, ie 35% in 1992, 45% in 1993 etc. The overall level of effort will be determined by the Northrop National Bank Account Manager for this credit line, and will occur on a semiannual basis in the first year; and adjusted for more or less reviews in the following years based on BLC’s performance to meet this condition. • BLC shall maintain a net working capital above 240,000 for 1991 and reevaluated for 1992 at a later date by the Northrop National Bank Account Manager for this credit line. • BLC shall request prior approval for any additional investments in fixed assets. • Limitations shall be placed on withdraws of funds from the business by Butler in excess of 10,000 per month.

APPENDIX A – RATIO CALCULATIONS BUTLER LUMBER COMPANY

[pic]

APPENDIX B – BALANCE SHEET PROJECTION (Assuming 1991 sales volume to be $3.6 million)

[pic]

Similar Documents

Premium Essay

Butler Lumber Case

...BUTLER LUMBER CASE REPORT The Butler Lumber company is facing cash difficulties due to the buyout of Henry Stark’s share and because it is operating a high growth rate. Thus, it is imperative to analyze the various options available to Mark Butler in order to meet the cash needs of the Butler Lumber Company. In order to support the reasoning for our recommendation, we constructed a ratio analysis (Appendix I; Exhibit 1). Even though the firm has realized increasing sales and decreased its operating and cash cycle, other factors were found to have contributed to the shortage of funds. From the analysis, we were able to conclude that the main reasons for the firm’s insufficient funds were due to its slower collection of accounts receivable, higher costs of goods sold, heavy reliance on debt financing and most importantly a growth rate that is not sustainable. From Exhibit 1 in the Appendix, the current and quick ratios have been declining since 1988; furthermore, the quick ratio is less than 1, which indicates that the firm is deeply reliant on its inventory to meet the payments of its current liabilities. This is a problem since more inventory means more cash tied up in less liquid assets, which decreases the firm’s cash.            Secondly, when analyzing the firm’s profitability, ROA increased by 3% from 1989 to 1990, but this was mainly due to the increase in total asset turnover which increased from 3.03 to 3.23 (Exhibit 1).  Another component of ROA, net...

Words: 964 - Pages: 4

Premium Essay

Butler Lumber Case Study

...Problems, Options and Recommendations The problem that we have recognized in this case is that Butler Lumber Company does not have enough funds to finance its operations in the future. The company has experienced a shortage in cash and needs to issue debt as it moves forward. The company is also under pressure because of the payment to be made to Mr. Stark for the buyout of his share in the company of $105,000. Although, the majority of this payment has been made, Butler still owes Stark another $35,000 that he intends to finance through another loan. The firm has already been using up its cash reserves to pay back its liabilities, which is not a good sign since cash should be used for investment purposes. As we can see from Exhibit 4 (Cash flow from operations), cash balances have been depleting year by year with a total decrease of $17000 over the years 1988-1990. Butler Lumber has two options to support the company’s operations. The first presents itself in the form of a loan from the Suburban National Bank of $250000, who have asked them to secure the loan with real property, which shows that the company’s risk profile has increased as this bank never asked for any security while making loans in the past. But the problem with this scenario is that the company will need a bigger loan to finance its operations, which the Suburban National Bank will not provide beyond $250000. Therefore another option that the company can consider is to accept Northrop National Banks offer of...

Words: 3457 - Pages: 14

Premium Essay

Butler Lumber Case Analysis

...Butler Lumber Case Analysis Question 1 Butler Lumber, a retailer of lumber products in the Pacific Northwest area, experienced a time of growth in the spring of 1991 (Harvard College, 2002, p.1). The company looked to take out a loan to grow business operations. The maximum loan offer from Suburban National Bank was $250,000 (Harvard College, 2002, p.1). This loan also required a pledge of property from company owner, Mr. Butler, to secure it. However, Northrop Bank would offer a loan up to $465,000 (Harvard College, 2002, p.1). If he accepted this bigger loan, he would have to cut ties with Suburban National. Butler’s business ran off the ability to obtain resources at such a low rate by buying high quantity (Harvard College, 2002, p.1). The fact that he was only able to borrow up to $250,000 from the bank decreased his ability to buy more resources at a cheaper price and receive the discounts he needed to increase his profit margins with the growing market. He began the business in debt when he bought his partner’s interest in the company with a note payable and his business continued to have small profit margins due to lack of financing. During the years, Mr. Butler had taken few purchase discounts because of the shortage of funds arising from Stark’s investment and to cover working capital with the company’s expected increase in sales. He is unable to grow his cash flow enough to pay of his debts and this is a very dangerous trend. He...

Words: 1791 - Pages: 8

Premium Essay

Butler Lumber Case Study

...Case Analysis: Butler Lumber Company (2011-05-03 06:06:15) 转载▼ 标签:mbacorporatefinancecasestudybutlerlumber财经 | 分类: CorporateFinanceCaseStudy | HARVARD BUSINESS SCHOOL 9-292-013 REV: JANUARY 4, 2002 Butler Lumber Company To examine Butler’s current financial situation and to answer the question of how well Butler is doing are not an easy task. There are many things to look into. Let us start with net working capital.   Net working capital= current assets- current liabilities       | 1988 | 1989 | 1990 | 1991 | current assets | 468 | 596 | 776 | 932 | current liabilities | 260 | 375 | 535 | 690 | net working capital | 208 | 221 | 241 | 242 |   In thousands of dollars   For 1991, only first quarter’s data is provided, so in the following discussion, we us the first quarter’s data to represent year 1991. Using excel, I calculated the net working capital of Butler Lumber Company from year 1988 to year 1991. Net working capital can give us some ideas how much the company’s potential reservoir money is. We see a steady increase in net working capital through these years, which is a good sign. However, merely the absolute numbers are not sufficient to make further judgment. Thus, I make this chart on common size analysis based on the total asset.     net working capital | 208 | 221 | 241 | 242 | total assets | 594 | 736 | 933 | 1094 | net working capital common size | 0.350168 | 0.300272 | 0.258307 | 0.221207 |   In thousands of dollars   From the...

Words: 1659 - Pages: 7

Premium Essay

Butler Lumber Company Case Proposal

...Butler Lumber Company Financial Proposal Analysis & Conclusions Based on the analysis on Butler Lumber’s financial statements (Exhibit 1), we conclude that, for sole trader companies like this, it has been growing fast for the past years, as shown in an increase of Sales from 19% in 1989 to 34% in 1990. There is also a slow and steady growth in net income. Butler Lumber uses most of its cash in inventory, occupying 179,000 out of 475,000. Also, stocks’ SAF is positive for 1988-1990 and 1990-1991, indicating that the company has too much inventory. Accounts receivable’s SAF of 1988-1990 and 1990-1991 show a considerable increase, therefore we conclude that the company is giving out a significant amount of credit to its customers. We consider BLC a healthy company with increasing current assets, but due to the fact that it is giving out too much credit to customers, plus too much inventory, Butler Lumber has bad liquidity and turnover. Cash’s SAF shows a negative number brought by decrease in liquidity that avoids its use against contingencies and debt repayment. BLC desires to keep a good relationship with its suppliers. However, right now they have given the company a considerable credit for delayed payment. In order to maintain a solid relationship with its partners, BLC is in great urgency to find other financing sources to pay the credit. This is one of the reasons for Mr. Butler’s desire to borrow money, both to expand his business and to pay the liabilities that...

Words: 1420 - Pages: 6

Premium Essay

Butler Lumber Company Case Study

...BA 5802 Financial Management Case Study 1 Emre BULUT Butler Lumber Company 2056281   |   |   |   |   |   |   | First Quarter |   |   |   |   | 1988 | 1989 | 1990 | 1991 |   | | | | | | | | | | Current Ratio | (CA/CL) | | 1.80 | 1.59 | 1.45 | 1.35 | | Quick Ratio | ((CA-Inv)/CL) | 0.88 | 0.72 | 0.67 | 0.54 | | Inv. Turnover | (Sales/Inv) | 7.10 | 6.17 | 6.44 | 1.29 | | DSO | | (Rec*365/Sales) | 36.78 | 40.25 | 42.95 | 175.38 | | FA Turnover | (Sales/FA) | 13.47 | 14.38 | 17.16 | 4.43 | | TA Turnover | (Sales/TA) | 2.86 | 2.74 | 2.89 | 0.66 | | Debt Ratio | (TL/TA) | | 54.55% | 58.70% | 62.70% | 67.37% | | TIE | | (EBIT/Int Exp) | 3.85 | 3.05 | 2.61 | 2.10 | | EC | | (GP/Int Exp) | | 36.54 | 28.80 | 22.55 | 19.60 | | PM | | (NI/Sales) | 1.83% | 1.69% | 1.63% | 1.25% | | OM | | (EBIT/Sales) | 2.95% | 3.03% | 3.19% | 2.92% | | GPM | | ((Sales-COGS)/Sales) | 27.99% | 28.61% | 27.62% | 27.30% | | BEP | | (EBIT/TA) | | 8.42% | 8.29% | 9.22% | 1.92% | | ROA | | (NI/TA) | | 5.22% | 4.62% | 4.72% | 0.82% | | ROE | | (NI/Com Eq) | 11.48% | 11.18% | 12.64% | 2.52% | | Questions: 1: Why does Mr. Butler have to borrow so much money to support this profitable business? First of all, company is doing well but it has some problems to compensate their short term liabilities. As CR is examined ratio has a decreasing tendency. This is a pointer of money necessity in company. Also although company has a...

Words: 768 - Pages: 4

Premium Essay

Butler Lumber

...Butler Lumber Case Study Zachary Scott Brown FIN 6420 – Dr. J. Robert Malko February 4, 2012 I: Statement of Financial Problem: Butler Lumber Company, a rapidly growing lumber products and retail distribution organization, faced a critical challenge that would determine its future success and level of profitability. The company, led by its founder Mark Butler, had a bright future as its products were consistently in demand in both the new construction and repair work fields. However, Butler Lumber faced one major challenge. The challenge that the company was experiencing was a shortage of cash due to restrictions set by its current funding source, Suburban National Bank. Due to these restrictions, Butler Lumber began to explore other funding sources in order to enhance its current business model and satisfy the high demand of its products. As a possible solution, Butler Lumber looked to a larger bank, the Northrop Bank, which had the potential to offer the company $465,000, nearly double the amount offered by its current lender, Suburban National Bank. Although the idea of moving to a heavy hitting lender seemed quite appealing, one major financial problem needed to be addressed. The major financial problem facing Butler Lumber was identifying why the forecasted figures shown on the income statement differ from the results provided on the balance sheet. II: General Framework for Financial Analysis: There are several factors that can contribute to discrepancies or inconsistencies...

Words: 1210 - Pages: 5

Premium Essay

Butler Lumber

...Butler Lumber Case Study I. Statement of Financial Problem Butler Lumber Company, a growing profitable business has exhausted its credit limit and the key issues facing it are: 1. Need for additional funds to continue the growth 2. Need to consolidate debt 3. Need to improve cash flexibility. In this case study I will be discussing following problem: Why has Butler Lumber been profitable in the increasing volume of sales but at the same time it is experiencing cash difficulties in 1988 – 1990? This is a historical problem and my calculations and assumptions are based on income statement and balance sheet for 1988 – 1990. II. General Framework for Financial Analyses There are different financial ratios and questions they answer: • Liquidity ratio – current ratio: Will Butler Lumber be able to pay off his debts as they come due? Satisfactory liquidity ratio is necessary if Butler Lumber is to continue its operations. • Asset management ratio: Does Butler Lumber have the appropriate amount of assets versus sales? How effectively is Butler Lumber managing its assets? • Debt management ration: Does Butler Lumber have the right mix of debt and equity? • Profitability Ratios: Are sales high enough? Do sales exceed the unit cost? It is necessary to calculate different types of financial ratios to examine different aspects of Butler Lumber’s operations. Key accounts for sources of funds for Butler...

Words: 1432 - Pages: 6

Premium Essay

Case Study

...Butler Lumber Case Management Accounting Case (1) Financial Planning: Butler Lumber Valuation 1. Although Mr Butler has seen an increase in his sales for the last few years, there are a few reasons why he needed a loan from the bank to keep his operations going.       1) Shortage of Cash: Despite good profits, Mr. Butler had experienced a shortage of cash from 1988 to 1990. During this period of time, there was a decrease in cash reserves, as well as in inventory turnover, indicating that Mr. Butler’s money had been tied up in his inventory. This can be resolved by working on his receivables turnover ratio, which decreased from 1988 to 1990, as seen in Appendix A.       2) Debt Consolidation: In late 1988, Mr. Butler took a loan of $70,000 that carried an interest rate of 11%. The annual interest payable to the bank compounded to his cash shortage problem.       3) Expansion of operational business: Additional investments in working capital and inventory purchases will be required to keep up with the company’s increasing sales volume. 2. As illustrated in Appendix B, assuming that 1991 sales volume will be $3.6 million, Butler Lumber will only need a loan of roughly $333,600.00 to finance the expected expansion in sales. The company’s estimate of the loan requirements is inaccurate. 3. In the first quarter of 1990, sales were $698,000, approximately 25.91% of the yearly revenue. Based on this ratio, we estimate that Butler Lumber Company will generate approximately...

Words: 3590 - Pages: 15

Premium Essay

Butler Lumber Company

...Subject: Butler Lumber Company Problem: Butler Lumber Company has been experiencing in the past few years a rapid growth of its sales. However, in order to sustain this growth the company also experienced an increase of its inventory and of its accounts receivables leading to a shortage of cash to finance day to day activities. The company therefore needs to find a way to improve its financial flexibility without extending even more its trade credit. Options: 1. Remain with its current bank, the Suburban National Bank, with a credit limit of $250,000. 2. Take the 90-day note ($465k) from Northrop National Bank and deteriorate relations with Suburban National Bank. a. Benefit from the early payment discount b. Do not benefit from the early payment discount 3. Take a line of credit from Suburban National Bank but for a different amount. Recommendation: Ratio Analysis (compare A/R, A/P turnover rate) Our group recommends that Mr Butler puts an end to his relationship with the Suburban National Bank. Butler Lumber Company needs more financial flexibility in order to sustain its growth and the bank is limiting the maximum loan to $250,000. Therefore, we recommend Mr Butler to start working with Northrop National Bank. Based on our EFN calculations we believe that $465,000 is too much for Butler Lumber Company. Indeed, we have found in our 6 scenarios that the maximum amount that Mr Butler could need would be $392,000. Therefore, we recommend Butler...

Words: 1737 - Pages: 7

Premium Essay

Butler Lumber

...Shumann Butler Lumber Company Background: Butler Lumber Company had been founded in 1981 in a suburb of a large city in the Pacific Northwest. The company s operations were limited to the retail distribution of lumber products. Their typical products included plywood, moldings, and sash and door products. Despite good profits Butler Lumber Company experienced a shortage in cash and found it necessary to increase its bank loans. Issues: y y Why does a Profitable company such as Butler Lumber need external Financing? Should Butler Lumber Company accept the discount that is being offered from its suppliers? y Project the Butler Lumber Company s balance sheet and Income Statement for all of 1991 under two scenarios If they accept the discount If they don t accept the discount Analysis: Butler Lumber Company is a profitable company anticipating tremendous growth, and typical of a company in this phase of the business cycle, the cash needed to meet obligations outstrips its inflow from operations. Butler s exponential growth has caused them to need external financing, because they can t self-fund their working capital needs. The might be able to mitigate some of this through better inventory management control such as squeezing their suppliers on credit terms or for increased volume discounts. Going forward their fixed costs will also help build economies of scale which should diminish their external financing demands in future fiscal periods. Butler is banking...

Words: 1036 - Pages: 5

Premium Essay

Bulter Lumber Case

...Butler Lumber Company Case Analysis In completing the case, we have consulted only with each other and/or the instructor. Sergei Chunkovsky Hung Nguyen Jeffrey Parrish January 25, 2016 Butler Lumber Company, a lumber company located in the Pacific Northwest, is rapidly expanding and is seeking to borrow more cash to finance its day-to-day operations. However, their current bank, Suburban National, has imposed a limit on their borrowing thus causing Butler to seek funds from another bank, Northrop National. Butler Lumber finds itself in a unique position, as it requires an influx of cash even though sales are growing and the company is generating revenue. Because Mr. Butler wants to take advantage of trade discounts, he uses bank notes to pay his suppliers quickly where he would otherwise be unable to with operating cash flows. As his business grows, he purchases more and more inventory on account, requiring larger amounts of debt to pay off. Under current operating procedure, Mr. Butler will need to find another bank to lend him money so that he can continue to operate his business. Based on current projections, it is estimated that the Butler Lumber Company will need to obtain approximately $215,000 from Northrop National Bank to meet their current obligations. Table 1 shows a detailed pro forma balance sheet for the Butler Lumber Company for the years 1988 through 1991. This $215,000 number is calculated on the assumption that sales for 1991 will be...

Words: 2812 - Pages: 12

Premium Essay

Butler Lumber

...Fin 522 Cases in Financial Strategy Group Assignment – Butler Lumber Case Vedvati Shrotre (shrotre2) Xiaoyue Sun (xsun52) Chenxiao Zhu (czhu19) 1. If the first estimated growth of sales is 30 percent, compare it to the value of the secured 90 day note that Northrup Bank is willing to lend Butler Lumber. What are the results? Our conclusion is that the new credit line provided by Northrop National Bank would not cover Butler Lumber’s cash shortage under the assumption of 30 percent sale growth rate and 10 days period of payment period to the supplier. We noticed that the cash conversion cycle we have calculated indicates that it takes 15 days longer for the cash to cycle around in 1991 than in 1990. The main cause for this increase is the assumption that the Butler Lumber company pay suppliers in 10 days to gets purchase discount. With the increase in both sales and cash conversion cycle, the shortage of cash will expand. The geometric average sales growth rate for the period 1988 – 1990 is 26.0%, while the geometric average interest expense growth rate is 59.3%. Basically the interest expense is growing at the speed that doubles the growth rate for sales. Given that sales growth rate is 30%, we estimate the interest expense growth rate to be 76.7% and the amount would be 58K. While under the new credit line, the maximum interest expense under fully utilization of the notes payable would be 465k*10.5%+50K*11%=54.33K. Obviously under 30% growth, the new credit line would be...

Words: 820 - Pages: 4

Premium Essay

Re: Nmims Mumbai Final Merit List Out!!!

...Suggestion as Butler’s financial advisor Butler Lumber Company is on a growing path. It is evident from the case that the volume has been built due to successful price competition, careful control of operating expenses and purchases at substantial discounts. Even in case of an economic downturn its business is protected to a large extent as 55% of its sales are from the repair market. The company is growing at a good pace of 19%, 34% and 34% for the year 1989, 1990 and 1991 respectively. The data is tabulated below. % increase in sales of Butler Lumber Company Net Sales 1988 1697000 Increase NA % Increase NA All amounts in $ 1989 2013000 316000 18.621096 1990 2694000 681000 33.830104 Expected 1991 3600000 906000 33.63028953 1991 first quarter 718000 The company has a considerable amount of debt also which is tabulated below Current outstanding debts of Butler Lumber Company Particulars Notes Payable, bank Notes Payable, trade Accounts payable Accrued expenses Total Debt All amounts in $ Year 1991 247000 157000 157000 36000 597000 As his financial advisor I would suggest Mr. Butler to go for this loan amount. This would help in meeting the expansion and sustaining the growth of his company. Even though the operating expense for 1990 is 658000 and a purchase of 2042000 which is an increase of 34 % and 27.7 % over the previous year, respectively the growth is promising. The amount of $465000 might be needed in chunks and would help him repay a substantial amount of...

Words: 499 - Pages: 2

Premium Essay

Butler Lumberjack

...Suggestion as Butler’s financial advisor Butler Lumber Company is on a growing path. It is evident from the case that the volume has been built due to successful price competition, careful control of operating expenses and purchases at substantial discounts. Even in case of an economic downturn its business is protected to a large extent as 55% of its sales are from the repair market. The company is growing at a good pace of 19%, 34% and 34% for the year 1989, 1990 and 1991 respectively. The data is tabulated below. % increase in sales of Butler Lumber Company Net Sales 1988 1697000 Increase NA % Increase NA All amounts in $ 1989 2013000 316000 18.621096 1990 2694000 681000 33.830104 Expected 1991 3600000 906000 33.63028953 1991 first quarter 718000 The company has a considerable amount of debt also which is tabulated below Current outstanding debts of Butler Lumber Company Particulars Notes Payable, bank Notes Payable, trade Accounts payable Accrued expenses Year 1991 247000 157000 157000 36000 Total Debt All amounts in $ 597000 As his financial advisor I would suggest Mr. Butler to go for this loan amount. This would help in meeting the expansion and sustaining the growth of his company. Even though the operating expense for 1990 is 658000 and a purchase of 2042000 which is an increase of 34 % and 27.7 % over the previous year, respectively the growth is promising. The amount of $465000 might be needed in ...

Words: 494 - Pages: 2