Need 1 page and one excel sheet

Consider the following scenario:

Deer Valley Lodge, a ski resort in the Wasatch Mountains of Utah, has plans to eventually add five new chairlifts. Suppose that one lift costs $2 million, and preparing the slope and installing the lift costs another $1.3 million. The lift will allow 300 additional skiers on the slopes, but there are only 40 days a year when the extra capacity will be needed. (Assume that Deer Valley Lodge will sell all 300 lift tickets on those 40 days.) Running the new lift will cost $500 a day for the entire 200 days the lodge is open. Assume that the lift tickets at Deer Valley cost $55 a day. The new lift has an economic life of 20 years.

Don't use plagiarized sources. Get Your Custom Essay on
Need 1 page and one excel sheet
Just from $13/Page
Order Now
  1. Assume that the before-tax required rate of return for Deer Valley is 14%. Compute the before-tax NPV of the new lift and advise the managers of Deer Valley about whether adding the lift will be a profitable investment. Show calculations to support your answer.
  2. Assume that the after-tax required rate of return for Deer Valley is 8%, the income tax rate is 40%, and the MACRS recovery period is 10 years. Compute the after-tax NPV of the new lift and advise the managers of Deer Valley about whether adding the lift will be a profitable investment. Show calculations to support your answer.
  3. What subjective factors would affect the investment decision?

 

You can view a present value table here.

Grading Criteria

Percentage

Compute the before-tax NPV of the new lift and advise the managers of Deer Valley about whether adding the lift will be a profitable investment.

45%

Compute the after-tax NPV of the new lift and advise the managers of Deer Valley about whether adding the lift will be a profitable investment.

45%

What subjective factors would affect the investment decision?Supporting research/arguments made

10%

Please submit your assignment.

NOTE:
We have worked on a similar assignment and our student scored better and met their deadline. All our tasks are done from scratch, well researched and 100% unique, so entrust us with your assignment and I guarantee you will like our services and even engage us for your future tasks. Click below button to submit your specifications and get order quote

Get started