Read Problem 10 -19A and answer question below the scenario is attach below.
Use Microsoft® Excel®showing all work and formulasto 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 a 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 a 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.