||Present Value of a Single Amount
||Annual rate of interest
||Number of years
|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.