In: Finance
Blossom Corp. management is investigating two computer systems. The Alpha 8300 costs $2,448,125 and will generate cost savings of $1,253,325 in each of the next five years. The Beta 2100 system costs $3,387,500 and will produce cost savings of $921,750 in the first three years and then $2 million for the next two years. The company’s discount rate for similar projects is 14 percent. What is the NPV of each system? (Enter negative amounts using negative sign, e.g. -45.25. Do not round discount factors. Round other intermediate calculations and final answer to 0 decimal places, e.g. 1,525.) NPV of Alpha system
Net Present Value (NPV) of Alpha System
Year |
Annual Cash Flow ($) |
Present Value factor at 14% |
Present Value of Cash Flow ($) |
1 |
12,53,325 |
0.877193 |
10,99,408 |
2 |
12,53,325 |
0.769468 |
9,64,393 |
3 |
12,53,325 |
0.674972 |
8,45,959 |
4 |
12,53,325 |
0.592080 |
7,42,069 |
5 |
12,53,325 |
0.519369 |
6,50,938 |
TOTAL |
4,302,766 |
||
Net Present Value (NPV) = Present Value of annual cash inflows – Initial Investment
= $4,302,766 - $2,448,125
= $1,854,641
Net Present Value (NPV) of Beta System
Year |
Annual Cash Flow ($) |
Present Value factor at 14% |
Present Value of Cash Flow ($) |
1 |
9,21,750 |
0.877193 |
8,08,553 |
2 |
9,21,750 |
0.769468 |
7,09,257 |
3 |
9,21,750 |
0.674972 |
6,22,155 |
4 |
20,00,000 |
0.592080 |
11,84,161 |
5 |
20,00,000 |
0.519369 |
10,38,737 |
TOTAL |
4,362,862 |
||
Net Present Value (NPV) = Present Value of annual cash inflows – Initial Investment
= $4,362,862 - $3,387,500
= $975,362
NOTE
The formula for calculating the Present Value Inflow Factor (PVIF) is [1 / (1 + r)n], where “r” is the Discount Rate/Cost of capital and “n” is the number of years.