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.(Round answers to 2 decimal places, e.g. 52.75.)

Case Question 9-31 \"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 ow and income, and should be closed on December 31, 2018. When he returned to his ofce, 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 latelythe re 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 nd some way of disposing of the Roanoke facility. Early Monday morning, Ron ran into Warren's ofce 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: thion 1 Sell the plant immediately to Tinsley Togs for $9,000,000. thion 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. thion 3 Use the plant for four years to make souvenir 2022 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. Year Jacket Sales In Units 201 9 200,000 2020 300,000 2021 400,000 2022 100,000 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. ' (3) Your answer is correct. Calculate the cash ows for each year for each option? (Do not leave any answer eld blank. Enter 0 for amounts. Enter negative amounts using either a negative sign preceding the number e. g. -45.) Timing Amount Option 1 Option 2 Option 3 J Year 0 $ 9000000 Year 1 -'l 500000 I'Elil 9' l.\" t 2874000 1600000 Year 2 2874000 2500000 Year 3 2874000 3400000 W \" Year 4 4874000 3700000 7 '7 7\" W 60' Click if you would like to Show Work for this question: Open Show Work LINK TO TEXT Attempts: 5 of 15 used ' ('3) Your answer is partially correct. Try again. Calculate the net present value of each option. Assume a 12% discount rate. Net present value Optionl 3 900000000 Option 2 I 10000318 l $ '- Option 3 559311000 Click if you would like to Show Work for this question: Open Show Work 4 {9 " (b) Your answer is partially correct. Try again. Calculate the net present value of each option. Assume a 12% discount rate. Net present value Option 1 $ QOUDGUBDO l-l 3.. OptionS 3 559311030 Click if you would like to Show Work for this question: Open Show Work Option 2 LINK TO TEXT Attempts: 15 of 15 used ' (C) Use Excel or another spreadsheet application to determine the discount rate that equates options 'I and 2. Do the same for options 1 and 3. (Round answers to 2 decimal places, e.g. 52.75.) Discount Rate that equates Options 1 and 2 .16 Discount Rate that equates Options 1 and 3 as