Butler Lumber Company
\nEstimating Funds Requirements (AFN)
\nPrepare a short report (2-3 pages) explaining Butler Lumber\u2019s financial situation. You should consider
\nyour audience to be Mr. Butler. Be sure to at least answer the following questions in your report and
\nsupport your argument with detailed financial models which you will provide to Mr. Butler (via e-mail to
\nProfessor Tice) on the project due date along with the report that references your supporting data,
\naddresses the key questions in the case, and outlines a defensible recommendation that Mr. Butler can
\nuse in discussions with his bankers. A hard copy of the report and financial analysis should be turned
\nin at the start of class on the due date.
\nAssignment:
\n1. Compute the relevant ratios for Butler Lumber Company for the years 1988-1990.
\n2. Prepare a Statement of Cash Flows for the aggregate period 1988-1990 (i.e., use the 1988 and 1990
\nbalance sheets to compute the changes in balance sheet accounts).
\n3. Based on the work in questions #1 & #2, summarize your major findings. Address the firm\u2019s
\nliquidity, debt management, profitability, asset management, and working capital position.
\na. Identify any problem areas that you may see.
\nb. Use this analysis to determine why Butler Company is so short of cash despite its record of
\nprofitable operations.
\n3. Do you agree with Mr. Butler\u2019s estimate of the company\u2019s loan requirements, including term and
\ntotal amount required? How much will he need to borrow to finance his expected expansion in
\nsales? (Assume sales will grow 18% each year in 1991 and 1992 and that Butler Lumber is at full
\ncapacity).
\na. Using 1990 ending balances as starting points, prepare the 1991 and 1992 year-end pro-forma
\nincome statements and balance sheets under two scenarios:
\ni. They continue to rely heavily on trade credit (Accounts Payable) as a source of funds.
\nii. They pay accounts payable promptly (in 10 days) in order to take advantage of the 2% trade
\ndiscount.
\nb. In choosing between the use of trade credit and bank loans as a source of funds, what should
\nthis decision be based on? Be sure to explain this in your report.
\n4. As Mr. Butler\u2019s Financial Advisor, recommend to Mr. Butler whether he go ahead with OR reconsider
\nhis anticipated expansion and his plans for additional debt financing.
\na. If you recommend going forward with the expansion, indicate if you anticipate that the bank will
\napprove his loan and explain any conditions (covenants) you think the bankers would put on this
\nloan.
\nb. Discuss relevant issues, recommendations, and any necessary changes in Mr. Butler\u2019s business
\npractices your team identified through the analysis (including parts 1 through 4).
\nc. Identify the primary reason why Mr. Butler must borrow money to support this profitable
\nbusiness. Provide specific solutions to help him solve this issue, including the appropriate loan
\nterm and any additional sources of funding that he should consider.<\/p>\n","protected":false},"excerpt":{"rendered":"
Butler Lumber Company Estimating Funds Requirements (AFN) Prepare a short report (2-3 pages) explaining Butler Lumber\u2019s financial situation. You should consider your audience to be Mr. Butler. Be sure to at least answer the following questions in your report and Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-19324","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/19324","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=19324"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/19324\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=19324"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=19324"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=19324"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}