Chapter 24, Problem 5PSA

I am trying to find the accurate solution to this general accounting problem with appropriate explanations.

Using Excel showing all work and formulas to compute the following How can I Compute the net present value of each project. Rounding computations to 2 decimal points. And Compute the approximate internal rate of return for each project. Round your rates to 6 decimal points   Base on this Scenario: Dwight Donovan, the president of Donovan Enterprises, is considering 2 investment opportunities. Because of limited resources, he will be able to invest in only 1 of them. Project A is to purchase a machine that will enable factory automation; the machine is expected to have a useful life of 4 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 4 years. Donovan…

Compute the variable cost per unit