Math Problem Statement
The directors of Hybrid Ltd intend expanding the company and they have the choice of investing in one of two projects at the start of 2025 viz. Project A or Project B. Each project is expected to have a five-year life, with only Project A having a residual/scrap value of R300 000. The annual cash inflows from each project are estimated at R3 100 000. The company desires a minimum rate of return of 14%. Project A is anticipated to cost R4 800 000 excluding R300 000 for installation. The annual cash outflows are estimated to be R1 300 000 for year one. These cash outflows are expected to increase by R100 000 per year thereafter. Depreciation is estimated to be R960 000 per year. Project B cost is expected to cost R5 100 000 including R400 000 for installation. The annual cash outflows are estimated to be R1 500 000. Depreciation is estimated to be R1 020 000 per year. Calculate Internal Rate of Return of Project B (expressed to two decimal places ) using discount rates of 17% and 18% only. Your answer must include two net present value calculations and the determination of the IRR.
Solution
To calculate the Internal Rate of Return (IRR) for Project B, we first need to follow the general steps for determining IRR through net present value (NPV) calculations at two different discount rates, 17% and 18%. The IRR is the rate at which the NPV equals zero. Since we're given cash flows and costs, we will start by calculating the NPVs at both discount rates.
Step 1: Identify the relevant cash flows for Project B
- Initial cost: R5,100,000 (including R400,000 for installation).
- Annual cash inflows: R3,100,000 per year for 5 years.
- Annual cash outflows: R1,500,000 per year for 5 years.
- Net annual cash flows (inflows - outflows):
per year. - Depreciation: Depreciation is not a cash flow and won't affect the NPV calculation.
Therefore, we are working with annual net cash flows of R1,600,000 for 5 years.
Step 2: Calculate NPVs at 17% and 18%
NPV Formula
The formula for NPV is:
where:
- (constant for 5 years)
- (either 17% or 18%)
NPV at 17%
We substitute :
Let's compute this step-by-step.
NPV at 18%
Similarly, we substitute :
I'll now calculate both NPVs and proceed to determine the IRR.The calculated NPVs are as follows:
- NPV at 17%: R18,953.86
- NPV at 18%: -R96,526.37
Step 3: Determine the IRR
We can now use the interpolation formula to estimate the IRR between the two discount rates:
where:
- ,
- ,
I'll now calculate the IRR using this formula.The Internal Rate of Return (IRR) for Project B is approximately 17.16%.
Summary of results:
- NPV at 17%: R18,953.86
- NPV at 18%: -R96,526.37
- IRR: 17.16%
If you have any questions or need further clarification, feel free to ask!
Here are 5 related questions you could explore:
- How would the IRR change if the cash inflows or outflows were different?
- What does a positive NPV at 17% suggest about Project B?
- How would a longer project duration (e.g., 10 years) affect the IRR calculation?
- What is the impact of depreciation on the project's financial evaluation?
- How does the IRR compare to other project evaluation methods like payback period or ROI?
Tip: The IRR is a good measure to compare projects, but it’s always important to consider the NPV as well, especially when deciding between different discount rates.
Ask a new question for Free
By Image
Drop file here or Click Here to upload
Math Problem Analysis
Mathematical Concepts
Finance
Net Present Value (NPV)
Internal Rate of Return (IRR)
Formulas
NPV = -Initial Cost + Σ (Net Cash Flow / (1 + r)^t)
IRR = r1 + (NPV1 / (NPV1 - NPV2)) * (r2 - r1)
Theorems
-
Suitable Grade Level
Undergraduate/Graduate (Finance or Accounting)
Related Recommendation
Internal Rate of Return (IRR) Calculation Using 17% and 18% Discount Rates for Project B
IRR Calculation for Project B Using Discount Rates of 17% and 18%
Project Delta IRR Calculation for Capital Budgeting
Internal Rate of Return Calculation for a 7-Year Project Using a Factor of 5.033
Calculate IRR for a Capital Budgeting Project with a 5-Year Annuity