Purchase Solution

NPV and IRR in Excel

Not what you're looking for?

Ask Custom Question

After a long drought, the manager of Long Branch Farm is considering the installation of an irrigation system which will cost $100,000. It is estimated that the irrigation system will increase revenues by $21,500 annually, although operating expenses other than depreciation will increase by $5,000. The system will be depreciated using MACRS over its depreciable life (5 years) to a zero salvage value although management hopes to sell the used system for $15,000 at the end of 5 years. If the tax rate is 35 percent, what is the project's NPV at a rate of 9.5% and what is the IRR?

Note: The MACRS depreciation percentages are as follows:

Year MACRS
Percent
1 20%
2 32%
3 19%
4 12%
5 11%
6 6%

Purchase this Solution

Solution Summary

This solution provides step by step calculations for NPV and IRR in Excel.

Purchase this Solution


Free BrainMass Quizzes
Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

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.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.