Botany Bay, Inc., a maker of casual clothing, is considering four projects shown
ID: 1176102 • Letter: B
Question
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 NPV, with rankings of capital at 14.2%. a. Calculate the NPV of each project, using a cost of capital of 142%. 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 acceptablc. a. Calculate the NPV of each project, using a cost of capital of 14.2% Data Table The NFV of project A is sRound to the noarest cent Round to lhe nearest cent.) [Click on the icon located on the top-righl corner of the data table below in arder to copy its contents into a spreadsheet.) Project C $80,700 Project D $180,100 Project A Project B | ? 1? .. 1.1 Initial investment (CF0) Year (t S49.600 Cash inflows (CFt $19,900 $39,200 $59,800 $99,700 $80,500 $59,200 Enter your answer in the answer box and then click Check Answer $19,900 s35.400 $19.900 51.600 S50,100 $19,900 parts remainingExplanation / Answer
A, NPV= -CF0+CF1/(1+R)+CF2/(1+r)^2+CF3/(1+r)3
Project A=-49600+19900/1.142+19900/(1.142^2)+19900/(1.142^3)= -$3554.13
Project B=-99500+35400/1.142+51600/(1.142^2)+50100/(1.142^3)= $4702.54
Project C=-80700+19900/1.142+39200/(1.142^2)+59800/(1.142^3)= $6934.74
Project D=-180100+99700/1.142+80500/(1.142^2)+59200/(1.142^3)= $8677.09
B. Rank will be D , C, B and A as it is order of NPV
C IRR is the rate at which NPV =0
Project A=-49600+19900/(1+r)+19900/((1+r)^2)+19900/((1+r)^3)= 0, IRR =9.87%
Project B=-99500+35400/(1+r)+51600/((1+r)^2)+50100/((1+r)^3)= 0, IRR =16.84%
Project C=-80700+19900/(1+r)+39200/((1+r)^2)+59800/((1+r)^3)= 0, IRR =18.46%
Project D=-180100+99700/(1+r)+80500/((1+r)^2)+59200/((1+r)^3)= 0, IRR =17.33%
In order to accept all the projects highest cost of capital should be 9.86%
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.