Long description

A B
1 Solving for the Years of a Single Amount Investment
2 Present value negative 1,000 dollars
3 Annual rate of interest 8 percent
4 Future value 2500 dollars
5 Number of years 11.9

Entry in Cell B5 is equal to sign NPER(B3,0,B2,B4,0).

The minus sign appears before the 1,000 dollars in B2 because we treat the initial deposit as 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.