fm3_chapter30 - UN-19J 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15...

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

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: UN-19J 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 A CF1 Growth rate Discount rate Year Cash flow NPV IRR B 234 10% 15% 0 -1150.00 C D E F G H I J K 1 234.00 2 257.40 3 283.14 4 311.45 5 342.60 6 376.86 7 414.55 101.46 <-- =+B6+NPV(B3,C6:I6) 17.60% <-- =IRR(B6:I6,0) ### NPV Growth rate ### 101.46 0 5% 10% 15% Discount rate 7% 10% 111.09 -10.79 297.62 150.74 515.79 339.09 770.34 558.25 12% -82.08 65.13 236.44 435.41 0 5% 10% 15% -176.46 -47.82 101.46 274.35 IRR 9.71% 13.67% 17.60% 21.50% ### Growth rate ...
View Full Document

This note was uploaded on 01/23/2011 for the course FGB 780 taught by Professor Edwardchang during the Spring '09 term at Missouri State University-Springfield.

Ask a homework question - tutors are online