Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.)

image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Comprehensive Assurance & Systems Tool

Authors: Laura IngrahamJ Jenkins

2nd Edition

0131377213, 9780131377219

More Books

Students also viewed these Accounting questions

Question

5. How can I help others in the network achieve their goals?

Answered: 1 week ago