X Data Table Consider how Cherry Valley, a popular ski resort, could use capital budgeting to decide whether the $8.5 million Stream Park Lodge expansion would be a good investment. 9(Click the icon to view the expansion estimates.) (Click the icon to view the present value annuity factor table.) (Click the icon to view the present value factor table.) (Click the icon to view the future value annuity factor table.) (Click the icon to view the future value factor table.) Read the requirements Assume that Cherry Valley's managers developed the following estimates concerning a planned expansion to its Stream Park Lodge (all numbers assumed): Requirement 1. What is the project's NPV? Is the investment attractive? Why or why not? Calculate the net present value of the expansion. (Round your answer to the nearest whole dollar. Use parentheses or a minus sign for a negative net present value.) Net present value of expansion $ 873,475 Is the investment attractive? Why? Number of additional skiers per day .... 118 Average number of days per year that weather conditions allow skiing at Cherry Valley. 158 Useful life of expansion (in years) 10 Average cash spent by each skier per day. $ 237 Average variable cost of serving each skier per day. 142 Cost of expansion... $ 8,500,000 Discount rate....... 14% Assume that Cherry Valley uses the straight-line depreciation method and expects the lodge expansion to have a residual value of $500,000 at the end of its ten-year life. It has already calculated the average annual net cash inflow per year to be $1,771,180 The expansion is an attractive project because its NPV is positive Requirement 2. Assume the expansion has no residual value. What is the project's NPV? Is the investment still attractive? Why or why not? Calculate the project's NPV. (Round your answer to the nearest whole dollar. Use parentheses or a minus sign for a negative net present value.) Net present value of expansion Print Done