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 the O’Reilly learning platform.

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