Please do in excel showing the work Wansley Lumber is considering the purchase of a paper...

70.2K

Verified Solution

Question

Finance

Please do in excel showing the work WansleyLumber is considering the purchase of a paper company, which wouldrequire an initial investment of $300 million. Wansley estimatesthat the paper company would provide net cash flows of $40 millionat the end of each of the next 20 years. The cost of capital forthe paper company is 13%. a. Should Wansley purchase the papercompany? b. Wansley realizes that the cash flows in Years 1 to 20might be $30 million per year or $50 million per year, with a 50%probability of each outcome. Because of the nature of the purchasecontract, Wansley can sell the company 2 years after purchase (atYear 2 in this case) for $280 million if it no longer wants to ownit. Given this additional information, does decision-tree analysisindicate that it makes sense to purchase the paper company? Again,assume that all cash flows are discounted at 13%. c. Wansley canwait for 1 year and find out whether the cash flows will be $30million per year or $50 million per year before deciding topurchase the company. Because of the nature of the purchasecontract, if it waits to purchase, Wansley can no longer sell thecompany 2 years after purchase. Given this additional information,does decision-tree analysis indicate that it makes sense topurchase the paper company? If so, when? Again, assume that allcash flows are discounted at 13%.

Answer & Explanation Solved by verified expert
3.8 Ratings (638 Votes)
Discounting factor wheren the respective yearPart aCost of capital 13YearCash flow iDiscount factor 13 iiNet Present Value ixii0300000000130000000014000000008849563539823009240000000078314731325867333400000000693052772200649440000000061331924532749115400000000542762171039744640000000048031919212741174000000004250611700242575840000000037616150463944794000000003328851331539334104000000002945881178353393114000000002606981042790613124000000002307069228235512134000000002041658166580099144000000001806777227062034154000000001598916395630119164000000001414965659849663174000000001252185008716516184000000001108124432492492194000000000980643922559727204000000000867823471291794NPV190099369Since the net present value of all    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students