In: Finance
| 
 Year /Projects  | 
 A (cash flow)  | 
 B (cash flow)  | 
 C (cash flow)  | 
| 
 0  | 
 -$42,000  | 
 -$65,000  | 
 -$100,500  | 
| 
 1  | 
 12,000  | 
 10,000  | 
 30,000  | 
| 
 2  | 
 12,000  | 
 20,000  | 
 30,000  | 
| 
 3  | 
 12,000  | 
 30,000  | 
 30,000  | 
| 
 4  | 
 12,000  | 
 40,000  | 
 30,000  | 
| 
 5  | 
 12,000  | 
 ---  | 
 30,000  | 
| 
 6  | 
 12,000  | 
 ---  | 
 ---  | 
NPV(A) = ; NPV(B)= ; NPV(C)= ; Accept Project ( );
A-NPV(A) = ; A-NPV(B)= ; A-NPV(C)= ; Accept Project ( );
NPV = Present value of Cash Inflows - Present value of cash outlflows
Project A:
| Present value at 12% | |||
| Present value factor (1/(1+rate)^n | Present value factor | Cash flows | Present value of cash flows | 
| 1/(1.12) | 0.892857143 | 12000 | 10714.28571 | 
| 1/(1.12)^2 | 0.797193878 | 12000 | 9566.326531 | 
| 1/(1.12)^3 | 0.711780248 | 12000 | 8541.362974 | 
| 1/(1.12)^4 | 0.635518078 | 12000 | 7626.216941 | 
| 1/(1.12)^5 | 0.567426856 | 12000 | 6809.122269 | 
| 1/(1.12)^6 | 0.506631121 | 12000 | 6079.573454 | 
| 4.114 | Total Cash Inflow (A) | 49336.88788 | |
| Present value of cash outflows (B) | 42000 | ||
| NPV (A-B) | 7336.887882 | 
Project B :
| Present value at 12% | |||
| Present value factor (1/(1+rate)^n | Present value factor | Cash flows | Present value of cash flows | 
| 1/(1.12) | 0.892857143 | 10000 | 8928.571429 | 
| 1/(1.12)^2 | 0.797193878 | 20000 | 15943.87755 | 
| 1/(1.12)^3 | 0.711780248 | 30000 | 21353.40743 | 
| 1/(1.12)^4 | 0.635518078 | 40000 | 25420.72314 | 
| Present value annuity factor | 3.0373 | Total Cash Inflow (A) | 71646.57955 | 
| Present value of cash outflows (B) | 65000 | ||
| NPV (A-B) | 6646.57955 | 
Project C.
| Present value at 12% | |||
| Present value factor (1/(1+rate)^n | Present value factor | Cash flows | Present value of cash flows | 
| 1/(1.12) | 0.892857143 | 30000 | 26785.71429 | 
| 1/(1.12)^2 | 0.797193878 | 30000 | 23915.81633 | 
| 1/(1.12)^3 | 0.711780248 | 30000 | 21353.40743 | 
| 1/(1.12)^4 | 0.635518078 | 30000 | 19065.54235 | 
| 1/(1.12)^5 | 0.567426856 | 30000 | 17022.80567 | 
| 3.6047 | Total Cash Inflow (A) | 108143.2861 | |
| Present value of cash outflows (B) | 100500 | ||
| NPV (A-B) | 7643.28607 | 
NPV of project A = 7336.88
project B = 6646.58
Project C = 7643.28
Accept project C
Annualized NPV = NPV / Present value annuity factor ( 12% , number of years)
Project A = 7336.88 / 4.114 ( 4.114 from table 1 )
= $ 1783.39
Project B = 6446.58 / 3.0373 (3.0373 from table 2)
= $ 2122.4706
Project C = 7643.286 / 3.6047
= $ 2120.366
Amoung above three project B has more annualized NPV. which is preferrable.