||Present Value of an annuity due.
||Annual annuity payment
||Annual rate of interest
||Number of years
||negative 3,240.93 dollars
|Entry in Cell B5 is equal to sign PV(B3,B4,B2,0,1). The minus sign appears before the 3,240.93 dollars in B5 because the annuity's present value is a cost and therefore 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.