Explore BrainMass

Calculating the Internal Rate of Return

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

You are a boss of a restaurant considering the purchase of a self-ordering machine.
The upfront cost is estimated to be $23,828.
The machine will increase revenues by $10,000 per year and incur a maintenance cost of $4,000 every year.
The machine has a 5-year useful life after which can be sold for $2,000.
The project has a negative NPV at 12%.
Whats is IRR?
Ignore taxes

© BrainMass Inc. brainmass.com October 15, 2018, 1:39 pm ad1c9bdddf - https://brainmass.com/business/capital-budgeting/calculating-internal-rate-return-398746

Solution Summary

This solution illustrates how to compute a project's internal rate of return using Excel 97-2003.