Case Study Butler Lumber
Case Study: Capital Budgeting
Butler Lumber Company
Abstract
Butler Lumber Company, a lumber retailer with a rapid growth rate, is faced with the problem of cash flow shortage. In order to support this profitable business, BLC needs a great amount of cash. The loan of $250,000 from Suburban National and a line of credit of up to $465,000 from Northrop National Bank are the two choices provided. After a brief review of the operation and financial conditions of BLC, we first make analysis of the credit level of BLC from the perspective of banker. Although the feedback from all the firms that had business dealings with Butler are quite positive , both solvency and liquidity condition and the mortgage indicates that it is not a wise decision for Northrop National Bank to offer a line of credit to BLC. Then we diagnose the business of BLC by examining the sources and uses of funds and find out that the increase in inventory and accounts payable occupies too much funds that leads to the shortage of cash flow. If BLC can make improvement in the management of these two items, definitely it can take advantage of the trade discount, which equals to an interest rate of 20.2% per year. Based on the calculation of average days payable discount it can be concluded that BLC should reduce its days payable outstanding to 10 days. Since sales is expected to reach $3.6 million in 1991, the projected income sheet and the balance sheet can be obtained through calculation so that we get the plug value (notes payable to bank) needed for the profitable business. This amount is so large that it exceeds the maximum amount the company can get from bank.
In the third part of this report, we provide four suggestions for BLC to solve the problem of cash flow shortage. The credit terms of net 30 days on open account offered to customers can be improved by Customer Credit Ranking System. Besides BLC must keep inventory at an optimal level so that if can save the opportunity cost of
Butler Lumber Company
Abstract
Butler Lumber Company, a lumber retailer with a rapid growth rate, is faced with the problem of cash flow shortage. In order to support this profitable business, BLC needs a great amount of cash. The loan of $250,000 from Suburban National and a line of credit of up to $465,000 from Northrop National Bank are the two choices provided. After a brief review of the operation and financial conditions of BLC, we first make analysis of the credit level of BLC from the perspective of banker. Although the feedback from all the firms that had business dealings with Butler are quite positive , both solvency and liquidity condition and the mortgage indicates that it is not a wise decision for Northrop National Bank to offer a line of credit to BLC. Then we diagnose the business of BLC by examining the sources and uses of funds and find out that the increase in inventory and accounts payable occupies too much funds that leads to the shortage of cash flow. If BLC can make improvement in the management of these two items, definitely it can take advantage of the trade discount, which equals to an interest rate of 20.2% per year. Based on the calculation of average days payable discount it can be concluded that BLC should reduce its days payable outstanding to 10 days. Since sales is expected to reach $3.6 million in 1991, the projected income sheet and the balance sheet can be obtained through calculation so that we get the plug value (notes payable to bank) needed for the profitable business. This amount is so large that it exceeds the maximum amount the company can get from bank.
In the third part of this report, we provide four suggestions for BLC to solve the problem of cash flow shortage. The credit terms of net 30 days on open account offered to customers can be improved by Customer Credit Ranking System. Besides BLC must keep inventory at an optimal level so that if can save the opportunity cost of