Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please work in Excel. Please use the appropriate Excel functions. Your company manufactures roller - roller skatesskates. You are studying the possibility of selling a
Please work in Excel. Please use the appropriate Excel functions.
Your company manufactures rollerroller skatesskates. You are studying the possibility of selling a new product with a revolutionary rolling system.
To start off the new project, you are able to use a piece of land that your company bought years ago for $ and that is currently vacant. The company would need to spend $ on building a factory on the piece of land, as well as $ on purchasing new equipment. Some older equipment used for the current production could also be repurposed for the new project. Forgoing the use of the older equipment for the current production would increase the cost of current production by $ per year.
In addition, the project would also require a $ investment in working capital, amount that will be recovered at the end of the project.
Once started, the project is estimated to generate revenues of $ per year and would incur expenses of $ per year for years. At the end of the years, the land, the factory and the new equipment would be sold for $ $ and $ respectively. The old equipment being repurposed is already fully depreciated and considered worthless. The factory and the new equipment are to be depreciated with the straight line depreciation method over years.
The tax rate is The opportunity cost of capital for this kind of project is Considering its NPV and IRR, is this project worth undertaking? Please show your calculations.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started