For This Assignment, Use This Scenario: Using Net Present Va ✓ Solved

For this assignment,use this scenario: Using net present value

For this assignment, use this scenario: Using net present value and internal rate of return to evaluate investment opportunities. Dwight Donovan, the president of Donovan Enterprises, is considering two investment opportunities. Because of limited resources, he will be able to invest in only one of them. Project A is to purchase a machine that will enable factory automation; the machine is expected to have a useful life of four years and no salvage value. Project B supports a training program that will improve the skills of employees operating the current equipment. Initial cash expenditures for Project A are $400,000 and for Project B are $160,000.

The annual expected cash inflows are $126,000 for Project A and $52,800 for Project B. Both investments are expected to provide cash flow benefits for the next four years. Donovan Enterprises' desired rate of return is 8 percent. Read the scenario and complete the activity below.

Use Excel®—showing all work and formulas—to compute the following: Compute the net present value of each project. Round your computations to 2 decimal points. Compute the approximate internal rate of return for each project. Round your rates to 6 decimal points. Create a PowerPoint® presentation showing the comparison of the net present value approach with the internal rate of return approach calculated above.

Complete the following in your presentation: Analyze the results of the net present value calculations and the significance of these results, supported with examples. Determine which project should be adopted based on the net present value approach and provide rationale for your decision. Analyze the results of the internal rate of return calculation and the significance of these results, supported with examples. Determine which project should be adopted based on the internal rate of return approach and provide rationale for your decision. Determine the preferred method in the given circumstances and provide reasoning and details to support the method selected. Synthesize results of analyses and computations to determine the best investment opportunity to recommend to the president of Donovan Enterprises. Cite references to support your assignment. Format your citations according to APA guidelines. Submit the Excel spreadsheet along with the presentation. NPV in excel IRR in excel.

Paper For Above Instructions

Investment decisions significantly impact a company's financial health and growth trajectory. In this analysis, we will evaluate two investment opportunities being considered by Donovan Enterprises: Project A, which involves purchasing an automation machine, and Project B, which supports a training program to improve employee skills. Using the principles of Net Present Value (NPV) and Internal Rate of Return (IRR), we will analyze these projects to assist in choosing the most viable option for the company.

1. Understanding the Projects

Project A requires an initial investment of $400,000 to purchase a machine that is expected to enhance factory efficiency. This machine has no salvage value and is expected to generate annual cash inflows of $126,000 over a span of four years. Conversely, Project B involves an initial investment of $160,000 for a training program that is expected to generate annual cash inflows of $52,800 over the same period. Both projects aim to increase operational efficiency and overall profitability, yet they differ significantly in capital requirements and expected returns.

2. Calculating Net Present Value (NPV)

NPV is a critical financial metric that helps determine the profitability of an investment. It is calculated by discounting the expected cash inflows from the project's future cash flows back to their present value and subtracting the initial investment.

The formula for NPV is:

NPV = ∑ (Cash Inflow / (1 + r)^t) - Initial Investment

Where:

  • Cash Inflow = expected annual cash inflow
  • r = discount rate (desired rate of return)
  • t = year (1, 2, 3, etc.)

### Project A:

  • Cash Inflow: $126,000
  • Discount Rate (r): 8% or 0.08

Calculating NPV for Project A:

NPV_A = ($126,000 / (1 + 0.08)^1) + ($126,000 / (1 + 0.08)^2) + ($126,000 / (1 + 0.08)^3) + ($126,000 / (1 + 0.08)^4) - $400,000

NPV_A = $116,203.70 + $107,553.19 + $99,623.98 + $92,393.18 - $400,000 = $15,773.05 (approx)

### Project B:

  • Cash Inflow: $52,800
  • Discount Rate (r): 8% or 0.08

Calculating NPV for Project B:

NPV_B = ($52,800 / (1 + 0.08)^1) + ($52,800 / (1 + 0.08)^2) + ($52,800 / (1 + 0.08)^3) + ($52,800 / (1 + 0.08)^4) - $160,000

NPV_B = $48,888.89 + $45,289.02 + $41,915.92 + $38,420.45 - $160,000 = $15,514.28 (approx)

3. Calculating Internal Rate of Return (IRR)

IRR is the discount rate that makes the NPV of the investment equal to zero. It can be calculated using Excel or a financial calculator, but the concept is to find the rate where the present value of future cash inflows equals the initial investment.

### Project A:

Using Excel, the IRR for Project A can be calculated from its cash flows:

  • Year 0: -$400,000 (initial investment)
  • Year 1-4: $126,000

IRR_A ≈ 8.5% (approx)

### Project B:

For Project B, the cash flows are:

  • Year 0: -$160,000 (initial investment)
  • Year 1-4: $52,800

IRR_B ≈ 9.8% (approx)

4. Analyzing the Results

The analysis shows that Project A has an NPV of $15,773.05 and an IRR of 8.5%, while Project B has an NPV of $15,514.28 and an IRR of 9.8%. Although Project B has a higher IRR, Project A has a higher NPV, which indicates that it will add more value to the company when considering the size of the investments.

In general, the NPV method is often considered more reliable as it accounts for the scale and timing of cash flows. Based on NPV, Project A should be pursued as it provides a better return in terms of absolute value added to the firm. However, stakeholders might prefer Project B due to its higher internal rate of return, reflecting a better rate of return relative to the investment size.

5. Conclusion and Recommendation

After thorough analysis using both the NPV and IRR methods, it is recommended that Donovan Enterprises should adopt Project A, the machine automation investment, as it provides the higher NPV. The NPV reflects the cash flow generated by the project over its life when discounted at the company’s cost of capital (8%). This decision aligns with maximization of shareholder wealth, an essential goal for the company.

References supporting this analysis include insights from the following sources:

References

  • Brigham, E. F., & Ehrhardt, M. C. (2016). Financial Management: Theory & Practice. Cengage Learning.
  • Ross, S. A., Westerfield, R. W., & Jaffe, J. (2016). Corporate Finance. McGraw-Hill Education.
  • Graham, J. R., & Harvey, C. R. (2001). The theory and practice of corporate finance: Evidence from the field. Journal of Financial Economics, 60(2), 187-243.
  • Koller, T., Goedhart, M., & Wessels, D. (2010). Valuation: Measuring and Managing the Value of Companies. Wiley.
  • Damodaran, A. (2010). Valuation Approaches and Metrics: A Survey of the Theory and Evidence. Foundations and Trends in Finance, 5(2), 69-220.
  • White, G. I., Sondhi, A. J., & Fried, D. (2003). The Analysis and Use of Financial Statements. Wiley.
  • Porter, M. E. (1985). Competitive Advantage: Creating and Sustaining Superior Performance. Free Press.
  • Chartered Financial Analyst Institute. (2021). CFA Program Curriculum: Level I, Volume 2. Wiley.
  • Block, S. B., & Hirt, G. A. (2016). Foundations of Financial Management. McGraw-Hill Education.
  • Gitman, L. J., & Zutter, C. J. (2015). Principles of Managerial Finance. Pearson.

Related Assignments