Question

In: Finance

​OpenSeas, Inc. is evaluating the purchase of a new cruise ship. The ship will cost $499...

​OpenSeas, Inc. is evaluating the purchase of a new cruise ship. The ship will cost $499 ​million, and will operate for 20 years. OpenSeas expects annual cash flows from operating the ship to be $69.9 million and its cost of capital is 12.2%.

a. Prepare an NPV profile of the purchase.

b. Identify the IRR on the graph.

c. Should OpenSeas proceed with the​ purchase?

d. How far off could​ OpenSeas' cost of capital estimate be before your purchase decision would​ change?

Solutions

Expert Solution

Solution: Cash outflow : -$499 million, Cash Inflow = $69.9 million for 20 years, Cost of capital = 12.2%

  • Step 1: Calculate the discounted cash flow for 20 years
  • Step 2: compare Discounted cash flow with cash outflow to get NPV
  • Step 3: Select different rates to make NPV profile
  • Step 4: Make graph of NPV with different rates

All the calculations and formula have been shown in excel

Question A) NPV profile is plotted on the given graph (y-axis: NPV, x-axis: Rate)

Question B) IRR has been identified as 12.73% and for this NPV is zero

Question C) Yes, Since NPV is $16.63 million and it is positive for 12.2% discount rate

Question D) Since IRR is 12.73% and NPV is zero here and NPV is negative after this rate so purchase decision will change over 12.73% cost of capital.


Related Solutions

​OpenSeas, Inc. is evaluating the purchase of a new cruise ship. The ship will cost $...
​OpenSeas, Inc. is evaluating the purchase of a new cruise ship. The ship will cost $ 495 million and will operate for 20 years. OpenSeas expects annual cash flows from operating the ship to be $ 69.8 million and its cost of capital is 12.1 %. a. Prepare an NPV profile of the purchase. b. Identify the IRR on the graph. c. Should OpenSeas go ahead with the​ purchase? d. How far off could​ OpenSeas's cost of capital estimate be...
​ ​OpenSeas, Inc. is evaluating the purchase of a new cruise ship. The ship will cost...
​ ​OpenSeas, Inc. is evaluating the purchase of a new cruise ship. The ship will cost $ 500$500 ​million, and will operate for 2020 years. OpenSeas expects annual cash flows from operating the ship to be $ 70.0$70.0 million and its cost of capital is 12.0 %12.0%. a. Prepare an NPV profile of the purchase. b. Identify the IRR on the graph. c. Should OpenSeas proceed with the​ purchase? d. How far off could​ OpenSeas' cost of capital estimate be...
​OpenSeas, Inc. is evaluating the purchase of a new cruise ship. The ship will cost $...
​OpenSeas, Inc. is evaluating the purchase of a new cruise ship. The ship will cost $ 495 ​million, and will operate for 20 years. OpenSeas expects annual cash flows from operating the ship to be $ 70.7 million and its cost of capital is 12.1 %. a. Prepare an NPV profile of the purchase. b. Identify the IRR on the graph. c. Should OpenSeas proceed with the​ purchase? d. How far off could​ OpenSeas' cost of capital estimate be before...
​OpenSeas, Inc. is evaluating the purchase of a new cruise ship. The ship will cost $502...
​OpenSeas, Inc. is evaluating the purchase of a new cruise ship. The ship will cost $502 ​million, and will operate for20 years. OpenSeas expects annual cash flows from operating the ship to be $68.9 million and its cost of capital is 11.4%. a. Prepare an NPV profile of the purchase. b. Identify the IRR on the graph. c. Should OpenSeas proceed with the​ purchase? d. How far off could​ OpenSeas' cost of capital estimate be before your purchase decision would​...
​OpenSeas, Inc. is evaluating the purchase of a new cruise ship. The ship will cost $497...
​OpenSeas, Inc. is evaluating the purchase of a new cruise ship. The ship will cost $497 ​million, and will operate for 20 years. OpenSeas expects annual cash flows from operating the ship to be $68.1 million and its cost of capital is 11.7%. a. Prepare an NPV profile of the purchase. b. Identify the IRR on the graph. c. Should OpenSeas proceed with the​ purchase? d. How far off could​ OpenSeas' cost of capital estimate be before your purchase decision...
OpenSeas, Inc., is evaluating the purchase of a new cruise ship. The ship will cost $500...
OpenSeas, Inc., is evaluating the purchase of a new cruise ship. The ship will cost $500 million, and will operate for 20 years. OpenSeas expects annual cash flows from operating the ship to be $70 million and its cost of capital is 12%. a. Prepare a NPV profile of the purchase. Do from rate 0% to 20% (please show me the formula you use, I have been trying to figure it out and cant) b. Identify the IRR on the...
OpenSeas, Inc. is evaluating the purchase of a new cruise ship. The ship will cost $497...
OpenSeas, Inc. is evaluating the purchase of a new cruise ship. The ship will cost $497 ​million, and will operate for 20 years. OpenSeas expects annual cash flows from operating the ship to be $70.1 million and its cost of capital is 12.1%. a. Prepare an NPV profile of the purchase. b. Identify the IRR on the graph. c. Should OpenSeas proceed with the​ purchase? d. How far off could​ OpenSeas' cost of capital estimate be before your purchase decision...
​OpenSeas, Inc. is evaluating the purchase of a new cruise ship. The ship will cost $495...
​OpenSeas, Inc. is evaluating the purchase of a new cruise ship. The ship will cost $495 million, and will operate for 20years. OpenSeas expects annual cash flows from operating the ship to be $71.4 million and its cost of capital is 12.3%. a. Prepare an NPV profile of the purchase. b. Identify the IRR on the graph. c. Should OpenSeas proceed with the​ purchase? d. How far off could​ OpenSeas' cost of capital estimate be before your purchase decision would​...
OpenSeas, Inc., is evaluating the purchase of a new cruise ship. The ship would cost $400...
OpenSeas, Inc., is evaluating the purchase of a new cruise ship. The ship would cost $400 million today. OpenSeas expects annual cash flows from the new ship to be $70 million and these cash flows will last forever. The cost of capital is 16%. What is the IRR of the new cruise ship? Please make your answer in the unit of percent. ______% Following question 4, suppose the company has a desired payback period of 5 years. Which statement is...
OpenSeas, Inc. is evaluating the purchase of a new cruise ship. The ship would cost $505...
OpenSeas, Inc. is evaluating the purchase of a new cruise ship. The ship would cost $505 ?million, but would operate for 20 years. OpenSeas expects annual cash flows from operating the ship to be $70.1 million? (at the end of each? year) and its cost of capital is 11.9% a. Prepare an NPV profile of the purchase using discount rates of 2.0%?, 11.5% and 17.0%. b. Identify the IRR on a graph. c. Is the purchase attractive based on these?...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT