||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 the O’Reilly learning platform.
O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.