|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.