Question
Answer in Excel, please You have been asked by the president of Ellis Construction Company, headquartered in Toledo, to evaluate the proposed acquisition of a
Answer in Excel, please
You have been asked by the president of Ellis Construction Company, headquartered in Toledo, to evaluate the proposed acquisition of a new earthmover. The movers basic price is $750,000, and it will cost another $100,000 to modify it for special use by Ellis Construction. The mover falls into the MACRS 5-year class. It will be sold after 5 years for $200,000, and it will require an increase in working capital (spare parts inventory) of $50,000, which will be recovered in full at the end of the projects life. The earthmover purchase will have no effect on revenues, but it is expected to save Ellis $420,000 per year in before-tax operating costs. Elliss marginal tax rate is 30%. The cost of capital (discount rate) is 11%. Use the following 5-year MACRS schedule: 20%, 32%, 19.2%, 11.52%, 11.52%, and 5.76%.
Compute the NPV and IRR of the project. Would you ask the president to buy the equipment?
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