Question

In: Finance

.Squaw Valley Recreation is in the process of analyzing a new three year project to grow...

.Squaw Valley Recreation is in the process of analyzing a new three year project to grow their business. At the beginning of this project, Squaw Valley will need to spend $2,460,000 to build the required fixed asset. This asset will have a depreciation period of three-years and will use the straight-line method of depreciation and it will be depreciated to zero. The asset will have no salvage value at the end of the project. This new project will have an estimated annual sales amount of $2,950,000. The estimated annual costs for this project are $1,970,000. The appropriate tax rate to use for this analysis is 22 percent. The CFO of Squaw Valley has indicated that the required return for this project is 9 percent. Calculate the NPV for this project. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

Solutions

Expert Solution

Operating cash flow (OCF) each year = income after tax + depreciation

NPV is are calculated using NPV function in Excel

NPV is -$68,432.80

1 2 3 $2,460,000 2 Initial Investment 3 Cost of fixed asset 4. 5 OCF 6 Revenues 7 - Costs 8 - Depreciation 9 EBIT 10 - Taxes 11 Income after tax 12 + Depreciation 13 OCF 14 15 NPV Analysis 16 Project Cash Flows 17 18 NPV $2,950,000 $1,970,000 $820,000 $160,000 $35,200 $124,800 $820,000 $944,800 $2,950,000 $1,970,000 $820,000 $160,000 $35,200 $124,800 $820,000 $944,800 $2,950,000 $1,970,000 $820,000 $160,000 $35,200 $124,800 $820,000 $944,800 ($2,460,000) $944,800 $944,800 $944,800 $(68,432.80)


Related Solutions

Squaw Valley Recreation is in the process of analyzing a new three year project to grow...
Squaw Valley Recreation is in the process of analyzing a new three year project to grow their business. At the beginning of this project, Squaw Valley will need to spend $2,460,000 to build the required fixed asset. This asset will have a depreciation period of three-years and will use the straight-line method of depreciation and it will be depreciated to zero. The asset will have no salvage value at the end of the project. This new project will have an...
Vail Recreation is analyzing a project that will generate cash flows of $10,650, $11,600, $14,700, and...
Vail Recreation is analyzing a project that will generate cash flows of $10,650, $11,600, $14,700, and $9,200 over each of the next four years, respectively. The profitability index (PI) is the way they analyze their investment projects. The appropriate required return for a project like this is 9 percent. This project has a PI of 1.347. Based on this information provided, determine the Time 0 cost for this project.  
College GameDay is analyzing the costs of a new 3D camera system. This 4-year project has...
College GameDay is analyzing the costs of a new 3D camera system. This 4-year project has an initial asset investment of $391,492, and initial net working capital investment of $37,099, and an annual operating cash flow of -$54,592. The fixed asset is fully depreciated over the life of the project and has no salvage value. The net working capital will be recovered when the project ends. The required return is 15 percent. What is the project's equivalent annual cost (EAC)...
You are analyzing a project with a thirty-year lifetime, with the following characteristics: • The project...
You are analyzing a project with a thirty-year lifetime, with the following characteristics: • The project will require an initial investment of $20 million and additional investments of $5 million in year 10 and $5 million in year 20. • The project will generate earnings before interest and taxes of $3 million each year. (The tax rate is 40%.) • The depreciation will amount to $500,000 each year, and the salvage value of the equipment will be equal to the...
Calculating Project NPV; Considering a a new three year expansion project that requires an initial fixed...
Calculating Project NPV; Considering a a new three year expansion project that requires an initial fixed asset investment of $1.65million. The fixed asset will be depreciated straightline to zero over its three year tax life adfter which it will be worthless. The project is estimated to generate $1.24million in annual sales, with costs of $485,000. The tax rate is 35% and the required return is 12%. What is the NPV? Calculating project cashflow from assets; iN THE PREVIOUS PROBLEM SUPPOSE...
You are analyzing a project with 5-year life. The project requires a capital investment of $10000...
You are analyzing a project with 5-year life. The project requires a capital investment of $10000 now, and it will generate uniform annual revenue of $6000 at the end of each year. Further, the project will have a salvage value of $2500 at the end of the fifth year and it will require $3000 each year for the operation. What is the net value of the project using year 1 as the basis, considering a 10% annual interest rate._________(round your...
Analyzing Project Viability. What are the responsibilities of the project sponsor(s) if a project—when proposed/undertaken—requires new...
Analyzing Project Viability. What are the responsibilities of the project sponsor(s) if a project—when proposed/undertaken—requires new or unproven technologies? What are some of challenges that may arise even if the project’s technology has been previously demonstrated or is deemed standardized? Note: Respond in a short essay of approximately 150 -200 words.
You are analyzing a project with the following cash flows: Year 0:      -240,000 Year 1:      +...
You are analyzing a project with the following cash flows: Year 0:      -240,000 Year 1:      + 10,000 Year 2:      + 55,000 Year 3:      +100,000 Year 4:      +380,000 What is the NPV for this project, using a 15% discount rate? Multiple Choice The Project has an NPV of $69,281 The Project has an NPV of $58,445 The Project has an NPV of $70,617 The Project has an NPV of $93,301 What is the IRR for this project? Multiple Choice The Project...
Firm AAA is considering a new three-year new project that requires an initial fixed asset investment...
Firm AAA is considering a new three-year new project that requires an initial fixed asset investment of $2.28 million. The fixed asset will be depreciated straight-line to zero over its three-year tax life, after which time it will be worthless. The project is estimated to generate $2,120,000 in annual sales, with costs of $745,000. The project requires an initial investment in net working capital of $260,000, and the fixed asset will have a market value of $280,000 at the end...
you are analyzing a project and have this data : year : cash flow 0. :...
you are analyzing a project and have this data : year : cash flow 0. : -40,000 1 : 18,675 2 : 23,900 3. : 21,750 required rate of return = 13 % target payback = 2.0 years point:1+ 1.5 +1.5 + 2 compute following : a) pay back period b) discounted pay back period c) NPV D) IRR OF THIS PROJECT E) ACCEPT OR REJECT PROJECT
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT