Excel - IRR, MIRR
Not what you're looking for?
Existing equipment from a company could be sold for $50,000 after taxes. As of today, management forecasts call for after-tax cash flows of $15,000 next year if the current machinery is retained. The cash flows are expected to increase at a rate of 6% per year for the next five years. The new machinery under consideration has a price of $70,000. It would be expected to produce cash flows of $20,000 next year, and the cash flows would grow by 8% per year for the next five years.
a. Calculate the net present value, IRR, and MIRR of the existing equipment.
b. Calculate the net present value, IRR and MIRR of the new equipment.
Purchase this Solution
Solution Summary
The solution calculaes the net present value, IRR and MIRR of the new and existing equipment on an excel spread sheet.
Solution Preview
a. Calculate the net present value, IRR, and MIRR of the existing equipment.
Year Project ...
Purchase this Solution
Free BrainMass Quizzes
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
Learning Lean
This quiz will help you understand the basic concepts of Lean.
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.