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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
