In: Finance
| 
 our company is deciding whether to invest in a new machine. The new machine will increase cash flow by $329,000 per year. You believe the technology used in the machine has a 10-year life; in other words, no matter when you purchase the machine, it will be obsolete 10 years from today. The machine is currently priced at $1,700,000. The cost of the machine will decline by $100,000 per year until it reaches $1,200,000, where it will remain.  | 
| 
 If your required return is 14 percent, calculate the NPV today. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)  | 
| 
 NPV  | 
 $  | 
| 
 If your required return is 14 percent, calculate the NPV for the following years. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. A negative answer should be indicated by a minus sign.)  | 
| 
 
  | 
|
| 
 Year 1  | 
 $  | 
| 
 Year 2  | 
 $  | 
| 
 Year 3  | 
 $  | 
| 
 Year 4  | 
 $  | 
| 
 Year 5  | 
 $  | 
| 
 Year 6  | 
 $  | 
| 
 Should you purchase the machine?  | 
| 
 Yes No  | 
| 
 If so, when should you purchase it?  | 
| 
 Today One year from now Two years from now  | 
Answer :-
(i) NPV today = 16102.05
(i) NPV subsequent years =
| 
 Year 1  | 
 $ 23996.78  | 
| 
 Year 2  | 
 $ 20149.45  | 
| 
 Year 3  | 
 $ 7325  | 
| 
 Year 4  | 
 $ -12213.66  | 
| 
 Year 5  | 
 $ -36624  | 
| 
 Year 6  | 
 $ -109973.42  | 
(iii) Yes, we should purchase the machine as it has positive NPV.
(iv) It should be purchased in One year from Now.
Calculation :
| Year of Machine Purchase | Cost of machine | Cash flow benefit for number of years (Total life - Year of machine purchase) | PVAF for the number of years benefit @ 14% | Total PV of cash benefits (329,000 x PVAF) | NPV (Present value of benefits -Cost of machine) | PV factor @ 14% (Using Table) | Present Value of all NPV | 
| 0 | 1700000 | 10 | 5.216115646 | 17,16,102.05 | 16102.05 | 1 | 160102.05 | 
| 1 | 1600000 | 9 | 4.946371837 | 16,27,356.33 | 27356.33 | 0.8771929568 | 23996.78 | 
| 2 | 1500000 | 8 | 4.638863894 | 15,26,186.22 | 26186.22 | 0.76946768185 | 20149.45 | 
| 3 | 1400000 | 7 | 4.288304839 | 14,10,852.29 | 10852.29 | 0.67497274768 | 7325 | 
| 4 | 1300000 | 6 | 3.888667517 | 12,79,371.61 | -20628.39 | 0.5920801381 | -12213.66 | 
| 5 | 1200000 | 5 | 3.433080969 | 11,29,483.64 | -70516.36 | 0.51936883866 | -36624 | 
| 6 | 1200000 | 4 | 2.913712304 | 9,58,611.35 | -241388.65 | 0.45558654062 | -109973.42 |