hw20_21sol

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

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

View Full Document Right Arrow Icon
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
Background image of page 1
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

This note was uploaded on 07/09/2011 for the course ACG 2071 taught by Professor Tanner during the Spring '11 term at UNF.

Ask a homework question - tutors are online