Nicholson roofing materials, inc , is considering two mutually exclusive projects , each with an initial investment of $150,000 The company's board of directors has set a maximum 4 year payback requirement and has set its cost of capital at 9 The cash inflows associated with the two projects are shown in the following table Year Project A Project B 1 45000 75000 2 45000 60000 3 45000 30000 4 45000 30000 5 45000 30000 6 45000 30000 a Calculate the payback period for each project b Calculate the NPV of each project at 0 c Calculate the NPV of each project at 9 d Derive the IRR of each project e Rank the projects by each of hte techniques used Make and justify a recommendation F Go back one more time and calculate the NPV of each prject using a cost of capital of 12 Does the ranking of the two projects change compared ot your answer in part e Why Please show work in Excel

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

Question: Nicholson roofing materials, inc., is considering two mutually exclusive projects., each with an initial investment of $150,000. The company's board of directors has set a

Nicholson roofing materials, inc., is considering two mutually exclusive projects., each with an initial investment of $150,000. The company's board of directors has set a maximum 4-year payback requirement and has set its cost of capital at 9%. The cash inflows associated with the two projects are shown in the following table

Year	Project A	Project B
1	45000	75000
2	45000	60000
3	45000	30000
4	45000	30000
5	45000	30000
6	45000	30000

a. Calculate the payback period for each project.

b. Calculate the NPV of each project at 0%

c. Calculate the NPV of each project at 9%

d. Derive the IRR of each project.

e. Rank the projects by each of hte techniques used. Make and justify a recommendation.

F. Go back one more time and calculate the NPV of each prject using a cost of capital of 12%. Does the ranking of the two projects change compared ot your answer in part e? Why?

Please show work in Excel.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

MY QUESTION IS POSTED BELOW. All techniques, conflicting rankings: Nicholson Roofing Materials, Inc., is considering two mutually exclusive projects, each with an initial investment of $120,000. The...

All techniques, conflicting rankings Nicholson Roofing Materials, Inc., is considering two mutually exclusive projects, each with an initial investment of $150,000. The company's board of directors...

All techniques, conflicting rankings Nicholson Roofing Materials, Inc, is considering two mutually exclusive projects, each with an initial investment of $180,000. The company's board of directors...

Hi. I need help with my Finance work including net present value. Thanks! P10-2 Payback comparisons Nova Products has a 5-year maximum acceptable payback period. The firm is considering the purchase...

Nicholson Roofing Materials, Inc., is considering two mutually exclusive projects, each with an initial investment of $100000. The company's board of directors has set a 4-year payback requirement...

All techniques, conflicting rankings Nicholson Roofing Materials, Inc., is considering two mutually exclusive projects, each with an initial investment of $180,000. The company's board of directors...

All techniques, conflicting rankings. Nicholson Roofing Materials, Inc. is considering two mutually exclusive projects, each with an initial investment of $110,000. The company's board of directors...

mathod.com/Student/PlayerHomework.aspx?homeworkid=552149697&questionid2flushed fakecd58... a FIN 450 Spring 2020 11AM Ernesto Simental & I 02/23/20 11:26 PM Save Homework: Homework 4 Score: 0 of 1 pt...

Complete the following problems from chapter 10 in the textbook: P10-4 P10-10 P10-11 P10-15 P10-21 P10-24 Follow these instructions for completing and submitting your assignment: Do all work in...

let B PCX) bare for tome " under topology What Condition ? a

Recognizing that overloading commercial aircraft would lead to unsafe flights, you want to determine the average (mean) weight of airline passengers. Describe how you would apply the five basic steps...

21. Antonello Clothiers began operations on June 1, 20X1. During June, Antonello Clothiers reported the following: Purchases of merchandise inventory, at cost $100,000 Purchases returns, at cost...

Which project management tool uses the analogy "skateboard - bicycle - motorcycle - car"? Group of answer choices Scrum Waterfall Fate - Gate Star - gate

Realize that even in a small- or medium-sized business, age-friendly and inclusive human resource management practices can be adopted.

In the coming years, On Cheongs loyal and mature employees will grow older and some might choose to retire. Six employees are already over 70, and 15 are over the age of

It also seems likely that the next generation of employees may not stay with On Cheong for decades, or for life. How might this affect or change On Cheongs culture, which has emphasized warm,...