I've been using excel to calculate NPV based on the cash flows in part A but had no success. Please show your work so I can see what I did wrong.

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, 2018. When he returned to his office, Wingo summoned corporate controller Ron Wright to tell him the bad news. "Ron, I vish 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 Roanok 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 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 200,000 300,000 400,000 100,000 2019 2021 2022 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