Background Data
COMM Company is considering an investment in a new inventory control system. The system will require a substantial up-front investment but is expected to provide annual cash cost savings for the next 6 years. At the end of that year (year 6) the used system is likely to be outdated (but still functional) and will be sold for an estimated 10% of original cost. (The equipment is sold at the end of year 6) The system falls under the 7 year IRS depreciation guidelines (assume straight line depreciation full year every year). (Congress mandates tax related depreciation guidelines). The system is expected to become operational at a cost of $2,100,000. Annual cash cost savings (primarily due to labor cost savings) are expected to average $500,000. COMM is in the 35% combined federal and state tax bracket and uses a hurdle rate of 10% to evaluate capital projects.
Required
1. Prepare an exhibit that displays the outcome of your capital budgeting model’s NPV related calculations. The exhibit should clearly show each event that has a cash flow impact and the project's Net Present Value (you can use the model we developed in class or set up your own MS Excel model).
2. Is the project’s IRR more or less than the hurdle rate of 10%? How do you know? Within a range of 1 percentage point (for example 6% - 7%) where does the IRR on this project fall?
3. Capital Budgeting models (like all forecasts) are driven primarily by educated assumptions about outcomes. Which actual outcomes are most subject to deviation from expected outcomes? Why?