Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider how Cole Valley Spring Park Lodge could use capital budgeting to decide whether the $12,000,000 Spring Park Lodge expansion would be a good

Consider how Cole Valley Spring Park Lodge could use capital budgeting to decide whether the $12,000,000 Spring Park Lodge exi Data Table Number of additional skiers per day 122 skiers Average number of days per year that weather conditions 147 daysi More Info Assume that Cole Valley uses the straight-line depreciation method and expects the lodge expansion to have a resi  
  

Consider how Cole Valley Spring Park Lodge could use capital budgeting to decide whether the $12,000,000 Spring Park Lodge expansion would be a good investment. Assume Cole Valley's managers developed the following estimates concerning the expansion: (Click the icon to view the estimates.) i (Click the icon to view additional information.) Calculate the net present value of the expansion. (Enter any factor amounts to three decimal places, X.XXX. Round to the nearest whole dollar.) Net Cash Annuity PV Factor (i=12%, n=10) PV Factor (i=12%, n=10) Present Value Inflow Years 1-10 Present value of annuity. 10 0 Present value of residual value Total PV of cash inflows. Initial investment Net present value of expansion The expansion is project because its NPV is (Click the icon to view Present Value of $1 table.) (Click the icon to view Present Value of Ordinary Annuity of $1 table.) What is the project's NPV (round: nearest dollar)? Is the Investment attractive? Why or why not? Enter any number in the edit fields and then continue the next question. i Data Table Number of additional skiers per day Average number of days per year that weather conditions allow skiing at Cole Valley Useful life of expansion (in years) Average cash spent by each skier per day Average variable cost of serving each skier per day Cost of expansion Discount rate Print Done 122 skiers 147 days 10 years 240 77 12,000,000 12% More Info Assume that Cole Valley uses the straight-line depreciation method and expects the lodge expansion to have a residual value of $750,000 at the end of its ten-year life. They have already calculated the average annual net cash inflow per year to be $2,923,242. Print Done Reference Periods 1% 2% 0.990 0.980 0.980 0.961 0.971 0.942 0.961 0.924 0.951 0.906 0.942 0.888 0.837 0.790 0.933 0.871 0.813 0.760 0.923 0.853 0.789 0.731 0.914 0.837 0.766 0.703 0.905 0.820 0.744 0.676 0.614 0.558 0.508 2 3 45 678910 112 13 14 15 16 17 18 19 0.896 0.804 0.887 0.788 0.879 0.773 0.758 0.743 0.870 0.861 0.853 0.844 0.836 0.728 0.714 0.700 Present Value of $1 3% 4% 5% 6% 7% 8% 9% 12% 14% 15% 16% 18% 20% 0.971 0.962 0.952 0.943 0.926 0.833 0.935 0.943 0.925 0.907 0.890 0.873 0.857 0.915 0.889 0.864 0.840 0.816 0.794 0.772 0.888 0.855 0.823 0.792 0.763 0.735 0.708 0.863 0.822 0.784 0.747 0.713 0.681 0.650 0.194 10% 0.917 0.909 0.893 0.877 0.870 0.862 0.847 0.842 0.826 0.797 0.769 0.756 0.743 0.718 0.694 0.751 0.712 0.675 0.658 0.641 0.609 0.579 0.683 0.636 0.592 0.572 0.552 0.516 0.482 0.621 0.567 0.519 0.497 0.476 0.437 0.402 0.746 0.705 0.666 0.630 0.596 0.564 0.507 0.456 0.432 0.410 0.370 0.335 0.711 0.665 0.623 0.583 0.547 0.513 0.452 0.400 0.376 0.354 0.314 0.279 0.677 0.627 0.582 0.540 0.502 0.467 0.404 0.351 0.327 0.305 0.266 0.233 0.645 0.592 0.544 0.500 0.460 0.424 0.361 0.308 0.284 0.263 0.225 0.463 0.422 0.386 0.322 0.270 0.247 0.227 0.191 0.722 0.650 0.585 0.527 0.475 0.429 0.388 0.350 0.287 0.237 0.215 0.195 0.162 0.701 0.625 0.557 0.497 0.444 0.397 0.356 0.319 0.257 0.208 0.187 0.168 0.137 0.112 0.681 0.601 0.530 0.469 0.415 0.368 0.326 0.290 0.229 0.182 0.163 0.145 0.116 0.093 0.661 0.577 0.505 0.442 0.388 0.340 0.299 0.263 0.205 0.160 0.141 0.125 0.099 0.078 0.417 0.362 0.315 0.275 0.239 0.183 0.140 0.123 0.108 0.084 0.065 0.394 0.339 0.292 0.252 0.218 0.163 0.123 0.107 0.093 0.071 0.054 0.513 0.436 0.371 0.317 0.270 0.231 0.198 0.146 0.108 0.093 0.080 0.060 0.045 0.494 0.416 0.350 0.296 0.250 0.212 0.180 0.130 0.095 0.081 0.069 0.051 0.038 0.396 0.331 0.277 0.232 0.194 0.164 0.116 0.083 0.070 0.060 0.043 0.031 0.162 0.135 0.642 0.555 0.481 0.623 0.534 0.458 0.605 0.587 0.570 0.475 0.828 0.686

Step by Step Solution

3.41 Rating (151 Votes )

There are 3 Steps involved in it

Step: 1

Calculation of Net Present Value of Investment Net Present value Present valu... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Horngrens Financial and Managerial Accounting

Authors: Tracie L. Nobles, Brenda L. Mattison, Ella Mae Matsumura

4th Edition

978-0133251241, 9780133427516, 133251241, 013342751X, 978-0133255584

More Books

Students also viewed these Accounting questions

Question

Find reactions of support 1,2 and 3 F=10KN, a=2m, ?a=60 (45%) F 2a

Answered: 1 week ago

Question

define sickness absence and sickness presence;

Answered: 1 week ago

Question

How has technology had an impact on aggregate planning?

Answered: 1 week ago