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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.