Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Step: 3

blur-text-image

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

School Finance And Business Management Optimizing Fiscal Facility And Human Resources

Authors: Craig A. Schilling, Daniel R. Tomal

2nd Edition

1475844026, 978-1475844023

Students also viewed these Finance questions