Math Problem Statement
What is the internal rate of return of Project X, a 3-year project being evaluated by Pink Ocean Sugar? The project would involve an initial investment in equipment of $428,000. To finance the project, Pink Ocean Sugar would borrow $428,000. The firm would receive $428,000 today and pay $565,000 in 3 years (consisting of an interest payment of $137,000 and a principal payment of $428,000). Capital spending would be $0 in year 1 and $0 in year 2. The equipment would be sold for an after-tax cash flow of $82,000 in year 3. Operating cash flows are expected to be 201,000 dollars in year 1, -5,000 dollars in year 2, and 234,000 dollars in year 3. The changes in net working capital are expected to be 24,000 dollars at time 0, 32,000 dollars in year 1, -19,000 dollars in year 2, and -37,000 dollars in year 3. The cost of capital for the project is 10.32 percent and the interest rate on the loan would be 9.7 percent.
Solution
To calculate the Internal Rate of Return (IRR) for Project X, we need to organize the cash flows of the project and solve for the discount rate that makes the Net Present Value (NPV) equal to zero. Here's how we approach this:
Step 1: Cash Flow Breakdown
-
Initial Investment:
- Equipment cost:
- Change in Net Working Capital (NWC) at time 0:
Net cash flow at time 0 = -428,000 - 24,000 = -452,000.
-
Yearly Operating Cash Flows:
- Year 1: Operating cash flow , change in NWC (outflow).
Net cash flow = 201,000 - 32,000 = +169,000. - Year 2: Operating cash flow , change in NWC (inflow).
Net cash flow = -5,000 + 19,000 = +14,000. - Year 3: Operating cash flow , equipment salvage value , loan repayment , change in NWC (inflow).
Net cash flow = 234,000 + 82,000 - 565,000 + 37,000 = -212,000.
- Year 1: Operating cash flow , change in NWC (outflow).
Step 2: Cash Flow Summary
We now have the following cash flows:
Year | Cash Flow ($) |
---|---|
0 | |
1 | |
2 | |
3 |
Step 3: IRR Calculation
The IRR is the discount rate () that satisfies the equation:
This is a trial-and-error or computational process. Let’s compute IRR using a numerical approach.
I will calculate this and provide the IRR.from numpy_financial import irr
Cash flows of the project
cash_flows = [-452000, 169000, 14000, -212000]
Calculate IRR
internal_rate_of_return = irr(cash_flows)
Convert IRR to percentage
internal_rate_of_return_percentage = internal_rate_of_return * 100 internal_rate_of_return_percentagenannansuccessIt seems there was an issue with the calculation, as the IRR function may have difficulty converging due to the unconventional cash flow pattern. Let me try a more nuanced numerical approach to resolve this.import scipy.optimize as opt
Define the NPV function
def npv(rate, cashflows): return sum(cf / (1 + rate)**t for t, cf in enumerate(cashflows))
Define the IRR function (NPV = 0)
def irr_solver(cashflows): return opt.newton(lambda r: npv(r, cashflows), 0
Ask a new question for Free
By Image
Drop file here or Click Here to upload
Math Problem Analysis
Mathematical Concepts
Internal Rate of Return (IRR)
Net Present Value (NPV)
Cash Flow Analysis
Time Value of Money
Formulas
NPV = Σ (CF_t / (1 + r)^t)
IRR is the rate (r) such that NPV = 0
Theorems
Time Value of Money
Suitable Grade Level
College-Level Finance or Advanced High School Economics