Long description

1 Future Value of an annuity due.
2 Annual annuity payment negative 1,000 dollars
3 Annual rate of interest 7 percent
4 Number of years 5
5 Future value 6,153.29 dollars
Entry in Cell B5 is equal to sign FV(B3,B4,B2,0,1). The minus sign appears before the 1,000 dollars in B2 because the annuity's payments are cash outflows.

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.