In: Finance
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.)
Solution :
The NPV for the project is = - $ 68,432.80
Please find the attached screenshot of the excel sheet containing the detailed calculation for the solution.