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

  1. Initial Investment:

    • Equipment cost: 428,000-428,000
    • Change in Net Working Capital (NWC) at time 0: 24,000-24,000
      Net cash flow at time 0 = -428,000 - 24,000 = -452,000.
  2. Yearly Operating Cash Flows:

    • Year 1: Operating cash flow +201,000+201,000, change in NWC +32,000+32,000 (outflow).
      Net cash flow = 201,000 - 32,000 = +169,000.
    • Year 2: Operating cash flow 5,000-5,000, change in NWC 19,000-19,000 (inflow).
      Net cash flow = -5,000 + 19,000 = +14,000.
    • Year 3: Operating cash flow +234,000+234,000, equipment salvage value +82,000+82,000, loan repayment 565,000-565,000, change in NWC 37,000-37,000 (inflow).
      Net cash flow = 234,000 + 82,000 - 565,000 + 37,000 = -212,000.

Step 2: Cash Flow Summary

We now have the following cash flows:

YearCash Flow ($)
0452,000-452,000
1+169,000+169,000
2+14,000+14,000
3212,000-212,000

Step 3: IRR Calculation

The IRR is the discount rate (rr) that satisfies the equation:

NPV=t=0nCFt(1+r)t=0NPV = \sum_{t=0}^n \frac{CF_t}{(1 + r)^t} = 0

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