Please use Excel functions like PV A company is considering two capital budgeting projects Each project requires an initial outlay of $4,000,000 Cash inflows for each project are given in the table below Each project has a life of 3 years The company uses the NPV method to evaluate capital budgeting projects and its required rate of return is 9 Here are the cash inflows from the projects Project A Project B Year 1 $1,900,000 0 Year 2 $1,900,000 0 Year 3 $1,900,000 $6,000,000 Perform all relevant calculations to determine NPV for each project Show all work and perform all time value computations using the time value functions in Excel If the projects are independent, which, if any, should the company accept Why If the projects are mutually exclusive, which, if any, should the company accept Why One of the companys managers states To me, no matter what else we do, Project B needs to be our first choice because it has the largest cash inflows of $6,000,000 Comment on this managers proposal, considering the tenets of NPV and based on your computations

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 02, 2024

Please use Excel functions like PV A company is considering two capital budgeting projects. Each project requires an initial outlay of $4,000,000. Cash inflows for

Please use Excel functions like PV

A company is considering two capital budgeting projects. Each project requires an initial outlay of $4,000,000. Cash inflows for each project are given in the table below. Each project has a life of 3 years. The company uses the NPV method to evaluate capital budgeting projects and its required rate of return is 9%. Here are the cash inflows from the projects.

Project A Project B

Year 1 $1,900,000 0

Year 2 $1,900,000 0

Year 3 $1,900,000 $6,000,000

Perform all relevant calculations to determine NPV for each project. Show all work and perform all time value computations using the time value functions in Excel.
If the projects are independent, which, if any, should the company accept? Why?
If the projects are mutually exclusive, which, if any, should the company accept? Why?
One of the companys managers states To me, no matter what else we do, Project B needs to be our first choice because it has the largest cash inflows of $6,000,000. Comment on this managers proposal, considering the tenets of NPV and based on your computations.