Time
Project 1 Project 2 Diff A_B Rate
Rate
0 ($200,000) ($200,000) 0 6.50%
NPV_A NPV_B
1% $109,788 $52,882
1 0 80,000 -80,000
2% $91,063 $46,111
2 0 60,000 -60,000
3% $73,699 $39,663
3 20,000 50,000 -30,000
4% $57,582 $33,519
4 30,000 30,000 0
5% $42,610 $27,658
5 40,000 10,000 30,000
6% $28,689 $22,062
6 60,000 10,000 50,000
7% $15,734 $16,715
7 80,000 10,000 70,000
8% $3,667 $11,602
8 100,000 10,000 90,000
9% ($7,581) $6,708
NPV $22,095.57 $19,359
10% ($18,075) $2,021
IRR 8% 10% 7%
11% ($27,872) ($2,472)
MRR 8% 8%
12% ($37,028) ($6,782)
13% ($45,589) ($10,920)
14% ($53,601) ($14,894)
15% ($61,105) ($18,714)
16% ($68,138) ($22,389)
17% ($74,734) ($25,926)
18% ($80,926) ($29,332)
19% ($86,741) ($32,615)
20% ($92,206) ($35,780)
