NPV & IRR:
Find the NPV (assume 8% just to calculate NPV initially) &
IRR of these projects. When would you choose one over the other
(i.e. what is the crossover rate)? Draw the NPV profile using 11
intervals of interest rates ranging from (and including) 0% to
100%. Place all data, ratios, calculations, findings, etc. in the
first Excel sheet with references to the information in other
sheets.
Time
A CF
B CF
0
-10000
-10000
1
12000
9000...