MAT211SP16_HW1.2 - (c)2015 Second Wind Productions LLC You...

This preview shows page 1 - 4 out of 14 pages.

(c)2015 Second Wind Productions, LLC (c)2015 Second Wind Productions, LLC Project A Project B Project C $50,000 $45,000 $60,000 Pr($) $ (Return) $Pr($) Pr($) $ (Return) $Pr($) Pr($) $ (Return) 25% $33,500 5% $0 $0 4% $35,000 25% $49,900 20% $22,500 $4,500 22% $52,750 25% $56,500 35% $45,000 $15,750 48% $64,000 25% $65,600 25% $67,500 $16,875 17% $72,500 15% $73,000 $10,950 8% $83,000 100.4% 100.0% $48,075 99.0% STOP STOP ROI ROI 1.068333 ROI IRR IRR 6.8% IRR B REMEMBER: Start by summing Pr($) CAUTION: These projects have You have, at most, $65,000 to invest in just one of 5 possible projects defined below; based strictly on IRR (see P S = Selected Project Letter = DO NOT TAKE ANY SHORT CUTS! DO NOT COPY FROM DISTRIBUTION TO DISTRIBUTION!
Image of page 1

Subscribe to view the full document.

(c)2015 Second Wind Productions, LLC (c)2015 Second Wind Productions, LLC Project D Project E $40,000 $50,000 $Pr($) Pr($) $ (Return) $Pr($) Pr($) $ (Return) $Pr($) 5% $20,000 $1,000 25% $33,500 20% $25,000 $5,000 25% $49,900 50% $42,750 $21,375 25% $56,500 20% $47,500 $9,500 25% $65,600 5% $52,000 $2,600 100.0% $39,475 99.9% STOP ROI 0.986875 ROI IRR -1.3% IRR e more probabilities! PA for formatting), in which project do you invest (define by letter only in Cell F19)?
Image of page 2
(c)2015 Second Wind Productions, LLC (c)2015 Second Wind Productions, LLC 0.3596 0.6404 0.2684 Pass Maybe 0.2684 Pass Maybe caution! < 21 0.3942 Pass ¯ Fill in these overall probabilities after you fill in the dec Make sure to keep the SAME formatting in these 10 ce Pr( Pass Overall ) = Format - the same ¯ as in the data tables ® Pr( Fail Overall ) = < 19 < 19 Fill in this tier's branch probabilities by using the SUM macro for the appropriate probabilities along Column M. Fill in this tier's branch probabilities by using the SUM macro for the appropriate probabilities along Column S.
Image of page 3

Subscribe to view the full document.

Image of page 4
  • Fall '08
  • SEAL
  • Second Wind Productions, Wind Productions

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern