Long description

1 Present Value of a Single Amount
2 Future value 1,700 dollars
3 Annual rate of interest 4 percent
4 Number of years 8
5 Present value Negative 1,242.17
Entry in Cell B5 is equal to sign PV(B3,B4,0,B2,0). The minus sign appears before the 1,242.17 dollars in B5 because the cost of the investment is treated as a cash outflow.

Get Principles of Managerial Finance, 15th Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.