Question

Questions to consider with your groups: You are advisingMr. Butler 1. Why does Mr. Butler have to borrow so much monay to support this profitable businass? Towards assessing Butler's financial health and performance, calculate common financial ratios as3essing the firm's profitability, assat efficiency (espacially working capital), leverage and liquidity. Your text for Business Finance should have a chapter covering thase ratios and your Introductory Accounting text should also have a chapter on financial ratios. You are given, for the years, 1988-1990, and first quarter, 1991, balance shaats and income statemants (operating statemants) for Butler Lumber Co. From thase stataments, produce aCash Flow statement for 1989, 1990 and for first quarter, 1991 What are you able to conclude about Mr. Butler's business? a b. c. 2. Much of Butler's incresad nead for funds has been due to increased levels of Invantory and Accounts Racaivabla. Considering theperiod from end of 1988 to and of 1990, how much of tha increase in Invantories has ben due to siower inentor turms (or, eguaienty longer das yf inventory on hand versus that due to sales growth. Similarly, how much of the increase in Accounts Receivable has ben due to a longer collection period versus that due to sales growth. 3. Do vou agre with Butler's estimate of the company's loan requiremant? How much will he nead in 1991 to finance his expactad expansion in sales? Towards address this quastion, build a pro-forma income statament and balance shaet for 1991 year end. a Assume Butler's 1991 Sales grow to $3.6 million. ii. i. Unlass you have evidance to the contrary, assume that expanse category ratios to sales are the same a in 1990 iii. Intarast expanse should be estimated as a function of the amount of DEBT the company ends up with on the balance shaat. Start out with a guess of $40K for intarest expen32. iv. The net income from 1991 will directly increment the book value of equity from 1990 to 1991 year and (there are no dividands, no rpurchases of stock and no stoc issues in 1991) v. Assume Cash by the and of 1991 is incresad to $60K vi. Forecast AR. Inventory, AP, Accoed Expenses using either %'s of sales or the working capital ratios you got fom #1 above. vii. Assume property, net, will increase to $179K viii. Long term debt will go down by $TK. ix. Back into the New Bank Loan siz2 given the rest of the balance information x. Recalculate interest expanse now, given the loan size youjust calculatad. xi. Iterate. 4. Suppose he can gat the discussed loan from Northrop National Bank. Should he take it?

Answer 1