What is the IRR of the following set of cash flows? Year Cash Flow0 –$9,503 1 4,300 2 5,500 3 3,900
Question
What is the IRR of the following set of cash flows?
Year Cash Flow
0 –$9,503
1 4,300
2 5,500
3 3,900
Solution
The Internal Rate of Return (IRR) is the discount rate that makes the Net Present Value (NPV) of a series of cash flows equal to zero. It's the rate at which the present value of future cash inflows equals the initial investment outflow.
Here's how to calculate it:
-
Set up the equation for NPV, which is the sum of the present values of all cash flows. The equation is: NPV = CF0 + CF1/(1+r) + CF2/(1+r)^2 + CF3/(1+r)^3 + ... + CFn/(1+r)^n = 0
-
Substitute the given cash flows into the equation: 0 = -9503 + 4300/(1+r) + 5500/(1+r)^2 + 3900/(1+r)^3
-
Solve the equation for r.
Unfortunately, this equation can't be solved algebraically for r when there are more than two cash flows. You'll need to use a financial calculator or software like Excel to find the IRR.
In Excel, you can use the IRR function. Enter the cash flows in a single row or column, and then use the IRR function on that range. The function will return the IRR.
Please note that the IRR calculation assumes that all cash flows are reinvested at the IRR rate, which may not be realistic.
Similar Questions
Filter Corporation has a project available with the following cash flows:Year Cash Flow0 −$16,2001 5,6002 6,9003 6,3004 4,700 What is the project's IRR?
Which of the following account is carried forward to next year? Drawings Sales Interest income Machinery
The statement of cash flows measures cash flows on a(n) _____ basis.Group of answer choicescashseasonalaccrualnormalized
Find the present value of the cash flow shown below if interest rate (𝑖) is 10% per year. Year Cash 1 2000 2 5000 3 0 4 -2000 5 3000
Based upon the following data: calculate the Profitability Index. Cost = $325Present value of future cash flows = $350
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.