Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem 9 - 4 Present Value and What If Analysis - See Textbook page 9 - 3 0 National Cruise Line, Inc. is considering
Problem Present Value and "What If Analysis See Textbook page
National Cruise Line, Inc. is considering the acquisition of a new ship that will cost In this regard, the president of the company asked the CFO to analyze cash flows associated with operating the ship under two alternative itineraries: Itinerary Caribbean WinterAlaska Summer and Itinerary Caribbean WinterEastern Canada Summer. The CFO estimated the following cash flows, which are expected to apply to each of the next years:
CaribbeanAlaska Caribbean Eastern Canada
Net revenue $ $
Less:
Direct program expenses
Indirect program expenses
Nonoperating expenses
Add back depreciation
Cash flow per year $ $
The estimated cost of the new ship and expected cash flows are:
Estimated cost of new ship $
Estimated period of cash flows in years
Required
a For each of the itineraries, calculate the present values of the cash flows using required rates of return of both and using both present value factors using Tables and separately using the Excel PV function. Assume a year time horizon. Should the company purchase the ship with either or both required rates of return?
Use Appendix Table B to arrive at the factor Note: The PV values using the Table method vs Excel
will not be exactly equal, but will be very close in value.
CaribbeanAlaska
Cash Flow Factor
times
times
Caribbean Eastern Canada
times
times
CaribbeanAlaska Caribbean Eastern Canada
Rate
Number of periods
Cash Flow
Future value $ $ $ $
Type
PV
For the PV values in cells DE F G use the Microsoft Excel functions. If you need help with the Excel function, see the Excel video.
The Excel video shows how to use the FORMAT and FINANCIAL tabs in Excel to choose a multitude of Excel functions
You will be using the PV function in the drop down list to complete the above table.
Should the company purchase the ship with either or both required rates of return? Explain.
b The president is uncertain whether a percent or a percent required return is appropriate. Explain why,
c Focusing on a percent required rate of return, what would be the opportunity cost to the company of using the ship in the CaribbeanEastern Canada itinerary rather than a CaribbeanAlaska itinerary?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started