Purchase Solution

Excel - IRR, MIRR

Not what you're looking for?

Ask Custom Question

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.