Answered You can buy a ready-made answer or pick a professional tutor to order an original one.

QUESTION

Sky Fly, Inc is a fast growing drone manufacturer. The annual rate of return of Sky Fly's stock has been 20% over the past few years. Company managers believe 20% is a good estimate for the firms' cos

Sky Fly, Inc is a fast growing drone manufacturer. The annual rate of return of Sky Fly's stock has been 20% over the past few years. Company managers believe 20% is a good estimate for the firms' cost of capital. Sky Fly's CEO, Dane Cooper, believes the company needs to continue to invest in projects that offer the highest possible returns. Currently, the company is reviewing two separate projects. Project E involves expanding production capacity. Project I involves introducing one of the firms' drones into a new market. The following table shows the projected cash flows for each project.Year E I0 -3,500,00 -500,0001 1,500,000 250,0002 2,000,000 350,0003 2,500,000 375,0004 2,750,000 425,000Calculate the NPV, IRR, and PI for both projects.Rank the projects based on their NPV, IRR, and PI.The firm can only afford to take on one investment. Which project will the CEO likely favor?What do you think the company should do?

Show more
  • @
ANSWER

Tutor has posted answer for $20.00. See answer's preview

$20.00

*** ** *** *************** ***** *************** **** -3500000 ******* 2000000 2500000 ********** *************** 100000 ****** 069444 ****** ********** **** flow -3500000 ******* ******* ******* ******* ************** ***** *************** **** ******* ****** 350000 ****** ********* *************** 100000 083333 ****** ****** ********** **** **** ******* ****** 243056 ****** 204958 ********* of the ************ discount *** ******* * with rwo ******** **** 43% ***** 44%Year (n)01234NPVCash flow ******** 1500000 ******* ******* ********** *************** ****** ****** 048902 ****** 023914Disc **** **** ******** 1048951 ****** ****** ****** ******** *************** ****** ****** ****** ****** ********** **** **** ******** 1041667 ****** 837245 ****** ********* ** ******* ********************************************************* formula ** ********* ************************** discount the ******* * with *** ******** rate *** & ******* *************** flow ******* ****** ****** 375000 ********* *************** 100000 065789 043283 ****** 018734Disc **** **** ******* ****** ****** ****** ***** ******* fac=1/(1+53%)^n ****** ****** 042719 027921 ********** **** **** -500000 ****** ****** 104702 ***** ******** ** project I=(52+(2364/(2364+4826))*(53-52))/10005233or5233%Excel formula ** ********* *********************************** ************ to profiability ****************** outflow)/Initial ********* ** ******* *************************** ***** ** ******* ************************ ******************** * having ******* NPV ** ******* E is preferredIRRProject * have highest *** so ******* * ** *********************** indexProject I **** highest ************* ***** so project * ** ************** ******* is not the ********** **** ******* ****** ** ** *** *** ans ****** ****** * ********* go ** *** ************* ***** and accept ******* *** **** ** *** ***** ** assumption that ******** ******* will **** ** ********** at *** **** ***** ********* ***** **********

Click here to download attached files: skyfly.xlsx
or Buy custom answer
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question