Calculations of Present Value Factors
Calculation of PVF |
1 |
0.917431 |
2 |
0.84168 |
3 |
0.772183 |
4 |
0.708425 |
5 |
0.649931 |
6 |
0.596267 |
7 |
0.547034 |
Calculation of NPV of the new machine
|
Amount |
Year |
PVF |
Amount |
Present Value of Cash Outflows |
|
|
|
Purchase
Price |
$Â Â Â Â 2,450,000 |
0 |
1 |
$
2,450,000.00 |
Maintainence cost |
$Â Â Â Â Â Â Â Â Â 94,000 |
5 |
0.649931 |
$Â Â Â Â Â Â 61,093.55 |
|
|
|
|
|
Total |
|
|
|
$
2,511,093.55 |
|
|
|
|
|
Present Value of Cash Inflows |
|
|
|
|
Training
Costs |
$Â Â Â Â Â Â Â Â Â 85,000 |
0 |
1 |
$Â Â Â Â Â Â 85,000.00 |
Savings
in operating costs |
$Â Â Â Â Â Â Â 390,900 |
1 |
0.917431 |
$Â Â Â Â 358,623.85 |
|
$Â Â Â Â Â Â Â 399,800 |
2 |
0.84168 |
$Â Â Â Â 336,503.66 |
|
$Â Â Â Â Â Â Â 410,100 |
3 |
0.772183 |
$Â Â Â Â 316,672.45 |
|
$Â Â Â Â Â Â Â 425,400 |
4 |
0.708425 |
$Â Â Â Â 301,364.08 |
|
$Â Â Â Â Â Â Â 434,000 |
5 |
0.649931 |
$Â Â Â Â 282,070.22 |
|
$Â Â Â Â Â Â Â 434,900 |
6 |
0.596267 |
$Â Â Â Â 259,316.66 |
|
$Â Â Â Â Â Â Â 436,400 |
7 |
0.547034 |
$Â Â Â Â 238,725.74 |
Salvage
Value |
$Â Â Â Â Â Â Â 379,100 |
7 |
0.547034 |
$Â Â Â Â 207,380.68 |
|
|
|
|
|
|
|
|
|
|
Total |
|
|
|
$
2,385,657.35 |
|
|
|
|
|
Net Present Value |
|
|
|
$Â Â Â (125,436.20) |
But the company can sale the old machine for $ 240,438. Hence,
actual NPV comes out to be $ 240,438 - $ 125,436 = $ 115,002.
Hence, Hillsong should purchase the new machine to replace the
existing machine
Note- Sunk cost and Depreciation are to be ignored.