The net present value NPV of the project is round to the ne

nt valbe (NPV) of the project is sI(Round to the nearest cent.) Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) $410,000 Initial investment (CF Year () Cash inflows (CF $80,000 $80,000 $80,000 $80,000 $80,000 $30,000 $30,000 $80,000 $80,000 $80,000 4 10 Done

Solution

Year Cash flow PVF@16% Present value 0 $ (410,000) 1.000 $      (410,000.00) 1 $      80,000 0.862 $           68,965.52 2 $      80,000 0.743 $           59,453.03 3 $      80,000 0.641 $           51,252.61 4 $      80,000 0.552 $           44,183.29 5 $      80,000 0.476 $           38,089.04 6 $      80,000 0.410 $           32,835.38 7 $      80,000 0.354 $           28,306.36 8 $      80,000 0.305 $           24,402.04 9 $      80,000 0.263 $           21,036.24 10 $      80,000 0.227 $           18,134.69 Net present value $         (23,341.80) Project should not be accepted.