Calculations to determine npv for each project

Assignment Help Financial Management

Reference no: EM132047342

All answers need to be calculated in Excel. Show all work please.

A company is considering three 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 Project C Year 1 $1,900,000 0 $1,000,000 Year 2 $1,900,000 0 $2,000,000 Year 3 $1,900,000 $6,000,000 $2,000,000

1. 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.

2. If the projects are independent, which, if any, should the company accept? Why?

3. If the projects are mutually exclusive, which, if any, should the company accept? Why?

4. One of the company’s 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 manager’s proposal, considering the tenets of NPV and based on your computations.

5. This one has nothing to do with the foregoing data. Give an example of a capital budgeting project that would be considered “independent”. Give an example of a capital budgeting project that would be considered “mutually exclusive”. No explanation is needed, but be sure your descriptions of the projects you have identified is clear so that I can see why one is independent and one is mutually exclusive.

Reference no: EM132047342

Questions Cloud

Prepare journal entries for the transactions : The inventory on hand at the close of business on May 31 is USD 299,040. Prepare journal entries for the transactions

Describe the sampling methods in your own words : Using the empirical research article, focus on the sampling method in the study and begin to evaluate the sampling method by answering the following.

What is the couple tax refund : Fred, Betty's son, who lives with the couple, aged 12. Fred's father is deceased.

Discuss strengths of current risk assessment practices : How can you utilize or build upon the strengths of current risk assessment practices in forensic psychology? How can you account for the weaknesses.

Calculations to determine npv for each project : erform all relevant calculations to determine NPV for each project.

What is the duration of the insurance company liability : What is the duration of the insurance company’s liability when it is first issued? Duration of the liability year(s) ?

How is default risk different from systematic risk : Elaborate on default risk of a firm. How is default risk different from systematic risk?

Discuss premise and limitations of nondirective interviewing : Discuss the premise, benefit, and limitations of nondirective interviewing. To what extent do basic interviewing methods align with core conditions.

Find a current policy development in the accounting industry : Find a current policy development in the accounting industry. In your Discussion posting, provide background on the policy development

User Account

All Pages