dentonblake
Board Regular
- Joined
- Jun 8, 2004
- Messages
- 160
Is there a formula in excel that will calculate the exact payback period for an investment, and a series of cash flows, for example:
Year 0: -275,000 (initial investment)
Year 1: 125,000
Year 2: 125,000
Year 3: 145,000
Year 4: 145,000
I know I will get the payback in year 3, but would like a more exact figure like 3.17 and/or in years and weeks/days...
Appreciate your help! db
Year 0: -275,000 (initial investment)
Year 1: 125,000
Year 2: 125,000
Year 3: 145,000
Year 4: 145,000
I know I will get the payback in year 3, but would like a more exact figure like 3.17 and/or in years and weeks/days...
Appreciate your help! db