Microsoft 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
 
• For this assignment, refer to the scenario located in  "Planning for Capital Investments" of Fundamental Managerial Accounting Concepts. This scenario puts you at the task as a Senior Accountant for Donovan Enterprises to identify the preferred method and best investment opportunity for the company.