Chepter 11 Case Klton Starr Student: Kolton Starr Date: to/2/16 1. Developing Relevant Cash Flows for Clark Upholstery Company's Machine. Renewal or Replacement Decision Instructor: Alan Eastman Course: FIN 320 Fall 2016 Assignment: Chapter 11 Case Bo Humphries, chief financial officer of Clark Upholstery Company, expects the firm's net operating profit after taxes for the next 5 years to be as shown in the following table. Year Net operating profit after taxes $100,000 $150,000 $200,000 $250,000 $320,000 Bo is beginning to develop the relevant cash flows needed to analyze whether to renew or replace Clark's only depreciable asset, a machine that criginally cost $30,000, has a current book value of zero, and can now be sold for $20,000. (Note: Because the firm's only depreciable asset is fully depreciated-its book value is zero its expected operating cash inflows equal its net operating profit after taxes.) He estimates that at the end of 5 years, the existing machine can be sold to net $2,000 before taxes. Bo plans to use the following information to develop the relevant cash flows for each of the alternatives. Alternative 1 Renew the existing machine at a total depreciable cost of $90,000. The renewed machine would have a 5-year usable life and would be depreciated under MACRS using a 5-year recavery period. Renewing the machine would result in the following projected revenues and expenses (excluding depreciation and interest) Year Revenue Expenses (Excl. depreciation and interest) $1,000,000 $1,175,000 $1,300,000 $1,425,000 $1,550,000 943,100 968,100 801,500 884,200 918,100 The renewed machine would result in an increased investment in net working capital of $15,000. At the end of 5 years, the machine could be sold to net $8,000 before taxes. Alternative 2 Replace the existing machine with a new machine that costs $100,000 and requires installation costs of $10,000. The new machine would have a 5-year usable life and would be depreciated under MACRS using a 5-year recovery period. The firm's projected revenues and expenses (excluding depreciation and interest), if it acquires the machine, would be as follows: Year $1,000,000 $1,175,000 $1,300,000 $1,425,000 $1,550,000 Revenue Expenses (Excl. depreciation and interest) 784,500 839,800 914,900 989,900 998,900 The new machine would result in an increased investment in net working capital of $22,000. At the end of 5 years, the new machine could be sold to net $25,000 before taxes. The firm is subject to a 40% tax rate. Assume a 9 percent dscount rate. As noted, the company uses MACRS depreciation To Do a. Calculate the initial investment associated with each of Clark Upholstery's alternatives. b. Calculate the incremental operating cash inflows associated with each of Clark's altenatives. (Note: Be sure to consider the depreciation in year 6.) c. Calculate the terminal cash flow at the end of year 5 associated with each of Clark's alternatives d. Use your findings in parts (a), (b), and (c) to depict on a time line the relevant cash flows associated with each of Clark Upholstery's altematives e. Solely on the basis of your comparison of their relevant cash flows, which alternative appears to be better? Why? a. Calculate the initial investment associated with each of Clark Upholstery's altenatives. Calculate the initial investment associated with Altemative 1 below (Round to the nearest dolar.)
