In_class_spreadsheet_November_16_2006

In_class_spreadsheet_November_16_2006 - This method is...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
16% Time Pmt PV 0 -120000 -120000 33,532 1 52500 45258.62 2 52500 39016.05 3 52500 33634.53 4 64500 35622.78 33531.98 NPV 28.997% IRR
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Time Pmt 0 (130,000) 2.6902% 1 15,000 2 15,000 3 15,000 4 15,000 5 15,000 6 15,000 7 15,000 8 15,000 9 15,000 10 15,000
Background image of page 2
0.12 Time Pmt PV 0 -10000 -10000 ($5,812.12) NPV done correctly 1 1500 1339.29 ($5,189.39) NPV done incorrectly 2 1250 996.49 3 1000 711.78 4 750 476.64 5 500 283.71 6 750 379.97 ($5,812.12) NPV done using direct calculation
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: This method is recommended. 14% Time Pmt PV-63270-63270 1 20000 17543.86 2 30000 23084.03 3 50000 33748.58 $11,106.46 NPV Positive, so YES 22.721% IRR 16% Time Pmt PV-120000-120000 33,532 1 52500 45258.62 2 52500 39016.05 3 52500 33634.53 4 64500 35622.78 $33,531.98 NPV 28.997% IRR...
View Full Document

This note was uploaded on 04/05/2009 for the course ORIE 350 taught by Professor Callister during the Summer '08 term at Cornell University (Engineering School).

Page1 / 5

In_class_spreadsheet_November_16_2006 - This method is...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online