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

Wansley Lumber is considering the purchase of a paper company,which would require an initial investment of $300 million. Wansleyestimates that the paper company would provide net cash flows of$40 million at the end of each of the next 20 years. The cost ofcapital for the paper company is 13%. a. Should Wansley purchasethe paper company? b. Wansley realizes that the cash flows in Years1 to 20 might be $30 million per year or $50 million per year, witha 50% probability of each outcome. Because of the nature of thepurchase contract, Wansley can sell the company 2 years afterpurchase (at Year 2 in this case) for $280 million if it no longerwants to own it. Given this additional information, doesdecision-tree analysis indicate that it makes sense to purchase thepaper company? Again, assume that all cash flows are discounted at13%. c. Wansley can wait for 1 year and find out whether the cashflows will be $30 million per year or $50 million per year beforedeciding to purchase the company. Because of the nature of thepurchase contract, if it waits to purchase, Wansley can no longersell the company 2 years after purchase. Given this additionalinformation, does decision-tree analysis indicate that it makessense to purchase the paper company? If so, when? Again, assumethat all cash flows are discounted at 13%.

Answer & Explanation Solved by verified expert
4.2 Ratings (529 Votes)
Answer 1 Cash outflow Initial 300 Mn Cash Flow per Annum for 20 years 40 Mn Cost of capital 013 Formula PVrateno of years amount Calculation PV0132040 Present value of Cash flow per annum 281    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