hw20_21sol

# hw20_21sol - 56000 56000 56000 56000 71000 C05 = 56,00...

This preview shows page 1. Sign up to view the full content.

Problem 20 Problem 21 A. CF0 C01 C02 C03 C04 BAII plus data -47000 3050 19100 16800 16800 NPV = \$(1,907) NPV = =NPV(0.0782,D7:G7)+C7 IRR = 6.23% IRR = =IRR(C7:G7) B. CF0 C01 C02 C03 C04 C05 BAII plus data -41000 9700 9700 9700 9700 12500 C05 = 9,700 + 2,800 = 12,500 NPV = \$(2,774) NPV = =NPV(0.1028,D16:H16)+C16 IRR = 7.67% IRR = =IRR(C6:H16) C. CF0 C01 C02 C03 C04 C05 C06 C07 BAII plus data -310000 30000 54000
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 56000 56000 56000 56000 71000 C05 = 56,00 + `5,000 = 71,000 NPV = \$(41,051) NPV = =NPV(0.0855,D27:M27)+C27 IRR = 4.85% IRR = =IRR(C27:M27) D. CF0 C01 C02 C03 C04 C05 C06 BAII plus data-90000 16800 17472 ### ### ### ### NPV = \$(3,541) NPV = =NPV(0.075,D39:K39)+C39 IRR = 6.25% IRR = =IRR(C39:K39)...
View Full Document

{[ snackBarMessage ]}

### What students are saying

• 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.

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

• 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.

Dana University of Pennsylvania ‘17, Course Hero Intern

• 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.

Jill Tulane University ‘16, Course Hero Intern