Net present value (CMA adapted) (LO 3) "Maybe I should have stuck with teaching high school art. No matter what I try, I can't seem to turn that Roanoke plant around." That's how the meeting between Warren Wingo, CEO of clothing manufacturer Wingo Designs, and Angie Tillery, vice president of corporate lending at First National Bank, ended. Wingo and Tillery had just concluded that the Roanoke plant was draining corporate cash flow and income, and should be closed on December 31, 2011.
When he returned to his office, Wingo summoned corporate controller Ron Wright to tell him the bad news. "Ron, I wish there were some way to turn this situation around. We've had so many bad things happen lately-the fire in Lexington, the strike in Pulaski, and now this. Why didn't I stay at Cave Spring High?"
"Warren, it may not be as bad as it seems," Ron replied. "Let's put our heads together and do some investigating. We've got some great folks working here, and I bet if we asked them to think about it, they could come up with some options." With that encouragement, Warren sent Ron out to find some way of disposing of the Roanoke facility.
Early Monday morning, Ron ran into Warren's office waving a legal pad. "We've done it, Warren. We've got three good options for the Roanoke plant. One of them even has us keeping the plant." Warren listened intently as Ron laid out the three options his staff had developed:

Option 1
Sell the plant immediately to Tinsley Togs for $9,000,000.
Option 2
Lease the plant for four years to Star City Mills (one of Wingo's suppliers). Under the lease terms, Star City would pay Wingo $2,400,000 in rent each year and would grant Wingo a 10% discount on fabric purchased by another of its plants. The fabric normally sells for $2 per yard, and Wingo expects to purchase 2,370,000 yards of it each year. Star City would cover all the plant's ownership costs, including property taxes. At the end of the lease, Wingo would sell the plant for $2,000,000.
Option 3
Use the plant for four years to make souvenir 2014 Winter Olympic jackets. Fixed overhead, before equipment upgrades, is estimated at $200,000 a year. The jackets are expected to have a variable cost of $33 per unit and to sell for $42 each. Estimated unit sales are as follows; annual production would equal sales.

To manufacture the jackets, some of the plant's equipment would have to be replaced at an immediate cost of $1,500,000. The equipment would have a useful life of four years. Because of the upgraded equipment, Wingo could sell the plant for $3,000,000 at the end of four years.

Required

a. Calculate the cash flows for years one through four for each option.

b. Calculate the net present value of each of each option. Assume a 12% discount rate.

c. Use Excel or another spreadsheet application to determine the discount rate that equates options 1 and 2. Do the same for options 1 and 3.

d. What should Wingo do?