NPV, with rankings Botany Bay, Inc., a maker of casual clothing, is considering

Question

NPV, with rankings Botany Bay, Inc., a maker of casual clothing, is considering four projects shown in the following table,?. Because of past financial difficulties, the company has a high cost of capital at 14.3% a. Calculate the NPV of each project, using a cost of capital of 14.3%. b. Rank acceptable projects by NPV c. Calculate the IRR of each project and use it to determine the highest cost of capital at which all of the projects would be acceptable 1Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Project A $49,100 Project B $100,500 Project C $80,400 Project D $180,600 initial investment (CF) Year (t) $20,500 $20,500 $20,500 Cash inflows (CF) $36,800 $51,400 $50,600 $20,100 $40,300 $59,200 $100,400 $80,100 $60,200

Explanation / Answer

Answer a.

Project A:

NPV = -$49,100 + $20,500/1.143 + $20,500/1.143^2 + $20,500/1.143^3
NPV = -$1,745.10

Project B:

NPV = -$100,500 + $36,800/1.143 + $51,400/1.143^2 + $50,600/1.143^3
NPV = $4,924.60

Project C:

NPV = -$80,400 + $20,100/1.143 + $40,300/1.143^2 + $59,200/1.143^3
NPV = $7,676.78

Project D:

NPV = -$180,600 + $100,400/1.143 + $80,100/1.143^2 + $60,200/1.143^3
NPV = $8,864.43

Answer b.

Rank of Projects: Project A < Project B < Project C < Project D

Answer c.

Project A:

Let IRR be i%

NPV = -$49,100 + $20,500/(1+i) + $20,500/(1+i)^2 + $20,500/(1+i)^3
0 = -$49,100 + $20,500/(1+i) + $20,500/(1+i)^2 + $20,500/(1+i)^3

Using financial calculator, i = 12.16%

IRR = 12.16%

Project B:

Let IRR be i%

NPV = -$100,500 + $36,800/(1+i) + $51,400/(1+i)^2 + $50,600/(1+i)^3
0 = -$100,500 + $36,800/(1+i) + $51,400/(1+i)^2 + $50,600/(1+i)^3

Using financial calculator, i = 17.05%

IRR = 17.05%

Project C:

Let IRR be i%

NPV = -$80,400 + $20,100/(1+i) + $40,300/(1+i)^2 + $59,200/(1+i)^3
0 = -$80,400 + $20,100/(1+i) + $40,300/(1+i)^2 + $59,200/(1+i)^3

Using financial calculator, i = 19.05%

IRR = 19.05%

Project D:

Let IRR be i%

NPV = -$180,600 + $100,400/(1+i) + $80,100/(1+i)^2 + $60,200/(1+i)^3
0 = -$180,600 + $100,400/(1+i) + $80,100/(1+i)^2 + $60,200/(1+i)^3

Using financial calculator, i = 17.49%

IRR = 17.49%

Cost of Capital is 14.3%. So, all projects are acceptable except Project A.

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.