For option 2, here is the formula that would get you the present value of $1,000 annual payments for five years
=pv([discount rate], [number of payments], [payment amount], [future value if any], [1 for beginning of period payments; 2 fo end of period payments])
=PV(12%,5,-1000,0,1)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.