Math Problem Statement
Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined by his division’s return on investment (ROI), which has been above 24% each of the last three years. Casey is considering a capital budgeting project that would require a $5,850,000 investment in equipment with a useful life of five years and no salvage value. Pigeon Company’s discount rate is 20%. The project would provide net operating income each year for five years as follows:
Sales $ 5,200,000 Variable expenses 2,320,000 Contribution margin 2,880,000 Fixed expenses: Advertising, salaries, and other fixed out-of-pocket costs $ 880,000 Depreciation 1,170,000 Total fixed expenses 2,050,000 Net operating income $ 830,000 Click here to view Exhibit 7B-1 and Exhibit 7B-2, to determine the appropriate discount factor(s) using tables.
Required:
What is the project’s internal rate of return to the nearest whole percent?
Solution
To determine the internal rate of return (IRR) for the project, we need to identify the discount rate that results in a net present value (NPV) of zero. The formula for NPV is:
Where:
- is the internal rate of return (IRR).
- is the year (1 to 5 in this case).
- Net Cash Inflow = Net Operating Income + Depreciation (because depreciation is a non-cash expense).
Step 1: Calculate the annual net cash inflows
From the given information:
- Net Operating Income = $830,000
- Depreciation = $1,170,000
The net cash inflow each year is:
Step 2: Apply the formula for NPV
We know the initial investment is $5,850,000 and the project provides annual net cash inflows of $2,000,000 for five years. To find the IRR, we need to solve for the discount rate where the NPV equals 0:
Step 3: Use the Present Value of Annuity formula
We need to find the discount rate () such that the present value of an annuity of $2,000,000 over five years equals the initial investment of $5,850,000.
Using annuity tables or trial and error, we can estimate the rate by checking the factor that will yield:
Step 4: Locate the corresponding IRR from Annuity Tables
By consulting the annuity tables, we look for a 5-year annuity factor close to 2.925. This factor corresponds to an interest rate of approximately 24%.
Conclusion:
The project’s internal rate of return (IRR) is approximately 24%.
Would you like more details on any specific part of this process?
5 Related Questions:
- How does the IRR compare to the company’s discount rate of 20%?
- What would be the net present value (NPV) if the discount rate were 20%?
- How does depreciation impact the cash flow of a project?
- What are the risks of relying solely on IRR for capital budgeting decisions?
- What other financial metrics could Casey use to evaluate the project?
Tip:
When evaluating a project, it’s essential to consider both the IRR and the NPV to get a full picture of its potential profitability.
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)
Present Value of Annuity
Capital Budgeting
Formulas
NPV = ∑ (Net Cash Inflow / (1 + r)^t) - Initial Investment
Net Cash Inflow = Net Operating Income + Depreciation
Annuity Factor = (1 - (1 + r)^-n) / r
Theorems
Present Value of Annuity Theorem
Suitable Grade Level
Undergraduate Finance or Business Studies
Related Recommendation
Internal Rate of Return Calculation for a 7-Year Project Using a Factor of 5.033
Calculate NPV and IRR for Big Steve's Swizzle Sticks Investment
Calculate the IRR for an 8-Year Project with $700,000 Investment
Calculate the Internal Rate of Return (IRR) for Project A with Cash Flows
Calculate the Internal Rate of Return (IRR) for Project B in 2025