Long description

A B
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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.