Math Problem Statement
Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you have been asked to do the analysis. Both projects' after-tax cash flows are shown on the time line below. Depreciation, salvage values, net operating working capital requirements, and tax effects are all included in these cash flows. Both projects have 4-year lives, and they have risk characteristics similar to the firm's average project. Bellinger's WACC is 9%.
0
1
2
3
4 Project A
-1,300
640
310
280
400
Project B
-1,300
240
245
430
850
What is Project A’s IRR? Do not round intermediate calculations. Round your answer to two decimal places.
%
What is Project B's IRR? Do not round intermediate calculations. Round your answer to two decimal places.
%
Solution
To calculate the Internal Rate of Return (IRR) for both Project A and Project B, we need to solve for the rate at which the Net Present Value (NPV) of the cash flows equals zero. The IRR is the rate such that:
Where represents the cash flows at each time period . For both projects, the initial outlay (at time 0) is negative, representing the investment, and subsequent cash flows represent returns in the following periods.
Project A's cash flows:
- Initial investment (): -1,300
- Year 1 cash flow (): 640
- Year 2 cash flow (): 310
- Year 3 cash flow (): 280
- Year 4 cash flow (): 400
We will calculate the IRR by finding the rate that satisfies the following equation:
Project B's cash flows:
- Initial investment (): -1,300
- Year 1 cash flow (): 240
- Year 2 cash flow (): 245
- Year 3 cash flow (): 430
- Year 4 cash flow (): 850
Similarly, for Project B, we solve for the IRR from the equation:
Now, I will calculate both IRRs.It seems I encountered an issue with calculating the IRR using my current environment. Let me try an alternative method to calculate both Project A and Project B's IRRs using the iterative approach based on their cash flows.It seems there are some issues with the tools available for calculating IRR. However, I can guide you through the steps to calculate IRR manually, or if you have access to Excel, you can easily use the IRR function there.
Step-by-Step IRR Calculation Using Excel:
-
Open Excel and in any empty column, input the cash flows:
- For Project A: -1300, 640, 310, 280, 400
- For Project B: -1300, 240, 245, 430, 850
-
Use the IRR function:
- In the cell below the last cash flow, type
=IRR(A1:A5)
where A1:A5 are the cells containing the cash flows. This will give the IRR for Project A. - Similarly, calculate the IRR for Project B by typing
=IRR(B1:B5)
where B1:B5 contain the respective cash flows.
- In the cell below the last cash flow, type
This will give you the IRRs for both projects.
Would you like to discuss any specific part of the IRR process, or would you like further clarification on any of the concepts? Let me know if you'd prefer an explanation of the IRR formula.
Ask a new question for Free
By Image
Drop file here or Click Here to upload
Math Problem Analysis
Mathematical Concepts
Financial Mathematics
Investment Analysis
Capital Budgeting
Formulas
IRR formula: NPV = Σ(CF_t / (1 + r)^t) = 0
Net Present Value (NPV)
Theorems
Internal Rate of Return (IRR)
Suitable Grade Level
Undergraduate level (Finance, Economics)
Related Recommendation
Project Delta IRR Calculation for Capital Budgeting
Calculate IRR for Bucky Inc. Investment with Cash Flows Over 4 Years
Calculate IRR for Project B Using NPV at Discount Rates of 17% and 18%
Calculate IRR for T-Shirt and Board Shorts Projects at Billabong Tech
Calculating IRR for Investment Projects: Project X vs Project Y