Calculating IRR with MACRS for Long Branch Farm
Not what you're looking for?
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 $20,500 annually, although operating expenses other than depreciation will also increase by $5,000. The system will be depreciated using MACRS over its depreciate life (5 years) to a zero salvage value. If the tax rate on ordinary income is 40 percent, what is the project's IRR?
Purchase this Solution
Solution Summary
This solution provides an example of how to calculate the internal rate of return (IRR) with MACRS for a given business. The solution is formatted in Excel, and displays how to use the functions of the program.
Solution Preview
-1.32
See worksheet to see how it was computed.
MACRS Depreciable Annual
Year Percent Basis Depreciation
1 0.2 $100,000 $20,000
2 0.32 100,000 $32,000
3 0.19 100,000 $19,000
4 0.12 100,000 $12,000
5 0.11 100,000 $11,000
6 0.06 100,000 $6,000
$100,000 ...
Purchase this Solution
Free BrainMass Quizzes
Production and cost theory
Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.
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.
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.